/// <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;
using (var session = DbFactory.CreateSession())
{
var poDbSet = session.GetRepository <ProductOrderEntity>().GetDbSet();
var sqlQuery = (from vw in poDbSet
select vw);
if (query.Status > 0)
{
sqlQuery = sqlQuery.Where(e => e.Status == query.Status);
}
else if (!string.IsNullOrEmpty(query.RoleCode))
{
var status = GetStatusByRoleCode(query.RoleCode);
if (status < 6)
{
sqlQuery = sqlQuery.Where(e => e.Status == status);
}
else
{
sqlQuery = sqlQuery.Where(e => e.Status > status);
}
}
count = sqlQuery.Count();
list = sqlQuery.OrderByDescending(e => e.ID)
.Skip(query.PageIndex * query.PageSize)
.Take(query.PageSize)
.ToList();
return(list);
}
}
/// <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 (query.Status > 0)
{
predicate = Predicates.Field <ProductOrderEntity>(f => f.Status, DapperExtensions.Operator.Eq, query.Status);
}
else if (!string.IsNullOrEmpty(query.RoleCode))
{
var status = GetStatusByRoleCode(query.RoleCode);
if (status < 6)
{
predicate = Predicates.Field <ProductOrderEntity>(f => f.Status, DapperExtensions.Operator.Eq, status);
}
else
{
predicate = Predicates.Field <ProductOrderEntity>(f => f.Status, DapperExtensions.Operator.Ge, status);
}
}
count = QuickRepository.Count <ProductOrderEntity>(conn, predicate);
list = QuickRepository.GetPaged <ProductOrderEntity>(conn, query.PageIndex, query.PageSize,
predicate, sortList, false).ToList();
return(list);
}
catch (System.Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public ResponseResult <List <ProductOrderEntity> > QueryPaged([FromBody] ProductOrderQuery query)
{
var result = ResponseResult <List <ProductOrderEntity> > .Default();
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);
}
