/// <summary>
///
/// </summary>
/// <param name="list"></param>
/// <param name="status"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
private List <Registry> StatusToList(List <Registry> list, ModeBase.Status status, params string[] entityAttrs)
{
try
{
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 上一条
/// </summary>
/// <param name="id"></param>
/// <param name="keyWord"></param>
/// <param name="status"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
public Registry Prev(int id, string keyWord, ModeBase.Status status, params string[] entityAttrs)
{
try
{
// 定义
var list = SQLToList();
// keyWord查询
list = KeyWordToList(list, keyWord);
// keyWordExt查询
list = KeyWordExtToList(list, keyWord + "^Id<" + id);
// status查询
list = StatusToList(list, status);
// 返回结果
return(list.FirstOrDefault());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 末记录
/// </summary>
/// <param name="keyWord"></param>
/// <param name="status"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
public Dictionary Last(string keyWord, ModeBase.Status status, params string[] entityAttrs)
{
try
{
// 定义
var list = SQLToList();
// keyWord查询
list = KeyWordToList(list, keyWord);
// keyWordExt查询
list = KeyWordExtToList(list, keyWord);
// status查询
list = StatusToList(list, status);
// 返回结果
return(list.LastOrDefault());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 首记录
/// </summary>
/// <param name="keyWord"></param>
/// <param name="status"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
public Venue First(string keyWord, ModeBase.Status status, params string[] entityAttrs)
{
try
{
// 定义
var list = SQLToList();
// keyWord查询
list = KeyWordToList(list, keyWord);
// keyWordExt查询
list = KeyWordExtToList(list, keyWord);
// venue查询
list = StatusToList(list, status);
// 返回结果
return(SQLEntityToSingle(
list.FirstOrDefault()
));
}
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="status"></param>
/// <param name="entityAttrs"></param>
/// <returns></returns>
private IQueryable <SQLEntity> StatusQueryable(IQueryable <SQLEntity> queryable, ModeBase.Status status, params string[] entityAttrs)
{
try
{
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;
}
}
}
