protected void Page_Load(object sender, EventArgs e)
{
SectionService sectionService = new SectionService();
HousetypeService hyService = new HousetypeService();
AreaService areaSevice = new AreaService();
sectionList = sectionService.GetModelList("");
hyList = hyService.GetModelList("");
areaList = areaSevice.GetModelList("");
hid = Int32.Parse(Request["hid"]);
house = houseService.GetModel(hid);
hmode = (int)house.hmode;
sid = house.sid;
htype = (int)house.htype;
areaid = (int)house.harea;
if (IsPostBack)
{
this.update();
}
}
//条件分页查询
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);
}
}
//房屋信息添加方法
protected void add()
{
if (IsPostBack)
{
HttpFileCollection files = HttpContext.Current.Request.Files; //多文件上传
string photo1 = "", photo2 = "", photo3 = "", photo4 = "";
string[] photo = { photo1, photo2, photo3, photo4 };
//通过for循环判断并存储所有上传的图片
for (int i = 0; i < files.Count; i++)
{
if (files[i] != null && !files[i].FileName.Equals(""))
{ //判断文件是否为空
string fileName = files[i].FileName; //得到上传图片的文件名字
string ext = Path.GetExtension(fileName); //得到上传图片的文件扩展名
if (ext == ".jpg" || ext == ".gif" || ext == ".png" || ext == ".jpeg" || ext == ".JPG" || ext == ".bmp") //设定文件的类型
{
string newFileNames = Guid.NewGuid().ToString() + ext;
string fileSavePath = Request.MapPath("/HousePhoto/" + newFileNames); //保存路径HousePhoto
photo[i] = "/HousePhoto/" + newFileNames;
files[i].SaveAs(fileSavePath); //保存图片到服务器指定的目录中去
}
else
{
photo[i] = "/Images/House/wu.jpg"; //默认头像
}
}
else
{
photo[i] = "/Images/House/wu.jpg";
}
}
HouseService houseService = new HouseService();
House house = new House();
house.uid = ((User)Session["userInfo"]).uid;
house.hname = Request["hname"];
house.sid = Int32.Parse(Request["sid"]);
house.htype = Int32.Parse(Request["htype"]);
house.hsize = Request["hsize"];
house.hfloor = Request["hfloor"];
house.hmoney = Request["hmoney"];
house.hcommunity = Request["hcommunity"];
house.harea = Int32.Parse(Request["harea"]);
house.hadress = Request["hadress"];
house.hdescription = Request["hdescription"];
house.hphotoone = photo[0];
house.hphototwo = photo[1];
house.hphotothree = photo[2];
house.hphotofour = photo[3];
house.htime = DateTime.Now;
house.hmode = Int32.Parse(Request["hmode"]);
house.hstatus = Int32.Parse(Request["hstatus"]);
if (houseService.Add(house) > 0)
{
Response.Redirect("/MyHouse.aspx");
}
else
{
Response.Write("<script>alter(发布失败！)</script>");
}
}
else
{
SectionService sectionService = new SectionService();
HousetypeService hyService = new HousetypeService();
AreaService areaSevice = new AreaService();
sectionList = sectionService.GetModelList("");
hyList = hyService.GetModelList("");
areaList = areaSevice.GetModelList("");
}
}
protected void Page_Load(object sender, EventArgs e)
{
//防止sid非法
if (!Int32.TryParse(Request["sid"], out sid))
{
sid = 1;
}
//当前房屋板块名
sectionname = sectionService.GetModel(sid).sname;
//地区与房屋类型选择
areaList = areaService.GetModelList("");
hyList = hyService.GetModelList("");
//防止请求的page非法
if (!Int32.TryParse(Request["page"], out page))
{
page = 1;
}
//获取条件进行条件语句拼接和回显(form表单提交的参数查询，get方式提交的方便分页和回显)
if (IsPostBack)
{
areaid = Request.Form["harea"];
tid = Request.Form["htype"];
money = Request.Form["hmoney"];
}
else
{
areaid = Request.QueryString["harea"];
tid = Request.QueryString["htype"];
money = Request.QueryString["hmoney"];
}
//将租金900-1200根据"-"分割并存放在数组中，取出即为最小值与最大值
if (money != null && !"".Equals(money))
{
string[] mArray = money.Split('-');
min = mArray[0];
max = mArray[1];
}
//分页列表条件拼接 strWhere
if (sid.ToString() != "")
{
strWhere.Append("sid= '" + sid + "'");
}
if (areaid != null && !"".Equals(areaid))
{
strWhere.Append(" and harea= '" + areaid + "'");
}
if (tid != null && !"".Equals(tid))
{
strWhere.Append(" and htype= '" + tid + "'");
}
if (min != null && !"".Equals(min) && max != null && !"".Equals(max))
{
strWhere.Append(" and hmoney between '" + min + "' and '" + max + "'");
}
if (sid.ToString() != "")
{
strWhere.Append(" and hstatus= '" + hstatus + "'");
}
//获取信息的排序方式
flag = Request["flag"];
//分页链接条件拼接 param 注意空格
if (sid.ToString() != "")
{
param.Append("sid=" + sid);
}
if (areaid != null && !"".Equals(areaid))
{
param.Append("&harea=" + areaid);
}
if (tid != null && !"".Equals(tid))
{
param.Append("&htype=" + tid);
}
if (min != null && !"".Equals(min) && max != null && !"".Equals(max))
{
param.Append("&hmoney=" + min + "-" + max);
}
if (sid.ToString() != "")
{
param.Append("&hstatus=" + hstatus);
}
if (flag != null && !"".Equals(flag))
{
param.Append("&flag=" + flag);
}
//根据不同条件查询出的信息的最大数，然后判断page与最大页的大小，防止最后一页为空
recordcount = houseService.GetRecordCount(strWhere.ToString());
if (recordcount % houseService.pagecount == 0)
{
maxpage = recordcount / houseService.pagecount;
}
else
{
maxpage = recordcount / houseService.pagecount + 1;
}
if (page > maxpage)
{
page = maxpage;
}
//通过页面传递的不同参数执行不同的操作 未审核房屋信息不查询
if (flag == null || "".Equals(flag))
{
//默认发布时间倒序
houseList = houseService.FindHouseByPageWhere(strWhere.ToString(), "htime desc", page, houseService.pagecount);
}
else if (flag == "moneydown")
{
//房屋租金从高到低
houseList = houseService.FindHouseByPageWhere(strWhere.ToString(), "hmoney desc", page, houseService.pagecount);
}
else if (flag == "moneyup")
{
//房屋租金从低到高
houseList = houseService.FindHouseByPageWhere(strWhere.ToString(), "hmoney asc", page, houseService.pagecount);
}
//分页链接
pageCode = PageUtil.genPagination("/HouseList.aspx", recordcount, page, houseService.pagecount, param.ToString());
//封装房屋地区到house,area下
foreach (House house in houseList)
{
house.area = areaService.GetModel((int)house.harea);
}
}