houseclass.cs

主要是一个图片展示效果

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

/// <summary>
/// HouseClass 的摘要说明
/// </summary>
public class HouseClass
{
    public HouseClass() { }

    private int houseId;
    private String address;
    private String city;
    private Double price;
    private String doorType;
    private int acreage;
    private String linkman;
    private String email;
    private String phone;
    private String handSet;
    private DateTime availabilityTime;
    private String description;
    private String theme;
    private String category;
    private String wayStatus;
    private int brokerId;

    public int HouseId
    {
        get { return houseId; }
        set { houseId = value; }
    }

    public String Address
    {
        get { return address; }
        set { address = value; }
    }

    public String City
    {
        get { return city; }
        set { city = value; }
    }

    public Double Price
    {
        get { return price; }
        set { price = value; }
    }

    public String DoorType
    {
        get { return doorType; }
        set { doorType = value; }
    }

    public int Acreage
    {
        get { return acreage; }
        set { acreage = value; }
    }

    public String Linkman
    {
        get { return linkman; }
        set { linkman = value; }
    }

    public String Email
    {
        get { return email; }
        set { email = value; }
    }

    public String Phone
    {
        get { return phone; }
        set { phone = value; }
    }

    public String HandSet
    {
        get { return handSet; }
        set { handSet = value; }
    }

    public DateTime AvailabilityTime
    {
        get { return availabilityTime; }
        set { availabilityTime = value; }
    }

    public String Description
    {
        get { return description; }
        set { description = value; }
    }

    public String Theme
    {
        get { return theme; }
        set { theme = value; }
    }

    public String Category
    {
        get { return category; }
        set { category = value; }
    }

    public String WayStatus
    {
        get { return wayStatus; }
        set { wayStatus = value; }
    }

    public int BrokerId
    {
        get { return brokerId; }
        set { brokerId = value; }
    }

    private static String strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();

    /// <summary>
    /// 发布信息
    /// </summary>
    /// <returns></returns>
    public int HouseAdd(HouseClass hc)
    {
        string sql = "Insert into R_House(Address,City,Price,DoorType,Acreage,Linkman,Email,Phone,HandSet,AvailabilityTime,Description,Theme,Category,WayStatus,BrokerId)";
        sql += " Values('" + hc.Address + "','"+hc.City+"'" + hc.Price + ",'" + hc.DoorType + "'," + hc.Acreage + ",'" + hc.Linkman + "','" + hc.Email + "','" + hc.Phone + "','" + hc.HandSet + "','" + hc.AvailabilityTime + "','" + hc.Description + "','" + hc.Theme + "','"+hc.Category+"','" + hc.WayStatus + "'," + hc.BrokerId + ")";
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
        return result;
    }

    /// <summary>
    /// 房屋查询
    /// </summary>
    /// <param name="wayStatus"></param>
    /// <param name="city"></param>
    /// <param name="category"></param>
    /// <param name="startAcreage"></param>
    /// <param name="endAcreage"></param>
    /// <param name="startPrice"></param>
    /// <param name="endPrice"></param>
    /// <param name="doorType"></param>
    /// <returns></returns>
    public DataSet HouseSearchInfo(string wayStatus, string city, string category, int startAcreage, int endAcreage, double startPrice, double endPrice, string doorType)
    {
        string sql = "Select HouseId,Theme,City,WayStatus,DoorType,Price,Acreage,ReleaseTime From R_House ";
        sql += "Where WayStatus like '%"+wayStatus+"%' and DoorType like '%"+doorType+"%' and City like '%"+city+"%' and Category like '%"+category+"%' and Acreage Between "+startAcreage+" and "+endAcreage+" and Price Between "+startPrice+" and "+endPrice+" and InfoStatus=1";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql,null);
        return ds;
    }

    /// <summary>
    /// 获取指定房屋的详细信息
    /// </summary>
    /// <param name="houseId"></param>
    /// <returns></returns>
    public SqlDataReader GetHouseDetail(int houseId)
    {
        string sql = "Select Address,City,Price,DoorType,Acreage,Linkman,Email,Phone,HandSet,ReleaseTime,AvailabilityTime,Description,Theme,Category,WayStatus From R_House";
        sql += " Where HouseId = "+houseId;
        SqlDataReader sdr = BindData.ExecuteDataReader(sql);
        return sdr;
    }

    /// <summary>
    /// 按照方式获取房屋的信息
    /// </summary>
    /// <param name="wayStatus"></param>
    /// <returns></returns>
    public DataSet GetHouseList(string wayStatus)
    { 
        string sql = "Select HouseId,City,Price,DoorType,Acreage,ReleaseTime,Theme,Category,WayStatus From R_House";
        sql += " Where WayStatus like '%"+wayStatus+"%' and InfoStatus=1";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql, null);
        return ds;
    }

    /// <summary>
    /// 会员发布的信息验证通过
    /// </summary>
    /// <param name="houseId"></param>
    /// <returns></returns>
    public int InfoValidateOk(int houseId)
    {
        string sql = "Update R_House Set InfoStatus=1 Where HouseId = "+houseId;
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
        return result;
    }

    /// <summary>
    /// 冻结未通过验证的信息
    /// </summary>
    /// <param name="houseId"></param>
    /// <returns></returns>
    public int InfoDongJie(int houseId)
    {
        string sql = "Update R_House Set InfoStatus=2 Where HouseId = " + houseId;
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
        return result;
    }

    /// <summary>
    /// 获取不同方式的房屋信息--未验证的!
    /// </summary>
    /// <param name="wayStatus"></param>
    /// <returns></returns>
    public DataSet GetNoValidateHouseList(string wayStatus)
    {
        string sql = "Select HouseId,City,Price,DoorType,Acreage,ReleaseTime,Theme,Category,WayStatus From R_House";
        sql += " Where WayStatus like '%" + wayStatus + "%' and InfoStatus=0";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql, null);
        return ds;
    }
}