/// <summary>
/// 排序
/// </summary>
/// <param name="list"></param>
/// <param name="sort"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
private List <Registry> SortToList(List <Registry> list, ModeBase.Sort sort, params string[] entityAttrs)
{
try
{
return(list.OrderBy(row => row.Id).ToList());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 汇总信息
/// </summary>
/// <param name="keyWord"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="status"></param>
/// <param name="sort"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
public SummaryEntity PageSummary(string keyWord, int pageIndex, int pageSize, DateTime startDate, DateTime endDate, ModeBase.Status status, ModeBase.Sort sort, params string[] entityAttrs)
{
try
{
// 返回
return(new SummaryEntity());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 分页计数
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="startDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="registry">状态</param>
/// <param name="sort">排序</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public int PageCount(string keyWord, DateTime startDate, DateTime endDate, ModeBase.Status status, ModeBase.Sort sort, params string[] entityAttrs)
{
try
{
// 定义
var list = SQLToList();
// keyWord查询
list = KeyWordToList(list, keyWord);
// keyWordExt查询
list = KeyWordExtToList(list, keyWord);
// status查询
list = StatusToList(list, status);
// 时间范围查询
list = DateToList(list, startDate, endDate);
// 返回
return(list.Count());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">每页显示数</param>
/// <param name="startDate">起始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="registry">状态</param>
/// <param name="sort">排序</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <Registry> Page(string keyWord, int pageIndex, int pageSize, DateTime startDate, DateTime endDate, ModeBase.Status status, ModeBase.Sort sort, params string[] entityAttrs)
{
try
{
// 定义
var list = SQLToList();
// keyWord查询
list = KeyWordToList(list, keyWord);
// keyWordExt查询
list = KeyWordExtToList(list, keyWord);
// status查询
list = StatusToList(list, status);
// 时间范围查询
list = DateToList(list, startDate, endDate);
// 排序
list = SortToList(list, sort);
// 分页
list = PageToList(list, pageIndex, pageSize);
// 返回
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 排序
/// </summary>
/// <param name="queryable"></param>
/// <param name="sort"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
private IQueryable <SQLEntity> SortQueryable(IQueryable <SQLEntity> queryable, ModeBase.Sort sort, params string[] entityAttrs)
{
try
{
if (sort.Name.ToLower().Equals("userid"))
{
if (sort.Mode.ToLower().Equals("asc"))
{
return(queryable.OrderBy(row => row.UserPower.UserId));
}
else
{
return(queryable.OrderByDescending(row => row.UserPower.UserId));
}
}
return(queryable);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 汇总信息
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">单页数据量</param>
/// <param name="startDate">开始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="status">状态</param>
/// <param name="sort">分页</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public SummaryEntity PageSummary(string keyWord, int pageIndex, int pageSize, DateTime startDate, DateTime endDate, ModeBase.Status status, ModeBase.Sort sort, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
// 定义
var queryable = SQLQueryable(context, entityAttrs);
// keyWord查询
queryable = KeyWordQueryable(queryable, keyWord, entityAttrs);
// keyWordExt查询
queryable = KeyWordExtQueryable(queryable, keyWord, entityAttrs);
// 日期查询
queryable = DateQueryable(queryable, startDate, endDate, entityAttrs);
// status查询
queryable = StatusQueryable(queryable, status, entityAttrs);
// 排序
queryable = SortQueryable(queryable, sort, entityAttrs);
// 分页
queryable = PageQueryable(queryable, pageIndex, pageSize, entityAttrs);
// 返回
return(new SummaryEntity());
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 分页计数
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="startDate">开始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="status">状态</param>
/// <param name="sort">分页</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public int PageCount(string keyWord, DateTime startDate, DateTime endDate, ModeBase.Status status, ModeBase.Sort sort, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
// 定义
var queryable = SQLQueryable(context, entityAttrs);
// keyWord查询
queryable = KeyWordQueryable(queryable, keyWord, entityAttrs);
// keyWordExt查询
queryable = KeyWordExtQueryable(queryable, keyWord, entityAttrs);
// 日期查询
queryable = DateQueryable(queryable, startDate, endDate, entityAttrs);
// status查询
queryable = StatusQueryable(queryable, status, entityAttrs);
// 排序
queryable = SortQueryable(queryable, sort, entityAttrs);
// 返回
return(queryable.Count());
}
catch (Exception ex)
{
throw ex;
}
}
}
