public async Task <VerifyRecordResult> BeforeUpdateCheckAsync(FlowHistoryAdapterModel paraObject) { CleanTrackingHelper.Clean <FlowHistory>(context); if (paraObject.MyUserId == 0) { return(VerifyRecordResultFactory.Build(false, "需要指定一個使用者")); } var searchItem = await context.FlowHistory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.要更新的紀錄_發生同時存取衝突_已經不存在資料庫上)); } searchItem = await context.FlowHistory .AsNoTracking() .FirstOrDefaultAsync(x => x.FlowMasterId == paraObject.FlowMasterId && x.MyUserId == paraObject.MyUserId && x.Id != paraObject.Id); if (searchItem != null) { return(VerifyRecordResultFactory.Build(false, "同一個簽核政策內,使用者不能重複指定")); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <VerifyRecordResult> UpdateAsync(FlowHistoryAdapterModel paraObject) { try { FlowHistory itemData = Mapper.Map <FlowHistory>(paraObject); CleanTrackingHelper.Clean <FlowHistory>(context); FlowHistory item = await context.FlowHistory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (item == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法修改紀錄)); } else { CleanTrackingHelper.Clean <FlowHistory>(context); context.Entry(itemData).State = EntityState.Modified; await context.SaveChangesAsync(); CleanTrackingHelper.Clean <FlowHistory>(context); return(VerifyRecordResultFactory.Build(true)); } } catch (Exception ex) { Logger.LogError(ex, "修改記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "修改記錄發生例外異常", ex)); } }
public async Task OnCommandClicked(CommandClickEventArgs <FlowHistoryAdapterModel> args) { FlowHistoryAdapterModel item = args.RowData as FlowHistoryAdapterModel; if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdEdit) { #region 點選 修改紀錄 按鈕 CurrentRecord = item.Clone(); EditRecordDialogTitle = "修改紀錄"; IsShowEditRecord = true; isNewRecordMode = false; #endregion } else if (args.CommandColumn.ButtonOption.IconCss == ButtonIdHelper.ButtonIdDelete) { #region 點選 刪除紀錄 按鈕 CurrentNeedDeleteRecord = item; #region 檢查關聯資料是否存在 var checkedResult = await CurrentService .BeforeDeleteCheckAsync(CurrentNeedDeleteRecord); await Task.Delay(100); if (checkedResult.Success == false) { MessageBox.Show("400px", "200px", "警告", ErrorMessageMappingHelper.Instance.GetErrorMessage(checkedResult.MessageId), MessageBox.HiddenAsync); await Task.Yield(); thisView.NeedRefresh(); return; } #endregion #region 刪除這筆紀錄 await Task.Yield(); var checkTask = ConfirmMessageBox.ShowAsync("400px", "200px", "警告", "確認要刪除這筆紀錄嗎?", ConfirmMessageBox.HiddenAsync); thisView.NeedRefresh(); var checkAgain = await checkTask; if (checkAgain == true) { var verifyRecordResult = await CurrentService.DeleteAsync(CurrentNeedDeleteRecord.Id); await TranscationResultHelper.CheckDatabaseResult(MessageBox, verifyRecordResult); dataGrid.RefreshGrid(); } #endregion #endregion } }
public async Task <FlowHistoryAdapterModel> GetAsync(int id) { FlowHistory item = await context.FlowHistory .AsNoTracking() .Include(x => x.MyUser) .FirstOrDefaultAsync(x => x.Id == id); FlowHistoryAdapterModel result = Mapper.Map <FlowHistoryAdapterModel>(item); await OhterDependencyData(result); return(result); }
public async Task <VerifyRecordResult> BeforeDeleteCheckAsync(FlowHistoryAdapterModel paraObject) { CleanTrackingHelper.Clean <FlowHistory>(context); var searchItem = await context.FlowHistory .AsNoTracking() .FirstOrDefaultAsync(x => x.Id == paraObject.Id); if (searchItem == null) { return(VerifyRecordResultFactory.Build(false, ErrorMessageEnum.無法刪除紀錄_要刪除的紀錄已經不存在資料庫上)); } return(VerifyRecordResultFactory.Build(true)); }
public void ToolbarClickHandler(Syncfusion.Blazor.Navigations.ClickEventArgs args) { if (args.Item.Id == ButtonIdHelper.ButtonIdAdd) { CurrentRecord = new FlowHistoryAdapterModel(); #region 針對新增的紀錄所要做的初始值設定商業邏輯 #endregion EditRecordDialogTitle = "新增紀錄"; isNewRecordMode = true; IsShowEditRecord = true; CurrentRecord.FlowMasterId = Header.Id; //CurrentRecord.Name = Header.Title; } else if (args.Item.Id == ButtonIdHelper.ButtonIdRefresh) { dataGrid.RefreshGrid(); } }
public async Task <VerifyRecordResult> BeforeAddCheckAsync(FlowHistoryAdapterModel paraObject) { CleanTrackingHelper.Clean <FlowHistory>(context); if (paraObject.MyUserId == 0) { return(VerifyRecordResultFactory.Build(false, "需要指定一個使用者")); } var item = await context.FlowHistory .AsNoTracking() .FirstOrDefaultAsync(x => x.FlowMasterId == paraObject.FlowMasterId && x.MyUserId == paraObject.MyUserId); if (item != null) { return(VerifyRecordResultFactory.Build(false, "同一個簽核政策內,使用者不能重複指定")); } return(VerifyRecordResultFactory.Build(true)); }
public async Task <VerifyRecordResult> AddAsync(FlowHistoryAdapterModel paraObject) { try { FlowHistory itemParameter = Mapper.Map <FlowHistory>(paraObject); CleanTrackingHelper.Clean <FlowHistory>(context); await context.FlowHistory .AddAsync(itemParameter); await context.SaveChangesAsync(); CleanTrackingHelper.Clean <FlowHistory>(context); return(VerifyRecordResultFactory.Build(true)); } catch (Exception ex) { Logger.LogError(ex, "新增記錄發生例外異常"); return(VerifyRecordResultFactory.Build(false, "新增記錄發生例外異常", ex)); } }
Task OhterDependencyData(FlowHistoryAdapterModel data) { data.MyUserName = data.MyUser.Name; return(Task.FromResult(0)); }