product.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>
/// Product 的摘要说明
/// </summary>
public class Product
{
    #region 属性和私有字段
    private int _id;
    public int ID
    {
        get { return _id; }
        set { _id = value; }
    }
    private string _proname;

    public string Proname
    {
        get { return _proname; }
        set { _proname = value; }
    }
    private string _content;

    public string Content
    {
        get { return _content; }
        set { _content = value; }
    }
    private string _hot;

    public string Hot
    {
        get { return _hot; }
        set { _hot = value; }
    }
    private string _tejia;

    public string Tejia
    {
        get { return _tejia; }
        set { _tejia = value; }
    }
    private string _jipin;

    public string Jipin
    {
        get { return _jipin; }
        set { _jipin = value; }
    }
    private string _pic;

    public string Pic
    {
        get { return _pic; }
        set { _pic = value; }
    }
    private string _memberPrice;

    public string MemberPrice
    {
        get { return _memberPrice; }
        set { _memberPrice = value; }
    }
    private string _marketPrice;

    public string MarketPrice
    {
        get { return _marketPrice; }
        set { _marketPrice = value; }
    }
    private string _bigClass;

    public string BigClass
    {
        get { return _bigClass; }
        set { _bigClass = value; }
    }
    private string _cha;

    public string Cha
    {
        get { return _cha; }
        set { _cha = value; }
    }
	
    #endregion
    #region 构造函数
    public Product()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public Product(SqlDataReader dr)
    {
        this._id = Convert.ToInt32(dr["id"]);
        this._proname = Convert.ToString(dr["Proname"]);
        this._hot = Convert.ToString(dr["Hot"]);
        this._jipin = Convert.ToString(dr["Jipin"]);
        this._bigClass = Convert.ToString(dr["BigClass"]);
        this._content = Convert.ToString(dr["Content"]);
        this._marketPrice = Convert.ToString(dr["MarketPrice"]);
        this._memberPrice = Convert.ToString(dr["MemberPrice"]);
        this._pic = Convert.ToString(dr["Pic"]);
        this._tejia = Convert.ToString(dr["Tejia"]);
        this._cha = Convert.ToString(dr["cha"]);
    }
     #endregion 
    #region 添加产品
public int addproduct(Product add)
{

Database exe = new Database();
SqlParameter[] param ={Database.CreateInParam("@Proname",SqlDbType.NVarChar,50,add.Proname),
                       Database.CreateInParam("@Hot",SqlDbType.NVarChar,50,add.Hot),
                       Database.CreateInParam("@Tejia",SqlDbType.NVarChar,50,add.Tejia),
                       Database.CreateInParam("@Jipin",SqlDbType.NVarChar,50,add.Jipin),
                       Database.CreateInParam("@BigClass",SqlDbType.NVarChar,50,add.BigClass),
                       Database.CreateInParam("@Pic",SqlDbType.NVarChar,50,add.Pic),
                       Database.CreateInParam("@MarketPrice",SqlDbType.NVarChar,50,add.MarketPrice),
                       Database.CreateInParam("@MemberPrice",SqlDbType.NVarChar,50,add.MemberPrice),
                       Database.CreateInParam("@Content",SqlDbType.Text,2147483647,add.Content)};
        
        
        
       
        try
        {
            return (exe.execute("addproduct", param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    #endregion
    #region 显示全部产品
    public DataTable getall()
    {
        Database gettable = new Database();
        try
        {
            return (gettable.GetTable("GetAllProduct",null, "Product", 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }

    #endregion
    #region 根据id返回product
    public static Product GetUserByUserId(int id)
    {
        Database getone = new Database();
        Product Single = new Product();
        SqlParameter[] prams ={ Database.CreateInParam("@id",SqlDbType.Int,4,id) };
        SqlDataReader Dr = getone.GetReader("getoneproduct", prams, 1);
        while (Dr.Read())
        {
            Single = new Product(Dr);
        }
        Dr.Close();
        return Single;
    }


    #endregion
    #region 修改产品
    public int editproduct(Product add)
    {

        Database exe = new Database();
        SqlParameter[] param ={Database.CreateInParam("@Proname",SqlDbType.NVarChar,50,add.Proname),
                       Database.CreateInParam("@Hot",SqlDbType.NVarChar,50,add.Hot),
                       Database.CreateInParam("@Tejia",SqlDbType.NVarChar,50,add.Tejia),
                       Database.CreateInParam("@Jipin",SqlDbType.NVarChar,50,add.Jipin),
                       Database.CreateInParam("@BigClass",SqlDbType.NVarChar,50,add.BigClass),
                       Database.CreateInParam("@Pic",SqlDbType.NVarChar,50,add.Pic),
                       Database.CreateInParam("@MarketPrice",SqlDbType.NVarChar,50,add.MarketPrice),
                       Database.CreateInParam("@MemberPrice",SqlDbType.NVarChar,50,add.MemberPrice),
                       Database.CreateInParam("@Content",SqlDbType.Text,2147483647,add.Content),
                       Database.CreateInParam("@ID",SqlDbType.Int,4,add.ID)};




        try
        {
            return (exe.execute("editproduct", param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    #endregion
    #region 删除产品

    public int delProduct(Product del)
    {
        string proanme = "DelProduct";
        Database exe = new Database();
        SqlParameter[] param ={ Database.CreateInParam("@id", SqlDbType.Int, 4, del.ID) };
        try
        {
            return (exe.execute(proanme, param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    #endregion
    #region 返回不同类型产品
    //第一中sql语句
    public void Gettypeproduct(string  sql,SqlParameter [] parm,ref DataSet ds,string srctable,int type)
    {
        Database gettable = new Database();
        try
        {
            gettable.GetSet(sql, parm, ref ds,srctable, 0);
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
    }
    //第二种存储过程实现
    public DataTable GetTypeFour(int type)
    {
        Database gettable = new Database();
        SqlParameter[] parm ={ Database.CreateInParam("@Type", SqlDbType.Int, 4, type) };
        try
        {
            return (gettable.GetTable("GetType", parm, "Product", 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    #endregion
    #region 获取类别产品总数
    //获取类别产品总数
    public DataTable GetTypeall(int type)
    {
        Database gettable = new Database();
        SqlParameter[] parm ={ Database.CreateInParam("@Type", SqlDbType.Int, 4, type) };
        try
        {
            return (gettable.GetTable("GetTypeall", parm, "Product", 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    //重载 取出当页的记录数否则无法实现分页
    public DataTable GetTypeall(int type,int currentPage,int pageSize)
    {
        Database gettable = new Database();
        SqlParameter[] parm ={ Database.CreateInParam("@Type", SqlDbType.Int, 4, type) };
        try
        {
            return (gettable.GetTable("GetTypeall", parm, "Product", 1,currentPage,pageSize));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }

    #endregion



    #region 获取不同类型名称产品总数
    //获取类别产品总数
    public DataTable GetClassall(string BigClass)
    {
        Database gettable = new Database();
        SqlParameter[] parm ={ Database.CreateInParam("@BigClass", SqlDbType.NVarChar, 50, BigClass) };
        try
        {
            return (gettable.GetTable("GetClassall", parm, "Product", 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    //重载 取出当页的记录数否则无法实现分页
    public DataTable GetClassall(string BigClass, int currentPage, int pageSize)
    {
        Database gettable = new Database();
        SqlParameter[] parm ={ Database.CreateInParam("@BigClass", SqlDbType.NVarChar, 50, BigClass) };
        try
        {
            return (gettable.GetTable("GetClassall", parm, "Product", 1, currentPage, pageSize));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }

    #endregion



}