MES-WEB-API.git

			@@ -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;