From 54bfe544f50d0933ebc27583decb9ab61e01146f Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 14 六月 2024 16:05:16 +0800
Subject: [PATCH] 1.SOP管理，工单SOP功能接口开发
---
VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs | 25 +++++++++++++++++++++++++
1 files changed, 25 insertions(+), 0 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs b/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
index 26d0d40..ae4fc9d 100644
--- a/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/GeneralBasicDataDAL.cs
@@ -643,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