private void SetFormat()
{
var expression = new DataExpression(ApplicationControl);
txtCustomerCodeFrom.MaxLength = expression.CustomerCodeLength;
txtCustomerCodeTo.MaxLength = expression.CustomerCodeLength;
txtStaffCodeFrom.MaxLength = expression.StaffCodeLength;
txtStaffCodeTo.MaxLength = expression.StaffCodeLength;
txtCustomerCodeFrom.Format = expression.CustomerCodeFormatString;
txtCustomerCodeTo.Format = expression.CustomerCodeFormatString;
txtStaffCodeFrom.Format = expression.StaffCodeFormatString;
txtStaffCodeTo.Format = expression.StaffCodeFormatString;
txtCustomerCodeFrom.ImeMode = expression.CustomerCodeImeMode();
txtCustomerCodeTo.ImeMode = expression.CustomerCodeImeMode();
txtCustomerCodeFrom.PaddingChar = expression.CustomerCodePaddingChar;
txtCustomerCodeTo.PaddingChar = expression.CustomerCodePaddingChar;
}
private IWorker CreateConcreteWorker(LogWriter logger, TaskSchedule task)
{
ApplicationControl appControl = null;
DataExpression expression = null;
try
{
appControl = Screen.Util.GetApplicationControl(Login);
}
catch (Exception ex)
{
logger.Log(ex);
}
if (appControl == null)
{
return(null);
}
else
{
expression = new DataExpression(appControl);
}
switch (task.ImportType)
{
case (int)BatchType.Customer: return(new ConcreteWorker.CustomerImporterWorker(logger, Login, task, appControl));
case (int)BatchType.CustomerGroup: return(new ConcreteWorker.CustomerGroupImporterWorker(logger, Login, task, appControl, expression));
case (int)BatchType.Billing: return(new ConcreteWorker.BillingImporterWorker(logger, Login, task, appControl));
case (int)BatchType.EbData: return(new ConcreteWorker.EBDataImporterWorker(logger, Login, task));
case (int)BatchType.Receipt: return(new ConcreteWorker.ReceiptImporterWorker(logger, Login, task, appControl));
case (int)BatchType.PaymentSchedule: return(new ConcreteWorker.PaymentScheduleImporterWorker(logger, Login, task, appControl));
}
return(null);
}
private void SetOnFormLoad()
{
var useOperationLogging = ApplicationControl?.UseOperationLogging ?? 0;
var expression = new DataExpression(ApplicationControl);
if (useOperationLogging == 1)
{
lblLoggedSwitch.Text = "する";
}
else
{
lblLoggedSwitch.Text = "しない";
}
txtLoginUserCode.Format = expression.LoginUserCodeFormatString;
if (expression.LoginUserCodeFormatString == "9")
{
txtLoginUserCode.PaddingChar = '0';
}
txtLoginUserCode.MaxLength = expression.LoginUserCodeLength;
}
private void PB1501_Load(object sender, EventArgs e)
{
try
{
SetScreenName();
var loadTask = new List <Task>();
if (Company == null)
{
loadTask.Add(LoadCompanyAsync());
}
if (ApplicationControl == null)
{
loadTask.Add(LoadApplicationControlAsync());
}
loadTask.Add(LoadControlColorAsync());
loadTask.Add(LoadFunctionAuthorities(MasterImport, MasterExport));
Task <List <IgnoreKana> > loadListTask = GetListAsync();
loadListTask.ContinueWith(task => IgnoreKanaList.AddRange(task.Result));
loadTask.Add(loadListTask);
ProgressDialog.Start(ParentForm, Task.WhenAll(loadTask), false, SessionKey);
var expression = new DataExpression(ApplicationControl);
txtKana.MaxLength = expression.IgnoreKanaLength;
InitializeKanaGrid();
grdExcludeKanaList.DataSource = new BindingSource(IgnoreKanaList, null);
Clear(true);
}
catch (Exception ex)
{
Debug.Fail(ex.ToString());
NLogHandler.WriteErrorLog(this, ex, SessionKey);
}
}
private void SetFormat()
{
if (ApplicationControl == null)
{
return;
}
var expression = new DataExpression(ApplicationControl);
// 外貨利用を問わず 140 固定
txtPayerName.MaxLength = 140;
var format = IsCustomer ? expression.CustomerCodeFormatString : "9";
var length = IsCustomer ? expression.CustomerCodeLength : 2;
var ime = IsCustomer ? expression.CustomerCodeImeMode() : ImeMode.Disable;
var paddingChar = format == "9" ? (char?)'0' : null;
txtCustomerCodeFrom.Format = format;
txtCustomerCodeTo.Format = format;
txtCustomerCodeFrom.MaxLength = length;
txtCustomerCodeTo.MaxLength = length;
txtCustomerCodeFrom.ImeMode = ime;
txtCustomerCodeTo.ImeMode = ime;
txtCustomerCodeFrom.PaddingChar = paddingChar;
txtCustomerCodeTo.PaddingChar = paddingChar;
}
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 LoginUserFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "ログインユーザー";
FileNameToken = DataTypeToken + "マスター";
CompanyIdField = new StandardIdToCodeFieldDefinition <LoginUser, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
LoginUserCodeField = new StringFieldDefinition <LoginUser>(k => k.Code)
{
FieldName = "ログインユーザーコード",
FieldNumber = 2,
Required = true,
Accept = VisitLoginUserCode,
};
LoginUserNameField = new StringFieldDefinition <LoginUser>(k => k.Name)
{
FieldName = "ログインユーザー名",
FieldNumber = 3,
Required = true,
Accept = VisitLoginUserName,
};
DepartmentCodeField = new StandardIdToCodeFieldDefinition <LoginUser, Department>(
k => k.DepartmentId, c => c.Id, l => l.DepartmentCode, c => c.Code)
{
FieldName = "請求部門コード",
FieldNumber = 4,
Required = true,
Accept = VisitDepartmentCode,
};
MailField = new StringFieldDefinition <LoginUser>(k => k.Mail)
{
FieldName = "メールアドレス",
FieldNumber = 5,
Accept = VisitMail,
};
MenuLevelField = new NumberFieldDefinition <LoginUser, int>(k => k.MenuLevel)
{
FieldName = "権限レベル",
FieldNumber = 6,
Required = true,
Accept = VisitMenuLevelField,
Format = value => value.ToString(),
};
FunctionLevelField = new NumberFieldDefinition <LoginUser, int>(k => k.FunctionLevel)
{
FieldName = "セキュリティ",
FieldNumber = 7,
Required = true,
Accept = VisitFunctionLevelField,
Format = value => value.ToString(),
};
UseClientField = new NumberFieldDefinition <LoginUser, int>(k => k.UseClient)
{
FieldName = "V-ONE利用",
FieldNumber = 8,
Required = true,
Accept = VisitUseClientField,
Format = value => value.ToString(),
};
UseWebViewerField = new NumberFieldDefinition <LoginUser, int>(k => k.UseWebViewer)
{
FieldName = "WebViewer利用",
FieldNumber = 9,
Required = true,
Accept = VisitUseWebViewerField,
Format = value => value.ToString(),
};
StaffCodeField = new StandardNullableIdToCodeFieldDefinition <LoginUser, Staff>(
k => k.AssignedStaffId, c => c.Id, l => l.StaffCode, c => c.Code)
{
FieldName = "営業担当者コード",
FieldNumber = 10,
Required = false,
Accept = VisitStaffCode,
};
InitialPasswordField = new StringFieldDefinition <LoginUser>(k => k.InitialPassword)
{
FieldName = "初回パスワード",
FieldNumber = 11,
Required = false,
Accept = VisitInitialPassword,
};
Fields.AddRange(new IFieldDefinition <LoginUser>[] {
CompanyIdField, LoginUserCodeField, LoginUserNameField, DepartmentCodeField, MailField,
MenuLevelField, UseClientField, UseWebViewerField, FunctionLevelField, StaffCodeField,
InitialPasswordField
});
KeyFields.AddRange(new IFieldDefinition <LoginUser>[]
{
LoginUserCodeField,
});
}
//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
});
}
public KanaHistoryCustomerFileDefinition(DataExpression expression)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "得意先学習履歴";
FileNameToken = DataTypeToken;
CompanyIdField = new StandardIdToCodeFieldDefinition <KanaHistoryCustomer, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
PayerNameField = new StringFieldDefinition <KanaHistoryCustomer>(k => k.PayerName)
{
FieldName = "振込依頼人名",
FieldNumber = 2,
Required = false,
Accept = VisitKana,
};
CustomerIdField = new StandardIdToCodeFieldDefinition <KanaHistoryCustomer, Customer>(
k => k.CustomerId, c => c.Id,
k => k.CustomerCode, c => c.Code)
{
FieldName = "得意先コード",
FieldNumber = 3,
Required = true,
Accept = VisitcustomerId,
};
SourceBankNameField = new StringFieldDefinition <KanaHistoryCustomer>(k => k.SourceBankName)
{
FieldName = "仕向銀行",
FieldNumber = 4,
Required = false,
Accept = VisitSourceBankName,
};
SourceBrankNameField = new StringFieldDefinition <KanaHistoryCustomer>(k => k.SourceBranchName)
{
FieldName = "仕向支店",
FieldNumber = 5,
Required = false,
Accept = VisitSourceBrankName,
};
HitCountField = new NumberFieldDefinition <KanaHistoryCustomer, int>(k => k.HitCount)
{
FieldName = "消込回数",
FieldNumber = 6,
Required = true,
Accept = VisitHitCount,
Format = value => value.ToString(),
};
Fields.AddRange(new IFieldDefinition <KanaHistoryCustomer>[] {
CompanyIdField, PayerNameField, CustomerIdField, SourceBankNameField, SourceBrankNameField, HitCountField
});
KeyFields.AddRange(new IFieldDefinition <KanaHistoryCustomer>[]
{
PayerNameField,
CustomerIdField,
SourceBankNameField,
SourceBrankNameField,
});
}
public 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 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
});
}
/// <summary>
/// Creates a new joined table.
/// </summary>
/// <param name="kind">The kind to consider.</param>
/// <param name="condition">The condition to consider.</param>
/// <returns>Returns a new From statement.</returns>
public DbJoinedTable TableAsJoin <T>(DbQueryJoinKind kind, DataExpression condition)
{
return(TableAsJoin(typeof(T).Name, kind, condition));
}
// As Join -------------------------------------
/// <summary>
/// Creates a new joined table.
/// </summary>
/// <param name="name"></param>
/// <param name="kind">The kind to consider.</param>
/// <param name="condition">The condition to consider.</param>
/// <returns>Returns a new From statement.</returns>
public DbJoinedTable TableAsJoin(string name, DbQueryJoinKind kind, DataExpression condition)
{
return(DbFluent.TableAsJoin(kind, Table(name), condition));
}
public CurrencyFileDefinition(DataExpression expression)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "通貨";
FileNameToken = DataTypeToken + "マスター";
CompanyIdField = new StandardIdToCodeFieldDefinition <Currency, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
CurrencyCodeField = new StringFieldDefinition <Currency>(k => k.Code)
{
FieldName = "通貨コード",
FieldNumber = 2,
Required = true,
Accept = VisitCurrencyCode,
};
CurrencyNameField = new StringFieldDefinition <Currency>(k => k.Name)
{
FieldName = "名称",
FieldNumber = 3,
Required = true,
Accept = VisitCurrencyName,
};
CurrencySymbolField = new StringFieldDefinition <Currency>(k => k.Symbol)
{
FieldName = "単位",
FieldNumber = 4,
Required = true,
Accept = VisitCurrencySymbol,
};
CurrencyPrecisionField = new NumberFieldDefinition <Currency, int>(k => k.Precision)
{
FieldName = "小数点以下桁数",
FieldNumber = 5,
Required = true,
Accept = VisitCurrencyPrecision,
Format = value => value.ToString(),
};
CurrencyDisplayOrderField = new NumberFieldDefinition <Currency, int>(k => k.DisplayOrder)
{
FieldName = "表示順番",
FieldNumber = 6,
Required = true,
Accept = VisitCurrencyDisplayOrder,
Format = value => value.ToString(),
};
CurrencyNoteField = new StringFieldDefinition <Currency>(k => k.Note)
{
FieldName = "備考",
FieldNumber = 7,
Required = false,
Accept = VisitCurrencyNote,
};
CurrencyToleranceField = new NumberFieldDefinition <Currency, decimal>(k => k.Tolerance)
{
FieldName = "手数料誤差金額",
FieldNumber = 8,
Required = true,
Accept = VisitCurrencyTolerance,
Format = value => value.ToString(),
};
Fields.AddRange(new IFieldDefinition <Currency>[] {
CompanyIdField, CurrencyCodeField, CurrencyNameField, CurrencySymbolField, CurrencyPrecisionField
, CurrencyDisplayOrderField, CurrencyNoteField, CurrencyToleranceField
});
KeyFields.AddRange(new IFieldDefinition <Currency>[]
{
CurrencyCodeField,
});
}
} //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 MatchingHistoryFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "消込履歴データ";
FileNameToken = DataTypeToken;
var fieldNumber = 1;
MatchingAtField = new StringFieldDefinition <ExportMatchingHistory>(k => k.CreateAt)
{
FieldName = "消込日時",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitMatchingAt,
};
SectionCodeField = new StringFieldDefinition <ExportMatchingHistory>(k => k.SectionCode)
{
FieldName = "入金部門コード",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitSectionCode,
};
SectionNameField = new StringFieldDefinition <ExportMatchingHistory>(k => k.SectionName)
{
FieldName = "入金部門名",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitSectionName,
};
DepartmentCodeField = new StringFieldDefinition <ExportMatchingHistory>(k => k.DepartmentCode)
{
FieldName = "請求部門コード",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitDepartmentCode,
};
DepartmentNameField = new StringFieldDefinition <ExportMatchingHistory>(k => k.DepartmentName)
{
FieldName = "請求部門名",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitDepartmentName,
};
CustomerCodeField = new StringFieldDefinition <ExportMatchingHistory>(k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitCustomerCode,
};
CustomerNameField = new StringFieldDefinition <ExportMatchingHistory>(k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitCustomerName,
};
BilledAtField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BilledAt)
{
FieldName = "請求日",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBilledAt,
};
SalesAtField = new StringFieldDefinition <ExportMatchingHistory>(k => k.SalesAt)
{
FieldName = "売上日",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitSalesAt,
};
InvoiceCodeField = new StringFieldDefinition <ExportMatchingHistory>(k => k.InvoiceCode)
{
FieldName = "請求書番号",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitInvoiceCode,
};
BillingCategoryField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingCategory)
{
FieldName = "請求区分",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBillingCategory,
};
CollectCategoryField = new StringFieldDefinition <ExportMatchingHistory>(k => k.CollectCategory)
{
FieldName = "回収区分",
FieldNumber = fieldNumber++,
Required = false,
Accept = VisitCollectCategory,
};
BilledAmountField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingAmount)
{
FieldName = "請求額(税込)",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBilledAmount,
};
BilledAmountExcludingTaxField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingAmountExcludingTax)
{
FieldName = "請求額(税抜)",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBilledAmountExcludingTax,
};
TaxAmountField = new StringFieldDefinition <ExportMatchingHistory>(k => k.TaxAmount)
{
FieldName = "消費税",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitTaxAmount,
};
MatchingAmountField = new StringFieldDefinition <ExportMatchingHistory>(k => k.MatchingAmount)
{
FieldName = "消込金額",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitMatchingAmount,
};
BilledRemainField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingRemain)
{
FieldName = "請求残",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBilledRemain,
};
BillingNote1Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingNote1)
{
FieldName = "備考",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBillingNote1,
};
BillingNote2Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingNote2)
{
FieldName = "備考2",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBillingNote2,
};
BillingNote3Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingNote3)
{
FieldName = "備考3",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBillingNote3,
};
BillingNote4Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.BillingNote4)
{
FieldName = "備考4",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBillingNote4,
};
RecordedAtField = new StringFieldDefinition <ExportMatchingHistory>(k => k.RecordedAt)
{
FieldName = "入金日",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitRecordedAt,
};
ReceiptIdField = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptId)
{
FieldName = "入金ID",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptId,
};
ReceiptCategoryField = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptCategory)
{
FieldName = "入金区分",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptCategory,
};
ReceiptAmountField = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptAmount)
{
FieldName = "入金額",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptAmount,
};
AdvanceReceivedOccuredField = new StringFieldDefinition <ExportMatchingHistory>(k => k.AdvanceReceivedOccuredString)
{
FieldName = "前受",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitAdvanceReceivedOccured,
};
ReceiptRemainField = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptRemain)
{
FieldName = "入金残",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptRemain,
};
PayerNameField = new StringFieldDefinition <ExportMatchingHistory>(k => k.PayerName)
{
FieldName = "振込依頼人名",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitPayerName,
};
BankCodeField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BankCode)
{
FieldName = "銀行コード",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBankCode,
};
BankNameField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BankName)
{
FieldName = "銀行名",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBankName,
};
BranchCodeField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BranchCode)
{
FieldName = "支店コード",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBranchCode,
};
BranchNameField = new StringFieldDefinition <ExportMatchingHistory>(k => k.BranchName)
{
FieldName = "支店名",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitBranchName,
};
AccountNumberField = new StringFieldDefinition <ExportMatchingHistory>(k => k.AccountNumber)
{
FieldName = "口座番号",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitAccountNumber,
};
ReceiptNote1Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptNote1)
{
FieldName = "備考",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptNote1,
};
ReceiptNote2Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptNote2)
{
FieldName = "備考2",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptNote2,
};
ReceiptNote3Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptNote3)
{
FieldName = "備考3",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptNote3,
};
ReceiptNote4Field = new StringFieldDefinition <ExportMatchingHistory>(k => k.ReceiptNote4)
{
FieldName = "備考4",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitReceiptNote4,
};
VirtualBranchCode = new StringFieldDefinition <ExportMatchingHistory>(k => k.VirtualBranchCode)
{
FieldName = "仮想支店コード",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitPayerCodeFirst,
};
VirtualAccountNumberField = new StringFieldDefinition <ExportMatchingHistory>(k => k.VirtualAccountNumber)
{
FieldName = "仮想口座番号",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitPayerCodeLast,
};
LoginUserNameField = new StringFieldDefinition <ExportMatchingHistory>(k => k.LoginUserName)
{
FieldName = "消込実行ユーザー",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitLoginUserName,
};
MatchingProcessTypeField = new StringFieldDefinition <ExportMatchingHistory>(k => k.MatchingProcessTypeString)
{
FieldName = "消込",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitMatchingProcessType,
};
MatchingMemoField = new StringFieldDefinition <ExportMatchingHistory>(k => k.MatchingMemo)
{
FieldName = "消込メモ",
FieldNumber = fieldNumber++,
Required = true,
Accept = VisitMatchingMemo,
};
Fields.AddRange(new IFieldDefinition <ExportMatchingHistory>[] {
MatchingAtField
, SectionCodeField
, SectionNameField
, DepartmentCodeField
, DepartmentNameField
, CustomerCodeField
, CustomerNameField
, BilledAtField
, SalesAtField
, InvoiceCodeField
, BillingCategoryField,
CollectCategoryField,
BilledAmountField
, BilledAmountExcludingTaxField
, TaxAmountField
, MatchingAmountField
, BilledRemainField
, BillingNote1Field
, BillingNote2Field
, BillingNote3Field
, BillingNote4Field
, RecordedAtField
, ReceiptIdField
, ReceiptCategoryField
, ReceiptAmountField
, AdvanceReceivedOccuredField
, ReceiptRemainField
, PayerNameField
, BankCodeField
, BankNameField
, BranchCodeField
, BranchNameField
, AccountNumberField
, ReceiptNote1Field
, ReceiptNote2Field
, ReceiptNote3Field
, ReceiptNote4Field
, VirtualBranchCode
, VirtualAccountNumberField
, LoginUserNameField
, MatchingProcessTypeField
, MatchingMemoField
});
}
public BillingJournalizingFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "請求仕訳出力";
FileNameToken = DataTypeToken;
OutputHeader = false;
CompanyCodeField = new StandardIdToCodeFieldDefinition <BillingJournalizing, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyCode,
};
BilledAtField = new NumberFieldDefinition <BillingJournalizing, DateTime>(
k => k.BilledAt)
{
FieldName = "伝票日付",
FieldNumber = 2,
Required = true,
Accept = VisitBilledAt,
Format = value => (value == DateTime.MinValue) ? "" : value.ToShortDateString(),
};
SlipNumberField = new NumberFieldDefinition <BillingJournalizing, long>(
k => k.SlipNumber)
{
FieldName = "伝票番号",
FieldNumber = 3,
Required = true,
Accept = VisitSlipNumber,
Format = value => value.ToString(),
};
DebitDepartmentCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitDepartmentCode)
{
FieldName = "借方部門コード",
FieldNumber = 4,
Required = true,
Accept = VisitDebitDepartmentCode,
};
DebitDepartmentNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitDepartmentName)
{
FieldName = "借方部門名",
FieldNumber = 5,
Required = true,
Accept = VisitDebitDepartmentCode,
};
DebitAccountTitleCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitAccountTitleCode)
{
FieldName = "借方科目コード",
FieldNumber = 6,
Required = true,
Accept = VisitDebitAccountTitleCode,
};
DebitAccountTitleNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitAccountTitleName)
{
FieldName = "借方科目名",
FieldNumber = 7,
Required = true,
Accept = VisitDebitAccountTitleName,
};
DebitSubCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitSubCode)
{
FieldName = "借方補助コード",
FieldNumber = 8,
Required = true,
Accept = VisitDebitSubCode,
};
DebitSubNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.DebitSubName)
{
FieldName = "借方補助名",
FieldNumber = 9,
Required = true,
Accept = VisitDebitSubName,
};
CreditDepartmentCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditDepartmentCode)
{
FieldName = "貸方部門コード",
FieldNumber = 10,
Required = true,
Accept = VisitCreditDepartmentCode,
};
CreditDepartmentNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditDepartmentName)
{
FieldName = "貸方部門名",
FieldNumber = 11,
Required = true,
Accept = VisitCreditDepartmentName,
};
CreditAccountTitleCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditAccountTitleCode)
{
FieldName = "貸方科目コード",
FieldNumber = 12,
Required = true,
Accept = VisitCreditAccountTitleCode,
};
CreditAccountTitleNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditAccountTitleName)
{
FieldName = "貸方科目名",
FieldNumber = 13,
Required = true,
Accept = VisitCreditAccountTitleName,
};
CreditSubCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditSubCode)
{
FieldName = "貸方補助コード",
FieldNumber = 14,
Required = true,
Accept = VisitCreditSubCode,
};
CreditSubNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CreditSubName)
{
FieldName = "貸方補助名",
FieldNumber = 15,
Required = true,
Accept = VisitCreditSubName,
};
BillingAmountField = new NumberFieldDefinition <BillingJournalizing, decimal>(
k => k.BillingAmount)
{
FieldName = "仕訳金額",
FieldNumber = 16,
Required = true,
Accept = VisitBillingAmount,
Format = value => value.ToString(),
};
NoteField = new StringFieldDefinition <BillingJournalizing>(
k => k.Note)
{
FieldName = "備考",
FieldNumber = 17,
Required = true,
Accept = VisitNote,
};
CustomerCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 18,
Required = true,
Accept = VisitCustomerCode,
};
CustomerNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 19,
Required = true,
Accept = VisitCustomerName,
};
InvoiceCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.InvoiceCode)
{
FieldName = "請求書番号",
FieldNumber = 20,
Required = true,
Accept = VisitInvoiceCode,
};
StaffCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.StaffCode)
{
FieldName = "担当者コード",
FieldNumber = 21,
Required = true,
Accept = VisitStaffCode,
};
PayerCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.PayerCode)
{
FieldName = "振込依頼人コード",
FieldNumber = 22,
Required = true,
Accept = VisitPayerCode,
};
PayerNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.PayerName)
{
FieldName = "振込依頼人名",
FieldNumber = 23,
Required = true,
Accept = VisitPayerName,
};
SourceBankNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.SourceBankName)
{
FieldName = "仕向銀行",
FieldNumber = 24,
Required = true,
Accept = VisitSourceBankName,
};
SourceBranchNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.SourceBranchName)
{
FieldName = "仕向支店",
FieldNumber = 25,
Required = true,
Accept = VisitSourceBranchName,
};
DueAtField = new NumberFieldDefinition <BillingJournalizing, DateTime>(
k => k.DueAt)
{
FieldName = "期日",
FieldNumber = 26,
Required = true,
Accept = VisitDueAt,
Format = value => (value == DateTime.MinValue) ? "" : value.ToString(),
};
BankCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.BankCode)
{
FieldName = "銀行コード",
FieldNumber = 27,
Required = true,
Accept = VisitBankCode,
};
BankNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.BankName)
{
FieldName = "銀行名",
FieldNumber = 28,
Required = true,
Accept = VisitBankName,
};
BranchCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.BranchCode)
{
FieldName = "支店コード",
FieldNumber = 29,
Required = true,
Accept = VisitBranchCode,
};
BranchNameField = new StringFieldDefinition <BillingJournalizing>(
k => k.BranchName)
{
FieldName = "支店名",
FieldNumber = 30,
Required = true,
Accept = VisitBranchName,
};
AccountTypeField = new NullableNumberFieldDefinition <BillingJournalizing, int>(
k => k.AccountType)
{
FieldName = "預金種別",
FieldNumber = 31,
Required = true,
Accept = VisitAccountType,
Format = value => value.ToString(),
};
AccountNumberField = new StringFieldDefinition <BillingJournalizing>(
k => k.AccountNumber)
{
FieldName = "口座番号",
FieldNumber = 32,
Required = true,
Accept = VisitAccountNumber,
};
CurrencyCodeField = new StringFieldDefinition <BillingJournalizing>(
k => k.CurrencyCode)
{
FieldName = "通貨コード",
FieldNumber = 33,
Required = true,
Accept = VisitCurrencyCode,
};
Fields.AddRange(new IFieldDefinition <BillingJournalizing>[]
{
CompanyCodeField, BilledAtField, SlipNumberField, DebitDepartmentCodeField,
DebitDepartmentNameField, DebitAccountTitleCodeField, DebitAccountTitleNameField,
DebitSubCodeField, DebitSubNameField, CreditDepartmentCodeField,
CreditDepartmentNameField, CreditAccountTitleCodeField, CreditAccountTitleNameField,
CreditSubCodeField, CreditSubNameField, BillingAmountField,
NoteField, CustomerCodeField, CustomerNameField,
InvoiceCodeField, StaffCodeField, PayerCodeField,
PayerNameField, SourceBankNameField, SourceBranchNameField,
DueAtField, BankCodeField, BankNameField,
BranchCodeField, BranchNameField, AccountTypeField,
AccountNumberField, CurrencyCodeField
});
}
public 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()));
}
private void PE0103_Load(object sender, EventArgs e)
{
try
{
SetScreenName();
datBilledAtFrom.Focus();
datBilledAtFrom.Clear();
datBilledAtTo.Clear();
datDueAtFrom.Value = DueAtFrom;
datDueAtTo.Value = DueAtTo;
datSalesAtFrom.Clear();
datSalesAtTo.Clear();
datUpdateAtFrom.Clear();
datUpdateAtTo.Clear();
cmbAmountType.SelectedIndex = 0;
datBilledAtFrom.Focus();
var loadTask = new List <Task>();
if (Company == null)
{
loadTask.Add(LoadCompanyAsync());
}
if (ApplicationControl == null)
{
loadTask.Add(LoadApplicationControlAsync());
}
loadTask.Add(LoadControlColorAsync());
loadTask.Add(LoadLeagalPersonarities());
loadTask.Add(LoadColumnNameSettingAsync());
SuspendLayout();
ResumeLayout();
InitializeDepartmentSelection();
loadTask.Add(LoadBillingCategoryCombo());
ProgressDialog.Start(ParentForm, Task.WhenAll(loadTask), false, SessionKey);
SetComboForInputType();
if (ApplicationControl != null)
{
var expression = new DataExpression(ApplicationControl);
txtCusCodeFrom.Format = expression.CustomerCodeFormatString;
txtCusCodeFrom.MaxLength = expression.CustomerCodeLength;
txtCusCodeFrom.ImeMode = expression.CustomerCodeImeMode();
txtCusCodeFrom.PaddingChar = expression.CustomerCodePaddingChar;
txtCusCodeTo.Format = expression.CustomerCodeFormatString;
txtCusCodeTo.MaxLength = expression.CustomerCodeLength;
txtCusCodeTo.ImeMode = expression.CustomerCodeImeMode();
txtCusCodeTo.PaddingChar = expression.CustomerCodePaddingChar;
txtDepCodeFrom.Format = expression.DepartmentCodeFormatString;
txtDepCodeFrom.MaxLength = expression.DepartmentCodeLength;
txtDepCodeFrom.PaddingChar = expression.DepartmentCodePaddingChar;
txtDepCodeTo.Format = expression.DepartmentCodeFormatString;
txtDepCodeTo.MaxLength = expression.DepartmentCodeLength;
txtDepCodeTo.PaddingChar = expression.DepartmentCodePaddingChar;
txtStaffCodeFrom.Format = expression.StaffCodeFormatString;
txtStaffCodeFrom.MaxLength = expression.StaffCodeLength;
txtStaffCodeFrom.PaddingChar = expression.StaffCodePaddingChar;
txtStaffCodeTo.Format = expression.StaffCodeFormatString;
txtStaffCodeTo.MaxLength = expression.StaffCodeLength;
txtStaffCodeTo.PaddingChar = expression.StaffCodePaddingChar;
txtUpdateBy.Format = expression.LoginUserCodeFormatString;
txtUpdateBy.MaxLength = expression.LoginUserCodeLength;
txtUpdateBy.PaddingChar = expression.LoginUserCodePaddingChar;
}
var format = UseForeignCurrency
? "###,###,###,##0.00000"
: "###,###,###,##0";
nmbAmountFrom.DisplayFields.AddRange(format, "", "", "-", "");
nmbAmountTo.DisplayFields.AddRange(format, "", "", "-", "");
Settings.SetCheckBoxValue <PE0103>(Login, cbxCusCode);
Settings.SetCheckBoxValue <PE0103>(Login, cbxDeCode);
Settings.SetCheckBoxValue <PE0103>(Login, cbxInvoiceCode);
Settings.SetCheckBoxValue <PE0103>(Login, cbxStaffCode);
Settings.SetCheckBoxValue <PE0103>(Login, cbxAmountType);
}
catch (Exception ex)
{
Debug.Fail(ex.ToString());
NLogHandler.WriteErrorLog(this, ex, SessionKey);
}
}
private void PE0104_Load(object sender, EventArgs e)
{
try
{
SetScreenName();
cmbAmountType.SelectedIndex = 0;
cmbInputKubun.SelectedIndex = 0;
datNyuukinFrom.Clear();
datNyuukinFrom.Value = RecordedAtFrom;
datNyuukinTo.Value = RecordedAtTo;
datUpdateAtFrom.Clear();
datUpdateAtTo.Clear();
var tasks = new List <Task>();
if (Company == null)
{
tasks.Add(LoadCompanyAsync());
}
if (ApplicationControl == null)
{
tasks.Add(LoadApplicationControlAsync());
}
tasks.Add(LoadControlColorAsync());
tasks.Add(LoadNyuukinCategoryCombo());
tasks.Add(LoadColumnNameSettingAsync());
tasks.Add(LoadLegalPersonalitiesAsync());
ProgressDialog.Start(ParentForm, Task.WhenAll(tasks), false, SessionKey);
if (ApplicationControl != null)
{
var expression = new DataExpression(ApplicationControl);
txtCusCodeFrom.Format = expression.CustomerCodeFormatString;
txtCusCodeFrom.MaxLength = expression.CustomerCodeLength;
txtCusCodeFrom.ImeMode = expression.CustomerCodeImeMode();
txtCusCodeFrom.PaddingChar = expression.CustomerCodePaddingChar;
txtCusCodeTo.Format = expression.CustomerCodeFormatString;
txtCusCodeTo.MaxLength = expression.CustomerCodeLength;
txtCusCodeTo.ImeMode = expression.CustomerCodeImeMode();
txtCusCodeTo.PaddingChar = expression.CustomerCodePaddingChar;
txtSecCodeFrom.Format = expression.SectionCodeFormatString;
txtSecCodeFrom.MaxLength = expression.SectionCodeLength;
txtSecCodeFrom.PaddingChar = expression.SectionCodePaddingChar;
txtSecCodeTo.Format = expression.SectionCodeFormatString;
txtSecCodeTo.MaxLength = expression.SectionCodeLength;
txtSecCodeTo.PaddingChar = expression.SectionCodePaddingChar;
txtUpdatedBy.Format = expression.LoginUserCodeFormatString;
txtUpdatedBy.MaxLength = expression.LoginUserCodeLength;
txtUpdatedBy.PaddingChar = expression.LoginUserCodePaddingChar;
}
pnlSection.Visible = UseSection;
var format = UseForeignCurrency
? "###,###,###,##0.00000"
: "###,###,###,##0";
nmbAmountFrom.DisplayFields.AddRange(format, "", "", "-", "");
nmbAmountTo.DisplayFields.AddRange(format, "", "", "-", "");
InitializeSectionSelection();
Settings.SetCheckBoxValue <PE0104>(Login, cbxCusCode);
Settings.SetCheckBoxValue <PE0104>(Login, cbxSecCode);
txtPayerCodePrefix.PaddingChar = '0';
txtPayerCodesuffix.PaddingChar = '0';
datNyuukinFrom.Select();
}
catch (Exception ex)
{
Debug.Fail(ex.ToString());
NLogHandler.WriteErrorLog(this, ex, SessionKey);
}
}
//Creates a cached generator for the converter to use for all data tables with a matching set of data columns. Due to our assumption that data types are loose in
//data tables, this will generate an extremely generic converter that doesn't statically use the data table's data typing.
private static Func <DataRow, TEntity> GetConverter(IDictionary <DataColumn, string> columnToMemberMap)
{
List <string> columnNames = columnToMemberMap.Select(k => k.Key.ColumnName).ToList();
if (!converters.TryGetValue(columnNames, out Func <DataRow, TEntity> value))
{
NewExpression instantiate = Expression.New(type);
ParameterExpression dataRow = Expression.Parameter(typeof(DataRow), "dataRow");
//Declare a dictionary to prevent creating more than 1 instance of a temporary parser type.
ConcurrentDictionary <Type, ParameterExpression> parameters = new ConcurrentDictionary <Type, ParameterExpression>();
List <MemberBinding> memberBindings = new List <MemberBinding>();
//Iterate over the column map and generate the expressions needed.
foreach (KeyValuePair <DataColumn, string> columnToMember in columnToMemberMap)
{
if (TryGetMemberInfo(columnToMember.Value, columnToMember.Key.Table.CaseSensitive, out MemberInfo memberInfo))
{
//Get a member expression. This is used for type resolution.
Type memberType = Expression.MakeMemberAccess(instantiate, memberInfo).Type,
realType = Nullable.GetUnderlyingType(memberType) ?? memberType;
//Get the data column expression used to access the data row field.
DataColumnExpression dataColumn = DataExpression.DataColumn(DataExpression.DataTable(dataRow), columnToMember.Key.ColumnName);
//Get the is null expression used to determine if the data field is null.
DataFieldIsNullExpression callDataFieldIsNull = DataExpression.DataFieldIsNull(dataRow, dataColumn);
ConditionalExpression dataFieldIsNull = Expression.Condition(callDataFieldIsNull, Expression.Default(memberType),
Expression.Default(memberType));
//Get the is assignable from expression used to determine if the data column can be converted to the member type.
IsAssignableFromExpression callIsAssignableFrom = DataExpression.IsAssignableFrom(DataExpression.DataType(dataColumn), memberType);
//Get the is assignable from true result. If member type is string, then call the trim method on the string.
Expression isAssignableFromTrue = Expression.Convert(DataExpression.DataField(dataRow, dataColumn), memberType);
if (typeof(string).IsAssignableFrom(memberType))
{
isAssignableFromTrue = Expression.Call(isAssignableFromTrue, "Trim", Type.EmptyTypes);
}
//Get the conditional expression used to process the data column type conversion.
ConditionalExpression isAssignableFrom = Expression.Condition(callIsAssignableFrom,
isAssignableFromTrue, Expression.Default(memberType));
if (realType.GetMethods().Any(m => m.Name == "TryParse"))
{
//Get the is string parameter expression used for try parsing.
ParameterExpression stringLocal = parameters.GetOrAdd(typeof(string), Expression.Variable(typeof(string))),
outLocal = parameters.GetOrAdd(realType, Expression.Variable(realType));
//Get the type is assign and try parse expressions used for try parsing.
TypeIsAssignExpression typeIsAssign = DataExpression.TypeIsAssign(
DataExpression.DataField(dataRow, dataColumn), stringLocal);
TryParseExpression callTryParse = DataExpression.TryParse(stringLocal, outLocal);
//Get the conditional expression used to process the try parse conversion.
ConditionalExpression tryParse = Expression.Condition(
Expression.AndAlso(typeIsAssign, callTryParse),
Expression.Convert(outLocal, memberType), Expression.Default(memberType));
//Update is assignable from with the try parse method.
isAssignableFrom = isAssignableFrom.Update(isAssignableFrom.Test, isAssignableFrom.IfTrue, tryParse);
}
if (typeof(IConvertible).IsAssignableFrom(realType))
{
//Get the change type expression.
ChangeTypeExpression callChangeType = DataExpression.ChangeType(
DataExpression.DataField(dataRow, dataColumn), realType);
//Get the conversion expression for the change type. If member type is string, then call the trim method on the string.
Expression changeType = Expression.Convert(callChangeType, memberType);
if (typeof(string).IsAssignableFrom(memberType))
{
changeType = Expression.Call(changeType, "Trim", Type.EmptyTypes);
}
//Determine if try parse is set. If so, update it and is assignable from. Otherwise, add change type to is assignable from.
if (isAssignableFrom.IfFalse is ConditionalExpression tryParse)
{
tryParse = tryParse.Update(tryParse.Test, tryParse.IfTrue, changeType);
isAssignableFrom = isAssignableFrom.Update(isAssignableFrom.Test, isAssignableFrom.IfTrue, tryParse);
}
else
{
isAssignableFrom = isAssignableFrom.Update(isAssignableFrom.Test, isAssignableFrom.IfTrue, changeType);
}
}
dataFieldIsNull = dataFieldIsNull.Update(dataFieldIsNull.Test, dataFieldIsNull.IfTrue, isAssignableFrom);
//Silently ignore conversion errors with the try catch expression. This is mostly for testing purposes and might be removed
//in the future.
memberBindings.Add(Expression.Bind(memberInfo, Expression.TryCatch(dataFieldIsNull,
Expression.Catch(typeof(Exception), Expression.Default(memberType)))));
}
}
//Get the converter lambda expression, creating the initialization block with its parameters.
Expression <Func <DataRow, TEntity> > converter = Expression.Lambda <Func <DataRow, TEntity> >(
Expression.Block(parameters.Values, Expression.MemberInit(instantiate, memberBindings)), dataRow);
//Use expression reducer to reduce the conversion lambda expression, then compile and return the delegate.
converter = (Expression <Func <DataRow, TEntity> >) new ExpressionReducer().Visit(converter);
value = converters.GetOrAdd(new HashSet <string>(columnNames), converter.Compile());
}
return(value);
}
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 ReceiptSearchFileDefinition(DataExpression expression, List <GridSetting> GridSettingInfo)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "入金データ";
FileNameToken = DataTypeToken;
int fieldNumber = 1;
Fields.Add(DeleteAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.DeleteAt,
fieldName: "削除日", fieldNumber: fieldNumber,
accept: VisitDeleteAtField,
formatter: value => (value == DateTime.MinValue) ? "" : value.ToShortDateString()));
foreach (GridSetting gs in GridSettingInfo)
{
fieldNumber++;
IFieldDefinition <Receipt> field = null;
switch (gs.ColumnName)
{
case "ExcludeFlag":
field = (ExcludeFlagField = new NumberFieldDefinition <Receipt, int>(k => k.ExcludeFlag,
accept: VisitExcludeFlagField,
formatter: value => value.ToString()));
break;
case "ExcludeCategory":
field = (ExcludeCategoryNameField = new StringFieldDefinition <Receipt>(k => k.ExcludeCategoryName,
accept: VisitExcludeCategoryNameField));
break;
case "Id":
field = (IdField = new NumberFieldDefinition <Receipt, long>(k => k.Id,
accept: VisitIdField,
formatter: value => value.ToString()));
break;
case "AssignmentState":
field = (AssignmentFlagNameField = new StringFieldDefinition <Receipt>(k => k.AssignmentFlagName,
accept: VisitAssignmentFlagNameField));
break;
case "RecordedAt":
field = (RecordedAtField = new NumberFieldDefinition <Receipt, DateTime>(k => k.RecordedAt,
accept: VisitRecordedAtField,
formatter: value => (value == null) ? "" : value.ToShortDateString()));
break;
case "CustomerCode":
field = (CustomerCodeField = new StandardNullableIdToCodeFieldDefinition <Receipt, Customer>(
k => k.CustomerId, c => c.Id, k => k.CustomerCode, c => c.Code,
accept: VisitCustomerCodeField));
break;
case "CustomerName":
field = (CustomerNameField = new StringFieldDefinition <Receipt>(k => k.CustomerName,
accept: VisitCustomerNameField));
break;
case "PayerName":
field = (PayerNameField = new StringFieldDefinition <Receipt>(k => k.PayerName,
accept: VisitPayerNameField));
break;
case "CurrencyCode":
field = (CurrencyIdField = new StandardIdToCodeFieldDefinition <Receipt, Currency>(
k => k.CurrencyId, c => c.Id,
k => k.CurrencyCode, c => c.Code,
accept: VisitCurrencyIdField));
break;
case "ReceiptAmount":
field = (ReceiptAmountField = new NumberFieldDefinition <Receipt, decimal>(k => k.ReceiptAmount,
accept: VisitReceiptAmountField,
formatter: value => value.ToString()));
break;
case "RemainAmount":
field = (RemainAmountField = new NumberFieldDefinition <Receipt, decimal>(k => k.RemainAmount,
accept: VisitRemainAmountField,
formatter: value => value.ToString()));
break;
case "ExcludeAmount":
field = (ExcludeAmountField = new NumberFieldDefinition <Receipt, decimal>(k => k.ExcludeAmount,
accept: VisitExcludeAmountField,
formatter: value => value.ToString()));
break;
case "ReceiptCategoryName":
field = (ReceiptCategoryNameField = new StringFieldDefinition <Receipt>(k => k.CategoryCodeName,
accept: VisitReceiptCategoryNameField));
break;
case "InputType":
field = (InputTypeField = new StringFieldDefinition <Receipt>(k => k.InputTypeName,
accept: VisitInputTypeField));
break;
case "Note1":
field = (Note1Field = new StringFieldDefinition <Receipt>(k => k.Note1,
accept: VisitNote1Field));
break;
case "Note2":
field = (Note2Field = new StringFieldDefinition <Receipt>(k => k.Note2,
accept: VisitNote2Field));
break;
case "Note3":
field = (Note3Field = new StringFieldDefinition <Receipt>(k => k.Note3,
accept: VisitNote3Field));
break;
case "Note4":
field = (Note4Field = new StringFieldDefinition <Receipt>(k => k.Note4,
accept: VisitNote4Field));
break;
case "Memo":
field = (ReceiptMemoField = new StringFieldDefinition <Receipt>(k => k.ReceiptMemo,
accept: VisitReceiptMemoField));
break;
case "DueAt":
field = (DueAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.DueAt,
accept: VisitDueAtField,
formatter: value => (value == null) ? "" : value.ToShortDateString()));
break;
case "SectionCode":
field = (SectionIdField = new StandardNullableIdToCodeFieldDefinition <Receipt, Section>(
k => k.SectionId, c => c.Id,
k => k.SectionCode, c => c.Code,
accept: VisitSectionIdField));
break;
case "SectionName":
field = (SectionNameField = new StringFieldDefinition <Receipt>(k => k.SectionName,
accept: VisitSectionNameField));
break;
case "BankCode":
field = (BankCodeField = new StringFieldDefinition <Receipt>(k => k.BankCode,
accept: VisitBankCodeField));
break;
case "BankName":
field = (BankNameField = new StringFieldDefinition <Receipt>(k => k.BankName,
accept: VisitBankNameField));
break;
case "BranchCode":
field = (BranchCodeField = new StringFieldDefinition <Receipt>(k => k.BranchCode,
accept: VisitBranchCodeField));
break;
case "BranchName":
field = (BranchNameField = new StringFieldDefinition <Receipt>(k => k.BranchName,
accept: VisitBranchNameField));
break;
case "AccountNumber":
field = (AccountNumberField = new StringFieldDefinition <Receipt>(k => k.AccountNumber,
accept: VisitAccountNumberField));
break;
case "SourceBankName":
field = (SourceBankNameField = new StringFieldDefinition <Receipt>(k => k.SourceBankName,
accept: VisitSourceBankNameField));
break;
case "SourceBranchName":
field = (SourceBranchNameField = new StringFieldDefinition <Receipt>(k => k.SourceBranchName,
accept: VisitSourceBranchNameField));
break;
case "VirtualBranchCode":
field = (PayerCodePrefixField = new StringFieldDefinition <Receipt>(k => k.PayerCodePrefix,
accept: VisitPayerCodePrefixField));
break;
case "VirtualAccountNumber":
field = (PayerCodeSuffixField = new StringFieldDefinition <Receipt>(k => k.PayerCodeSuffix,
accept: VisitPayerCodeSuffixField));
break;
case "OutputAt":
field = (OutputAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.OutputAt,
accept: VisitOutputAtField,
formatter: value => (value == null) ? "" : value.ToString()));
break;
case "BillNumber":
field = (BillNumberField = new StringFieldDefinition <Receipt>(k => k.BillNumber,
accept: VisitBillNumberField));
break;
case "BillBankCode":
field = (BillBankCodeField = new StringFieldDefinition <Receipt>(k => k.BillBankCode,
accept: VisitBillBankCodeField));
break;
case "BillBranchCode":
field = (BillBranchCodeField = new StringFieldDefinition <Receipt>(k => k.BillBranchCode,
accept: VisitBillBranchCodeField));
break;
case "BillDrawAt":
field = (BillDrawAtField = new NullableNumberFieldDefinition <Receipt, DateTime>(k => k.BillDrawAt,
accept: VisitBillDrawAtField,
formatter: value => (value == null) ? "" : value.ToShortDateString()));
break;
case "BillDrawer":
field = (BillDrawerField = new StringFieldDefinition <Receipt>(k => k.BillDrawer,
accept: VisitBillDrawerField));
break;
}
if (field == null)
{
continue;
}
field.FieldName = gs.ColumnNameJp;
field.FieldNumber = fieldNumber;
Fields.Add(field);
}
KeyFields.AddRange(new IFieldDefinition <Receipt>[]
{
CurrencyIdField,
CustomerCodeField,
SectionIdField,
});
}
public PaymentScheduleInputFileDefinition(DataExpression expression, List <GridSetting> GridSettingInfo) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "入金予定入力";
FileNameToken = DataTypeToken;
int fieldNumber = 1;
foreach (GridSetting gs in GridSettingInfo)
{
Func <DateTime, string> dateTimeFormatter = value => value.ToString("yyyy/MM/dd");
fieldNumber++;
IFieldDefinition <Billing> field = null;
switch (gs.ColumnName)
{
case nameof(Billing.BillingId):
field = (IdField = new NumberFieldDefinition <Billing, long>(k => k.Id,
accept: VisitIdField,
formatter: value => value.ToString()));
break;
case nameof(Billing.InvoiceCode):
field = (InvoiceCodeField = new StringFieldDefinition <Billing>(k => k.InvoiceCode,
accept: VisitInvoiceCodeField));
break;
case nameof(Billing.CustomerCode):
field = (CustomerCodeField = new StringFieldDefinition <Billing>(k => k.CustomerCode,
accept: VisitCustomerCodeField));
break;
case nameof(Billing.CustomerName):
field = (CustomerNameField = new StringFieldDefinition <Billing>(k => k.CustomerName,
accept: VisitCustomerNameField));
break;
case nameof(Billing.DepartmentCode):
field = (DepartmentCodeField = new StringFieldDefinition <Billing>(k => k.DepartmentCode,
accept: VisitDepartmentCodeField));
break;
case nameof(Billing.DepartmentName):
field = (DepartmentNameField = new StringFieldDefinition <Billing>(k => k.DepartmentName,
accept: VisitDepartmentNameField));
break;
case nameof(Billing.CurrencyCode):
field = (CurrencyCodeField = new StringFieldDefinition <Billing>(k => k.CurrencyCode,
accept: VisitCurrencyCodeField));
break;
case nameof(Billing.BillingAmount):
field = (BillingAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.BillingAmount,
accept: VisitBillingAmountField,
formatter: value => value.ToString()));
break;
case "DiscountAmountSummary":
field = (DiscountAmountSummaryField = new NumberFieldDefinition <Billing, decimal>(k => k.DiscountAmount,
accept: VisitDiscountAmountSummaryField,
formatter: value => value.ToString()));
break;
case nameof(Billing.RemainAmount):
field = (RemainAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.RemainAmount,
accept: VisitRemainAmountField,
formatter: value => value.ToString()));
break;
case nameof(Billing.PaymentAmount):
field = (PaymentAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.PaymentAmount,
accept: VisitPaymentAmountField,
formatter: value => value.ToString()));
break;
case nameof(Billing.OffsetAmount):
field = (OffsetAmountField = new NumberFieldDefinition <Billing, decimal>(k => k.OffsetAmount,
accept: VisitOffsetAmountField,
formatter: value => value.ToString()));
break;
case nameof(Billing.BilledAt):
field = (BilledAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.BilledAt,
accept: VisitBilledAtField,
formatter: dateTimeFormatter));
break;
case nameof(Billing.BillingDueAt):
field = (BillingDueAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.BillingDueAt,
accept: VisitBillingDueAtField,
formatter: dateTimeFormatter));
break;
case "BillingCategory":
field = (BillingCategoryField = new StringFieldDefinition <Billing>(k => k.BillingCategoryCodeAndName,
accept: VisitBillingCategoryField));
break;
case nameof(Billing.ScheduledPaymentKey):
field = (ScheduledPaymentKeyField = new StringFieldDefinition <Billing>(k => k.ScheduledPaymentKey,
accept: VisitScheduledPaymentKeyField));
break;
case nameof(Billing.SalesAt):
field = (SalesAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.SalesAt,
accept: VisitSalesAtField,
formatter: dateTimeFormatter));
break;
case nameof(Billing.ClosingAt):
field = (ClosingAtField = new NumberFieldDefinition <Billing, DateTime>(k => k.ClosingAt,
accept: VisitClosingAtField,
formatter: dateTimeFormatter));
break;
case "CollectCategory":
field = (CollectCategoryField = new StringFieldDefinition <Billing>(k => k.CollectCategoryCodeAndName,
accept: VisitCollectCategoryField));
break;
case nameof(Billing.Note1):
field = (Note1Field = new StringFieldDefinition <Billing>(k => k.Note1,
accept: VisitNote1Field));
break;
case nameof(Billing.Note2):
field = (Note2Field = new StringFieldDefinition <Billing>(k => k.Note2,
accept: VisitNote2Field));
break;
case nameof(Billing.Note3):
field = (Note3Field = new StringFieldDefinition <Billing>(k => k.Note3,
accept: VisitNote3Field));
break;
case nameof(Billing.Note4):
field = (Note4Field = new StringFieldDefinition <Billing>(k => k.Note4,
accept: VisitNote4Field));
break;
case nameof(Billing.StaffCode):
field = (StaffCodeField = new StringFieldDefinition <Billing>(k => k.StaffCode,
accept: VisitStaffCodeField));
break;
case nameof(Billing.StaffName):
field = (StaffNameField = new StringFieldDefinition <Billing>(k => k.StaffName,
accept: VisitStaffNameField));
break;
case nameof(Billing.InputType):
field = (InputTypeField = new StringFieldDefinition <Billing>(k => k.InputTypeName,
accept: VisitInputTypeField));
break;
case nameof(Billing.Memo):
field = (BillingMemoField = new StringFieldDefinition <Billing>(k => k.Memo,
accept: VisitBillingMemoField));
break;
case nameof(Billing.Note5):
field = (Note5Field = new StringFieldDefinition <Billing>(k => k.Note5,
accept: VisitNote5Field));
break;
case nameof(Billing.Note6):
field = (Note6Field = new StringFieldDefinition <Billing>(k => k.Note6,
accept: VisitNote6Field));
break;
case nameof(Billing.Note7):
field = (Note7Field = new StringFieldDefinition <Billing>(k => k.Note7,
accept: VisitNote7Field));
break;
case nameof(Billing.Note8):
field = (Note8Field = new StringFieldDefinition <Billing>(k => k.Note8,
accept: VisitNote8Field));
break;
default:
break;
}
if (field == null)
{
continue;
}
field.FieldName = gs.ColumnNameJp;
field.FieldNumber = fieldNumber;
Fields.Add(field);
}
}
// Join --------------------------------
/// <summary>
/// Creates a new joined table.
/// </summary>
/// <param name="kind">The kind to consider.</param>
/// <param name="table">The table to consider.</param>
/// <param name="expression">The expression to consider.</param>
/// <returns>Returns a new From statement.</returns>
public static DbJoinedTable TableAsJoin(DbQueryJoinKind kind, DbTable table, DataExpression expression)
=> new DbJoinedTable()
{
Kind = kind, Table = table
}.WithCondition(expression);
public BillingAgingListDetailFileDefinition(DataExpression expression, ColumnNameSetting ColumnNameSetting)
: base(expression)
{
StartLineNumber = 1;
DataTypeToken = "請求残高年齢表";
FileNameToken = DataTypeToken;
CustomerCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.CustomerCode)
{
FieldName = "得意先コード",
FieldNumber = 1,
Required = false,
Accept = VisitCustomerCodeField,
};
CustomerNameField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.CustomerName)
{
FieldName = "得意先名",
FieldNumber = 1,
Required = false,
Accept = VisitCustomerNameField,
};
CurrencyCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.CurrencyCode)
{
FieldName = "通貨コード",
FieldNumber = 1,
Required = false,
Accept = VisitCurrencyCodeField,
};
BilledAtField = new NumberFieldDefinition <BillingAgingListDetail, DateTime>(
k => k.BilledAt)
{
FieldName = "請求日",
FieldNumber = 1,
Required = false,
Accept = VisitBilledAtField,
Format = value => value.ToShortDateString(),
};
DueAtField = new NumberFieldDefinition <BillingAgingListDetail, DateTime>(
k => k.DueAt)
{
FieldName = "入金予定日",
FieldNumber = 1,
Required = false,
Accept = VisitDueAtField,
Format = value => value.ToShortDateString(),
};
SalesAtField = new NumberFieldDefinition <BillingAgingListDetail, DateTime>(
k => k.SalesAt)
{
FieldName = "売上日",
FieldNumber = 1,
Required = false,
Accept = VisitSalesAtField,
Format = value => value.ToShortDateString(),
};
BillingAmountField = new NumberFieldDefinition <BillingAgingListDetail, decimal>(k => k.BillingAmount)
{
FieldName = "請求金額",
FieldNumber = 1,
Required = false,
Accept = VisitBillingAmountField,
Format = value => value.ToString(),
};
RemainAmountField = new NumberFieldDefinition <BillingAgingListDetail, decimal>(k => k.RemainAmount)
{
FieldName = "請求残",
FieldNumber = 1,
Required = false,
Accept = VisitRemainAmountField,
Format = value => value.ToString(),
};
StaffCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.StaffCode)
{
FieldName = "担当者コード",
FieldNumber = 1,
Required = false,
Accept = VisitStaffCodeField,
};
StaffNameField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.StaffName)
{
FieldName = "担当者名",
FieldNumber = 1,
Required = false,
Accept = VisitStaffNameField,
};
InvoiceCodeField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.InvoiceCode)
{
FieldName = "請求書番号",
FieldNumber = 1,
Required = false,
Accept = VisitInvoiceCodeField,
};
NoteField = new StringFieldDefinition <BillingAgingListDetail>(
k => k.Note)
{
FieldName = ColumnNameSetting.DisplayColumnName,
FieldNumber = 1,
Required = false,
Accept = VisitNoteField,
};
Fields.AddRange(new IFieldDefinition <BillingAgingListDetail>[] {
CustomerCodeField, CustomerNameField, CurrencyCodeField, BilledAtField, DueAtField
, SalesAtField, BillingAmountField, RemainAmountField, StaffCodeField, StaffNameField
, InvoiceCodeField, NoteField
});
}
//Load Document
private void MenuItem_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openfile = new OpenFileDialog();
openfile.DefaultExt = ".xml";
openfile.Filter = "(.xml)|*xml";
//openfile.ShowDialog();
var browsefile = openfile.ShowDialog();
if (browsefile == true)
{
try
{
var path = openfile.FileName;
EDITOR_SCREEN.Children.Clear();
EDITOR_SCREEN.UpdateLayout();
var xmlStr = File.ReadAllText(@path);
var str = XElement.Parse(xmlStr);
foreach (var item in str.Elements())
{
if (item.Name.LocalName.ToString() == "DATABASE")
{
((App)App.Current).Server = item.Attribute("INSTANCE").Value.ToString();
((App)App.Current).DatabaseName = item.Attribute("DATABAZA").Value.ToString();
MyIntances.Items.Add(new ComboBoxItem {
Content = ((App)App.Current).DatabaseName
});
}
else
if (item.Name.LocalName.ToString() == XMLCREATOR.TEKST)
{
var txt = new Text();
var top = item.Attribute(XMLCREATOR.TOP).Value.ToString();
txt.Txt.Text = item.Attribute("VALUE").Value.ToString();
Canvas.SetTop(txt, double.Parse(top));
Canvas.SetLeft(txt, double.Parse(item.Attribute(XMLCREATOR.LEFT).Value.ToString()));
txt.Width = double.Parse(item.Attribute(XMLCREATOR.WIDTH).Value);
txt.Height = double.Parse(item.Attribute(XMLCREATOR.HEIGHT).Value.ToString());
EDITOR_SCREEN.Children.Add(txt);
}
else if (item.Name.LocalName.ToString() == XMLCREATOR.FIELD)
{
var f = new Field();
Canvas.SetTop(f, double.Parse(item.Attribute(XMLCREATOR.TOP).Value.ToString()));
Canvas.SetLeft(f, double.Parse(item.Attribute(XMLCREATOR.LEFT).Value.ToString()));
f.DataBaseData = new Tuple <string, string>(item.Elements("DB").FirstOrDefault().Attribute("TN").Value.ToString(), item.Elements("DB").FirstOrDefault().Attribute("CN").Value.ToString());
f.LblName.Content = f.DataBaseData.Item2;
f.Width = double.Parse(item.Attribute(XMLCREATOR.WIDTH).Value);
f.Height = double.Parse(item.Attribute(XMLCREATOR.HEIGHT).Value);
EDITOR_SCREEN.Children.Add(f);
}
else if (item.Name.LocalName.ToString() == XMLCREATOR.TABELE)
{
var t = new Tabele();
Canvas.SetTop(t, double.Parse(item.Attribute(XMLCREATOR.TOP).Value.ToString()));
Canvas.SetLeft(t, double.Parse(item.Attribute(XMLCREATOR.LEFT).Value.ToString()));
t.Width = double.Parse(item.Attribute(XMLCREATOR.WIDTH).Value);
t.Height = double.Parse(item.Attribute(XMLCREATOR.HEIGHT).Value);
foreach (XElement colums in item.Element(XMLCREATOR.COLUMNS).Elements())
{
var kol = new Kolone();
t.Container.ColumnDefinitions.Add(new ColumnDefinition());
Grid.SetColumn(kol, t.Container.ColumnDefinitions.Count - 1);
if (colums.Elements("DB").FirstOrDefault() != null)
{
kol.FieldColumn.DataBaseData = new Tuple <string, string>(colums.Elements("DB").FirstOrDefault().Attribute("TN").Value.ToString(), colums.Elements("DB").FirstOrDefault().Attribute("CN").Value.ToString());
kol.FieldColumn.LblName.Content = kol.FieldColumn.DataBaseData.Item2;
}
else
{
var rows = colums.Element("FX").Elements().ToList();
var e1 = new DataExpression();
e1.ColumnName = new Tuple <string, string>(rows[0].Attribute("TN").Value, rows[0].Attribute("CN").Value);
var OPERATOR = rows[1].Value;
var e2 = new DataExpression();
e2.ColumnName = new Tuple <string, string>(rows[2].Attribute("TN").Value, rows[2].Attribute("CN").Value);
if (OPERATOR == "+")
{
var a = new AddExpression(e1, e2);
kol.FieldColumn.Exp = a;
kol.FieldColumn.LblName.Content = a.getFunctionAsString();
}
else if (OPERATOR == "*")
{
var a = new MultipleExpression(e1, e2);
kol.FieldColumn.Exp = a;
kol.FieldColumn.LblName.Content = a.getFunctionAsString();
}
else if (OPERATOR == "-")
{
var a = new SubstractExpression(e1, e2);
kol.FieldColumn.Exp = a;
kol.FieldColumn.LblName.Content = a.getFunctionAsString();
}
else if (OPERATOR == "/")
{
var a = new MultipleExpression(e1, e2);
kol.FieldColumn.Exp = a;
kol.FieldColumn.LblName.Content = a.getFunctionAsString();
}
}
kol.ColHeader.Text = colums.Attribute(XMLCREATOR.COLUMN_HEADER).Value.ToString();
if (colums.Attribute("TOT") != null)
{
if (colums.Attribute("TOT").Value.ToString() == "True")
{
kol.HasTotal = true;
}
}
t.Container.Children.Add(kol);
}
EDITOR_SCREEN.Children.Add(t);
}
//schema DATA
else if (item.Name.LocalName == "SCHEMA")
{
SchemaCreator.CurrentChoise = new TableRelationShips();
SchemaCreator.CurrentChoise.Parent_Table = item.Attribute("PT").Value.ToString();
SchemaCreator.CurrentChoise.ParentKey = item.Attribute("PK").Value.ToString();
SchemaCreator.CurrentChoise.Child_Table = item.Attribute("CT").Value.ToString();
SchemaCreator.CurrentChoise.ChildKey = item.Attribute("PK").Value.ToString();
SchemaCreator.CurrentChoise.MAIN_KEY.Key = item.Attribute("FILTER").Value.ToString();
try
{
((App)App.Current).Server = item.Attribute("INSTANCE").Value.ToString();
((App)App.Current).DatabaseName = item.Attribute("DATABASE").Value.ToString();
}
catch
{
}
var nextlist = item.Element("NEXT").Elements().ToList();
foreach (var item2 in nextlist)
{
var pt = item2.Attribute("PT").Value.ToString();
var pk = item2.Attribute("PK").Value.ToString();
var ct = item2.Attribute("CT").Value.ToString();
var cky = item2.Attribute("CK").Value.ToString();
SchemaCreator.CurrentChoise.NextRelationShips.Add(new TableRelationShips {
Parent_Table = pt, ParentKey = pk, Child_Table = ct, ChildKey = cky
});
}
SchemaCreator.CurrentChoise.LoadColums();
}
}
}
catch (Exception xe)
{
MessageBox.Show("Dokumenti nuk mund te hapet, mund te jete korruptuar ose formati nuk eshte i sakte !");
}
}
}
public BankBranchFileDefinition(DataExpression applicationControl) : base(applicationControl)
{
OutputHeader = false;
StartLineNumber = 0;
DataTypeToken = "銀行・支店";
FileNameToken = DataTypeToken + "マスター";
DuplicateAdoption = DuplicateAdoption.First; // 重複データは先勝ち
TreatDuplicateAs = TreatDuplicateAs.Ignore;
// FieldNumber 1 銀行コード
BankCodeField = new StringFieldDefinition <BankBranch>(
cd => cd.BankCode)
{
FieldName = "銀行コード",
FieldNumber = 1,
Required = true,
Accept = VisitBankCode,
};
// FieldNumber 2 支店コード
BranchCodeField = new StringFieldDefinition <BankBranch>(
cd => cd.BranchCode)
{
FieldName = "支店コード",
FieldNumber = 2,
Required = true,
Accept = VisitBranchCode,
};
// FieldNumber 3 銀行名カナ
BankKanaField = new StringFieldDefinition <BankBranch>(
cd => cd.BankKana)
{
FieldName = "銀行名カナ",
FieldNumber = 3,
Required = false,
Accept = VisitBankKana,
};
// FieldNumber 4 銀行名
BankNameField = new StringFieldDefinition <BankBranch>(
cd => cd.BankName)
{
FieldName = "銀行名",
FieldNumber = 4,
Required = true,
Accept = VisitBankName,
};
// FieldNumber 5 支店名カナ
BranchKanaField = new StringFieldDefinition <BankBranch>(
cd => cd.BranchKana)
{
FieldName = "支店名カナ",
FieldNumber = 5,
Required = false,
Accept = VisitBranchKana,
};
// FieldNumber 6 支店名
BranchNameField = new StringFieldDefinition <BankBranch>(
cd => cd.BranchName)
{
FieldName = "支店名",
FieldNumber = 6,
Required = true,
Accept = VisitBranchName,
};
Fields.AddRange(new IFieldDefinition <BankBranch>[] {
BankCodeField
, BranchCodeField
, BankKanaField
, BankNameField
, BranchKanaField
, BranchNameField
});
KeyFields.AddRange(new IFieldDefinition <BankBranch>[]
{
BankCodeField,
BranchCodeField,
});
}
public StaffFileDefinition(DataExpression expression) : base(expression)
{
StartLineNumber = 1;
DataTypeToken = "営業担当者";
FileNameToken = DataTypeToken + "マスター";
CompanyIdField = new StandardIdToCodeFieldDefinition <Staff, Company>(
k => k.CompanyId, c => c.Id, null, c => c.Code)
{
FieldName = "会社コード",
FieldNumber = 1,
Required = false,
Accept = VisitCompanyId,
};
StaffCodeField = new StringFieldDefinition <Staff>(k => k.Code)
{
FieldName = "営業担当者コード",
FieldNumber = 2,
Required = true,
Accept = VisitStaffCode,
};
StaffNameField = new StringFieldDefinition <Staff>(k => k.Name)
{
FieldName = "営業担当者名",
FieldNumber = 3,
Required = true,
Accept = VisitStaffName,
};
DepartmentIdField = new StandardIdToCodeFieldDefinition <Staff, Department>(
k => k.DepartmentId, c => c.Id,
k => k.DepartmentCode, c => c.Code)
{
FieldName = "請求部門コード",
FieldNumber = 4,
Required = true,
Accept = VisitDepartmentId,
};
MailField = new StringFieldDefinition <Staff>(k => k.Mail)
{
FieldName = "メールアドレス",
FieldNumber = 5,
Accept = VisitStaffMail,
};
TelField = new StringFieldDefinition <Staff>(k => k.Tel)
{
FieldName = "電話番号",
FieldNumber = 6,
Required = false,
Accept = VisitStaffTel,
};
FaxField = new StringFieldDefinition <Staff>(k => k.Fax)
{
FieldName = "FAX番号",
FieldNumber = 7,
Required = false,
Accept = VisitStaffFax,
};
Fields.AddRange(new IFieldDefinition <Staff>[] {
CompanyIdField, StaffCodeField, StaffNameField, DepartmentIdField, MailField, TelField, FaxField
});
KeyFields.AddRange(new IFieldDefinition <Staff>[]
{
StaffCodeField,
});
}
public ExportWorker(DataExpression exp)
{
DataExpression = exp;
}
