| | |
| | | e.FieldKeys.Add("FBaseActualQty"); |
| | | } |
| | | /// <summary> |
| | | ///反审核 反更新日计划用料清单领料数量 |
| | | ///审核更新日计划用料清单领料数量 |
| | | /// </summary> |
| | | /// <param name="e"></param> |
| | | public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e) |
| | |
| | | sql = string.Format($"/*dialect*/update Sc_DayPlanPPBomBillSub set FPickedQty = FPickedQty + {Convert.ToDecimal(entryRow["BaseActualQty"])} where FEntryID = {fentryId} "); |
| | | //LogHelper.Info("领料单的日计划用料清单ID:" + fentryId); |
| | | sqlList.Add(sql); |
| | | sql = string.Format($"/*dialect*/update T_PRD_PICKMTRLDATA set FisFX = 1 where FentryId = {entryRow["Id"]}"); |
| | | sqlList.Add(sql); |
| | | } |
| | | } |
| | | DBServiceHelper.ExecuteBatch(Context, sqlList); |