예제 #1
0
        public List <VHelpArea> SearchMyInfoByWhere(GetMyListViewModel VSearchModel)
        {
            //查询条件
            var predicate = WhereExtension.True <VHelpArea>();//初始化where表达式

            // 不显示 已删除的信息 20191111
            predicate = predicate.And(p => !p.Status.Equals("3"));
            if (!String.IsNullOrEmpty(VSearchModel.CommunityID))
            {
                predicate = predicate.And(p => p.CommunityID.Contains(VSearchModel.CommunityID));
            }
            if (!String.IsNullOrEmpty(VSearchModel.TypeIDs))
            {
                predicate = predicate.And(p => p.TypeID.Contains(VSearchModel.TypeIDs));
            }
            if (!String.IsNullOrEmpty(VSearchModel.Status))
            {
                predicate = predicate.And(p => p.Address.Contains(VSearchModel.Status));
            }

            var result = DbSet.Where(predicate)
                         .OrderByDescending(o => o.CreateDate).ToList();

            return(result);
        }
        //根据条件查询用户
        private Expression <Func <VolunteerActivity, bool> > SearchVAWhere(VolunteerActivitySearchViewModel VSearchViewModel)
        {
            var predicate = WhereExtension.True <VolunteerActivity>();//初始化where表达式

            if (!String.IsNullOrEmpty(VSearchViewModel.ID))
            {
                predicate = predicate.And(p => p.ID.Contains(VSearchViewModel.ID));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.Title))
            {
                predicate = predicate.And(p => p.Title.Contains(VSearchViewModel.Title));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.CommunityID))
            {
                predicate = predicate.And(p => p.CommunityID.Contains(VSearchViewModel.CommunityID));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.Address))
            {
                predicate = predicate.And(p => p.Address.Contains(VSearchViewModel.Address));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.TypeIDs))
            {
                predicate = predicate.And(p => p.TypeIDs.Contains(VSearchViewModel.TypeIDs));
            }

            return(predicate);
        }
        //根据条件查询
        public List <VolunteerActivity> SearchInfoByWhere(AllSearchViewModel VSearchViewModel)
        {
            //查询条件
            var predicate = WhereExtension.True <VolunteerActivity>();//初始化where表达式

            // 不显示 已删除的信息 status=0  (20191128)
            predicate = predicate.And(p => !p.Status.Equals("0"));

            predicate = predicate.And(p => (p.Title.Contains(VSearchViewModel.Title) || p.Community.Contains(VSearchViewModel.Community) || p.Address.Contains(VSearchViewModel.Address) || p.Type.Contains(VSearchViewModel.Type)));


            if (!String.IsNullOrEmpty(VSearchViewModel.Status))
            {
                predicate = predicate.And(p => (p.Status.Equals(VSearchViewModel.Status)));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.CommunityID))
            {
                predicate = predicate.And(p => p.CommunityID.Equals(VSearchViewModel.CommunityID));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.TypeID))
            {
                predicate = predicate.And(p => p.TypeIDs.Equals(VSearchViewModel.TypeID));
            }

            var result = DbSet.Where(predicate)
                         .OrderByDescending(o => o.CreateDate).ToList();

            return(result);
        }
        private Expression <Func <ResidentInfo, bool> > SearchUnderAgeWhere(UnderAgerSearchViewModel underAgerSearchViewModel)
        {
            var predicate = WhereExtension.True <ResidentInfo>();//初始化where表达式

            if (underAgerSearchViewModel.Area != "")
            {
                predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.Area.Equals(underAgerSearchViewModel.Area));
            }
            if (underAgerSearchViewModel.Name != "")
            {
                predicate = predicate.And(p => p.Name.Equals(underAgerSearchViewModel.Name));
            }

            //根据出生年月范围查询
            if (underAgerSearchViewModel.StartTime != null)
            {
                predicate = predicate.And(p => DateTime.ParseExact(p.IdNumber.Substring(6, 8), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture) >= underAgerSearchViewModel.StartTime);
            }
            if (underAgerSearchViewModel.EndTime != null)
            {
                predicate = predicate.And(p => DateTime.ParseExact(p.IdNumber.Substring(6, 8), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture) <= underAgerSearchViewModel.EndTime);
            }

            predicate = predicate.And(p => (Convert.ToInt32(DateTime.Now.Year.ToString()) - Convert.ToInt32(p.IdNumber.Substring(6, 4))) < 18);
            predicate = predicate.And(p => p.Status == "1");


            return(predicate);
        }
        private Expression <Func <Inform, bool> > SearchInformWhere(InformSearchViewModel informSearchViewModel)
        {
            var predicate = WhereExtension.True <Inform>();//初始化where表达式

            if (informSearchViewModel.StartTime != null)
            {
                predicate = predicate.And(p => p.SendTime > informSearchViewModel.StartTime);
            }
            if (informSearchViewModel.EndTime != null)
            {
                predicate = predicate.And(p => p.SendTime < informSearchViewModel.EndTime);
            }
            if (informSearchViewModel.Sender != "")
            {
                predicate = predicate.And(p => p.Sender.Contains(informSearchViewModel.Sender));
            }
            if (informSearchViewModel.Title != "")
            {
                predicate = predicate.And(p => p.InformTitle.Contains(informSearchViewModel.Title));
            }
            if (informSearchViewModel.Status == "1")
            {
                predicate = predicate.And(p => p.Status == "1");
            }
            if (informSearchViewModel.Status == "2")
            {
                predicate = predicate.And(p => p.Status == "2");
            }
            if (informSearchViewModel.Status == "3")
            {
                predicate = predicate.And(p => p.Status != "0");
            }

            return(predicate);
        }
