using DIXWeb.DataRepository;
|
using DIXWeb.Entity.GlobalM;
|
using DIXWeb.Util;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace DIXWeb.Business.MySQLBiz
|
{
|
public class MySQLInspectBaseBiz:BaseBusiness<MySQLInspectBaseBiz>
|
{
|
public MySQLInspectBaseBiz() : base(DBConfigKeys.MySQLDIX, DatabaseType.MySql) { }
|
public ResultMessage ReCreateMaster()
|
{
|
var plist = new List<System.Data.Common.DbParameter>();
|
plist.Add(GlobalDataHelper.NewMySqlParameter("whatever", 1));
|
ResultMessage r = Service.SubmitDataByProc("yp_ReCreateMaster", plist);
|
return r;
|
}
|
public DataTable GetInspectedItems()
|
{
|
string sql = "SELECT * FROM dix.inspectiteminfo WHERE IsInspected=0;";
|
DataTable r = Service.GetDataTableWithSql(sql);
|
return r;
|
}
|
|
public DataTable GetImageItems()
|
{
|
string sql = " SELECT SN,ImgId,ImgString FROM dix.itemimg";
|
var table = Service.GetDataTableWithSql(sql);
|
return table;
|
}
|
|
public void UpdateInspectedItems()
|
{
|
try
|
{
|
string sql = "update dix.inspectiteminfo set IsInspected=1 where IsInspected=0;";
|
Service.ExecuteSql(sql);
|
UpdateInspectedjudge();
|
}
|
catch (Exception)
|
{
|
throw new Exception();
|
}
|
}
|
public void UpdateInspectedjudge()
|
{
|
try
|
{
|
string sql = "update dix.inspectjudge set IsInspected=1 where IsInspected=0;";
|
Service.ExecuteSql(sql);
|
}
|
catch (Exception)
|
{
|
throw new Exception();
|
}
|
}
|
public ResultMessage CompareFreqLimit(int objectid, int freqid)
|
{
|
var plist = new List<System.Data.Common.DbParameter>();
|
plist.Add(GlobalDataHelper.NewMySqlParameter("objectid", objectid));
|
plist.Add(GlobalDataHelper.NewMySqlParameter("freqid", freqid));
|
ResultMessage r = Service.SubmitDataByProc("yp_CompareFreqLimit", plist);
|
return r;
|
}
|
public List<ImageModel> GetImageDic(string sn)
|
{
|
List<ImageModel> myimagelist = new List<ImageModel>();
|
ImageModel myimage;
|
string sql = " SELECT ImgId,ImgString FROM dix.itemimg where SN='" + sn + "'";
|
var table = Service.GetDataTableWithSql(sql);
|
if (table != null || table.Rows.Count > 0)
|
{
|
for (int i = 0; i < table.Rows.Count; i++)
|
{
|
int id = Convert.ToInt32(table.Rows[i]["ImgId"].ToString());
|
string img = table.Rows[i]["ImgString"].ToString();
|
myimage = new ImageModel() { Id = id, SN = sn, ImgString = img };
|
myimagelist.Add(myimage);
|
}
|
}
|
return myimagelist;
|
}
|
}
|
}
|