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()); }