From 7ff74f599084561338eef1230db5aa45f74565f8 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 15 四月 2024 18:03:33 +0800
Subject: [PATCH] 1.ERP订单关闭增加单据id 2.MES工单关闭增加源单id关联
---
VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs | 94 ++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 84 insertions(+), 10 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs b/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
index 43e51a9..bb8b2f1 100644
--- a/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
@@ -34,14 +34,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鍚屾璁￠噺鍗曚綅鎴愬姛!";
+ mes.message = "鍚屾璁￠噺鍗曚綅鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍚屾璁￠噺鍗曚綅澶辫触!";
+ mes.message = "鍚屾璁￠噺鍗曚綅澶辫触!";
mes.data = null;
}
}
@@ -49,7 +49,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -71,14 +71,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鍚屾瀛樿揣妗ｆ鎴愬姛!";
+ mes.message = "鍚屾瀛樿揣妗ｆ鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍚屾瀛樿揣妗ｆ澶辫触!";
+ mes.message = "鍚屾瀛樿揣妗ｆ澶辫触!";
mes.data = null;
}
}
@@ -86,14 +86,14 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
}
#endregion
- #region[鐗╂枡绠＄悊锛氫粨搴撳悓姝
+ #region[鍩虹璁剧疆锛氫粨搴撳悓姝
public static ToMessage SaveSearchWareHouse(User us)
{
var sql = "";
@@ -108,14 +108,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鍚屾浠撳簱鎴愬姛!";
+ mes.message = "鍚屾浠撳簱鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍚屾浠撳簱澶辫触!";
+ mes.message = "鍚屾浠撳簱澶辫触!";
mes.data = null;
}
}
@@ -123,7 +123,81 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[鍩虹璁剧疆锛氬線鏉ュ崟浣嶅悓姝
+ public static ToMessage SeaveSearchPartner(User us)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPPartner";
+ dynamicParams.Add("@username", us.usercode);
+ 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[鐢熶骇绠＄悊锛欵RP鐢熶骇璁㈠崟鍚屾]
+ public static ToMessage SeaveSearchErpOrder(User us)
+ {
+ var sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //瀛樺偍杩囩▼鍚�
+ sql = @"h_p_IFCLD_ERPMO";
+ dynamicParams.Add("@username", us.usercode);
+ 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;
--
Gitblit v1.9.3