public List <ItemBatchStockView> ListByBatchStock(Page <ItemBatchStockView> page, ref int count) { List <ItemBatchStockView> result = new List <ItemBatchStockView>(); if (page.Params.Count > 0) { Expression <Func <ItemBatchStockView, bool> > searchPredicate = PredicateExtensions.True <ItemBatchStockView>(); foreach (var param in page.Params) { switch (param.Key) { case "query": string query = param.Value; searchPredicate = searchPredicate.And(s => s.ItemId.ToString().Contains(query) || s.ItemName.Contains(query) || s.StoreName.Contains(query) || s.Code.Contains(query) || s.Barcode.Contains(query) || s.Brand.Contains(query)); break; case "brand": string brand = param.Value; searchPredicate = searchPredicate.And(s => s.Brand == brand); break; case "store_id": int store_id = int.Parse(param.Value); searchPredicate = searchPredicate.And(s => s.StoreId == store_id); break; case "item_id": int item_id = int.Parse(param.Value); searchPredicate = searchPredicate.And(s => s.ItemId == item_id); break; case "date_from": DateTime date_from = DateTime.Parse(param.Value); searchPredicate = searchPredicate.And(p => p.DateProduct.HasValue && p.DateProduct.Value >= date_from); break; case "date_to": DateTime date_to = DateTime.Parse(param.Value); searchPredicate = searchPredicate.And(p => p.DateProduct.HasValue && p.DateProduct.Value <= date_to); break; case "only_count": string only_count = param.Value; searchPredicate = searchPredicate.And(s => s.RealCount > 0); break; } } result = db.ItemBatchStockView.Where(searchPredicate).ToList(); } else { result = db.ItemBatchStockView.ToList(); } count = result.Count; result = result.OrderBy(o => o.DateProduct).Skip(page.Start).Take(page.Limit).ToList(); return(result); }
public IEnumerable <Menu> GetListByParent(MenuCondition menudition) { using (var repository = new Repository <Menu>()) { Expression <Func <Menu, bool> > where = PredicateExtensions.True <Menu>(); where = where.And(m => m.ParentId == null); return(repository.NoTrackingDbSet.Where(where)); } }
public static Predicate <T> AndAll <T> (IEnumerable <Predicate <T> > conditions) { Predicate <T> result = PredicateExtensions.True <T>(); foreach (Predicate <T> cond in conditions) { result = result.And <T>(cond); } return(result); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public List <Entity.DetailChannelInfo> getDetailChannelList(int enabled = 0) { var lambda = PredicateExtensions.True <Entity.DetailChannelInfo>(); if (enabled == 1) { lambda = lambda.And(g => g.Enabled == 1); } return(this.dbContext.DetailChannel.Where(lambda).ToList()); }
public Task <List <Admins> > userList(string key = null) { Expression <Func <Admins, bool> > express = PredicateExtensions.True <Admins>(); if (key != null) { express = express.And(n => n.UserName.Contains(key)); } return(_dbContext.Admins.AsNoTracking().Where(express).OrderByDescending(r => r.RegDate).ToListAsync()); }
public Task <PaginatedList <Pages> > GetPageList(int pageSize = 10, int pageIndex = 1, string keywords = "") { Expression <Func <Pages, bool> > express = PredicateExtensions.True <Pages>(); if (keywords != "") { express = express.And(n => n.Title.Contains(keywords) || n.PContent.Contains(keywords)); } return(PaginatedList <Pages> .CreateAsync(_dbContext.Pages.AsNoTracking().Where(express).OrderByDescending(o => o.RegDate), pageIndex, pageSize)); }
public List <Options> List(Page <Options> page, ref int count) { List <Options> result = new List <Options>(); if (page.Params.Count > 0) { Expression <Func <Dictionary, bool> > searchPredicate = PredicateExtensions.True <Dictionary>(); foreach (var param in page.Params) { switch (param.Key) { case "module": string str = param.Value; searchPredicate = searchPredicate.And(d => d.Module.ToLower().Contains(str.ToLower())); break; case "field": string str1 = param.Value; searchPredicate = searchPredicate.And(d => d.Field.ToLower().Contains(str1.ToLower())); break; case "table_name": string table_name = param.Value; searchPredicate = searchPredicate.And(d => d.TableName == table_name); break; case "record_id": int record_id = int.Parse(param.Value); searchPredicate = searchPredicate.And(d => d.RecordId == record_id); break; default: break; } } if (page.Params.ContainsKey("table_name")) { result = db.Dictionary.Where(searchPredicate).Select(d => new Options() { Id = d.OrderNo.Value, Key = d.Options, Value = d.Field }).ToList(); } else { result = db.Dictionary.Where(searchPredicate).Select(d => new Options() { Id = d.OrderNo.Value, Key = d.Options, Value = d.Options }).ToList(); } } count = result.Count; return(result); }
/// <summary> /// 获取全部角色 /// </summary> /// <returns></returns> public List <Entity.RoleInfo> getRoleEnabledList(string roletype = null) { var lambda = PredicateExtensions.True <Entity.RoleInfo>(); lambda = lambda.And(g => g.Lock == 0); if (!string.IsNullOrEmpty(roletype)) { lambda = lambda.And(g => g.RoleType.Equals(roletype)); } return(this.dbContext.Role.Where(lambda).OrderBy(g => g.OrderNo).ToList()); }
/// <summary> /// 根据角色类型获取最小阅读权限角色实体 /// </summary> /// <param name="roleid"></param> /// <returns></returns> public Entity.RoleInfo getRoleByReadPower(string roletype, int readpower) { var lambda = PredicateExtensions.True <Entity.RoleInfo>(); lambda = lambda.And(g => g.RoleType == roletype && g.Lock == 0); if (readpower > 0) { lambda = lambda.And(g => g.ReadPower >= readpower); } return(this.dbContext.Role.Where(lambda).OrderBy(g => g.ReadPower).FirstOrDefault()); }
/// <summary> /// 获取会员绑定账号 /// </summary> /// <param name="modulecode"></param> /// <param name="usercode"></param> /// <returns></returns> public Entity.UserBindInfo getUserBindInfo(string modulecode, string usercode) { var lambda = PredicateExtensions.True <Entity.UserBindInfo>(); lambda = lambda.And(g => g.UserCode.Equals(usercode)); if (!string.IsNullOrEmpty(modulecode)) { lambda = lambda.And(g => g.ModuleCode.Equals(modulecode)); } return(this.dbContext.UserBind.FirstOrDefault(lambda)); }
/// <summary> /// 获取列表 /// </summary> public List <ScoreEventInfo> getScoreEventList(int eventType) { var lambda = PredicateExtensions.True <Entity.ScoreEventInfo>(); lambda = lambda.And(g => g.Enabled == 1); if (eventType > -1) { lambda = lambda.And(g => g.EventType == eventType); } return(this.dbContext.ScoreEvent.Where(lambda).OrderByDescending(g => g.EventId).ToList()); }
/// <summary> /// 查询代列表 /// </summary> /// <param name="json"></param> /// <returns></returns> public JObject GetDlInfoList(vw_MallDLInfo mallDlInfo, Pagination page) { try { using (var db = new RepositoryBase()) { JObject ret = new JObject(); PaginationResult <List <vw_MallDLInfo> > ResultPage = new PaginationResult <List <vw_MallDLInfo> >(); Expression <Func <vw_MallDLInfo, bool> > expressions = PredicateExtensions.True <vw_MallDLInfo>(); if (mallDlInfo != null) { if (mallDlInfo.GameId != null && mallDlInfo.GameId > 0) { expressions = expressions.And(c => c.GameId == mallDlInfo.GameId); } if (mallDlInfo.GroupId != null && mallDlInfo.GroupId > 0) { expressions = expressions.And(c => c.GroupId == mallDlInfo.GroupId); } if (mallDlInfo.ServerId != null && mallDlInfo.ServerId > 0) { expressions = expressions.And(c => c.ServerId == mallDlInfo.ServerId); } if (!string.IsNullOrEmpty(mallDlInfo.DlType)) { expressions = expressions.And(c => c.DlType == mallDlInfo.DlType); } if (!string.IsNullOrEmpty(mallDlInfo.WorkerType)) { expressions = expressions.And(c => c.WorkerType == mallDlInfo.WorkerType); } if (!string.IsNullOrEmpty(mallDlInfo.DlNo)) { expressions = expressions.And(c => c.DlNo == mallDlInfo.DlNo); } ResultPage.datas = db.FindList(page, out page, expressions); ResultPage.pagination = page; } else { ResultPage.datas = db.FindList <vw_MallDLInfo>(page == null ? Pagination.GetDefaultPagination("GoodNo") : page).ToList(); } ret.Add(ResultInfo.Result, true); ret.Add(ResultInfo.Content, JToken.FromObject(ResultPage)); return(ret); } } catch (Exception ex) { throw new Exception(ex.Message + "处发生了错误!"); } }
public void PredicateExtensionBuildsOrExpressionWithTrue() { const string expected = "i => ((i > 5) OrElse True)"; Expression <Func <int, bool> > exp1 = i => i > 5; Expression <Func <int, bool> > trueExp = PredicateExtensions.True <int>(); Expression <Func <int, bool> > orExp = exp1.Or(trueExp); var results = _testArray.Where(orExp.Compile()); Assert.AreEqual(5, results.Count()); Assert.AreEqual(expected, orExp.ToString()); }
public void PredicateExtensionBuildsAndExpressionWithTrue() { const string expected = "i => ((i > 0) AndAlso True)"; Expression <Func <int, bool> > exp1 = i => i > 0; Expression <Func <int, bool> > trueExp = PredicateExtensions.True <int>(); Expression <Func <int, bool> > andExp = exp1.And(trueExp); var results = _testArray.Where(andExp.Compile()); Assert.AreEqual(5, results.Count()); Assert.AreEqual(expected, andExp.ToString()); }
/// <summary> /// 普通查询终端 /// </summary> /// <returns></returns> private string QueryNormal() { var exp = PredicateExtensions.True <TB_Terminal>(); if (!string.IsNullOrEmpty(data)) { exp = exp.And(a => a.Number.Contains(data) || a.Sim.Contains(data)); } exp = exp.And(a => a.Delete == false); var normal = TerminalInstance.FindList(exp).Take(10).ToList(); return(JsonConverter.ToJson(normal)); }
public OperateResult GetPagedMeberCardList(GetPagedMeberCardListViewModel viewModel) { //总记录数 int rowCount = 0; //当用户什么都没有输入的时候默认查询所有的 var query = PredicateExtensions.True <MemCards>(); //根据用户输入的参数信息实现多条件查询 if (!string.IsNullOrWhiteSpace(viewModel.CardId)) { query = query.And(e => e.MC_CardID == viewModel.CardId); } if (!string.IsNullOrWhiteSpace(viewModel.Name)) { query = query.And(e => e.MC_Name.Contains(viewModel.Name)); } if (!string.IsNullOrWhiteSpace(viewModel.Mobile)) { query = query.And(e => e.MC_Mobile == viewModel.Mobile); } if (viewModel.CardLevelId > 0) { query = query.And(e => e.CL_ID == viewModel.CardLevelId); } if (viewModel.State > 0) { query = query.And(e => e.MC_State == viewModel.State); } var pageData = GetList(viewModel.page, viewModel.rows, ref rowCount, query, e => e.MC_ID, false) .Select(e => new MeberCardListViewModel() { CardId = e.MC_CardID, CardLevelName = e.CardLevels.CL_LevelName, CreateTime = (DateTime)e.MC_CreateTime, Id = e.MC_ID, Mobile = e.MC_Mobile, Name = e.MC_Name, Point = (int)e.MC_Point, Sex = ((SexTypeEnum)e.MC_Sex).ToString(), State = ((CardStateTypeEnum)e.MC_State).ToString(), TotalMoney = (float)e.MC_TotalMoney }).AsQueryable().ToList(); var dataGridViewModel = new DataGridViewModel() { total = rowCount, rows = pageData }; return(new OperateResult(true, "", dataGridViewModel)); }
public List <Company> FindCompanyByPage(Page <Company> page, ref int count) { List <Company> result = new List <Company>(); if (page.Params.Count > 0) { if (page.Params.ContainsKey("type")) { string type = page.Params["type"]; if (type == "client") { Expression <Func <Client, bool> > searchPredicate = PredicateExtensions.True <Client>(); foreach (var param in page.Params) { switch (param.Key) { case "code": string code = param.Value; searchPredicate = searchPredicate.And(s => s.Code.Contains(code)); break; } } result = db.Client.Where(searchPredicate).Select(c => new Company() { Id = c.Id, Name = c.ClientName }).ToList(); } if (type == "supply") { Expression <Func <Supply, bool> > searchPredicate = PredicateExtensions.True <Supply>(); foreach (var param in page.Params) { switch (param.Key) { case "code": string code = param.Value; searchPredicate = searchPredicate.And(s => s.Code.Contains(code)); break; } } result = db.Supply.Where(searchPredicate).Select(c => new Company() { Id = c.Id, Name = c.SupplyName }).ToList(); } } } count = result.Count; result = result.OrderByDescending(o => o.Id).Skip(page.Start).Take(page.Limit).ToList(); return(result); }
/// <summary> /// 分页查询 /// </summary> public List <role> queryPage(role record) { int _total = 0; Expression <Func <role, bool> > whereLambda = PredicateExtensions.True <role>(); if (record.ID != null) { whereLambda.And(p => p.ID.Equals(record.ID)); } if (!String.IsNullOrEmpty(record.NAME)) { whereLambda.And(p => p.NAME.Equals(record.NAME)); } if (!String.IsNullOrEmpty(record.REMARK)) { whereLambda.And(p => p.REMARK.Equals(record.REMARK)); } if (!String.IsNullOrEmpty(record.DATA_SCOPE)) { whereLambda.And(p => p.DATA_SCOPE.Equals(record.DATA_SCOPE)); } if (record.LEVEL != null) { whereLambda.And(p => p.LEVEL.Equals(record.LEVEL)); } if (record.CREATE_TIME != null) { whereLambda.And(p => p.CREATE_TIME.Equals(record.CREATE_TIME)); } if (!String.IsNullOrEmpty(record.PERMISSION)) { whereLambda.And(p => p.PERMISSION.Equals(record.PERMISSION)); } return(LoadPageItems(5, 2, out _total, whereLambda, p => p.ID, true)); // return LoadPageItems(5, 2, out _total, whereLambda, p => p.id, true); }
// // GET: /Pager/ public ActionResult Index(int?page) { int currentPageIndex = page.HasValue ? page.Value - 1 : 0; IMembershipServiceInModule membershipService = DependencyResolver.Current.GetService <IMembershipServiceInModule>(); Pagination pagination = new Pagination(currentPageIndex); Expression <Func <UserEntity, bool> > pre = PredicateExtensions.True <UserEntity>(); var allUsers = membershipService.Fetch((x => ((x.NormalizedUserName == "" && x.Id == 1) || x.Password == "")), (x => x.Asc(d => d.Password, d => d.Password)), pagination); return(View(allUsers.ToPagedList(currentPageIndex, 5, 10))); }
public Task <PaginatedList <News> > GetNewsList(int pageSize = 10, int pageIndex = 1, string keywords = "", string category = "") { Expression <Func <News, bool> > express = PredicateExtensions.True <News>(); if (keywords != "") { express = express.And(n => n.Title.Contains(keywords) || n.NewsDetail.Contains(keywords)); } if (category != "") { express = express.And(n => n.ColumnID == int.Parse(category)); } return(PaginatedList <News> .CreateAsync(_dbContext.News.AsNoTracking().Where(express).OrderByDescending(o => o.RegDate), pageIndex, pageSize)); }
/// <summary> /// 查询绑定状态 /// </summary> /// <returns></returns> private string QueryBound() { var exp = PredicateExtensions.True <TB_Terminal>(); exp = exp.And(a => a.HasBound == ("bound" == cmd ? true : false)); if (!string.IsNullOrEmpty(data)) { exp = exp.And(a => a.Number.Contains(data) || a.Sim.Contains(data)); } exp = exp.And(a => a.Delete == false); var bound = TerminalInstance.FindList(exp).Take(10).ToList(); return(JsonConverter.ToJson(bound)); }
public IList <Activity_Activitys> SearchActivity(ActivityCondition condition, ref Paging paging) { CupcakeEntities db = new CupcakeEntities(); Expression <Func <Activity_Activitys, bool> > where = PredicateExtensions.True <Activity_Activitys>(); if (condition.ActityType != null) { where = where.And(n => n.ActityType == condition.ActityType); } where = where.And(n => n.IsDelete == false); paging.Total = db.Activity_Activitys.Where(n => n.ActityType == condition.ActityType).Count(); return(db.Activity_Activitys.Where(where).OrderBy(n => n.CreateDate) .Skip(paging.PageSize * paging.PageIndex) .Take(paging.PageSize).ToList()); }
private IQueryable <vw_name_in_user> GetData() { var predicate = PredicateExtensions.True <vw_name_in_user>(); if (!String.IsNullOrEmpty(name)) { predicate = predicate.And(c => c.name.Equals(name)); } if (!String.IsNullOrEmpty(userName)) { predicate = predicate.And(c => c.UserName.Equals(userName)); } return(dc.vw_name_in_users.Where(predicate).OrderByDescending(c => c.name)); }
/// <summary> /// 根据角色类型获取最小阅读权限角色实体 /// </summary> /// <param name="roleid"></param> /// <returns></returns> public Entity.RoleInfo getRoleByScore(string roletype, int score) { var lambda = PredicateExtensions.True <Entity.RoleInfo>(); lambda = lambda.And(g => g.RoleType == roletype && g.Lock == 0); if (score > 0) { lambda = lambda.And(g => g.MinScore <= score); return(this.dbContext.Role.Where(lambda).OrderByDescending(g => g.MinScore).FirstOrDefault()); } else { return(this.dbContext.Role.Where(lambda).OrderBy(g => g.MinScore).FirstOrDefault()); } }
private IQueryable <businessPartner> GetData() { var predicate = PredicateExtensions.True <businessPartner>(); if (!String.IsNullOrEmpty(bpCode)) { predicate = predicate.And(c => c.bpCode.Equals(bpCode)); } predicate = predicate.And(c => c.bpMother.Equals(null)); predicate = predicate.And(c => c.bpType.Equals("C")); predicate = predicate.And(c => !c.isMother); return(dc.businessPartners.Where(predicate).OrderBy(c => Convert.ToInt32(c.bpCode))); }
public IList <Menu> GetListByCondition(MenuCondition menudition, ref Paging paging) { using (var repository = new Repository <Menu>()) { Expression <Func <Menu, bool> > where = PredicateExtensions.True <Menu>(); if (!string.IsNullOrEmpty(menudition.MenuName)) { where = where.And(u => u.Name == menudition.MenuName); } if (menudition.ParentMenuID != null) { where = where.And(u => u.ParentId == new Guid(menudition.ParentMenuID)); } return(repository.GetPaged(ref paging, where, m => m.Sort, false).ToList()); } }
/// <summary> /// 获取项目Id /// </summary> /// <param name="fatherid"></param> /// <returns></returns> public List <Entity.ItemInfo> getItemList(string code, int fahterid, int show) { var lambda = PredicateExtensions.True <Entity.ItemInfo>(); lambda = lambda.And(g => g.ChannelCode == code); if (fahterid > -1) { lambda = lambda.And(g => g.FatherId == fahterid); } if (show > -1) { lambda = lambda.And(g => (g.Show & show) == show); } return(this.dbContext.Item.Where(lambda).OrderBy(g => g.OrderNo).ToList()); }
/// <summary> /// 检查会员 /// </summary> /// <param name="username"></param> /// <param name="userid"></param> /// <returns></returns> public int checkUserName(string username, int userid = -1) { var config = Config.SiteConfig.load(); var lambda = PredicateExtensions.True <Entity.UserViewInfo>(); lambda = lambda.And(g => g.UserName.Equals(username)); if (userid > 0) { lambda = lambda.And(g => g.UserId != userid); } if (config.DuplicationUserName) { lambda = lambda.And(g => g.RoleType == "admin"); } return(this.dbContext.UserView.Where(lambda).Count()); }
private IQueryable <businessPartner> GetData() { var predicate = PredicateExtensions.True <businessPartner>(); if (!String.IsNullOrEmpty(bpName)) { predicate = predicate.And(c => c.bpName.Equals(bpName)); } if (!String.IsNullOrEmpty(bpCode)) { predicate = predicate.And(c => c.bpCode.Equals(bpCode)); } return(dc.businessPartners.Where(predicate).OrderByDescending(c => c.bpName)); }
public List <Purchase> FindByPage(Page <Purchase> page, ref int count) { List <Purchase> result = new List <Purchase>(); if (page.Params.Count > 0) { Expression <Func <Purchase, bool> > searchPredicate = PredicateExtensions.True <Purchase>(); string type = page.Params.ContainsKey("type") ? page.Params["type"] : ""; foreach (var param in page.Params) { switch (param.Key) { case "query": string query = param.Value; if (type == "明细") { List <int?> ids = db.PurchaseItem.Where(i => i.ItemId.ToString().Contains(query) || i.ItemNo.Contains(query) || i.ItemName.Contains(query) || i.MissProcess.Contains(query) || i.Remark.Contains(query)).Select(i => i.PurchaseId).ToList(); searchPredicate = searchPredicate.And(s => ids.Contains(s.Id)); } else { searchPredicate = searchPredicate.And(s => s.Id.ToString().Contains(query) || s.SupplyName.Contains(query) || s.Status.Contains(query) || s.AddName.Contains(query) || s.CheckName.Contains(query) || s.ApproveName.Contains(query) || s.Remark.Contains(query)); } break; case "date_from": DateTime date_from = DateTime.Parse(param.Value); searchPredicate = searchPredicate.And(p => p.DateAdded.HasValue && p.DateAdded.Value >= date_from); break; case "date_to": DateTime date_to = DateTime.Parse(param.Value); searchPredicate = searchPredicate.And(p => p.DateAdded.HasValue && p.DateAdded.Value <= date_to); break; } } result = db.Purchase.Where(searchPredicate).ToList(); } else { result = db.Purchase.ToList(); } count = result.Count; result = result.OrderByDescending(o => o.Id).Skip(page.Start).Take(page.Limit).ToList(); return(result); }