From 0910a653b936af52e97633c70f6d6dee3f3f5a2b Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期二, 21 十月 2025 16:55:55 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/BaseSet/Gy_SupplierController.cs | 29 ++++++++++++++++++++++++++++-
1 files changed, 28 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
index 253a980..f42be6b 100644
--- a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
@@ -481,10 +481,14 @@
{
var _value = msg["model"].ToString();
LogService.Write("1" + _value);
+ var entry = msg["model"]["HENTRY"].ToString();
+ LogService.Write("1" + _value);
+ LogService.Write("12" + entry);
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//鍙嶅簭鍒楀寲
_value = "[" + _value.ToString() + "]";
List<Supplier> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(_value);
+ List<Model.ClsGy_SupplierContact_Model> lssub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_SupplierContact_Model>>(entry);
string sql = string.Empty;
LogService.Write("2");
//淇濆瓨
@@ -524,9 +528,30 @@
",'" + lsmain[0].HEnglishAddress + "'," + lsmain[0].HCurID + "," + lsmain[0].HSSID + "," + lsmain[0].HAreaID +",'"+lsmain[0].HMaterClass+
"'," + lsmain[0].HItemID + ",'" + lsmain[0].HUseOrgID + "','" + lsmain[0].HCreateOrgID +
"') ");
- //淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
sql = "set identity_insert Gy_Supplier off";
oCN.RunProc(sql);
+ ///////////
+ foreach (var osub in lssub)
+ {
+ sql = " set identity_insert Gy_SupplierContact on";
+ oCN.RunProc(sql);
+ LogService.Write("寮�濮嬫彃鍏ヤ緵搴斿晢鑱旂郴浜�");
+ sql = $"delete from Gy_SupplierContact where HItemID = {osub.HItemID}";
+ oCN.RunProc(sql);
+ oCN.RunProc("insert into Gy_SupplierContact" +
+ "(HItemID,HNumber,HName,HShortNumber,HParentID,HLevel" +
+ ", HEndFlag, HStopflag, HRemark, HUseFlag, HIsDefault, HUSEORGID, HCREATEORGID) " +
+ " values('" + osub.HItemID + "','" + osub.HNumber + "','" + osub.HName + "'," + "'" + osub.HShortNumber + "'," + osub.HParentID + "," + osub.HLevel + ",'" + osub.HEndFlag + "','" + osub.HStopflag + "'" +
+ "," + "'" + osub.HRemark + "'" + ",'" + osub.HUseFlag + "','" + osub.HIsDefault + "'," + osub.HUSEORGID + "," + osub.HCREATEORGID +
+ ") ");
+ sql = "set identity_insert Gy_SupplierContact off";
+ oCN.RunProc(sql);
+ }
+
+ //淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
+
+
+ LogService.Write("鎻掑叆渚涘簲鍟嗚仈绯讳汉compelete");
oCN.Commit();
objJsonResult.code = "1";
@@ -537,6 +562,7 @@
}
catch (Exception e)
{
+ LogService.Write(e);
objJsonResult.code = "0";
objJsonResult.count = 0;
objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.ToString();
@@ -716,6 +742,7 @@
}
catch (Exception e)
{
+
oCN.RollBack();
objJsonResult.code = "0";
objJsonResult.count = 0;
--
Gitblit v1.9.1