From fcc99f2648369ea6aa20e59f59653ac872bba091 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期日, 19 十月 2025 13:01:03 +0800
Subject: [PATCH] 分支合并
---
WebAPI/Controllers/BaseSet/Gy_SupplierController.cs | 158 +++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 143 insertions(+), 15 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
index 240b2f4..253a980 100644
--- a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs
@@ -247,6 +247,7 @@
}
#endregion
+ #region 鑾峰彇渚涘簲鍟嗙紪杈戞煡鐪� 瑙嗗浘
/// <summary>
/// 渚涘簲鍟嗗垪琛ㄤ慨鏀规寜閽柟娉�
///鍙傛暟锛歴tring sql銆�
@@ -261,8 +262,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 = "";
@@ -279,8 +282,46 @@
return objJsonResult;
}
}
+ #endregion
+ #region 鑾峰彇渚涘簲鍟嗙紪杈戞煡鐪� 瑙嗗浘 鎵╁睍鍒跺崟淇℃伅
+ /// <summary>
+ /// 渚涘簲鍟嗗垪琛ㄤ慨鏀规寜閽柟娉�
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Gy_Supplier/xg_ExpendBillMake")]
+ [HttpGet]
+ public object xg_ExpendBillMake(long HInterID)
+ {
+ try
+ {
+ string sql = string.Format(@"select * from h_v_Gy_SupplierEdit_ExpendBillMake where HItemID='" + HInterID + "'");
+ ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierEdit_ExpendBillMake");
+ 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 = "";
+ objJsonResult.data = ds.Tables[0];
+ objJsonResult.list = list;
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+ #region 鍗曟嵁淇濆瓨缁撳悎澶嶅埗鍔熻兘
/// <summary>
/// 鏂板鍗曟嵁-淇濆瓨鎸夐挳
///鍙傛暟锛歴tring sql銆�
@@ -297,6 +338,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() + "]";
@@ -318,7 +360,7 @@
string HAddress = list[0].HAddress;
string HLinkMan = list[0].HLinkMan;
string HLinkPhone = list[0].HLinkPhone;
- string HBankAccount = list[0].HMobilePhone;
+ string HBankAccount = list[0].HBankAccount;
string HFax = list[0].HFax;
string HPostalCode = list[0].HPostalCode;
string HEmail = list[0].HEmail;
@@ -342,6 +384,7 @@
string HMaterClass = list[0].HMaterClass;
long HPSStyleID = list[0].HPSStyleID;
long HSupTypeID = list[0].HSupTypeID;
+ string HMaker = list[0].HMaker;
if (!DBUtility.ClsPub.AllowNumber(HNumber))
{
@@ -353,6 +396,17 @@
}
//鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
oCN.BeginTran();
+ // 鑻ュ湪鏂板鍜屽鍒朵腑瀛樺湪鐩稿悓缁勭粐锛屽垯杩斿洖閿欒淇℃伅
+ DataSet ds_check = oCN.RunProcReturn(@"select * from Gy_Supplier where HNumber ='" + HNumber + "'" + "and HUSEORGID = '" + HUseOrgID + "'", "Gy_Supplier");
+ if (ds_check.Tables[0].Rows.Count != 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鐩稿悓缁勭粐涓嬩笉鑳藉瓨鍦ㄧ浉鍚屼緵搴斿晢浠ｇ爜!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
//涓昏〃
oCN.RunProc("Insert Into Gy_Supplier " +
"(HNumber,HName,HHelpCode,HShortNumber,HParentID" +
@@ -360,30 +414,44 @@
",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" +
",HFax,HPostalCode,HEmail,HBank,HBankAccount" +
",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" +
- ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HUSEORGID,HCREATEORGID,HPSStyleID,HSupTypeID) " +
+ ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HUSEORGID,HCREATEORGID,HPSStyleID,HSupTypeID,HMaker) " +
" values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HParentID + "'" +
"," + HLevel + ",1,'" + HStopflag + "','" + HRemark + "'" +
",'" + HShortName + "','" + HAddress + "','" + HLinkMan + "','" + HLinkPhone + "','" + HMobilePhone + "'" +
",'" + HFax + "','" + HPostalCode + "','" + HEmail + "','" + HBank + "','" + HBankAccount + "'" +
",'" + HTaxNum + "','" + HTaxRate + "','" + HCountry + "','" + HCorMan + "','" + HEnglishName + "'" +
- ",'" + HEnglishAddress + "'," + HCurID + "," + HSSID + "," + HAreaID +" ,'" + HMaterClass + " ','" + HUseOrgID + "' ,'" + HCreateOrgID + "' ,'" + HPSStyleID+ "' ,'" + HSupTypeID +
+ ",'" + HEnglishAddress + "'," + HCurID + "," + HSSID + "," + HAreaID +" ,'" + HMaterClass + " ','" + HUseOrgID + "' ,'" + HCreateOrgID + "' ,'" + HPSStyleID+ "' ,'" + HSupTypeID + "' ,'" + HMaker +
"') ");
//淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
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();
@@ -403,6 +471,7 @@
return objJsonResult;
}
}
+ #endregion
[Route("Gy_Supplier/SaveGy_SupplierListApi")]
[HttpPost]
@@ -411,32 +480,50 @@
try
{
var _value = msg["model"].ToString();
+ LogService.Write("1" + _value);
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
//鍙嶅簭鍒楀寲
_value = "[" + _value.ToString() + "]";
List<Supplier> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(_value);
string sql = string.Empty;
+ LogService.Write("2");
//淇濆瓨
oCN.BeginTran();
sql = $"delete from Gy_Supplier where HItemID = {lsmain[0].HItemID}";
+ LogService.Write("3");
oCN.RunProc(sql);
sql = "set identity_insert Gy_Supplier on";
oCN.RunProc(sql);
+ LogService.Write("渚涘簲鍟嗗悓姝�" + @"Insert Into Gy_Supplier " +
+ "(HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +
+ ",HLevel,HEndFlag,HStopflag,HRemark" +
+ ",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" +
+ ",HFax,HPostalCode,HEmail,HBank,HBankAccount" +
+ ",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" +
+ ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HERPItemID,HUseOrgID,HCreateOrgID) " +
+ " values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HName + "','" + lsmain[0].HHelpCode + "','" + lsmain[0].HShortNumber + "','" + lsmain[0].HParentID + "'" +
+ "," + lsmain[0].HLevel + ",0,'" + lsmain[0].HStopflag + "','" + lsmain[0].HRemark + "'" +
+ ",'" + lsmain[0].HShortName + "','" + lsmain[0].HAddress + "','" + lsmain[0].HLinkMan + "','" + lsmain[0].HLinkPhone + "','" + lsmain[0].HMobilePhone + "'" +
+ ",'" + lsmain[0].HFax + "','" + lsmain[0].HPostalCode + "','" + lsmain[0].HEmail + "','" + lsmain[0].HBank + "','" + lsmain[0].HBankAccount + "'" +
+ ",'" + lsmain[0].HTaxNum + "','" + lsmain[0].HTaxRate + "','" + lsmain[0].HCountry + "','" + lsmain[0].HCorMan + "','" + lsmain[0].HEnglishName + "'" +
+ ",'" + lsmain[0].HEnglishAddress + "'," + lsmain[0].HCurID + "," + lsmain[0].HSSID + "," + lsmain[0].HAreaID + ",'" + lsmain[0].HMaterClass +
+ "'," + lsmain[0].HItemID + ",'" + lsmain[0].HUseOrgID + "','" + lsmain[0].HCreateOrgID +
+ "') ");
oCN.RunProc("Insert Into Gy_Supplier " +
"(HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +
",HLevel,HEndFlag,HStopflag,HRemark" +
",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" +
",HFax,HPostalCode,HEmail,HBank,HBankAccount" +
",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" +
- ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HERPItemID) " +
+ ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HERPItemID,HUseOrgID,HCreateOrgID) " +
" values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HName + "','" + lsmain[0].HHelpCode + "','" + lsmain[0].HShortNumber + "','" + lsmain[0].HParentID + "'" +
"," + lsmain[0].HLevel + ",0,'" + lsmain[0].HStopflag + "','" + lsmain[0].HRemark + "'" +
",'" + lsmain[0].HShortName + "','" + lsmain[0].HAddress + "','" + lsmain[0].HLinkMan + "','" + lsmain[0].HLinkPhone + "','" + lsmain[0].HMobilePhone + "'" +
",'" + lsmain[0].HFax + "','" + lsmain[0].HPostalCode + "','" + lsmain[0].HEmail + "','" + lsmain[0].HBank + "','" + lsmain[0].HBankAccount + "'" +
",'" + lsmain[0].HTaxNum + "','" + lsmain[0].HTaxRate + "','" + lsmain[0].HCountry + "','" + lsmain[0].HCorMan + "','" + lsmain[0].HEnglishName + "'" +
",'" + lsmain[0].HEnglishAddress + "'," + lsmain[0].HCurID + "," + lsmain[0].HSSID + "," + lsmain[0].HAreaID +",'"+lsmain[0].HMaterClass+
- "'," + lsmain[0].HItemID +
- ") ");
+ "'," + lsmain[0].HItemID + ",'" + lsmain[0].HUseOrgID + "','" + lsmain[0].HCreateOrgID +
+ "') ");
//淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
sql = "set identity_insert Gy_Supplier off";
oCN.RunProc(sql);
@@ -463,7 +550,6 @@
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
-
[Route("Gy_Supplier/AddBill1")]
[HttpPost]
public object AddBill1([FromBody] JObject oMain)
@@ -478,10 +564,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);
@@ -499,7 +586,7 @@
string HAddress = list[0].HAddress;
string HLinkMan = list[0].HLinkMan;
string HLinkPhone = list[0].HLinkPhone;
- string HBankAccount = list[0].HMobilePhone;
+ string HBankAccount = list[0].HBankAccount;
string HFax = list[0].HFax;
string HPostalCode = list[0].HPostalCode;
string HEmail = list[0].HEmail;
@@ -534,6 +621,10 @@
return objJsonResult;
}
+ if(HItemID == 0) // 浣跨敤鏂板鍑芥暟
+ {
+
+ }
if (!DBUtility.ClsPub.AllowNumber(HNumber))
{
@@ -588,17 +679,30 @@
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++;
oCN.RunProc($@"Insert into Gy_Supplier_PayPlan
(HSupID,HSubID,HPayType,HPayRate,HPayTime,HPayRemark)
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}')");
}
@@ -663,12 +767,36 @@
objJsonResult.data = null;
return objJsonResult;
}
+
+ //鍒犻櫎鍓嶆帶鍒�=========================================
+ string sql1 = "exec h_p_Gy_Supplier_BeforeDelCtrl " + HItemID + ",'" + User + "'";
+ ds = oCN.RunProcReturn(sql1, "h_p_Gy_Supplier_BeforeDelCtrl");
+ if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:鍒犻櫎鍓嶅垽鏂け璐ワ紝璇蜂笌缃戠粶绠＄悊浜哄憳鑱旂郴";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ //==================================================================================
+
oCN.BeginTran();
//
if (oGroup.DeleteByID(HItemID))
{
//鍒犻櫎瀛愯〃
oCN.RunProc("delete from Gy_Supplier_PayPlan where HSupID='" + HItemID + "'");
+ oCN.RunProc("delete from Gy_Supplier_Link where HSupID='" + HItemID + "'");
oCN.Commit();
//鍐欏叆鏃ュ織
ClsPub.Add_Log("", "鍒犻櫎椤圭洰锛屼唬鐮侊細" + oGroupHlp.omodel.HNumber + ",鍚嶇О锛�" + oGroupHlp.omodel.HName, ClsPub.CurUserName);
--
Gitblit v1.9.1