智云MES后端API代码
parent: 0d81aae3 | 补丁 | 提交 | ignore whitespace
yusijie
2026-01-21 225651f4626d77df4420fba3837966d09d877c27 
添康excel导入排产信息；巡检单新增语句补齐引号
2个文件已修改
12 ■■■■■ 已修改文件
WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormImportController.cs 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/ClsQC_PatrolProcCheckBill.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 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();




 WebAPI/DLL/ClsQC_PatrolProcCheckBill.cs


@@ -258,8 +258,8 @@


                      "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +


                      "," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HQCNote1 + "','" + oSub.HQCNote2 + "','" + oSub.HQCNote3 + "','" + oSub.HQCNote4 + "'" +


                      ",'" + oSub.HQCNote5 + "','" + oSub.HQCNote6 + "','" + oSub.HQCNote7 + "','" + oSub.HQCNote8 + "','" + oSub.HQCNote9 + "','" + oSub.HQCNote10 + "','" + oSub.HQCNote1_SN + "','" + oSub.HQCNote2_SN + "','" + oSub.HQCNote3_SN + "','" + oSub.HQCNote4_SN + "','" + oSub.HQCNote5_SN + "','" + oSub.HQCNote6_SN + "','" + oSub.HQCNote7_SN + "','" + oSub.HQCNote8_SN + "','" + oSub.HQCNote9_SN + "','" + oSub.HQCNote10_SN + "'" +


                      ","+ oSub.HTargetVal+","+ oSub.HInspectMethodID+","+ oSub.HDownLimit+","+ oSub.HUpLimit + ",'"+ oSub.HAnalysisMethod+"'"+


                          "," + oSub.HTargetVal2 + "," + oSub.HTargetVal3 + "," + oSub.HTargetVal4 + "," + oSub.HTargetVal5 + "," + oSub.HTargetVal6 +


                      ",'"+ oSub.HTargetVal+"',"+ oSub.HInspectMethodID+",'"+ oSub.HDownLimit+"','"+ oSub.HUpLimit + "','"+ oSub.HAnalysisMethod+"'"+


                          ",'" + oSub.HTargetVal2 + "','" + oSub.HTargetVal3 + "','" + oSub.HTargetVal4 + "','" + oSub.HTargetVal5 + "','" + oSub.HTargetVal6 + "'" +


                      ") ");


                }


                //插入子表2