From 90b8b9b16b9b91669c82fda653167f9dc99889d0 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 12 三月 2025 14:30:07 +0800
Subject: [PATCH] 供应商：增加联系人 子表
---
WebAPI/Controllers/BaseSet/Gy_SupplierController.cs | 45 ++++++++++++++++++++++++++++++++++++++-------
1 files changed, 38 insertions(+), 7 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
index 240b2f4..f67fd55 100644
--- a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
@@ -261,8 +261,10 @@
string sql = string.Format(@"select * from h_v_Gy_SupplierEdit where HItemID='" + HInterID + "'");
ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierEdit");
DataSet cs = oCN.RunProcReturn("select * from Gy_Supplier_PayPlan where HSupID = '"+ HInterID + "'", "Gy_Supplier_PayPlan");
+ DataSet cs1 = oCN.RunProcReturn("select * from Gy_Supplier_Link where HSupID = '" + HInterID + "'", "Gy_Supplier_Link");
List<Object> list = new List<object>();
list.Add(cs);
+ list.Add(cs1);
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "";
@@ -297,6 +299,7 @@
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
string msg2 = sArray[0].ToString(); //涓昏〃鏁版嵁
string msg3 = sArray[1].ToString(); //瀛愯〃鏁版嵁
+ string msg4 = sArray[2].ToString(); //瀛愯〃鏁版嵁
//涓昏〃鍙嶅簭鍒楀寲
msg2 = "[" + msg2.ToString() + "]";
@@ -370,20 +373,34 @@
"') ");
//淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
oCN.RunProc("Update Gy_Supplier set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
- //瀛愯〃娣诲姞
- List<ClsGy_Supplier_PayPlan> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_Supplier_PayPlan>>(msg3);
- int i = 0;
+
+ //鍒犻櫎瀛愯〃鎿嶄綔 闃叉鍑洪敊
DataSet Cs;
Cs = oCN.RunProcReturn("select MAX(HItemID)HItemID from Gy_Supplier", "Gy_Supplier");
string MaxHItemID = Cs.Tables[0].Rows[0]["HItemID"].ToString();
- //鍒犻櫎瀛愯〃鎿嶄綔 闃叉鍑洪敊
oCN.RunProc("delete from Gy_Supplier_PayPlan where HSupID='" + MaxHItemID + "'");
+ oCN.RunProc("delete from Gy_Supplier_Link where HSupID='" + MaxHItemID + "'");
+
+ //瀛愯〃娣诲姞
+ List<ClsGy_Supplier_PayPlan> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_Supplier_PayPlan>>(msg3);
+ int i = 0;
foreach (ClsGy_Supplier_PayPlan oSub in DetailColl)
{
i++;
oCN.RunProc($@"Insert into Gy_Supplier_PayPlan
(HSupID,HSubID,HPayType,HPayRate,HPayTime,HPayRemark)
values({MaxHItemID},{i} ,'{oSub.HPayType}',{oSub.HPayRate},{oSub.HPayTime},'{oSub.HPayRemark}')");
+ }
+
+ //瀛愯〃娣诲姞
+ List<ClsGy_Supplier_Link> DetailCol2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_Supplier_Link>>(msg4);
+ int i2 = 0;
+ foreach (ClsGy_Supplier_Link oSub in DetailCol2)
+ {
+ i2++;
+ oCN.RunProc($@"Insert into Gy_Supplier_Link
+ (HSupID,HSubID,HLinkMan,HLinkPhone,HRemark)
+ values({MaxHItemID},{i2} ,'{oSub.HLinkMan}','{oSub.HLinkPhone}','{oSub.HRemark}')");
}
oCN.Commit();
@@ -478,10 +495,11 @@
string msg1 = _value.ToString();
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
string msg2 = sArray[0].ToString(); //琛ㄥご鏁版嵁
- string msg3 = sArray[1].ToString(); //瀛愯〃鏁版嵁
+ string msg3 = sArray[1].ToString(); //瀛愯〃鏁版嵁-浠樻璁″垝
string msg4 = sArray[2].ToString(); //鍒楄〃涓籌D
string msg5 = sArray[3].ToString(); //鐧诲綍浜哄憳
string msg6 = sArray[4].ToString(); //鏉冮檺妯″潡浠ｇ爜
+ string msg7 = sArray[5].ToString(); //瀛愯〃鏁版嵁-鑱旂郴浜�
//鍙嶅簭鍒楀寲
msg2 = "[" + msg2.ToString() + "]";
List<Supplier> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(msg2);
@@ -588,11 +606,13 @@
oCN.RunProc("Update Gy_Supplier set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
//
+ //鍒犻櫎瀛愯〃鎿嶄綔 闃叉鍑洪敊
+ oCN.RunProc("delete from Gy_Supplier_PayPlan where HSupID='" + HItemID + "'");
+ oCN.RunProc("delete from Gy_Supplier_Link where HSupID='" + HItemID + "'");
+
//瀛愯〃娣诲姞
List<ClsGy_Supplier_PayPlan> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_Supplier_PayPlan>>(msg3);
int i = 0;
- //鍒犻櫎瀛愯〃鎿嶄綔 闃叉鍑洪敊
- oCN.RunProc("delete from Gy_Supplier_PayPlan where HSupID='" + HItemID + "'");
foreach (ClsGy_Supplier_PayPlan oSub in DetailColl)
{
i++;
@@ -601,6 +621,17 @@
values({HItemID},{i} ,'{oSub.HPayType}',{oSub.HPayRate},{oSub.HPayTime},'{oSub.HPayRemark}')");
}
+ //瀛愯〃娣诲姞
+ List<ClsGy_Supplier_Link> DetailCol2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_Supplier_Link>>(msg7);
+ int i2 = 0;
+ foreach (ClsGy_Supplier_Link oSub in DetailCol2)
+ {
+ i2++;
+ oCN.RunProc($@"Insert into Gy_Supplier_Link
+ (HSupID,HSubID,HLinkMan,HLinkPhone,HRemark)
+ values({HItemID},{i2} ,'{oSub.HLinkMan}','{oSub.HLinkPhone}','{oSub.HRemark}')");
+ }
+
oCN.Commit();
--
Gitblit v1.9.1