예제 #6
0
        private Expression <Func <ResidentInfo, bool> > SearchStatisticsWhere(StatisticsViewModel statisticsViewModel)
        {
            var predicate = WhereExtension.True <ResidentInfo>();//初始化where表达式

            //小区名字
            if (statisticsViewModel.Name != null)
            {
                predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.Area.Equals(statisticsViewModel.Name));
            }
            //性别
            if (statisticsViewModel.Gender != null)
            {
                predicate = predicate.And(p => p.Gender.Equals(statisticsViewModel.Gender));
            }

            //起始年龄
            if (statisticsViewModel.StartAge != 0)
            {
                predicate = predicate.And(p => Convert.ToInt32(DateTime.Now.Year.ToString()) - Convert.ToInt32(p.IdNumber.Substring(6, 4)) > (statisticsViewModel.StartAge));
            }
            //结束年龄
            if (statisticsViewModel.EndAge != 0)
            {
                predicate = predicate.And(p => Convert.ToInt32(DateTime.Now.Year.ToString()) - Convert.ToInt32(p.IdNumber.Substring(6, 4)) <= (statisticsViewModel.EndAge));
            }

            return(predicate);
        }
예제 #7
0
        //根据条件查询报修
        private Expression <Func <Flow_Node, bool> > SearchByRepairWhere(FlowNodeByRepairIdSearchViewModel flowNodeByRepairIdSearchViewModel)
        {
            var predicate = WhereExtension.True <Flow_Node>();//初始化where表达式

            predicate = predicate.And(p => p.Repair_InfoId == flowNodeByRepairIdSearchViewModel.Repair_InfoId);
            return(predicate);
        }
예제 #8
0
        public Expression <Func <Except_Info_Employ, bool> > GetByModelWhere(ExceptEmploySearchViewModel exceptEmploySearchViewModel)
        {
            var predicate = WhereExtension.True <Except_Info_Employ>();//初始化where表达式SchoolName

            //姓
            if (!exceptEmploySearchViewModel.SchoolCode.Equals(""))
            {
                predicate = predicate.And(p => p.facultystaff_Info.SchoolCode.Contains(exceptEmploySearchViewModel.SchoolCode));
            }
            if (!exceptEmploySearchViewModel.DepartCode.Equals(""))
            {
                predicate = predicate.And(p => p.facultystaff_Info.DepartCode.Contains(exceptEmploySearchViewModel.DepartCode));
            }
            if (!exceptEmploySearchViewModel.StaffCode.Equals(""))
            {
                predicate = predicate.And(p => p.facultystaff_Info.StaffCode.Contains(exceptEmploySearchViewModel.StaffCode));
            }
            if (!exceptEmploySearchViewModel.CreateDate.Equals(""))
            {
                predicate = predicate.And(p => p.CreateDate.ToString().Contains(exceptEmploySearchViewModel.CreateDate));
            }
            if (!exceptEmploySearchViewModel.Name.Equals(""))
            {
                predicate = predicate.And(p => p.Name.Contains(exceptEmploySearchViewModel.Name));
            }
            if (!exceptEmploySearchViewModel.Temperature.Equals(""))
            {
                predicate = predicate.And(p => p.Temperature.Contains(exceptEmploySearchViewModel.Temperature));
            }
            return(predicate);
        }
