blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
ch
2022-05-30 f9ef44a67fbf73f073efe65600bc25e204fde04f 
 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_DayPlanPlatFormImportController.cs


@@ -126,6 +126,7 @@


                        tb2.Rows[i]["HWorkShopID"] = ds.Tables[0].Rows[0]["HDeptID"].ToString();


                        tb2.Rows[i]["ICMOBillHInterID"] = ds.Tables[0].Rows[0]["hmainid"].ToString();//生产订单主id


                        tb2.Rows[i]["ICMOBillHEntryID"] = ds.Tables[0].Rows[0]["HEntryID"].ToString();//生产订单子id


                        tb2.Rows[i]["生产订单数量"] = ds.Tables[0].Rows[0]["生产任务单数量"].ToString();//生产订单数量


                    }




                    ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList " +


@@ -147,7 +148,6 @@


                        tb2.Rows[i]["计量单位"] = ds.Tables[0].Rows[0]["计量单位"].ToString();


                        tb2.Rows[i]["批次号"] = ds.Tables[0].Rows[0]["批次"].ToString();


                        tb2.Rows[i]["销售订单数量"] = ds.Tables[0].Rows[0]["销售订单数量"].ToString();


                        tb2.Rows[i]["生产订单数量"] = ds.Tables[0].Rows[0]["订单需求数量"].ToString();


                        tb2.Rows[i]["总齐套数量"] = ds.Tables[0].Rows[0]["齐套数量"].ToString();


                    }


                    else


@@ -270,7 +270,7 @@


                        var HUnitID = list[i]["HUnitID"].ToString();


                        var HBatchNo = list[i]["批次号"].ToString();


                        var HSeOrderBillQty = list[i]["销售订单数量"].ToString();


                        var HOrderNeedQty = list[i]["生产订单数量"].ToString();


                        var HPlanQty = list[i]["生产订单数量"].ToString();


                        var HCompleteQty = list[i]["总齐套数量"].ToString();


                        var HOrderType = omdelMian.HOrderType;


                        var HDate = omdelMian.HDate;


@@ -293,13 +293,13 @@


                            "HBillSubType,HDate,HBillStatus,HMaker,HMakeDate,HICMOBillNo,HOrderType," +


                            "HICMOEntrySEQ,HWorkShopID,HSourceID, HYX, HEmpID," +


                            " HMaterID, HMaterName, HMaterModel, HUnitID, HBatchNo," +


                            " HSeOrderBillQty, HOrderNeedQty, HCompleteQty,HPreparatDate," +


                            " HSeOrderBillQty, HPlanQty, HCompleteQty,HPreparatDate," +


                            "HMainSourceInterID,HMainSourceEntryID)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)}, {(HEmpID == "" ? 0.ToString() : HEmpID)}," +


                            $" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, '{HBatchNo}'," +


                            $" {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}, {(HOrderNeedQty == "" ? 0.ToString() : HOrderNeedQty)}, {(HCompleteQty == "" ? 0.ToString() : HCompleteQty)},getdate()," +


                            $" {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}, {(HPlanQty == "" ? 0.ToString() : HPlanQty)}, {(HCompleteQty == "" ? 0.ToString() : HCompleteQty)},getdate()," +


                            $" {HMainSourceInterID},{HMainSourceEntryID})");


                    }