public IQueryable <HouseInfo> HouseInfoSerachByWhere3(InhabitantUpdateMiddle inhabitantUpdateMiddle) { //查询条件 var predicate = SearchHouseInfoWhere3(inhabitantUpdateMiddle); var result = DbSet .Where(predicate); return(result); }
private Expression <Func <HouseInfo, bool> > SearchHouseInfoWhere3(InhabitantUpdateMiddle inhabitantUpdateMiddle) { var predicate = WhereExtension.True <HouseInfo>();//初始化where表达式 predicate = predicate.And(p => p.Area == inhabitantUpdateMiddle.Area); predicate = predicate.And(p => p.UnitNo == inhabitantUpdateMiddle.UnitNo); predicate = predicate.And(p => p.BuildingNo == inhabitantUpdateMiddle.BuildingNo); predicate = predicate.And(p => p.HouseNo == inhabitantUpdateMiddle.HouseNo); //predicate = predicate.And(p => p.Status == "1"); return(predicate); }