From 48aa43a04f8d8a0964d9d8a206e329f400fd5b89 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 07 八月 2023 18:10:04 +0800
Subject: [PATCH] 1.移出班组功能，单独关联人员 2.用户清单取消指定班组 3.生产开报工增加扫码后选择设备 4.用户清单导入取消班组 5.erp订单查询、订单下达 mes工单查询、报废补单增加销售订单号
---
VueWebApi/DLL/DAL/ErpSyncMesDAL.cs | 131 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 129 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs b/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
index 94f4db8..5ddf6cc 100644
--- a/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
+++ b/VueWebApi/DLL/DAL/ErpSyncMesDAL.cs
@@ -11,8 +11,45 @@
{
public static ToMessage mes = new ToMessage(); //瀹氫箟鍏ㄥ眬杩斿洖淇℃伅瀵硅薄
+ #region[鍒堕�犳ā鍨嬶細鍗曚綅鍚屾]
+ public static ToMessage SeaveSearchUnit(string username)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPUnit";
+ dynamicParams.Add("@username", username);
+ bool a = DapperHelper.IsProcedure(sql, dynamicParams);
+ if (a)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍚屾鍗曚綅鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍚屾鍗曚綅澶辫触!";
+ 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 SeaveSearchInventoryClass(string username)
+ public static ToMessage SeaveSearchInventoryClass()
{
var sql = "";
var dynamicParams = new DynamicParameters();
@@ -20,7 +57,7 @@
{
//瀛樺偍杩囩▼鍚�
sql = @"h_p_IFCLD_ERPInventory_Class";
- bool a = DapperHelper.IsProcedure(sql, dynamicParams);
+ bool a = DapperHelper.IsProcedureNo(sql);
if (a)
{
mes.code = "200";
@@ -157,5 +194,95 @@
return mes;
}
#endregion
+
+ #region[鐢熶骇绠＄悊锛氱敓浜ц鍗曞悓姝
+ public static ToMessage SeaveSearchErpOrder(string stu_torgcode,string stu_torgtypecode)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ if (stu_torgcode == "" || stu_torgcode == null)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "绠＄悊鍛樿处鍙锋棤鎿嶄綔鏉冮檺,璇蜂娇鐢ㄨ溅闂寸骇璐﹀彿!";
+ mes.data = null;
+ return mes;
+ }
+ if (stu_torgtypecode == "D")
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "閮ㄩ棬璐﹀彿鏃犳搷浣滄潈闄�,璇蜂娇鐢ㄨ溅闂寸骇璐﹀彿!";
+ mes.data = null;
+ return mes;
+ }
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPMO";
+ dynamicParams.Add("@stu_torgcode", stu_torgcode);
+ dynamicParams.Add("@stu_torgtypecode", stu_torgtypecode);
+ bool a = DapperHelper.IsProcedure(sql, dynamicParams);
+ if (a)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍚屾鐢熶骇璁㈠崟鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍚屾鐢熶骇璁㈠崟澶辫触!";
+ 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 SeaveSearchErpPurchaseOrder()
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPPurchaseOrder";
+ bool a = DapperHelper.IsProcedureNo(sql);
+ if (a)
+ {
+ mes.code = "200";
+ mes.count = 0;
+ mes.Message = "鍚屾閲囪喘璁㈠崟鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "鍚屾閲囪喘璁㈠崟澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.3