智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yxj
2025-11-28 5286b614c84f8f82f81772cdb32c2dc5a0d26e0f 
 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_DayPlanPlatFormImportController.cs


@@ -1826,6 +1826,7 @@


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


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


                        var HSourceID = "0";


                        var HSourceName = list[i]["生产资源"].ToString();


                        var HWorkQty = DBUtility.ClsPub.isDoule(list[i]["产能"]);


                        var HYX = list[i]["优先级"].ToString();


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


@@ -1844,6 +1845,10 @@


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


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






                        var ds = oCN.RunProcReturn($@"select * from Gy_Source where HName= '{HSourceName}'", "Gy_Source");


                        HSourceID = ds.Tables[0].Rows[0]["HItemID"].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,'') = ''";


                        LogService.Write("sql:" + sql);