~yxj/MES-WEB-API.git

			@@ -15,6 +15,9 @@
			//收料通知单Controller
			public class Cg_POInStockBillController : ApiController
			{
			//获取系统参数
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

			public DBUtility.ClsPub.Enum_BillStatus BillStatus;

			private json objJsonResult = new json();
			@@ -68,7 +71,7 @@
			/// </summary>
			[Route("Cg_POInStockBill/list")]
			[HttpGet]
			public object list(string sWhere,string user)
			public object list(string sWhere, string user)
			{
			try
			{
			@@ -84,12 +87,12 @@

			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList order by hmainid desc" , "h_v_IF_POInStockBillList");
			ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList order by hmainid desc", "h_v_IF_POInStockBillList");
			}
			else
			{
			string sql1 = "select * from h_v_IF_POInStockBillList where 1 = 1 ";
			string sql = sql1 + sWhere+ " order by 日期 desc,hmainid desc";
			string sql = sql1 + sWhere + " order by 日期 desc,hmainid desc";
			ds = oCN.RunProcReturn(sql, "h_v_IF_POInStockBillList");
			}

			@@ -119,14 +122,14 @@
			return objJsonResult;
			}
			}


			/// <summary>
			///删除功能
			/// </summary>
			/// <returns></returns>
			[Route("Cg_POInStockBill/DeltetPOInStockBill")]
			[HttpGet]
			public object DeltetPOInStockBill(string HInterID,string user)
			public object DeltetPOInStockBill(string HInterID, string user)
			{
			try
			{
			@@ -171,7 +174,7 @@
			/// </summary>
			[Route("Cg_POInStockBill/DeAuditPOInStockBill")]
			[HttpGet]
			public object DeAuditPOInStockBill(string HInterID,string user)
			public object DeAuditPOInStockBill(string HInterID, string user)
			{
			try
			{
			@@ -224,7 +227,7 @@
			Ids = ""
			};
			var loginRet = InvokeHelper.Login();


			var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
			if (isSuccess == 0)
			{
			@@ -527,14 +530,14 @@
			,HMoney,HWHID,HSPID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HPOOrderInterID
			,HPOOrderEntryID,HPOORderBillNo,HAuxPropID,HBatchNO,HMTONo,HPlanMode,HERPInterID,HERPEntryID
			,HRelationQty,HGiveAwayFlag,HReceiveQty,HSEQ,HPRODUCEDATE,HEXPIRYDATE,HSUPPLYLOT,HREQTRACENO,HBOMID,HSTOCKUNITID
			,HBASEUNITID,HSTOCKSTATUSID,HKEEPERTYPEID,HPROJECTNO,HGIVEAWAY,HCHECKINCOMING,HTAXPRICE,HDISCOUNTRATE
			,HBASEUNITID,HSTOCKSTATUSID,HKEEPERTYPEID,HPROJECTNO,HCHECKINCOMING,HTAXPRICE,HDISCOUNTRATE
			,HPRICECOEFFICIENT,HPRICEUNITID,HPRICELISTENTRY,HSAMPLEDAMAGEQTY,HSAMPLEDAMAGEBASEQTY
			,HPAYORGID,HSETTLEORGID,HSETTLECURRID,HSETTLEMODEID,HEXCHANGETYPEID,HPAYCONDITONID
			,HEXCHANGERATE,HLOCALCURRID,HISINCLUDEDTAX,HISPRICEEXCLUDETAX
			,HTAXRATEID,HCOSTPERCENT,HCOSTAMOUNT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING,HSecUnitID)
			values({HInterID},{NewHEntryID},{oSub.HMaterID},{oSub.HUnitID},{(oSub.HQty == null ? 0 : oSub.HQty)}
			,{oSub.HPrice},{oSub.HMoney},{oSub.HWHID},{oSub.HSPID},'{HRemark}',{oSub.HSourceInterID},{oSub.HSourceEntryID},{HSourceBillNo},{HSourceBillType},{oSub.HPOOrderInterID},{oSub.HPOOrderEntryID},{HPOOrderBillNo},{HAuxPropID},{HBatchNO},{HMTONo},{HPlanMode},{HERPInterID},{HERPEntryID},{HRelationQty},{HGiveAwayFlag},{HReceiveQty},{HSEQ},{HPRODUCEDATE},{HEXPIRYDATE},
			{HSUPPLYLOT},{HREQTRACENO},{HBOMID},{HSTOCKUNITID},{HBASEUNITID},{HSTOCKSTATUSID},'{HKEEPERTYPEID}',{HPROJECTNO},{HGIVEAWAY},{HCHECKINCOMING},{oSub.HTaxPrice},{HDISCOUNTRATE},{HPRICECOEFFICIENT},{HPRICEUNITID},{HPRICELISTENTRY},{HSAMPLEDAMAGEQTY},{HSAMPLEDAMAGEBASEQTY},{HPAYORGID},{HSETTLEORGID},{HSETTLECURRID},{HSETTLEMODEID},{HEXCHANGETYPEID},{HPAYCONDITONID},{oSub.HEXCHANGERATE},{HLOCALCURRID},{HISINCLUDEDTAX},{HISPRICEEXCLUDETAX},{HTAXRATEID},{HCOSTPERCENT},{HCOSTAMOUNT},{HVAT},{HSELLERWITHHOLDING},{HBUYERWITHHOLDING},{oSub.HSecUnitID})");
			{HSUPPLYLOT},{HREQTRACENO},{HBOMID},{HSTOCKUNITID},{HBASEUNITID},{HSTOCKSTATUSID},'{HKEEPERTYPEID}',{HPROJECTNO},{HCHECKINCOMING},{oSub.HTaxPrice},{HDISCOUNTRATE},{HPRICECOEFFICIENT},{HPRICEUNITID},{HPRICELISTENTRY},{HSAMPLEDAMAGEQTY},{HSAMPLEDAMAGEBASEQTY},{HPAYORGID},{HSETTLEORGID},{HSETTLECURRID},{HSETTLEMODEID},{HEXCHANGETYPEID},{HPAYCONDITONID},{oSub.HEXCHANGERATE},{HLOCALCURRID},{HISINCLUDEDTAX},{HISPRICEEXCLUDETAX},{HTAXRATEID},{HCOSTPERCENT},{HCOSTAMOUNT},{HVAT},{HSELLERWITHHOLDING},{HBUYERWITHHOLDING},{oSub.HSecUnitID})");
			}

			objJsonResult.code = "1";
			@@ -544,7 +547,459 @@
			return objJsonResult;
			}

			[Route("Cg_POInStockBill/Cg_POInStockBillSaveApi")]
			[HttpPost]
			public object Cg_POInStockBillSaveApi([FromBody] JObject sMainSub)
			{
			try
			{
			var model = sMainSub["model"].ToString();
			var entry = sMainSub["model"]["HENTRY"].ToString();

			model = "[" + model.ToString() + "]";
			List<ClsCg_POInStockBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POInStockBillMain>>(model);
			List<ClsCg_POInStockBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POInStockBillSub>>(entry);
			string sql = string.Empty;
			oCN.BeginTran();
			sql = $"delete Cg_POInStockBillMain where HinterID = {mainList[0].HInterID}";
			oCN.RunProc(sql);
			sql = $"delete Cg_POInStockBillSub where HinterID = {mainList[0].HInterID}";
			oCN.RunProc(sql);
			//主表
			sql = @"
			Insert Into Cg_POInStockBillMain
			(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate
			,HBillNo,HBillStatus,HSupID,HManagerID,HEmpID,HDeptID,HRemark
			,HMaker,HMakeDate,HChecker,HCheckDate,HOWNERTYPEID,HOWNERID
			,HERPInterID,HERPBillType,HPURCHASEORGID,HSTOCKORGID,HREQUIREORGID
			,HSTOCKGROUPID,HSENDBILLNO,HLADBILLNO,HPURDEPTID,HPURGROUPID,HSUPPLYID
			,HSETTLEID,HCHARGEID,HBUSINESSTYPE,HSUPPLYADDRESS,HCORRESPONDORGID,HPROVIDERCONTACTID,HCurID,HExRate,HAddress,HWHID,HInnerBillNo)
			values(" + mainList[0].HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1103 + "','" +
			mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "'," + mainList[0].HBillStatus + "," + mainList[0].HSupID +
			"," + mainList[0].HManagerID + "," + mainList[0].HEmpID + "," + mainList[0].HDeptID + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker +
			"','" + mainList[0].HMakeDate + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HOWNERTYPEID + "'," + mainList[0].HOWNERID + "," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "'," + mainList[0].HPURCHASEORGID + "," + mainList[0].HSTOCKORGID + "," + mainList[0].HREQUIREORGID + "," +
			mainList[0].HSTOCKGROUPID + ",'" + mainList[0].HSENDBILLNO + "','" + mainList[0].HLADBILLNO + "'," + mainList[0].HPURDEPTID + "," + mainList[0].HPURGROUPID + "," + mainList[0].HSUPPLYID + "," +
			mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + ",'" + mainList[0].HBUSINESSTYPE + "','" + mainList[0].HSUPPLYADDRESS + "'," + mainList[0].HCORRESPONDORGID + "," + mainList[0].HPROVIDERCONTACTID + "," + mainList[0].HCurID + "," + mainList[0].HExRate + ",'" + mainList[0].HAddress + "'," + mainList[0].HWHID + "," + mainList[0].HInnerBillNo + ")";
			oCN.RunProc(sql);
			//保存主表
			foreach (var oSub in subList)
			{
			sql = $@"
			Insert into Cg_POInStockBillSub
			(HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice
			,HMoney,HWHID,HSPID,HRemark,HTaxMoney,HTaxRate,HTaxMoney_TAX,HTaxRate_TAX
			,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HPOOrderInterID
			,HPOOrderEntryID,HPOORderBillNo,HAuxPropID,HBatchNO,HMTONo,HPlanMode,HERPInterID,HERPEntryID
			,HRelationQty,HGiveAwayFlag,HReceiveQty,HSEQ,HPRODUCEDATE,HEXPIRYDATE,HSUPPLYLOT,HREQTRACENO,HBOMID,HSTOCKUNITID
			,HBASEUNITID,HSTOCKSTATUSID,HKEEPERTYPEID,HPROJECTNO,HCHECKINCOMING,HTAXPRICE,HDISCOUNTRATE
			,HPRICECOEFFICIENT,HPRICEUNITID,HPRICELISTENTRY,HSAMPLEDAMAGEQTY,HSAMPLEDAMAGEBASEQTY
			,HPAYORGID,HSETTLEORGID,HSETTLECURRID,HSETTLEMODEID,HEXCHANGETYPEID,HPAYCONDITONID
			,HEXCHANGERATE,HLOCALCURRID,HISINCLUDEDTAX,HISPRICEEXCLUDETAX
			,HTAXRATEID,HCOSTPERCENT,HCOSTAMOUNT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING,HSecUnitID)
			values(
			'{oSub.HInterID}','{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HUnitID}','{oSub.HQty}','{oSub.HPrice}'
			,'{oSub.HMoney}','{oSub.HWHID}','{oSub.HSPID}','{oSub.HRemark}','{oSub.HTaxMoney}','{oSub.HTaxRate}','{oSub.HTaxMoney_TAX}','{oSub.HTaxRate_TAX}'
			,'{oSub.HSourceInterID}','{oSub.HSourceEntryID}','{oSub.HSourceBillNo}','{oSub.HSourceBillType}','{oSub.HPOOrderInterID}','{oSub.HPOOrderEntryID}','{oSub.HPOOrderBillNo}','{oSub.HAuxPropID}','{oSub.HBatchNO}','{oSub.HMTONo}','{oSub.HPlanMode}','{oSub.HERPInterID}','{oSub.HERPEntryID}','{oSub.HRelationQty}','{oSub.HGiveAwayFlag}','{oSub.HReceiveQty}','{oSub.HSEQ}','{oSub.HPRODUCEDATE}','{oSub.HEXPIRYDATE}',
			'{oSub.HSUPPLYLOT}','{oSub.HREQTRACENO}','{oSub.HBOMID}','{oSub.HSTOCKUNITID}','{oSub.HBASEUNITID}','{oSub.HSTOCKSTATUSID}','{oSub.HKEEPERTYPEID}','{oSub.HPROJECTNO}','{oSub.HCHECKINCOMING}','{oSub.HTaxPrice}','{oSub.HDISCOUNTRATE}','{oSub.HPRICECOEFFICIENT}','{oSub.HPRICEUNITID}','{oSub.HPRICELISTENTRY}','{oSub.HSAMPLEDAMAGEQTY}','{oSub.HSAMPLEDAMAGEBASEQTY}','{oSub.HPAYORGID}','{oSub.HSETTLEORGID}','{oSub.HSETTLECURRID}','{oSub.HSETTLEMODEID}','{oSub.HEXCHANGETYPEID}','{oSub.HPAYCONDITONID}','{oSub.HEXCHANGERATE}','{oSub.HLOCALCURRID}','{oSub.HISINCLUDEDTAX}','{oSub.HISPRICEEXCLUDETAX}','{oSub.HTAXRATEID}','{oSub.HCOSTPERCENT}','{oSub.HCOSTAMOUNT}','{oSub.HVAT}','{oSub.HSELLERWITHHOLDING}','{oSub.HBUYERWITHHOLDING}','{oSub.HSecUnitID}')";
			oCN.RunProc(sql);
			}
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "单据保存成功！";
			objJsonResult.data = null;
			return objJsonResult;

			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region [同步单据]
			[Route("Cg_POInStockBill/Cg_POInStockBillViewApi")]
			[HttpGet]
			public json Cg_POInStockBillViewApi(string BillNo, string BillType)
			{
			string sql = string.Empty;
			string sReturn = "";
			if (oSystemParameter.ShowBill(ref sReturn) == true)
			{
			//系统参数是否为私有云模式,N为公有云模式，Y为私有云模式
			if (oSystemParameter.omodel.WMS_CloudMode == "Y")
			{
			#region [私有云模式，直接调用数据库存储过程更新]
			try
			{
			oCN.BeginTran();
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			DataSet DS = oCn.RunProcReturn("exec h_p_WMS_ERPSourceBillToLocal '" + BillNo + "','" + BillType + "'", "h_p_WMS_ERPSourceBillToLocal");
			if (DS == null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据同步失败";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBack"]) == "2")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ERP中不存在该单据号";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "单据同步成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			#endregion
			}
			else
			{
			#region [公有云模式，调用WEBAPI的方式进行更新]
			var json = new
			{
			CreateOrgId = 0,
			Number = BillNo,
			Id = ""
			};
			#region [金蝶部分]
			//登录金蝶
			var loginRet = InvokeHelper.Login();
			var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
			//判断是否登录成功
			if (isSuccess < 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = loginRet;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//查看获取数据
			var _result = InvokeHelper.View("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
			var _saveObj = JObject.Parse(_result);
			//判断数据是否获取成功
			if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "金蝶收料通知单同步失败jsonRoot：" + _result;
			objJsonResult.data = null;
			return objJsonResult;
			}

			#endregion
			//获取主表数据
			DataSet Ds;
			Int64 InterID = 0;
			Int64 ManagerID = 0;
			Int64 EmpID = 0;
			Int64 DeptID = 0;
			Ds = oCN.RunProcReturn("select * from Cg_POInStockBillMain where HBillNo = '" + BillNo + "'", "Cg_POInStockBillMain");
			if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0)
			{
			InterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
			ManagerID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HManagerID"].ToString());
			EmpID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"].ToString());
			DeptID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"].ToString());
			}

			#region [主表数据赋值]
			var jsonData = new
			{
			HInterID = _saveObj["Result"]["Result"]["Id"],
			HYear = DateTime.Now.Year,
			HPeriod = DateTime.Now.Month,
			HBillType = 1103,
			HBillSubType = _saveObj["Result"]["Result"]["BusinessType"].ToString() == "CG" ? 12510 : 12511,
			HDate = _saveObj["Result"]["Result"]["Date"],
			HBillNo = _saveObj["Result"]["Result"]["BillNo"],
			HBillStatus = 2,
			HSupID = _saveObj["Result"]["Result"]["SupplierId_Id"],
			HManagerID = ManagerID,
			HEmpID = EmpID,
			HDeptID = DeptID,
			HRemark = "CLOUD导入",
			HMaker = _saveObj["Result"]["Result"]["CreatorId_Id"],
			HMakeDate = _saveObj["Result"]["Result"]["CreateDate"],
			HChecker = _saveObj["Result"]["Result"]["ApproverId_Id"],
			HCheckDate = _saveObj["Result"]["Result"]["ApproveDate"],
			HOWNERTYPEID = _saveObj["Result"]["Result"]["OwnerTypeIdHead"],
			HOWNERID = _saveObj["Result"]["Result"]["OwnerIdHead_Id"],
			HERPInterID = _saveObj["Result"]["Result"]["Id"],
			HERPBillType = _saveObj["Result"]["Result"]["BillTypeId_Id"],
			HPURCHASEORGID = _saveObj["Result"]["Result"]["PurOrgId_Id"],
			HSTOCKORGID = _saveObj["Result"]["Result"]["StockOrgId_Id"],
			HREQUIREORGID = _saveObj["Result"]["Result"]["DemandOrgId_Id"],
			HSTOCKGROUPID = _saveObj["Result"]["Result"]["StockGroupId_Id"],
			HSENDBILLNO = _saveObj["Result"]["Result"]["SendBillNo"],
			HLADBILLNO = _saveObj["Result"]["Result"]["LadBillNo"],
			HPURDEPTID = _saveObj["Result"]["Result"]["PurDeptId_Id"],
			HPURGROUPID = _saveObj["Result"]["Result"]["PurGroupId_Id"],
			HSUPPLYID = _saveObj["Result"]["Result"]["SupplyId_Id"],
			HSETTLEID = _saveObj["Result"]["Result"]["SettleId_Id"],
			HCHARGEID = _saveObj["Result"]["Result"]["ChargeId_Id"],
			HBUSINESSTYPE = _saveObj["Result"]["Result"]["BusinessType"],
			HSUPPLYADDRESS = _saveObj["Result"]["Result"]["SupplyAddress"],
			HCORRESPONDORGID = _saveObj["Result"]["Result"]["CorrespondOrgId_Id"],
			HPROVIDERCONTACTID = _saveObj["Result"]["Result"]["ProviderContactId_Id"],
			};
			#endregion
			// 删除主表对应数据
			sql = $"delete from Cg_POInStockBillMain where HInterID = " + InterID;
			oCN.RunProc(sql);

			//插入主表
			sql = $@"
			insert into Cg_PoInstockbillMain
			(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate
			,HBillNo,HBillStatus,HSupID,HManagerID,HEmpID,HDeptID,HRemark
			,HMaker,HMakeDate,HChecker,HCheckDate,HOWNERTYPEID,HOWNERID
			,HERPInterID,HERPBillType,HPURCHASEORGID,HSTOCKORGID,HREQUIREORGID
			,HSTOCKGROUPID,HSENDBILLNO,HLADBILLNO,HPURDEPTID,HPURGROUPID,HSUPPLYID
			,HSETTLEID,HCHARGEID,HBUSINESSTYPE,HSUPPLYADDRESS,HCORRESPONDORGID,HPROVIDERCONTACTID
			)
			values
			({jsonData.HInterID},{jsonData.HYear},{jsonData.HPeriod},{jsonData.HBillType},{jsonData.HBillSubType},'{jsonData.HDate}','{jsonData.HBillNo}',
			{jsonData.HBillStatus},{jsonData.HSupID},{jsonData.HManagerID},{jsonData.HEmpID},{jsonData.HDeptID},'{jsonData.HRemark}','{jsonData.HMaker}',
			'{jsonData.HMakeDate}','{jsonData.HChecker}','{jsonData.HCheckDate}','{jsonData.HOWNERTYPEID}','{jsonData.HOWNERID}',{jsonData.HERPInterID},
			'{jsonData.HERPBillType}',{jsonData.HPURCHASEORGID},{jsonData.HSTOCKORGID},{jsonData.HREQUIREORGID},{jsonData.HSTOCKGROUPID},'{jsonData.HSENDBILLNO}',
			'{jsonData.HLADBILLNO}',{jsonData.HPURDEPTID},{jsonData.HPURGROUPID},{jsonData.HSUPPLYID},{jsonData.HSETTLEID},{jsonData.HCHARGEID},'{jsonData.HBUSINESSTYPE}',
			'{jsonData.HSUPPLYADDRESS}',{jsonData.HCORRESPONDORGID},{jsonData.HPROVIDERCONTACTID})";
			oCN.RunProc(sql);

			#region [申请子表变量]
			var dataArr = _saveObj["Result"]["Result"]["PUR_ReceiveEntry"];

			DataSet Cs;
			double Qty = 0;
			double Money = 0;
			Int64 WHID = 0;
			Int64 SPID = 0;
			string subRemark = "";
			double TaxMoney = 0;
			double TaxMoney_TAX = 0;
			double TaxRate_TAX = 0;
			Int64 SourceBillType = 0;
			Int64 POOrderInterID = 0;
			string POORderBillNo = "";
			string BatchNO = "";
			Int64 ERPInterID = 0;
			Int64 ERPEntryID = 0;
			double RelationQty = 0;
			Int64 SecUnitID = 0;
			Int64 PAYORGID = 0;
			Int64 PAYCONDITONID = 0;
			Int64 SETTLEORGID = 0;
			Int64 SETTLECURRID = 0;
			Int64 SETTLEMODEID = 0;
			Int64 EXCHANGETYPEID = 0;
			double EXCHANGERATE = 0;
			Int64 LOCALCURRID = 0;
			Int64 ISINCLUDEDTAX = 0;
			Int64 ISPRICEEXCLUDETAX = 0;
			Int64 PlanMode = 0;
			#endregion
			int i = 0;

			// 获取子表数据
			Cs = oCN.RunProcReturn("select * from Cg_POInStockBillSub where HInterID = " + InterID, "Cg_POInStockBillSub");
			// 删除子表对应数据
			sql = $"delete from Cg_POInStockBillSub where HInterID = " + InterID;
			oCN.RunProc(sql);

			foreach (var oSub in dataArr)
			{
			#region [子表数据赋值]

			if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HInterID"].ToString()) != 0)
			{
			Qty = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HQty"].ToString());
			Money = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HMoney"].ToString());
			WHID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HWHID"].ToString());
			SPID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HSPID"].ToString());
			subRemark = ClsPub.isStrNull(Cs.Tables[0].Rows[i]["HRemark"]);
			TaxMoney = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HTaxMoney"].ToString());
			TaxMoney_TAX = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HTaxMoney_TAX"].ToString());
			TaxRate_TAX = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HTaxRate_TAX"].ToString());
			SourceBillType = ClsPub.isLong(Cs.Tables[0].Rows[i]["HSourceBillType"].ToString());
			POOrderInterID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HPOOrderInterID"].ToString());
			POORderBillNo = ClsPub.isStrNull(Cs.Tables[0].Rows[i]["HPOORderBillNo"]);
			BatchNO = ClsPub.isStrNull(Cs.Tables[0].Rows[i]["HBatchNO"]);
			ERPInterID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HERPInterID"].ToString());
			ERPEntryID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HERPEntryID"].ToString());
			RelationQty = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HRelationQty"].ToString());
			SecUnitID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HSecUnitID"].ToString());
			PAYORGID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HPAYORGID"].ToString());
			PAYCONDITONID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HPAYCONDITONID"].ToString());
			SETTLEORGID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HSETTLEORGID"].ToString());
			SETTLECURRID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HSETTLECURRID"].ToString());
			SETTLEMODEID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HSETTLEMODEID"].ToString());
			EXCHANGETYPEID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HEXCHANGETYPEID"].ToString());
			EXCHANGERATE = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HEXCHANGERATE"].ToString());
			LOCALCURRID = ClsPub.isLong(Cs.Tables[0].Rows[i]["HLOCALCURRID"].ToString());
			ISINCLUDEDTAX = ClsPub.isLong(Cs.Tables[0].Rows[i]["HISINCLUDEDTAX"].ToString());
			ISPRICEEXCLUDETAX = ClsPub.isLong(Cs.Tables[0].Rows[i]["HISPRICEEXCLUDETAX"].ToString());
			PlanMode = ClsPub.isLong(Cs.Tables[0].Rows[i]["HPlanMode"].ToString());

			i++;
			}

			var subData = new
			{
			HInterID = _saveObj["Result"]["Result"]["Id"],
			HEntryID = oSub["Id"],
			HMaterID = oSub["MaterialID_Id"],
			HUnitID = oSub["UnitId_Id"],
			HQty = Qty,
			HPrice = oSub["Price"],
			HMoney = Money,
			HWHID = WHID,
			HSPID = SPID,
			HRemark = subRemark,
			HTaxMoney = TaxMoney,
			HTaxRate = oSub["TaxRate"],
			HTaxMoney_TAX = TaxMoney_TAX,
			HTaxRate_TAX = TaxRate_TAX,
			HSourceInterID = oSub["SrcId"],
			HSourceEntryID = oSub["SrcEntryId"],
			HSourceBillNo = oSub["SrcBillNo"],
			HSourceBillType = SourceBillType,
			HPOOrderInterID = POOrderInterID,
			HPOOrderEntryID = oSub["POORDERENTRYID"],
			HPOORderBillNo = POORderBillNo,
			HAuxPropID = oSub["AuxPropId_Id"],
			HBatchNO = BatchNO,
			HMTONo = oSub["MtoNo"],
			HPlanMode = PlanMode,
			HERPInterID = ERPInterID,
			HERPEntryID = ERPEntryID,
			HRelationQty = RelationQty,
			HGiveAwayFlag = oSub["GiveAway"] = false ? 0 : 1,
			HReceiveQty = oSub["ReceiveQty"],
			HSecUnitID = SecUnitID,
			HSEQ = oSub["Seq"],
			HPRODUCEDATE = oSub["ProduceDate"],
			HEXPIRYDATE = oSub["ExpiryDate"],
			HSUPPLYLOT = oSub["SupplierLot"],
			HREQTRACENO = oSub["ReqTraceNo"],
			HBOMID = oSub["BomId_Id"],
			HSTOCKUNITID = oSub["StockUnitID_Id"],
			HBASEUNITID = oSub["BaseUnitId_Id"],
			HSTOCKSTATUSID = oSub["StockStatusId_Id"],
			HKEEPERTYPEID = oSub["KeeperTypeId"],
			HPROJECTNO = oSub["ProjectNo"],
			HCHECKINCOMING = oSub["CheckInComing"] = false ? 0 : 1,
			HTAXPRICE = oSub["TaxPrice"],
			HDISCOUNTRATE = oSub["DiscountRate"],
			HPRICECOEFFICIENT = oSub["PriceCoefficient"],
			HPRICEUNITID = oSub["PriceUnitId_Id"],
			HPRICELISTENTRY = oSub["PriceListEntry_Id"],
			HTAXCOMBINATION = oSub["TaxCombination_Id"],
			HSAMPLEDAMAGEQTY = oSub["SampleDamageQty"],
			HSAMPLEDAMAGEBASEQTY = oSub["SampleDamageBaseQty"],
			HOWNERTYPEID = oSub["OwnerTypeId"],
			HOWNERID = oSub["OwnerId_Id"],
			HBFLOWID = oSub["FBFLowId_Id"],
			HPAYORGID = PAYORGID,
			HSETTLEORGID = SETTLEORGID,
			HSETTLECURRID = SETTLECURRID,
			HSETTLEMODEID = SETTLEMODEID,
			HEXCHANGETYPEID = EXCHANGETYPEID,
			HPAYCONDITONID = PAYCONDITONID,
			HEXCHANGERATE = EXCHANGERATE,
			HLOCALCURRID = LOCALCURRID,
			HISINCLUDEDTAX = ISINCLUDEDTAX,
			HISPRICEEXCLUDETAX = ISPRICEEXCLUDETAX,
			HTAXRATEID = 0,
			HCOSTPERCENT = 0,
			HCOSTAMOUNT = 0,
			HVAT = 0,
			HSELLERWITHHOLDING = 0,
			HBUYERWITHHOLDING = 0,
			};
			#endregion


			//插入子表
			sql = $@"
			insert into Cg_PoInstockbillSub
			(HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice
			,HMoney,HWHID,HSPID,HRemark,HTaxMoney,HTaxRate,HTaxMoney_TAX,HTaxRate_TAX
			,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HPOOrderInterID,HPOOrderEntryID,HPOORderBillNo
			,HAuxPropID,HBatchNO,HMTONo,HPlanMode,HERPInterID,HERPEntryID
			,HRelationQty,HGiveAwayFlag,HReceiveQty,HSecUnitID
			,HSEQ,HPRODUCEDATE,HEXPIRYDATE,HSUPPLYLOT,HREQTRACENO,HBOMID,HSTOCKUNITID
			,HBASEUNITID,HSTOCKSTATUSID,HKEEPERTYPEID,HPROJECTNO,HCHECKINCOMING
			,HTAXPRICE,HDISCOUNTRATE,HPRICECOEFFICIENT,HPRICEUNITID,HPRICELISTENTRY
			,HTAXCOMBINATION,HSAMPLEDAMAGEQTY,HSAMPLEDAMAGEBASEQTY,HOWNERTYPEID,HOWNERID,HBFLOWID
			,HPAYORGID,HSETTLEORGID,HSETTLECURRID,HSETTLEMODEID,HEXCHANGETYPEID,HPAYCONDITONID
			,HEXCHANGERATE,HLOCALCURRID,HISINCLUDEDTAX,HISPRICEEXCLUDETAX
			,HTAXRATEID,HCOSTPERCENT,HCOSTAMOUNT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING
			)
			values
			({subData.HInterID},{subData.HEntryID},{subData.HMaterID},{subData.HUnitID},{subData.HQty},{subData.HPrice},
			{subData.HMoney},{subData.HWHID},{subData.HSPID},'{subData.HRemark}',{subData.HTaxMoney},{subData.HTaxRate},{subData.HTaxMoney_TAX},
			{subData.HTaxRate_TAX},{subData.HSourceInterID},{subData.HSourceEntryID},'{subData.HSourceBillNo}',{subData.HSourceBillType},
			{subData.HPOOrderInterID},{subData.HPOOrderEntryID},'{subData.HPOORderBillNo}',{subData.HAuxPropID},'{subData.HBatchNO}',
			'{subData.HMTONo}',{subData.HPlanMode},{subData.HERPInterID},{subData.HERPEntryID},{subData.HRelationQty},{subData.HGiveAwayFlag},
			{subData.HReceiveQty},{subData.HSecUnitID},{subData.HSEQ},'{subData.HPRODUCEDATE}','{subData.HEXPIRYDATE}','{subData.HSUPPLYLOT}',
			'{subData.HREQTRACENO}',{subData.HBOMID},{subData.HSTOCKUNITID},{subData.HBASEUNITID},{subData.HSTOCKSTATUSID},'{subData.HKEEPERTYPEID}',
			'{subData.HPROJECTNO}',{subData.HCHECKINCOMING},{subData.HTAXPRICE},{subData.HDISCOUNTRATE},
			{subData.HPRICECOEFFICIENT},{subData.HPRICEUNITID},{subData.HPRICELISTENTRY},'{subData.HTAXCOMBINATION}',{subData.HSAMPLEDAMAGEQTY},
			{subData.HSAMPLEDAMAGEBASEQTY},'{subData.HOWNERTYPEID}',{subData.HOWNERID},'{subData.HBFLOWID}',{subData.HPAYORGID},{subData.HSETTLEORGID},
			{subData.HSETTLECURRID},{subData.HSETTLEMODEID},{subData.HEXCHANGETYPEID},{subData.HPAYCONDITONID},{subData.HEXCHANGERATE},
			{subData.HLOCALCURRID},{subData.HISINCLUDEDTAX},{subData.HISPRICEEXCLUDETAX},{subData.HTAXRATEID},{subData.HCOSTPERCENT},
			{subData.HCOSTAMOUNT},{subData.HVAT},{subData.HSELLERWITHHOLDING},{subData.HBUYERWITHHOLDING})";
			oCN.RunProc(sql);
			}


			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "单据同步成功！";
			objJsonResult.data = null;
			return objJsonResult;

			#endregion
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "单据读取失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion
			}
			}