EF 公共查询类

 

因需求忒多，所以自己拼接了下备忘。

 

/// <summary>
        /// 地区组合查询
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="db"></param>
        /// <returns></returns>
        public static Expression<Func<W_Brjcxx, bool>> W_BrjcxxToArea1(DB.BlContext db)
        {
            var predicate_Base = PredicateBuilder.False<W_Brjcxx>();
            if (RequestSession.GetSessionUser().UserAccount.ToString() != "admin")
            {
                int pageSize = 10;
                var DeptNo = RequestSession.GetSessionUser().DeptNo.ToString().Replace("'", "").Split(',').ToList();
                var list_Base_Organization = db.Base_Organization.Where(d => DeptNo.Contains(d.Organization_ID))
                                            .OrderBy(d => d.Organization_ID)
                                            //.Skip((1 - 1) * pageSize)
                                            //.Take(pageSize)
                                            .ToList();

                foreach (var model_Base_Organization in list_Base_Organization)
                {
                    var predicate_Base_Organization = PredicateBuilder.True<W_Brjcxx>();
                    var areas = model_Base_Organization.AreaLV.Split(',').ToList();
                    var city = areas.Count >= 1 ? areas[0] : "";
                    var county = areas.Count >= 2 ? areas[1] : "";
                    var town = areas.Count >= 3 ? areas[2] : "";
                    var community = areas.Count >= 4 ? areas[3] : "";

                    int whereCount = 0;

                    if (!string.IsNullOrWhiteSpace(city) && city != "请选择")
                    {
                        predicate_Base_Organization = predicate_Base_Organization.And(d => d.AreaID.Contains(city));
                        whereCount++;
                    }
                    if (!string.IsNullOrWhiteSpace(county) && county != "请选择")
                    {
                        predicate_Base_Organization = predicate_Base_Organization.And(d => d.AreaID.Contains(county));
                        whereCount++;
                    }
                    if (!string.IsNullOrWhiteSpace(town) && town != "请选择")
                    {
                        predicate_Base_Organization = predicate_Base_Organization.And(d => d.AreaID.Contains(town));
                        whereCount++;
                    }
                    if (!string.IsNullOrWhiteSpace(community) && community != "请选择")
                    {
                        predicate_Base_Organization = predicate_Base_Organization.And(d => d.AreaID.Contains(community));
                        whereCount++;
                    }
                    if (whereCount == 0)
                    {
                        predicate_Base_Organization = predicate_Base_Organization.And(d => d.AreaID == "此人没有设置任何所属区域");
                    }

                    predicate_Base = predicate_Base.Or(predicate_Base_Organization);                    
                }
                
            }
            return predicate_Base;
        }

 

 

//例子

                  
                    var xxx = Model.PublicPredicateBuilder.W_BrjcxxToArea1(context);
                    
                    
                    var sql_W_Brjcxx = context.W_Brjcxx.Where(predicate).Where(xxx);
                    var list = sql_W_Brjcxx.OrderBy(d => d.state)
                                            .ThenByDescending(d => d.LR_time)
                                            .Skip((PageControl1.PageIndex - 1) * PageControl1.PageSize)
                                            .Take(PageControl1.PageSize)
                                            .ToList();

 

转载于:https://www.cnblogs.com/OleRookie/p/8645725.html