| 提交 | 用户 | age | ||
| 4e8a53 | 1 | using DIXWeb.DataRepository; |
| edc224 | 2 | using DIXWeb.Entity.GlobalM; |
| 4e8a53 | 3 | using DIXWeb.Util; |
| J | 4 | using System; |
| 5 | using System.Collections.Generic; | |
| 6 | using System.Data; | |
| 7 | using System.Linq; | |
| 8 | using System.Text; | |
| 9 | using System.Threading.Tasks; | |
| 10 | ||
| 11 | namespace DIXWeb.Business.MySQLBiz | |
| 12 | { | |
| 13 | public class MySQLInspectBaseBiz:BaseBusiness<MySQLInspectBaseBiz> | |
| 14 | { | |
| 15 | public MySQLInspectBaseBiz() : base(DBConfigKeys.MySQLDIX, DatabaseType.MySql) { } | |
| 16 | public ResultMessage ReCreateMaster() | |
| 17 | { | |
| 18 | var plist = new List<System.Data.Common.DbParameter>(); | |
| 19 | plist.Add(GlobalDataHelper.NewMySqlParameter("whatever", 1)); | |
| 20 | ResultMessage r = Service.SubmitDataByProc("yp_ReCreateMaster", plist); | |
| 21 | return r; | |
| 22 | } | |
| 23 | public DataTable GetInspectedItems() | |
| 24 | { | |
| 25 | string sql = "SELECT * FROM dix.inspectiteminfo WHERE IsInspected=0;"; | |
| 26 | DataTable r = Service.GetDataTableWithSql(sql); | |
| 27 | return r; | |
| 28 | } | |
| 29 | ||
| edc224 | 30 | public DataTable GetImageItems() |
| J | 31 | { |
| 32 | string sql = " SELECT SN,ImgId,ImgString FROM dix.itemimg"; | |
| 33 | var table = Service.GetDataTableWithSql(sql); | |
| 34 | return table; | |
| 35 | } | |
| 36 | ||
| 4e8a53 | 37 | public void UpdateInspectedItems() |
| J | 38 | { |
| b347b1 | 39 | try |
| J | 40 | { |
| 41 | string sql = "update dix.inspectiteminfo set IsInspected=1 where IsInspected=0;"; | |
| 42 | Service.ExecuteSql(sql); | |
| 43 | UpdateInspectedjudge(); | |
| 44 | } | |
| 45 | catch (Exception) | |
| 46 | { | |
| 47 | throw new Exception(); | |
| 48 | } | |
| a70742 | 49 | } |
| J | 50 | public void UpdateInspectedjudge() |
| 51 | { | |
| b347b1 | 52 | try |
| J | 53 | { |
| 54 | string sql = "update dix.inspectjudge set IsInspected=1 where IsInspected=0;"; | |
| 55 | Service.ExecuteSql(sql); | |
| 56 | } | |
| 57 | catch (Exception) | |
| 58 | { | |
| 59 | throw new Exception(); | |
| 60 | } | |
| 4e8a53 | 61 | } |
| 1063f3 | 62 | public ResultMessage CompareFreqLimit(int objectid, int freqid) |
| J | 63 | { |
| 64 | var plist = new List<System.Data.Common.DbParameter>(); | |
| 65 | plist.Add(GlobalDataHelper.NewMySqlParameter("objectid", objectid)); | |
| 66 | plist.Add(GlobalDataHelper.NewMySqlParameter("freqid", freqid)); | |
| 67 | ResultMessage r = Service.SubmitDataByProc("yp_CompareFreqLimit", plist); | |
| 68 | return r; | |
| 69 | } | |
| edc224 | 70 | public List<ImageModel> GetImageDic(string sn) |
| J | 71 | { |
| 72 | List<ImageModel> myimagelist = new List<ImageModel>(); | |
| 73 | ImageModel myimage; | |
| f0ebb2 | 74 | string sql = " SELECT ImgId,ImgString FROM dix.itemimg where SN='" + sn + "'"; |
| edc224 | 75 | var table = Service.GetDataTableWithSql(sql); |
| J | 76 | if (table != null || table.Rows.Count > 0) |
| 77 | { | |
| 78 | for (int i = 0; i < table.Rows.Count; i++) | |
| 79 | { | |
| f0ebb2 | 80 | int id = Convert.ToInt32(table.Rows[i]["ImgId"].ToString()); |
| edc224 | 81 | string img = table.Rows[i]["ImgString"].ToString(); |
| J | 82 | myimage = new ImageModel() { Id = id, SN = sn, ImgString = img }; |
| 83 | myimagelist.Add(myimage); | |
| 84 | } | |
| 85 | } | |
| 86 | return myimagelist; | |
| 87 | } | |
| 4e8a53 | 88 | } |
| J | 89 | } |
