MES-WEB-API.git

			@@ -89,9 +89,125 @@
			return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_WW_PPBomBillList");
			}

			}

			}



			#region å§å¤ç¨ææ¸åè®¢å éè¶åæ¥
			[Route("WW_PPBomBillController/SaveWW_PPBomBillApi")]
			[HttpPost]
			public object SaveWW_PPBomBillApi([FromBody] JObject sMainSub)
			{
			LogService.Write("å¼å§åæ¥");
			try
			{
			LogService.Write($"æ¥æ¶å°çå®æ´æ°æ®: {sMainSub.ToString()}");
			var model = sMainSub["model"].ToString();
			var entry = sMainSub["model"]["HENTRY"].ToString();
			model = "[" + model.ToString() + "]";
			LogService.Write($"ä¸»è¡¨æ¨¡åJSON: {model}");
			LogService.Write($"åè¡¨æ¨¡åJSON: {entry}");
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			ListModels oListModels = new ListModels();
			List<ClsWW_PPBomBill> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsWW_PPBomBill>>(model);
			List<ClsWW_PPBomBillSubERP> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsWW_PPBomBillSubERP>>(entry);
			// æ·»å ç±»åæ£æ¥æ¥å¿
			LogService.Write($"ä¸»è¡¨HInterIDç±»å: {mainList[0].HInterID.GetType()}");
			LogService.Write($"ä¸»è¡¨HInterIDå¼: {mainList[0].HInterID}");
			string sql = string.Empty;
			LogService.Write($"ä¸»æ¨¡åæ°æ®{mainList}");
			LogService.Write($"åæ¨¡åæ°æ®{subList}");
			//ä¿å
			oCN.BeginTran();
			int hInterID = mainList[0].HInterID;
			LogService.Write($"å¼å§å¤ç HInterID: {hInterID}");

			string checkSql = $"SELECT COUNT(1) FROM WW_PPBomBillSub WHERE HInterID = {hInterID}";
			LogService.Write($"æ£æ¥åè¡¨æ°æ®æ¯å¦åå¨: {checkSql}");

			// 2. å é¤åè¡¨æ°æ®
			string deleteSubSql = $"DELETE FROM WW_PPBomBillSub WHERE HInterID = {hInterID}";
			LogService.Write($"å é¤åè¡¨SQL: {deleteSubSql}");
			oCN.RunProc(deleteSubSql, ref DBUtility.ClsPub.sExeReturnInfo);
			LogService.Write("åè¡¨æ°æ®å é¤å®æ");

			// 3. å é¤ä¸»è¡¨æ°æ®
			string deleteMainSql = $"DELETE FROM WW_PPBomBillMain WHERE HInterID = {hInterID}";
			LogService.Write($"å é¤ä¸»è¡¨SQL: {deleteMainSql}");
			oCN.RunProc(deleteMainSql, ref DBUtility.ClsPub.sExeReturnInfo);
			LogService.Write("ä¸»è¡¨æ°æ®å é¤å®æ");


			oCN.RunProc($@"insert into WW_PPBomBillMain
			(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate
			,HBillNo,HBillStatus,HICMOInterID,HICMOEntryID,HSUBBILLNO,HSUBREQENTRYSEQ
			,HMaterID,HUnitID,HQty,HSupID,HDEPTID,HPOOrderBillNo,HPOOrderSeq
			,HMaker,HMakeDate,HChecker,HCheckDate,HUpDater,HUpDateDate
			,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HSeOrderSEQ
			,HPRDORGID,HENTRUSTORGID,HPARENTOWNERID,HPARENTOWNERTYPEID
			,HERPInterID,HERPBillType,HSETTLEORGID,HREQSRC)
			values({mainList[0].HInterID},'{mainList[0].HYear}','{mainList[0].HPeriod}','{mainList[0].HBillType}','{mainList[0].HBillSubType}','{mainList[0].HDate}','{mainList[0].HBillNo}'
			,'{mainList[0].HBillStatus}','{mainList[0].HICMOInterID}','{mainList[0].HICMOEntryID}','{mainList[0].HSUBBILLNO}','{mainList[0].HSUBREQENTRYSEQ}','{mainList[0].HMaterID}',{mainList[0].HUnitID},'{mainList[0].HQty}','{mainList[0].HSupID}','{mainList[0].HDeptID}',
			'{mainList[0].HPOOrderBillNo}','{mainList[0].HPOOrderSeq}','{mainList[0].HMaker}','{mainList[0].HMakeDate}','{mainList[0].HChecker}','{mainList[0].HCheckDate}','{mainList[0].HUpDater}','{mainList[0].HUpDateDate}','{mainList[0].HSeOrderBillNo}','{mainList[0].HSeOrderInterID}','{mainList[0].HSeOrderEntryID}','{mainList[0].HSeOrderSEQ}'
			,'{mainList[0].HPRDORGID}','{mainList[0].HENTRUSTORGID}','{mainList[0].HPARENTOWNERID}'
			,'{mainList[0].HPARENTOWNERTYPEID}','{mainList[0].HERPInterID}','{mainList[0].HERPBillType}','{mainList[0].HSETTLEORGID}','{mainList[0].HREQSRC}'

			)", ref DBUtility.ClsPub.sExeReturnInfo);
			LogService.Write("ä¸»è¡¨æå¥æå");

			foreach (var oSub in subList)
			{
			var count = subList.Count();
			LogService.Write($"åè¡¨æ°æ®æ¡æ°ä¸º{count}");
			//æ°å¢åè¡¨ï¼
			oCN.RunProc($@" insert into WW_PPBomBillSub
			(HInterID,HEntryID,HMaterID,HUnitID,HQty,HQtyMust,HWHID,HRemark
			,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType
			,HICMOInterID,HICMOEntryID,HICMOBillNo
			,HCHILDSUPPLYORGID,HSUPPLYORGID,HENTRUSTPICKORGID,HSRCTRANSORGID,HGROUPBYOWNERID,HOWNERID,HOWNERTYPEID
			,HRelationQty,HMoveStockQty,HAuxPropID,HBatchNO,HMTONo,HQtyScrap,HERPInterID,HERPEntryID
			,HBackRelationQty
			,HPROCESSID,HBASEUNITID,HPROJECTNO,HOPERID,HSEQ
			,HSTOCKSTATUSID,HRESERVETYPE
			)
			values({oSub.HInterID},'{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HUnitID}','{oSub.HQty}',{oSub.HQtyMust},'{oSub.HWHID}',
			'{oSub.HRemark}','{oSub.HSourceInterID}','{oSub.HSourceEntryID}','{oSub.HSourceBillNo}','{oSub.HSourceBillType}',{oSub.HICMOInterID },'{oSub.HICMOEntryID}','{oSub.HICMOBillNo}','{oSub.HCHILDSUPPLYORGID}','{oSub.HSUPPLYORGID}'
			,'{oSub.HENTRUSTPICKORGID}','{oSub.HSRCTRANSORGID}','{oSub.HGROUPBYOWNERID}','{oSub.HOWNERID}','{oSub.HOWNERTYPEID}','{oSub.HRelationQty}','{oSub.HMoveStockQty}','{oSub.HAuxPropID}','{oSub.HBatChNo}','{oSub.HMTONo}','{oSub.HQtyScrap}',
			{oSub.HERPInterID},'{oSub.HERPEntryID}','{oSub.HBackRelationQty}','{oSub.HPROCESSID}',{oSub.HBASEUNITID },'{oSub.HPROJECTNO}','{oSub.HOPERID}','{oSub.HSEQ}','{oSub.HSTOCKSTATUSID}','{oSub.HRESERVETYPE}'
			)", ref DBUtility.ClsPub.sExeReturnInfo);
			}
			LogService.Write("åè¡¨æå¥æå");





			oCN.Commit();






			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "ä¿åæåï¼";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			catch (Exception e)
			{
			LogService.Write("å¼å¸¸ä¿¡æ¯ï¼" + e.ToString());
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿åå¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			#endregion

			}

			#endregion
			}