public ActionResult HouseUserList(HouseUserSearchModel Model) { int CompanyId = GetSessionModel().CompanyId.Value; //根据业主姓名查询 Expression <Func <T_HouseUser, bool> > where = u => (string.IsNullOrEmpty(Model.Name) ? true : u.Name.Contains(Model.Name)) && u.DelFlag == ConstantParam.DEL_FLAG_DEFAULT && u.PropertyPlace.CompanyId == CompanyId && u.PropertyPlace.PlaceType == ConstantParam.PLACE_TYPE_HOUSE; //根据小区名称查询 if (Model.PropertyPlaceId != null) { where = PredicateBuilder.And(where, u => u.PropertyPlaceId == Model.PropertyPlaceId.Value); } //根据楼座,单元,单元户名称查询 if (!string.IsNullOrEmpty(Model.Kword)) { where = PredicateBuilder.And(where, u => u.BuildDoor.BuildUnit.Build.BuildName.Contains(Model.Kword) || u.BuildDoor.BuildUnit.UnitName.Contains(Model.Kword) || u.BuildDoor.DoorName.Contains(Model.Kword)); } //排序 IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); var sortModel = this.SettingSorting("Id", false); Model.DataList = houseUserBll.GetPageList(where, sortModel.SortName, sortModel.IsAsc, Model.PageIndex) as PagedList <T_HouseUser>; //获取所有物业小区列表 Model.PropertyPlaceList = GetPropertyPlaceList(); return(View(Model)); }
public ActionResult HouseUserList(HouseUserSearchModel Model) { IHouseUserBLL houseUserBll = BLLFactory <IHouseUserBLL> .GetBLL("HouseUserBLL"); int propertyPlaceId = GetSessionModel().PropertyPlaceId.Value; Expression <Func <T_HouseUser, bool> > where = u => (string.IsNullOrEmpty(Model.Name) ? true : u.Name.Contains(Model.Name)) && u.DelFlag == ConstantParam.DEL_FLAG_DEFAULT && u.PropertyPlaceId == propertyPlaceId; //排序 var sortModel = this.SettingSorting("Id", false); var list = houseUserBll.GetPageList(where, sortModel.SortName, sortModel.IsAsc, Model.PageIndex); return(View(list)); }