public ResponseResult<List<ProductOrderEntity>> QueryPaged(ProductOrderQuery query)
{
var result = ResponseResult<List<ProductOrderEntity>>.Default();
var conn = SessionFactory.CreateConnection();
try
{
var count = 0;
var list = ProductOrderService.GetPaged(query, out count);
result = ResponseResult<List<ProductOrderEntity>>.Success(list);
result.TotalRowsCount = count;
result.TotalPages = (count + query.PageSize - 1) / query.PageSize;
}
catch (System.Exception ex)
{
result = ResponseResult<List<ProductOrderEntity>>.Error(
string.Format("获取{0}分页数据失败，错误{1}", "ProductOrder", ex.Message)
);
}
return result;
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="count">记录数</param>
/// <returns></returns>
public List<ProductOrderEntity> GetPaged(ProductOrderQuery query, out int count)
{
List<ProductOrderEntity> list = null;
var conn = SessionFactory.CreateConnection();
try
{
var sortList = new List<DapperExtensions.ISort>();
sortList.Add(new DapperExtensions.Sort { PropertyName = "ID", Ascending = false });
IFieldPredicate predicate = null;
if (!string.IsNullOrEmpty(query.OrderCode))
predicate = Predicates.Field<ProductOrderEntity>(f => f.OrderCode, Operator.Eq, query.OrderCode);
count = DBHelper.Count<ProductOrderEntity>(conn, predicate);
list = DBHelper.GetPaged<ProductOrderEntity>(conn, query.PageIndex, query.PageSize,
predicate, sortList, false).ToList();
return list;
}
catch (System.Exception)
{
throw;
}
finally
{
conn.Close();
}
}