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