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