From cd23b00f03ac749e998a823a530f277772e734af Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 17 六月 2024 17:12:00 +0800
Subject: [PATCH] 1.设备清单查看SOP，获取SOP文件列表接口 2.报工反审核接口
---
VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs | 46 ++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 42 insertions(+), 4 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs b/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs
index 5917668..5740f43 100644
--- a/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/DeviceManagerDAL.cs
@@ -698,6 +698,44 @@
}
#endregion
+ #region[璁惧淇℃伅鏌ョ湅SOP]
+ public static ToMessage DeviceSopSearch(string eqptypecode, string eqpcode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鑾峰彇SOP鏂囦欢淇℃伅
+ sql = @"select filename,filepath,version from TDeviceSop
+ where eqptypecode=@eqptypecode and eqpcode=@eqpcode
+ order by version";
+ dynamicParams.Add("@eqptypecode", eqptypecode);
+ dynamicParams.Add("@eqpcode", eqpcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.message = "褰撳墠璁惧鏆傛棤SOP鏂囦欢!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
#region[璁惧鐐规椤瑰垪琛ㄦ煡璇
public static ToMessage DeviceCheckItemSearch(string checkitemcode, string checkitemname, string checkdescr, string isqrcode, string cycle, int startNum, int endNum, string prop, string order)
@@ -2571,7 +2609,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.message = "鍥剧墖涓婁紶澶辫触"+e.Message;
+ mes.message = "鍥剧墖涓婁紶澶辫触" + e.Message;
mes.data = null;
}
return mes;
@@ -2624,12 +2662,12 @@
// 杩欓噷鍙互璁板綍寮傚父鍒版棩蹇椾腑锛屼互渚垮悗缁垎鏋�
mes.code = "300";
mes.count = 0;
- mes.message = "鍒犻櫎鍥剧墖鏃跺彂鐢熼敊璇�:"+ ex.Message;
+ mes.message = "鍒犻櫎鍥剧墖鏃跺彂鐢熼敊璇�:" + ex.Message;
mes.data = null;
return mes;
}
}
-
+
#endregion
#region[璁惧缁翠慨鍒楄〃]
@@ -2693,7 +2731,7 @@
wxwo = wo[0].ToString(); //鑾峰彇鍗曞彿
numvalue = wo[1].ToString(); //鑾峰彇娴佹按鍙�
}
- if (model.groupimage1.Count > 0)
+ if (model.groupimage1.Count > 0)
{
for (int i = 0; i < model.groupimage1.Count; i++)
{
--
Gitblit v1.9.3