public IPagedList <Order> OrderPagedList()
{
return(Try(nameof(OrderPagedList), () =>
{
var cmd = SqlBuilder.Select("*")
.From("orderinfo")
.ToCommand(1, 50);
var list = TradeConn.PagedList <Order>(1, 50, cmd);
var ids = list.Select(x => x.Id).Aggregate((a, b) => "'" + a + "','" + b + "'");
var sql = "select * from orderitem where orderid in(" + ids + ")";
var items = TradeConn.Query <OrderItem>(sql);
foreach (var o in list)
{
o.Items = items.Where(x => x.OrderId == o.Id).ToList();
}
return list;
}));
}
