| | |
| | | if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "") |
| | | continue; |
| | | string fentryId = entryRow["FDayPlanFentryId"].ToString(); |
| | | sql = string.Format($"/*dialect*/update Sc_WorkBillSortBillSub set FRptFinishQty = (select sum(FBaseQuaQty) from T_PRD_MORPTENTRY where FDayPlanFentryId = { fentryId})where FEntryID = { fentryId} "); |
| | | sql = string.Format($"/*dialect*/update Sc_WorkBillSortBillSub set FRptFinishQty = (select sum(FFinishQty) from T_PRD_MORPTENTRY where FDayPlanFentryId = { fentryId})where FEntryID = { fentryId} "); |
| | | sqlList.Add(sql); |
| | | } |
| | | } |
| | |
| | | } |
| | | return string.Empty; |
| | | } |
| | | |
| | | public void WriteImportLog() |
| | | { |
| | | try |
| | |
| | | string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper(); |
| | | if (saveIsSuc != "TRUE") |
| | | { |
| | | LogHelper.Error(saveObj.ToString()); |
| | | LogHelper.Error("日计划用料清单列表生成失败:" + jsonRoot.ToString()); |
| | | this.View.ShowMessage(saveObj["Result"]["ResponseStatus"]["Errors"][0]["Message"].ToString()); |
| | | } |
| | | Fentity = new JArray(); |
| | | } |