| | |
| | | } |
| | | else if (costObject == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "第" + index + "行,该" + HORGName + "组织,成本对象:" + costObject + ",为空"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | tb2.Rows[i]["HCostObjID"] = 0; |
| | | } |
| | | else |
| | | { |
| | |
| | | // 插入主表 |
| | | 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}')"; |
| | | |