1

wangyi

2026-01-22 35139325316d0eda0a55136cbf08fae699c08536

 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/JIT_DayPlanPlatFormImportController.cs

@@ -2110,6 +2110,12 @@
                        return objJsonResult;
                    }

                    //导出excel表格时，前面的0没掉了，这边做补0的动作；
                    if (tb2.Rows[i]["生产车间编码"].ToString().Length == 4)
                    {
                        tb2.Rows[i]["生产车间编码"] = "0" + tb2.Rows[i]["生产车间编码"].ToString();
                    }                   

                    string 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());
@@ -2331,7 +2337,7 @@
                        var HProdORGID = list[i]["HProdORGID"].ToString();
                        var HWorkShopID = list[i]["HWorkShopID"].ToString();
                        var HSourceID = list[i]["HSourceID"].ToString();
                        var HWorkQty = DBUtility.ClsPub.isDoule(list[i]["产线总产能"]);
                        var HWorkQty = DBUtility.ClsPub.isDoule(list[i]["小时产能"]);
                        var HYX = list[i]["优先级"].ToString();
                        var HEmpID = list[i]["HEmpID"].ToString();
                        var HMaterID = list[i]["HMaterID"].ToString();