From 84d11937e57ca3d73fa58e123b14de02ad8e8d4e Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 03 十二月 2024 14:17:00 +0800
Subject: [PATCH] 1.仓库、库位、存货新增加字段noid
---
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