コード例 #1
0
        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));
        }
コード例 #2
0
ファイル: MUFJNicosExporter.cs プロジェクト: fwka1605/next
 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());
コード例 #3
0
 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()));
コード例 #4
0
ファイル: MizuhoAspExporter.cs プロジェクト: fwka1605/next
 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());
コード例 #5
0
        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));
        }
コード例 #6
0
 public virtual string GetDataRecord(AccountTransferDetail detail) => string.Empty;