MES-WEB-API.git

			@@ -8,7 +8,8 @@
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using System.Diagnostics;

			using System.Threading;
			using System.Globalization;
			namespace WebAPI.Controllers.SCGL.æ¥è®¡åç®¡ç
			{
			public class JIT_DayPlanPlatFormBillController : ApiController
			@@ -20,6 +21,7 @@
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			Sc_WorkBillSortBillMain omdelMian = new Sc_WorkBillSortBillMain();
			public static string BillType = "4610";
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

			#region çäº§æ¥è®¡åå¹³å° æ¥è¯¢
			[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillList")]
			@@ -41,7 +43,8 @@
			omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);

			ds = oCN.RunProcReturn($"exec h_p_JIT_Sc_WorkBillSortBill_Query '{omdelMian.HPlanBeginDate}',{(omdelMian.HProdORGID == null ? 0 : omdelMian.HProdORGID)},'{omdelMian.HSeOrderBillNo}'" +
			$",'{omdelMian.HPlanEndDate.AddDays(1)}',{omdelMian.HMaterID},'{omdelMian.HICMOBillNo}',{omdelMian.HWorkShopID}", "h_p_JIT_Sc_WorkBillSortBill_Query");
			$",'{omdelMian.HPlanEndDate.AddDays(1)}',{omdelMian.HMaterID},'{omdelMian.HICMOBillNo}',{omdelMian.HWorkShopID}" +
			$",'{omdelMian.HMastersDate}','{omdelMian.sWheres}'", "h_p_JIT_Sc_WorkBillSortBill_Query");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -95,6 +98,40 @@
			return objJsonResult;
			}
			}

			/// <summary>
			/// æ ¹æ®ç¹å»è¡æ é¢æ¶é´æ¥è¯¢ç¼ºæåæ
			/// </summary>
			/// <param name="sWhere"></param>
			/// <param name="user"></param>
			/// <returns></returns>
			[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHDateTimeList")]
			[HttpGet]
			public object JIT_DayPlanPlatFormBillHDateTimeList(string sWhere)
			{
			try
			{
			MaterialShorAnalysis Report = JsonConvert.DeserializeObject<MaterialShorAnalysis>(sWhere);

			ds = oCN.RunProcReturn($"exec h_p_JIT_MaterialShorAnalysisReportList {Report.HORGID},'{Report.HBEGINDATE}','{Report.HENDDATE}' ", "h_p_JIT_PODemandPlanBill_ReportList");


			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			//objJsonResult.list = columnNameList;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region çäº§æ¥è®¡åå¹³å° ä¿å
			@@ -126,12 +163,15 @@

			public json AddBillMain(string msg1)
			{
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string[] sArray = msg1.Split(new string[] { "&å" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string user = sArray[1].ToString();

			try
			{
			Stopwatch sw = new Stopwatch();//è®¡æ¶å¨
			sw.Start();//å¼å§è®¡æ¶

			if (!DBUtility.ClsPub.Security_Log("Sc_WorkBillSortBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			@@ -141,6 +181,7 @@
			return objJsonResult;
			}

			LogService.CustomWriteLog("1:"+msg2, DateTime.Now.ToString("yyyy-MM-dd"));
			//JSONåºååè½¬æ¢åå¸éå
			List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
			List<object> jb = JsonConvert.DeserializeObject<List<object>>(msg2);
			@@ -154,16 +195,21 @@
			list.Add(dic);
			}

			LogService.CustomWriteLog("2:", DateTime.Now.ToString("yyyy-MM-dd"));
			int TrueCount = 0, SumCount = 0;
			LogService.CustomWriteLog("list.Count:"+ list.Count, DateTime.Now.ToString("yyyy-MM-dd"));

			string sReturn = "";
			oSystemParameter.ShowBill(ref sReturn);
			for (int i = 0; i < list.Count; i++)
			{
			{
			TrueCount = 0;
			SumCount = 0;
			long HInterID = 0;
			var HBillNo = "";
			if (list[i]["åæ®å·"].ToString() == "" && list[i]["hmainid"].ToString() == "")
			{
			LogService.CustomWriteLog("2.01:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
			var HICMOBillNo = list[i]["çäº§è®¢åå·"].ToString();
			var HOrderType = list[i]["è®¢åç±»å"].ToString();
			var HICMOEntrySEQ = list[i]["çäº§è®¢åæç»è¡å·"].ToString();
			@@ -173,13 +219,14 @@
			var HProdORGID = list[i]["HProdORGID"].ToString();
			var HMaterID = list[i]["HMaterID"].ToString();
			var HMaterName = list[i]["ç©æåç§°"].ToString();
			var HMaterModel = list[i]["è§æ ¼åå·"].ToString();
			var HMaterModel = list[i]["è§æ ¼åå·"].ToString().Replace("'", "''");
			var HUnitID = list[i]["HUnitID"].ToString();
			var HSeOrderBillQty = list[i]["éå®è®¢åæ°é"].ToString();
			//var HOrderNeedQty = list[i]["è®¢åéæ±æ°é"].ToString();
			var HSplitQty = list[i]["æåæ°é"].ToString();
			var HDayPlanSumQty = list[i]["æ¥è®¡åæ°éæ»é"].ToString();
			var HPlanBeginDate = list[i]["è®¡åå¼å§æ¥æ"].ToString();
			var HPlanEndDate = list[i]["è®¡åç»ææ¥æ"].ToString();
			var HSeOrderBillNo = list[i]["éå®è®¢åå·"].ToString();
			var HICMOBillType = list[i]["çäº§è®¢ååæ®ç±»å"].ToString();
			var HSourceStockInQty = list[i]["äº§çº¿å¥åºæ°é"].ToString();
			@@ -188,18 +235,27 @@
			var HMainSourceInterID = list[i]["æºåä¸»åç "].ToString();
			var HMainSourceEntryID = list[i]["æºåååç "].ToString();
			var HPlanQty = list[i]["è®¡åæ°é"].ToString();
			var HEmpID = list[i]["HEmpID"].ToString();
			var HWorkQty = list[i]["å°æ¶äº§è½"].ToString();
			var HSourceName = list[i]["çäº§èµæº"].ToString();
			var HWorkQty_ProdLine = list[i]["äº§çº¿æ»äº§è½"].ToString();

			if (HSourceID == ""\|\| HSourceID == "0")
			LogService.CustomWriteLog("2.05:" + i, DateTime.Now.ToString("yyyy-MM-dd"));

			if (oSystemParameter.omodel.WMS_CampanyName != "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºä¸è½ä¸ºç©º!";
			objJsonResult.data = null;
			return objJsonResult;
			if (HSourceID == "" \|\| HSourceID == "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºä¸è½ä¸ºç©º!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			ds = oCN.RunProcReturn($"select HInterID,HICMOBillNo from Sc_WorkBillSortBillMain with(nolock) where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID} and ISNULL(HDeleteMan,'')=''", "Sc_WorkBillSortBillMain");

			ds = oCN.RunProcReturn($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain");
			if (ds.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			@@ -213,58 +269,252 @@
			HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);//è·å¾ä¸ä¸ªæ°çåæ®å·
			HInterID = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//è·å¾ä¸ä¸ªæ°çid

			//ä¸»è¡¨
			oCN.RunProc("insert into Sc_WorkBillSortBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType," +
			string sql = $"insert into Sc_WorkBillSortBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType," +
			"HBillSubType,HDate,HBillStatus,HMaker,HMakeDate,HICMOBillNo,HOrderType," +
			"HICMOEntrySEQ,HWorkShopID,HSourceID, HYX, HProdORGID," +
			" HMaterID, HMaterName, HMaterModel, HUnitID, HSeOrderBillQty," +
			" HOrderNeedQty, HSplitQty, HDayPlanSumQty,HPlanBeginDate," +
			"HSeOrderBillNo,HICMOBillType,HSourceStockInQty,HLeftPlanQty,HOrderLev,HPreparatDate," +
			"HMainSourceInterID,HMainSourceEntryID,HICMOInterID_Sec,HICMOEntryID_Sec,HPlanQty)values" +
			"HMainSourceInterID,HMainSourceEntryID,HICMOInterID_Sec,HICMOEntryID_Sec,HPlanQty" +
			",HICMOInterID,HICMOEntryID,HPlanEndDate,HEmpID,HWorkQty,HSourceName,HWorkQty_ProdLine)values" +
			$"({HInterID},'{HBillNo}',{DateTime.Now.Year},{DateTime.Now.Month},'{BillType}'," +
			$"'{BillType}',GETDATE(),1,'{user}',getdate(),'{HICMOBillNo}','{HOrderType}'," +
			$"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID == "" ? 0.ToString() : HSourceID)}, {(HYX == "" ? 0.ToString() : HYX)}, {(HProdORGID == "" ? 0.ToString() : HProdORGID)}," +
			$" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}," +
			$" 0, {(HSplitQty == "" ? 0.ToString() : HSplitQty)}, {(HDayPlanSumQty == "" ? 0.ToString() : HDayPlanSumQty)},'{HPlanBeginDate}'," +
			$"'{HSeOrderBillNo}','{HICMOBillType}',{(HSourceStockInQty == "" ? 0.ToString() : HSourceStockInQty)},{(HLeftPlanQty == "" ? 0.ToString() : HLeftPlanQty)},'{HOrderLev}',getdate()," +
			$"{HMainSourceInterID},{HMainSourceEntryID},{HMainSourceInterID},{HMainSourceEntryID},{HPlanQty})");
			$"{HMainSourceInterID},{HMainSourceEntryID},{HMainSourceInterID},{HMainSourceEntryID},{HPlanQty}," +
			$"{HMainSourceInterID},{HMainSourceEntryID},'{HPlanEndDate}','{HEmpID}','{HWorkQty}','{HSourceName}','{HWorkQty_ProdLine}')";

			//LogService.Write("sql:" + sql);
			//ä¸»è¡¨
			oCN.RunProc(sql);
			}
			else
			{
			LogService.CustomWriteLog("2.0:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
			HBillNo = list[i]["åæ®å·"].ToString();
			HInterID = int.Parse(list[i]["hmainid"].ToString());
			var HMainSourceInterID = list[i]["æºåä¸»åç "].ToString();
			var HMainSourceEntryID = list[i]["æºåååç "].ToString();
			var HICMOBillNo = list[i]["çäº§è®¢åå·"].ToString();
			var HICMOEntrySEQ = list[i]["çäº§è®¢åæç»è¡å·"].ToString();
			var HSourceID = list[i]["HSourceID"].ToString();
			var HYX = list[i]["ä¼åçº§"].ToString();
			var HWorkQty = list[i]["å°æ¶äº§è½"].ToString();
			var HProdTimes = list[i]["çäº§å¨æ"].ToString();
			var HReadyTimes = list[i]["å¼å·¥ä½é"].ToString();
			var HLastBeginDate = list[i]["æè¿å¼å·¥æ¥æ"].ToString();
			var HLastEndDate = list[i]["æè¿å®å·¥æ¥æ"].ToString();
			var HOrderNeedQty = list[i]["è®¢åéæ±æ°é"].ToString();
			var HOrderCommitDate = list[i]["è®¢åäº¤è´§æ"].ToString();
			var HPlanEndDate = list[i]["è®¡åç»ææ¥æ"].ToString();
			var HSplitQty = list[i]["æåæ°é"].ToString();
			var HSourceName = list[i]["çäº§èµæº"].ToString();
			var HWorkQty_ProdLine = list[i]["äº§çº¿æ»äº§è½"].ToString();

			if (HSourceID == "" \|\| HSourceID == "0")
			var HOrderType = list[i]["è®¢åç±»å"].ToString();
			var HWorkShopID = list[i]["HWorkShopID"].ToString();
			var HProdORGID = list[i]["HProdORGID"].ToString();
			var HMaterID = list[i]["HMaterID"].ToString();
			var HMaterName = list[i]["ç©æåç§°"].ToString();
			var HMaterModel = list[i]["è§æ ¼åå·"].ToString().Replace("'", "''");
			var HUnitID = list[i]["HUnitID"].ToString();
			var HSeOrderBillQty = list[i]["éå®è®¢åæ°é"].ToString();
			var HDayPlanSumQty = list[i]["æ¥è®¡åæ°éæ»é"].ToString();
			var HPlanBeginDate = list[i]["è®¡åå¼å§æ¥æ"].ToString();
			var HSeOrderBillNo = list[i]["éå®è®¢åå·"].ToString();
			var HICMOBillType = list[i]["çäº§è®¢ååæ®ç±»å"].ToString();
			var HSourceStockInQty = list[i]["äº§çº¿å¥åºæ°é"].ToString();
			var HLeftPlanQty = list[i]["æªææ°é"].ToString();
			var HOrderLev = list[i]["è®¢åççº§"].ToString();
			var HPlanQty = list[i]["è®¡åæ°é"].ToString();
			var HEmpID = list[i]["HEmpID"].ToString();

			LogService.CustomWriteLog("2.1:"+i, DateTime.Now.ToString("yyyy-MM-dd"));

			if (oSystemParameter.omodel.WMS_CampanyName != "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			if (HSourceID == "" \|\| HSourceID == "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºä¸è½ä¸ºç©º!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			var str = 0;
			if (!int.TryParse(HYX, out str))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºä¸è½ä¸ºç©º!";
			objJsonResult.Message = $"ç¬¬{i + 1}è¡ä¼åçº§:{HYX},è¯·è¾å¥æ°å!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain");

			if (ds.Tables[0].Rows.Count > 1)
			if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºæéå¤,è¯·ä¿®æ¹!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//çæå å°çäº§èµæºååçäº§
			string[] HSourceNameArr = HSourceName.Split(new char[]{'&'});

			oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID == "" ? 0.ToString() : HSourceID)} where HInterID={list[i]["hmainid"].ToString()} and HBillNo='{list[i]["åæ®å·"].ToString()}'");
			if (HSourceNameArr.Length >= 2)
			{
			for (int s = 0; s < HSourceNameArr.Length; s++)
			{
			if (s == 0)
			{
			ds = oCN.RunProcReturn("select HItemID from Gy_Source with(nolock) where HName = '" + HSourceNameArr[s] + "'", "Gy_Source");

			var HSourceID_Child = ds.Tables[0].Rows[0]["HItemID"];

			oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID_Child == "" ? 0.ToString() : HSourceID_Child)}" +
			$",HYX={HYX},HWorkQty={HWorkQty},HProdTimes={HProdTimes},HReadyTimes={HReadyTimes},HLastBeginDate='{HLastBeginDate}'" +
			$",HLastEndDate='{HLastEndDate}',HOrderNeedQty={HOrderNeedQty},HOrderCommitDate='{HOrderCommitDate}'" +
			$",HPlanEndDate='{HPlanEndDate}',HSplitQty={HSplitQty},HSourceName='{HSourceName}',HWorkQty_ProdLine={HWorkQty_ProdLine}" +
			$" where HInterID={list[i]["hmainid"].ToString()} and HBillNo='{list[i]["åæ®å·"].ToString()}'");
			}
			else
			{
			ds = oCN.RunProcReturn("select HItemID from Gy_Source with(nolock) where HName = '" + HSourceNameArr[s] + "'", "Gy_Source");

			var HSourceID_Child = ds.Tables[0].Rows[0]["HItemID"];

			//æ°å¢ååçäº§èµæºçæäº§è®°å½
			ds = oCN.RunProcReturn($"select HInterID,HICMOBillNo from Sc_WorkBillSortBillMain with(nolock) where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID_Child}", "Sc_WorkBillSortBillMain");

			if (ds.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºæéå¤,è¯·ä¿®æ¹!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//æ°å¢åæ®å· id
			var HBillNo_New = DBUtility.ClsPub.CreateBillCode_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);//è·å¾ä¸ä¸ªæ°çåæ®å·
			var HInterID_New = DBUtility.ClsPub.CreateBillID_Prod(BillType, ref DBUtility.ClsPub.sExeReturnInfo);//è·å¾ä¸ä¸ªæ°çid

			string sql = $"insert into Sc_WorkBillSortBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType," +
			"HBillSubType,HDate,HBillStatus,HMaker,HMakeDate,HICMOBillNo,HOrderType," +
			"HICMOEntrySEQ,HWorkShopID,HSourceID, HYX, HProdORGID," +
			" HMaterID, HMaterName, HMaterModel, HUnitID, HSeOrderBillQty," +
			" HOrderNeedQty, HSplitQty, HDayPlanSumQty,HPlanBeginDate," +
			"HSeOrderBillNo,HICMOBillType,HSourceStockInQty,HLeftPlanQty,HOrderLev,HPreparatDate," +
			"HMainSourceInterID,HMainSourceEntryID,HICMOInterID_Sec,HICMOEntryID_Sec,HPlanQty" +
			",HICMOInterID,HICMOEntryID,HPlanEndDate,HEmpID,HWorkQty,HSourceName,HWorkQty_ProdLine,HRemark)values" +
			$"({HInterID_New},'{HBillNo_New}',{DateTime.Now.Year},{DateTime.Now.Month},'{BillType}'," +
			$"'{BillType}',GETDATE(),1,'{user}',getdate(),'{HICMOBillNo}','{HOrderType}'," +
			$"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID_Child == "" ? 0.ToString() : HSourceID_Child)}, {(HYX == "" ? 0.ToString() : HYX)}, {(HProdORGID == "" ? 0.ToString() : HProdORGID)}," +
			$" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}," +
			$" 0, {(HSplitQty == "" ? 0.ToString() : HSplitQty)}, {(HDayPlanSumQty == "" ? 0.ToString() : HDayPlanSumQty)},'{HPlanBeginDate}'," +
			$"'{HSeOrderBillNo}','{HICMOBillType}',{(HSourceStockInQty == "" ? 0.ToString() : HSourceStockInQty)},{(HLeftPlanQty == "" ? 0.ToString() : HLeftPlanQty)},'{HOrderLev}',getdate()," +
			$"{HMainSourceInterID},{HMainSourceEntryID},{HMainSourceInterID},{HMainSourceEntryID},{HPlanQty}," +
			$"{HMainSourceInterID},{HMainSourceEntryID},'{HPlanEndDate}','{HEmpID}','{HWorkQty}','{HSourceName}','{HWorkQty_ProdLine}','{"ååçäº§"}')";

			//LogService.Write("sql:" + sql);
			//ä¸»è¡¨
			oCN.RunProc(sql);

			//æå¥åè¡¨æ°æ®
			for (int j = 0; j < 180; j++)
			{
			//ä¸»è¡¨ææ°æ® åè¡¨æ æ°æ®
			//if (j == 180 - 1 && SumCount == 0 && HInterID_New != 0 && HBillNo_New != "")
			//{
			// objJsonResult = AddBillSub(HInterID_New.ToString(), HBillNo_New, DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd").ToString()), 0, list[i]);
			//}


			if (list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString() != "")
			{
			////ä¿ååè¡¨
			objJsonResult = AddBillSub(HInterID_New == 0 ? list[i]["hmainid"].ToString() : HInterID_New.ToString()
			, HBillNo_New == "" ? list[i]["åæ®å·"].ToString() : HBillNo_New
			, DateTime.Parse(DateTime.Now.AddDays(j).ToString("yyyy-MM-dd").ToString())
			, 0
			, list[i]);
			}
			}
			}
			}
			}
			else
			{
			ds = oCN.RunProcReturn($"select HInterID,HICMOBillNo from Sc_WorkBillSortBillMain with(nolock) where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", "Sc_WorkBillSortBillMain");

			if (ds.Tables[0].Rows.Count > 1)
			{
			LogService.CustomWriteLog("ç¬¬" + i + 1 + "è¡çäº§èµæºæéå¤,è¯·ä¿®æ¹", DateTime.Now.ToString("yyyy-MM-dd"));
			LogService.CustomWriteLog($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID}", DateTime.Now.ToString("yyyy-MM-dd"));
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºæéå¤,è¯·ä¿®æ¹!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			LogService.CustomWriteLog("2.2:" + i, DateTime.Now.ToString("yyyy-MM-dd"));

			oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID == "" ? 0.ToString() : HSourceID)},HYX={HYX}" +
			$",HWorkQty={HWorkQty},HProdTimes={HProdTimes},HReadyTimes={HReadyTimes},HLastBeginDate='{HLastBeginDate}'" +
			$",HLastEndDate='{HLastEndDate}',HOrderNeedQty={HOrderNeedQty},HOrderCommitDate='{HOrderCommitDate}',HPlanEndDate='{HPlanEndDate}',HSplitQty={HSplitQty},HSourceName='{HSourceName}',HWorkQty_ProdLine={HWorkQty_ProdLine}" +
			$" where HInterID={list[i]["hmainid"].ToString()} and HBillNo='{list[i]["åæ®å·"].ToString()}'");
			}
			}
			else
			{
			ds = oCN.RunProcReturn($"select HInterID,HICMOBillNo from Sc_WorkBillSortBillMain with(nolock) where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID} and ISNULL(HDeleteMan,'') = ''", "Sc_WorkBillSortBillMain");

			if (ds.Tables[0].Rows.Count > 1)
			{
			LogService.CustomWriteLog("ç¬¬" + i + 1 + "è¡çäº§èµæºæéå¤,è¯·ä¿®æ¹", DateTime.Now.ToString("yyyy-MM-dd"));
			LogService.CustomWriteLog($"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" +
			$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID} and ISNULL(HDeleteMan,'')=''", DateTime.Now.ToString("yyyy-MM-dd"));
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = $"ç¬¬{i + 1}è¡çäº§èµæºæéå¤,è¯·ä¿®æ¹!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			LogService.CustomWriteLog("2.2:" + i, DateTime.Now.ToString("yyyy-MM-dd"));

			oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID == "" ? 0.ToString() : HSourceID)},HYX={HYX}" +
			$",HWorkQty={HWorkQty},HProdTimes={HProdTimes},HReadyTimes={HReadyTimes},HLastBeginDate='{HLastBeginDate}'" +
			$",HLastEndDate='{HLastEndDate}',HOrderNeedQty={HOrderNeedQty},HOrderCommitDate='{HOrderCommitDate}',HPlanEndDate='{HPlanEndDate}',HSplitQty={HSplitQty},HSourceName='{HSourceName}',HWorkQty_ProdLine={HWorkQty_ProdLine}" +
			$" where HInterID={list[i]["hmainid"].ToString()} and HBillNo='{list[i]["åæ®å·"].ToString()}'");
			}
			}

			oCN.RunProc($"update Sc_WorkBillSortBillMain set HDayPlanSumQty={list[i]["æ¥è®¡åæ°éæ»é"].ToString()} where HInterID={(HInterID==0?int.Parse(list[i]["hmainid"].ToString()):HInterID)} and HBillNo='{(HBillNo==""?list[i]["åæ®å·"].ToString(): HBillNo)}'");

			int SumDay = 31; //å¨æä¸¤æä¹å·® DateTime.Now.AddMonths(1).AddDays(-1).Subtract(DateTime.Now).Days;
			int SumDay = 0; //å¨æä¸¤æä¹å·® DateTime.Now.AddMonths(1).AddDays(-1).Subtract(DateTime.Now).Days;

			// ç»è®¡æ»å¤©æ°
			HashSet<DateTime> uniqueDates = new HashSet<DateTime>();

			foreach (var key in list[i].Keys)
			{
			if (DateTime.TryParseExact(key, "yyyy-M-d", CultureInfo.InvariantCulture, DateTimeStyles.None, out DateTime date))
			{
			uniqueDates.Add(date);
			}
			}

			SumDay = uniqueDates.Count;

			if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			SumDay = 180;
			}

			LogService.CustomWriteLog("2.3:" + i, DateTime.Now.ToString("yyyy-MM-dd"));
			for (int j = 0; j < SumDay; j++)
			{
			//ä¸»è¡¨åè¡¨é½ææ°æ®
			@@ -275,32 +525,43 @@
			objJsonResult = AddBillSub(HInterID == 0 ? list[i]["hmainid"].ToString() : HInterID.ToString()
			, HBillNo == "" ? list[i]["åæ®å·"].ToString() : HBillNo
			, DateTime.Parse(DateTime.Now.AddDays(j).ToString("yyyy-MM-dd").ToString())
			, int.Parse(list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString()));

			, Math.Round(double.Parse(list[i][DateTime.Now.AddDays(j).ToString("yyyy-MM-dd")].ToString()),1)
			, list[i]);
			if (objJsonResult.count == 1)
			{
			TrueCount += 1;
			}
			}
			//ä¸»è¡¨ææ°æ® åè¡¨æ æ°æ®
			if (j == 30 && SumCount == 0 && HInterID != 0 && HBillNo != "")
			if (j == SumDay-1 && SumCount == 0 && HInterID != 0 && HBillNo != "")
			{
			objJsonResult = AddBillSub(HInterID.ToString(), HBillNo, DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd").ToString()), 0);
			//LogService.CustomWriteLog("3:"+ HInterID+","+ HBillNo, DateTime.Now.ToString("yyyy-MM-dd"));
			objJsonResult = AddBillSub(HInterID.ToString(), HBillNo, DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd").ToString()), 0, list[i]);
			}
			}

			LogService.CustomWriteLog("2.4:" + i, DateTime.Now.ToString("yyyy-MM-dd"));

			if (TrueCount != SumCount)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}


			}

			if (TrueCount != SumCount)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = objJsonResult.Message;
			objJsonResult.data = null;
			return objJsonResult;
			}
			LogService.CustomWriteLog("2.5:", DateTime.Now.ToString("yyyy-MM-dd"));

			//åæ¥æ¥è®¡åå·¥å
			oCN.RunProc("exec REALESE_SC_ICMOBILLSTATUS_TMP");

			LogService.CustomWriteLog("2.6:", DateTime.Now.ToString("yyyy-MM-dd"));
			sw.Stop();//ç»æè®¡æ¶
			LogService.Write($"========================1.æäº§è®¢åæ»ç¨æ¶ï¼" + sw.Elapsed);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -318,33 +579,70 @@
			}
			}

			public json AddBillSub(string HInterID, string HBillNo, DateTime date, int HQTY)
			public json AddBillSub(string HInterID, string HBillNo, DateTime date, double HQTY, Dictionary<string, string> dic)
			{
			//è·åè¡¨æ ¼æ°æ®
			ds = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where åæ®å·='{HBillNo}'", "h_v_JIT_Sc_WorkBillSortBillList");
			string sReturn = "";
			oSystemParameter.ShowBill(ref sReturn);

			//è·åè¡¨æ ¼æ°æ®
			ds = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBill_PC where åæ®å·='{HBillNo}'", "h_v_JIT_Sc_WorkBillSortBill_PC");
			int count = 0;
			if (ds.Tables[0].Rows.Count > 0)
			{
			//å¤æåè¡¨æ¯å¦æå½æ¥çæ¥æä»¥åæ¥ææå¯¹åºçæ°é
			for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
			if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			if (DateTime.Parse(ds.Tables[0].Rows[i]["æ¥è®¡åçäº§æ¥æ"].ToString()) == date)
			//å¤æåè¡¨æ¯å¦æå½æ¥çæ¥æä»¥åæ¥ææå¯¹åºçæ°é
			for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
			{
			oCN.RunProc($"update Sc_WorkBillSortBillSub set HMasterDate='{date}',HQty={HQTY}" +
			$" where HInterID={HInterID} and HEntryID={ds.Tables[0].Rows[i]["hsubid"].ToString()}");
			count += 1;
			if (DateTime.Parse(ds.Tables[0].Rows[i]["æ¥è®¡åçäº§æ¥æ"].ToString()) == date)
			{
			oCN.RunProc($"update Sc_WorkBillSortBillSub set HMasterDate='{date}',HQty={HQTY},HUseTimes={(dic["äº§çº¿æ»äº§è½"] == "0" ? 0 : HQTY / float.Parse(dic["äº§çº¿æ»äº§è½"].ToString()))}" +
			$" where HInterID={HInterID} and HEntryID={ds.Tables[0].Rows[i]["hsubid"].ToString()}");
			count += 1;
			}
			}
			}
			else
			{
			//å¤æåè¡¨æ¯å¦æå½æ¥çæ¥æä»¥åæ¥ææå¯¹åºçæ°é
			for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
			{
			if (DateTime.Parse(ds.Tables[0].Rows[i]["æ¥è®¡åçäº§æ¥æ"].ToString()) == date)
			{
			oCN.RunProc($"update Sc_WorkBillSortBillSub set HMasterDate='{date}',HQty={HQTY},HUseTimes={(dic["å°æ¶äº§è½"] == "0" ? 0 : HQTY / float.Parse(dic["å°æ¶äº§è½"].ToString()))}" +
			$" where HInterID={HInterID} and HEntryID={ds.Tables[0].Rows[i]["hsubid"].ToString()}");
			count += 1;
			}
			}
			}
			}


			if (count != 1)
			{
			//æå¥åè¡¨
			oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ," +
			"HMasterDate,HQty)" +
			$"values({HInterID}, {(ds.Tables[0].Rows.Count + 1)}," +
			$" '{date}', {HQTY})");
			if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			//æå¥åè¡¨
			oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ," +
			"HMasterDate,HQty,HUseTimes)" +
			$"values({HInterID}, {(ds.Tables[0].Rows.Count + 1)}," +
			$" '{date}', {HQTY},{ ((dic["äº§çº¿æ»äº§è½"] == "0.0000" ? 0 : dic["äº§çº¿æ»äº§è½"] == "0" ? 0 : HQTY / float.Parse(dic["äº§çº¿æ»äº§è½"].ToString())).ToString() == "éæ°å" ? 0 : dic["äº§çº¿æ»äº§è½"] == "0.0000" ? 0 : dic["äº§çº¿æ»äº§è½"] == "0" ? 0 : HQTY / float.Parse(dic["äº§çº¿æ»äº§è½"].ToString())) })");
			}
			else
			{
			//æå¥åè¡¨
			oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ," +
			"HMasterDate,HQty,HUseTimes)" +
			$"values({HInterID}, {(ds.Tables[0].Rows.Count + 1)}," +
			$" '{date}', {HQTY},{ ((dic["å°æ¶äº§è½"] == "0.0000" ? 0 : dic["å°æ¶äº§è½"] == "0" ? 0 : HQTY / float.Parse(dic["å°æ¶äº§è½"].ToString())).ToString() == "éæ°å" ? 0 : dic["å°æ¶äº§è½"] == "0.0000" ? 0 : dic["å°æ¶äº§è½"] == "0" ? 0 : HQTY / float.Parse(dic["å°æ¶äº§è½"].ToString())) })");
			}
			}


			if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			//ææäº§è®¢åå®å·¥æ¥æååå°éè¶éå®è®¢åä¸
			string sql = "exec h_p_JIT_UpdateEndDateToERP " + HInterID + ",'" + HBillNo + "'";
			oCN.RunProc(sql);
			}

			objJsonResult.code = "1";
			@@ -514,6 +812,14 @@
			/// ä»åºç¼ç
			/// </summary>
			public string FStockNumber { get; set; }
			/// <summary>
			/// æ¹å·
			/// </summary>
			public string HLOT { get; set; }
			/// <summary>
			/// id
			/// </summary>
			public string HInventoryFID { get; set; }
			}
			#endregion

			@@ -677,13 +983,16 @@
			public string FStock { get; set; }
			//è½¦é´
			public string FWorkShop { get; set; }
			//æ¹å·
			public string HLOT { get; set; }
			public string HInventoryFID { get; set; }

			}
			#endregion

			[Route("JIT_DayPlanPlatFormBill/JIT_CompleteSetAnalysis")]
			[HttpGet]
			public object JIT_CompleteSetAnalysis(string sWhere, string user)
			#region é½å¥åæ åè°ç¨æ¹æ³

			public object JIT_CompleteSetAnalysis_Old(string sWhere, string user)
			{
			try
			{
			@@ -691,9 +1000,22 @@
			omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);
			string sql = $"exec JIT_qtfx {omdelMian.HProdORGID},{omdelMian.HWorkShopID},'{user}' ";
			ds = oCN.RunProcReturn(sql, "JIT_qtfx");
			LogService.Write("é½å¥åæsql:" + sql);
			//LogService.Write("é½å¥åæsql:" + sql);
			List<PRD_PPBOM> BomList = new List<PRD_PPBOM>();
			DataTable resulTable = ds.Tables[0];

			if (ds.Tables[0].Rows.Count < 1 \|\| ds == null)
			{
			//éæ¾é½å¥æä½ é¿åå¤äººåæ¶è¿è¡é½å¥åæ
			oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "æ²¡æéè¦è¿è¡é½å¥åæçæ°æ®";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (resulTable.Rows[0][0].ToString().Contains("å¤±è´¥"))
			{
			//éæ¾é½å¥æä½ é¿åå¤äººåæ¶è¿è¡é½å¥åæ
			@@ -730,26 +1052,15 @@
			fDayPlanFids = string.Join(",", fidList);
			fDayPlanFEntryids = string.Join(",", fentryidList);
			}
			LogService.Write("æ¥è®¡åå·¥åids" + fDayPlanFids);
			//LogService.Write("æ¥è®¡åå·¥åids" + fDayPlanFids);

			sw.Start();//å¼å§è®¡æ¶

			//è·åå½åå³æ¶åºå åºåæ°é+åºåç»ç»+ç©æ+è´§ä¸»+ä»åº
			//åæ¥è¯¢å³æ¶åºåæ¹å¼ï¼select * from h_v_jit_InventoryList
			ds = oCN.RunProcReturn(@"
			select distinct isnull(a.FBASEQTY,0) FBASEQTY,b.FNumber,a.FOwnerTypeId,a.FOwnerId,c.FNUMBER as FOwnerNumber,a.FSTOCKID,d.FNUMBER as FStockNumber from
			(
			select distinct a.HProdORGID FStockOrgId,T2.FMATERIALID,FNumber from SC_WORKBILLSORTBILLMAIN a
			join SC_WORKBILLSORTBILLSub b on a.HInterID = b.HInterID
			join AIS20210811135644..T_PRD_PPBOM T1 on a.HICMOInterID_Sec = t1.FMoId and a.HICMOEntryID_Sec = t1.FMOENTRYID
			LEFT JOIN AIS20210811135644..T_PRD_PPBOMENTRY T2 on T1.FID = t2.FID
			join AIS20210811135644..T_BD_MATERIAL T3 on T2.FMATERIALID = T3.FMATERIALID
			) T1
			JOIN AIS20210811135644..T_BD_MATERIAL b on t1.FNUMBER = b.FNUMBER
			LEFT JOIN AIS20210811135644..T_STK_Inventory a on b.FMATERIALID = a.FMATERIALID
			LEFT join (select distinct fitemid,fformid,FNUMBER from AIS20210811135644..V_ITEMCLASS_OWNER) c on a.FOwnerTypeId = c.fformid and a.FOWNERID = c.fitemid
			join AIS20210811135644..t_BD_Stock d on a.FSTOCKID =d.FSTOCKID
			where a.FBASEQTY>0
			", "SC_WORKBILLSORTBILLMAIN");
			exec h_p_jit_Inventory_UsableList
			", "h_p_jit_Inventory_UsableList");
			ListInventory = ds.ToModelList<PRD_Inventory>();
			//è½¦é´ ä»åºå¯¹ç§åè¡¨
			ds = oCN.RunProcReturn(@"
			@@ -761,38 +1072,26 @@
			//æ¥è®¡å+çäº§è®¢ååè¡¨ç¼ç ID
			var DatePlanList = BomList.GroupBy(p => new { p.HMasterDate, p.HICMOEntryID_Sec }).Select(x => new PRD_PPBOM { HMasterDate = x.Key.HMasterDate, HICMOEntryID_Sec = x.Key.HICMOEntryID_Sec }).ToList();
			//ååºåæ°é FMustQty ä¸è¦åå¼éæ±æ°éFNeedQty é¢ææ°æ®
			string LLsql = string.Format(@"
			select max(t1.FCXStockInQty)FCXStockInQty,FPRDMOENTYID,max(dwyl)dwyl,sum(FPickedQty)FPickedQty,sum(FRemainPickedQty)FRemainPickedQty,FMATERIALID from
			(
			select a.FCXStockInQty, FPRDMOENTYID,convert( decimal(18,2),FMustQty/FQty ) as dwyl,FPickedQty,T2.FMATERIALID,
			case when convert( decimal(18,2),(FPickedQty - a.FCXStockInQty * FMustQty/FQty))< 0 then 0
			else convert( decimal(18,2),(FPickedQty - a.FCXStockInQty * FMustQty/FQty)) end as FRemainPickedQty
			from
			(
			select sum(HSourceStockInQty)FCXStockInQty,HICMOEntryID_Sec FPRDMOENTYID from SC_WORKBILLSORTBILLMAIN a
			where a.HInterID IN ({0})
			group by HICMOEntryID_Sec
			) a
			join AIS20210811135644..T_PRD_PPBOM T1 on a.FPRDMOENTYID = t1.FMOENTRYID
			LEFT JOIN AIS20210811135644..T_PRD_PPBOMENTRY t2 on T1.FID = T2.FID
			LEFT JOIN AIS20210811135644..T_PRD_PPBOMENTRY_Q t3 on t2.FENTRYID = T3.FENTRYID
			LEFT JOIN AIS20210811135644..T_BD_MATERIAL T4 ON T2.FMATERIALID = T4.FMATERIALID
			) t1
			group by FPRDMOENTYID,FMATERIALID
			", fDayPlanFids);
			string LLsql = string.Format(@"exec h_p_jit_PPBOMList '{0}'", fDayPlanFids);
			List<DayPlanPickedModel> DayPlanPickedModel = new List<DayPlanPickedModel>();
			//LogService.Write("LLsql:" + LLsql);
			ds = oCN.RunProcReturn(LLsql, "SC_WORKBILLSORTBILLMAIN");
			//LogService.Write(JsonConvert.SerializeObject(ds));
			DayPlanPickedModel = ds.ToModelList<DayPlanPickedModel>();
			//LogService.Write(JsonConvert.SerializeObject(DayPlanPickedModel));
			//CompleteAnalysisTempModel ç¨äºåå¨ä¸´æ¶éè¦æå¥æ°æ®
			List<CompleteAnalysisTempModel> completeAnalysisTempModel = new List<CompleteAnalysisTempModel>();
			//åå»ºåå¸ ç¨äºå¨åç©æ + å ç¨æ°é
			Dictionary<string, decimal> occupyDic = new Dictionary<string, decimal>();
			LogService.Write($"é½å¥åæï¼æ°æ®åå¤é¶æ®µï¼ç¨æ¶" + sw.Elapsed + "æ»è¡æ°ï¼" + BomList.Count);
			LogService.Write($"é½å¥åæï¼æ°æ®åå¤é¶æ®µï¼ç¨æ¶" + sw.Elapsed + "æ»éè¦å¾ªç¯çbomæ°éï¼" + DatePlanList.Count);
			//LogService.Write($"é½å¥åæï¼æ°æ®åå¤é¶æ®µï¼ç¨æ¶" + sw.Elapsed + "æ»è¡æ°ï¼" + BomList.Count);
			//LogService.Write($"é½å¥åæï¼æ°æ®åå¤é¶æ®µï¼ç¨æ¶" + sw.Elapsed + "æ»éè¦å¾ªç¯çbomæ°éï¼" + DatePlanList.Count);

			//ç¬¬ä¸ä¸ªå¾ªç¯ æ¥è®¡åå·¥åæç» ä¸å¤©+ä¸ä¸ªå·¥å ä¸ä¸ªå¾ªç¯
			int o = 0;
			foreach (var item in DatePlanList)
			{
			o++;
			//LogService.Write("å¾ªç¯:" + o);
			//æ¥è®¡åç¨ææ¸åæç» æ¯ä¸å¤©çå®éç¨ææåµ
			var _BomList = BomList.Where(x => x.HMasterDate == item.HMasterDate && x.HICMOEntryID_Sec == item.HICMOEntryID_Sec).ToList();
			//æ¯ä¸ä¸ªç©æè¿è¡åºåè®¡ç®
			@@ -828,8 +1127,9 @@
			decimal planNeed = _item.PlanCount; //ä¸åä¸è®¡ç® ç¨äºè®°å½
			decimal need = _item.PlanCount;//åä¸è®¡ç®
			decimal FOccupyPickedCount = 0;//å ç¨é¢æåæ°é
			//æ¾å°é¢ç¨æ°é
			//æ¾å°é¢ç¨æ°é
			var _DayPlanPickedModel = DayPlanPickedModel.Where(c => c.FPRDMOENTYID == _item.HICMOEntryID_Sec && c.FMATERIALID == _item.FMATERIALID2).FirstOrDefault();

			if (_DayPlanPickedModel.FRemainPickedQty >= need)
			{
			//é¢ææ°éæ»¡è¶³äºå½åè¿ä¸ªéæ±é ç´æ¥é½å¥ ä¸éè¦å»å ç¨ä»åº
			@@ -860,19 +1160,24 @@
			});
			//æ£é¤å©ä½å¯ç¨é¢ææ°é
			_DayPlanPickedModel.FRemainPickedQty -= need;
			//LogService.Write($"h" + need);
			//å¾ªç¯ä¸ä¸ä¸ªç©æ
			continue;
			}
			else
			{
			//LogService.Write($"kxs" + need);
			need -= _DayPlanPickedModel.FRemainPickedQty; //å©ä½éæ±æ°é
			//LogService.Write($"i1" + need);
			FOccupyPickedCount = _DayPlanPickedModel.FRemainPickedQty;
			_DayPlanPickedModel.FRemainPickedQty = 0;
			//LogService.Write($"i" + need);
			}
			if (_pRD_WorkHouseCompar.Count > 0)
			{
			//ç¼ºææ°é éæ±æ°é - å®éåºå >0 ? ä¸ä¸ªç©æä¸ç®¡å ç¨å¤å°æ¡ åºå+è´§ä¸» æ°æ® ç¼ºææ°éæ¯åä¸ä¸ªæ°é
			decimal _fLackCount = need > jskcQty ? (need - jskcQty) : 0;
			//LogService.Write($"j" + _fLackCount);
			//LogHelper.Info("ç»ç»ï¼" + _item.FStockOrgId + " ,åæ¶åºå" + jskcQty);
			//æ»åºåä¸º0äº ç´æ¥ç»åº ç¼ºææ°é
			if (jskcQty == 0)
			@@ -905,6 +1210,8 @@
			//ç»æ¢è¯¥ç©æè®¡ç® è¿å¥ä¸ä¸ä¸ª
			continue;
			}

			//LogService.Write($"k" + 2);
			foreach (var WorkHouse in _pRD_WorkHouseCompar)
			{
			//åºåæ°æ®å¹é
			@@ -954,7 +1261,9 @@
			FComPlete = jskcQty >= need ? "é½å¥" : "æªé½å¥",
			FPlanDate = item.HMasterDate, // æ¥è®¡åæ¥æ
			FStock = Inventory.FSTOCKID,//ä»åº
			FWorkShop = _item.HWorkShopID //è½¦é´
			FWorkShop = _item.HWorkShopID, //è½¦é´
			HLOT = Inventory.HLOT, //æ¹å·
			HInventoryFID = Inventory.HInventoryFID //id
			});
			//æ£åæ»åºåæ°é
			jskcQty = jskcQty >= fCompleteCount ? jskcQty - fCompleteCount : 0;
			@@ -1003,7 +1312,7 @@
			//Thread.Sleep(6000);
			i++;
			}
			LogService.Write($"é½å¥åæï¼æ°æ®åå¤å®æï¼ä¿åå°Modelå®ä½ï¼æ»è¡æ°ï¼{completeAnalysisTempModel.Count}ï¼èæ¶ï¼" + sw.Elapsed);
			//LogService.Write($"é½å¥åæï¼æ°æ®åå¤å®æï¼ä¿åå°Modelå®ä½ï¼æ»è¡æ°ï¼{completeAnalysisTempModel.Count}ï¼èæ¶ï¼" + sw.Elapsed);
			List<string> sqlList = new List<string>();
			DataTable insertDT = new DataTable();
			insertDT.TableName = "JIT_MOMaterReadysBill";
			@@ -1033,6 +1342,8 @@
			insertDT.Columns.Add("FWORKSHOPID", typeof(long));
			insertDT.Columns.Add("FSTOCKID", typeof(long));
			insertDT.Columns.Add("FOCCUPYPICKEDCOUNT", typeof(decimal));
			insertDT.Columns.Add("HLOT", typeof(long));
			insertDT.Columns.Add("HInventoryFID", typeof(string));
			int jdtmmm = 1;
			ds = oCN.RunProcReturn("select max(HInterID)FID FROM JIT_MOMaterReadysBill", "JIT_MOMaterReadysBill");
			int maxFid = int.Parse(ds.Tables[0].Rows[0][0].ToString() == "" ? "0" : ds.Tables[0].Rows[0][0].ToString());
			@@ -1065,6 +1376,8 @@
			dr["FWORKSHOPID"] = item.FWorkShop == null ? "0" : item.FWorkShop;
			dr["FSTOCKID"] = item.FStock == null ? "0" : item.FStock;
			dr["FOCCUPYPICKEDCOUNT"] = item.FOccupyPickedCount;
			dr["HLOT"] = item.HLOT == null? "0" : item.HLOT;
			dr["HInventoryFID"] = item.HInventoryFID == null ? "0" : item.HInventoryFID;
			insertDT.Rows.Add(dr);
			jdtmmm++;
			}
			@@ -1080,14 +1393,16 @@
			", HICMOEntryID, HMaterID, HStockORGID, HStockQty, HLeftQty" +
			", HProdORGID, HUnitDosage, HSumPlanQty, HICMOBillNo, HOwnerID" +
			", HOwnerTypeID, HPlanDate, HComplete, HLackQty, HOccupyQty" +
			", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY,HMainICMOBillNo)values" +
			", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY,HMainICMOBillNo" +
			",HLOT,HInventoryFID)values" +
			$"({item["FID"].ToString()}, 1, {item["FHMAINICMOINTERIDR"].ToString()}, {item["FHMAINICMOENTRYID"].ToString()}, {item["FHICMOINTERID"].ToString()}" +
			$", {item["FHICMOENTRYID"].ToString()}, {item["FHMATERID"].ToString()}, {item["FHSTOCKORGID"].ToString()}, {item["FHSTOCKQTY"].ToString()}, {item["FHLEFTQTY"].ToString()}" +
			$" , {item["FHPRDORGID"].ToString()}, {item["FUNITDOSAGE"].ToString()}, {item["FSUMPLANCOUNT"].ToString()}, '{item["FPRDBILLNO"].ToString()}', {item["FOWNERID"].ToString()}" +
			$", '{item["FOWNERTYPEID"].ToString()}', '{item["FPLANDATE"].ToString()}','{item["FCOMPLETE"].ToString()}', {item["FLACKCOUNT"].ToString()}, {item["FOCCUPYCOUNT"].ToString()}" +
			$", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()}, '{item["HMainICMOBillNo"].ToString()}')");
			$", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()}, '{item["HMainICMOBillNo"].ToString()}'" +
			$",{item["HLOT"].ToString()},'{item["HInventoryFID"].ToString()}')");
			}
			LogService.Write("æ¹éæå¥å°æ°æ®åºç¨æ¶ï¼" + sw.Elapsed);
			//LogService.Write("æ¹éæå¥å°æ°æ®åºç¨æ¶ï¼" + sw.Elapsed);
			//æ§è¡å®æå æ´æ°æ¥è®¡åå·¥åç¶æ
			string updatesql = string.Format(@"
			update Sc_WorkBillSortBillSub set HComplete = 'æªé½å¥' where HEntryID IN
			@@ -1106,7 +1421,7 @@
			//éæ¾é½å¥æä½ é¿åå¤äººåæ¶è¿è¡é½å¥åæ
			oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");
			sw.Stop();//ç»æè®¡æ¶
			LogService.Write("é½å¥åæè¿è¡æ»æ¶é¿ï¼" + sw.Elapsed);
			//LogService.Write("é½å¥åæè¿è¡æ»æ¶é¿ï¼" + sw.Elapsed);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -1124,6 +1439,1538 @@
			return objJsonResult;
			}
			}

			#endregion

			#region é½å¥åæè°ç¨æ¹æ³ 20250402

			[Route("JIT_DayPlanPlatFormBill/JIT_CompleteSetAnalysis")]
			[HttpGet]
			public object JIT_CompleteSetAnalysis(string sWhere, string user)
			{
			try
			{
			string sErrMsg = "";
			if (oSystemParameter.ShowBill(ref sErrMsg) == true)
			{
			if (oSystemParameter.omodel.WMS_CampanyName == "å¸å¨"
			\|\| oSystemParameter.omodel.WMS_CampanyName == "å¯è´å¥ç¹"
			\|\| oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ"
			\|\| oSystemParameter.omodel.WMS_CampanyName == "å®å·¥") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			objJsonResult = (json)JIT_CompleteSetAnalysis_Old(sWhere, user);
			}
			else
			{
			objJsonResult = (json)JIT_CompleteSetAnalysis_New(sWhere, user);
			}
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è·åç³»ç»åæ°å¤±è´¥ï¼ " + sErrMsg;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			LogService.Write("é½å¥åææä½å¤±è´¥ï¼" + e.Message.ToString());
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.Message.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// é½å¥åæ æ°è°ç¨æ¹æ³
			/// </summary>
			/// <returns></returns>
			public object JIT_CompleteSetAnalysis_New(string sWhere, string user)
			{
			try
			{
			omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);
			string HWorkShopID = omdelMian.HWorkShopID.ToString();
			var HStockOrgID = omdelMian.HProdORGID;

			ds = oCN.RunProcReturn("exec h_p_JIT_CompleteSetAnalysis " + HWorkShopID.ToString() + ",'" + user + "'," + HStockOrgID.ToString(), "h_p_JIT_CompleteSetAnalysis");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "é½å¥åæåçéè¯¯ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); //è¿ç®æå
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "é½å¥åæå¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			#endregion

			#endregion

			#region çäº§æ¥è®¡åå¹³å° ææè¿ç®

			#region æ¥è®¡åå±å¼æ°æ®æç»
			public class DayPlanPpbom
			{

			/// <summary>
			/// æ¥è®¡åå·¥åä¸»ID
			/// </summary>
			public long FID { get; set; }
			/// <summary>
			/// çäº§è®¢åå·
			/// </summary>
			public string FBILLNO { get; set; }
			/// <summary>
			/// æ¥è®¡åæç»æ¥æ
			/// </summary>
			public DateTime FHMASTERDATE { get; set; }
			/// <summary>
			/// æ¥è®¡åæç»æ°é
			/// </summary>
			public decimal FHQTY { get; set; }
			/// <summary>
			/// é½å¥æ°
			/// </summary>
			public decimal FCOMPLETECOUNT { get; set; }
			/// <summary>
			/// çäº§è®¢åå·¥åID
			/// </summary>
			public long FPRDMOMAINID { get; set; }
			/// <summary>
			/// åè¡¨ID
			/// </summary>
			public int FENTRYID { get; set; }
			/// <summary>
			/// åä½ç¨æ
			/// </summary>
			public decimal FNeedQty { get; set; }
			/// <summary>
			/// ç©æID
			/// </summary>
			public string FMATERIALID { get; set; }
			/// <summary>
			/// æåå¤©æ°
			/// </summary>
			public int FFIXLEADTIME { get; set; }
			/// <summary>
			///æå¤§åè£
			/// </summary>
			public decimal FMAXPOQTY { get; set; }
			/// <summary>
			/// æå°åè£é
			/// </summary>
			public decimal FMINPOQTY { get; set; }
			/// <summary>
			/// ç©æç¼ç
			/// </summary>
			public string FNumber { get; set; }
			/// <summary>
			/// å®ééæ±
			/// </summary>
			public decimal NeedQty { get; set; }

			/// <summary>
			/// åºåç»ç»
			/// </summary>
			public long FStockOrgId { get; set; }
			//åºåç»ç»åç§°
			public string FStockOrgName { get; set; }
			/// <summary>
			/// jitç©æåç±»
			/// </summary>
			public string FJITmaterialGroup { get; set; }
			/// <summary>
			/// JITç©æéæ±ä¾è´§å¨æ
			/// </summary>
			public string FJITMaterielDemand { get; set; }
			/// <summary>
			/// JITå®å¨åºå
			/// </summary>
			public string FJITSafeStock { get; set; }

			/// <summary>
			/// ç©æå±æ§
			/// </summary>
			public string FErpClsID { get; set; }
			/// <summary>
			/// éæ±åå·ï¼éå®è®¢åå·ï¼
			/// </summary>
			public string FXQD { get; set; }
			/// <summary>
			/// æ¥è®¡åå·¥ååå·
			/// </summary>
			public string FDAYPLANBILLNO { get; set; }
			/// <summary>
			/// çäº§è½¦é´ç¼ç
			/// </summary>
			public string FWORKSHOPNUMBER { get; set; }


			}
			#endregion

			#region éè´è®¢åç©æåºå
			public class PurchaseInventory
			{
			/// <summary>
			/// éè´FID
			/// </summary>
			public long FID { get; set; }
			//éè´è®¢ååå·
			public string FBillNo { get; set; }
			/// <summary>
			/// éè´åè¡¨æ è¯
			/// </summary>
			public long FENTRYID { get; set; }
			/// <summary>
			/// ä¾åºåid
			/// </summary>
			public long FSUPPLIERID { get; set; }
			/// <summary>
			/// ä¾åºååç§°
			/// </summary>
			public string FNUMBER { get; set; }
			/// <summary>
			/// ç©æID
			/// </summary>
			public string FMATERIALID { get; set; }
			/// <summary>
			/// ç©æç¼ç
			/// </summary>
			public string FMATERIALNUMBER { get; set; }

			/// <summary>
			/// éè´æ°é
			/// </summary>
			public decimal FQTY { get; set; }

			/// <summary>
			/// éè´ç»ç»
			/// </summary>
			public long FStockOrgId { get; set; }
			/// <summary>
			/// éè´ç»ç»åç§°
			/// </summary>
			public string FStockOrgName { get; set; }
			/// <summary>
			/// ç»ç»ç¼ç
			/// </summary>
			public string FORGNumber { get; set; }
			/// <summary>
			/// æåæ
			/// </summary>
			public int FFIXLEADTIME { get; set; }

			/// <summary>
			/// éæ±åå·
			/// </summary>
			public string FXQD { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çåå»ºäºº
			/// </summary>
			public string FCREATORID { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çåå»ºäººåç§°
			/// </summary>
			public string FName { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çéè´æ¥æ
			/// </summary>
			public DateTime FDate { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çäº¤è´§æ¥æ
			/// </summary>
			public DateTime FDeliveryDate { get; set; }
			/// <summary>
			/// éè´è®¢åè¡¨å¤´æè¦
			/// </summary>
			public string F_QIMB_NOTE { get; set; }
			/// <summary>
			/// éè´è®¢åè¡¨ä½å¤æ³¨
			/// </summary>
			public string FNOTE { get; set; }
			//éè´é¨é¨
			public string FPURCHASEDEPTNUMBER { get; set; }

			/// <summary>
			/// æ¶æä½æ¯æ²¡å¥åºé¨å éè¦ä¼åå»æ£é¤
			/// </summary>
			public decimal FReceiveNotInQty { get; set; }
			/// <summary>
			/// éè´è®¢åæ°é
			/// </summary>
			public decimal FPURCHASEQTY { get; set; }
			/// <summary>
			/// éè´è®¢åå³èæ°é
			/// </summary>
			public decimal FJOINQTY { get; set; }

			/// <summary>
			/// æ¶æåæ°é
			/// </summary>
			public decimal FReceiveQty { get; set; }
			}
			#endregion

			#region ææè®¡åä¸´æ¶å¨å
			public class PODemandPlanTemp
			{
			/// <summary>
			/// æ¥è®¡åå·¥åä¸»ID
			/// </summary>
			public long FID { get; set; }
			/// <summary>
			/// æ¥è®¡åå·¥åç¼å·
			/// </summary>
			public string FBILLNO { get; set; }
			/// <summary>
			/// æ¥è®¡åæç»æ¥æ
			/// </summary>
			public DateTime FHMASTERDATE { get; set; }
			/// <summary>
			/// æ¥è®¡åæç»æ°é
			/// </summary>
			public decimal FHQTY { get; set; }
			/// <summary>
			/// çäº§è®¢åå·¥åID
			/// </summary>
			public long FPRDMOMAINID { get; set; }
			/// <summary>
			/// åè¡¨ID
			/// </summary>
			public int FENTRYID { get; set; }
			/// <summary>
			/// æ°é
			/// </summary>
			public decimal FQty { get; set; }
			/// <summary>
			/// ç©æID
			/// </summary>
			public string FMATERIALID { get; set; }
			/// <summary>
			/// ç©æç¼ç
			/// </summary>
			public string FNumber { get; set; }

			/// <summary>
			/// éè´FID
			/// </summary>
			public long PurchseFID { get; set; }
			/// <summary>
			/// éè´è®¢ååå·
			/// </summary>
			public string PurchseFBillNo { get; set; }
			/// <summary>
			/// éè´åè¡¨æ è¯
			/// </summary>
			public long PurchseFentryID { get; set; }
			/// <summary>
			/// ä¾åºåid
			/// </summary>
			public long FSUPPLIERID { get; set; }
			/// <summary>
			/// ä¾åºååç§°
			/// </summary>
			public string PurchseFNUMBER { get; set; }

			/// <summary>
			/// æ¥è®¡åæ¥æ
			/// </summary>
			public DateTime OLDDATE { get; set; }

			/// <summary>
			/// éè´è®¢åæ°é
			/// </summary>
			public decimal PurchseFqty { get; set; }

			/// <summary>
			/// æåæ
			/// </summary>
			public double FFIXLEADTIME { get; set; }

			/// <summary>
			/// éè´ç»ç»
			/// </summary>
			public long FStockOrgId { get; set; }
			/// <summary>
			/// éè´ç»ç»åç§°
			/// </summary>
			public string FStockOrgName { get; set; }
			/// <summary>
			/// ç»ç»ç¼ç
			/// </summary>
			public string FORGNumber { get; set; }

			/// <summary>
			/// ç©æå±æ§
			/// </summary>
			public string FErpClsID { get; set; }

			/// <summary>
			/// éæ±åå·
			/// </summary>
			public string FXQD { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çåå»ºäºº
			/// </summary>
			public string FCREATORID { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çåå»ºäººåç§°
			/// </summary>
			public string FName { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çéè´æ¥æ
			/// </summary>
			public DateTime FDate { get; set; }
			/// <summary>
			/// éè´è®¢åä¸çäº¤è´§æ¥æ
			/// </summary>
			public DateTime FDeliveryDate { get; set; }
			/// <summary>
			/// éè´è®¢åè¡¨å¤´æè¦
			/// </summary>
			public string F_QIMB_NOTE { get; set; }
			/// <summary>
			/// éè´è®¢åè¡¨ä½å¤æ³¨
			/// </summary>
			public string FNOTE { get; set; }

			/// <summary>
			/// éè´é¨é¨
			/// </summary>
			public string FPURCHASEDEPTNUMBER { get; set; }
			/// <summary>
			/// æ¥è®¡åå·¥ååå·
			/// </summary>
			public string FDAYPLANBILLNO { get; set; }
			/// <summary>
			/// çäº§è½¦é´ç¼ç
			/// </summary>
			public string FWORKSHOPNUMBER { get; set; }
			/// <summary>
			/// éè´è®¢åæ°é
			/// </summary>
			public decimal FPURCHASEQTY { get; set; }
			/// <summary>
			/// éè´è®¢åå³èæ°é
			/// </summary>
			public decimal FJOINQTY { get; set; }
			}
			#endregion

			[Route("JIT_DayPlanPlatFormBill/JIT_TLYS")]
			[HttpGet]
			public object JIT_TLYS(string sWhere, string user,string HTLType)
			{
			try
			{
			omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);

			string fProWorkShopId = omdelMian.HWorkShopID.ToString();
			var fPrdOrgId = omdelMian.HProdORGID;
			string sqlName = "";//AIS20210811135644
			string WMS_CampanyName = ""; //å®¢æ·åç§°
			//å®¢æ·å¶å®
			string sErr = "";
			if (oSystemParameter.ShowBill(ref sErr))
			{
			if (oSystemParameter.omodel.WMS_CampanyName == "å¸å¨")
			{
			sqlName = "AIS20230129011339";
			WMS_CampanyName = "å¸å¨";
			}
			else if (oSystemParameter.omodel.WMS_CampanyName == "å¯è´å¥ç¹")
			{
			sqlName = "AIS20210820164804";
			WMS_CampanyName = "å¯è´å¥ç¹";
			}
			else if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ")
			{
			sqlName = "AIS20240809105013";
			WMS_CampanyName = "æ·»åº·ç§æ";
			}
			else if (oSystemParameter.omodel.WMS_CampanyName == "å®å·¥")
			{
			sqlName = "AIS20250102123554";
			WMS_CampanyName = "å®å·¥";
			}
			else
			{
			sqlName = "AIS20210811135644";
			}

			if (WMS_CampanyName == "å®å·¥")
			{
			objJsonResult = (json)JIT_MOMaterLack(fProWorkShopId, fPrdOrgId, user);
			}
			else if (HTLType == "ç¼ºæ")
			{
			if (WMS_CampanyName == "å¸å¨" \|\| WMS_CampanyName == "å¯è´å¥ç¹" \|\| WMS_CampanyName == "æ·»åº·ç§æ")
			{
			objJsonResult = (json)JIT_QL(fProWorkShopId, fPrdOrgId, user, sqlName);
			}
			else
			{
			objJsonResult = (json)JIT_MOMaterReady(fProWorkShopId, fPrdOrgId, user);
			}
			}
			else if (HTLType == "çäº§ç¨ææ¸å")
			{
			objJsonResult = (json)JIT_PPBOM(fProWorkShopId, fPrdOrgId, user, sqlName);
			}

			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è·åç³»ç»åæ°å¤±è´¥ï¼ " + sErr;
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			LogService.Write("æä½å¤±è´¥ï¼" + e.Message.ToString());
			oCN.RollBack();//äºå¡åæ»
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.Message.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// éè¿ç¼ºææåµç®ææ
			/// </summary>
			/// <returns></returns>
			public object JIT_QL(string HWorkShopID,int? HProdORGID,string user,string sqlName) {
			try
			{

			oCN.BeginTran();

			DataSet DaSet = oCN.RunProcReturn($"exec h_p_JIT_MOMaterReady {HWorkShopID},{HProdORGID},1", "JIT_MOMaterReadysBill");

			if (DaSet.Tables[0].Rows[0][0].ToString() != "1")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ²¡ææ°æ®,è¯·åé½å¥åæ!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//Stopwatch sw = new Stopwatch();
			//sw.Start();//å¼å§è®¡æ¶
			//ææè®¡åé¢å¤ç æ¸çææè®¡ååæ°æ® æ´æ°éè´è®¢åææè®¡åæ°é
			// string sql = string.Format(@"
			// /dialect/
			//exec [ææè®¡åé¢å¤ç]
			//");
			// DBServiceHelper.Execute(Context, sql);
			////LogHelper.Info("[ææè®¡ååå¤é¶æ®µ]ææè®¡åé¢å¤çsqlï¼" + sql);
			//éè´è®¢åæ°æ®
			string sql = $@"exec h_p_JIT_MOMaterReady {HWorkShopID},{HProdORGID},2";
			DataSet ds = oCN.RunProcReturn(sql, "t_PUR_POOrderEntry");
			List<PurchaseInventory> PurchaseInventory = ds.ToModelList<PurchaseInventory>();
			////LogHelper.Info("[ææè®¡ååå¤é¶æ®µ]å¯ç¨éè´è®¢åæ°æ®sqlï¼" + sql);
			sql = string.Format($@"exec h_p_JIT_MOMaterReady {HWorkShopID},{HProdORGID},3");
			////LogHelper.Info("[ææè®¡ååå¤é¶æ®µ]éè¦æææ°æ®sqlï¼" + sql);
			ds = oCN.RunProcReturn( sql, "JIT_MOMaterReadysBill");
			List<DayPlanPpbom> DayPlanPpbom = ds.ToModelList<DayPlanPpbom>();
			//ç©æ+åºåç»ç»åç±»
			var MaterialIDList = DayPlanPpbom.GroupBy(p => new { p.FMATERIALID, p.FNumber,p.FStockOrgName, p.FStockOrgId }).Select(x => new PODemandPlanTemp { FMATERIALID = x.Key.FMATERIALID, FNumber=x.Key.FNumber, FStockOrgId = x.Key.FStockOrgId , FStockOrgName =x.Key.FStockOrgName }).ToList();
			//ææè®¡åæ°æ®éä¸´æ¶åå¨éå
			List<PODemandPlanTemp> PODemandPlanTemp = new List<PODemandPlanTemp>();
			//sqléå æ´æ°éè´è®¢åå ç¨çææè®¡åæ°é
			List<string> sqlList = new List<string>();

			//LogService.Write("1");
			string Error = "";
			foreach (var item in MaterialIDList)
			{
			//å½åç©ææ²¡æéè´è®¢åæ¶ ç´æ¥è·³åº
			List<PurchaseInventory> _PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();
			if (_PurchaseInventory.Count == 0)
			{
			Error+="[ææè®¡åå¼å§]å½åç©ææ éè´ä¿¡æ¯ï¼" + item.FNumber + " åºåç»ç»ï¼" + item.FStockOrgName + " ";
			continue;
			}

			//LogService.Write("1.1");

			////LogHelper.Info(item.FMATERIALID.ToString());
			//å½åç©æååºåç»ç»å¯¹åºçéè¿è¡ææè®¡åçæ°æ®
			List<DayPlanPpbom> _DayPlanPpbom = DayPlanPpbom.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId).ToList();
			decimal FMINPOQTY = _DayPlanPpbom.FirstOrDefault().FMINPOQTY;//æå°èµ·è®¢é
			double FFIXLEADTIME = _DayPlanPpbom.FirstOrDefault().FFIXLEADTIME;//æåæ
			//double FFIXLEADTIME = 3;//æåæ(2022-1-26 æåææ¹ä¸º3å¤© ä¹æ°¸ååé¦)
			string FJITmaterialGroup = _DayPlanPpbom.FirstOrDefault().FJITmaterialGroup;//jitç©æåç±»
			string FJITMaterielDemand = _DayPlanPpbom.FirstOrDefault().FJITMaterielDemand; //JITç©æéæ±ä¾è´§å¨æ
			string FJITSafeStock = _DayPlanPpbom.FirstOrDefault().FJITSafeStock; //JITå®å¨åºå
			decimal NeedQty = 0;
			DateTime DATE = _DayPlanPpbom.FirstOrDefault().FHMASTERDATE;//ç¬¬ä¸ä¸ªè®¢è´§èµ·å§æ¥æ
			int i = 0;
			//è®°å½å¨æå°éè´ééæ±ä¸çæ¥è®¡åæç»FentyrID

			//LogService.Write("1.2");

			List<int> FEntryIdList = new List<int>();
			foreach (var _item in _DayPlanPpbom)
			{
			i++;
			_PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();
			if (_PurchaseInventory.Count == 0)
			{
			break;
			}

			//LogService.Write("1.2.1");

			if (NeedQty == 0)
			{
			DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-FFIXLEADTIME);
			}
			FEntryIdList.Add(_item.FENTRYID);
			NeedQty += _item.NeedQty;
			//LogService.Write(FJITmaterialGroup);
			//LogService.Write(FEntryIdList.Count);
			//LogService.Write(Convert.ToDouble(FJITMaterielDemand));
			//LogService.Write(_DayPlanPpbom.Count);
			//LogService.Write(i);
			if ((FJITmaterialGroup == "æ»éæ§å¶è§æ ¼ç±»" \|\| FJITmaterialGroup == "è®¢åä¸ç¨ä¸ªæ§ç±»") && FEntryIdList.Count < Convert.ToDouble(FJITMaterielDemand) && i < _DayPlanPpbom.Count) //è®¢åä¸ç¨ä¸ªæ§ç±»
			{
			continue;
			}

			//LogService.Write("1.2.2");

			foreach (var Purchase in _PurchaseInventory)
			{
			if (Purchase.FQTY >= NeedQty)
			{
			foreach (int id in FEntryIdList)
			{
			var DayPlanPpbomls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
			PODemandPlanTemp.Add(new PODemandPlanTemp
			{
			FID = DayPlanPpbomls.FID,
			FHMASTERDATE = DATE,
			FQty = DayPlanPpbomls.NeedQty,
			FBILLNO = DayPlanPpbomls.FBILLNO,
			FENTRYID = DayPlanPpbomls.FENTRYID,
			FMATERIALID = DayPlanPpbomls.FMATERIALID,
			FNumber = DayPlanPpbomls.FNumber,
			OLDDATE = DayPlanPpbomls.FHMASTERDATE,
			FFIXLEADTIME = FFIXLEADTIME,
			FErpClsID = DayPlanPpbomls.FErpClsID,

			PurchseFID = Purchase.FID,
			PurchseFentryID = Purchase.FENTRYID,
			FSUPPLIERID = Purchase.FSUPPLIERID,
			PurchseFNUMBER = Purchase.FNUMBER,
			PurchseFBillNo = Purchase.FBillNo,
			PurchseFqty = Purchase.FQTY,
			FStockOrgId = Purchase.FStockOrgId, //éè´ç»ç»
			FORGNumber = Purchase.FORGNumber,

			FXQD = _item.FXQD,
			FCREATORID = Purchase.FCREATORID,
			FName = Purchase.FName,
			FDate = Purchase.FDate,
			FDeliveryDate = Purchase.FDeliveryDate,
			F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
			FNOTE = Purchase.FNOTE,
			FPURCHASEQTY = Purchase.FPURCHASEQTY,
			FJOINQTY = Purchase.FJOINQTY,
			FDAYPLANBILLNO = _item.FDAYPLANBILLNO
			});
			//æ£é¤æ¥è®¡åæç»å·²è¢«åéçæ°é
			DayPlanPpbomls.NeedQty = 0;
			}

			//LogService.Write("1.2.3");

			FEntryIdList.Clear();
			//æ´æ°éè´è®¢å
			//sqlList.Add($"/dialect/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
			//æ£é¤å½åè¡å¯¹åºéè´è®¢åæ°é
			var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
			ls.FQTY -= NeedQty;
			break;
			}
			else
			{
			//æ´æ°æ»éæ±æ°é
			NeedQty = NeedQty - Purchase.FQTY;
			//éè´è®¢åæ°é
			decimal _NeedQty = Purchase.FQTY;
			List<int> mmm = new List<int>();
			foreach (int id in FEntryIdList)
			{
			var DayPlanPpbomls = DayPlanPpbom.Where(c => c.FENTRYID == id && c.FMATERIALID == _item.FMATERIALID).FirstOrDefault();
			decimal Qty = DayPlanPpbomls.NeedQty;//è®¢åæ°é

			if (Qty > _NeedQty)
			Qty = _NeedQty; //è®¢åæ°é>éè´è®¢åæ°é åéè´è®¢å

			_NeedQty = _NeedQty - Qty;
			PODemandPlanTemp.Add(new PODemandPlanTemp
			{
			FID = DayPlanPpbomls.FID,
			FHMASTERDATE = DATE,
			FQty = Qty,
			FBILLNO = DayPlanPpbomls.FBILLNO,
			FENTRYID = DayPlanPpbomls.FENTRYID,
			FMATERIALID = DayPlanPpbomls.FMATERIALID,
			FNumber = DayPlanPpbomls.FNumber,
			OLDDATE = DayPlanPpbomls.FHMASTERDATE,
			FFIXLEADTIME = FFIXLEADTIME,
			FErpClsID = DayPlanPpbomls.FErpClsID,

			PurchseFID = Purchase.FID,
			PurchseFentryID = Purchase.FENTRYID,
			FSUPPLIERID = Purchase.FSUPPLIERID,
			PurchseFNUMBER = Purchase.FNUMBER,
			PurchseFBillNo = Purchase.FBillNo,
			PurchseFqty = Purchase.FQTY,
			FStockOrgId = Purchase.FStockOrgId, //éè´ç»ç»
			FORGNumber = Purchase.FORGNumber,

			FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,
			FXQD = _item.FXQD,
			FCREATORID = Purchase.FCREATORID,
			FName = Purchase.FName,
			FDate = Purchase.FDate,
			FDeliveryDate = Purchase.FDeliveryDate,
			F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
			FNOTE = Purchase.FNOTE,
			FPURCHASEQTY = Purchase.FPURCHASEQTY,
			FJOINQTY = Purchase.FJOINQTY,
			FDAYPLANBILLNO = _item.FDAYPLANBILLNO
			});
			//æ´æ°è®¡åæ°éï¼å©ä½éè¦æçï¼ ç»§ç»å»è®¡ç®ä¸ä¸ä¸ªéè´è®¢å
			DayPlanPpbomls.NeedQty -= Qty;
			//æ´æ°éè´è®¢å
			//sqlList.Add($"/dialect/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Qty}' where FENTRYID = {Purchase.FENTRYID}");
			//æ´æ°Model
			var ls = PurchaseInventory.Where(c => c.FENTRYID == Purchase.FENTRYID).FirstOrDefault();
			ls.FQTY -= Qty;
			if (_NeedQty <= 0)
			{
			foreach (var mm in mmm)
			{
			FEntryIdList.Remove(mm);
			}
			break;
			}
			mmm.Add(id);
			}
			}
			}

			//LogService.Write("1.2.4");

			NeedQty = 0;

			}
			}

			//var PODemandPlanList222 = PODemandPlanTemp.GroupBy(p => new PODemandPlanTemp { PurchseFNUMBER = p.PurchseFNUMBER, FHMASTERDATE = p.FHMASTERDATE }).Select(x => new PODemandPlanTemp { PurchseFNUMBER = x.Key.PurchseFNUMBER, FHMASTERDATE = x.Key.FHMASTERDATE }).ToList();
			var PODemandPlanList = PODemandPlanTemp.GroupBy(p => new { p.PurchseFNUMBER, p.FHMASTERDATE }).Select(x => new PODemandPlanTemp { PurchseFNUMBER = x.Key.PurchseFNUMBER, FHMASTERDATE = x.Key.FHMASTERDATE }).ToList();
			//LogHelper.Info($"ææè®¡åï¼æ°æ®åå¤å®æï¼ä¿åå°Modelå®ä½ï¼æ»è¡æ°ï¼{PODemandPlanTemp.Count}");
			int tlmmm = 0;
			JArray FinalyResult = new JArray();

			//LogService.Write("2");

			foreach (var item in PODemandPlanList)
			{
			tlmmm++;

			DateTime date = item.FHMASTERDATE;
			string PurchseFNUMBER = item.PurchseFNUMBER;
			//JObject model = new JObject();
			//model.Add("FHDate", date);
			//model.Add("FDeliveryDate", date.AddDays(-3));//ä¾åºåé¢è®¡åè´§æ¥æ
			//model.Add("FSettleCurrId", new JObject() { ["Fnumber"] = "PRE001" });
			//model.Add("FSupplierID", new JObject() { ["Fnumber"] = PurchseFNUMBER });

			var HInterID = DBUtility.ClsPub.CreateBillID("4608", ref DBUtility.ClsPub.sExeReturnInfo);
			var HBillNo = DBUtility.ClsPub.CreateBillCode("4608", ref DBUtility.ClsPub.sExeReturnInfo, true);

			var dataUser = oCN.RunProcReturn("select Czymc from gy_czygl where Czybm = '" + user + "'", "gy_czygl");
			string HMaker = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//å¶åäºº
			string HUpDater = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//ä¿®æ¹äºº


			var dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
			inner join "+ sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
			where FNUMBER='" + PODemandPlanTemp[0].FORGNumber + "' and HItemID ='" + HProdORGID + "'", "Xt_ORGANIZATIONS");
			long HPURCHASEORGID = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); //éè´ç»ç»

			var dataSup = oCN.RunProcReturn(@"select * from Gy_Supplier p
			inner join " + sqlName + @"..t_BD_Supplier fp on p.HNumber=fp.FNUMBER and p.HUSEORGID=fp.FUSEORGID
			where FNUMBER='" + item.PurchseFNUMBER + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Supplier");
			long HSupplierID = dataSup.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataSup.Tables[0].Rows[0]["HItemID"].ToString()); //ä¾åºå

			long HSettleCurrId = 1;//è´§å¸ é»è®¤æ¬å°äººæ°å¸

			//ä¸»è¡¨
			oCN.RunProc("insert into JIT_Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" +
			",HBillSubType,HDate,HBillStatus,HMaker,HMakeDate" +
			",HSubORGID ,HAddress,HPURCHASEORGID,HSupplierID ,HSettleCurrId" +
			",HRemark,HExplanation,HUpDater,HUpDateDate)" +
			$"values({HInterID}, '{HBillNo}', {DateTime.Now.Year}, {DateTime.Now.Month}, '4608'" +
			$", '4608','{date}',1, '{HMaker}',GETDATE()," +
			$"{HPURCHASEORGID},'',{HPURCHASEORGID}, {HSupplierID}, {HSettleCurrId}" +
			$",'','','{HUpDater}',getdate())");

			JArray Fentity = new JArray();
			List<PODemandPlanTemp> _PODemandPlanList = PODemandPlanTemp.Where(x => x.FHMASTERDATE == date && x.PurchseFNUMBER == PurchseFNUMBER).ToList();
			//LogService.Write("æµè¯listmodelï¼" + _PODemandPlanList[0].FORGNumber.ToString());
			int i = 0;
			foreach (var _item in _PODemandPlanList)
			{
			i++;
			//if (!model.ToString().Contains("FHPURCHASEORGID"))
			// model.Add("FHPURCHASEORGID", new JObject() { ["Fnumber"] = _item.FORGNumber });
			//JObject FentityModel = new JObject();
			//FentityModel.Add("FHPURCHASEORGID", new JObject() { ["Fnumber"] = _item.FORGNumber });//éè´ç»ç»
			//FentityModel.Add("FHMaterID", new JObject() { ["Fnumber"] = _item.FNumber });//ç©æ
			//FentityModel.Add("FHQty", _item.FQty);//æ°é
			//FentityModel.Add("FHSourceInterID", _item.FID);//æ¥è®¡åå·¥åFID
			//FentityModel.Add("FHSourceEntryID", _item.FENTRYID);//æ¥è®¡åå·¥åFENTRYID
			//FentityModel.Add("FHSourceBillNo", _item.FBILLNO);//æ¥è®¡åå·¥ååå·
			//FentityModel.Add("FHSourceBillType", "");//æ¥è®¡åå·¥åç±»å
			//FentityModel.Add("FDayPlanDate", _item.OLDDATE);//æ¥è®¡åå·¥åç±»å
			//FentityModel.Add("FHRelationQty", _item.PurchseFqty);//å³èæ°é
			//FentityModel.Add("FFIXLEADTIME", _item.FFIXLEADTIME);//æåæ
			//FentityModel.Add("FPURCHASEORGID", new JObject() { ["Fnumber"] = _item.FORGNumber });//éè´ç»ç»
			//FentityModel.Add("FHPOOrderInterID", _item.PurchseFID);// éè´è®¢ååç ï¼FHPOOrderInterID
			//FentityModel.Add("FHPOOrderEntryID", _item.PurchseFentryID); //éè´è®¢åååç ï¼FHPOOrderEntryID
			//FentityModel.Add("FHPOOrderBillNo", _item.PurchseFBillNo); //éè´è®¢åå·ï¼FHPOOrderBillNo
			//FentityModel.Add("FERPCLSID", _item.FErpClsID); //åææ¹å¼
			//FentityModel.Add("FUnitID", new JObject() { ["Fnumber"] = "Pcs" }); //åææ¹å¼
			//Fentity.Add(FentityModel);


			var dataSet = oCN.RunProcReturn(@"select m.* from Gy_Material m
			inner join " + sqlName + @"..T_BD_MATERIAL fm on m.HNumber = fm.FNUMBER and m.HUSEORGID=fm.FUSEORGID
			where FNUMBER='" + _item.FNumber + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Material");
			string HMaterID = "0"; //ç©æ
			string HMaterModel = ""; //ç©æä»£ç
			string HMaterName = ""; //ç©æåç§°
			if (dataSet.Tables[0].Rows.Count != 0)
			{
			HMaterID = dataSet.Tables[0].Rows[0]["HItemID"].ToString(); //ç©æ
			HMaterModel = dataSet.Tables[0].Rows[0]["HNumber"].ToString(); //ç©æä»£ç
			HMaterName = dataSet.Tables[0].Rows[0]["HName"].ToString(); //ç©æåç§°
			}

			decimal HQty = _item.FQty; //æ°é
			long HSourceInterID = _item.FID; //æ¥è®¡åå·¥åFID
			long HSourceEntryID = _item.FENTRYID;//æ¥è®¡åå·¥åFENTRYID
			string HSourceBillNo = _item.FBILLNO; //çäº§è®¢åå·
			string HSourceBillType = ""; //æ¥è®¡åå·¥åç±»å
			DateTime HDayPlanDate = _item.OLDDATE; // å·¥åçäº§æ¥æ
			decimal HRelationQty = _item.PurchseFqty; // å³èæ°é
			double HFixleadTime = _item.FFIXLEADTIME; // æåæ

			dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
			inner join " + sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
			where FNUMBER='" + _item.FORGNumber + "' and HItemID ='" + HProdORGID + "'", "Xt_ORGANIZATIONS");
			long HPURCHASEORGIDSub = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); // éè´ç»ç»
			long HPOOrderInterID = _item.PurchseFID; // éè´è®¢ååç
			long HPOOrderEntryID = _item.PurchseFentryID; // éè´è®¢åååç
			string HPOOrderBillNo = _item.PurchseFBillNo; // éè´è®¢åå·
			string HErpClsID = _item.FErpClsID; // ç©æå±æ§
			long HUnitID = 10101; // è®¡éåä½ åæç§æ¬å°æ¥ é»è®¤ Pcs
			string HSeOrderBillNo = _item.FXQD; // éå®è®¢åå· éæ±åå·
			string HOrderEmpID = _item.FCREATORID; // éè´å
			DateTime HPOOrderBillDate = _item.FDate; // éè´è®¢ååæ®æ¥æ
			DateTime HPOOrderBillDeliveryDate = _item.FDeliveryDate; // éè´è®¢åäº¤è´§æ¥æ
			string HPOOrderBillRemark = _item.F_QIMB_NOTE; // éè´è®¢åæè¦
			string HPOOrderBillNote = _item.FNOTE; // éè´è®¢åè¡¨ä½å¤æ³¨
			string HDayPlanBillNo = _item.FDAYPLANBILLNO; // æ¥è®¡åå·¥åå·

			dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
			inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
			where FNUMBER='" + _item.FWORKSHOPNUMBER + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Department");
			HWorkShopID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // çäº§è½¦é´

			dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
			inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
			where FNUMBER='" + _item.FPURCHASEDEPTNUMBER + "' and HUSEORGID ='" + HProdORGID + "'", "Gy_Department");
			string HPurchaseDeptID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // éè´é¨é¨

			decimal HPURCHASEQTY = _item.FPURCHASEQTY; // éè´è®¢åæ°é
			decimal HJoinQty = _item.FJOINQTY; // éè´è®¢åå³èæ°é

			oCN.RunProc("insert into JIT_Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" +
			", HMaterModel, HUnitID, HErpClsID, HQty, HRemark" +
			", HPURCHASEORGID, HStatus, HFixleadTime, HDayPlanBillNo, HSourceInterID" +
			", HSourceEntryID, HSourceBillNo, HSourceBillType, HWorkShopID, HDayPlanDate" +
			", HRelationQty1, HPOOrderInterID, HPOOrderEntryID, HPOOrderBillNo, HPOOrderBillSEQ" +
			", HWWOrderInterID, HWWOrderEntryID, HWWOrderBillNo, HPurchaseDeptID, HCloseTypeSub" +
			", HCloseMan, HEntryCloseDate, HSendQty, HReciveQty, HCloseStatus" +
			", HRemoveQty, HSeOrderBillNo, HUnReciveQty, HPOOrderBillDate, HPOOrderBillDeliveryDate" +
			", HPOOrderBillRemark, HPOOrderBillNote)" +
			$"values({HInterID}, {i}, '', {(HMaterID == null ? "0" : HMaterID)}, '{HMaterName}'" +
			$", '{HMaterModel}', {HUnitID}, '{HErpClsID}', {HQty}, ''" +
			$", {HPURCHASEORGIDSub}, '', {HFixleadTime}, '{HDayPlanBillNo}', {HSourceInterID}" +
			$", {HSourceEntryID}, '{HSourceBillNo}', '{HSourceBillType}', {HWorkShopID}, '{HDayPlanDate}'" +
			$", {HRelationQty}, {HPOOrderInterID},{HPOOrderEntryID}, '{HPOOrderBillNo}',0" +
			$",0,0, '',{HPurchaseDeptID}, '0'" +
			$", '','',0,0, '0'" +
			$",0, '{HSeOrderBillNo}',0, '{HPOOrderBillDate}', '{HPOOrderBillDeliveryDate}'" +
			$", '{HPOOrderBillRemark}', '{HPOOrderBillNote}')");

			}
			//model.Add("FEntity", Fentity);
			//FinalyResult.Add(model);
			// if ((tlmmm >= 20 \|\| tlmmm == PODemandPlanList.Count) && (tlmmm % 20 == 0 \|\| tlmmm == PODemandPlanList.Count))
			// {
			// //LogHelper.Info("ææè®¡åæ°å¢æ¹éæ§è¡ï¼è®°å½å¾ªç¯çå½åæ¡æ°" + tlmmm);
			// JObject jsonRoot = new JObject()
			// {
			// ["Creator"] = "",
			// ["NeedUpDateFields"] = new JArray(),
			// ["NeedReturnFields"] = new JArray(),
			// ["IsDeleteEntry"] = "false",
			// ["SubSystemId"] = "",
			// ["IsVerifyBaseDataField"] = "false",
			// ["Model"] = FinalyResult
			// };
			// CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");
			// var result = cloudClient.BatchSave("paez_PODemandPlan", jsonRoot.ToString());
			// JObject saveObj = JObject.Parse(result);
			// string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();
			// if (saveIsSuc != "TRUE")
			// {
			// //LogHelper.Error(jsonRoot.ToString());
			// }
			// FinalyResult = new JArray();
			// }
			// tlmmm++;
			}

			//LogService.Write("3");
			if (Error != "")
			{
			oCN.Commit();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è¿ç®æå!" + Error;
			objJsonResult.data = null;
			return objJsonResult;
			}
			else if (tlmmm == PODemandPlanList.Count && tlmmm != 0)
			{
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "è¿ç®æå!" + Error;
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			oCN.RollBack();//äºå¡åæ»
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è¿ç®å¤±è´¥!" + Error;
			objJsonResult.data = null;
			return objJsonResult;
			}

			////sw.Stop();//ç»æè®¡æ¶
			//////LogHelper.Info("ææè®¡åæ§è¡å®æï¼è¿è¡æ»æ¶é¿ï¼" + sw.Elapsed);
			//DBServiceHelper.ExecuteBatch(Context, sqlList);

			//objJsonResult.code = "1";
			//objJsonResult.count = 1;
			//objJsonResult.Message = "ææè¿ç®æåï¼";
			//objJsonResult.data = null;
			//return objJsonResult;
			}
			catch (Exception e)
			{
			LogService.Write("æä½å¤±è´¥ï¼" + e.Message.ToString());
			oCN.RollBack();//äºå¡åæ»
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.Message.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}

			}

			/// <summary>
			/// éè¿çäº§ç¨ææ¸å ç®ç¼ºææåµ
			/// </summary>
			/// <returns></returns>
			public object JIT_PPBOM(string fProWorkShopId,int? fPrdOrgId,string user,string sqlName) {

			try
			{
			Stopwatch sw = new Stopwatch();
			sw.Start();//å¼å§è®¡æ¶
			//ææè®¡åé¢å¤ç æ¸çææè®¡ååæ°æ® æ´æ°éè´è®¢åææè®¡åæ°é å¹¶ä¸æ¥è¯¢åºéè¦è¿è¡è¿ç®çæ°æ®

			oCN.BeginTran(); //å¼å§äºå¡

			ds = oCN.RunProcReturn($"exec h_p_PROC_JIT_TLPLANYCL '{fProWorkShopId}','{fPrdOrgId}'", "h_p_PROC_JIT_TLPLANYCL");
			List<DayPlanPpbom> DayPlanPpbom = ds.ToModelList<DayPlanPpbom>();

			if (DayPlanPpbom.Count == 0)
			{
			oCN.RollBack();//åæ»äºå¡
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æ°æ®è¿ç®!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			//éè´è®¢åæ°æ® ï¼å©ä½æ¶ææ°éï¼

			//t2.FXQD t2.FSTOCKINQTY,t2.FReceiveQty æ¬å°æ²¡æè¿äºåæ®µ
			string sql = string.Format(@"
			select * from h_v_jit_POOrderList where FQTY>0 and FCloseStatus in('A')
			and FMRPCLOSESTATUS in('A') and FBillTypeID in('83d822ca3e374b4ab01e5dd46a0062bd','6d01d059713d42a28bb976c90a121142') and FStockOrgId = '{0}'", fPrdOrgId);

			ds = oCN.RunProcReturn(sql, "h_v_jit_POOrderList");

			if (ds.Tables[0].Rows.Count == 0)
			{
			oCN.RollBack();//åæ»äºå¡
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ¥æ éè´è®¢åæ°æ®!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			List<PurchaseInventory> PurchaseInventory = ds.ToModelList<PurchaseInventory>();
			//ç©æ+åºåç»ç»åç±»
			var MaterialIDList = DayPlanPpbom.GroupBy(p => new { p.FMATERIALID, p.FStockOrgId }).Select(x => new PODemandPlanTemp { FMATERIALID = x.Key.FMATERIALID, FStockOrgId = x.Key.FStockOrgId }).ToList();

			//ææè®¡åæ°æ®éä¸´æ¶åå¨éå
			List<PODemandPlanTemp> PODemandPlanTemp = new List<PODemandPlanTemp>();
			//sqléå æ´æ°éè´è®¢åå ç¨çææè®¡åæ°é
			List<string> sqlList = new List<string>();

			foreach (var item in MaterialIDList)
			{
			//this.View.Session["ProcessRateValue"] = Convert.ToInt32((Convert.ToDecimal(75) / MaterialIDList.Count) * i);
			//å½åç©æååºåç»ç»å¯¹åºçéè¿è¡ææè®¡åçæ°æ®
			List<DayPlanPpbom> _DayPlanPpbom = DayPlanPpbom.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId).ToList();
			decimal NeedQty = 0;
			foreach (var _item in _DayPlanPpbom)
			{
			//æ¥è¯¢ææ²¡æå¯ä»¥ç¨äºææçéè´è®¢åæ°æ®
			var _PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();
			if (_PurchaseInventory.Count == 0)
			{
			//æ éè´è®¢åç´æ¥ä¸ä¸ä¸ªç©æ
			sql = $"INSERT INTO JIT_TLPLANERROR(HROGID,HUSERID,HWORKSHOPID,HDAYPLANID,HDAYPLANENTRYID,HMATERIALID,HQTY,HTYPE) VALUES({fPrdOrgId},{user},{fProWorkShopId},{_item.FID},{_item.FENTRYID},{_item.FMATERIALID},{_item.NeedQty},0) ";
			sqlList.Add(sql);
			break;
			}
			//éæ±æ°é
			NeedQty = _item.NeedQty;
			//å¢å ä¸ä¸ªéå®è®¢åå·å¹éçé»è¾ ä¼åå¾ªç¯
			var PurchaseInventoryBySalOrder = _PurchaseInventory.Where(x => x.FXQD == _item.FXQD).OrderBy(x => x.FENTRYID).ToList();
			if (PurchaseInventoryBySalOrder.Count > 0)
			{
			foreach (var Purchase in PurchaseInventoryBySalOrder)
			{
			double _FFIXLEADTIME = Purchase.FFIXLEADTIME;//æåæ
			DateTime _DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-_FFIXLEADTIME);
			if (Purchase.FQTY >= NeedQty)
			{
			PODemandPlanTemp.Add(new PODemandPlanTemp
			{
			FID = _item.FID,
			FHMASTERDATE = _DATE,
			FQty = NeedQty,
			FBILLNO = _item.FBILLNO,
			FENTRYID = _item.FENTRYID,
			FMATERIALID = _item.FMATERIALID,
			FNumber = _item.FNumber,
			OLDDATE = _item.FHMASTERDATE,
			FFIXLEADTIME = _FFIXLEADTIME,
			FErpClsID = _item.FErpClsID,
			FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
			FDAYPLANBILLNO = _item.FDAYPLANBILLNO,

			PurchseFentryID = Purchase.FENTRYID,
			FSUPPLIERID = Purchase.FSUPPLIERID,
			PurchseFNUMBER = Purchase.FNUMBER,
			PurchseFBillNo = Purchase.FBillNo,
			PurchseFqty = Purchase.FQTY,
			FStockOrgId = Purchase.FStockOrgId, //éè´ç»ç»
			FORGNumber = Purchase.FORGNumber,
			FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,

			FXQD = _item.FXQD,
			FCREATORID = Purchase.FCREATORID,
			FName = Purchase.FName,
			FDate = Purchase.FDate,
			FDeliveryDate = Purchase.FDeliveryDate,
			F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
			FNOTE = Purchase.FNOTE,
			FPURCHASEQTY = Purchase.FPURCHASEQTY,
			FJOINQTY = Purchase.FJOINQTY

			});
			//æ£é¤æ¥è®¡åæç»å·²è¢«åéçæ°é
			_item.NeedQty = 0;
			//æ£é¤å½åè¡å¯¹åºéè´è®¢åæ°é
			Purchase.FQTY -= NeedQty;
			//æ´æ°éè´è®¢å
			//sqlList.Add($"/dialect/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
			//éæ±æ°éåä¸º0
			NeedQty = 0;
			break;
			}
			else//éè´è®¢åæ°æ®ä¸è½æ»¡è¶³è®¢åæéæ°é
			{
			//éè´è®¢åæ°é
			decimal _NeedQty = Purchase.FQTY;
			PODemandPlanTemp.Add(new PODemandPlanTemp
			{
			FID = _item.FID,
			FHMASTERDATE = _DATE,
			FQty = _NeedQty,
			FBILLNO = _item.FBILLNO,
			FENTRYID = _item.FENTRYID,
			FMATERIALID = _item.FMATERIALID,
			FNumber = _item.FNumber,
			OLDDATE = _item.FHMASTERDATE,
			FFIXLEADTIME = _FFIXLEADTIME,
			FErpClsID = _item.FErpClsID,
			FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
			FDAYPLANBILLNO = _item.FDAYPLANBILLNO,

			PurchseFentryID = Purchase.FENTRYID,
			FSUPPLIERID = Purchase.FSUPPLIERID,
			PurchseFNUMBER = Purchase.FNUMBER,
			PurchseFBillNo = Purchase.FBillNo,
			PurchseFqty = Purchase.FQTY,
			FStockOrgId = Purchase.FStockOrgId, //éè´ç»ç»
			FORGNumber = Purchase.FORGNumber,
			FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,

			FXQD = _item.FXQD,
			FCREATORID = Purchase.FCREATORID,
			FName = Purchase.FName,
			FDate = Purchase.FDate,
			FDeliveryDate = Purchase.FDeliveryDate,
			F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
			FNOTE = Purchase.FNOTE,
			FPURCHASEQTY = Purchase.FPURCHASEQTY,
			FJOINQTY = Purchase.FJOINQTY
			});
			//æ´æ°éè´è®¢å
			//sqlList.Add($"/dialect/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
			//æ´æ°è®¢åéæ±æ°é
			NeedQty = NeedQty - Purchase.FQTY;
			//æ£é¤æ¥è®¡åæç»å·²è¢«åéçæ°é
			_item.NeedQty -= _NeedQty;
			//æ£é¤å½åè¡å¯¹åºéè´è®¢åæ°é
			Purchase.FQTY = 0;
			}
			}
			}
			if (NeedQty == 0)
			continue;
			var PurchaseInventoryElse = _PurchaseInventory.Where(x => x.FXQD != _item.FXQD).OrderBy(x => x.FENTRYID).ToList();
			foreach (var Purchase in PurchaseInventoryElse)
			{
			double _FFIXLEADTIME = Purchase.FFIXLEADTIME;//æåæ
			DateTime _DATE = Convert.ToDateTime(_item.FHMASTERDATE).AddDays(-_FFIXLEADTIME);
			if (Purchase.FQTY >= NeedQty)
			{
			PODemandPlanTemp.Add(new PODemandPlanTemp
			{
			FID = _item.FID,
			FHMASTERDATE = _DATE,
			FQty = _item.NeedQty,
			FBILLNO = _item.FBILLNO,
			FENTRYID = _item.FENTRYID,
			FMATERIALID = _item.FMATERIALID,
			FNumber = _item.FNumber,
			OLDDATE = _item.FHMASTERDATE,
			FFIXLEADTIME = _FFIXLEADTIME,
			FErpClsID = _item.FErpClsID,
			FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
			FDAYPLANBILLNO = _item.FDAYPLANBILLNO,

			PurchseFentryID = Purchase.FENTRYID,
			FSUPPLIERID = Purchase.FSUPPLIERID,
			PurchseFNUMBER = Purchase.FNUMBER,
			PurchseFBillNo = Purchase.FBillNo,
			PurchseFqty = Purchase.FQTY,
			FStockOrgId = Purchase.FStockOrgId, //éè´ç»ç»
			FORGNumber = Purchase.FORGNumber,
			FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,

			FXQD = _item.FXQD,
			FCREATORID = Purchase.FCREATORID,
			FName = Purchase.FName,
			FDate = Purchase.FDate,
			FDeliveryDate = Purchase.FDeliveryDate,
			F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
			FNOTE = Purchase.FNOTE,
			FPURCHASEQTY = Purchase.FPURCHASEQTY,
			FJOINQTY = Purchase.FJOINQTY
			});
			//æ´æ°éè´è®¢å
			//sqlList.Add($"/dialect/ update t_PUR_POOrderEntry set FPODemandPlanCount =isnull(FPODemandPlanCount,0)+ '{NeedQty}' where FENTRYID = {Purchase.FENTRYID}");
			//æ£é¤æ¥è®¡åæç»å·²è¢«åéçæ°é
			_item.NeedQty = 0;
			//æ£é¤å½åè¡å¯¹åºéè´è®¢åæ°é
			Purchase.FQTY -= NeedQty;
			//éæ±æ°éåä¸º0
			NeedQty = 0;
			break;
			}
			else//éè´è®¢åæ°æ®ä¸è½æ»¡è¶³è®¢åæéæ°é
			{
			//æ´æ°æ»éæ±æ°é
			NeedQty = NeedQty - Purchase.FQTY;
			//éè´è®¢åæ°é
			decimal _NeedQty = Purchase.FQTY;
			PODemandPlanTemp.Add(new PODemandPlanTemp
			{
			FID = _item.FID,
			FHMASTERDATE = _DATE,
			FQty = _NeedQty,
			FBILLNO = _item.FBILLNO,
			FENTRYID = _item.FENTRYID,
			FMATERIALID = _item.FMATERIALID,
			FNumber = _item.FNumber,
			OLDDATE = _item.FHMASTERDATE,
			FFIXLEADTIME = _FFIXLEADTIME,
			FErpClsID = _item.FErpClsID,
			FWORKSHOPNUMBER = _item.FWORKSHOPNUMBER,
			FDAYPLANBILLNO = _item.FDAYPLANBILLNO,

			PurchseFentryID = Purchase.FENTRYID,
			FSUPPLIERID = Purchase.FSUPPLIERID,
			PurchseFNUMBER = Purchase.FNUMBER,
			PurchseFBillNo = Purchase.FBillNo,
			PurchseFqty = Purchase.FQTY,
			FStockOrgId = Purchase.FStockOrgId, //éè´ç»ç»
			FORGNumber = Purchase.FORGNumber,
			FPURCHASEDEPTNUMBER = Purchase.FPURCHASEDEPTNUMBER,

			FXQD = _item.FXQD,
			FCREATORID = Purchase.FCREATORID,
			FName = Purchase.FName,
			FDate = Purchase.FDate,
			FDeliveryDate = Purchase.FDeliveryDate,
			F_QIMB_NOTE = Purchase.F_QIMB_NOTE,
			FNOTE = Purchase.FNOTE,
			FPURCHASEQTY = Purchase.FPURCHASEQTY,
			FJOINQTY = Purchase.FJOINQTY
			});
			//æ´æ°éè´è®¢å
			//sqlList.Add($"/dialect/ update t_PUR_POOrderEntry set FPODemandPlanCount = isnull(FPODemandPlanCount,0)+ '{Purchase.FQTY}' where FENTRYID = {Purchase.FENTRYID}");
			//æ£é¤æ¥è®¡åæç»å·²è¢«åéçæ°é
			_item.NeedQty -= _NeedQty;
			//æ£é¤å½åè¡å¯¹åºéè´è®¢åæ°é
			Purchase.FQTY = 0;
			}
			}
			if (NeedQty > 0)
			{
			sql = $"INSERT INTO JIT_TLPLANERROR(HROGID,HUSERID,HWORKSHOPID,HDAYPLANID,HDAYPLANENTRYID,HMATERIALID,HQTY,HTYPE,HERRORTYPE) VALUES({fPrdOrgId},{user},{fProWorkShopId},{_item.FID},{_item.FENTRYID},{_item.FMATERIALID},{NeedQty},0,1) ";
			sqlList.Add(sql);
			}
			}
			}

			//ä¾åºåï¼æææ¥æï¼çäº§è½¦é´ï¼éè´å åç»
			var PODemandPlanList = PODemandPlanTemp.GroupBy(p => new { p.PurchseFNUMBER, p.FHMASTERDATE, p.FWORKSHOPNUMBER, p.FCREATORID }).Select(x => new PODemandPlanTemp { PurchseFNUMBER = x.Key.PurchseFNUMBER, FHMASTERDATE = x.Key.FHMASTERDATE, FWORKSHOPNUMBER = x.Key.FWORKSHOPNUMBER, FCREATORID = x.Key.FCREATORID }).ToList();

			LogService.Write("ææè®¡åéç® ï¼æ°æ®åå¤å®æï¼ä¿åå°Modelå®ä½ ç¨æ¶ï¼" + sw.Elapsed + "æ»è¡æ°ï¼" + PODemandPlanTemp.Count);

			int tlmmm = 0;
			JArray FinalyResult = new JArray();
			foreach (var item in PODemandPlanList)
			{
			tlmmm++;

			DateTime date = item.FHMASTERDATE;
			long HSettleCurrId = 1;//è´§å¸ é»è®¤æ¬å°äººæ°å¸

			var dataSup = oCN.RunProcReturn(@"select * from Gy_Supplier p
			inner join " + sqlName + @"..t_BD_Supplier fp on p.HNumber=fp.FNUMBER and p.HUSEORGID=fp.FUSEORGID
			where FNUMBER='" + item.PurchseFNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Supplier");
			long HSupplierID = dataSup.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataSup.Tables[0].Rows[0]["HItemID"].ToString()); //ä¾åºå

			var dataUser = oCN.RunProcReturn("select Czymc from gy_czygl where Czybm = '" + user + "'", "gy_czygl");
			string HMaker = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//å¶åäºº
			string HUpDater = dataUser.Tables[0].Rows.Count == 0 ? "" : dataUser.Tables[0].Rows[0][0].ToString();//ä¿®æ¹äºº

			var dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
			inner join " + sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
			where FNUMBER='" + PODemandPlanTemp[0].FORGNumber + "' and HItemID ='" + fPrdOrgId + "'", "Xt_ORGANIZATIONS");
			long HPURCHASEORGID = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); //éè´ç»ç»

			string PurchseFNUMBER = item.PurchseFNUMBER;
			string FWorkshopNumber = item.FWORKSHOPNUMBER;
			string FCreatorID = item.FCREATORID;

			var HInterID = DBUtility.ClsPub.CreateBillID("4608", ref DBUtility.ClsPub.sExeReturnInfo);
			var HBillNo = DBUtility.ClsPub.CreateBillCode("4608", ref DBUtility.ClsPub.sExeReturnInfo, true);
			//ä¸»è¡¨
			oCN.RunProc("insert into JIT_Cg_PODemandPlanBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType" +
			",HBillSubType,HDate,HBillStatus,HMaker,HMakeDate" +
			",HSubORGID ,HAddress,HPURCHASEORGID,HSupplierID ,HSettleCurrId" +
			",HRemark,HExplanation,HUpDater,HUpDateDate)" +
			$"values({HInterID}, '{HBillNo}', {DateTime.Now.Year}, {DateTime.Now.Month}, '4608'" +
			$", '4608','{date}',1, '{HMaker}',GETDATE()," +
			$"{HPURCHASEORGID},'',{HPURCHASEORGID}, {HSupplierID}, {HSettleCurrId}" +
			$",'','','{HUpDater}',getdate())");

			List<PODemandPlanTemp> _PODemandPlanList = PODemandPlanTemp.Where(x => x.FHMASTERDATE == date && x.PurchseFNUMBER == PurchseFNUMBER && x.FWORKSHOPNUMBER == FWorkshopNumber && x.FCREATORID == FCreatorID).ToList();
			int i = 0;
			foreach (var _item in _PODemandPlanList)
			{
			i++;

			var dataSet = oCN.RunProcReturn(@"select m.* from Gy_Material m
			inner join " + sqlName + @"..T_BD_MATERIAL fm on m.HNumber = fm.FNUMBER and m.HUSEORGID=fm.FUSEORGID
			where FNUMBER='" + _item.FNumber + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Material");
			string HMaterID = "0"; //ç©æ
			string HMaterModel = ""; //ç©æä»£ç
			string HMaterName = ""; //ç©æåç§°
			if (dataSet.Tables[0].Rows.Count != 0)
			{
			HMaterID = dataSet.Tables[0].Rows[0]["HItemID"].ToString(); //ç©æ
			HMaterModel = dataSet.Tables[0].Rows[0]["HNumber"].ToString(); //ç©æä»£ç
			HMaterName = dataSet.Tables[0].Rows[0]["HName"].ToString(); //ç©æåç§°
			}

			decimal HQty = _item.FQty; //æ°é
			long HSourceInterID = _item.FID; //æ¥è®¡åå·¥åFID
			long HSourceEntryID = _item.FENTRYID;//æ¥è®¡åå·¥åFENTRYID
			string HSourceBillNo = _item.FBILLNO; //çäº§è®¢åå·
			string HSourceBillType = ""; //æ¥è®¡åå·¥åç±»å
			DateTime HDayPlanDate = _item.OLDDATE; // å·¥åçäº§æ¥æ
			decimal HRelationQty = _item.PurchseFqty; // å³èæ°é
			double HFixleadTime = _item.FFIXLEADTIME; // æåæ

			dataOrg = oCN.RunProcReturn(@"select HItemID from Xt_ORGANIZATIONS o
			inner join " + sqlName + @"..T_ORG_ORGANIZATIONS fo on o.HNumber=fo.FNUMBER
			where FNUMBER='" + _item.FORGNumber + "' and HItemID ='" + fPrdOrgId + "'", "Xt_ORGANIZATIONS");
			long HPURCHASEORGIDSub = dataOrg.Tables[0].Rows.Count == 0 ? 0 : long.Parse(dataOrg.Tables[0].Rows[0]["HItemID"].ToString()); // éè´ç»ç»
			long HPOOrderInterID = _item.PurchseFID; // éè´è®¢ååç
			long HPOOrderEntryID = _item.PurchseFentryID; // éè´è®¢åååç
			string HPOOrderBillNo = _item.PurchseFBillNo; // éè´è®¢åå·
			string HErpClsID = _item.FErpClsID; // ç©æå±æ§
			long HUnitID = 10101; // è®¡éåä½ åæç§æ¬å°æ¥ é»è®¤ Pcs
			string HSeOrderBillNo = _item.FXQD; // éå®è®¢åå· éæ±åå·
			string HOrderEmpID = _item.FCREATORID; // éè´å
			DateTime HPOOrderBillDate = _item.FDate; // éè´è®¢ååæ®æ¥æ
			DateTime HPOOrderBillDeliveryDate = _item.FDeliveryDate; // éè´è®¢åäº¤è´§æ¥æ
			string HPOOrderBillRemark = _item.F_QIMB_NOTE; // éè´è®¢åæè¦
			string HPOOrderBillNote = _item.FNOTE; // éè´è®¢åè¡¨ä½å¤æ³¨
			string HDayPlanBillNo = _item.FDAYPLANBILLNO; // æ¥è®¡åå·¥åå·

			dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
			inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
			where FNUMBER='" + _item.FWORKSHOPNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Department");
			string HWorkShopID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // çäº§è½¦é´

			dataSet = oCN.RunProcReturn(@"select HItemID from Gy_Department d
			inner join " + sqlName + @"..T_BD_DEPARTMENT fd on d.HNumber = fd.FNUMBER
			where FNUMBER='" + _item.FPURCHASEDEPTNUMBER + "' and HUSEORGID ='" + fPrdOrgId + "'", "Gy_Department");
			string HPurchaseDeptID = dataSet.Tables[0].Rows.Count == 0 ? "0" : dataSet.Tables[0].Rows[0][0].ToString(); // éè´é¨é¨

			decimal HPURCHASEQTY = _item.FPURCHASEQTY; // éè´è®¢åæ°é
			decimal HJoinQty = _item.FJOINQTY; // éè´è®¢åå³èæ°é

			oCN.RunProc("insert into JIT_Cg_PODemandPlanBillSub(HInterID,HEntryID,HLaterReason,HMaterID,HMaterName" +
			", HMaterModel, HUnitID, HErpClsID, HQty, HRemark" +
			", HPURCHASEORGID, HStatus, HFixleadTime, HDayPlanBillNo, HSourceInterID" +
			", HSourceEntryID, HSourceBillNo, HSourceBillType, HWorkShopID, HDayPlanDate" +
			", HRelationQty1, HPOOrderInterID, HPOOrderEntryID, HPOOrderBillNo, HPOOrderBillSEQ" +
			", HWWOrderInterID, HWWOrderEntryID, HWWOrderBillNo, HPurchaseDeptID, HCloseTypeSub" +
			", HCloseMan, HEntryCloseDate, HSendQty, HReciveQty, HCloseStatus" +
			", HRemoveQty, HSeOrderBillNo, HUnReciveQty, HPOOrderBillDate, HPOOrderBillDeliveryDate" +
			", HPOOrderBillRemark, HPOOrderBillNote)" +
			$"values({HInterID}, {i}, '', {(HMaterID == null ? "0" : HMaterID)}, '{HMaterName}'" +
			$", '{HMaterModel}', {HUnitID}, '{HErpClsID}', {HQty}, ''" +
			$", {HPURCHASEORGIDSub}, '', {HFixleadTime}, '{HDayPlanBillNo}', {HSourceInterID}" +
			$", {HSourceEntryID}, '{HSourceBillNo}', '{HSourceBillType}', {HWorkShopID}, '{HDayPlanDate}'" +
			$", {HRelationQty}, {HPOOrderInterID},{HPOOrderEntryID}, '{HPOOrderBillNo}',0" +
			$",0,0, '',{HPurchaseDeptID}, '0'" +
			$", '','',0,0, '0'" +
			$",0, '{HSeOrderBillNo}',0, '{HPOOrderBillDate}', '{HPOOrderBillDeliveryDate}'" +
			$", '{HPOOrderBillRemark}', '{HPOOrderBillNote}')");
			}
			}

			if (tlmmm == PODemandPlanList.Count)
			{
			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "è¿ç®æå!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			oCN.RollBack();//äºå¡åæ»
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è¿ç®å¤±è´¥!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			LogService.Write("æä½å¤±è´¥ï¼" + e.Message.ToString());
			oCN.RollBack();//äºå¡åæ»
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.Message.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// éè¿æ¬ æè¡¨ ç®ææ å®å·¥
			/// </summary>
			/// <returns></returns>
			public object JIT_MOMaterLack(string HWorkShopID, int? HProdORGID, string user)
			{
			try
			{
			ds = oCN.RunProcReturn("exec h_p_JIT_PODemandPlanBill_MOMaterLack " + HWorkShopID.ToString() + ",'" + user + "'," + HProdORGID.ToString(), "h_p_JIT_PODemandPlanBill_MOMaterLack");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ææè¿ç®åçéè¯¯ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); //è¿ç®æå
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ææè¿ç®å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// éè¿é½å¥è¡¨ ç®ææ
			/// </summary>
			/// <returns></returns>
			public object JIT_MOMaterReady(string HWorkShopID, int? HProdORGID, string user)
			{
			try
			{
			ds = oCN.RunProcReturn("exec h_p_JIT_PODemandPlanBill_MOMaterReady " + HWorkShopID.ToString() + ",'" + user + "'," + HProdORGID.ToString(), "h_p_JIT_PODemandPlanBill_MOMaterReady");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ææè¿ç®åçéè¯¯ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); //è¿ç®æå
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ææè¿ç®å¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			#endregion

			#region çäº§æ¥è®¡åå¹³å° éå®
			@@ -1184,30 +3031,216 @@
			}
			#endregion

			#region çäº§æ¥è®¡åå¹³å° çäº§è®¢åæ¥è¯¢
			[Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillList")]
			#region çäº§æ¥è®¡åå¹³å° éå®å·¥å
			[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHLockedOrder")]
			[HttpGet]
			public object JIT_ICMOBillList(string hmainid, string HEntryID)
			public object JIT_DayPlanPlatFormBillHLockedOrder(string HInterIDs)
			{
			try
			{
			DataSet dt = new DataSet();
			oCN.RunProc("exec h_p_ICMOBillList_PrimarySubTable");
			ds = oCN.RunProcReturn($"select * from ##ICMOBillList where æºåä¸»åç in({hmainid}) and æºåååç in({HEntryID})", "##ICMOBillList");
			oCN.RunProc($"update Sc_WorkBillSortBillMain set HLockOrder = 1 where HInterID in ({HInterIDs})");

			for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			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

			#region çäº§æ¥è®¡åå¹³å° è§£éå·¥å
			[Route("JIT_DayPlanPlatFormBill/JIT_DayPlanPlatFormBillHUnlockOrder")]
			[HttpGet]
			public object JIT_DayPlanPlatFormBillHUnlockOrder(string HInterIDs)
			{
			try
			{
			oCN.RunProc($"update Sc_WorkBillSortBillMain set HLockOrder = 0 where HInterID in ({HInterIDs})");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			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

			#region çäº§æ¥è®¡åå¹³å° çäº§è®¢åæ¥è¯¢
			[Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillList")]
			[HttpGet]
			public object JIT_ICMOBillList(string hmainid)
			{
			try
			{
			var list = hmainid.Split(',');
			List<DataTable> listdt = new List<DataTable>();
			DataTable dtable = new DataTable("dt");
			for (int i = 0; i < list.Length; i++)
			{
			dt = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where æºåä¸»åç in({ds.Tables[0].Rows[i]["æºåä¸»åç "].ToString()}) and æºåååç in({ds.Tables[0].Rows[i]["æºåååç "].ToString()})", "h_v_JIT_Sc_WorkBillSortBillList");
			var listEvery = list[i].Split('_');

			ds = oCN.RunProcReturn($"exec h_p_ICMOBillList_PrimarySubTable '{listEvery[0]}','{listEvery[1]}'", "h_p_ICMOBillList_PrimarySubTable");

			var dt = oCN.RunProcReturn($"select * from h_v_JIT_Sc_WorkBillSortBillList where æºåä¸»åç in({ds.Tables[0].Rows[0]["æºåä¸»åç "].ToString()}) and æºåååç in({ds.Tables[0].Rows[0]["æºåååç "].ToString()})", "h_v_JIT_Sc_WorkBillSortBillList");
			if (dt.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "çäº§æç»è¡éå¤,éå¤ççäº§è®¢åå·:"+ ds.Tables[0].Rows[i]["çäº§è®¢åå·"].ToString()+",æç»è¡å·:"+ ds.Tables[0].Rows[i]["çäº§è®¢åæç»è¡å·"].ToString();
			objJsonResult.Message = "çäº§æç»è¡éå¤,éå¤ççäº§è®¢åå·:" + dt.Tables[0].Rows[i]["çäº§è®¢åå·"].ToString() + ",æç»è¡å·:" + dt.Tables[0].Rows[i]["çäº§è®¢åæç»è¡å·"].ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (i == 0)
			{
			//æ·»å åå
			for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
			{
			dtable.Columns.Add(ds.Tables[0].Columns[j].ToString());
			}
			}
			listdt.Add(ds.Tables[0]);
			}


			//è·åéåæ°æ®
			for (int i = 0; i < listdt.Count; i++)
			{
			DataRow row = dtable.NewRow();
			for (int j = 0; j < listdt[i].Columns.Count; j++)
			{
			if (listdt[i].Columns[j].ColumnName == "è®¡åæ°é")
			{
			row[j] = double.Parse(listdt[i].Rows[0][j].ToString()).ToString();
			}
			else
			{
			row[j] = listdt[i].Rows[0][j].ToString();
			}
			}
			dtable.Rows.Add(row);
			}

			//æ·»å å¨ææ¥æ
			for (int j = 1; j <= 31; j++)
			{
			dtable.Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32));
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = dtable;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region çäº§æ¥è®¡åå¹³å° æ°æ®åå¤ è®¾ç½®ä»»å¡åç¸å³ä¿¡æ¯
			[Route("JIT_DayPlanPlatFormBill/ReadyData")]
			[HttpGet]
			public object ReadyData(string SWhere)
			{
			try
			{
			var list = SWhere.Split(',');
			DataTable dt = new DataTable("date");
			dt.Columns.Add("HICMOInterID", typeof(string));
			dt.Columns.Add("HICMOEntryID", typeof(string));
			dt.Columns.Add("å°æ¶äº§è½", typeof(string));
			dt.Columns.Add("çäº§å¨æ", typeof(decimal));
			dt.Columns.Add("å¼å·¥ä½é", typeof(decimal));
			dt.Columns.Add("æè¿å¼å·¥æ¥æ", typeof(DateTime));
			dt.Columns.Add("æè¿å®å·¥æ¥æ", typeof(DateTime));
			dt.Columns.Add("è®¢åéæ±æ°é", typeof(decimal));
			dt.Columns.Add("è®¢åäº¤è´§æ", typeof(DateTime));

			for (int i = 0; i < list.Length; i++)
			{
			string HICMOInterID = list[i].Split(';')[0].ToString();
			string HICMOEntryID = list[i].Split(';')[1].ToString();
			string HSourceID = list[i].Split(';')[2].ToString();

			Thread.Sleep(100);
			ds = oCN.RunProcReturn("exec h_p_Sc_GetInfoByICMOBillNo " + HICMOInterID+","+ HICMOEntryID+","+ HSourceID, "h_p_Sc_GetInfoByICMOBillNo");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{

			}
			else
			{
			DataRow dr = dt.NewRow();
			dr["å°æ¶äº§è½"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["äº§è½"]);
			dr["çäº§å¨æ"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["çäº§å¨æ"]);
			dr["å¼å·¥ä½é"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["å¼å·¥ä½é"]);
			dr["æè¿å¼å·¥æ¥æ"] = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["æè¿å¼å·¥æ¥æ"]);
			dr["æè¿å®å·¥æ¥æ"] = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["æè¿å®å·¥æ¥æ"]);
			dr["è®¢åéæ±æ°é"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["è®¢åéæ±æ°"]);
			dr["è®¢åäº¤è´§æ"] = DBUtility.ClsPub.isDate(ds.Tables[0].Rows[0]["è®¢åäº¤è´§æ"]);
			dr["HICMOInterID"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["HICMOInterID"]);
			dr["HICMOEntryID"] = DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[0]["HICMOEntryID"]);
			dt.Rows.Add(dr);
			}
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = dt;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region ç¼ºæåææ¥è¡¨
			public class MaterialShorAnalysis
			{
			public int? HORGID;
			public DateTime HBEGINDATE;
			public DateTime HENDDATE;
			}
			[Route("JIT_DayPlanPlatFormBill/MaterialShorAnalysisReport")]
			[HttpGet]
			public object MaterialShorAnalysisReport(string sWhere)
			{
			try
			{
			MaterialShorAnalysis Report = JsonConvert.DeserializeObject<MaterialShorAnalysis>(sWhere);

			ds = oCN.RunProcReturn($"exec h_p_JIT_MaterialShorAnalysisReportList {Report.HORGID},'{Report.HBEGINDATE}','{Report.HENDDATE}' ", "h_p_JIT_PODemandPlanBill_ReportList");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			@@ -1225,5 +3258,363 @@
			}
			#endregion

			#region æ ¹æ®ç©æIDè·åå·¥èºè·¯çº¿ åè¡¨
			[Route("JIT_DayPlanPlatFormBill/GetRoutingListByMater")]
			[HttpGet]
			public object GetRoutingListByMater(int HMaterID, string user)
			{
			try
			{
			List<object> columnNameList = new List<object>();

			int IsHavingPermissions = 1;

			//å¤ææ¯å¦æå·¥èºè·¯çº¿ç¼è¾æé
			if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Edit", 1, false, user))
			{
			IsHavingPermissions = 0;
			}

			ds = oCN.RunProcReturn("select * from h_v_JIT_GetRoutingList_Mater where HMaterID = " + HMaterID , "h_v_JIT_GetRoutingList_Mater");

			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å½åç©ææ²¡æç»´æ¤å·¥èºè·¯çº¿ï¼è¯·èç³»è®¡åé¨è¿è¡ç»´æ¤";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.IsHavingPermissions = IsHavingPermissions;
			return objJsonResult;
			}
			else
			{
			//æ·»å åå
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnåå¯¹è±¡çåå
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			objJsonResult.IsHavingPermissions = IsHavingPermissions;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region çäº§æ¥è®¡åå¹³å° æ ¹æ®è½¦é´æ·»å æªæäº§çäº§è®¢å
			[Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillListByDept")]
			[HttpGet]
			public object JIT_ICMOBillListByDept(string HDeptID)
			{
			try
			{
			//è·åæ¾ç¤ºç³»ç»åæ°
			string sReturn = "";
			oSystemParameter.ShowBill(ref sReturn);

			//æ¥è¯¢éæ©è½¦é´ä¸æªæäº§è¿ççäº§è®¢åä¿¡æ¯ï¼æ·»åº·ç§æ--çäº§è®¢åç¶æä¸ºä¸è¾¾ï¼
			ds = oCN.RunProcReturn($"exec h_p_JIT_ICMOBillListByDept '{HDeptID}'", "h_p_JIT_ICMOBillListByDept");

			if (ds.Tables[0].Rows.Count > 0 && ds != null)
			{
			if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			//æ°æ®è¡¨æ ¼æ·»å å¨ææ¥æ
			for (int j = 1; j <= 180; j++)
			{
			ds.Tables[0].Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32));
			}
			}
			else
			{
			//æ°æ®è¡¨æ ¼æ·»å å¨ææ¥æ
			for (int j = 1; j <= 31; j++)
			{
			ds.Tables[0].Columns.Add(DateTime.Now.AddDays(j - 1).ToString("yyyy-MM-dd"), typeof(Int32));
			}
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ¥æ æ°æ®ï¼å½åæéè½¦é´ä¸ææ æªæäº§ä¸è®¢åç¶æä¸ºä¸è¾¾ççäº§è®¢åä¿¡æ¯ï¼";
			objJsonResult.data = "";
			return objJsonResult;
			}

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region çäº§æ¥è®¡åå¹³å° è·åå®å·¥æ¥æ
			[Route("JIT_DayPlanPlatFormBill/GetICMOCompletionDate")]
			[HttpGet]
			public object GetICMOCompletionDate(string HDeptID)
			{
			try
			{
			//æ´æ°æ¥è®¡åå·¥åçå®å·¥æ¥æ
			oCN.RunProc($"exec h_p_JIT_GetICMOCompletionDate '{HDeptID}'");

			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

			#region çäº§æ¥è®¡åå¹³å° è·åææ©å¼å·¥æ¥æ
			[Route("JIT_DayPlanPlatFormBill/GetICMOEarlyDate")]
			[HttpGet]
			public object GetICMOEarlyDate(string HDeptID)
			{
			try
			{
			//æ´æ°çäº§è®¢åçææ©å¼å·¥æ¥æ
			oCN.RunProc($"exec h_p_JIT_GetICMOEarlyDate '{HDeptID}'");

			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

			#region éè¿ç©æå¹éäº§åå¨å·æ¸å
			[Route("JIT_DayPlanPlatFormBill/GetMouldByMater")]
			[HttpGet]
			public object GetMouldByMater(string HMaterID,string HSourceID,string HPCDate)
			{
			try
			{
			ds = oCN.RunProcReturn("exec h_p_Gy_MaterialMouldByMater " + HMaterID + "," + HSourceID + ",'" + HPCDate + "'", "h_p_Gy_MaterialMouldByMater");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region éè¿èµæºå¹éèµæºå¨å·æ¸å
			[Route("JIT_DayPlanPlatFormBill/GetMouldBySource")]
			[HttpGet]
			public object GetMouldBySource(string HSourceID, string HMouldID)
			{
			try
			{
			ds = oCN.RunProcReturn("select * from h_v_Gy_SourceMouldBillMainList where HSourceID = " + HSourceID + " and HMouldID = " + HMouldID, "h_v_Gy_SourceMouldBillMainList");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region æäº§åå°å¨å·å ç¨æ¶é´åå¥æ°æ®åº
			[Route("JIT_DayPlanPlatFormBill/AddMouldOccupancyTime")]
			[HttpGet]
			public object AddMouldOccupancyTime(string HMouldID, string HSourceID, string HICMOInterID, string HICMOEntryID, string HICMOBillNo, string HMouldPCTime)
			{
			try
			{
			ds = oCN.RunProcReturn("exec h_p_JIT_AddMouldOccupancyTime " + HMouldID + "," + HSourceID + "," + HICMOInterID + "," + HICMOEntryID + ",'" + HICMOBillNo + "','" + HMouldPCTime + "'", "h_p_JIT_AddMouldOccupancyTime");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = "";
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region éè¿ä¸»èµæºå¹éåèµæº
			[Route("JIT_DayPlanPlatFormBill/GetChildSource")]
			[HttpGet]
			public object GetChildSource(string HSourceID)
			{
			try
			{
			ds = oCN.RunProcReturn("select HItemID åèµæºID,HNumber åèµæºä»£ç ,HName åèµæºåç§°,HCubicleQty åèµæºå·¥ä½æ° from Gy_Source with(nolock) where HParentID = " + HSourceID + " order by HName asc", "Gy_Source");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region å¤æç©ææ¯å¦å¯ä»¥æ¾å¨åä¸èµæºä¸ä¸èµ·çäº§
			[Route("JIT_DayPlanPlatFormBill/GetSourceByMater")]
			[HttpGet]
			public object GetSourceByMater(string HMaterID)
			{
			try
			{
			ds = oCN.RunProcReturn("exec h_p_Sc_ICMOGetWorkSource_TK " + HMaterID + ",'',''", "h_p_Sc_ICMOGetWorkSource_TK");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region å·¥åºè´è·åææ±æ»æ¥è¡¨ æ¥è¯¢
			/// <summary>
			/// è¿åé¡¹ç®é¶æ®µåè¡¨
			///åæ°ï¼string sqlã
			///è¿åå¼ï¼objectã
			/// </summary>
			[Route("JIT_DayPlanPlatFormBill/JIT_FuHeFenXiReport")]
			[HttpGet]
			public object JIT_FuHeFenXiReport(string sWhere, string user)
			{
			try
			{

			//æ¥çæé
			if (!DBUtility.ClsPub.Security_Log("JIT_FuHeFenXiReport", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æ¥çæéï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			List<object> columnNameList = new List<object>();
			string sql = "exec h_p_JIT_FuHeFenXiReport '" + sWhere + "','" + user + "'";

			ds = oCN.RunProcReturn(sql, "h_p_JIT_FuHeFenXiReport");

			//æ·»å åå
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnåå¯¹è±¡çåå
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion



			}
			}