From cbeb997178132c5c71d57b5011847f7d6e21930a Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 08 十一月 2024 15:58:55 +0800
Subject: [PATCH] 1.入库记录删除 2.畅捷通T+反写产成品入库单(直接写表) 3.erp同步基础资料和订单改为根据配置取T+或者T8 4.通用基础资料仓库资料放出erpid 5.生产入库查询信息接口调整字段(T+和T8共用)
---
VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs | 61 ++++++++++++++++++++++++++++--
1 files changed, 56 insertions(+), 5 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs b/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
index 8389c8a..75f5989 100644
--- a/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/ErpSyncMesDAL.cs
@@ -18,6 +18,7 @@
public static string strProcName = ""; //瀹氫箟鍏ㄥ眬sql鍙橀噺
public static List<SqlParameter> listStr = new List<SqlParameter>(); //瀹氫箟鍏ㄥ眬鍙傛暟闆嗗悎
public static SqlParameter[] parameters; //瀹氫箟鍏ㄥ眬SqlParameter鍙傛暟鏁扮粍
+ public static string ErpPath = AppSetting.GetAppSetting("ErpPath"); //鑾峰彇ERP閰嶇疆
#region[鐗╂枡绠＄悊锛氳閲忓崟浣嶅悓姝
public static ToMessage SaveSearchUnit(User us)
@@ -27,7 +28,17 @@
try
{
//瀛樺偍杩囩▼鍚�
- sql = @"h_p_IFCLD_T8ERPUnit";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"h_p_IFCLD_TCloundERPUnit";
+ break;
+ case "T8":
+ sql = @"h_p_IFCLD_T8ERPUnit";
+ break;
+ default:
+ break;
+ }
dynamicParams.Add("@username", us.usercode);
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
if (a)
@@ -64,7 +75,17 @@
try
{
//瀛樺偍杩囩▼鍚�
- sql = @"h_p_IFCLD_T8ERPInventory";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"h_p_IFCLD_TCloundERPInventory";
+ break;
+ case "T8":
+ sql = @"h_p_IFCLD_T8ERPInventory";
+ break;
+ default:
+ break;
+ }
dynamicParams.Add("@username", us.usercode);
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
if (a)
@@ -101,7 +122,17 @@
try
{
//瀛樺偍杩囩▼鍚�
- sql = @"h_p_IFCLD_T8ERPWhareHousesLocation";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"h_p_IFCLD_TCloundERPWhareHousesLocation";
+ break;
+ case "T8":
+ sql = @"h_p_IFCLD_T8ERPWhareHousesLocation";
+ break;
+ default:
+ break;
+ }
dynamicParams.Add("@username", us.usercode);
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
if (a)
@@ -138,7 +169,17 @@
try
{
//瀛樺偍杩囩▼鍚�
- sql = @"h_p_IFCLD_T8ERPPartner";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"h_p_IFCLD_TCloundERPPartner";
+ break;
+ case "T8":
+ sql = @"h_p_IFCLD_T8ERPPartner";
+ break;
+ default:
+ break;
+ }
dynamicParams.Add("@username", us.usercode);
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
if (a)
@@ -175,7 +216,17 @@
try
{
//瀛樺偍杩囩▼鍚�
- sql = @"h_p_IFCLD_T8ERPMO";
+ switch (ErpPath)
+ {
+ case "T+":
+ sql = @"h_p_IFCLD_TCloundERPMO";
+ break;
+ case "T8":
+ sql = @"h_p_IFCLD_T8ERPMO";
+ break;
+ default:
+ break;
+ }
dynamicParams.Add("@username", us.usercode);
bool a = DapperHelper.IsProcedure(sql, dynamicParams);
if (a)
--
Gitblit v1.9.3