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);
     });
 }
Example #3
0
        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;
            }
        }
Example #4
0
        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);
        }