public Task <AccountTransferDetail> AddAsync(AccountTransferDetail detail, CancellationToken token = default(CancellationToken))
{
#region insert query
var query = @"
INSERT INTO [dbo].[AccountTransferDetail]
( [AccountTransferLogId]
, [BillingId]
, [CompanyId]
, [CustomerId]
, [DepartmentId]
, [StaffId]
, [BilledAt]
, [SalesAt]
, [ClosingAt]
, [DueAt]
, [DueAt2nd]
, [BillingAmount]
, [InvoiceCode]
, [Note1]
, [TransferBankCode]
, [TransferBankName]
, [TransferBranchCode]
, [TransferBranchName]
, [TransferAccountTypeId]
, [TransferAccountNumber]
, [TransferAccountName]
, [TransferCustomerCode]
, [TransferNewCode] )
OUTPUT inserted.*
VALUES
( @AccountTransferLogId
, @BillingId
, @CompanyId
, @CustomerId
, @DepartmentId
, @StaffId
, @BilledAt
, @SalesAt
, @ClosingAt
, @DueAt
, @DueAt2nd
, @BillingAmount
, @InvoiceCode
, @Note1
, @TransferBankCode
, @TransferBankName
, @TransferBranchCode
, @TransferBranchName
, @TransferAccountTypeId
, @TransferAccountNumber
, @TransferAccountName
, @TransferCustomerCode
, @TransferNewCode )
";
#endregion
return(dbHelper.ExecuteAsync <AccountTransferDetail>(query, detail, token));
}
public override string GetDataRecord(AccountTransferDetail detail) => Join(
Dummy(),
detail.TransferCustomerCode,
decimal.Truncate(detail.BillingAmount),
detail.TransferBankCode,
detail.TransferBranchCode,
detail.TransferAccountTypeId,
detail.TransferAccountNumber,
detail.TransferAccountName,
detail.TransferNewCode,
Dummy(),
0,
Dummy(),
Dummy());
public override string GetDataRecord(AccountTransferDetail detail) => Join(
GetStrField(1, DivisionData),
GetNmbField(4, detail.TransferBankCode),
GetStrField(15, detail.TransferBankName),
GetNmbField(3, detail.TransferBranchCode),
GetStrField(15, detail.TransferBranchName),
GetStrField(4, Dummy()),
GetStrField(1, detail.TransferAccountTypeId),
GetNmbField(7, detail.TransferAccountNumber),
GetStrField(30, detail.TransferAccountName),
GetNmbField(10, decimal.Truncate(detail.BillingAmount)),
GetStrField(1, detail.TransferNewCode),
GetStrField(20, detail.TransferCustomerCode),
GetStrField(1, 0),
GetStrField(8, Dummy()));
public override string GetDataRecord(AccountTransferDetail detail) => Join(
DivisionData,
detail.TransferBankCode,
detail.TransferBankName,
detail.TransferBranchCode,
detail.TransferBranchName,
0,
detail.TransferAccountTypeId,
detail.TransferAccountNumber,
detail.TransferAccountName,
decimal.Truncate(detail.BillingAmount),
detail.TransferNewCode,
PaymentAgency.ConsigneeCode, /* 右6桁 */
detail.TransferCustomerCode, /* 左14桁 */
0,
Dummy());
public Task <Billing> UpdateAsync(AccountTransferDetail detail, CancellationToken token = default(CancellationToken))
{
var query = @"
UPDATE [dbo].[Billing]
SET [AccountTransferLogId] = @AccountTransferLogId
, [RequestDate] = CAST( GETDATE() AS DATE )
, [DueAt] = @NewDueAt
, [TransferOriginalDueAt] = CASE WHEN [TransferOriginalDueAt] IS NULL THEN [DueAt] ELSE [TransferOriginalDueAt] END
, [UpdateBy] = @CreateBy
, [UpdateAt] = GETDATE()
OUTPUT inserted.*
WHERE [Id] = @BillingId
AND [UpdateAt] = @BillingUpdateAt;"
.AppendIfNotAnyRowsAffectedThenRaiseError();
return(dbHelper.ExecuteAsync <Billing>(query, detail, token));
}
public virtual string GetDataRecord(AccountTransferDetail detail) => string.Empty;