details.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>
/// Details 的摘要说明
/// </summary>
public class Details
{
    #region 私有字段和属性
    private int _newid;

    public int Newid
    {
        get { return _newid; }
        set { _newid = value; }
    }
    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 _memberPrice;

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

    public string Num
    {
        get { return _num; }
        set { _num = value; }
    }
    private int _orderid;

    public int Orderid
    {
        get { return _orderid; }
        set { _orderid = value; }
    }
    private string _people;

    public string People
    {
        get { return _people; }
        set { _people = value; }
    }
    #endregion
    #region 添加订单详情
    public int adddetails(Details add)
    {

        Database exe = new Database();
        SqlParameter[] param ={Database.CreateInParam("@id",SqlDbType.NVarChar,50,add.Id),
                       Database.CreateInParam("@Proname",SqlDbType.NVarChar,50,add.Proname),
                       Database.CreateInParam("@MemberPrice",SqlDbType.NVarChar,50,add.MemberPrice),
                       Database.CreateInParam("@Num",SqlDbType.NVarChar,50,add.Num),
                       Database.CreateInParam("@Orderid",SqlDbType.Int,4,add.Orderid),
                       Database.CreateInParam("@People",SqlDbType.NVarChar,50,add.People)};
           
        try
        {
            return (exe.execute("adddetails", param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    #endregion
    #region 显示某个用户订单
    public DataTable getall(string people)
    {
        Database gettable = new Database();
        SqlParameter[] param ={ Database.CreateInParam("@People", SqlDbType.NVarChar, 50, people) };
        try
        {
            return (gettable.GetTable("Getonedetails", param, "OrderDetail", 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }

    #endregion
    #region 获取总价格
    public int getsum()
    {
        Database gettable = new Database();
        try
        {
            return(gettable.GetScalar("GetsumDetails",null,1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }

       #endregion
    public Details()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
}