From 47f5a9401f1e83efeca8b6a5cd28e1da805811f9 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 18 六月 2024 17:36:23 +0800
Subject: [PATCH] 1.设置文件上传大小 2.工艺SOP查看接口 3.工单SOP查看接口
---
VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 50 insertions(+), 0 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs b/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
index 004b993..ae4fc9d 100644
--- a/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
@@ -364,6 +364,31 @@
}
#endregion
+ #region[璁惧绫诲瀷缂栫爜鏌ユ壘璁惧淇℃伅]
+ public static ToMessage EqpTypecodeSeachEqpPermissions(string eqptypecode)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ sql = @"select code,name from TEqpInfo where enable='Y' and eqptype_code=@eqptypecode";
+ dynamicParams.Add("@eqptypecode", eqptypecode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
#region[浠撳簱鍩虹璧勬枡]
public static ToMessage WareHouse()
{
@@ -618,5 +643,30 @@
return mes;
}
#endregion
+
+ #region[鏌ヨ宸ュ崟/浜у搧鍩虹璧勬枡]
+ public static ToMessage WrkOrderDataSelect()
+ {
+ string sql = "";
+ try
+ {
+ sql = @"select P.wo_code,P.materiel_code,M.partname as materiel_name
+ from TK_Wrk_Man P
+ left join TMateriel_Info M on P.materiel_code=M.partcode";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
}
}
--
Gitblit v1.9.3