buildclass.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>
/// BuildClass 的摘要说明
/// </summary>
public class BuildClass
{
    public BuildClass() { }

    private int buildId;
    private String buildName;
    private String category;
    private String city;
    private String transportation;
    private Double evenPrice;
    private String repairStatus;
    private DateTime enterTime;
    private DateTime openTime;
    private String salePhone;
    private String developer;
    private String paymentWay;
    private String imgUrl;

    public int BuildId
    {
        get { return buildId; }
        set { buildId = value; }
    }

    public String BuildName
    {
        get { return buildName; }
        set { buildName = value; }
    }

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

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

    public String Transportation
    {
        get { return transportation; }
        set { transportation = value; }
    }

    public Double EvenPrice
    {
        get { return evenPrice; }
        set { evenPrice = value; }
    }

    public string RepairStatus
    {
        get { return repairStatus; }
        set { repairStatus = value; }
    }

    public DateTime EnterTime
    {
        get { return enterTime; }
        set { enterTime = value; }
    }

    public DateTime OpenTime
    {
        get { return openTime; }
        set { openTime = value; }
    }

    public String SalePhone
    {
        get { return salePhone; }
        set { salePhone = value; }
    }

    public String Developer
    {
        get { return developer; }
        set { developer = value; }
    }

    public String PaymentWay
    {
        get { return paymentWay; }
        set { paymentWay = value; }
    }

    public String ImgUrl
    {
        get { return imgUrl; }
        set { imgUrl = value; }
    }

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

    /// <summary>
    ///　添加楼盘
    /// </summary>
    /// <param name="bc"></param>
    /// <returns></returns>
    public int BuildAdd(BuildClass bc)
    { 
        SqlParameter[] paras = { new SqlParameter("@BuildName",bc.BuildName),new SqlParameter("@Category",bc.Category),new SqlParameter("@City",bc.City),new SqlParameter("@Transportation",bc.Transportation),new SqlParameter("@EvenPrice",bc.EvenPrice),new SqlParameter("@RepairStatus",bc.RepairStatus),new SqlParameter("@EnterTime",bc.EnterTime),new SqlParameter("@OpenTime",bc.OpenTime),new SqlParameter("@SalePhone",bc.SalePhone),new SqlParameter("@Developer",bc.Developer),new SqlParameter("@PaymentWay",bc.PaymentWay),new SqlParameter("@ImgUrl",bc.ImgUrl)};
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "B_BuildAdd", paras);
        return result;
    }

    /// <summary>
    /// 更新楼盘
    /// </summary>
    /// <returns></returns>
    public int BuildUpdate(BuildClass bc)
    {
        SqlParameter[] paras = {new SqlParameter("@BuildId",bc.BuildId), new SqlParameter("@BuildName", bc.BuildName), new SqlParameter("@Category", bc.Category), new SqlParameter("@City", bc.City), new SqlParameter("@Transportation", bc.Transportation), new SqlParameter("@EvenPrice", bc.EvenPrice), new SqlParameter("@RepairStatus", bc.RepairStatus), new SqlParameter("@EnterTime", bc.EnterTime), new SqlParameter("@OpenTime", bc.OpenTime), new SqlParameter("@SalePhone", bc.SalePhone), new SqlParameter("@Developer", bc.Developer), new SqlParameter("@PaymentWay", bc.PaymentWay), new SqlParameter("@ImgUrl", bc.ImgUrl) };
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.StoredProcedure,"B_BuildUpdate", paras);
        return result;
    }

    /// <summary>
    /// 获取指定楼盘的详细信息
    /// </summary>
    /// <param name="buildId"></param>
    /// <returns></returns>
    public SqlDataReader GetBuildDetailInfo(int buildId)
    {
        string sql = "Select BuildName,Category,City,Transportation,EvenPrice,RepairStatus,EnterTime,OpenTime,SalePhone,Developer,PaymentWay,ImgUrl From R_Building Where BuildId ="+buildId;
        SqlDataReader sdr =  BindData.ExecuteDataReader(sql);
        return sdr;
    }

    /// <summary>
    /// 返回查询信息
    /// </summary>
    /// <param name="bc"></param>
    /// <param name="startPrice"></param>
    /// <param name="endPrice"></param>
    /// <returns></returns>
    public DataSet GetSearchInfo(BuildClass bc,double startPrice,double endPrice)
    {
        string sql = "Select BuildId,BuildName,Category,City,Transportation,EvenPrice,RepairStatus,EnterTime,OpenTime,SalePhone,Developer,PaymentWay,ImgUrl From R_Building Where ";
        sql += "BuildName like '%"+bc.BuildName+"%' and City like '%"+bc.City+"%' and Category like '%"+bc.Category+"%' and EvenPrice Between "+startPrice+" and "+endPrice+"";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql, null);
        return ds;
    }

    /// <summary>
    /// 楼盘删除
    /// </summary>
    /// <param name="buildId"></param>
    public void DeleteBuild(int buildId)
    {
        string sql = "Delete From R_Building Where BuildId ="+buildId;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
    }

    /// <summary>
    /// 返回楼盘信息－－在首页显示
    /// </summary>
    /// <returns></returns>
    public DataSet GetBuildImg()
    {
        string sql = "Select top 6 BuildId,BuildName,ImgUrl From R_Building Order By OpenTime desc";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql, null);
        return ds;
    }
}