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);
}
