/// <summary>
/// 获取跨库查询所需的表达式
/// </summary>
/// <returns></returns>
protected override DisPageEntity <LogEntity> GetDisPageEntity(LogEntityParams paramz)
{
DisPageEntity <LogEntity> disPageEntity = new DisPageEntity <LogEntity>();
LogEntityOrderBy orderBy = paramz.orderByAsc;
if (orderBy != null)
{
disPageEntity.OrderType = true;
if (orderBy.id)
{
disPageEntity.OrderCol = a => a.Id;
disPageEntity.OrderColLazy = a => a.Id;
return(disPageEntity);
}
if (orderBy.createDate)
{
disPageEntity.OrderCol = a => a.CreateDate;
disPageEntity.OrderColLazy = a => a.CreateDate;
return(disPageEntity);
}
if (orderBy.level)
{
disPageEntity.OrderCol = a => a.Level;
disPageEntity.OrderColLazy = a => a.Level;
return(disPageEntity);
}
if (orderBy.threadNo)
{
disPageEntity.OrderCol = a => a.ThreadNo;
disPageEntity.OrderColLazy = a => a.ThreadNo;
return(disPageEntity);
}
if (orderBy.message)
{
disPageEntity.OrderCol = a => a.Message;
disPageEntity.OrderColLazy = a => a.Message;
return(disPageEntity);
}
if (orderBy.projectName)
{
disPageEntity.OrderCol = a => a.ProjectName;
disPageEntity.OrderColLazy = a => a.ProjectName;
return(disPageEntity);
}
if (orderBy.typeName)
{
disPageEntity.OrderCol = a => a.TypeName;
disPageEntity.OrderColLazy = a => a.TypeName;
return(disPageEntity);
}
if (orderBy.funcName)
{
disPageEntity.OrderCol = a => a.FuncName;
disPageEntity.OrderColLazy = a => a.FuncName;
return(disPageEntity);
}
if (orderBy.exception)
{
disPageEntity.OrderCol = a => a.Exception;
disPageEntity.OrderColLazy = a => a.Exception;
return(disPageEntity);
}
}
disPageEntity.OrderType = false;
orderBy = paramz.orderByDesc;
if (orderBy != null)
{
if (orderBy.id)
{
disPageEntity.OrderCol = a => a.Id;
disPageEntity.OrderColLazy = a => a.Id;
return(disPageEntity);
}
else
if (orderBy.createDate)
{
disPageEntity.OrderCol = a => a.CreateDate;
disPageEntity.OrderColLazy = a => a.CreateDate;
return(disPageEntity);
}
else
if (orderBy.level)
{
disPageEntity.OrderCol = a => a.Level;
disPageEntity.OrderColLazy = a => a.Level;
return(disPageEntity);
}
else
if (orderBy.threadNo)
{
disPageEntity.OrderCol = a => a.ThreadNo;
disPageEntity.OrderColLazy = a => a.ThreadNo;
return(disPageEntity);
}
else
if (orderBy.message)
{
disPageEntity.OrderCol = a => a.Message;
disPageEntity.OrderColLazy = a => a.Message;
return(disPageEntity);
}
else
if (orderBy.projectName)
{
disPageEntity.OrderCol = a => a.ProjectName;
disPageEntity.OrderColLazy = a => a.ProjectName;
return(disPageEntity);
}
else
if (orderBy.typeName)
{
disPageEntity.OrderCol = a => a.TypeName;
disPageEntity.OrderColLazy = a => a.TypeName;
return(disPageEntity);
}
else
if (orderBy.funcName)
{
disPageEntity.OrderCol = a => a.FuncName;
disPageEntity.OrderColLazy = a => a.FuncName;
return(disPageEntity);
}
else
if (orderBy.exception)
{
disPageEntity.OrderCol = a => a.Exception;
disPageEntity.OrderColLazy = a => a.Exception;
return(disPageEntity);
}
else
{
disPageEntity.OrderCol = a => a.Id;
disPageEntity.OrderColLazy = a => a.Id;
return(disPageEntity);
}
}
else
{
disPageEntity.OrderCol = a => a.Id;
disPageEntity.OrderColLazy = a => a.Id;
return(disPageEntity);
}
}
/// <summary>
/// 升序、降序排序的查询参数设置，当对应字段的升序设置为true时才会对
/// 该字段降序。
/// </summary>
/// <param name="query">待设置降序参数的query对象</param>
/// <param name="orderBy">装载降序参数的实体类</param>
/// <returns>返回设置好降序参数的query对象</returns>
IQueryable <LogEntity> OrderBy(IQueryable <LogEntity> query, LogEntityParams eqArgs)
{
LogEntityOrderBy orderBy = eqArgs.orderByAsc;
if (orderBy != null)
{
if (orderBy.id)
{
return(query = query.OrderBy(a => a.Id));
}
else
if (orderBy.createDate)
{
return(query = query.OrderBy(a => a.CreateDate));
}
else
if (orderBy.level)
{
return(query = query.OrderBy(a => a.Level));
}
else
if (orderBy.threadNo)
{
return(query = query.OrderBy(a => a.ThreadNo));
}
else
if (orderBy.message)
{
return(query = query.OrderBy(a => a.Message));
}
else
if (orderBy.projectName)
{
return(query = query.OrderBy(a => a.ProjectName));
}
else
if (orderBy.typeName)
{
return(query = query.OrderBy(a => a.TypeName));
}
else
if (orderBy.funcName)
{
return(query = query.OrderBy(a => a.FuncName));
}
else
if (orderBy.exception)
{
return(query = query.OrderBy(a => a.Exception));
}
else
if (orderBy.username)
{
return(query = query.OrderBy(a => a.Username));
}
}
orderBy = eqArgs.orderByDesc;
if (orderBy != null)
{
if (orderBy.id)
{
return(query = query.OrderByDescending(a => a.Id));
}
else
if (orderBy.createDate)
{
return(query = query.OrderByDescending(a => a.CreateDate));
}
else
if (orderBy.level)
{
return(query = query.OrderByDescending(a => a.Level));
}
else
if (orderBy.threadNo)
{
return(query = query.OrderByDescending(a => a.ThreadNo));
}
else
if (orderBy.message)
{
return(query = query.OrderByDescending(a => a.Message));
}
else
if (orderBy.projectName)
{
return(query = query.OrderByDescending(a => a.ProjectName));
}
else
if (orderBy.typeName)
{
return(query = query.OrderByDescending(a => a.TypeName));
}
else
if (orderBy.funcName)
{
return(query = query.OrderByDescending(a => a.FuncName));
}
else
if (orderBy.exception)
{
return(query = query.OrderByDescending(a => a.Exception));
}
else
if (orderBy.username)
{
return(query = query.OrderByDescending(a => a.Username));
}
else
{
return(query = query.OrderByDescending(a => a.Id));
}
}
else
{
return(query = query.OrderByDescending(a => a.Id));
}
}
