deckclass.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>
/// DeckClass 的摘要说明
/// </summary>
public class DeckClass
{
	public DeckClass()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    private int deckId;
    private string deckName;
    private string detailInfo;
    private string address;
    private string phone;
    private string email;
    private string fax;
    private int postBoy;
    private string stylist;
    private string firmDetail;
    private int brokerId;
    private int dClassId;
    private string imgUrl;

    public int DeckId
    {
        get { return deckId; }
        set { deckId = value; }
    }

    public String DeckName
    {
        get { return deckName; }
        set { deckName = value; }
    }

    public String DetailInfo
    {
        get { return detailInfo; }
        set { detailInfo = value; }
    }

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

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

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

    public String Fax
    {
        get { return fax; }
        set { fax = value; }
    }

    public int PostBoy
    {
        get { return postBoy; }
        set { postBoy = value; }
    }

    public String Stylist
    {
        get { return stylist; }
        set { stylist = value; }
    }

    public String FirmDetail
    {
        get { return firmDetail; }
        set { firmDetail = value; }
    }

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

    public int DClassId
    {
        get { return dClassId; }
        set { dClassId = value; }
    }

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

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

    /// <summary>
    /// 添加类别
    /// </summary>
    /// <param name="className"></param>
    /// <returns></returns>
    public int InsertDeckClass(string className)
    {
        string sql = "Insert Into R_DeckClass(DClassName) Values('" + className + "')";
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
        return result;
    }

    /// <summary>
    /// 删除指定类别
    /// </summary>
    /// <param name="dClassId"></param>
    public void DeleteDeckClass(int dClassId)
    {
        string sql = "Delete From R_DeckClass Where DClassId = "+dClassId;
        string sqls = "Delete From R_Deck Where DClassId ="+dClassId;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sqls, null);
    }

    /// <summary>
    /// 添加装饰
    /// </summary>
    /// <param name="dc"></param>
    /// <returns></returns>
    public int AddDeck(DeckClass dc)
    {
        string sql = "Insert Into R_Deck(DeckName,DetailInfo,Address,Phone,Email,Fax,PostBoy,Stylist,FirmDetail,BrokerId,DClassId,ImgUrl) Values('"+dc.DeckName+"','"+dc.DetailInfo+"','"+dc.Address+"','"+dc.Phone+"','"+dc.Email+"','"+dc.Fax+"',"+dc.PostBoy+",'"+dc.Stylist+"','"+dc.FirmDetail+"',"+dc.BrokerId+","+dc.DClassId+",'"+dc.ImgUrl+"')";
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon,CommandType.Text,sql,null);
        return result;
    }

    /// <summary>
    /// 获取装饰类别信息
    /// </summary>
    /// <returns></returns>
    public DataSet GetDeckClassSum()
    {
        string sql = "Select DClassId,DClassName From R_DeckClass";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql, null);
        return ds;
    }

    /// <summary>
    /// 获取不同类别的装饰信息(只能显示固定张数图片)
    /// </summary>
    /// <returns></returns>
    public DataSet GetDeckInfoByClassId(int dClassIds)
    {
        string sql = "Select Top 4 DeckId,DeckName,ImgUrl From R_Deck Where DClassId = "+dClassIds +" Order By DTime DESC";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql, null);
        return ds;
    }

    /// <summary>
    /// 获取不同类别的装饰信息
    /// </summary>
    /// <returns></returns>
    public DataSet GetDeckInfosByClassId(int dClassIds)
    {
        string sql = "Select DeckId,DeckName,ImgUrl,DClassId From R_Deck Where DClassId = " + dClassIds + " Order By DTime DESC";
        DataSet ds = Real.DAL.SqlHelper.ExecuteDataset(strCon, CommandType.Text, sql, null);
        return ds;
    }

    /// <summary>
    ///　获取指定的DeckId的CurrentPage
    /// </summary>
    /// <returns></returns>
    public int GetCurrentPageByDeckId(int deckIds, int dClassId)
    {
        SqlParameter[] paras = { new SqlParameter("@DeckId", deckIds), new SqlParameter("@DClassId", dClassId) };
        int result = Convert.ToInt32(Real.DAL.SqlHelper.ExecuteScalar(strCon, CommandType.StoredProcedure, "D_CurrentPageByDeckId", paras));
        return result;
    }
}