| | |
| | | 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"); |
| | |
| | | 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, |
| | |
| | | {HBeginBal}, 0, 0, 0, 0, |
| | | 0, 0, 0, 0, |
| | | 0, 0, 0, 0, |
| | | 0, 0)"; |
| | | 0, 0,{HPanelQty})"; |
| | | |
| | | oCN.RunProc(insertSubSql); |
| | | |