public Task <IEnumerable <KanaHistoryCustomer> > GetAsync(KanaHistorySearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT kh.*
, cs.Code CustomerCode
, cs.Name CustomerName
FROM KanaHistoryCustomer kh
INNER JOIN Customer cs ON cs.Id = kh.CustomerId
WHERE kh.CompanyId = @CompanyId";
if (!string.IsNullOrWhiteSpace(option.PayerName))
{
option.PayerName = Sql.GetWrappedValue(option.PayerName);
query += @"
AND kh.PayerName LIKE @PayerName";
}
if (!string.IsNullOrWhiteSpace(option.CodeFrom))
{
query += @"
AND cs.Code >= @CodeFrom";
}
if (!string.IsNullOrWhiteSpace(option.CodeTo))
{
query += @"
AND cs.Code <= @CodeTo";
}
query += @"
ORDER BY cs.Code ASC
, kh.PayerName ASC";
return(dbHelper.GetItemsAsync <KanaHistoryCustomer>(query, option, token));
}
public Task <IEnumerable <KanaHistoryPaymentAgency> > GetAsync(KanaHistorySearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT kh.*
, pa.Code PaymentAgencyCode
, pa.Name PaymentAgencyName
FROM KanaHistoryPaymentAgency kh
INNER JOIN PaymentAgency pa ON pa.Id = kh.PaymentAgencyId
WHERE kh.CompanyId = @CompanyId";
if (!string.IsNullOrWhiteSpace(option.PayerName))
{
option.PayerName = Sql.GetWrappedValue(option.PayerName);
query += @"
AND kh.PayerName LIKE @PayerName";
}
if (!string.IsNullOrWhiteSpace(option.CodeFrom))
{
query += @"
AND pa.Code >= @CodeFrom";
}
if (!string.IsNullOrWhiteSpace(option.CodeTo))
{
query += @"
AND pa.Code <= @CodeTo";
}
query += @"
ORDER BY pa.Code ASC
, kh.PayerName ASC";
return(dbHelper.GetItemsAsync <KanaHistoryPaymentAgency>(query, option, token));
}
public async Task <ActionResult <IEnumerable <KanaHistoryCustomer> > > GetItems(KanaHistorySearch option, CancellationToken token) => (await kanaHistoryCustomerProcessor.GetAsync(option, token)).ToArray();
public async Task <IEnumerable <KanaHistoryCustomer> > GetAsync(KanaHistorySearch option, CancellationToken token = default(CancellationToken)) => await kanaHistoryCustomerQueryProcessor.GetAsync(option, token);
public async Task <IEnumerable <KanaHistoryPaymentAgency> > GetItems(KanaHistorySearch option, CancellationToken token) => (await kanaHistoryPaymentAgencyProcessor.GetAsync(option, token)).ToArray();
