public Task <ColumnNameSetting> SaveAsync(ColumnNameSetting ColumnName, CancellationToken token = default(CancellationToken))
{
#region merge query
var query = @"
MERGE INTO ColumnNameSetting AS Org
USING (
SELECT
@CompanyId AS CompanyId
,@TableName AS TableName
,@ColumnName AS ColumnName
) AS Target
ON (
Org.CompanyId = @CompanyId
AND Org.TableName = @TableName
AND Org.ColumnName = @ColumnName
)
WHEN MATCHED THEN
UPDATE SET
Alias = @Alias
,UpdateBy = @UpdateBy
,UpdateAt = GETDATE()
WHEN NOT MATCHED THEN
INSERT (CompanyId, TableName, ColumnName, OriginalName, Alias,CreateBy,CreateAt,UpdateBy,UpdateAt)
VALUES (@CompanyId, @TableName, @ColumnName, @OriginalName, @Alias,@CreateBy,GETDATE(),@UpdateBy,GETDATE())
OUTPUT inserted.*; ";
#endregion
return(dbHelper.ExecuteAsync <ColumnNameSetting>(query, ColumnName, token));
}
public async Task <ColumnNameSettingResult> SaveAsync(string SessionKey, ColumnNameSetting ColumnName)
{
return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token =>
{
var result = await columnNameSettingProcessor.SaveAsync(ColumnName, token);
return new ColumnNameSettingResult
{
ProcessResult = new ProcessResult {
Result = true
},
ColumnName = result
};
}, logger));
}
private void SetCommonSettingCombo()
{
foreach (var s in ColumnNameSetting.Where(x => x.TableName == nameof(Billing)))
{
cmbOutputDetailItem.Items.Add(new GrapeCity.Win.Editors.ListItem(s.DisplayColumnName, s.ColumnName));
}
cmbOutputDetailItem.TextSubItemIndex = 0;
cmbOutputDetailItem.ValueSubItemIndex = 1;
cmbDepartmentSummaryMode.Items.Add(new GrapeCity.Win.Editors.ListItem("営業担当者の所属部門で集計", (int)DepartmentSummaryMode.StaffDepartment));
cmbDepartmentSummaryMode.Items.Add(new GrapeCity.Win.Editors.ListItem("請求データの請求部門で集計", (int)DepartmentSummaryMode.BillDepartment));
cmbCalculateBaseDate.Items.Add(new GrapeCity.Win.Editors.ListItem("当初予定日", (int)CalculateBaseDate.OriginalDueAt));
cmbCalculateBaseDate.Items.Add(new GrapeCity.Win.Editors.ListItem("入金予定日", (int)CalculateBaseDate.DueAt));
cmbCalculateBaseDate.Items.Add(new GrapeCity.Win.Editors.ListItem("請求日", (int)CalculateBaseDate.BilledAt));
cmbIncludeOnTheDay.Items.Add(new GrapeCity.Win.Editors.ListItem("含めない", (int)IncludeOnTheDay.Exclude));
cmbIncludeOnTheDay.Items.Add(new GrapeCity.Win.Editors.ListItem("含める", (int)IncludeOnTheDay.Include));
}
/// <summary>登録処理</summary>
private void SaveColumnNameSetting()
{
var columnNameSetting = new ColumnNameSetting();
columnNameSetting.CompanyId = CompanyId;
columnNameSetting.TableName = TableName;
columnNameSetting.ColumnName = ColumnName;
if (!string.IsNullOrEmpty(txtAlias.Text.Trim()))
{
columnNameSetting.Alias = txtAlias.Text.Trim();
}
columnNameSetting.UpdateBy = Login.UserId;
bool success = false;
List <ColumnNameSetting> list = null;
var task = ServiceProxyFactory.DoAsync <ColumnNameSettingMasterClient>(async client =>
{
var result = await client.SaveAsync(SessionKey, columnNameSetting);
success = result?.ProcessResult.Result ?? false;
if (success)
{
list = await GetColumnNameSettingsListAsync();
}
});
ProgressDialog.Start(ParentForm, task, false, SessionKey);
if (!success)
{
ShowWarningDialog(MsgErrSaveError);
}
else
{
ClearControl();
DispStatusMessage(MsgInfSaveSuccess);
}
grdColumnName.DataSource = new BindingSource(list, null);
grdColumnName.Focus();
grdColumnName.CurrentCellPosition = new CellPosition(0, CellName(nameof(ColumnNameSetting.TableNameText)));
}
private async Task InitializeColumnNameSettingAsync(CompanySource source, LoginUser loginUser, CancellationToken token)
{
foreach (var tableName in new string[] { nameof(Billing), nameof(Receipt) })
{
var noteCount = (tableName == nameof(Billing) ? 8 : 4);
for (var i = 1; i <= noteCount; i++)
{
var columnName = new ColumnNameSetting
{
CompanyId = source.Company.Id,
TableName = tableName,
ColumnName = $"Note{i}",
OriginalName = $"備考{(i == 1 ? "" : i.ToString())}",
CreateBy = loginUser.Id,
UpdateBy = loginUser.Id,
};
await columnNameSettingQueryProcessor.SaveAsync(columnName, token);
}
}
}
public Task <IEnumerable <ColumnNameSetting> > GetAsync(ColumnNameSetting setting, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT cns.*
FROM ColumnNameSetting cns
WHERE cns.CompanyId = @CompanyId";
if (!string.IsNullOrEmpty(setting.TableName))
{
query += @"
AND cns.TableName = @TableName";
}
if (!string.IsNullOrEmpty(setting.ColumnName))
{
query += @"
AND cns.ColumnName = @ColumnName";
}
query += @"
ORDER BY cns.CompanyId ASC
, cns.TableName ASC
, cns.ColumnName ASC";
return(dbHelper.GetItemsAsync <ColumnNameSetting>(query, setting, token));
}
public async Task <ActionResult <ColumnNameSetting> > Save(ColumnNameSetting columnName, CancellationToken token) => await columnNameSettingProcessor.SaveAsync(columnName, token);
public async Task <ActionResult <IEnumerable <ColumnNameSetting> > > Get(ColumnNameSetting setting, CancellationToken token) => (await columnNameSettingProcessor.GetAsync(setting, token)).ToArray();
public BillingAgingListDetailFileDefinition(DataExpression expression, ColumnNameSetting ColumnNameSetting)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "請求残高年齢表";
FileNameToken = DataTypeToken;
CustomerCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 1,
Required = false,
Accept = VisitCustomerCodeField,
};
CustomerNameField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 1,
Required = false,
Accept = VisitCustomerNameField,
};
CurrencyCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.CurrencyCode)
{
FieldName = "通貨コード",
FieldNumber = 1,
Required = false,
Accept = VisitCurrencyCodeField,
};
BilledAtField = new NumberFieldDefinition <BillingAgingListDetail, DateTime>(
k => k.BilledAt)
{
FieldName = "請求日",
FieldNumber = 1,
Required = false,
Accept = VisitBilledAtField,
Format = value => value.ToShortDateString(),
};
DueAtField = new NumberFieldDefinition <BillingAgingListDetail, DateTime>(
k => k.DueAt)
{
FieldName = "入金予定日",
FieldNumber = 1,
Required = false,
Accept = VisitDueAtField,
Format = value => value.ToShortDateString(),
};
SalesAtField = new NumberFieldDefinition <BillingAgingListDetail, DateTime>(
k => k.SalesAt)
{
FieldName = "売上日",
FieldNumber = 1,
Required = false,
Accept = VisitSalesAtField,
Format = value => value.ToShortDateString(),
};
BillingAmountField = new NumberFieldDefinition <BillingAgingListDetail, decimal>(k => k.BillingAmount)
{
FieldName = "請求金額",
FieldNumber = 1,
Required = false,
Accept = VisitBillingAmountField,
Format = value => value.ToString(),
};
RemainAmountField = new NumberFieldDefinition <BillingAgingListDetail, decimal>(k => k.RemainAmount)
{
FieldName = "請求残",
FieldNumber = 1,
Required = false,
Accept = VisitRemainAmountField,
Format = value => value.ToString(),
};
StaffCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.StaffCode)
{
FieldName = "担当者コード",
FieldNumber = 1,
Required = false,
Accept = VisitStaffCodeField,
};
StaffNameField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.StaffName)
{
FieldName = "担当者名",
FieldNumber = 1,
Required = false,
Accept = VisitStaffNameField,
};
InvoiceCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.InvoiceCode)
{
FieldName = "請求書番号",
FieldNumber = 1,
Required = false,
Accept = VisitInvoiceCodeField,
};
NoteField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.Note)
{
FieldName = ColumnNameSetting.DisplayColumnName,
FieldNumber = 1,
Required = false,
Accept = VisitNoteField,
};
Fields.AddRange(new IFieldDefinition <BillingAgingListDetail>[] {
CustomerCodeField, CustomerNameField, CurrencyCodeField, BilledAtField, DueAtField
, SalesAtField, BillingAmountField, RemainAmountField, StaffCodeField, StaffNameField
, InvoiceCodeField, NoteField
});
}
public async Task <ColumnNameSetting> SaveAsync(ColumnNameSetting ColumnName, CancellationToken token = default(CancellationToken)) => await addColumnNameSettingQueryProcessor.SaveAsync(ColumnName, token);
public async Task <IEnumerable <ColumnNameSetting> > GetAsync(ColumnNameSetting setting, CancellationToken token = default(CancellationToken)) => await columnNameSettingQueryProcessor.GetAsync(setting, token);
public void SetData(List <BillingAgingListDetail> GeneralResult, int Precision, ColumnNameSetting SettingInfo)
{
BillingAgingDetailList = GeneralResult;
PrintPrecision = Precision;
DataSource = new BindingSource(GeneralResult, null);
var displayFormat = "#,##0";
if (Precision > 0)
{
displayFormat += "." + new string('0', Precision);
}
txtCustomerCode.DataField = "CustomerCode";
txtCustomerName.DataField = "CustomerName";
txtBillingAt.DataField = "BilledAt";
txtStaffCode.DataField = "StaffCode";
txtDueAt.DataField = "DueAt";
txtInvoiceCode.DataField = "InvoiceCode";
txtStaffName.DataField = "StaffName";
txtBillingAmount.OutputFormat = displayFormat;
txtRemainAmount.OutputFormat = displayFormat;
txtNote.DataField = "Note";
lblNote.Text = SettingInfo.DisplayColumnName;
}
