//条件分页查询
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");
}
