public Task <ReminderSummarySetting> SaveAsync(ReminderSummarySetting setting, CancellationToken token = default(CancellationToken)) { #region merge query var query = @" MERGE INTO ReminderSummarySetting target USING ( SELECT @CompanyId [CompanyId] , @ColumnName [ColumnName] ) source ON ( target.CompanyId = source.CompanyId AND target.ColumnName = source.ColumnName ) WHEN MATCHED THEN UPDATE SET Available = @Available ,UpdateBy = @UpdateBy ,UpdateAt = GETDATE() WHEN NOT MATCHED THEN INSERT (CompanyId, ColumnName, ColumnNameJp, DisplayOrder, Available, CreateBy, CreateAt, UpdateBy, UpdateAt) VALUES (@CompanyId, @ColumnName, @ColumnNameJp, @DisplayOrder, @Available, @UpdateBy, GETDATE(), @UpdateBy, GETDATE()) OUTPUT inserted.*; "; #endregion return(dbHelper.ExecuteAsync <ReminderSummarySetting>(query, setting, token)); }
private async Task LoadReminderSummarySetting() { var setting = new List <ReminderSummarySetting>(); await ServiceProxyFactory.DoAsync <ReminderSettingServiceClient>(async client => { var result = await client.GetReminderSummarySettingsAsync(SessionKey, CompanyId); if (result.ProcessResult.Result) { setting = result.ReminderSummarySettings; } ReminderSummarySetting = setting; UseDestinationSummarized = ReminderSummarySetting.Any(x => x.ColumnName == "DestinationCode" && x.Available == 1); }); }
private void SetInitialSetting() { if (ReminderTemplateSetting?.Count > 0) { cmbReminderTemplate.TextSubItemIndex = 0; cmbReminderTemplate.ValueSubItemIndex = 1; cmbReminderTemplate.Items.AddRange(ReminderTemplateSetting.Select(x => new ListItem(x.Name, x.Id)).ToArray()); } UseDestinationSummarized = ReminderSummarySetting.Any(x => x.ColumnName == "DestinationCode" && x.Available == 1); if (UseDestinationSummarized) { BaseContext.SetFunction09Caption("検索"); BaseContext.SetFunction09Enabled(false); OnF09ClickHandler = ShowDestinationCodeSearchDialog; } }
private List <ReminderSummarySetting> PrepareSummarySetting() { var summarySettings = new List <ReminderSummarySetting>(); foreach (Row row in grdSummarySetting.Rows) { var summarySetting = new ReminderSummarySetting(); summarySetting.CompanyId = CompanyId; summarySetting.ColumnName = row.Cells[CellName(nameof(ReminderSummarySetting.ColumnName))].Value.ToString(); summarySetting.ColumnNameJp = row.Cells[CellName(nameof(ReminderSummarySetting.ColumnNameJp))].Value.ToString(); summarySetting.DisplayOrder = int.Parse(row.Cells[CellName(nameof(ReminderSummarySetting.DisplayOrder))].Value.ToString()); summarySetting.Available = int.Parse(row.Cells[CellName(nameof(ReminderSummarySetting.Available))].Value.ToString()); summarySetting.CreateBy = Login.UserId; summarySetting.UpdateBy = Login.UserId; summarySettings.Add(summarySetting); } return(summarySettings); }