派生自 MES-WEB-API
WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_DayPlanPlatFormBillController.cs
@@ -236,12 +236,22 @@ var HICMOBillNo = list[i]["ç产订åå·"].ToString(); var HICMOEntrySEQ = list[i]["ç产订åæç»è¡å·"].ToString(); var HSourceID = list[i]["HSourceID"].ToString(); var HYX = list[i]["ä¼å 级"].ToString(); 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}è¡ä¼å 级:{HYX},请è¾å ¥æ°å!"; objJsonResult.data = null; return objJsonResult; } @@ -258,7 +268,7 @@ return objJsonResult; } oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID == "" ? 0.ToString() : HSourceID)} where HInterID={list[i]["hmainid"].ToString()} and HBillNo='{list[i]["åæ®å·"].ToString()}'"); oCN.RunProc($"update Sc_WorkBillSortBillMain set HSourceID={(HSourceID == "" ? 0.ToString() : HSourceID)},HYX={HYX} 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)}'"); @@ -514,6 +524,14 @@ /// ä»åºç¼ç /// </summary> public string FStockNumber { get; set; } /// <summary> /// æ¹å· /// </summary> public string HLOT { get; set; } /// <summary> /// id /// </summary> public string HInventoryFID { get; set; } } #endregion @@ -677,6 +695,9 @@ public string FStock { get; set; } //è½¦é´ public string FWorkShop { get; set; } //æ¹å· public string HLOT { get; set; } public string HInventoryFID { get; set; } } #endregion @@ -736,10 +757,11 @@ //è·åå½åå³æ¶åºå åºåæ°é+åºåç»ç»+ç©æ+货主+ä»åº 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 isnull(a.FBASEQTY,0) FBASEQTY,b.FNumber,a.FOwnerTypeId,a.FOwnerId,c.FNUMBER as FOwnerNumber,a.FSTOCKID,d.FNUMBER as FStockNumber ,a.FLOT HLOT,a.FID HInventoryFID from ( select distinct a.HProdORGID FStockOrgId,T2.FMATERIALID,FNumber from SC_WORKBILLSORTBILLMAIN a join SC_WORKBILLSORTBILLSub b on a.HInterID = b.HInterID 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 @@ -954,7 +976,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; @@ -1033,6 +1057,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 +1091,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,12 +1108,14 @@ ", 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); //æ§è¡å®æå æ´æ°æ¥è®¡åå·¥åç¶æ @@ -1187,31 +1217,67 @@ #region ç产æ¥è®¡åå¹³å° ç产订åæ¥è¯¢ [Route("JIT_DayPlanPlatFormBill/JIT_ICMOBillList")] [HttpGet] public object JIT_ICMOBillList(string hmainid, string HEntryID) public object JIT_ICMOBillList(string hmainid) { 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"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) 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 = "ç产æç»è¡éå¤,éå¤çç产订åå·:" + ds.Tables[0].Rows[i]["ç产订åå·"].ToString() + ",æç»è¡å·:" + ds.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 = ds.Tables[0]; objJsonResult.data = dtable; return objJsonResult; } catch (Exception e)
