//条件分页查询 protected void showhouse() { sectionList = sectionService.GetModelList(""); hyList = hyService.GetModelList(""); areaList = areaService.GetModelList(""); //分页参数分开获取post提交的查询条件与get提交分页参数 if (IsPostBack) { hname = Request.Form["hname"]; sid = Request.Form["sid"]; htype = Request.Form["htype"]; harea = Request.Form["harea"]; hmode = Request.Form["hmode"]; hstatus = Request.Form["hstatus"]; order = Request.Form["order"]; } else { hname = Request.QueryString["hname"]; sid = Request.QueryString["sid"]; htype = Request.QueryString["htype"]; harea = Request.QueryString["harea"]; hmode = Request.QueryString["hmode"]; hstatus = Request.QueryString["hstatus"]; order = Request.QueryString["order"]; } int page = 1; if (!Int32.TryParse(Request["page"], out page)) { page = 1; } //传递参数获取房屋列表和分页链接 ArrayList arraylist = houseService.FindHosueListOnWhereByPage(page, hname, sid, htype, harea, hmode, hstatus, order); //从动态数组中取出 houseList = (List <House>)arraylist[0]; pageCode = arraylist[1].ToString(); //封装房屋板块,房屋类型,房屋地区到房屋model下 foreach (House house in houseList) { house.area = areaService.GetModel((int)house.harea); house.housetype = hyService.GetModel((int)house.htype); house.section = sectionService.GetModel(house.sid); house.userinfo = userService.GetModel(house.uid); } }
//添加分页查询被举报的信息(若房屋已处理设置为不合法,则不再显示此房屋的相关信息) protected void showreporte() { sectionList = sectionService.GetModelList(""); hyList = hyService.GetModelList(""); int page = 1; if (!Int32.TryParse(Request["page"], out page)) { page = 1; } //查询与分页条件分开获取 if (IsPostBack) { hid = Request.Form["hid"]; cstatus = Request.Form["cstatus"]; order = Request.Form["order"]; } else { hid = Request.QueryString["hid"]; cstatus = Request.QueryString["cstatus"]; order = Request.QueryString["order"]; } //调用获取arraylist ArrayList list = contractService.FindReportByPageOnWhere(page, hid, cstatus, order); //取出信息列表与分页链接 reportList = (List <Contract>)list[0]; pageCode = list[1].ToString(); //封装信息 foreach (Contract contract in reportList) { contract.house = houseService.GetModel(contract.hid); contract.user = userService.GetModel(contract.uid); contract.house.housetype = hyService.GetModel((int)contract.house.htype); contract.house.section = sectionService.GetModel(contract.house.sid); contract.house.userinfo = userService.GetModel(contract.house.uid); } }
//show protected void housedetailsshow() { //查询出与该房屋有关的信息 house = houseService.GetModel(hid); house.userinfo = userService.GetModel(house.uid); housetype = hyService.GetModel((int)house.htype).ttype.ToString(); housearea = areaService.GetModel((int)house.harea).areaname; housesection = sectionService.GetModel(house.sid).sname; //房屋所在小区与地址,地图使用 houseadress = house.hadress; housecommunity = house.hcommunity; if (Session["userInfo"] != null) { int uid = ((User)Session["userInfo"]).uid; contractList = contractService.GetModelList("uid='" + uid + "' and hid=" + hid); if (contractList.Count == 0) { house.contract = null; } else { house.contract = contractList[0]; } } //推荐房屋查询 string hmoney = house.hmoney; int htype = (int)house.htype; tjhouse = houseService.GetModelListTop(4, "hmoney='" + hmoney + "' and htype='" + htype + "' and hid !='" + hid + "' and hstatus =" + 1, "htime desc"); }