智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
chenhaozhe
2026-04-20 86f004f924cc0a920df4d4ced72640471db01c54 
 WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs


@@ -369,7 +369,7 @@


                        Double HBeginBal = Double.Parse(item["期初金额"].ToString());


                        Double HPanelQty = Double.Parse(item["拼板数"].ToString());


                        // 1. 检查主表是否存在记录


                        string checkMainSql = $"select HInterID from Kf_WIPBalMain where HOrgID='{HOrgID}' and HWorkShopID={HWorkShopID} and HCostObjID={HCostObjID}";


                        string checkMainSql = $"select HInterID from Kf_WIPBalMain where HOrgID='{HOrgID}' and HWorkShopID={HWorkShopID} and HCostObjID={HCostObjID} and HYear ={HYear} and HPeriod = {HPeriod}";


                        DataSet ds = oCN.RunProcReturn(checkMainSql, "Kf_WIPBalMain");




                        int HInterID;


@@ -385,11 +385,11 @@


                            // 插入主表


                            string insertMainSql = $@"


                                        insert into Kf_WIPBalMain 


                                        ( HYear, HPeriod, HCostCenterID, HWorkShopID, HCostObjID, 


                                        (HInterID, HYear, HPeriod, HCostCenterID, HWorkShopID, HCostObjID, 


                                         HICMOInterID, HProcExchInterID, HProcExchEntryID, HIsBack, HBatchNo,


                                         HMaker, HMakeDate, HOrgID)


                                        values 


                                        ( {HYear}, {HPeriod}, 0, {HWorkShopID}, {HCostObjID},


                                        ({HInterID},{HYear}, {HPeriod}, 0, {HWorkShopID}, {HCostObjID},


                                         0, 0, 0, 0, '',


                                         '{user}', getdate(), '{HOrgID}')";