public MatchingHeaderFileDefinition(DataExpression dataExpression) :
base(dataExpression)
{
Fields.Add(CheckedField = new NumberFieldDefinition <MatchingHeader, bool>(x => x.Checked,
"解除", accept: VisitChecked, formatter: x => x ? "レ" : ""));
Fields.Add(CurrencyCodeField = new StringFieldDefinition <MatchingHeader>(x => x.CurrencyCode,
"通貨", accept: VisitCurrencyCode));
Fields.Add(CustomerCodeField = new StringFieldDefinition <MatchingHeader>(x => x.DispCustomerCode,
"得意先コード", accept: VisitCustomerCode));
Fields.Add(CustomerNameField = new StringFieldDefinition <MatchingHeader>(x => x.DispCustomerName,
"得意先名（代表者）", accept: VisitCustomerName));
Fields.Add(BillingCountField = new NumberFieldDefinition <MatchingHeader, int>(x => x.BillingCount,
"件数", accept: VisitBillingCount, formatter: x => x.ToString()));
Fields.Add(BillingAmountField = new NumberFieldDefinition <MatchingHeader, decimal>(x => x.BillingAmount,
"金額", accept: VisitBillingAmount));
Fields.Add(PayerNameField = new StringFieldDefinition <MatchingHeader>(x => x.PayerName,
"振込依頼人名", accept: VisitPayerName));
Fields.Add(ReceiptCountField = new NumberFieldDefinition <MatchingHeader, int>(x => x.ReceiptCount,
"件数", accept: VisitReceiptCount, formatter: x => x.ToString()));
Fields.Add(ReceiptAmountField = new NumberFieldDefinition <MatchingHeader, decimal>(x => x.ReceiptAmount,
"金額", accept: VisitReceiptAmount));
Fields.Add(ShareTransferFeeField = new StringFieldDefinition <MatchingHeader>(x => x.DispShareTransferFee,
"手数科", accept: VisitShareTransferFee));
Fields.Add(DifferentField = new NumberFieldDefinition <MatchingHeader, decimal>(x => x.Different,
"差額", accept: VisitDifferent));
Fields.Add(DispMemoField = new StringFieldDefinition <MatchingHeader>(x => x.DispMemo,
"メモ", accept: VisitDispMemo));
}
private IEnumerable <IFieldDefinition <ReminderSummary> > InitializeFields()
{
yield return(CustomerCodeField = new StringFieldDefinition <ReminderSummary>(k => k.CustomerCode,
"得意先コード", 1, accept: x => x.StandardString(CustomerCodeField)));
yield return(CustomerNameField = new StringFieldDefinition <ReminderSummary>(k => k.CustomerName,
"得意先名", 2, accept: x => x.StandardString(CustomerNameField)));
yield return(CurrencyCodeField = new StringFieldDefinition <ReminderSummary>(k => k.CurrencyCode,
"通貨コード", 3, accept: x => x.StandardString(CurrencyCodeField)));
yield return(RemainAmountField = new NumberFieldDefinition <ReminderSummary, decimal>(k => k.RemainAmount,
"請求残", 4, accept: x => x.StandardNumber(RemainAmountField), formatter: value => value.ToString()));
yield return(ReminderAmountField = new NumberFieldDefinition <ReminderSummary, decimal>(k => k.ReminderAmount,
"滞留金額", 5, accept: x => x.StandardNumber(ReminderAmountField), formatter: value => value.ToString()));
yield return(MemoField = new StringFieldDefinition <ReminderSummary>(k => k.Memo,
"対応記録", 6, accept: x => x.StandardString(MemoField)));
yield return(CustomerStaffNameField = new StringFieldDefinition <ReminderSummary>(k => k.CustomerStaffName,
"相手先担当者", 7, accept: x => x.StandardString(CustomerStaffNameField)));
yield return(CustomerNoteField = new StringFieldDefinition <ReminderSummary>(k => k.CustomerNote,
"得意先備考", 8, accept: x => x.StandardString(CustomerNoteField)));
yield return(CustomerTelField = new StringFieldDefinition <ReminderSummary>(k => k.CustomerTel,
"電話番号", 9, accept: x => x.StandardString(CustomerTelField)));
yield return(CustomerFaxField = new StringFieldDefinition <ReminderSummary>(k => k.CustomerFax,
"FAX番号", 10, accept: x => x.StandardString(CustomerFaxField)));
}
public HolidayCalendarFileDefinition(DataExpression expression)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "カレンダー";
FileNameToken = DataTypeToken + "マスター";
CompanyIdField = new StandardIdToCodeFieldDefinition <HolidayCalendar, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
HolidayField = new NumberFieldDefinition <HolidayCalendar, DateTime>(k => k.Holiday)
{
FieldName = "休業日",
FieldNumber = 2,
Required = true,
Accept = VisitHolidayField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
Fields.AddRange(new IFieldDefinition <HolidayCalendar>[] {
CompanyIdField, HolidayField
});
KeyFields.AddRange(new IFieldDefinition <HolidayCalendar>[]
{
HolidayField,
});
}
private IEnumerable <IFieldDefinition <CreditAgingList> > InitializeFields()
{
yield return(DepartmentCodeField = new StringFieldDefinition <CreditAgingList>(x => x.DepartmentCode,
"請求部門コード", 1, accept: x => x.StandardString(DepartmentCodeField)));
yield return(DepartmentNameField = new StringFieldDefinition <CreditAgingList>(k => k.DepartmentName,
"請求部門名", 2, accept: x => x.StandardString(DepartmentNameField)));
yield return(StaffCodeField = new StringFieldDefinition <CreditAgingList>(k => k.StaffCode,
"担当者コード", 3, accept: x => x.StandardString(StaffCodeField)));
yield return(StaffNameField = new StringFieldDefinition <CreditAgingList>(k => k.StaffName,
"担当者名", 4, accept: x => x.StandardString(StaffNameField)));
yield return(CustomerCodeField = new StringFieldDefinition <CreditAgingList>(x => x.CustomerCode,
"得意先コード", 5, accept: x => x.StandardString(CustomerCodeField)));
yield return(CustomerNameField = new StringFieldDefinition <CreditAgingList>(x => x.CustomerName,
"得意先名", 6, accept: x => x.StandardString(CustomerNameField)));
yield return(CollectCategoryField = new StringFieldDefinition <CreditAgingList>(k => k.TotalText,
"回収条件", 7, accept: x => x.StandardString(CollectCategoryField)));
yield return(CreditAmountField = new NumberFieldDefinition <CreditAgingList, decimal>(k => k.CreditAmount,
"当月債権総額", 8, accept: x => x.StandardNumber(CreditAmountField), formatter: x => x.ToString()));
yield return(UnsettledRemainField = new NumberFieldDefinition <CreditAgingList, decimal>(k => k.UnsettledRemain,
"当月末未決済残高", 9, accept: x => x.StandardNumber(UnsettledRemainField), formatter: x => x.ToString()));
yield return(BillingRemainField = new NumberFieldDefinition <CreditAgingList, decimal>(k => k.BillingRemain,
"当月請求残高", 10, accept: x => x.StandardNumber(BillingRemainField), formatter: x => x.ToString()));
yield return(CreditLimitField = new NullableNumberFieldDefinition <CreditAgingList, decimal>(k => k.CreditLimit,
"与信限度額", 11, accept: x => x.StandardNumber(CreditLimitField), formatter: x => x.ToString()));
yield return(CreditRemainField = new NullableNumberFieldDefinition <CreditAgingList, decimal>(k => k.CreditBalance,
"当月与信残高", 12, accept: x => x.StandardNumber(CreditRemainField), formatter: x => x.ToString()));
yield return(CreditRemainStarField = new StringFieldDefinition <CreditAgingList>(k => k.CreditBalanceMark,
" ", 13, accept: x => x.StandardString(CreditRemainStarField)));
yield return(ArrivalDueDate1Field = new NumberFieldDefinition <CreditAgingList, decimal>(k => k.ArrivalDueDate1,
"", 14, accept: x => x.StandardNumber(ArrivalDueDate1Field), formatter: x => x.ToString()));
yield return(ArrivalDueDate2Field = new NumberFieldDefinition <CreditAgingList, decimal>(k => k.ArrivalDueDate2,
"", 15, accept: x => x.StandardNumber(ArrivalDueDate2Field), formatter: x => x.ToString()));
yield return(ArrivalDueDate3Field = new NumberFieldDefinition <CreditAgingList, decimal>(k => k.ArrivalDueDate3,
"", 16, accept: x => x.StandardNumber(ArrivalDueDate3Field), formatter: x => x.ToString()));
yield return(ArrivalDueDate4Field = new NumberFieldDefinition <CreditAgingList, decimal>(k => k.ArrivalDueDate4,
"", 17, accept: x => x.StandardNumber(ArrivalDueDate4Field), formatter: x => x.ToString()));
}
public LogDataFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "操作ログ管理";
FileNameToken = DataTypeToken;
LoggedAtField = new NumberFieldDefinition <LogData, DateTime>(k => k.LoggedAt)
{
FieldName = "日時",
FieldNumber = 1,
Required = false,
Accept = VisitLoggedAt,
Format = value => value.ToString(),
};
LoginUserCodeField = new StringFieldDefinition <LogData>(k => k.LoginUserCode)
{
FieldName = "ユーザーコード",
FieldNumber = 2,
Required = false,
Accept = VisitLoginUserCode,
};
LoginUserNameField = new StringFieldDefinition <LogData>(k => k.LoginUserName)
{
FieldName = "ユーザー名",
FieldNumber = 3,
Required = false,
Accept = VisitLoginUserName,
};
MenuNameField = new StringFieldDefinition <LogData>(k => k.MenuName)
{
FieldName = "名称",
FieldNumber = 4,
Required = false,
Accept = VisitMenuName,
};
OperationNameField = new StringFieldDefinition <LogData>(k => k.OperationName)
{
FieldName = "操作",
FieldNumber = 5,
Required = false,
Accept = VisitOperationName,
};
Fields.AddRange(new IFieldDefinition <LogData>[] {
LoggedAtField, LoginUserCodeField, LoginUserNameField, MenuNameField, OperationNameField
});
}
private IEnumerable <IFieldDefinition <Header> > GetFields()
{
yield return(CompanyIdField = new StandardIdToCodeFieldDefinition <Header, Company>(x => x.CompanyId, x => x.Id, null, x => x.Code,
"会社コード", 1, accept: x => x.OwnCompanyCode(CompanyIdField)));
yield return(NameField = new StringFieldDefinition <Header>(x => x.Name,
"パターン名", 2, accept: x => x.StandardString(NameField)));
yield return(CustomerCodeField = new StringFieldDefinition <Header>(x => x.CustomerCode,
"得意先コード", 3, accept: x => x.StandardString(CustomerCodeField)));
yield return(CustomerNameField = new StringFieldDefinition <Header>(x => x.CustomerName,
"得意先名", 4, accept: x => x.StandardString(CustomerNameField)));
yield return(DestinationCodeField = new StringFieldDefinition <Header>(x => x.DestinationCode,
"仕向先コード", 5, accept: x => x.StandardString(DestinationCodeField)));
yield return(BilledCycleStatusField = new StringFieldDefinition <Header>(x => x.BilledCycleStatus,
"請求サイクル", 6, accept: x => x.StandardString(BilledCycleStatusField)));
yield return(BilledDayField = new NumberFieldDefinition <Header, int>(x => x.BilledDay,
"請求日", 7, accept: x => x.StandardNumber(BilledDayField), formatter: x => x.ToString()));
yield return(StartMonthField = new NumberFieldDefinition <Header, DateTime>(x => x.StartMonth,
"開始月", 8, accept: x => x.StandardNumber(StartMonthField), formatter: x => x.ToString(YearMonthFormat)));
yield return(EndMonthField = new NullableNumberFieldDefinition <Header, DateTime>(x => x.EndMonth,
"終了月", 9, accept: x => x.StandardNumber(EndMonthField), formatter: x => x.ToString(YearMonthFormat)));
yield return(InvoiceCodeField = new StringFieldDefinition <Header>(x => x.InvoiceCode,
"請求書番号", 10, accept: x => x.StandardString(InvoiceCodeField)));
yield return(SetNote1Field = new NumberFieldDefinition <Header, int>(x => x.SetBillingNote1,
"備考1設定", 11, accept: x => x.StandardNumber(SetNote1Field), formatter: x => x.ToString()));
yield return(SetNote2Field = new NumberFieldDefinition <Header, int>(x => x.SetBillingNote2,
"備考2設定", 12, accept: x => x.StandardNumber(SetNote2Field), formatter: x => x.ToString()));
yield return(BillingAmountField = new NumberFieldDefinition <Header, decimal>(x => x.BillingAmount,
"請求額合計", 13, accept: x => x.StandardNumber(BillingAmountField), formatter: x => x.ToString("0")));
}
public CollectionScheduleFileDefinition(DataExpression expression)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "回収予定表";
FileNameToken = DataTypeToken;
Fields.Add(CustomerInfoField = new StringFieldDefinition <CollectionSchedule>(
x => x.CustomerInfo, "得意先/回収条件", accept: VisitCustomerInfoField));
Fields.Add(ClosingDayField = new StringFieldDefinition <CollectionSchedule>(
k => k.Closing, "締日", accept: VisitClosingDayField));
Fields.Add(StaffNameField = new StringFieldDefinition <CollectionSchedule>(
k => k.StaffName, "担当者名", accept: VisitStaffNameField));
Fields.Add(DepartmentNameField = new StringFieldDefinition <CollectionSchedule>(
k => k.DepartmentName, "請求部門名", accept: VisitDepartmentNameField));
Fields.Add(CategoryNameField = new StringFieldDefinition <CollectionSchedule>(
k => k.CollectCategoryName, "区分", accept: VisitCategoryNameField));
Fields.Add(UncollectedAmountLastField = new NullableNumberFieldDefinition <CollectionSchedule, decimal>(
k => k.UncollectedAmountLast, accept: VisitUncollectedAmountLastField));
Fields.Add(UncollectedAmount0Field = new NullableNumberFieldDefinition <CollectionSchedule, decimal>(
k => k.UncollectedAmount0, accept: VisitUncollectedAmount0Field));
Fields.Add(UncollectedAmount1Field = new NullableNumberFieldDefinition <CollectionSchedule, decimal>(
k => k.UncollectedAmount1, accept: VisitUncollectedAmount1Field));
Fields.Add(UncollectedAmount2Field = new NullableNumberFieldDefinition <CollectionSchedule, decimal>(
k => k.UncollectedAmount2, accept: VisitUncollectedAmount2Field));
Fields.Add(UncollectedAmount3Field = new NullableNumberFieldDefinition <CollectionSchedule, decimal>(
k => k.UncollectedAmount3, accept: VisitUncollectedAmount3Field));
Fields.Add(UncollectedAmountTotalField = new NullableNumberFieldDefinition <CollectionSchedule, decimal>(
k => k.UncollectedAmountTotal, "合計", accept: VisitUncollectedAmountTotalField));
}
private IEnumerable <IFieldDefinition <BankAccount> > GetFields()
{
var id = 0;
//return null;
yield return(CompanyIdField = new StandardIdToCodeFieldDefinition <BankAccount, Company>(k => k.CompanyId, c => c.Id, null, c => c.Code,
"会社コード", ++id, accept: x => x.OwnCompanyCode(CompanyIdField)));
yield return(BankCodeField = new StringFieldDefinition <BankAccount>(k => k.BankCode,
"銀行コード", ++id, required: true, accept: x => x.BankCode(BankCodeField)));
yield return(BankNameField = new StringFieldDefinition <BankAccount>(k => k.BankName,
"銀行名", ++id, required: true, accept: x => x.BankName(BankNameField)));
yield return(BranchCodeField = new StringFieldDefinition <BankAccount>(k => k.BranchCode,
"支店コード", ++id, required: true, accept: x => x.BranchCode(BranchCodeField)));
yield return(BranchNameField = new StringFieldDefinition <BankAccount>(x => x.BranchName,
"支店名", ++id, required: true, accept: x => x.BranchName(BranchNameField)));
yield return(AccountTypeIdField = new NumberFieldDefinition <BankAccount, int>(k => k.AccountTypeId,
"預金種別", ++id, required: true, accept: x => x.AccountTypeId(AccountTypeIdField), formatter: x => x.ToString()));
yield return(AccountNumberField = new StringFieldDefinition <BankAccount>(k => k.AccountNumber,
"口座番号", ++id, required: true, accept: x => x.AccountNumber(AccountNumberField)));
yield return(CategoryIdField = new NullableForeignKeyFieldDefinition <BankAccount, int, Category>(
k => k.ReceiptCategoryId, c => c.Id,
k => k.ReceiptCategoryCode, c => c.Code,
"入金区分コード", ++id, required: true, accept: x => x.CategoryCode(CategoryIdField)));
yield return(ImportSkippingField = new NumberFieldDefinition <BankAccount, int>(k => k.ImportSkipping,
"取込対象外", ++id, required: true, accept: x => x.UseValueDate(ImportSkippingField), formatter: x => x.ToString()));
yield return(SectionIdField = new NullableForeignKeyFieldDefinition <BankAccount, int, Section>(
k => k.SectionId, c => c.Id,
k => k.SectionCode, c => c.Code,
"入金部門コード", ++id, accept: x => x.SectionCode(SectionIdField)));
}
public MatchingJournalizingCancelFileDefinition(DataExpression applicationControl)
: base(applicationControl)
{
StartLineNumber = 1;
DataTypeToken = "消込仕訳出力取消";
FileNameToken = DataTypeToken;
CompanyIdField = new StandardIdToCodeFieldDefinition <MatchingJournalizingDetail, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
CreateAtField = new NullableNumberFieldDefinition <MatchingJournalizingDetail, DateTime>(k => k.CreateAt)
{
FieldName = "更新日時",
FieldNumber = 2,
Required = true,
Accept = VisitCreateAtField,
Format = value => value.ToString(),
};
JournalizingNameField = new StringFieldDefinition <MatchingJournalizingDetail>(k => k.JournalizingName)
{
FieldName = "仕訳区分",
FieldNumber = 3,
Required = false,
Accept = VisitJournalizingName,
};
CustomerCodeField = new StringFieldDefinition <MatchingJournalizingDetail>(k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 4,
Required = false,
Accept = VisitCustomerCode,
};
CustomerNameField = new StringFieldDefinition <MatchingJournalizingDetail>(k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 5,
Required = false,
Accept = VisitCustomerName,
};
CurrencyCodeField = new StringFieldDefinition <MatchingJournalizingDetail>(k => k.CurrencyCode)
{
FieldName = "通貨コード",
FieldNumber = 6,
Required = false,
Accept = VisitCurrencyCode,
};
AmountField = new NumberFieldDefinition <MatchingJournalizingDetail, decimal>(k => k.Amount)
{
FieldName = "金額",
FieldNumber = 7,
Required = true,
Accept = VisitAmount,
Format = value => value.ToString(),
};
OutputAtField = new NullableNumberFieldDefinition <MatchingJournalizingDetail, DateTime>(k => k.OutputAt)
{
FieldName = "仕訳日",
FieldNumber = 8,
Required = true,
Accept = VisitOutputAtField,
Format = value => value.ToString(),
};
ReceiptAmountField = new NumberFieldDefinition <MatchingJournalizingDetail, decimal>(k => k.ReceiptAmount)
{
FieldName = "入金額",
FieldNumber = 9,
Required = true,
Accept = VisitReceiptAmount,
Format = value => value.ToString(),
};
RecordedAtField = new NullableNumberFieldDefinition <MatchingJournalizingDetail, DateTime>(k => k.RecordedAt)
{
FieldName = "入金日",
FieldNumber = 10,
Required = true,
Accept = VisitRecordedAtField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
PayerNameField = new StringFieldDefinition <MatchingJournalizingDetail>(k => k.PayerName)
{
FieldName = "振込依頼人名",
FieldNumber = 11,
Required = false,
Accept = VisitPayerName,
};
BilledAtField = new NullableNumberFieldDefinition <MatchingJournalizingDetail, DateTime>(k => k.BilledAt)
{
FieldName = "請求日",
FieldNumber = 12,
Required = true,
Accept = VisitBillingAtField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
InvoiceCodeField = new StringFieldDefinition <MatchingJournalizingDetail>(k => k.InvoiceCode)
{
FieldName = "請求書番号",
FieldNumber = 13,
Required = false,
Accept = VisitInvoiceCode,
};
BillingAmountField = new NullableNumberFieldDefinition <MatchingJournalizingDetail, decimal>(k => k.BillingAmount)
{
FieldName = "請求額",
FieldNumber = 14,
Required = true,
Accept = VisitBillingAmount,
Format = value => value.ToString(),
};
Fields.AddRange(new IFieldDefinition <MatchingJournalizingDetail>[] {
CompanyIdField, CreateAtField, JournalizingNameField, CustomerCodeField, CustomerNameField, CurrencyCodeField, AmountField, OutputAtField,
ReceiptAmountField, RecordedAtField, PayerNameField, BilledAtField, InvoiceCodeField, BillingAmountField
});
}
private IEnumerable <IFieldDefinition <Reminder> > InitializeFields(string baseDateCaption)
{
yield return(BaseDateField = new NumberFieldDefinition <Reminder, DateTime>(k => k.BaseDate,
"基準日", 1, accept: x => x.StandardNumber(BaseDateField), formatter: value => value.ToShortDateString()));
yield return(CustomerCodeField = new StringFieldDefinition <Reminder>(k => k.CustomerCode,
"得意先コード", 2, accept: x => x.StandardString(CustomerCodeField)));
yield return(CustomerNameField = new StringFieldDefinition <Reminder>(k => k.CustomerName,
"得意先名", 3, accept: x => x.StandardString(CustomerNameField)));
yield return(CalculateBaseDateField = new NumberFieldDefinition <Reminder, DateTime>(k => k.CalculateBaseDate,
baseDateCaption, 4, accept: x => x.StandardNumber(CalculateBaseDateField), formatter: value => value.ToShortDateString()));
yield return(DetailCountField = new NumberFieldDefinition <Reminder, int>(k => k.DetailCount,
"明細件数", 5, accept: x => x.StandardNumber(DetailCountField), formatter: value => value.ToString()));
yield return(CurrencyCodeField = new StringFieldDefinition <Reminder>(k => k.CurrencyCode,
"通貨コード", 6, accept: x => x.StandardString(CurrencyCodeField)));
yield return(RemainAmountField = new NumberFieldDefinition <Reminder, decimal>(k => k.RemainAmount,
"請求残", 7, accept: x => x.StandardNumber(RemainAmountField), formatter: value => value.ToString()));
yield return(ReminderAmountField = new NullableNumberFieldDefinition <Reminder, decimal>(k => k.ReminderAmount,
"滞留金額", 8, accept: x => x.StandardNumber(ReminderAmountField), formatter: value => value.ToString()));
yield return(ArrearsInterestField = new NullableNumberFieldDefinition <Reminder, decimal>(k => k.ArrearsInterest,
"延滞利息", 9, accept: x => x.StandardNumber(ArrearsInterestField), formatter: value => value.ToString()));
yield return(ArrearsDaysField = new NullableNumberFieldDefinition <Reminder, int>(k => k.ArrearsDays,
"滞留日数", 10, accept: x => x.StandardNumber(ArrearsDaysField), formatter: value => value.ToString()));
yield return(StatusField = new StringFieldDefinition <Reminder>(k => k.StatusCodeAndName,
"ステータス", 11, accept: x => x.StandardString(StatusField)));
yield return(MemoField = new StringFieldDefinition <Reminder>(k => k.Memo,
"対応記録", 12, accept: x => x.StandardString(MemoField)));
yield return(ClosingAtField = new NumberFieldDefinition <Reminder, DateTime>(k => k.ClosingAt,
"請求締日", 13, accept: x => x.StandardNumber(ClosingAtField), formatter: value => value.ToShortDateString()));
yield return(InvoiceCodeField = new StringFieldDefinition <Reminder>(k => k.InvoiceCode,
"請求書番号", 14, accept: x => x.StandardString(InvoiceCodeField)));
yield return(CollectCategoryField = new StringFieldDefinition <Reminder>(k => k.CollectCategoryCodeAndName,
"回収区分", 15, accept: x => x.StandardString(CollectCategoryField)));
yield return(DepartmentCodeField = new StringFieldDefinition <Reminder>(k => k.DepartmentCode,
"請求部門コード", 16, accept: x => x.StandardString(DepartmentCodeField)));
yield return(DepartmentNameField = new StringFieldDefinition <Reminder>(k => k.DepartmentName,
"請求部門名", 17, accept: x => x.StandardString(DepartmentNameField)));
yield return(StaffCodeField = new StringFieldDefinition <Reminder>(k => k.StaffCode,
"担当者コード", 18, accept: x => x.StandardString(StaffCodeField)));
yield return(StaffNameField = new StringFieldDefinition <Reminder>(k => k.StaffName,
"担当者名", 19, accept: x => x.StandardString(StaffNameField)));
yield return(DestinationCodeField = new StringFieldDefinition <Reminder>(k => k.DestinationCode,
"送付先コード", 20, accept: x => x.StandardString(DestinationCodeField)));
}
private IEnumerable <IFieldDefinition <MatchingJournalizing> > InitializeFields()
{
yield return(SlipNumberField = new NumberFieldDefinition <MatchingJournalizing, long>(k => k.SlipNumber,
"取引No", 1, accept: x => x.StandardNumber(SlipNumberField), formatter: value => value.ToString()));
yield return(RecordedAtField = new NumberFieldDefinition <MatchingJournalizing, DateTime>(k => k.RecordedAt,
"取引日", 2, accept: x => x.StandardNumber(RecordedAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
yield return(DebitAccountTitleNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitAccountTitleName,
"借方勘定科目", 3, accept: x => x.StandardString(DebitAccountTitleNameField)));
yield return(DebitSubCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitSubCode,
"借方補助科目", 4, accept: x => x.StandardString(DebitSubCodeField)));
yield return(DebitTaxCategoryField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitTaxCategory,
"借方税区分", 5, accept: x => x.StandardString(DebitTaxCategoryField)));
yield return(DebitDepartmentNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitDepartmentName,
"借方部門", 6, accept: x => x.StandardString(DebitDepartmentNameField)));
yield return(DebitAmountField = new NumberFieldDefinition <MatchingJournalizing, decimal>(k => k.DebitAmount,
"借方金額(円)", 7, accept: x => x.StandardNumber(DebitAmountField), formatter: value => value.ToString()));
yield return(DebitTaxAmountField = new NumberFieldDefinition <MatchingJournalizing, int>(k => k.DebitTaxAmount,
"借方税額", 8, accept: x => x.StandardNumber(DebitTaxAmountField), formatter: value => value.ToString()));
yield return(CreditAccountTitleNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditAccountTitleName,
"貸方勘定科目", 9, accept: x => x.StandardString(CreditAccountTitleNameField)));
yield return(CreditSubCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditSubCode,
"貸方補助科目", 10, accept: x => x.StandardString(CreditSubCodeField)));
yield return(CreditTaxCategoryField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditTaxCategory,
"貸方税区分", 11, accept: x => x.StandardString(CreditTaxCategoryField)));
yield return(CreditDepartmentNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditDepartmentName,
"貸方部門", 12, accept: x => x.StandardString(CreditDepartmentNameField)));
yield return(CreditAmountField = new NumberFieldDefinition <MatchingJournalizing, decimal>(k => k.CreditAmount,
"貸方金額(円)", 13, accept: x => x.StandardNumber(CreditAmountField), formatter: value => value.ToString()));
yield return(CreditTaxAmountField = new NumberFieldDefinition <MatchingJournalizing, int>(k => k.CreditTaxAmount,
"貸方税額", 14, accept: x => x.StandardNumber(CreditTaxAmountField), formatter: value => value.ToString()));
yield return(NoteField = new StringFieldDefinition <MatchingJournalizing>(k => k.Note,
"摘要", 15, accept: x => x.StandardString(NoteField)));
yield return(MatchingMemoField = new StringFieldDefinition <MatchingJournalizing>(k => k.MatchingMemo,
"仕訳メモ", 16, accept: x => x.StandardString(MatchingMemoField)));
yield return(MFTagField = new StringFieldDefinition <MatchingJournalizing>(k => k.MFTag,
"タグ", 17, accept: x => x.StandardString(MFTagField)));
yield return(MFJournalizingTypeField = new StringFieldDefinition <MatchingJournalizing>(k => k.MFJournalizingType,
"MF仕訳タイプ", 18, accept: x => x.StandardString(MFJournalizingTypeField)));
yield return(ClosingAdjustmentField = new StringFieldDefinition <MatchingJournalizing>(k => k.ClosingAdjustment,
"決算整理仕訳", 19, accept: x => x.StandardString(ClosingAdjustmentField)));
yield return(CreateAtField = new NumberFieldDefinition <MatchingJournalizing, DateTime>(k => k.CreateAt,
"作成日時", 20, accept: x => x.StandardNumber(CreateAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToString("yyyy/MM/dd HH:mm")));
yield return(MFUpdateAtField = new NumberFieldDefinition <MatchingJournalizing, DateTime>(k => k.MFUpdateAt,
"最終更新日時", 21, accept: x => x.StandardNumber(MFUpdateAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToString("yyyy/MM/dd HH:mm")));
}
public BillingJournalizingFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "請求仕訳出力";
FileNameToken = DataTypeToken;
OutputHeader = false;
CompanyCodeField = new StandardIdToCodeFieldDefinition <BillingJournalizing, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyCode,
};
BilledAtField = new NumberFieldDefinition <BillingJournalizing, DateTime>(
k => k.BilledAt)
{
FieldName = "伝票日付",
FieldNumber = 2,
Required = true,
Accept = VisitBilledAt,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
SlipNumberField = new NumberFieldDefinition <BillingJournalizing, long>(
k => k.SlipNumber)
{
FieldName = "伝票番号",
FieldNumber = 3,
Required = true,
Accept = VisitSlipNumber,
Format = value => value.ToString(),
};
DebitDepartmentCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitDepartmentCode)
{
FieldName = "借方部門コード",
FieldNumber = 4,
Required = true,
Accept = VisitDebitDepartmentCode,
};
DebitDepartmentNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitDepartmentName)
{
FieldName = "借方部門名",
FieldNumber = 5,
Required = true,
Accept = VisitDebitDepartmentCode,
};
DebitAccountTitleCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitAccountTitleCode)
{
FieldName = "借方科目コード",
FieldNumber = 6,
Required = true,
Accept = VisitDebitAccountTitleCode,
};
DebitAccountTitleNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitAccountTitleName)
{
FieldName = "借方科目名",
FieldNumber = 7,
Required = true,
Accept = VisitDebitAccountTitleName,
};
DebitSubCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitSubCode)
{
FieldName = "借方補助コード",
FieldNumber = 8,
Required = true,
Accept = VisitDebitSubCode,
};
DebitSubNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitSubName)
{
FieldName = "借方補助名",
FieldNumber = 9,
Required = true,
Accept = VisitDebitSubName,
};
CreditDepartmentCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditDepartmentCode)
{
FieldName = "貸方部門コード",
FieldNumber = 10,
Required = true,
Accept = VisitCreditDepartmentCode,
};
CreditDepartmentNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditDepartmentName)
{
FieldName = "貸方部門名",
FieldNumber = 11,
Required = true,
Accept = VisitCreditDepartmentName,
};
CreditAccountTitleCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditAccountTitleCode)
{
FieldName = "貸方科目コード",
FieldNumber = 12,
Required = true,
Accept = VisitCreditAccountTitleCode,
};
CreditAccountTitleNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditAccountTitleName)
{
FieldName = "貸方科目名",
FieldNumber = 13,
Required = true,
Accept = VisitCreditAccountTitleName,
};
CreditSubCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditSubCode)
{
FieldName = "貸方補助コード",
FieldNumber = 14,
Required = true,
Accept = VisitCreditSubCode,
};
CreditSubNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditSubName)
{
FieldName = "貸方補助名",
FieldNumber = 15,
Required = true,
Accept = VisitCreditSubName,
};
BillingAmountField = new NumberFieldDefinition <BillingJournalizing, decimal>(
k => k.BillingAmount)
{
FieldName = "仕訳金額",
FieldNumber = 16,
Required = true,
Accept = VisitBillingAmount,
Format = value => value.ToString(),
};
NoteField = new StringFieldDefinition <BillingJournalizing>(
k => k.Note)
{
FieldName = "備考",
FieldNumber = 17,
Required = true,
Accept = VisitNote,
};
CustomerCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 18,
Required = true,
Accept = VisitCustomerCode,
};
CustomerNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 19,
Required = true,
Accept = VisitCustomerName,
};
InvoiceCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.InvoiceCode)
{
FieldName = "請求書番号",
FieldNumber = 20,
Required = true,
Accept = VisitInvoiceCode,
};
StaffCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.StaffCode)
{
FieldName = "担当者コード",
FieldNumber = 21,
Required = true,
Accept = VisitStaffCode,
};
PayerCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.PayerCode)
{
FieldName = "振込依頼人コード",
FieldNumber = 22,
Required = true,
Accept = VisitPayerCode,
};
PayerNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.PayerName)
{
FieldName = "振込依頼人名",
FieldNumber = 23,
Required = true,
Accept = VisitPayerName,
};
SourceBankNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.SourceBankName)
{
FieldName = "仕向銀行",
FieldNumber = 24,
Required = true,
Accept = VisitSourceBankName,
};
SourceBranchNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.SourceBranchName)
{
FieldName = "仕向支店",
FieldNumber = 25,
Required = true,
Accept = VisitSourceBranchName,
};
DueAtField = new NumberFieldDefinition <BillingJournalizing, DateTime>(
k => k.DueAt)
{
FieldName = "期日",
FieldNumber = 26,
Required = true,
Accept = VisitDueAt,
Format = value => (value == DateTime.MinValue) ? "" : value.ToString(),
};
BankCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.BankCode)
{
FieldName = "銀行コード",
FieldNumber = 27,
Required = true,
Accept = VisitBankCode,
};
BankNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.BankName)
{
FieldName = "銀行名",
FieldNumber = 28,
Required = true,
Accept = VisitBankName,
};
BranchCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.BranchCode)
{
FieldName = "支店コード",
FieldNumber = 29,
Required = true,
Accept = VisitBranchCode,
};
BranchNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.BranchName)
{
FieldName = "支店名",
FieldNumber = 30,
Required = true,
Accept = VisitBranchName,
};
AccountTypeField = new NullableNumberFieldDefinition <BillingJournalizing, int>(
k => k.AccountType)
{
FieldName = "預金種別",
FieldNumber = 31,
Required = true,
Accept = VisitAccountType,
Format = value => value.ToString(),
};
AccountNumberField = new StringFieldDefinition <BillingJournalizing>(
k => k.AccountNumber)
{
FieldName = "口座番号",
FieldNumber = 32,
Required = true,
Accept = VisitAccountNumber,
};
CurrencyCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CurrencyCode)
{
FieldName = "通貨コード",
FieldNumber = 33,
Required = true,
Accept = VisitCurrencyCode,
};
Fields.AddRange(new IFieldDefinition <BillingJournalizing>[]
{
CompanyCodeField, BilledAtField, SlipNumberField, DebitDepartmentCodeField,
DebitDepartmentNameField, DebitAccountTitleCodeField, DebitAccountTitleNameField,
DebitSubCodeField, DebitSubNameField, CreditDepartmentCodeField,
CreditDepartmentNameField, CreditAccountTitleCodeField, CreditAccountTitleNameField,
CreditSubCodeField, CreditSubNameField, BillingAmountField,
NoteField, CustomerCodeField, CustomerNameField,
InvoiceCodeField, StaffCodeField, PayerCodeField,
PayerNameField, SourceBankNameField, SourceBranchNameField,
DueAtField, BankCodeField, BankNameField,
BranchCodeField, BranchNameField, AccountTypeField,
AccountNumberField, CurrencyCodeField
});
}
// <===
public TaskScheduleHistoryFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "タイムスケジューラーログ";
FileNameToken = DataTypeToken;
StartAtField = new NumberFieldDefinition <TaskScheduleHistory, DateTime>(h => h.StartAt)
{
FieldName = "開始日時",
FieldNumber = 1,
Required = true,
Accept = VisitStartAt,
Format = value => value.ToString(),
};
EndAtField = new NumberFieldDefinition <TaskScheduleHistory, DateTime>(h => h.EndAt)
{
FieldName = "終了日時",
FieldNumber = 2,
Required = true,
Accept = VisitEndAt,
Format = value => value.ToString(),
};
ImportTypeField = new NumberFieldDefinition <TaskScheduleHistory, int>(h => h.ImportType)
{
FieldName = "種別",
FieldNumber = 3,
Required = true,
Accept = VisitImportType,
Format = value => { /* ★ */ currentImportType = value; return(ImportType[value]); },
};
ImportSubTypeField = new NumberFieldDefinition <TaskScheduleHistory, int>(h => h.ImportSubType)
{
FieldName = "取込パターン",
FieldNumber = 4,
Required = true,
Accept = VisitImportSubType,
Format = value => ImportTypeToImportSubType[/* ★ */ currentImportType][value],
};
ResultField = new NumberFieldDefinition <TaskScheduleHistory, int>(h => h.Result)
{
FieldName = "実行結果",
FieldNumber = 5,
Required = true,
Accept = VisitResult,
Format = value => Result[value],
};
ErrorsField = new StringFieldDefinition <TaskScheduleHistory>(h => h.Errors)
{
FieldName = "エラーログ",
FieldNumber = 6,
Required = false,
Accept = VisitErrors,
};
Fields.AddRange(new IFieldDefinition <TaskScheduleHistory>[] {
StartAtField,
EndAtField,
ImportTypeField,
ImportSubTypeField, // 追加順序をImportTypeFieldの後にする必要あり
ResultField,
ErrorsField,
});
}
public MatchingBillingFilterFileDefinition(DataExpression applicationControl)
: base(applicationControl)
{
//請求データ
StartLineNumber = 1;
DataTypeToken = "個別消込";
FileNameToken = DataTypeToken;
CurrencyCodeField = new StringFieldDefinition<Billing>(k => k.CurrencyCode)
{
FieldName = "通貨コード",
FieldNumber = 1,
Required = false,
Accept = VisitCurrencyCodeField,
};
BillCheckField = new StringFieldDefinition<Billing>(k => k.BillCheck)
{
FieldName = "消",
FieldNumber = 1,
Required = false,
Accept = VisitBillCheckField,
};
CustomerCodeField = new StringFieldDefinition<Billing>(k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 1,
Required = false,
Accept = VisitCustomerCodeField,
};
CustomerNameField = new StringFieldDefinition<Billing>(k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 1,
Required = false,
Accept = VisitCustomerNameField,
};
BilledAtField = new NumberFieldDefinition<Billing, DateTime>(k => k.BilledAt)
{
FieldName = "請求日",
FieldNumber = 1,
Required = false,
Accept = VisitBilledAtField,
Format = value => value.ToShortDateString(),
};
DueAtField = new NumberFieldDefinition<Billing, DateTime>(k => k.DueAt)
{
FieldName = "予定日",
FieldNumber = 1,
Required = false,
Accept = VisitDueAtField,
Format = value => value.ToShortDateString(),
};
BillingAmountField = new NumberFieldDefinition<Billing, decimal>(k => k.BillingAmount)
{
FieldName = "請求額",
FieldNumber = 1,
Required = false,
Accept = VisitBillingAmountField,
Format = value => value.ToString(),
};
RemainAmountField = new NumberFieldDefinition<Billing, decimal>(k => k.RemainAmount)
{
FieldName = "請求残",
FieldNumber = 1,
Required = false,
Accept = VisitRemainAmountField,
Format = value => value.ToString(),
};
TargetAmountField = new NumberFieldDefinition<Billing,decimal>(k => k.TargetAmount)
{
FieldName = "消込対象額",
FieldNumber = 1,
Required = false,
Accept = VisitTargetAmountField,
Format = value => value.ToString(),
};
DiscountAmountField = new NumberFieldDefinition<Billing, decimal>(k => k.DiscountAmount)
{
FieldName = "歩引額",
FieldNumber = 1,
Required = false,
Accept = VisitDiscountAmountField,
Format = value => value.ToString(),
};
InvoiceCodeField = new StringFieldDefinition<Billing>(k => k.InvoiceCode)
{
FieldName = "請求番号",
FieldNumber = 1,
Required = false,
Accept = VisitInvoiceCode,
};
BillingCategoryField = new StringFieldDefinition<Billing>(k => k.BillingCategoryCodeAndName)
{
FieldName = "請求区分",
FieldNumber = 1,
Required = false,
Accept = VisitBillingCategoryField,
};
BillingDepartmentField = new StringFieldDefinition<Billing>(k => k.DepartmentName)
{
FieldName = "請求部門名",
FieldNumber = 1,
Required = false,
Accept = VisitBillingDepartmentField,
};
BillingNote1Field = new StringFieldDefinition<Billing>(k => k.Note1)
{
FieldName = "備考",
FieldNumber = 1,
Required = false,
Accept = VisitBillingNote1Field,
};
BillingNote2Field = new StringFieldDefinition<Billing>(k => k.Note2)
{
FieldName = "備考2",
FieldNumber = 1,
Required = false,
Accept = VisitBillingNote2Field,
};
BillingNote3Field = new StringFieldDefinition<Billing>(k => k.Note3)
{
FieldName = "備考3",
FieldNumber = 1,
Required = false,
Accept = VisitBillingNote3Field,
};
BillingNote4Field = new StringFieldDefinition<Billing>(k => k.Note4)
{
FieldName = "備考4",
FieldNumber = 1,
Required = false,
Accept = VisitBillingNote4Field,
};
BillingMemoField = new StringFieldDefinition<Billing>(k => k.Memo)
{
FieldName = "請求メモ",
FieldNumber = 1,
Required = false,
Accept = VisitBillingMemoField,
};
BillingInputTypeField = new StringFieldDefinition<Billing>(k => k.InputTypeName)
{
FieldName = "データ区分",
FieldNumber = 1,
Required = false,
Accept = VisitBillingInputTypeField,
};
ScheduledPaymentKeyField = new StringFieldDefinition<Billing>(k => k.ScheduledPaymentKey)
{
FieldName = "入金予定キー",
FieldNumber = 1,
Required = false,
Accept = VisitScheduledPaymentKeyField,
};
Fields.AddRange(new IFieldDefinition<Billing>[]
{
CurrencyCodeField
,BillCheckField
,CustomerCodeField
,CustomerNameField
,BilledAtField
,DueAtField
,BillingAmountField
,RemainAmountField
,TargetAmountField
,DiscountAmountField
,InvoiceCodeField
,BillingCategoryField
,BillingDepartmentField
,BillingNote1Field
,BillingNote2Field
,BillingNote3Field
,BillingNote4Field
,BillingMemoField
,BillingInputTypeField
,ScheduledPaymentKeyField
});
}
private IEnumerable <IFieldDefinition <ReminderHistory> > InitializeFields(List <GridSetting> GridSettingInfo)
{
var index = 0;
foreach (var setting in GridSettingInfo.Where(x => x.DisplayWidth > 0))
{
index++;
if (setting.ColumnName == nameof(ReminderHistory.CustomerCodeDisplay))
{
yield return(CustomerCodeDisplayField = new StringFieldDefinition <ReminderHistory>(k => k.CustomerCodeDisplay,
setting.ColumnNameJp, index, accept: x => x.StandardString(CustomerCodeDisplayField)));
}
if (setting.ColumnName == nameof(ReminderHistory.CustomerNameDisplay))
{
yield return(CustomerNameDisplayField = new StringFieldDefinition <ReminderHistory>(k => k.CustomerNameDisplay,
setting.ColumnNameJp, index, accept: x => x.StandardString(CustomerNameDisplayField)));
}
if (setting.ColumnName == nameof(ReminderHistory.CalculateBaseDateDisplay))
{
yield return(CalculateBaseDateDisplayField = new NullableNumberFieldDefinition <ReminderHistory, DateTime>(k => k.CalculateBaseDateDisplay,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(CalculateBaseDateDisplayField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
}
if (setting.ColumnName == nameof(ReminderHistory.CurrencyCode))
{
yield return(CurrencyCodeField = new StringFieldDefinition <ReminderHistory>(k => k.CurrencyCode,
setting.ColumnNameJp, index, accept: x => x.StandardString(CurrencyCodeField)));
}
if (setting.ColumnName == nameof(ReminderHistory.ArrearsDaysDisplay))
{
yield return(ArrearsDaysDisplayField = new NullableNumberFieldDefinition <ReminderHistory, int>(k => k.ArrearsDaysDisplay,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(ArrearsDaysDisplayField), formatter: value => (value.ToString())));
}
if (setting.ColumnName == nameof(ReminderHistory.ReminderAmount))
{
yield return(ReminderAmountField = new NullableNumberFieldDefinition <ReminderHistory, decimal>(k => k.ReminderAmount,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(ReminderAmountField)));
}
if (setting.ColumnName == nameof(ReminderHistory.InputTypeName))
{
yield return(InputTypeNameField = new StringFieldDefinition <ReminderHistory>(k => k.InputTypeName
, setting.ColumnNameJp, index, accept: x => x.StandardString(InputTypeNameField)));
}
if (setting.ColumnName == nameof(ReminderHistory.StatusCodeAndName))
{
yield return(StatusCodeAndNameField = new StringFieldDefinition <ReminderHistory>(k => k.StatusCodeAndName,
setting.ColumnNameJp, index, accept: x => x.StandardString(StatusCodeAndNameField)));
}
if (setting.ColumnName == nameof(ReminderHistory.Memo))
{
yield return(MemoField = new StringFieldDefinition <ReminderHistory>(k => k.Memo,
setting.ColumnNameJp, index, accept: x => x.StandardString(MemoField)));
}
if (setting.ColumnName == nameof(ReminderHistory.OutputFlagName))
{
yield return(OutputFlagNameField = new StringFieldDefinition <ReminderHistory>(k => k.OutputFlagName,
setting.ColumnNameJp, index, accept: x => x.StandardString(OutputFlagNameField)));
}
if (setting.ColumnName == nameof(ReminderHistory.CreateAt))
{
yield return(CreateAtField = new NumberFieldDefinition <ReminderHistory, DateTime>(k => k.CreateAt,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(CreateAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToString("yyyy/MM/dd HH:mm:ss")));
}
if (setting.ColumnName == nameof(ReminderHistory.CreateByName))
{
yield return(CreateByNameField = new StringFieldDefinition <ReminderHistory>(k => k.CreateByName,
setting.ColumnNameJp, index, accept: x => x.StandardString(CreateByNameField)));
}
}
}
public MatchingSequentialFileDefinition(DataExpression expression)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "一括消込チェックリスト";
FileNameToken = DataTypeToken;
CheckedField = new NumberFieldDefinition<Collation, bool>(
k => k.Checked)
{
FieldName = "一括",
FieldNumber = 1,
Required = false,
Accept = VisitChecked,
Format = value => (value == false) ? " " : "レ",
};
CurrencyCodeField = new StringFieldDefinition<Collation>(
k => k.CurrencyCode )
{
FieldName = "通貨",
FieldNumber = 2,
Required = false,
Accept = VisitCurrencyCode,
};
CustomerCodeField = new StringFieldDefinition<Collation>(
k => k.DispCustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 3,
Required = false,
Accept = VisitCustomerCode,
};
CustomerNameField = new StringFieldDefinition<Collation>(
k => k.DispCustomerName)
{
FieldName = "得意先名（代表者）",
FieldNumber = 4,
Required = false,
Accept = VisitCustomerName,
};
BillingCountField = new NullableNumberFieldDefinition<Collation, int>(
k => k.DispBillingCount)
{
FieldName = "件数",
FieldNumber = 5,
Required = false,
Accept = VisitBillingCount,
Format = value => (value == 0) ? " " : value.ToString(""),
};
BillingAmountField = new NullableNumberFieldDefinition<Collation, decimal>(
k => k.DispBillingAmount)
{
FieldName = "金額",
FieldNumber = 6,
Required = false,
Accept = VisitBillingAmount,
Format = value => (value == 0) ? " " : value.ToString(""),
};
PayerNameField = new StringFieldDefinition<Collation>(
k => k.PayerName)
{
FieldName = "振込依頼人名",
FieldNumber = 7,
Required = false,
Accept = VisitPayerName,
};
ReceiptCountField = new NullableNumberFieldDefinition<Collation, int>(
k => k.DispReceiptCount)
{
FieldName = "件数",
FieldNumber = 8,
Required = false,
Accept = VisitReceiptCount,
Format = value => (value == 0) ? " " : value.ToString(""),
};
ReceiptAmountField = new NullableNumberFieldDefinition<Collation, decimal>(
k => k.DispReceiptAmount)
{
FieldName = "金額",
FieldNumber = 9,
Required = false,
Accept = VisitReceiptAmount,
Format = value => (value == 0) ? " " : value.ToString(""),
};
ShareTransferFee = new StringFieldDefinition<Collation>(
k => k.DispShareTransferFee)
{
FieldName = "手数科",
FieldNumber = 10,
Required = false,
Accept = VisitShareTransferfee,
};
Different = new NullableNumberFieldDefinition<Collation, decimal>(
k => k.DispDifferent)
{
FieldName = "差額",
FieldNumber = 11,
Required = false,
Accept = VisitDifferent,
Format = value => (value == 0) ? " " : value.ToString(""),
};
DisDispAdvanceReceivedCountField = new StringFieldDefinition<Collation>(
k => k.DispAdvanceReceivedCount)
{
FieldName = "前受",
FieldNumber = 12,
Required = false,
Accept = VisitorDisDispAdvanceReceivedCount,
};
Fields.AddRange(new IFieldDefinition<Collation>[] {
CheckedField,CurrencyCodeField, CustomerCodeField,
CustomerNameField, BillingCountField, BillingAmountField,
PayerNameField, ReceiptCountField, ReceiptAmountField,
ShareTransferFee, Different, DisDispAdvanceReceivedCountField});
}
public CustomerDiscountFileDefinition(DataExpression applicationControl)
: base(applicationControl)
{
StartLineNumber = 1;
DataTypeToken = "得意先";
FileNameToken = DataTypeToken + "マスター";
// FieldNumber 1 会社コード
CompanyIdField = new StandardIdToCodeFieldDefinition <CustomerDiscount, Company>(
cd => cd.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
// FieldNumber 2 得意先コード
CustomerIdField = new StandardIdToCodeFieldDefinition <CustomerDiscount, Customer>(
cd => cd.CustomerId, c => c.Id, cd => cd.CustomerCode, c => c.Code)
{
FieldName = "得意先コード",
FieldNumber = 2,
Required = true,
Accept = VisitCustomerId,
};
// FieldNumber 3 得意先名
CustomerNameField = new StringFieldDefinition <CustomerDiscount>(cd => cd.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 3,
Required = false,
Accept = VisitCustomerName,
};
// FieldNumber 4 最低実行金額
MinValueField = new NumberFieldDefinition <CustomerDiscount, decimal>(cd => cd.MinValue)
{
FieldName = "最低実行金額",
FieldNumber = 4,
Required = true,
Accept = VisitMinValue,
Format = value => value.ToString(),
};
// FieldNumber 5 歩引率1
Rate1Field = new NullableNumberFieldDefinition <CustomerDiscount, decimal>(cd => cd.Rate1)
{
FieldName = "歩引率1",
FieldNumber = 5,
Required = false,
Accept = VisitRate1,
Format = value => value.ToString(),
};
// FieldNumber 6 端数処理1
RoundingMode1Field = new NumberFieldDefinition <CustomerDiscount, int>(cd => cd.RoundingMode1)
{
FieldName = "端数処理1",
FieldNumber = 6,
Required = true,
Accept = VisitRoundingMode1,
Format = value => value.ToString(),
};
// FieldNumber 7 部門コード1
DepartmentId1Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, Department>(
cd => cd.DepartmentId1, d => d.Id, null, d => d.Code)
{
FieldName = "部門コード1",
FieldNumber = 7,
Required = false,
Accept = VisitDepartmentId1,
};
// FieldNumber 8 科目コード1
AccountTitleId1Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, AccountTitle>(
cd => cd.AccountTitleId1, a => a.Id, null, a => a.Code)
{
FieldName = "科目コード1",
FieldNumber = 8,
Required = false,
Accept = VisitAccountTitleId1,
};
// FieldNumber 9 補助コード1
SubCode1Field = new StringFieldDefinition <CustomerDiscount>(cd => cd.SubCode1)
{
FieldName = "補助コード1",
FieldNumber = 9,
Required = false,
Accept = VisitSubCode1,
};
// FieldNumber 10 歩引率2
Rate2Field = new NullableNumberFieldDefinition <CustomerDiscount, decimal>(cd => cd.Rate2)
{
FieldName = "歩引率2",
FieldNumber = 10,
Required = false,
Accept = VisitRate2,
Format = value => value.ToString(),
};
// FieldNumber 11 端数処理2
RoundingMode2Field = new NumberFieldDefinition <CustomerDiscount, int>(cd => cd.RoundingMode2)
{
FieldName = "端数処理2",
FieldNumber = 11,
Required = true,
Accept = VisitRoundingMode2,
Format = value => value.ToString(),
};
// FieldNumber 12 部門コード2
DepartmentId2Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, Department>(
cd => cd.DepartmentId2, d => d.Id, null, d => d.Code)
{
FieldName = "部門コード2",
FieldNumber = 12,
Required = false,
Accept = VisitDepartmentId2,
};
// FieldNumber 13 科目コード2
AccountTitleId2Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, AccountTitle>(
cd => cd.AccountTitleId2, a => a.Id, null, a => a.Code)
{
FieldName = "科目コード2",
FieldNumber = 13,
Required = false,
Accept = VisitAccountTitleId2,
};
// FieldNumber 14 補助コード2
SubCode2Field = new StringFieldDefinition <CustomerDiscount>(cd => cd.SubCode2)
{
FieldName = "補助コード2",
FieldNumber = 14,
Required = false,
Accept = VisitSubCode2,
};
// FieldNumber 15 歩引率3
Rate3Field = new NullableNumberFieldDefinition <CustomerDiscount, decimal>(cd => cd.Rate3)
{
FieldName = "歩引率3",
FieldNumber = 15,
Required = false,
Accept = VisitRate3,
Format = value => value.ToString(),
};
// FieldNumber 16 端数処理3
RoundingMode3Field = new NumberFieldDefinition <CustomerDiscount, int>(cd => cd.RoundingMode3)
{
FieldName = "端数処理3",
FieldNumber = 16,
Required = true,
Accept = VisitRoundingMode3,
Format = value => value.ToString(),
};
// FieldNumber 17 部門コード3
DepartmentId3Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, Department>(
cd => cd.DepartmentId3, d => d.Id, null, d => d.Code)
{
FieldName = "部門コード3",
FieldNumber = 17,
Required = false,
Accept = VisitDepartmentId3,
};
// FieldNumber 18 科目コード3
AccountTitleId3Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, AccountTitle>(
cd => cd.AccountTitleId3, a => a.Id, null, a => a.Code)
{
FieldName = "科目コード3",
FieldNumber = 18,
Required = false,
Accept = VisitAccountTitleId3,
};
// FieldNumber 19 補助コード3
SubCode3Field = new StringFieldDefinition <CustomerDiscount>(cd => cd.SubCode3)
{
FieldName = "補助コード3",
FieldNumber = 19,
Required = false,
Accept = VisitSubCode3,
};
// FieldNumber 20 歩引率4
Rate4Field = new NullableNumberFieldDefinition <CustomerDiscount, decimal>(cd => cd.Rate4)
{
FieldName = "歩引率4",
FieldNumber = 20,
Required = false,
Accept = VisitRate4,
Format = value => value.ToString(),
};
// FieldNumber 21 端数処理4
RoundingMode4Field = new NumberFieldDefinition <CustomerDiscount, int>(cd => cd.RoundingMode4)
{
FieldName = "端数処理4",
FieldNumber = 21,
Required = true,
Accept = VisitRoundingMode4,
Format = value => value.ToString(),
};
// FieldNumber 22 部門コード4
DepartmentId4Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, Department>(
cd => cd.DepartmentId4, d => d.Id, null, d => d.Code)
{
FieldName = "部門コード4",
FieldNumber = 22,
Required = false,
Accept = VisitDepartmentId4,
};
// FieldNumber 23 科目コード4
AccountTitleId4Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, AccountTitle>(
cd => cd.AccountTitleId4, a => a.Id, null, a => a.Code)
{
FieldName = "科目コード4",
FieldNumber = 23,
Required = false,
Accept = VisitAccountTitleId4,
};
// FieldNumber 24 補助コード4
SubCode4Field = new StringFieldDefinition <CustomerDiscount>(cd => cd.SubCode4)
{
FieldName = "補助コード4",
FieldNumber = 24,
Required = false,
Accept = VisitSubCode4,
};
// FieldNumber 25 歩引率5
Rate5Field = new NullableNumberFieldDefinition <CustomerDiscount, decimal>(cd => cd.Rate5)
{
FieldName = "歩引率5",
FieldNumber = 25,
Required = false,
Accept = VisitRate5,
Format = value => value.ToString(),
};
// FieldNumber 26 端数処理5
RoundingMode5Field = new NumberFieldDefinition <CustomerDiscount, int>(cd => cd.RoundingMode5)
{
FieldName = "端数処理5",
FieldNumber = 26,
Required = true,
Accept = VisitRoundingMode5,
Format = value => value.ToString(),
};
// FieldNumber 27 部門コード5
DepartmentId5Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, Department>(
cd => cd.DepartmentId5, d => d.Id, null, d => d.Code)
{
FieldName = "部門コード5",
FieldNumber = 27,
Required = false,
Accept = VisitDepartmentId5,
};
// FieldNumber 28 科目コード5
AccountTitleId5Field = new NullableForeignKeyFieldDefinition <CustomerDiscount, int, AccountTitle>(
cd => cd.AccountTitleId5, a => a.Id, null, a => a.Code)
{
FieldName = "科目コード5",
FieldNumber = 28,
Required = false,
Accept = VisitAccountTitleId5,
};
// FieldNumber 29 補助コード5
SubCode5Field = new StringFieldDefinition <CustomerDiscount>(cd => cd.SubCode5)
{
FieldName = "補助コード5",
FieldNumber = 29,
Required = false,
Accept = VisitSubCode5,
};
Fields.AddRange(new IFieldDefinition <CustomerDiscount>[] {
CompanyIdField
, CustomerIdField
, CustomerNameField
, MinValueField
, Rate1Field
, RoundingMode1Field
, DepartmentId1Field
, AccountTitleId1Field
, SubCode1Field
, Rate2Field
, RoundingMode2Field
, DepartmentId2Field
, AccountTitleId2Field
, SubCode2Field
, Rate3Field
, RoundingMode3Field
, DepartmentId3Field
, AccountTitleId3Field
, SubCode3Field
, Rate4Field
, RoundingMode4Field
, DepartmentId4Field
, AccountTitleId4Field
, SubCode4Field
, Rate5Field
, RoundingMode5Field
, DepartmentId5Field
, AccountTitleId5Field
, SubCode5Field
});
KeyFields.AddRange(new IFieldDefinition <CustomerDiscount>[]
{
CustomerIdField,
});
}
} //63
public CustomerFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "得意先";
FileNameToken = DataTypeToken + "マスター";
//1
CompanyIdField = new StandardIdToCodeFieldDefinition <Customer, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
//2
CustomerCodeField = new StringFieldDefinition <Customer>(k => k.Code)
{
FieldName = "得意先コード",
FieldNumber = 2,
Required = true,
Accept = VisitCustomerCode,
};
//3
CustomerNameField = new StringFieldDefinition <Customer>(k => k.Name)
{
FieldName = "得意先名",
FieldNumber = 3,
Required = true,
Accept = VisitCustomerName,
};
//4
CustomerKanaField = new StringFieldDefinition <Customer>(k => k.Kana)
{
FieldName = "得意先名カナ",
FieldNumber = 4,
Required = true,
Accept = VisitCustomerKana,
};
//5
ExclusiveBankCodeField = new StringFieldDefinition <Customer>(k => k.ExclusiveBankCode)
{
FieldName = "専用銀行コード",
FieldNumber = 5,
Required = false,
Accept = VisitExclusiveBankCode,
};
//6
ExclusiveBankNameField = new StringFieldDefinition <Customer>(k => k.ExclusiveBankName)
{
FieldName = "専用銀行名",
FieldNumber = 6,
Required = false,
Accept = VisitExclusiveBankName,
};
//7
ExclusiveBranchCodeField = new StringFieldDefinition <Customer>(k => k.ExclusiveBranchCode)
{
FieldName = "専用支店コード",
FieldNumber = 7,
Required = false,
Accept = VisitExclusiveBranchCode,
};
//8
ExclusiveBranchNameField = new StringFieldDefinition <Customer>(k => k.ExclusiveBranchName)
{
FieldName = "専用支店名",
FieldNumber = 8,
Required = false,
Accept = VisitExclusiveBranchName,
};
//9
ExclusiveAccountNumberField = new StringFieldDefinition <Customer>(k => k.ExclusiveAccountNumber)
{
FieldName = "専用入金口座番号",
FieldNumber = 9,
Required = false,
Accept = VisitExclusiveAccountNumber,
};
//10
ExclusiveAccountTypeIdField = new NullableNumberFieldDefinition <Customer, int>(k => k.ExclusiveAccountTypeId)
{
FieldName = "預金種別",
FieldNumber = 10,
Required = true,
Accept = VisitExclusiveAccountTypeId,
Format = value => value.ToString(),
};
//11
ShareTransferFeeField = new NumberFieldDefinition <Customer, int>(k => k.ShareTransferFee)
{
FieldName = "手数料負担区分",
FieldNumber = 11,
Required = true,
Accept = VisitShareTransferFee,
Format = value => value.ToString(),
};
//12
CreditLimitField = new NumberFieldDefinition <Customer, decimal>(k => k.CreditLimit)
{
FieldName = "与信限度額",
FieldNumber = 12,
Required = false,
Accept = VisitCreditLimit,
Format = value => value.ToString("#"),
};
//13
ClosingDayField = new NumberFieldDefinition <Customer, int>(k => k.ClosingDay)
{
FieldName = "締日",
FieldNumber = 13,
Required = true,
Accept = VisitClosingDay,
Format = value => value.ToString("00"),
};
//14
CollectCategoryIdField = new StandardIdToCodeFieldDefinition <Customer, Category>(
k => k.CollectCategoryId, c => c.Id, null, c => c.Code)
{
FieldName = "回収方法",
FieldNumber = 14,
Required = true,
Accept = VisitCollectCategoryId,
};
//15
CollectOffsetMonthField = new NumberFieldDefinition <Customer, int>(k => k.CollectOffsetMonth)
{
FieldName = "回収予定（月）",
FieldNumber = 15,
Required = true,
Accept = VisitCollectOffsetMonth,
Format = value => value.ToString(),
};
//16
CollectOffsetDayField = new NumberFieldDefinition <Customer, int>(k => k.CollectOffsetDay)
{
FieldName = "回収予定（日）",
FieldNumber = 16,
Required = true,
Accept = VisitCollectOffsetDay,
Format = value => value.ToString(),
};
//17
StaffCodeField = new StandardIdToCodeFieldDefinition <Customer, Staff>(
k => k.StaffId, c => c.Id, l => l.StaffCode, c => c.Code)
{
FieldName = "営業担当者",
FieldNumber = 17,
Required = true,
Accept = VisitStaffCodeField,
};
//18
IsParentField = new NumberFieldDefinition <Customer, int>(k => k.IsParent)
{
FieldName = "債権代表者フラグ",
FieldNumber = 18,
Required = true,
Accept = VisitIsParent,
Format = value => value.ToString(),
};
//19
PostalCodeField = new StringFieldDefinition <Customer>(k => k.PostalCode)
{
FieldName = "郵便番号",
FieldNumber = 19,
Required = false,
Accept = VisitPostalCode,
};
//20
Address1Field = new StringFieldDefinition <Customer>(k => k.Address1)
{
FieldName = "住所1",
FieldNumber = 20,
Required = false,
Accept = VisitAddress1Field,
};
//21
Address2Field = new StringFieldDefinition <Customer>(k => k.Address2)
{
FieldName = "住所2",
FieldNumber = 21,
Required = false,
Accept = VisitAddress2Field,
};
//22
TelField = new StringFieldDefinition <Customer>(k => k.Tel)
{
FieldName = "TEL番号",
FieldNumber = 22,
Required = false,
Accept = VisitTel,
};
//23
FaxField = new StringFieldDefinition <Customer>(k => k.Fax)
{
FieldName = "FAX番号",
FieldNumber = 23,
Required = false,
Accept = VisitFax,
};
//24
CustomerStaffNameField = new StringFieldDefinition <Customer>(k => k.CustomerStaffName)
{
FieldName = "相手先担当者名",
FieldNumber = 24,
Required = false,
Accept = VisitCustomerStaffName,
};
//25
NoteField = new StringFieldDefinition <Customer>(k => k.Note)
{
FieldName = "備考",
FieldNumber = 25,
Required = false,
Accept = VisitNote,
};
//26
UseFeeLearningField = new NumberFieldDefinition <Customer, int>(k => k.UseFeeLearning)
{
FieldName = "手数料自動学習",
FieldNumber = 26,
Required = true,
Accept = VisitUseFeeLearning,
Format = value => value.ToString(),
};
//27
SightOfBillField = new NullableNumberFieldDefinition <Customer, int>(k => k.SightOfBill)
{
FieldName = "回収サイト",
FieldNumber = 27,
Required = true,
Accept = VisitSightOfBill,
Format = value => value.ToString(),
};
//28
DensaiCodeField = new StringFieldDefinition <Customer>(k => k.DensaiCode)
{
FieldName = "電子手形用企業コード",
FieldNumber = 28,
Required = false,
Accept = VisitDensaiCode,
};
//29
CreditCodeField = new StringFieldDefinition <Customer>(k => k.CreditCode)
{
FieldName = "信用調査用企業コード",
FieldNumber = 29,
Required = false,
Accept = VisitCreditCode,
};
//30
CreditRankField = new StringFieldDefinition <Customer>(k => k.CreditRank)
{
FieldName = "与信ランク",
FieldNumber = 30,
Required = false,
Accept = VisitCreditRank,
};
//31
TransferBankCodeField = new StringFieldDefinition <Customer>(k => k.TransferBankCode)
{
FieldName = "口座振替用銀行コード",
FieldNumber = 31,
Required = false,
Accept = VisitTransferBankCode,
};
//32
TransferBankNameField = new StringFieldDefinition <Customer>(k => k.TransferBankName)
{
FieldName = "口座振替用銀行名",
FieldNumber = 32,
Required = false,
Accept = VisitTransferBankName,
};
//33
TransferBranchCodeField = new StringFieldDefinition <Customer>(k => k.TransferBranchCode)
{
FieldName = "口座振替用支店コード",
FieldNumber = 33,
Required = false,
Accept = VisitTransferBranchCode,
};
//34
TransferBranchNameField = new StringFieldDefinition <Customer>(k => k.TransferBranchName)
{
FieldName = "口座振替用支店名",
FieldNumber = 34,
Required = false,
Accept = VisitTransferBranchName,
};
//35
TransferAccountNumberField = new StringFieldDefinition <Customer>(k => k.TransferAccountNumber)
{
FieldName = "口座振替用口座番号",
FieldNumber = 35,
Required = false,
Accept = VisitTransferAccountNumber,
};
//36
TransferAccountTypeIdField = new NullableNumberFieldDefinition <Customer, int>(k => k.TransferAccountTypeId)
{
FieldName = "口座振替用預金種別",
FieldNumber = 36,
Required = true,
Accept = VisitTransferAccountTypeId,
Format = value => value.ToString(),
};
//37
TransferCustomerCodeField = new StringFieldDefinition <Customer>(k => k.TransferCustomerCode)
{
FieldName = "口座振替用顧客コード",
FieldNumber = 37,
Required = false,
Accept = VisitTransferCustomerCode,
};
//38
TransferNewCodeField = new StringFieldDefinition <Customer>(k => k.TransferNewCode)
{
FieldName = "口座振替用新規コード",
FieldNumber = 38,
Required = false,
Accept = VisitTransferNewCode,
};
//39
TransferAccountNameField = new StringFieldDefinition <Customer>(k => k.TransferAccountName)
{
FieldName = "口座振替用預金者名",
FieldNumber = 39,
Required = false,
Accept = VisitTransferAccountName,
};
//40
ThresholdValueField = new NumberFieldDefinition <Customer, decimal>(k => k.ThresholdValue)
{
FieldName = "約定金額",
FieldNumber = 40,
Required = true,
Accept = VisitThresholdValue,
Format = value => value.ToString("#"),
};
//41
LessThanCollectCategoryIdField = new StandardIdToCodeFieldDefinition <Customer, Category>(
k => k.LessThanCollectCategoryId, c => c.Id, null, c => c.Code)
{
FieldName = "約定金額未満",
FieldNumber = 41,
Required = true,
Accept = VisitLessThanCollectCategoryId,
};
//42
GreaterThanCollectCategoryId1Field = new StandardIdToCodeFieldDefinition <Customer, Category>(
k => k.GreaterThanCollectCategoryId1, c => c.Id, null, c => c.Code)
{
FieldName = "約定金額以上1",
FieldNumber = 42,
Required = true,
Accept = VisitGreaterThanCollectCategoryId1,
};
//43
GreaterThanRate1Field = new NullableNumberFieldDefinition <Customer, decimal>(k => k.GreaterThanRate1)
{
FieldName = "分割1",
FieldNumber = 43,
Required = true,
Accept = VisitGreaterThanRate1,
Format = value => value.ToString(),
};
//44
GreaterThanRoundingMode1Field = new NullableNumberFieldDefinition <Customer, int>(k => k.GreaterThanRoundingMode1)
{
FieldName = "端数1",
FieldNumber = 44,
Required = true,
Accept = VisitGreaterThanRoundingMode1,
Format = value => value.ToString(),
};
//45
GreaterThanSightOfBill1Field = new NullableNumberFieldDefinition <Customer, int>(k => k.GreaterThanSightOfBill1)
{
FieldName = "回収サイト1",
FieldNumber = 45,
Required = true,
Accept = VisitGreaterThanSightOfBill1,
Format = value => value.ToString(),
};
//46
GreaterThanCollectCategoryId2Field = new StandardNullableIdToCodeFieldDefinition <Customer, Category>(
k => k.GreaterThanCollectCategoryId2, c => c.Id, null, c => c.Code)
{
FieldName = "約定金額以上2",
FieldNumber = 46,
Required = false,
Accept = VisitGreaterThanCollectCategoryId2,
};
//47
GreaterThanRate2Field = new NullableNumberFieldDefinition <Customer, decimal>(k => k.GreaterThanRate2)
{
FieldName = "分割2",
FieldNumber = 47,
Required = true,
Accept = VisitGreaterThanRate2,
Format = value => value.ToString(),
};
//48
GreaterThanRoundingMode2Field = new NullableNumberFieldDefinition <Customer, int>(k => k.GreaterThanRoundingMode2)
{
FieldName = "端数2",
FieldNumber = 48,
Required = true,
Accept = VisitGreaterThanRoundingMode2,
Format = value => value.ToString(),
};
//49
GreaterThanSightOfBill2Field = new NullableNumberFieldDefinition <Customer, int>(k => k.GreaterThanSightOfBill2)
{
FieldName = "回収サイト2",
FieldNumber = 49,
Required = true,
Accept = VisitGreaterThanSightOfBill2,
Format = value => value.ToString(),
};
//50
GreaterThanCollectCategoryId3Field = new StandardNullableIdToCodeFieldDefinition <Customer, Category>(
k => k.GreaterThanCollectCategoryId3, c => c.Id, null, c => c.Code)
{
FieldName = "約定金額以上3",
FieldNumber = 50,
Required = false,
Accept = VisitGreaterThanCollectCategoryId3,
};
//51
GreaterThanRate3Field = new NullableNumberFieldDefinition <Customer, decimal>(k => k.GreaterThanRate3)
{
FieldName = "分割3",
FieldNumber = 51,
Required = true,
Accept = VisitGreaterThanRate3,
Format = value => value.ToString(),
};
//52
GreaterThanRoundingMode3Field = new NullableNumberFieldDefinition <Customer, int>(k => k.GreaterThanRoundingMode3)
{
FieldName = "端数3",
FieldNumber = 52,
Required = true,
Accept = VisitGreaterThanRoundingMode3,
Format = value => value.ToString(),
};
//53
GreaterThanSightOfBill3Field = new NullableNumberFieldDefinition <Customer, int>(k => k.GreaterThanSightOfBill3)
{
FieldName = "回収サイト3",
FieldNumber = 53,
Required = true,
Accept = VisitGreaterThanSightOfBill3,
Format = value => value.ToString(),
};
//54
UseKanaLearningField = new NumberFieldDefinition <Customer, int>(k => k.UseKanaLearning)
{
FieldName = "カナ自動学習",
FieldNumber = 54,
Required = true,
Accept = VisitUseKanaLearning,
Format = value => value.ToString(),
};
//55
HolidayFlagField = new NumberFieldDefinition <Customer, int>(k => k.HolidayFlag)
{
FieldName = "休業日設定",
FieldNumber = 55,
Required = true,
Accept = VisitHolidayFlag,
Format = value => value.ToString(),
};
//56
UseFeeToleranceField = new NumberFieldDefinition <Customer, int>(k => k.UseFeeTolerance)
{
FieldName = "手数料誤差利用",
FieldNumber = 56,
Required = true,
Accept = VisitUseFeeTolerance,
Format = value => value.ToString(),
};
//57
PrioritizeMatchingIndividuallyField = new NumberFieldDefinition <Customer, int>(k => k.PrioritizeMatchingIndividually)
{
FieldName = "一括消込対象外",
FieldNumber = 57,
Required = true,
Accept = VisitPrioritizeMatchingIndividually,
Format = value => value.ToString(),
};
//58
CollationKeyField = new StringFieldDefinition <Customer>(k => k.CollationKey)
{
FieldName = "照合番号",
FieldNumber = 58,
Required = false,
Accept = VisitCollationKey,
};
//60
ExcludeInvoicePublishField = new NumberFieldDefinition <Customer, int>(k => k.ExcludeInvoicePublish)
{
FieldName = "請求書発行対象外",
FieldNumber = 60,
Required = true,
Accept = VisitExcludeInvoicePublish,
Format = value => value.ToString(),
};
//61
ExcludeReminderPublishField = new NumberFieldDefinition <Customer, int>(k => k.ExcludeReminderPublish)
{
FieldName = "督促状発行対象外",
FieldNumber = 61,
Required = true,
Accept = VisitExcludeReminderPublish,
Format = value => value.ToString(),
};
//62
DestinationDepartmentNameField = new StringFieldDefinition <Customer>(k => k.DestinationDepartmentName)
{
FieldName = "相手先部署",
FieldNumber = 62,
Required = false,
Accept = VisitDestinationDepartmentName,
};
//63
HonorificField = new StringFieldDefinition <Customer>(k => k.Honorific)
{
FieldName = "敬称",
FieldNumber = 63,
Required = false,
Accept = VisitHonorific,
};
Fields.AddRange(new IFieldDefinition <Customer>[] {
CompanyIdField, CustomerCodeField, CustomerNameField, CustomerKanaField, ExclusiveBankCodeField,
ExclusiveBankNameField, ExclusiveBranchCodeField, ExclusiveBranchNameField, ExclusiveAccountNumberField, ExclusiveAccountTypeIdField
, ShareTransferFeeField, CreditLimitField, ClosingDayField, CollectCategoryIdField, CollectOffsetMonthField
, CollectOffsetDayField, StaffCodeField, IsParentField, PostalCodeField, Address1Field,
Address2Field, TelField, FaxField, CustomerStaffNameField, NoteField,
UseFeeLearningField, SightOfBillField, DensaiCodeField, CreditCodeField, CreditRankField,
TransferBankCodeField, TransferBankNameField, TransferBranchCodeField, TransferBranchNameField, TransferAccountNumberField,
TransferAccountTypeIdField, TransferCustomerCodeField, TransferNewCodeField, TransferAccountNameField,
ThresholdValueField, LessThanCollectCategoryIdField, GreaterThanCollectCategoryId1Field, GreaterThanRate1Field,
GreaterThanRoundingMode1Field, GreaterThanSightOfBill1Field, GreaterThanCollectCategoryId2Field, GreaterThanRate2Field, GreaterThanRoundingMode2Field
, GreaterThanSightOfBill2Field, GreaterThanCollectCategoryId3Field, GreaterThanRate3Field, GreaterThanRoundingMode3Field, GreaterThanSightOfBill3Field
, UseKanaLearningField, HolidayFlagField, UseFeeToleranceField, PrioritizeMatchingIndividuallyField, CollationKeyField, ExcludeInvoicePublishField, ExcludeReminderPublishField
, DestinationDepartmentNameField, HonorificField
});
KeyFields.AddRange(new IFieldDefinition <Customer>[]
{
CustomerCodeField,
});
}
public KanaHistoryCustomerFileDefinition(DataExpression expression)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "得意先学習履歴";
FileNameToken = DataTypeToken;
CompanyIdField = new StandardIdToCodeFieldDefinition <KanaHistoryCustomer, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
PayerNameField = new StringFieldDefinition <KanaHistoryCustomer>(k => k.PayerName)
{
FieldName = "振込依頼人名",
FieldNumber = 2,
Required = false,
Accept = VisitKana,
};
CustomerIdField = new StandardIdToCodeFieldDefinition <KanaHistoryCustomer, Customer>(
k => k.CustomerId, c => c.Id,
k => k.CustomerCode, c => c.Code)
{
FieldName = "得意先コード",
FieldNumber = 3,
Required = true,
Accept = VisitcustomerId,
};
SourceBankNameField = new StringFieldDefinition <KanaHistoryCustomer>(k => k.SourceBankName)
{
FieldName = "仕向銀行",
FieldNumber = 4,
Required = false,
Accept = VisitSourceBankName,
};
SourceBrankNameField = new StringFieldDefinition <KanaHistoryCustomer>(k => k.SourceBranchName)
{
FieldName = "仕向支店",
FieldNumber = 5,
Required = false,
Accept = VisitSourceBrankName,
};
HitCountField = new NumberFieldDefinition <KanaHistoryCustomer, int>(k => k.HitCount)
{
FieldName = "消込回数",
FieldNumber = 6,
Required = true,
Accept = VisitHitCount,
Format = value => value.ToString(),
};
Fields.AddRange(new IFieldDefinition <KanaHistoryCustomer>[] {
CompanyIdField, PayerNameField, CustomerIdField, SourceBankNameField, SourceBrankNameField, HitCountField
});
KeyFields.AddRange(new IFieldDefinition <KanaHistoryCustomer>[]
{
PayerNameField,
CustomerIdField,
SourceBankNameField,
SourceBrankNameField,
});
}
public BillingAgingListFileDefinition(DataExpression expression,
string Remain0Header,
string Remain1Header,
string Remain2Header,
string Remain3Header)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "請求残高年齢表";
FileNameToken = DataTypeToken;
Fields.Add(DepartmentCodeField = new StringFieldDefinition <BillingAgingList>(k => k.DepartmentCode,
fieldName: "請求部門コード",
accept: VisitDepartmentCodeField));
Fields.Add(DepartmentNameField = new StringFieldDefinition <BillingAgingList>(k => k.DepartmentName,
fieldName: "請求部門名",
accept: VisitDepartmentNameField));
Fields.Add(StaffCodeField = new StringFieldDefinition <BillingAgingList>(k => k.StaffCode,
fieldName: "担当者コード",
accept: VisitStaffCodeField));
Fields.Add(StaffNameField = new StringFieldDefinition <BillingAgingList>(k => k.StaffName,
fieldName: "担当者名",
accept: VisitStaffNameField));
Fields.Add(CustomerCodeField = new StringFieldDefinition <BillingAgingList>(k => k.CustomerCode,
fieldName: "得意先コード",
accept: VisitCustomerCodeField));
Fields.Add(CustomerNameField = new StringFieldDefinition <BillingAgingList>(k => k.CustomerName,
fieldName: "得意先名",
accept: VisitCustomerNameField));
Fields.Add(LastMonthRemainField = new NullableNumberFieldDefinition <BillingAgingList, decimal>(k => k.LastMonthRemain,
fieldName: "前月請求残",
accept: VisitLastMonthRemainField,
formatter: value => value.ToString()));
Fields.Add(CurrenctMonthSaleField = new NumberFieldDefinition <BillingAgingList, decimal>(k => k.CurrentMonthSales,
fieldName: "当月売上高",
accept: VisitCurrentMonthSaleField,
formatter: value => value.ToString()));
Fields.Add(CurrentMonthReceiptField = new NullableNumberFieldDefinition <BillingAgingList, decimal>(k => k.CurrentMonthReceipt,
fieldName: "当月入金",
accept: VisitCurrentMonthReceiptField,
formatter: value => value.ToString()));
Fields.Add(CurrentMonthMatchingField = new NumberFieldDefinition <BillingAgingList, decimal>(k => k.CurrentMonthMatching,
fieldName: "当月消込",
accept: VisitCurrentMonthMatchingField,
formatter: value => value.ToString()));
Fields.Add(CurrenttMonthRemainField = new NullableNumberFieldDefinition <BillingAgingList, decimal>(k => k.CurrentMonthRemain,
fieldName: "当月請求残",
accept: VisitCurrentMonthRemainField,
formatter: value => value.ToString()));
Fields.Add(MonthlyRemain0Field = new NullableNumberFieldDefinition <BillingAgingList, decimal>(k => k.MonthlyRemain0,
fieldName: Remain0Header,
accept: VisitMonthlyRemain0Field,
formatter: value => value.ToString()));
Fields.Add(MonthlyRemain1Field = new NullableNumberFieldDefinition <BillingAgingList, decimal>(k => k.MonthlyRemain1,
fieldName: Remain1Header,
accept: VisitMonthlyRemain1Field,
formatter: value => value.ToString()));
Fields.Add(MonthlyRemain2Field = new NullableNumberFieldDefinition <BillingAgingList, decimal>(k => k.MonthlyRemain2,
fieldName: Remain2Header,
accept: VisitMonthlyRemain2Field,
formatter: value => value.ToString()));
Fields.Add(MonthlyRemain3Field = new NullableNumberFieldDefinition <BillingAgingList, decimal>(k => k.MonthlyRemain3,
fieldName: Remain3Header,
accept: VisitMonthlyRemain3Field,
formatter: value => value.ToString()));
}
public ScheduledPaymentListFileDefinition(DataExpression applicationControl, List <ColumnNameSetting> ColumnNameSettingInfo)
: base(applicationControl)
{
StartLineNumber = 1;
DataTypeToken = "入金予定明細表";
FileNameToken = DataTypeToken;
BaseDateField = new NullableNumberFieldDefinition <ScheduledPaymentList, DateTime>(k => k.BaseDate)
{
FieldName = "基準日",
FieldNumber = 1,
Required = false,
Accept = VisitBaseDate,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
IDField = new NumberFieldDefinition <ScheduledPaymentList, int>(k => k.Id)
{
FieldName = "請求ID",
FieldNumber = 2,
Required = false,
Accept = VisitId,
Format = value => value.ToString(),
};
CustomerCodeField = new StringFieldDefinition <ScheduledPaymentList>(k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 3,
Required = false,
Accept = VisitCustomerCode,
};
CustomerNameField = new StringFieldDefinition <ScheduledPaymentList>(k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 4,
Required = false,
Accept = VisitCustomerName,
};
BilledAtField = new NullableNumberFieldDefinition <ScheduledPaymentList, DateTime>(k => k.BilledAt)
{
FieldName = "請求日",
FieldNumber = 5,
Required = true,
Accept = VisitBilledAtField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
SalesAtField = new NullableNumberFieldDefinition <ScheduledPaymentList, DateTime>(k => k.SalesAt)
{
FieldName = "売上日",
FieldNumber = 6,
Required = true,
Accept = VisitSalesAtField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
ClosingAtField = new NullableNumberFieldDefinition <ScheduledPaymentList, DateTime>(k => k.ClosingAt)
{
FieldName = "請求締日",
FieldNumber = 7,
Required = true,
Accept = VisitClosingAtField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
DueAtField = new NullableNumberFieldDefinition <ScheduledPaymentList, DateTime>(k => k.DueAt)
{
FieldName = "入金予定日",
FieldNumber = 8,
Required = true,
Accept = VisitDueAtField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
OriginalDueAtField = new NullableNumberFieldDefinition <ScheduledPaymentList, DateTime>(k => k.OriginalDueAt)
{
FieldName = "当初予定日",
FieldNumber = 9,
Required = true,
Accept = VisitOriginalDueAtField,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
CurrencyCodeField = new StringFieldDefinition <ScheduledPaymentList>(k => k.CurrencyCode)
{
FieldName = "通貨コード",
FieldNumber = 10,
Required = false,
Accept = VisitCurrencyCode,
};
AmountField = new NumberFieldDefinition <ScheduledPaymentList, decimal>(k => k.RemainAmount)
{
FieldName = "回収予定金額",
FieldNumber = 11,
Required = true,
Accept = VisitAmount,
Format = value => value.ToString(),
};
DelayDivisionField = new StringFieldDefinition <ScheduledPaymentList>(k => k.DelayDivision)
{
FieldName = "遅延",
FieldNumber = 12,
Required = false,
Accept = VisitDelayDivisionField,
};
CodeAndNameField = new StringFieldDefinition <ScheduledPaymentList>(k => k.CodeAndName)
{
FieldName = "回収区分",
FieldNumber = 13,
Required = false,
Accept = VisitCodeAndNameField,
};
InvoiceCodeField = new StringFieldDefinition <ScheduledPaymentList>(k => k.InvoiceCode)
{
FieldName = "請求書番号",
FieldNumber = 14,
Required = false,
Accept = VisitInvoiceCodeField,
};
DepartmentCodeField = new StringFieldDefinition <ScheduledPaymentList>(k => k.DepartmentCode)
{
FieldName = "請求部門コード",
FieldNumber = 15,
Required = false,
Accept = VisitDepartmentCodeField,
};
DepartmentNameField = new StringFieldDefinition <ScheduledPaymentList>(k => k.DepartmentName)
{
FieldName = "請求部門名",
FieldNumber = 16,
Required = false,
Accept = VisitDepartmentNameField,
};
StaffCodeField = new StringFieldDefinition <ScheduledPaymentList>(k => k.StaffCode)
{
FieldName = "担当者コード",
FieldNumber = 17,
Required = false,
Accept = VisitStaffCodeField,
};
StaffNameField = new StringFieldDefinition <ScheduledPaymentList>(k => k.StaffName)
{
FieldName = "担当者名",
FieldNumber = 18,
Required = false,
Accept = VisitStaffNameField,
};
foreach (ColumnNameSetting gs in ColumnNameSettingInfo)
{
switch (gs.ColumnName)
{
case "Note1":
Note1Field = new StringFieldDefinition <ScheduledPaymentList>(k => k.Note1)
{
FieldName = gs.DisplayColumnName,
FieldNumber = 19,
Required = false,
Accept = VisitNote1Field,
};
break;
case "Note2":
Note2Field = new StringFieldDefinition <ScheduledPaymentList>(k => k.Note2)
{
FieldName = gs.DisplayColumnName,
FieldNumber = 20,
Required = false,
Accept = VisitNote2Field,
};
break;
case "Note3":
Note3Field = new StringFieldDefinition <ScheduledPaymentList>(k => k.Note3)
{
FieldName = gs.DisplayColumnName,
FieldNumber = 21,
Required = false,
Accept = VisitNote3Field,
};
break;
case "Note4":
Note4Field = new StringFieldDefinition <ScheduledPaymentList>(k => k.Note4)
{
FieldName = gs.DisplayColumnName,
FieldNumber = 22,
Required = false,
Accept = VisitNote4Field,
};
break;
}
}
Fields.AddRange(new IFieldDefinition <ScheduledPaymentList>[] {
BaseDateField, IDField, CustomerCodeField, CustomerNameField, BilledAtField, SalesAtField, ClosingAtField,
DueAtField, OriginalDueAtField, CurrencyCodeField, AmountField, DelayDivisionField,
CodeAndNameField, InvoiceCodeField, DepartmentCodeField, DepartmentNameField, StaffCodeField, StaffNameField, Note1Field,
Note2Field, Note3Field, Note4Field
});
}
public CurrencyFileDefinition(DataExpression expression)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "通貨";
FileNameToken = DataTypeToken + "マスター";
CompanyIdField = new StandardIdToCodeFieldDefinition <Currency, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
CurrencyCodeField = new StringFieldDefinition <Currency>(k => k.Code)
{
FieldName = "通貨コード",
FieldNumber = 2,
Required = true,
Accept = VisitCurrencyCode,
};
CurrencyNameField = new StringFieldDefinition <Currency>(k => k.Name)
{
FieldName = "名称",
FieldNumber = 3,
Required = true,
Accept = VisitCurrencyName,
};
CurrencySymbolField = new StringFieldDefinition <Currency>(k => k.Symbol)
{
FieldName = "単位",
FieldNumber = 4,
Required = true,
Accept = VisitCurrencySymbol,
};
CurrencyPrecisionField = new NumberFieldDefinition <Currency, int>(k => k.Precision)
{
FieldName = "小数点以下桁数",
FieldNumber = 5,
Required = true,
Accept = VisitCurrencyPrecision,
Format = value => value.ToString(),
};
CurrencyDisplayOrderField = new NumberFieldDefinition <Currency, int>(k => k.DisplayOrder)
{
FieldName = "表示順番",
FieldNumber = 6,
Required = true,
Accept = VisitCurrencyDisplayOrder,
Format = value => value.ToString(),
};
CurrencyNoteField = new StringFieldDefinition <Currency>(k => k.Note)
{
FieldName = "備考",
FieldNumber = 7,
Required = false,
Accept = VisitCurrencyNote,
};
CurrencyToleranceField = new NumberFieldDefinition <Currency, decimal>(k => k.Tolerance)
{
FieldName = "手数料誤差金額",
FieldNumber = 8,
Required = true,
Accept = VisitCurrencyTolerance,
Format = value => value.ToString(),
};
Fields.AddRange(new IFieldDefinition <Currency>[] {
CompanyIdField, CurrencyCodeField, CurrencyNameField, CurrencySymbolField, CurrencyPrecisionField
, CurrencyDisplayOrderField, CurrencyNoteField, CurrencyToleranceField
});
KeyFields.AddRange(new IFieldDefinition <Currency>[]
{
CurrencyCodeField,
});
}
public ReceiptSearchFileDefinition(DataExpression expression, List <GridSetting> GridSettingInfo)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "入金データ";
FileNameToken = DataTypeToken;
int fieldNumber = 1;
Fields.Add(DeleteAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.DeleteAt,
fieldName: "削除日", fieldNumber: fieldNumber,
accept: VisitDeleteAtField,
formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
foreach (GridSetting gs in GridSettingInfo)
{
fieldNumber++;
IFieldDefinition <Receipt> field = null;
switch (gs.ColumnName)
{
case "ExcludeFlag":
field = (ExcludeFlagField = new NumberFieldDefinition <Receipt, int>(k => k.ExcludeFlag,
accept: VisitExcludeFlagField,
formatter: value => value.ToString()));
break;
case "ExcludeCategory":
field = (ExcludeCategoryNameField = new StringFieldDefinition <Receipt>(k => k.ExcludeCategoryName,
accept: VisitExcludeCategoryNameField));
break;
case "Id":
field = (IdField = new NumberFieldDefinition <Receipt, long>(k => k.Id,
accept: VisitIdField,
formatter: value => value.ToString()));
break;
case "AssignmentState":
field = (AssignmentFlagNameField = new StringFieldDefinition <Receipt>(k => k.AssignmentFlagName,
accept: VisitAssignmentFlagNameField));
break;
case "RecordedAt":
field = (RecordedAtField = new NumberFieldDefinition <Receipt, DateTime>(k => k.RecordedAt,
accept: VisitRecordedAtField,
formatter: value => (value == null) ? "" : value.ToShortDateString()));
break;
case "CustomerCode":
field = (CustomerCodeField = new StandardNullableIdToCodeFieldDefinition <Receipt, Customer>(
k => k.CustomerId, c => c.Id, k => k.CustomerCode, c => c.Code,
accept: VisitCustomerCodeField));
break;
case "CustomerName":
field = (CustomerNameField = new StringFieldDefinition <Receipt>(k => k.CustomerName,
accept: VisitCustomerNameField));
break;
case "PayerName":
field = (PayerNameField = new StringFieldDefinition <Receipt>(k => k.PayerName,
accept: VisitPayerNameField));
break;
case "CurrencyCode":
field = (CurrencyIdField = new StandardIdToCodeFieldDefinition <Receipt, Currency>(
k => k.CurrencyId, c => c.Id,
k => k.CurrencyCode, c => c.Code,
accept: VisitCurrencyIdField));
break;
case "ReceiptAmount":
field = (ReceiptAmountField = new NumberFieldDefinition <Receipt, decimal>(k => k.ReceiptAmount,
accept: VisitReceiptAmountField,
formatter: value => value.ToString()));
break;
case "RemainAmount":
field = (RemainAmountField = new NumberFieldDefinition <Receipt, decimal>(k => k.RemainAmount,
accept: VisitRemainAmountField,
formatter: value => value.ToString()));
break;
case "ExcludeAmount":
field = (ExcludeAmountField = new NumberFieldDefinition <Receipt, decimal>(k => k.ExcludeAmount,
accept: VisitExcludeAmountField,
formatter: value => value.ToString()));
break;
case "ReceiptCategoryName":
field = (ReceiptCategoryNameField = new StringFieldDefinition <Receipt>(k => k.CategoryCodeName,
accept: VisitReceiptCategoryNameField));
break;
case "InputType":
field = (InputTypeField = new StringFieldDefinition <Receipt>(k => k.InputTypeName,
accept: VisitInputTypeField));
break;
case "Note1":
field = (Note1Field = new StringFieldDefinition <Receipt>(k => k.Note1,
accept: VisitNote1Field));
break;
case "Note2":
field = (Note2Field = new StringFieldDefinition <Receipt>(k => k.Note2,
accept: VisitNote2Field));
break;
case "Note3":
field = (Note3Field = new StringFieldDefinition <Receipt>(k => k.Note3,
accept: VisitNote3Field));
break;
case "Note4":
field = (Note4Field = new StringFieldDefinition <Receipt>(k => k.Note4,
accept: VisitNote4Field));
break;
case "Memo":
field = (ReceiptMemoField = new StringFieldDefinition <Receipt>(k => k.ReceiptMemo,
accept: VisitReceiptMemoField));
break;
case "DueAt":
field = (DueAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.DueAt,
accept: VisitDueAtField,
formatter: value => (value == null) ? "" : value.ToShortDateString()));
break;
case "SectionCode":
field = (SectionIdField = new StandardNullableIdToCodeFieldDefinition <Receipt, Section>(
k => k.SectionId, c => c.Id,
k => k.SectionCode, c => c.Code,
accept: VisitSectionIdField));
break;
case "SectionName":
field = (SectionNameField = new StringFieldDefinition <Receipt>(k => k.SectionName,
accept: VisitSectionNameField));
break;
case "BankCode":
field = (BankCodeField = new StringFieldDefinition <Receipt>(k => k.BankCode,
accept: VisitBankCodeField));
break;
case "BankName":
field = (BankNameField = new StringFieldDefinition <Receipt>(k => k.BankName,
accept: VisitBankNameField));
break;
case "BranchCode":
field = (BranchCodeField = new StringFieldDefinition <Receipt>(k => k.BranchCode,
accept: VisitBranchCodeField));
break;
case "BranchName":
field = (BranchNameField = new StringFieldDefinition <Receipt>(k => k.BranchName,
accept: VisitBranchNameField));
break;
case "AccountNumber":
field = (AccountNumberField = new StringFieldDefinition <Receipt>(k => k.AccountNumber,
accept: VisitAccountNumberField));
break;
case "SourceBankName":
field = (SourceBankNameField = new StringFieldDefinition <Receipt>(k => k.SourceBankName,
accept: VisitSourceBankNameField));
break;
case "SourceBranchName":
field = (SourceBranchNameField = new StringFieldDefinition <Receipt>(k => k.SourceBranchName,
accept: VisitSourceBranchNameField));
break;
case "VirtualBranchCode":
field = (PayerCodePrefixField = new StringFieldDefinition <Receipt>(k => k.PayerCodePrefix,
accept: VisitPayerCodePrefixField));
break;
case "VirtualAccountNumber":
field = (PayerCodeSuffixField = new StringFieldDefinition <Receipt>(k => k.PayerCodeSuffix,
accept: VisitPayerCodeSuffixField));
break;
case "OutputAt":
field = (OutputAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.OutputAt,
accept: VisitOutputAtField,
formatter: value => (value == null) ? "" : value.ToString()));
break;
case "BillNumber":
field = (BillNumberField = new StringFieldDefinition <Receipt>(k => k.BillNumber,
accept: VisitBillNumberField));
break;
case "BillBankCode":
field = (BillBankCodeField = new StringFieldDefinition <Receipt>(k => k.BillBankCode,
accept: VisitBillBankCodeField));
break;
case "BillBranchCode":
field = (BillBranchCodeField = new StringFieldDefinition <Receipt>(k => k.BillBranchCode,
accept: VisitBillBranchCodeField));
break;
case "BillDrawAt":
field = (BillDrawAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.BillDrawAt,
accept: VisitBillDrawAtField,
formatter: value => (value == null) ? "" : value.ToShortDateString()));
break;
case "BillDrawer":
field = (BillDrawerField = new StringFieldDefinition <Receipt>(k => k.BillDrawer,
accept: VisitBillDrawerField));
break;
}
if (field == null)
{
continue;
}
field.FieldName = gs.ColumnNameJp;
field.FieldNumber = fieldNumber;
Fields.Add(field);
}
KeyFields.AddRange(new IFieldDefinition <Receipt>[]
{
CurrencyIdField,
CustomerCodeField,
SectionIdField,
});
}
public PaymentScheduleInputFileDefinition(DataExpression expression, List <GridSetting> GridSettingInfo) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "入金予定入力";
FileNameToken = DataTypeToken;
int fieldNumber = 1;
foreach (GridSetting gs in GridSettingInfo)
{
Func <DateTime, string> dateTimeFormatter = value => value.ToString("yyyy/MM/dd");
fieldNumber++;
IFieldDefinition <Billing> field = null;
switch (gs.ColumnName)
{
case nameof(Billing.BillingId):
field = (IdField = new NumberFieldDefinition <Billing, long>(k => k.Id,
accept: VisitIdField,
formatter: value => value.ToString()));
break;
case nameof(Billing.InvoiceCode):
field = (InvoiceCodeField = new StringFieldDefinition <Billing>(k => k.InvoiceCode,
accept: VisitInvoiceCodeField));
break;
case nameof(Billing.CustomerCode):
field = (CustomerCodeField = new StringFieldDefinition <Billing>(k => k.CustomerCode,
accept: VisitCustomerCodeField));
break;
case nameof(Billing.CustomerName):
field = (CustomerNameField = new StringFieldDefinition <Billing>(k => k.CustomerName,
accept: VisitCustomerNameField));
break;
case nameof(Billing.DepartmentCode):
field = (DepartmentCodeField = new StringFieldDefinition <Billing>(k => k.DepartmentCode,
accept: VisitDepartmentCodeField));
break;
case nameof(Billing.DepartmentName):
field = (DepartmentNameField = new StringFieldDefinition <Billing>(k => k.DepartmentName,
accept: VisitDepartmentNameField));
break;
case nameof(Billing.CurrencyCode):
field = (CurrencyCodeField = new StringFieldDefinition <Billing>(k => k.CurrencyCode,
accept: VisitCurrencyCodeField));
break;
case nameof(Billing.BillingAmount):
field = (BillingAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.BillingAmount,
accept: VisitBillingAmountField,
formatter: value => value.ToString()));
break;
case "DiscountAmountSummary":
field = (DiscountAmountSummaryField = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount,
accept: VisitDiscountAmountSummaryField,
formatter: value => value.ToString()));
break;
case nameof(Billing.RemainAmount):
field = (RemainAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.RemainAmount,
accept: VisitRemainAmountField,
formatter: value => value.ToString()));
break;
case nameof(Billing.PaymentAmount):
field = (PaymentAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.PaymentAmount,
accept: VisitPaymentAmountField,
formatter: value => value.ToString()));
break;
case nameof(Billing.OffsetAmount):
field = (OffsetAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.OffsetAmount,
accept: VisitOffsetAmountField,
formatter: value => value.ToString()));
break;
case nameof(Billing.BilledAt):
field = (BilledAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.BilledAt,
accept: VisitBilledAtField,
formatter: dateTimeFormatter));
break;
case nameof(Billing.BillingDueAt):
field = (BillingDueAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.BillingDueAt,
accept: VisitBillingDueAtField,
formatter: dateTimeFormatter));
break;
case "BillingCategory":
field = (BillingCategoryField = new StringFieldDefinition <Billing>(k => k.BillingCategoryCodeAndName,
accept: VisitBillingCategoryField));
break;
case nameof(Billing.ScheduledPaymentKey):
field = (ScheduledPaymentKeyField = new StringFieldDefinition <Billing>(k => k.ScheduledPaymentKey,
accept: VisitScheduledPaymentKeyField));
break;
case nameof(Billing.SalesAt):
field = (SalesAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.SalesAt,
accept: VisitSalesAtField,
formatter: dateTimeFormatter));
break;
case nameof(Billing.ClosingAt):
field = (ClosingAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.ClosingAt,
accept: VisitClosingAtField,
formatter: dateTimeFormatter));
break;
case "CollectCategory":
field = (CollectCategoryField = new StringFieldDefinition <Billing>(k => k.CollectCategoryCodeAndName,
accept: VisitCollectCategoryField));
break;
case nameof(Billing.Note1):
field = (Note1Field = new StringFieldDefinition <Billing>(k => k.Note1,
accept: VisitNote1Field));
break;
case nameof(Billing.Note2):
field = (Note2Field = new StringFieldDefinition <Billing>(k => k.Note2,
accept: VisitNote2Field));
break;
case nameof(Billing.Note3):
field = (Note3Field = new StringFieldDefinition <Billing>(k => k.Note3,
accept: VisitNote3Field));
break;
case nameof(Billing.Note4):
field = (Note4Field = new StringFieldDefinition <Billing>(k => k.Note4,
accept: VisitNote4Field));
break;
case nameof(Billing.StaffCode):
field = (StaffCodeField = new StringFieldDefinition <Billing>(k => k.StaffCode,
accept: VisitStaffCodeField));
break;
case nameof(Billing.StaffName):
field = (StaffNameField = new StringFieldDefinition <Billing>(k => k.StaffName,
accept: VisitStaffNameField));
break;
case nameof(Billing.InputType):
field = (InputTypeField = new StringFieldDefinition <Billing>(k => k.InputTypeName,
accept: VisitInputTypeField));
break;
case nameof(Billing.Memo):
field = (BillingMemoField = new StringFieldDefinition <Billing>(k => k.Memo,
accept: VisitBillingMemoField));
break;
case nameof(Billing.Note5):
field = (Note5Field = new StringFieldDefinition <Billing>(k => k.Note5,
accept: VisitNote5Field));
break;
case nameof(Billing.Note6):
field = (Note6Field = new StringFieldDefinition <Billing>(k => k.Note6,
accept: VisitNote6Field));
break;
case nameof(Billing.Note7):
field = (Note7Field = new StringFieldDefinition <Billing>(k => k.Note7,
accept: VisitNote7Field));
break;
case nameof(Billing.Note8):
field = (Note8Field = new StringFieldDefinition <Billing>(k => k.Note8,
accept: VisitNote8Field));
break;
default:
break;
}
if (field == null)
{
continue;
}
field.FieldName = gs.ColumnNameJp;
field.FieldNumber = fieldNumber;
Fields.Add(field);
}
}
private IEnumerable <IFieldDefinition <MatchingJournalizing> > InitializeFields()
{
yield return(CompanyCodeField = new StandardIdToCodeFieldDefinition <MatchingJournalizing, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code,
"会社コード", 1, accept: x => x.OwnCompanyCode(CompanyCodeField)));
yield return(RecordedAtField = new NumberFieldDefinition <MatchingJournalizing, DateTime>(k => k.RecordedAt,
"伝票日付", 2, accept: x => x.StandardNumber(RecordedAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
yield return(SlipNumberField = new NumberFieldDefinition <MatchingJournalizing, long>(k => k.SlipNumber,
"伝票番号", 3, accept: x => x.StandardNumber(SlipNumberField), formatter: value => value.ToString()));
yield return(DebitDepartmentCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitDepartmentCode,
"借方部門コード", 4, accept: x => x.StandardString(DebitDepartmentCodeField)));
yield return(DebitDepartmentNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitDepartmentName,
"借方部門名", 5, accept: x => x.StandardString(DebitDepartmentNameField)));
yield return(DebitAccountTitleCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitAccountTitleCode,
"借方科目コード", 6, accept: x => x.StandardString(DebitAccountTitleCodeField)));
yield return(DebitAccountTitleNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitAccountTitleName,
"借方科目名", 7, accept: x => x.StandardString(DebitAccountTitleNameField)));
yield return(DebitSubCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitSubCode,
"借方補助コード", 8, accept: x => x.StandardString(DebitSubCodeField)));
yield return(DebitSubNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.DebitSubName,
"借方補助名", 9, accept: x => x.StandardString(DebitSubNameField)));
yield return(CreditDepartmentCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditDepartmentCode,
"貸方部門コード", 10, accept: x => x.StandardString(CreditDepartmentCodeField)));
yield return(CreditDepartmentNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditDepartmentName,
"貸方部門名", 11, accept: x => x.StandardString(CreditDepartmentNameField)));
yield return(CreditAccountTitleCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditAccountTitleCode,
"貸方科目コード", 12, accept: x => x.StandardString(CreditAccountTitleCodeField)));
yield return(CreditAccountTitleNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditAccountTitleName,
"貸方科目名", 13, accept: x => x.StandardString(CreditAccountTitleNameField)));
yield return(CreditSubCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditSubCode,
"貸方補助コード", 14, accept: x => x.StandardString(CreditSubCodeField)));
yield return(CreditSubNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.CreditSubName,
"貸方補助名", 15, accept: x => x.StandardString(CreditSubNameField)));
yield return(AmountField = new NumberFieldDefinition <MatchingJournalizing, decimal>(k => k.Amount,
"金額", 16, accept: x => x.StandardNumber(AmountField), formatter: value => value.ToString()));
yield return(NoteField = new StringFieldDefinition <MatchingJournalizing>(k => k.Note,
"備考", 17, accept: x => x.StandardString(NoteField)));
yield return(CustomerCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.CustomerCode,
"得意先コード", 18, accept: x => x.StandardString(CustomerCodeField)));
yield return(CustomerNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.CustomerName,
"得意先名", 19, accept: x => x.StandardString(CustomerNameField)));
yield return(InvoiceCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.InvoiceCode,
"請求書番号", 20, accept: x => x.StandardString(InvoiceCodeField)));
yield return(StaffCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.StaffCode,
"担当者コード", 21, accept: x => x.StandardString(StaffCodeField)));
yield return(PayerCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.PayerCode,
"振込依頼人コード", 22, accept: x => x.StandardString(PayerCodeField)));
yield return(PayerNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.PayerName,
"振込依頼人名", 23, accept: x => x.StandardString(PayerNameField)));
yield return(SourceBankNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.SourceBankName,
"仕向銀行", 24, accept: x => x.StandardString(SourceBankNameField)));
yield return(SourceBranchNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.SourceBranchName,
"仕向支店", 25, accept: x => x.StandardString(SourceBranchNameField)));
yield return(DueDateField = new NumberFieldDefinition <MatchingJournalizing, DateTime>(k => k.DueDate,
"期日", 26, accept: x => x.StandardNumber(DueDateField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
yield return(BankCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.BankCode,
"銀行コード", 27, accept: x => x.StandardString(BankCodeField)));
yield return(BankNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.BankName,
"銀行名", 28, accept: x => x.StandardString(BankNameField)));
yield return(BranchCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.BranchCode,
"支店コード", 29, accept: x => x.StandardString(BranchCodeField)));
yield return(BranchNameField = new StringFieldDefinition <MatchingJournalizing>(k => k.BranchName,
"支店名", 30, accept: x => x.StandardString(BranchNameField)));
yield return(AccountTypeIdField = new NullableNumberFieldDefinition <MatchingJournalizing, int>(k => k.AccountTypeId,
"預金種別", 31, accept: x => x.StandardNumber(AccountTypeIdField), formatter: value => value.ToString()));
yield return(AccountNumberField = new StringFieldDefinition <MatchingJournalizing>(k => k.AccountNumber,
"口座番号", 32, accept: x => x.StandardString(AccountNumberField)));
yield return(TaxClassIdField = new NullableNumberFieldDefinition <MatchingJournalizing, int>(k => k.TaxClassId,
"税区分コード", 33, accept: x => x.StandardNumber(TaxClassIdField), formatter: value => value.ToString()));
yield return(CurrencyCodeField = new StringFieldDefinition <MatchingJournalizing>(k => k.CurrencyCode,
"通貨コード", 34, accept: x => x.StandardString(CurrencyCodeField)));
}
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 LoginUserFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "ログインユーザー";
FileNameToken = DataTypeToken + "マスター";
CompanyIdField = new StandardIdToCodeFieldDefinition <LoginUser, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
LoginUserCodeField = new StringFieldDefinition <LoginUser>(k => k.Code)
{
FieldName = "ログインユーザーコード",
FieldNumber = 2,
Required = true,
Accept = VisitLoginUserCode,
};
LoginUserNameField = new StringFieldDefinition <LoginUser>(k => k.Name)
{
FieldName = "ログインユーザー名",
FieldNumber = 3,
Required = true,
Accept = VisitLoginUserName,
};
DepartmentCodeField = new StandardIdToCodeFieldDefinition <LoginUser, Department>(
k => k.DepartmentId, c => c.Id, l => l.DepartmentCode, c => c.Code)
{
FieldName = "請求部門コード",
FieldNumber = 4,
Required = true,
Accept = VisitDepartmentCode,
};
MailField = new StringFieldDefinition <LoginUser>(k => k.Mail)
{
FieldName = "メールアドレス",
FieldNumber = 5,
Accept = VisitMail,
};
MenuLevelField = new NumberFieldDefinition <LoginUser, int>(k => k.MenuLevel)
{
FieldName = "権限レベル",
FieldNumber = 6,
Required = true,
Accept = VisitMenuLevelField,
Format = value => value.ToString(),
};
FunctionLevelField = new NumberFieldDefinition <LoginUser, int>(k => k.FunctionLevel)
{
FieldName = "セキュリティ",
FieldNumber = 7,
Required = true,
Accept = VisitFunctionLevelField,
Format = value => value.ToString(),
};
UseClientField = new NumberFieldDefinition <LoginUser, int>(k => k.UseClient)
{
FieldName = "V-ONE利用",
FieldNumber = 8,
Required = true,
Accept = VisitUseClientField,
Format = value => value.ToString(),
};
UseWebViewerField = new NumberFieldDefinition <LoginUser, int>(k => k.UseWebViewer)
{
FieldName = "WebViewer利用",
FieldNumber = 9,
Required = true,
Accept = VisitUseWebViewerField,
Format = value => value.ToString(),
};
StaffCodeField = new StandardNullableIdToCodeFieldDefinition <LoginUser, Staff>(
k => k.AssignedStaffId, c => c.Id, l => l.StaffCode, c => c.Code)
{
FieldName = "営業担当者コード",
FieldNumber = 10,
Required = false,
Accept = VisitStaffCode,
};
InitialPasswordField = new StringFieldDefinition <LoginUser>(k => k.InitialPassword)
{
FieldName = "初回パスワード",
FieldNumber = 11,
Required = false,
Accept = VisitInitialPassword,
};
Fields.AddRange(new IFieldDefinition <LoginUser>[] {
CompanyIdField, LoginUserCodeField, LoginUserNameField, DepartmentCodeField, MailField,
MenuLevelField, UseClientField, UseWebViewerField, FunctionLevelField, StaffCodeField,
InitialPasswordField
});
KeyFields.AddRange(new IFieldDefinition <LoginUser>[]
{
LoginUserCodeField,
});
}
private IEnumerable <IFieldDefinition <MatchedReceipt> > GetFields(
IEnumerable <ExportFieldSetting> settings,
List <ColumnNameSetting> columnNames)
{
var fieldNumber = 0;
foreach (var setting in settings.Where(x => x.IsStandardField && x.AllowExport == 1))
{
fieldNumber++;
if (setting.ColumnName == "CompanyCode")
{
yield return(CompanyCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.CompanyCode, setting.Caption, fieldNumber, accept: x => x.StandardString(CompanyCodeField)));
}
if (setting.ColumnName == "SlipNumber")
{
yield return(SlipNumberField = new NumberFieldDefinition <MatchedReceipt, long>(
k => k.SlipNumber, setting.Caption, fieldNumber, accept: x => x.StandardNumber(SlipNumberField), formatter: x => x.ToString()));
}
if (setting.ColumnName == "CustomerCode")
{
yield return(CustomerCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.CustomerCode, setting.Caption, fieldNumber, accept: x => x.StandardString(CustomerCodeField)));
}
if (setting.ColumnName == "CustomerName")
{
yield return(CustomerNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.CustomerName, setting.Caption, fieldNumber, accept: x => x.StandardString(CustomerNameField)));
}
if (setting.ColumnName == "InvoiceCode")
{
yield return(InvoiceCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.InvoiceCode, setting.Caption, fieldNumber, accept: x => x.StandardString(InvoiceCodeField)));
}
if (setting.ColumnName == "BilledAt")
{
yield return(BilledAtField = new NumberFieldDefinition <MatchedReceipt, DateTime>(
k => k.BilledAt, setting.Caption, fieldNumber, accept: x => x.StandardNumber(BilledAtField), formatter: x => x.ToString(setting.DateFormat)));
}
if (setting.ColumnName == "ReceiptCategoryCode")
{
yield return(ReceiptCategoryCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptCategoryCode, setting.Caption, fieldNumber, accept: x => x.StandardString(ReceiptCategoryCodeField)));
}
if (setting.ColumnName == "ReceiptCategoryName")
{
yield return(ReceiptCategoryNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptCategoryName, setting.Caption, fieldNumber, accept: x => x.StandardString(ReceiptCategoryNameField)));
}
if (setting.ColumnName == "RecordedAt")
{
yield return(RecordedAtField = new NumberFieldDefinition <MatchedReceipt, DateTime>(
k => k.RecordedAt, setting.Caption, fieldNumber, accept: x => x.StandardNumber(RecordedAtField), formatter: x => x.ToString(setting.DateFormat)));
}
if (setting.ColumnName == "DueAt")
{
yield return(DueAtField = new NullableNumberFieldDefinition <MatchedReceipt, DateTime>(
k => k.DueAt, setting.Caption, fieldNumber, accept: x => x.StandardNumber(DueAtField), formatter: x => x.ToString(setting.DateFormat)));
}
if (setting.ColumnName == "Amount")
{
yield return(AmountField = new NumberFieldDefinition <MatchedReceipt, decimal>(
k => k.Amount, setting.Caption, fieldNumber, accept: x => x.StandardNumber(AmountField), formatter: x => x.ToString()));
}
if (setting.ColumnName == "DepartmentCode")
{
yield return(DepartmentCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.DepartmentCode, setting.Caption, fieldNumber, accept: x => x.StandardString(DepartmentCodeField)));
}
if (setting.ColumnName == "DepartmentName")
{
yield return(DepartmentNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.DepartmentName, setting.Caption, fieldNumber, accept: x => x.StandardString(DepartmentNameField)));
}
if (setting.ColumnName == "CurrencyCode")
{
yield return(CurrencyCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.CurrencyCode, setting.Caption, fieldNumber, accept: x => x.StandardString(CurrencyCodeField)));
}
if (setting.ColumnName == "ReceiptAmount")
{
yield return(ReceiptAmountField = new NumberFieldDefinition <MatchedReceipt, decimal>(
k => k.ReceiptAmount, setting.Caption, fieldNumber, accept: x => x.StandardNumber(ReceiptAmountField), formatter: x => x.ToString()));
}
if (setting.ColumnName == "ReceiptId")
{
yield return(IdField = new NumberFieldDefinition <MatchedReceipt, long>(
k => k.Id, setting.Caption, fieldNumber, accept: x => x.StandardNumber(IdField), formatter: x => x.ToString()));
}
if (setting.ColumnName == "BillingNote1")
{
yield return(BillingNote1Field = new StringFieldDefinition <MatchedReceipt>(
k => k.BillingNote1, GetColumnNames(columnNames, nameof(Billing), "Note1", "備考"), fieldNumber, accept: x => x.StandardString(BillingNote1Field)));
}
if (setting.ColumnName == "BillingNote2")
{
yield return(BillingNote2Field = new StringFieldDefinition <MatchedReceipt>(
k => k.BillingNote2, GetColumnNames(columnNames, nameof(Billing), "Note2", "備考2"), fieldNumber, accept: x => x.StandardString(BillingNote2Field)));
}
if (setting.ColumnName == "BillingNote3")
{
yield return(BillingNote3Field = new StringFieldDefinition <MatchedReceipt>(
k => k.BillingNote3, GetColumnNames(columnNames, nameof(Billing), "Note3", "備考3"), fieldNumber, accept: x => x.StandardString(BillingNote3Field)));
}
if (setting.ColumnName == "BillingNote4")
{
yield return(BillingNote4Field = new StringFieldDefinition <MatchedReceipt>(
k => k.BillingNote4, GetColumnNames(columnNames, nameof(Billing), "Note4", "備考4"), fieldNumber, accept: x => x.StandardString(BillingNote4Field)));
}
if (setting.ColumnName == "ReceiptNote1")
{
yield return(ReceiptNote1Field = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptNote1, GetColumnNames(columnNames, nameof(Receipt), "Note1", "備考"), fieldNumber, accept: x => x.StandardString(ReceiptNote1Field)));
}
if (setting.ColumnName == "ReceiptNote2")
{
yield return(ReceiptNote2Field = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptNote2, GetColumnNames(columnNames, nameof(Receipt), "Note2", "備考2"), fieldNumber, accept: x => x.StandardString(ReceiptNote2Field)));
}
if (setting.ColumnName == "ReceiptNote3")
{
yield return(ReceiptNote3Field = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptNote3, GetColumnNames(columnNames, nameof(Receipt), "Note3", "備考3"), fieldNumber, accept: x => x.StandardString(ReceiptNote3Field)));
}
if (setting.ColumnName == "ReceiptNote4")
{
yield return(ReceiptNote4Field = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptNote4, GetColumnNames(columnNames, nameof(Receipt), "Note4", "備考4"), fieldNumber, accept: x => x.StandardString(ReceiptNote4Field)));
}
if (setting.ColumnName == "BillNumber")
{
yield return(BillNumberField = new StringFieldDefinition <MatchedReceipt>(
k => k.BillNumber, setting.Caption, fieldNumber, accept: x => x.StandardString(BillNumberField)));
}
if (setting.ColumnName == "BillBankCode")
{
yield return(BillBankCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.BillBankCode, setting.Caption, fieldNumber, accept: x => x.StandardString(BillBankCodeField)));
}
if (setting.ColumnName == "BillBranchCode")
{
yield return(BillBranchCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.BillBranchCode, setting.Caption, fieldNumber, accept: x => x.StandardString(BillBranchCodeField)));
}
if (setting.ColumnName == "BillDrawAt")
{
yield return(BillDrawAtField = new NullableNumberFieldDefinition <MatchedReceipt, DateTime>(
k => k.BillDrawAt, setting.Caption, fieldNumber, accept: x => x.StandardNumber(BillDrawAtField), formatter: x => x.ToString(setting.DateFormat)));
}
if (setting.ColumnName == "BillDrawer")
{
yield return(BillDrawerField = new StringFieldDefinition <MatchedReceipt>(
k => k.BillDrawer, setting.Caption, fieldNumber, accept: x => x.StandardString(BillDrawerField)));
}
if (setting.ColumnName == "BillingMemo")
{
yield return(BillingMemoField = new StringFieldDefinition <MatchedReceipt>(
k => k.BillingMemo, setting.Caption, fieldNumber, accept: x => x.StandardString(BillingMemoField)));
}
if (setting.ColumnName == "ReceiptMemo")
{
yield return(ReceiptMemoField = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptMemo, setting.Caption, fieldNumber, accept: x => x.StandardString(ReceiptMemoField)));
}
if (setting.ColumnName == "MatchingMemo")
{
yield return(MatchingMemoField = new StringFieldDefinition <MatchedReceipt>(
k => k.MatchingMemo, setting.Caption, fieldNumber, accept: x => x.StandardString(MatchingMemoField)));
}
if (setting.ColumnName == "BankCode")
{
yield return(BankCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.BankCode, setting.Caption, fieldNumber, accept: x => x.StandardString(BankCodeField)));
}
if (setting.ColumnName == "BankName")
{
yield return(BankNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.BankName, setting.Caption, fieldNumber, accept: x => x.StandardString(BankNameField)));
}
if (setting.ColumnName == "BranchCode")
{
yield return(BranchCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.BranchCode, setting.Caption, fieldNumber, accept: x => x.StandardString(BranchCodeField)));
}
if (setting.ColumnName == "BranchName")
{
yield return(BranchNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.BranchName, setting.Caption, fieldNumber, accept: x => x.StandardString(BranchNameField)));
}
if (setting.ColumnName == "AccountNumber")
{
yield return(AccountNumberField = new StringFieldDefinition <MatchedReceipt>(
k => k.AccountNumber, setting.Caption, fieldNumber, accept: x => x.StandardString(AccountNumberField)));
}
if (setting.ColumnName == "SourceBankName")
{
yield return(SourceBankNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.SourceBankName, setting.Caption, fieldNumber, accept: x => x.StandardString(SourceBankNameField)));
}
if (setting.ColumnName == "SourceBranchName")
{
yield return(SourceBranchNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.SourceBranchName, setting.Caption, fieldNumber, accept: x => x.StandardString(SourceBranchNameField)));
}
if (setting.ColumnName == "VirtualBranchCode")
{
yield return(VirtualBranchCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.VirtualBranchCode, setting.Caption, fieldNumber, accept: x => x.StandardString(VirtualBranchCodeField)));
}
if (setting.ColumnName == "VirtualAccountNumber")
{
yield return(VirtualAccountNumberField = new StringFieldDefinition <MatchedReceipt>(
k => k.VirtualAccountNumber, setting.Caption, fieldNumber, accept: x => x.StandardString(VirtualAccountNumberField)));
}
if (setting.ColumnName == "SectionCode")
{
yield return(SectionCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.SectionCode, setting.Caption, fieldNumber, accept: x => x.StandardString(SectionCodeField)));
}
if (setting.ColumnName == "SectionName")
{
yield return(SectionNameField = new StringFieldDefinition <MatchedReceipt>(
k => k.SectionName, setting.Caption, fieldNumber, accept: x => x.StandardString(SectionNameField)));
}
if (setting.ColumnName == "ReceiptCategoryExternalCode")
{
yield return(ReceiptCategoryExternalCodeField = new StringFieldDefinition <MatchedReceipt>(
k => k.ReceiptCategoryExternalCode, setting.Caption, fieldNumber, accept: x => x.StandardString(ReceiptCategoryExternalCodeField)));
}
if (setting.ColumnName == "OriginalReceiptId")
{
yield return(OriginalReceiptIdField = new NumberFieldDefinition <MatchedReceipt, long>(
k => k.OriginalReceiptId, setting.Caption, fieldNumber, accept: x => x.StandardNumber(OriginalReceiptIdField), formatter: x => x.ToString()));
}
if (setting.ColumnName == "JournalizingCategory")
{
yield return(JournalizingCategoryField = new StringFieldDefinition <MatchedReceipt>(
k => k.JournalizingCategory, setting.Caption, fieldNumber, accept: x => x.StandardString(JournalizingCategoryField)));
}
}
}
public BillingSearchFileDefinition(DataExpression expression, List <GridSetting> GridSettingInfo) : base(expression)
{
Func <DateTime, string> dateTimeFormatter = value => value.ToString("yyyy/MM/dd");
StartLineNumber = 1;
DataTypeToken = "請求データ";
FileNameToken = DataTypeToken;
Fields.Add(DeleteAtField = new NullableNumberFieldDefinition <Billing, DateTime>(k => k.DeleteAt,
fieldName: "削除日", fieldNumber: 1,
accept: VisitDeleteAtField,
formatter: dateTimeFormatter));
int fieldNumber = 1;
foreach (GridSetting gs in GridSettingInfo)
{
fieldNumber++;
IFieldDefinition <Billing> field = null;
switch (gs.ColumnName)
{
case "Id":
field = (IdField = new NumberFieldDefinition <Billing, long>(k => k.Id,
accept: VisitIdField,
formatter: value => value.ToString()));
break;
case "InvoiceCode":
field = (InvoiceCodeField = new StringFieldDefinition <Billing>(k => k.InvoiceCode,
accept: VisitInvoiceCodeField));
break;
case "BillingCategory":
field = (BillingCategoryField = new StringFieldDefinition <Billing>(k => k.BillingCategoryCodeAndName,
accept: VisitBillingCategoryField));
break;
case "CollectCategory":
field = (CollectCategoryField = new StringFieldDefinition <Billing>(k => k.CollectCategoryCodeAndName,
accept: VisitCollectCategoryField));
break;
case "InputType":
field = (InputTypeField = new StringFieldDefinition <Billing>(k => k.InputTypeName,
accept: VisitInputTypeField));
break;
case "Note1":
field = (Note1Field = new StringFieldDefinition <Billing>(k => k.Note1, accept: VisitNote1Field));
break;
case "Note2":
field = (Note2Field = new StringFieldDefinition <Billing>(k => k.Note2, accept: VisitNote2Field));
break;
case "Note3":
field = (Note3Field = new StringFieldDefinition <Billing>(k => k.Note3, accept: VisitNote3Field));
break;
case "Note4":
field = (Note4Field = new StringFieldDefinition <Billing>(k => k.Note4, accept: VisitNote4Field));
break;
case "Note5":
field = (Note5Field = new StringFieldDefinition <Billing>(k => k.Note5, accept: x => x.StandardString(Note5Field)));
break;
case "Note6":
field = (Note6Field = new StringFieldDefinition <Billing>(k => k.Note6, accept: x => x.StandardString(Note6Field)));
break;
case "Note7":
field = (Note7Field = new StringFieldDefinition <Billing>(k => k.Note7, accept: x => x.StandardString(Note7Field)));
break;
case "Note8":
field = (Note8Field = new StringFieldDefinition <Billing>(k => k.Note8, accept: x => x.StandardString(Note8Field)));
break;
case "Memo":
field = (BillingMemoField = new StringFieldDefinition <Billing>(k => k.Memo,
accept: VisitBillingMemoField));
break;
case "CustomerCode":
field = (CustomerCodeField = new StringFieldDefinition <Billing>(k => k.CustomerCode,
accept: VisitCustomerCodeField));
break;
case "StaffCode":
field = (StaffCodeField = new StringFieldDefinition <Billing>(k => k.StaffCode,
accept: VisitStaffCodeField));
break;
case "ResultCode":
field = (ResultCodeField = new StringFieldDefinition <Billing>(k => k.ResultCodeName,
accept: VisitResultCodeField));
break;
case "ContractNumber":
field = (ContractNumberField = new StringFieldDefinition <Billing>(k => k.ContractNumber,
accept: VisitContractNumberField));
break;
case "Confirm":
field = (ConfirmField = new StringFieldDefinition <Billing>(k => k.ConfirmName,
accept: VisitConfirmField));
break;
case "CurrencyCode":
field = (CurrencyCodeField = new StringFieldDefinition <Billing>(k => k.CurrencyCode,
accept: VisitCurrencyCodeField));
break;
case "CustomerName":
field = (CustomerNameField = new StringFieldDefinition <Billing>(k => k.CustomerName,
accept: VisitCustomerNameField));
break;
case "StaffName":
field = (StaffNameField = new StringFieldDefinition <Billing>(k => k.StaffName,
accept: VisitStaffNameField));
break;
case "AssignmentState":
field = (AssignmentFlagField = new StringFieldDefinition <Billing>(k => k.AssignmentFlagName,
accept: VisitAssignmentFlagField));
break;
case "BilledAt":
field = (BilledAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.BilledAt,
accept: VisitBilledAtField,
formatter: dateTimeFormatter));
break;
case "SalesAt":
field = (SalesAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.SalesAt,
accept: VisitSalesAtField,
formatter: dateTimeFormatter));
break;
case "ClosingAt":
field = (ClosingAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.ClosingAt,
accept: VisitClosingAtField,
formatter: dateTimeFormatter));
break;
case "DueAt":
field = (DueAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.DueAt,
accept: VisitDueAtField,
formatter: dateTimeFormatter));
break;
case "RequestDate":
field = (RequestDateField = new NullableNumberFieldDefinition <Billing, DateTime>(k => k.RequestDate,
accept: VisitRequestField,
formatter: dateTimeFormatter));
break;
case "BillingAmount":
field = (BillingAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.BillingAmount,
accept: VisitBillingAmountField,
formatter: value => value.ToString()));
break;
case "RemainAmount":
field = (RemainAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.RemainAmount,
accept: VisitRemainAmountField,
formatter: value => value.ToString()));
break;
case "DiscountAmount1":
field = (DiscountAmount1Field = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount1,
accept: VisitDiscountAmount1Field,
formatter: value => value.ToString()));
break;
case "DiscountAmount2":
field = (DiscountAmount2Field = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount2,
accept: VisitDiscountAmount2Field,
formatter: value => value.ToString()));
break;
case "DiscountAmount3":
field = (DiscountAmount3Field = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount3,
accept: VisitDiscountAmount3Field,
formatter: value => value.ToString()));
break;
case "DiscountAmount4":
field = (DiscountAmount4Field = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount4,
accept: VisitDiscountAmount4Field,
formatter: value => value.ToString()));
break;
case "DiscountAmount5":
field = (DiscountAmount5Field = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount5,
accept: VisitDiscountAmount5Field,
formatter: value => value.ToString()));
break;
case "DepartmentCode":
field = (DepartmentCodeField = new StringFieldDefinition <Billing>(k => k.DepartmentCode,
accept: VisitDepartmentCodeField));
break;
case "DepartmentName":
field = (DepartmentNameField = new StringFieldDefinition <Billing>(k => k.DepartmentName,
accept: VisitDepartmentNameField));
break;
case "DiscountAmountSummary":
field = (DiscountAmountTotalField = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount,
accept: VisitDiscountAmountTotalField,
formatter: value => value.ToString()));
break;
case "FirstRecordedAt":
field = (FirstRecordedAtField = new NullableNumberFieldDefinition <Billing, DateTime>(k => k.FirstRecordedAt,
accept: VisitFirstRecordedAtField,
formatter: dateTimeFormatter));
break;
case "LastRecordedAt":
field = (LastRecordedAtField = new NullableNumberFieldDefinition <Billing, DateTime>(k => k.LastRecordedAt,
accept: VisitLastRecordedAtField,
formatter: dateTimeFormatter));
break;
case "Price":
field = (PriceField = new NumberFieldDefinition <Billing, decimal>(k => k.BillingAmountExcludingTax,
accept: VisitPriceField,
formatter: value => value.ToString()));
break;
case "TaxAmount":
field = (TaxAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.TaxAmount,
accept: VisitTaxAmountField,
formatter: value => value.ToString()));
break;
default:
break;
}
if (field == null)
{
continue;
}
field.FieldName = gs.ColumnNameJp;
field.FieldNumber = fieldNumber;
Fields.Add(field);
}
}
private IEnumerable <IFieldDefinition <BillingInvoice> > InitializeFields(List <GridSetting> GridSettingInfo)
{
var index = 0;
foreach (var setting in GridSettingInfo.Where(x => x.DisplayWidth > 0))
{
index++;
if (setting.ColumnName == nameof(BillingInvoice.Checked))
{
yield return(CheckedField = new NumberFieldDefinition <BillingInvoice, int>(k => k.Checked,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(CheckedField), formatter: value => value.ToString()));
}
if (setting.ColumnName == nameof(BillingInvoice.InvoiceTemplateCode))
{
yield return(InvoiceTemplateCodeField = new StringFieldDefinition <BillingInvoice>(k => k.InvoiceTemplateCode,
setting.ColumnNameJp, index, accept: x => x.StandardString(InvoiceTemplateCodeField)));
}
if (setting.ColumnName == nameof(BillingInvoice.InvoiceCode))
{
yield return(InvoiceCodeField = new StringFieldDefinition <BillingInvoice>(k => k.InvoiceCode,
setting.ColumnNameJp, index, accept: x => x.StandardString(InvoiceCodeField)));
}
if (setting.ColumnName == nameof(BillingInvoice.DetailsCount))
{
yield return(DetailsCountField = new NumberFieldDefinition <BillingInvoice, int>(k => k.DetailsCount,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(DetailsCountField), formatter: value => value.ToString()));
}
if (setting.ColumnName == nameof(BillingInvoice.CustomerCode))
{
yield return(CustomerCodeField = new StringFieldDefinition <BillingInvoice>(k => k.CustomerCode,
setting.ColumnNameJp, index, accept: x => x.StandardString(CustomerCodeField)));
}
if (setting.ColumnName == nameof(BillingInvoice.CustomerName))
{
yield return(CustomerNameField = new StringFieldDefinition <BillingInvoice>(k => k.CustomerName,
setting.ColumnNameJp, index, accept: x => x.StandardString(CustomerNameField)));
}
if (setting.ColumnName == nameof(BillingInvoice.AmountSum))
{
yield return(AmountSumField = new NumberFieldDefinition <BillingInvoice, decimal>(k => k.AmountSum,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(AmountSumField), formatter: value => value.ToString()));
}
if (setting.ColumnName == nameof(BillingInvoice.RemainAmountSum))
{
yield return(RemainAmountSumField = new NumberFieldDefinition <BillingInvoice, decimal>(k => k.RemainAmountSum,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(RemainAmountSumField), formatter: value => value.ToString()));
}
if (setting.ColumnName == nameof(BillingInvoice.CollectCategoryCodeAndNeme))
{
yield return(CollectCategoryCodeAndNemeField = new StringFieldDefinition <BillingInvoice>(k => k.CollectCategoryCodeAndNeme,
setting.ColumnNameJp, index, accept: x => x.StandardString(CollectCategoryCodeAndNemeField)));
}
if (setting.ColumnName == nameof(BillingInvoice.ClosingAt))
{
yield return(ClosingAtField = new NumberFieldDefinition <BillingInvoice, DateTime>(k => k.ClosingAt,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(ClosingAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
}
if (setting.ColumnName == nameof(BillingInvoice.BilledAt))
{
yield return(BilledAtField = new NumberFieldDefinition <BillingInvoice, DateTime>(k => k.BilledAt,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(BilledAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
}
if (setting.ColumnName == nameof(BillingInvoice.DepartmentCode))
{
yield return(DepartmentCodeField = new StringFieldDefinition <BillingInvoice>(k => k.DepartmentCode,
setting.ColumnNameJp, index, accept: x => x.StandardString(DepartmentCodeField)));
}
if (setting.ColumnName == nameof(BillingInvoice.DepartmentName))
{
yield return(DepartmentNameField = new StringFieldDefinition <BillingInvoice>(k => k.DepartmentName,
setting.ColumnNameJp, index, accept: x => x.StandardString(DepartmentNameField)));
}
if (setting.ColumnName == nameof(BillingInvoice.StaffCode))
{
yield return(StaffCodeField = new StringFieldDefinition <BillingInvoice>(k => k.StaffCode,
setting.ColumnNameJp, index, accept: x => x.StandardString(StaffCodeField)));
}
if (setting.ColumnName == nameof(BillingInvoice.StaffName))
{
yield return(StaffNameField = new StringFieldDefinition <BillingInvoice>(k => k.StaffName,
setting.ColumnNameJp, index, accept: x => x.StandardString(StaffNameField)));
}
if (setting.ColumnName == nameof(BillingInvoice.DestnationCode))
{
yield return(DestnationCodeField = new StringFieldDefinition <BillingInvoice>(k => k.DestnationCode,
setting.ColumnNameJp, index, accept: x => x.StandardString(DestnationCodeField)));
}
if (setting.ColumnName == nameof(BillingInvoice.PublishAt))
{
yield return(PublishAtField = new NumberFieldDefinition <BillingInvoice, DateTime>(k => k.PublishAt,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(PublishAtField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
}
if (setting.ColumnName == nameof(BillingInvoice.PublishAt1st))
{
yield return(PublishAt1stField = new NumberFieldDefinition <BillingInvoice, DateTime>(k => k.PublishAt1st,
setting.ColumnNameJp, index, accept: x => x.StandardNumber(PublishAt1stField), formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
}
}
}