抽样方案基础资料

llj

3 天以前 b4dba39ce6afc201ede288ada4295a5fa345092f

 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}')";