1
llj
13 小时以前 92f687bc71685c121da890161ade3f2040c8b3d7
WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
@@ -365,9 +365,9 @@
                        int HCostItemID = int.Parse(item["HCostItemID"].ToString()); //成本项目ID
                        int HMaterID = int.Parse(item["HMaterID"].ToString());       //物料ID
                        int HProcID = int.Parse(item["HProcID"].ToString());         //工序ID
                        int HBeginQty = int.Parse(item["期初数量"].ToString());
                        int HBeginBal = int.Parse(item["期初金额"].ToString());
                        Double HBeginQty = Double.Parse(item["期初数量"].ToString());
                        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}";
                        DataSet ds = oCN.RunProcReturn(checkMainSql, "Kf_WIPBalMain");
@@ -414,7 +414,7 @@
                                         HBeginBal, HCnangeBal, HDebit, HDebit_Sum, HCredit,
                                         HEndBal, HEndBal_Rel, HYtdDebit, HYtdCredit,
                                         HBeginDiff, HReceiveDiff, HSendDiff, HEndDiff,
                                         HYtdReceiveDiff, HYtdSendDiff)
                                         HYtdReceiveDiff, HYtdSendDiff,HPanelQty)
                                        values
                                        ({HInterID}, {HEntryID}, {HCostItemID}, {HMaterID}, {HProcID}, 0,
                                         {HBeginQty}, 0, 0, 0, 0,
@@ -422,7 +422,7 @@
                                         {HBeginBal}, 0, 0, 0, 0,
                                         0, 0, 0, 0,
                                         0, 0, 0, 0,
                                         0, 0)";
                                         0, 0,{HPanelQty})";
                        oCN.RunProc(insertSubSql);