| | |
| | | tb2.Columns.Add("ICMOBillHEntryID", typeof(Int32));//ç产订ååid |
| | | tb2.Columns.Add("HProdORGID", typeof(Int32));//ç»ç»id |
| | | tb2.Columns.Add("HSeOrderBillNo", typeof(string));//éå®è®¢åå· |
| | | tb2.Columns.Add("HVersion_Import", typeof(string));//导å
¥åºåå· |
| | | |
| | | //è·åç³»ç»åæ° |
| | | string Ret = ""; |
| | |
| | | //æ¥è¯¢ç产订åè¡¨å¤æææ²¡æç产订åä¿¡æ¯ |
| | | for (int i = 0; i < tb2.Rows.Count; i++) |
| | | { |
| | | tb2.Rows[i]["HVersion_Import"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | |
| | | |
| | | if (tb2.Rows[i]["ç»ç»ç¼ç *"].ToString() == "") |
| | | error += "ç»ç»ç¼ç ä¸è½ä¸ºç©º;"; |
| | | if (tb2.Rows[i]["ç产订åå·*"].ToString() == "") |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string sql1 = string.Format("select * from h_v_JIT_ICMOBillList_DR where åæ®å·='{0}' and ç产车é´ä»£ç ='{1}' and 产å代ç ='{2}' and æç»è¡å·={3} ", |
| | | string sql1 = ""; |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "å®å·¥") |
| | | { |
| | | sql1 = "select * from h_v_JIT_ICMOBillList_DR where åæ®å·='" + tb2.Rows[i]["ç产订åå·*"].ToString() + "' and 产å代ç ='" + tb2.Rows[i]["ç©æç¼ç *"].ToString() + "' and æç»è¡å·=" + tb2.Rows[i]["ç产订åæç»è¡å·*"].ToString(); |
| | | } |
| | | else |
| | | { |
| | | sql1 = string.Format("select * from h_v_JIT_ICMOBillList_DR where åæ®å·='{0}' and ç产车é´ä»£ç ='{1}' and 产å代ç ='{2}' and æç»è¡å·={3} ", |
| | | tb2.Rows[i]["ç产订åå·*"].ToString(), tb2.Rows[i]["ç产车é´ç¼ç *"].ToString(), tb2.Rows[i]["ç©æç¼ç *"].ToString(), tb2.Rows[i]["ç产订åæç»è¡å·*"].ToString()); |
| | | } |
| | | ds = oCN.RunProcReturn(sql1, "h_v_JIT_ICMOBillList_DR"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | |
| | | objJsonResult.data = tb2; |
| | | return objJsonResult; |
| | | } |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "å®å·¥") |
| | | { |
| | | string HOrgID = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | //çäº§è½¦é´ |
| | | ds = oCN.RunProcReturn($"select * from Gy_Department with(nolock) where HUSEORGID = {HOrgID} and HNumber='{tb2.Rows[i]["ç产车é´ç¼ç *"].ToString()}'", "Gy_Department"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | tb2.Rows[i]["HWorkShopID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"第{i + 1}è¡,çäº§è½¦é´æ¥æ æ°æ®!"; |
| | | objJsonResult.data = tb2; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | |
| | | var HMainSourceInterID = list[i]["ICMOBillHInterID"].ToString(); |
| | | var HMainSourceEntryID = list[i]["ICMOBillHEntryID"].ToString(); |
| | | var HSeOrderBillNo = list[i]["HSeOrderBillNo"].ToString(); |
| | | var HVersion_Import = list[i]["HVersion_Import"].ToString(); |
| | | |
| | | string sql = $"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" + |
| | | $" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID} and ISNULL(HDeleteMan,'') = ''"; |
| | |
| | | " HMaterID, HMaterName, HMaterModel, HUnitID, HBatchNo," + |
| | | " HSeOrderBillQty, HPlanQty, HCompleteQty,HPreparatDate," + |
| | | "HMainSourceInterID,HMainSourceEntryID,HICMOInterID,HICMOEntryID,HProdORGID,HICMOInterID_Sec,HICMOEntryID_Sec" + |
| | | ",HSeOrderBillNo)values" + |
| | | ",HSeOrderBillNo,HVersion_Import)values" + |
| | | $"({HInterID},'{HBillNo}',{DateTime.Now.Year},{DateTime.Now.Month},'{BillType}'," + |
| | | $"'{BillType}',GETDATE(),1,'{user}','{HDate}','{HICMOBillNo}','{HOrderType}'," + |
| | | $"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID == "" ? 0.ToString() : HSourceID)}, {(HYX == "" ? 0.ToString() : HYX)},{(HWorkQty)}, {(HEmpID == "" ? 0.ToString() : HEmpID)}," + |
| | | $" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, '{HBatchNo}'," + |
| | | $" {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}, {(HPlanQty == "" ? 0.ToString() : HPlanQty)}, {(HCompleteQty == "" ? 0.ToString() : HCompleteQty)},getdate()," + |
| | | $" {HMainSourceInterID},{HMainSourceEntryID},{HMainSourceInterID},{HMainSourceEntryID},{HProdORGID}, {HMainSourceInterID},{HMainSourceEntryID}" + |
| | | $",'{HSeOrderBillNo}')"); |
| | | $",'{HSeOrderBillNo}','{HVersion_Import}')"); |
| | | } |
| | | |
| | | int SumDay = 31; //卿䏤æä¹å·® DateTime.Now.AddMonths(1).AddDays(-1).Subtract(DateTime.Now).Days; |