public List <DataMap <string> > GetGroupCount <TOrderBy>(IList <QueryCondition> filter, QueryCondition groupBy)
{
Expression <Func <ArchiveInfo, bool> > f = LamdaExpressionHelper.BuildExpression <ArchiveInfo>(filter);
Expression <Func <ArchiveInfo, string> > g = LamdaExpressionHelper.BuildKeySelector <ArchiveInfo, string>(groupBy);
return(arvRepository.GetGroupCount <string>(f, g).ToList());
}
//按条件删除
public int DeleteRoleModules(List <QueryCondition> searchItems)
{
// 构建Lamda表达式
Expression <Func <RoleModuleDto, bool> > ep = LamdaExpressionHelper.BuildExpression <RoleModuleDto>(searchItems);
return(roleModuleRepository.Delete(searchItems));
}
/// <summary>
/// 按检索条件查找档案
/// </summary>
/// <param name="queryItems"></param>
/// <returns>记录集</returns>
public List <ArchiveInfo> FindArvs(IList <QueryCondition> queryItems)
{
// 构建Lamda表达式
Expression <Func <ArchiveInfo, bool> > ep = LamdaExpressionHelper.BuildExpression <ArchiveInfo>(queryItems);
return(arvRepository.Find(ep).ToList());
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="searchItems">查询条件</param>
/// <returns>结果集</returns>
public List <DataDict> FindDataDicts(IList <QueryCondition> searchItems)
{
// 构建查询条件的Lamda树表达式
Expression <Func <DataDict, bool> > ep = LamdaExpressionHelper.BuildExpression <DataDict>(searchItems);
// 立即返回数据库记录
return(dataDictRepository.Find(ep).ToList());
}
/// <summary>
/// 根据检索条件查找用户
/// </summary>
/// <param name="searchItems">检索条件</param>
/// <returns>用户集合</returns>
public List <User> FindUsers(List <QueryCondition> searchItems)
{
// 构建Lamda表达式
Expression <Func <User, bool> > ep = LamdaExpressionHelper.BuildExpression <User>(searchItems);
// 查找用户
return(userRepository.Find(ep).ToList());
}
/// <summary>
/// 查找档案盒
/// ToList()将立即执行数据库查询操作
/// </summary>
/// <param name="searchItems">查询条件</param>
/// <returns>查询结果集</returns>
public List <ArvBox> FindArvBoxes(IList <QueryCondition> queryItems)
{
if (queryItems == null)
{
// 查询条件为空，返回所有记录
return(arvBoxRepository.GetQueryable().ToList());
}
// 构建Lamda表达式
Expression <Func <ArvBox, bool> > ep = LamdaExpressionHelper.BuildExpression <ArvBox>(queryItems);
// 查询数据库
return(arvBoxRepository.Find(ep).ToList());
}
//public List<LogItem> GetLogItems(Expression<Func<LogItem, bool>> exp)
//{
// return logRepository.GetQueryable().Where(exp).ToList();
//}
public List <Log> GetLogItems(IList <QueryCondition> condition)
{
Expression <Func <Log, bool> > exp = LamdaExpressionHelper.BuildExpression <Log>(condition);
return(logRepository.GetQueryable().Where(exp).ToList());
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="searchItems">查询条件</param>
/// <returns>结果集</returns>
public List <FieldCfg> FindFieldCfgs(IList <QueryCondition> searchItems)
{
Expression <Func <FieldCfg, bool> > ep = LamdaExpressionHelper.BuildExpression <FieldCfg>(searchItems);
return(fieldTypeRepository.Find(ep).ToList());
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="searchItems">查询条件</param>
/// <returns>结果集</returns>
public List <Device> FindDevices(IList <QueryCondition> searchItems)
{
Expression <Func <Device, bool> > ep = LamdaExpressionHelper.BuildExpression <Device>(searchItems);
return(deviceRepository.Find(ep).ToList());
}
