public async Task <DataTables <OrderItemDTO> > GetItemsAsync(OrderItemQueryModel model)
{
var query = new GetOrderItemsQuery
{
PageSize = model.PageSize,
PageIndex = model.PageIndex,
OrderBy = model.OrderBy,
Draw = model.Draw,
Keyword = model.Keyword,
SortDirection = model.SortDirection,
OrderNo = model.OrderNo
};
query.SetContext(User.Identity);
var plist = await OrderItemDF.GetOrderItemsAsync(query).ConfigureAwait(false);
return(new DataTables <OrderItemDTO>(query.Draw, plist));
}
public Task <PagedList <OrderItemDTO> > GetOrderItemsAsync(GetOrderItemsQuery query)
{
var where = new StringBuilder();
where.AppendFormat($" AND OrderNo = '{query.OrderNo}'");
if (query.Keyword.IsPresent())
{
where.AppendFormat(" AND (SKU LIKE '%{0}%' OR ASIN LIKE '%{0}%')", query.Keyword);
}
string orderBy = "OrderNo";
//switch (query.OrderBy.GetValueOrDefault())
//{
// case 1:
// orderBy = "User_ID";
// break;
//}
orderBy += " " + query.SortDirection;
return(base.GetPagedListAsync <OrderItemDTO>(query.PageSize, query.PageIndex, "OrderItem", "*", where.ToString(), orderBy));
}
public async Task <PagedList <OrderItemDTO> > GetOrderItemsAsync(GetOrderItemsQuery query)
{
return(await OrderItemDAL.GetOrderItemsAsync(query).ConfigureAwait(false));
}
