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())); }
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)); }
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, }); }
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 <ExportMatchingIndividual> > GetFields() { var fieldNumber = 0; yield return(CurrencyCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.CurrencyCode, fieldNumber: ++fieldNumber, fieldName: "通貨コード", accept: visitor => visitor.StandardString(CurrencyCodeField))); yield return(BillCheckField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BillCheck, fieldNumber: ++fieldNumber, fieldName: "消", accept: visitor => visitor.StandardString(BillCheckField))); yield return(CustomerCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.CustomerCode, fieldNumber: ++fieldNumber, fieldName: "得意先コード", accept: visitor => visitor.StandardString(CustomerCodeField))); yield return(CustomerNameField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.CustomerName, fieldNumber: ++fieldNumber, fieldName: "得意先名", accept: visitor => visitor.StandardString(CustomerNameField))); yield return(BilledAtField = new NullableNumberFieldDefinition <ExportMatchingIndividual, DateTime>(k => k.BilledAt, fieldNumber: ++fieldNumber, fieldName: "請求日", accept: visitor => visitor.StandardNumber(BilledAtField), formatter: value => value.ToShortDateString())); yield return(SalesAtField = new NullableNumberFieldDefinition <ExportMatchingIndividual, DateTime>(k => k.SalesAt, fieldNumber: ++fieldNumber, fieldName: "売上日", accept: visitor => visitor.StandardNumber(SalesAtField), formatter: value => value.ToShortDateString())); yield return(DueAtField = new NullableNumberFieldDefinition <ExportMatchingIndividual, DateTime>(k => k.DueAt, fieldNumber: ++fieldNumber, fieldName: "予定日", accept: visitor => visitor.StandardNumber(DueAtField), formatter: value => value.ToShortDateString())); yield return(BillingAmountField = new NullableNumberFieldDefinition <ExportMatchingIndividual, decimal>(k => k.BillingAmount, fieldNumber: ++fieldNumber, fieldName: "請求額", accept: visitor => visitor.StandardNumber(BillingAmountField), formatter: value => value.ToString())); yield return(RemainAmountField = new NullableNumberFieldDefinition <ExportMatchingIndividual, decimal>(k => k.RemainAmount, fieldNumber: ++fieldNumber, fieldName: "請求残", accept: visitor => visitor.StandardNumber(RemainAmountField), formatter: value => value.ToString())); yield return(DiscountAmountField = new NullableNumberFieldDefinition <ExportMatchingIndividual, decimal>(k => k.DiscountAmount, fieldNumber: ++fieldNumber, fieldName: "歩引額", accept: visitor => visitor.StandardNumber(DiscountAmountField), formatter: value => value.ToString())); yield return(TargetAmountField = new NullableNumberFieldDefinition <ExportMatchingIndividual, decimal>(k => k.TargetAmount, fieldNumber: ++fieldNumber, fieldName: "消込対象額", accept: visitor => visitor.StandardNumber(TargetAmountField), formatter: value => value.ToString())); yield return(InvoiceCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.InvoiceCode, fieldNumber: ++fieldNumber, fieldName: "請求番号", accept: visitor => visitor.StandardString(InvoiceCodeField))); yield return(BillingCategoryField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BillingCategoryCodeAndName, fieldNumber: ++fieldNumber, fieldName: "請求区分", accept: visitor => visitor.StandardString(BillingCategoryField))); yield return(BillingDepartmentField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.DepartmentName, fieldNumber: ++fieldNumber, fieldName: "請求部門名", accept: visitor => visitor.StandardString(BillingDepartmentField))); yield return(BillingNote1Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note1, fieldNumber: ++fieldNumber, fieldName: "備考", accept: visitor => visitor.StandardString(BillingNote1Field))); yield return(BillingNote2Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note2, fieldNumber: ++fieldNumber, fieldName: "備考2", accept: visitor => visitor.StandardString(BillingNote2Field))); yield return(BillingNote3Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note3, fieldNumber: ++fieldNumber, fieldName: "備考3", accept: visitor => visitor.StandardString(BillingNote3Field))); yield return(BillingNote4Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note4, fieldNumber: ++fieldNumber, fieldName: "備考4", accept: visitor => visitor.StandardString(BillingNote4Field))); yield return(BillingNote5Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note5, fieldNumber: ++fieldNumber, fieldName: "備考5", accept: visitor => visitor.StandardString(BillingNote5Field))); yield return(BillingNote6Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note6, fieldNumber: ++fieldNumber, fieldName: "備考6", accept: visitor => visitor.StandardString(BillingNote6Field))); yield return(BillingNote7Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note7, fieldNumber: ++fieldNumber, fieldName: "備考7", accept: visitor => visitor.StandardString(BillingNote7Field))); yield return(BillingNote8Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Note8, fieldNumber: ++fieldNumber, fieldName: "備考8", accept: visitor => visitor.StandardString(BillingNote8Field))); yield return(BillingMemoField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.Memo, fieldNumber: ++fieldNumber, fieldName: "請求メモ", accept: visitor => visitor.StandardString(BillingMemoField))); yield return(BillingInputTypeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.InputTypeName, fieldNumber: ++fieldNumber, fieldName: "データ区分", accept: visitor => visitor.StandardString(BillingInputTypeField))); yield return(ScheduledPaymentKeyField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ScheduledPaymentKey, fieldNumber: ++fieldNumber, fieldName: "入金予定キー", accept: visitor => visitor.StandardString(ScheduledPaymentKeyField))); yield return(RecCheckField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.RecCheck, fieldNumber: ++fieldNumber, fieldName: "消", accept: visitor => visitor.StandardString(RecCheckField))); yield return(ReceiptPayerNameField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.PayerName, fieldNumber: ++fieldNumber, fieldName: "振込依頼人名", accept: visitor => visitor.StandardString(ReceiptPayerNameField))); yield return(ReceiptRecordAtField = new NullableNumberFieldDefinition <ExportMatchingIndividual, DateTime>(k => k.RecordedAt, fieldNumber: ++fieldNumber, fieldName: "入金日", accept: visitor => visitor.StandardNumber(ReceiptRecordAtField), formatter: value => value.ToShortDateString())); yield return(ReceiptCategoryField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.CategoryName, fieldNumber: ++fieldNumber, fieldName: "区分", accept: visitor => visitor.StandardString(ReceiptCategoryField))); yield return(ReceiptAmountField = new NullableNumberFieldDefinition <ExportMatchingIndividual, decimal>(k => k.ReceiptAmount, fieldNumber: ++fieldNumber, fieldName: "入金額", accept: visitor => visitor.StandardNumber(ReceiptAmountField), formatter: value => value.ToString())); yield return(ReceiptRemainAmountField = new NullableNumberFieldDefinition <ExportMatchingIndividual, decimal>(k => k.ReceiptRemainAmount, fieldNumber: ++fieldNumber, fieldName: "入金残", accept: visitor => visitor.StandardNumber(ReceiptRemainAmountField), formatter: value => value.ToString())); yield return(NettingStateField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.NettingState, fieldNumber: ++fieldNumber, fieldName: "相殺", accept: visitor => visitor.StandardString(NettingStateField))); yield return(SourceBankInfoField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.SourceBank, fieldNumber: ++fieldNumber, fieldName: "仕向", accept: visitor => visitor.StandardString(SourceBankInfoField))); yield return(BankCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BankCode, fieldNumber: ++fieldNumber, fieldName: "銀行コード", accept: visitor => visitor.StandardString(BankCodeField))); yield return(BankNameField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BankName, fieldNumber: ++fieldNumber, fieldName: "銀行名", accept: visitor => visitor.StandardString(BankNameField))); yield return(BranchCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BranchCode, fieldNumber: ++fieldNumber, fieldName: "支店コード", accept: visitor => visitor.StandardString(BranchCodeField))); yield return(BranchNameField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BranchName, fieldNumber: ++fieldNumber, fieldName: "支店名", accept: visitor => visitor.StandardString(BranchNameField))); yield return(AccountTypeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.AccountTypeName, fieldNumber: ++fieldNumber, fieldName: "種別", accept: visitor => visitor.StandardString(AccountTypeField))); yield return(AccountNumberField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.AccountNumber, fieldNumber: ++fieldNumber, fieldName: "口座", accept: visitor => visitor.StandardString(AccountNumberField))); yield return(SectionCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.SectionCode, fieldNumber: ++fieldNumber, fieldName: "入金部門コード", accept: visitor => visitor.StandardString(SectionCodeField))); yield return(SectionNameField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.SectionName, fieldNumber: ++fieldNumber, fieldName: "入金部門名", accept: visitor => visitor.StandardString(SectionNameField))); yield return(ReceiptMemoField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ReceiptMemo, fieldNumber: ++fieldNumber, fieldName: "入金メモ", accept: visitor => visitor.StandardString(ReceiptMemoField))); yield return(ReceiptDueDateField = new NullableNumberFieldDefinition <ExportMatchingIndividual, DateTime>(k => k.ReceiptDueAt, fieldNumber: ++fieldNumber, fieldName: "期日", accept: visitor => visitor.StandardNumber(ReceiptDueDateField), formatter: value => value.ToShortDateString())); yield return(ReceiptExcludeCategoryField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ExcludeCategoryName, fieldNumber: ++fieldNumber, fieldName: "対象外理由", accept: visitor => visitor.StandardString(ReceiptExcludeCategoryField))); yield return(PayerCodePrefixField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.PayerCodePrefix, fieldNumber: ++fieldNumber, fieldName: "仮想支店コード", accept: visitor => visitor.StandardString(PayerCodePrefixField))); yield return(PayerCodeSuffixField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.PayerCodeSuffix, fieldNumber: ++fieldNumber, fieldName: "仮想口座番号", accept: visitor => visitor.StandardString(PayerCodeSuffixField))); yield return(ReceiptCustomerCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ReceiptCustomerCode, fieldNumber: ++fieldNumber, fieldName: "得意先コード", accept: visitor => visitor.StandardString(ReceiptCustomerCodeField))); yield return(ReceiptCustomerNameField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ReceiptCustomerName, fieldNumber: ++fieldNumber, fieldName: "得意先名", accept: visitor => visitor.StandardString(ReceiptCustomerNameField))); yield return(ReceiptNote1Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ReceiptNote1, fieldNumber: ++fieldNumber, fieldName: "備考", accept: visitor => visitor.StandardString(ReceiptNote1Field))); yield return(ReceiptNote2Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ReceiptNote2, fieldNumber: ++fieldNumber, fieldName: "備考2", accept: visitor => visitor.StandardString(ReceiptNote2Field))); yield return(ReceiptNote3Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ReceiptNote3, fieldNumber: ++fieldNumber, fieldName: "備考3", accept: visitor => visitor.StandardString(ReceiptNote3Field))); yield return(ReceiptNote4Field = new StringFieldDefinition <ExportMatchingIndividual>(k => k.ReceiptNote4, fieldNumber: ++fieldNumber, fieldName: "備考4", accept: visitor => visitor.StandardString(ReceiptNote4Field))); yield return(BillNumberField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BillNumber, fieldNumber: ++fieldNumber, fieldName: "手形番号", accept: visitor => visitor.StandardString(BillNumberField))); yield return(BillBankCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BillBankCode, fieldNumber: ++fieldNumber, fieldName: "券面銀行コード", accept: visitor => visitor.StandardString(BillBankCodeField))); yield return(BillBranchCodeField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BillBranchCode, fieldNumber: ++fieldNumber, fieldName: "券面支店コード", accept: visitor => visitor.StandardString(BillBranchCodeField))); yield return(BillDrawAtField = new NullableNumberFieldDefinition <ExportMatchingIndividual, DateTime>(k => k.BillDrawAt, fieldNumber: ++fieldNumber, fieldName: "振出日", accept: visitor => visitor.StandardNumber(BillDrawAtField), formatter: value => value.ToShortDateString())); yield return(BillDrawerField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.BillDrawer, fieldNumber: ++fieldNumber, fieldName: "振出人", accept: visitor => visitor.StandardString(BillDrawerField))); yield return(ReceiptPayerNameRawField = new StringFieldDefinition <ExportMatchingIndividual>(k => k.PayerNameRaw, fieldNumber: ++fieldNumber, fieldName: "振込依頼人名(全て)", accept: visitor => visitor.StandardString(ReceiptPayerNameRawField))); }
public CustomerRegistrationFeeFileDefinition(DataExpression applicationControl) : base(applicationControl) { StartLineNumber = 1; DataTypeToken = "得意先"; FileNameToken = DataTypeToken + "マスター登録手数料"; // FieldNumber 1 会社コード CompanyIdField = new StandardIdToCodeFieldDefinition <CustomerFee, Company>( cd => cd.CompanyId, c => c.Id, null, c => c.Code) { FieldName = "会社コード", FieldNumber = 1, Required = false, Accept = VisitCompanyId, }; // FieldNumber 2 得意先コード CustomerIdField = new StandardIdToCodeFieldDefinition <CustomerFee, Customer>( cd => cd.CustomerId, c => c.Id, l => l.CustomerCode, c => c.Code) { FieldName = "得意先コード", FieldNumber = 2, Required = true, Accept = VisitCustomerId, }; // FieldNumber 3 登録手数料 FeeField = new NullableNumberFieldDefinition <CustomerFee, decimal>(cd => cd.Fee) { FieldName = "登録手数料", FieldNumber = 3, Required = true, Accept = VisitFee, Format = value => value.ToString(), }; // FieldNumber 4 通貨コード CurrencyCodeField = new StandardIdToCodeFieldDefinition <CustomerFee, Currency>( cd => cd.CurrencyId, c => c.Id, l => l.CurrencyCode, c => c.Code) { FieldName = "通貨コード", FieldNumber = 4, Required = true, Accept = VisitCurrencyCode, }; Fields.AddRange(new IFieldDefinition <CustomerFee>[] { CompanyIdField , CustomerIdField , FeeField , CurrencyCodeField }); if (applicationControl.UseForeignCurrency == 1) { KeyFields.AddRange(new IFieldDefinition <CustomerFee>[] { CustomerIdField, CurrencyCodeField, FeeField, }); } else { KeyFields.AddRange(new IFieldDefinition <CustomerFee>[] { CustomerIdField, FeeField, }); } foreignflg = applicationControl.UseForeignCurrency; }
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, }); }
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 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 }); }
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 }); }
} //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 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}); }
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 NumberFieldDefinition<CustomerLedger, int> RecordTypeField { get; private set; } public CustomerLedgerFileDefinition(DataExpression expression) : base(expression) { StartLineNumber = 1; DataTypeToken = "得意先別消込台帳"; FileNameToken = DataTypeToken; RecordedAtField = new StringFieldDefinition <CustomerLedger>( k => k.RecordTypeName) { FieldName = "日付", FieldNumber = 1, Required = true, Accept = VisitRecordedAtField, }; ParentCustomerCodeField = new StringFieldDefinition <CustomerLedger>( k => k.ParentCustomerCode) { FieldName = "代表得意先コード", FieldNumber = 2, Required = false, Accept = VisitParentCustomerCodeField, }; ParentCustomerNameField = new StringFieldDefinition <CustomerLedger>( k => k.ParentCustomerName) { FieldName = "代表得意先名", FieldNumber = 3, Required = true, Accept = VisitParentCustomerNameField, }; CurrencyCodeField = new StringFieldDefinition <CustomerLedger>( k => k.CurrencyCode) { FieldName = "通貨コード", FieldNumber = 9, Required = true, Accept = VisitCurrencyCodeField, }; SectionNameField = new StringFieldDefinition <CustomerLedger>( k => k.SectionName) { FieldName = "入金部門", FieldNumber = 4, Required = true, Accept = VisitSectionNameField, }; DepartmentNameField = new StringFieldDefinition <CustomerLedger>( k => k.DepartmentName) { FieldName = "請求部門", FieldNumber = 5, Required = true, Accept = VisitDepartmentNameField, }; InvoiceCodeField = new StringFieldDefinition <CustomerLedger>( k => k.InvoiceCode) { FieldName = "請求書番号", FieldNumber = 6, Required = true, Accept = VisitInvoiceCodeField, }; CategoryNameField = new StringFieldDefinition <CustomerLedger>( k => k.CategoryName) { FieldName = "区分", FieldNumber = 7, Required = true, Accept = VisitCategoryNameField, }; DebitAccountTitleNameField = new StringFieldDefinition <CustomerLedger>( k => k.AccountTitleName) { FieldName = "債権科目", FieldNumber = 8, Required = true, Accept = VisitDebitAccountTitleNameField, }; MatchingSymbolBillingField = new StringFieldDefinition <CustomerLedger>( k => k.MatchingSymbolBilling) { FieldName = "消込記号_請求", FieldNumber = 10, Required = false, Accept = VisitMatchingSymbolBillingField, }; BillingAmountField = new NullableNumberFieldDefinition <CustomerLedger, decimal>( k => k.BillingAmount) { FieldName = "請求額", FieldNumber = 11, Required = true, Accept = VisitBillingAmountField, Format = value => value.ToString(), }; SlipTotalField = new NullableNumberFieldDefinition <CustomerLedger, decimal>( k => k.SlipTotal) { FieldName = "伝票合計", FieldNumber = 12, Required = true, Accept = VisitSlipTotalField, Format = value => value.ToString(), }; ReceiptAmountField = new NullableNumberFieldDefinition <CustomerLedger, decimal>( k => k.ReceiptAmount) { FieldName = "入金額", FieldNumber = 13, Required = true, Accept = VisitReceiptAmountField, Format = value => value.ToString(), }; MatchingSymbolReceiptField = new StringFieldDefinition <CustomerLedger>( k => k.MatchingSymbolReceipt) { FieldName = "消込記号_消込", FieldNumber = 14, Required = false, Accept = VisitMatchingSymbolReceiptField, }; MatchingAmountField = new NullableNumberFieldDefinition <CustomerLedger, decimal>( k => k.MatchingAmount) { FieldName = "消込額", FieldNumber = 15, Required = true, Accept = VisitMatchingAmountField, Format = value => value.ToString(), }; RemainAmountField = new NullableNumberFieldDefinition <CustomerLedger, decimal>( k => k.RemainAmount) { FieldName = "残高", FieldNumber = 16, Required = true, Accept = VisitRemainAmountField, Format = value => value.ToString(), }; CustomerCodeField = new StringFieldDefinition <CustomerLedger>( k => k.CustomerCode) { FieldName = "得意先コード", FieldNumber = 17, Required = false, Accept = VisitCustomerCodeField, }; CustomerNameField = new StringFieldDefinition <CustomerLedger>( k => k.CustomerName) { FieldName = "得意先名", FieldNumber = 18, Required = true, Accept = VisitCustomerNameField, }; Fields.AddRange(new IFieldDefinition <CustomerLedger>[] { RecordedAtField, ParentCustomerCodeField, ParentCustomerNameField, SectionNameField, DepartmentNameField , InvoiceCodeField, CategoryNameField, DebitAccountTitleNameField, CurrencyCodeField, MatchingSymbolBillingField , BillingAmountField, SlipTotalField, ReceiptAmountField, MatchingSymbolReceiptField, MatchingAmountField , RemainAmountField, CustomerCodeField, CustomerNameField }); }
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 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); } }
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 }); }