예제 #9
0
        public bool GetByParas(string uid, string OndutyClaims_InfoId, DateTime?StartDutyTime, DateTime?EndDutyTime)
        {
            var predicate = WhereExtension.True <MydutyClaim_Info>();//初始化where表达式

            if (!string.IsNullOrEmpty(uid))
            {
                predicate = predicate.And(p => p.Userid.Equals(uid));
            }
            if (!string.IsNullOrEmpty(OndutyClaims_InfoId))
            {
                predicate = predicate.And(p => p.OndutyClaims_InfoId.Equals(OndutyClaims_InfoId));
            }
            predicate = predicate.And(p => p.StartDutyTime.Equals(StartDutyTime));
            predicate = predicate.And(p => p.EndDutyTime.Equals(EndDutyTime));
            var result = DbSet.Where(predicate).OrderBy(a => a.CreateDate).ToList();

            if (result.Count > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #10
0
        public List <Student_DayandNight_Info> CheckDayAndNightList(string IdNumber, string GradeName, string IsComeSchool, string Name, string SchoolName, string Temperature, string AddTimeInterval, string AddCreateDate)
        {
            //查询条件
            var predicate = WhereExtension.True <Student_DayandNight_Info>();//初始化where表达式

            predicate = predicate.And(p => p.IdNumber.Contains(IdNumber));
            predicate = predicate.And(p => p.GradeName.Contains(GradeName));
            predicate = predicate.And(p => p.Name.Contains(Name));
            predicate = predicate.And(p => p.SchoolName.Contains(SchoolName));
            predicate = predicate.And(p => p.AddTimeInterval.Contains(AddTimeInterval));
            if (AddCreateDate != null && !AddCreateDate.Equals(""))
            {
                predicate = predicate.And(p => p.AddCreateDate >= Convert.ToDateTime(Convert.ToDateTime(AddCreateDate).ToString("yyyy-MM-dd 00:00:00")) && p.AddCreateDate <= Convert.ToDateTime(Convert.ToDateTime(AddCreateDate).ToString("yyyy-MM-dd 23:59:59")));
            }
            var result = Db.Student_DayandNight_Info.Where(predicate).ToList();

            if (result.Count > 0)
            {
                return(result);
            }
            else
            {
                return(null);
            }
        }
예제 #11
0
        public Expression <Func <Student_DayandNight_Info, bool> > GetByModelChildWhereYEY(String ClassName)
        {
            var predicate = WhereExtension.True <Student_DayandNight_Info>();//初始化where表达式SchoolName

            predicate = predicate.And(p => p.ClassName == ClassName);
            return(predicate);
        }
        //根据条件活动
        private Expression <Func <Activity, bool> > SearchActivityWhere(ActivitySearchViewModel activitySearchViewModel)
        {
            var predicate = WhereExtension.True <Activity>();//初始化where表达式

            //predicate = predicate.And(p => p.Name.ToString().Contains(buildingSearchViewModel.Name.ToString()));

            if (activitySearchViewModel.Title != "")
            {
                predicate = predicate.And(p => p.Title.Contains(activitySearchViewModel.Title));
            }
            if (activitySearchViewModel.StartTime != null)
            {
                predicate = predicate.And(p => activitySearchViewModel.StartTime < p.StartTime);
            }
            if (activitySearchViewModel.EndTime != null)
            {
                predicate = predicate.And(p => p.StartTime < activitySearchViewModel.EndTime);
            }
            if (activitySearchViewModel.Recorder != "")
            {
                predicate = predicate.And(p => p.Recorder.Contains(activitySearchViewModel.Recorder));
            }
            //predicate = predicate.And(p => p.ConstructionTime.ToString().c);

            predicate = predicate.And(p => p.Status == "1");
            return(predicate);
        }
        public LoginType_Log SearchByUIDModel(SearchByVIDModel user)
        {
            var res = new LoginType_Log();
            //查询条件
            var predicate = WhereExtension.True <LoginType_Log>();//初始化where表达式

            //status='true'  为有效登录方式信息
            predicate = predicate.And(p => p.status.Contains("true"));
            if (!String.IsNullOrEmpty(user.VID))
            {
                predicate = predicate.And(p => p.uid.Contains(user.VID));
            }
            var result = DbSet.Where(predicate).OrderByDescending(p => p.CreateDate).ToList();

            if (result.Count != 0)
            {
                res = result.First();
            }
            else
            {
                res = null;
            }

            return(res);
        }
        //志愿者互助信息退出功能 (互助ID标识ContentID、志愿者唯一VID、擅长技能TypeID为空不传参数)
        public string SetStatusBack(string VID, string ContentID)
        {
            string   status = string.Empty;
            VHA_Sign res    = new VHA_Sign();
            //查询条件
            var predicate = WhereExtension.True <VHA_Sign>();//初始化where表达式

            if (!String.IsNullOrEmpty(VID))
            {
                predicate = predicate.And(p => p.VID.Equals(VID));
            }
            if (!String.IsNullOrEmpty(ContentID))
            {
                predicate = predicate.And(p => p.ContentID.Equals(ContentID));
            }
            var result = DbSet.Where(predicate).OrderByDescending(o => o.CreateDate).ToList();

            if (result.Count > 0)
            {
                res        = result.First();
                res.Status = "3";
                Update(res);
                int a = SaveChanges();
                if (a > 0)
                {
                    status = "success";
                }
                else
                {
                    status = "fail";
                }
            }
            return(status);
        }
예제 #15
0
        //根据条件查小区
        #region 查询条件

        private Expression <Func <ResidentialArea, bool> > SearchAreaWhere(AreaSearchViewModel areaSearchViewModel)
        {
            var predicate = WhereExtension.True <ResidentialArea>();//初始化where表达式

            if (areaSearchViewModel.Id != null)
            {
                predicate = predicate.And(p => p.Id.Equals(areaSearchViewModel.Id));
            }
            if (areaSearchViewModel.Name != "")
            {
                predicate = predicate.And(p => p.Name.ToString().Contains(areaSearchViewModel.Name.ToString()));
            }

            if (areaSearchViewModel.Developers != "")
            {
                predicate = predicate.And(p => p.Developers.Contains(areaSearchViewModel.Developers));
            }
            if (areaSearchViewModel.ConstructionTimeStart != null)
            {
                predicate = predicate.And(p => p.ConstructionTime > (areaSearchViewModel.ConstructionTimeStart));
            }
            if (areaSearchViewModel.ConstructionTimeEnd != null)
            {
                predicate = predicate.And(p => p.ConstructionTime < (areaSearchViewModel.ConstructionTimeEnd));
            }
            predicate = predicate.And(p => p.Status == "1");

            return(predicate);
        }
예제 #16
0
        //根据条件查询班车
        private Expression <Func <Bus_Payment, bool> > BusUserTongJiExcept_SearchWhere(BusPaymentSearchViewModel busPaymentSearchViewModel)
        {
            var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式

            if (busPaymentSearchViewModel.Bus_LineId != null)
            {
                predicate = predicate.And(a => a.Bus_LineId == busPaymentSearchViewModel.Bus_LineId);
            }

            // predicate = predicate.And(a => a.Bus_Payment_OrderId!=null);
            if (busPaymentSearchViewModel.User_DepartId != null)
            {
                predicate = predicate.And(a => a.User_DepartId == busPaymentSearchViewModel.User_DepartId);
            }

            predicate = predicate.And(a => a.Bus_Payment_Order.orderNo.Contains(busPaymentSearchViewModel.orderNo));
            predicate = predicate.And(a => a.status == "0");
            predicate = predicate.And(a => a.UserName.Contains(busPaymentSearchViewModel.UserName));

            if (busPaymentSearchViewModel.carDate != null)
            {
                predicate = predicate.And(a => a.carDate.Value.Year == busPaymentSearchViewModel.carDate.Value.Year &&
                                          a.carDate.Value.Month == busPaymentSearchViewModel.carDate.Value.Month);
            }
            predicate = predicate.And(a => a.Code != null);
            return(predicate);
        }
        public User_Info GetByIdnumber(string idnumber)
        {
            var res = new User_Info();
            //查询条件
            var predicate = WhereExtension.True <User_Info>();//初始化where表达式

            //Console.WriteLine("aaaaaaaa" + idnumber);这什么玩意
            if (!String.IsNullOrEmpty(idnumber))
            {
                predicate = predicate.And(p => Dtol.Helper.MD5.Decrypt(p.Idnumber).Equals(idnumber));
            }

            var result = DbSet.Where(predicate).ToList();

            if (result.Count > 0)
            {
                res = result.First();
            }
            else
            {
                res = null;
            }

            return(res);
        }
예제 #18
0
        //根据条件查询班车
        private Expression <Func <Bus_Payment, bool> > SearchBusUser2Where(BusUserSearch2ViewModel busUserSearch2ViewModel)
        {
            var predicate = WhereExtension.True <Bus_Payment>();//初始化where表达式

            predicate = predicate.And(a => a.Bus_Payment_Order.orderNo.Contains(busUserSearch2ViewModel.orderNo));
            predicate = predicate.And(a => a.UserName.Contains(busUserSearch2ViewModel.UserName));
            predicate = predicate.And(a => a.Name.Contains(busUserSearch2ViewModel.User_DepartName));
            if (busUserSearch2ViewModel.Bus_LineId != null)
            {
                predicate = predicate.And(a => a.Bus_LineId == busUserSearch2ViewModel.Bus_LineId);
            }

            if (busUserSearch2ViewModel.User_DepartId != null)
            {
                predicate = predicate.And(a => a.User_DepartId == busUserSearch2ViewModel.User_DepartId);
            }
            // predicate = predicate.And(a => a.LineName.Contains(busUserSearch2ViewModel.Bus_LineName));

            predicate = predicate.And(a => a.status == (busUserSearch2ViewModel.status));

            if (busUserSearch2ViewModel.Expense != "")
            {
                predicate = predicate.And(a => a.Expense == (busUserSearch2ViewModel.Expense));
            }
            if (busUserSearch2ViewModel.carDate != null)
            {
                predicate = predicate.And(a => a.carDate.Value.Year == busUserSearch2ViewModel.carDate.Value.Year &&
                                          a.carDate.Value.Month == busUserSearch2ViewModel.carDate.Value.Month);
            }

            predicate = predicate.And(a => a.Code != null);

            return(predicate);
        }
예제 #19
0
        //根据条件查询报修
        private Expression <Func <Flow_Node, bool> > SearchNodeWhere(FlowNodeSearchViewModel flowNodeSearchViewModel)
        {
            var predicate = WhereExtension.True <Flow_Node>();//初始化where表达式

            predicate = predicate.And(p => p.status.Contains(flowNodeSearchViewModel.status));
            if (flowNodeSearchViewModel.Flow_ProcedureId != null)
            {
                predicate = predicate.And(p => p.Flow_ProcedureId == flowNodeSearchViewModel.Flow_ProcedureId);
            }
            if (flowNodeSearchViewModel.Repair_InfoId != null)
            {
                predicate = predicate.And(p => p.Repair_InfoId == flowNodeSearchViewModel.Repair_InfoId);
            }
            predicate = predicate.And(p => p.operate.Contains(flowNodeSearchViewModel.operate));
            if (flowNodeSearchViewModel.User_InfoId != null)
            {
                predicate = predicate.And(p => p.User_InfoId == flowNodeSearchViewModel.User_InfoId);
            }
            if (flowNodeSearchViewModel.isHandler != null)
            {
                predicate = predicate.And(p => p.Repair_Info.isHandler == flowNodeSearchViewModel.isHandler);
            }

            return(predicate);
        }
예제 #20
0
        //根据条件查询部门
        private Expression <Func <Food_Info, bool> > SearchFoodWhere(FoodInfoSearchViewModel foodInfoSearchViewModel)
        {
            var predicate = WhereExtension.True <Food_Info>();//初始化where表达式

            predicate = predicate.And(p => p.Price.ToString().Contains(foodInfoSearchViewModel.Price.ToString()));
            predicate = predicate.And(p => p.FoodName.Contains(foodInfoSearchViewModel.FoodName));
            predicate = predicate.And(p => p.FoodType.Contains(foodInfoSearchViewModel.FoodType));
            predicate = predicate.And(p => p.Remark.Contains(foodInfoSearchViewModel.Remark));
            if (foodInfoSearchViewModel.flag == "0")//手机,默认查询当前周
            {
                System.Globalization.GregorianCalendar gc = new System.Globalization.GregorianCalendar();

                int weekOfYear = gc.GetWeekOfYear(DateTime.Now, System.Globalization.CalendarWeekRule.FirstDay, DayOfWeek.Monday);
                predicate = predicate.And(p => p.WeekNumber == weekOfYear.ToString());  //默认当前周
                predicate = predicate.And(p => p.Year == DateTime.Now.Year.ToString()); //默认当前年
            }
            else//PC查询任意周
            {
                if (foodInfoSearchViewModel.flag != "")
                {
                    predicate = predicate.And(p => p.WeekNumber == foodInfoSearchViewModel.flag);
                }
                predicate = predicate.And(p => p.Year.Contains(foodInfoSearchViewModel.Year));
            }
            predicate = predicate.And(p => p.isDelete == "0");

            return(predicate);
        }
        private Expression <Func <ResidentInfo, bool> > SearchPartResidentWhere(PartyResidentSearchViewModel partyResidentSearchViewModel)
        {
            var predicate = WhereExtension.True <ResidentInfo>();//初始化where表达式

            if (partyResidentSearchViewModel.IdentityName != "")
            {
                predicate = predicate.And(p => p.Politics.Equals(partyResidentSearchViewModel.IdentityName));
            }
            if (partyResidentSearchViewModel.Area != "")
            {
                predicate = predicate.And(p => p.InfoRelationShips.HouseInfo.Area.Equals(partyResidentSearchViewModel.Area));
            }
            if (partyResidentSearchViewModel.Name != "")
            {
                predicate = predicate.And(p => p.Name.Equals(partyResidentSearchViewModel.Name));
            }
            //根据出生年月范围查询
            if (partyResidentSearchViewModel.StartTime != null)
            {
                predicate = predicate.And(p => DateTime.ParseExact(p.IdNumber.Substring(6, 8), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture) >= partyResidentSearchViewModel.StartTime);
            }
            if (partyResidentSearchViewModel.EndTime != null)
            {
                predicate = predicate.And(p => DateTime.ParseExact(p.IdNumber.Substring(6, 8), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture) <= partyResidentSearchViewModel.EndTime);
            }

            predicate = predicate.And(p => p.Status == "1");


            return(predicate);
        }
예제 #22
0
        private Expression <Func <StudentRegisterHeath_Info, bool> > SearchLineWhere(HealthInfoSearchViewModel healthInfoSearchViewModel)
        {
            var aa = DateTime.Now;

            var aaaaaaa = aa.ToString();


            var predicate = WhereExtension.True <StudentRegisterHeath_Info>();//初始化where表达式


            predicate = predicate.And(p => p.Idnumber.Trim().Contains(healthInfoSearchViewModel.Idnumber.Trim() == ""?"":Dtol.Helper.MD5.Md5Hash(healthInfoSearchViewModel.Idnumber.Trim())));


            predicate = predicate.And(p => p.IsleaveJin.Contains(healthInfoSearchViewModel.IsleaveJin));
            predicate = predicate.And(p => p.IsPassHubei.Contains(healthInfoSearchViewModel.IsPassHubei));
            predicate = predicate.And(p => p.PassHubeiDetail.Contains(healthInfoSearchViewModel.IsPassHubei));
            predicate = predicate.And(p => p.Peers.Contains(healthInfoSearchViewModel.IsPassHubei));
            predicate = predicate.And(p => p.PeersTelephone.Contains(healthInfoSearchViewModel.IsPassHubei));
            predicate = predicate.And(p => p.Residencetemporary.Contains(healthInfoSearchViewModel.IsPassHubei));
            predicate = predicate.And(p => p.Telephone.Contains(healthInfoSearchViewModel.Telephone));
            predicate = predicate.And(p => p.Temperature.Contains(healthInfoSearchViewModel.Temperature));
            predicate = predicate.And(p => p.Traffic.Contains(healthInfoSearchViewModel.Traffic));
            predicate = predicate.And(p => p.BackJinDate.ToString().Contains(healthInfoSearchViewModel.BackJinDate == null? "": healthInfoSearchViewModel.BackJinDate.Value.ToString("yyyy-MM-dd")));
            predicate = predicate.And(p => p.BeforeTianjin.Contains(healthInfoSearchViewModel.Traffic));
            predicate = predicate.And(p => p.Guardian.Contains(healthInfoSearchViewModel.Guardian));
            predicate = predicate.And(p => p.Destination.Contains(healthInfoSearchViewModel.Destination));
            predicate = predicate.And(p => p.ForteenDaysExcepting.Contains(healthInfoSearchViewModel.ForteenDaysExcepting));
            predicate = predicate.And(p => p.CreateDate.ToString().Contains(healthInfoSearchViewModel.CreateDate == null ? "" : healthInfoSearchViewModel.CreateDate.Value.ToString("yyyy-MM-dd")));



            // predicate = predicate.And(p => p.Id==lineSearchViewModel.Id);

            return(predicate);
        }
예제 #23
0
        public string getToken()
        {
            string token     = "";
            var    predicate = WhereExtension.True <V_GetToken>();

            var result = DbSet.Where(predicate)
                         .OrderByDescending(o => o.addtime).ToList();

            if (result.Count != 0)
            {
                token = result.First().token;
                DateTime time = result.First().addtime;

                //token 有效期为2小时,超过2小时 token过期,返回值为空
                if (DateTime.Now >= time.AddHours(2))
                {
                    token = string.Empty;
                }
            }
            else
            {
                token = string.Empty;
            }

            return(token);
        }
        //根据条件查询菜单评价信息
        private Expression <Func <User_Relate_Food, bool> > SearchFoodCPWhere(FoodByUserSearchCpViewModel foodByUserSearchCpViewModel)
        {
            var predicate = WhereExtension.True <User_Relate_Food>();//初始化where表达式

            if (foodByUserSearchCpViewModel.User_InfoId != null)
            {
                predicate = predicate.And(p => p.User_InfoId == foodByUserSearchCpViewModel.User_InfoId.Value);
            }
            if (foodByUserSearchCpViewModel.Food_InfoId != null)
            {
                predicate = predicate.And(p => p.Food_InfoId == foodByUserSearchCpViewModel.Food_InfoId.Value);
            }
            predicate = predicate.And(p => p.status == foodByUserSearchCpViewModel.status);
            predicate = predicate.And(p => p.User_Info.status == "0");
            predicate = predicate.And(p => p.Food_Info.isDelete == "0");

            if (foodByUserSearchCpViewModel.WeekNumber != "")
            {
                predicate = predicate.And(p => p.Food_Info.WeekNumber == foodByUserSearchCpViewModel.WeekNumber);
            }

            predicate = predicate.And(p => p.Food_Info.Year.Contains(foodByUserSearchCpViewModel.Year));

            predicate = predicate.And(p => p.Food_Info.Remark.Contains(foodByUserSearchCpViewModel.Remark));


            return(predicate);
        }
예제 #25
0
        //根据条件查询用户
        private Expression <Func <VHelpArea, bool> > SearchVAWhere(VHelpAreaSearchViewModel VSearchViewModel)
        {
            var predicate = WhereExtension.True <VHelpArea>();//初始化where表达式

            // 不显示 已删除的信息 status=3 20191111  ,不显示 居民发布未审核的信息  status=9;审核不通过信息 status=8 (20191120)
            predicate = predicate.And(p => !p.Status.Equals("3"));
            predicate = predicate.And(p => !p.Status.Equals("9"));
            predicate = predicate.And(p => !p.Status.Equals("8"));
            if (!String.IsNullOrEmpty(VSearchViewModel.ID))
            {
                predicate = predicate.And(p => p.ID.Contains(VSearchViewModel.ID));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.Title))
            {
                predicate = predicate.And(p => p.Title.Contains(VSearchViewModel.Title));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.CommunityID))
            {
                predicate = predicate.And(p => p.CommunityID.Contains(VSearchViewModel.CommunityID));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.Address))
            {
                predicate = predicate.And(p => p.Address.Contains(VSearchViewModel.Address));
            }
            if (!String.IsNullOrEmpty(VSearchViewModel.TypeID))
            {
                predicate = predicate.And(p => p.TypeID.Contains(VSearchViewModel.TypeID));
            }

            return(predicate);
        }
        public Volunteer_Info SearchInfoByID(string id)
        {
            var res = new Volunteer_Info();
            //查询条件
            var predicate = WhereExtension.True <Volunteer_Info>();//初始化where表达式

            predicate = predicate.And(p => !p.Status.Equals("4"));
            if (!String.IsNullOrEmpty(id))
            {
                predicate = predicate.And(p => p.ID.Contains(id));
            }

            var result = DbSet.Where(predicate).ToList();

            if (result.Count != 0)
            {
                res = result.First();
            }
            else
            {
                res = null;
            }

            return(res);
        }
        private Expression <Func <Volunteer_Info, bool> > SearchVolunteerForBGWhere(VolunteerInfoSearchViewModel VSearchViewModel)
        {
            var predicate = WhereExtension.True <Volunteer_Info>();//初始化where表达式

            if (VSearchViewModel.VNO != "")
            {
                predicate = predicate.And(p => p.VNO.Equals(VSearchViewModel.VNO));
            }
            if (VSearchViewModel.Name != "")
            {
                predicate = predicate.And(p => p.Name.Contains(VSearchViewModel.Name));
            }
            if (VSearchViewModel.CommunityID != "")
            {
                predicate = predicate.And(p => p.CommunityID.Equals(VSearchViewModel.CommunityID));
            }
            if (VSearchViewModel.Gender != "")
            {
                predicate = predicate.And(p => p.Gender.Contains(VSearchViewModel.Gender));
            }
            if (VSearchViewModel.Political != "")
            {
                predicate = predicate.And(p => p.Political.Contains(VSearchViewModel.Political));
            }
            return(predicate);
        }
        //根据条件查询部门
        private Expression <Func <Flow_Relate_NodeRole, bool> > SearchDelRelateWhere(RelateRoleByNodeDelModelcs relateRoleByNodeDelModelcs)
        {
            var predicate = WhereExtension.True <Flow_Relate_NodeRole>();//初始化where表达式

            predicate = predicate.And(p => p.Flow_NodeDefineId == relateRoleByNodeDelModelcs.Flow_NodeDefineId);
            predicate = predicate.And(p => p.User_RoleId == relateRoleByNodeDelModelcs.User_RoleId);
            return(predicate);
        }
예제 #29
0
        private Expression <Func <City, bool> > SearchAllCityWhere()
        {
            var predicate = WhereExtension.True <City>();//初始化where表达式

            predicate = predicate.And(p => p.FormId == null);

            return(predicate);
        }
예제 #30
0
        private Expression <Func <City, bool> > SearchCityWhere(Guid FormId)
        {
            var predicate = WhereExtension.True <City>();//初始化where表达式

            predicate = predicate.And(p => p.FormId.Equals(FormId));

            return(predicate);
        }