mangerclass.cs

对网上购物进行管理的网站。采用SQLSERVER创建后台数据库。可以将购买的商品存入购物车、提交订单、信息查询等。

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>
/// MangerClass 的摘要说明
/// </summary>
public class MangerClass
{
    DBClass dbObj = new DBClass();
	public MangerClass()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    //*************************************************************************************************
    /// <summary>
    /// GridView控件的绑定
    /// </summary>
    /// <param name="gvName">控件名字</param>
    /// <param name="P_Str_srcTable">绑定信息</param>
    public  void gvBind(GridView gvName, SqlCommand myCmd, string P_Str_srcTable)
    {      
        SqlDataAdapter da = new SqlDataAdapter(myCmd);
        DataSet ds = new DataSet();
        da.Fill(ds, P_Str_srcTable);
        gvName.DataSource = ds.Tables[P_Str_srcTable].DefaultView;
        gvName.DataBind();
    }
    /// <summary>
    /// 判断有没有最新的订单或新会员
    /// </summary>
    /// <param name="P_Str_ProcName">执行语句的存储过程名</param>
    /// <returns></returns>
    public int IsExistsNI(string P_Str_ProcName)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand(P_Str_ProcName, myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter returnValue = myCmd.Parameters.Add("returnValue", SqlDbType.Int, 4);
        returnValue.Direction = ParameterDirection.ReturnValue;
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
        int P_Int_returnValue = Convert.ToInt32(returnValue.Value.ToString());
        return P_Int_returnValue;      
    }
    /// <summary>
    /// 绑定最新信息(最新订单信息，最新用户信息量)
    /// </summary>
    /// <param name="P_Str_ProcName">执行语句的存储过程名</param>
    /// <returns></returns>
    public SqlCommand GetNewICmd(string P_Str_ProcName)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand(P_Str_ProcName, myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter returnValue = myCmd.Parameters.Add("returnValue", SqlDbType.Int, 4);
        returnValue.Direction = ParameterDirection.ReturnValue;
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
      
         return myCmd ;   
    }
    //*************************************************************************************************
    /// <summary>
    ///  获取订单信息
    /// </summary>
    /// <param name="P_Int_Flag">是否是功能菜单栏传来的值</param>
    /// <param name="P_Int_IsMember">是否是以员工来查询</param>
    /// <param name="P_Int_MemberID">员工编号</param>
    /// <param name="P_Int_OrderID">订单编号</param>
    /// <param name="P_Int_Confirm">是否选择了确认下拉菜单</param>
    /// <param name="P_Int_Payed">是否选择了确认下拉菜单</param>
    /// <param name="P_Int_Shipped">是否选择了付款下拉菜单</param>
    /// <param name="P_Int_Finished">是否选择了归档下拉菜单</param>
    /// <param name="P_Int_IsConfirm">订单是否已确认</param>
    /// <param name="P_Int_IsPayment">订单是否已付款</param>
    /// <param name="P_Int_IsConsignment">订单是否已发贷</param>
    /// <param name="P_Int_IsPigeonhole">订单是否已归档</param>
    /// <returns>返回Sqlcommand</returns>
    public SqlCommand  GetOrderInfo(int P_Int_Flag,int P_Int_IsMember, int P_Int_MemberID, int P_Int_OrderID, int P_Int_Confirm,int P_Int_Payed,int P_Int_Shipped,int P_Int_Finished,int P_Int_IsConfirm, int P_Int_IsPayment, int P_Int_IsConsignment, int P_Int_IsPigeonhole)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetOrderInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter Flag = new SqlParameter("@Flag", SqlDbType.Int, 4);
        Flag.Value = P_Int_Flag;
        myCmd.Parameters.Add(Flag);
        //添加参数
        SqlParameter IsMember = new SqlParameter("@IsMember", SqlDbType.Int, 4);
        IsMember.Value = P_Int_IsMember;
        myCmd.Parameters.Add(IsMember);
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.Int, 4);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);
        //添加参数
        SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.Int, 4);
        OrderID.Value = P_Int_OrderID;
        myCmd.Parameters.Add(OrderID);
        //添加参数
        SqlParameter Confirm = new SqlParameter("@Confirm", SqlDbType.Int, 4);
        Confirm.Value = P_Int_Confirm;
        myCmd.Parameters.Add(Confirm);
        //添加参数
        SqlParameter Payed = new SqlParameter("@Payed", SqlDbType.Int, 4);
        Payed.Value = P_Int_Payed;
        myCmd.Parameters.Add(Payed);
        //添加参数
        SqlParameter Shipped = new SqlParameter("@Shipped", SqlDbType.Int, 4);
        Shipped.Value = P_Int_Shipped;
        myCmd.Parameters.Add(Shipped);
        SqlParameter Finished = new SqlParameter("@Finished", SqlDbType.Int, 4);
        Finished.Value = P_Int_Finished;
        myCmd.Parameters.Add(Finished);
        //添加参数
        SqlParameter IsConfirm = new SqlParameter("@IsConfirm", SqlDbType.Int, 4);
        IsConfirm.Value = P_Int_IsConfirm;
        myCmd.Parameters.Add(IsConfirm);
        //添加参数
        SqlParameter IsPayment = new SqlParameter("@IsPayment", SqlDbType.Int, 4);
        IsPayment.Value = P_Int_IsPayment;
        myCmd.Parameters.Add(IsPayment);
        //添加参数
        SqlParameter IsConsignment = new SqlParameter("@IsConsignment", SqlDbType.Int, 4);
        IsConsignment.Value = P_Int_IsConsignment;
        myCmd.Parameters.Add(IsConsignment);
        //添加参数
        SqlParameter IsPigeonhole = new SqlParameter("@IsPigeonhole", SqlDbType.Int, 4);
        IsPigeonhole.Value = P_Int_IsPigeonhole;
        myCmd.Parameters.Add(IsPigeonhole);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
        return myCmd;
    }
    /// <summary>
    /// 删除指定订单的信息
    /// </summary>
    /// <param name="P_Int_OrderID">订单编号</param>
    public void DeleteOrderInfo(int P_Int_OrderID)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_DeleteOrderInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
        OrderID.Value = P_Int_OrderID;
        myCmd.Parameters.Add(OrderID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
    }
    /// <summary>
    /// 获取运输方式名
    /// </summary>
    /// <param name="P_Int_ShipType">运输编号</param>
    /// <returns></returns>
    public string GetShipWay(int P_Int_ShipType)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetShipWay", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter ShipType = new SqlParameter("@ShipType", SqlDbType.Int,4);
        ShipType.Value = P_Int_ShipType;
        myCmd.Parameters.Add(ShipType);
        //执行过程
        myConn.Open();
        string P_Str_ShipWay =Convert.ToString(myCmd.ExecuteScalar());
        myCmd.Dispose();
        myConn.Close();
        return P_Str_ShipWay;
    }
    /// <summary>
    /// 获取支付方式名
    /// </summary>
    /// <param name="P_Int_PayType">获取支付编号</param>
    /// <returns></returns>
    public string GetPayWay(int P_Int_PayType)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetPayWay", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter PayType = new SqlParameter("@PayType", SqlDbType.Int, 4);
        PayType.Value = P_Int_PayType;
        myCmd.Parameters.Add(PayType);
        //执行过程
        myConn.Open();
        string P_Str_PayWay = Convert.ToString (myCmd.ExecuteScalar());
        myCmd.Dispose();
        myConn.Close();
        return P_Str_PayWay;
    }
    /// <summary>
    /// 获取订单状态的Dataset数据集
    /// </summary>
    /// <param name="P_Int_OrderID">订单编号</param>
    /// <param name="P_Str_srcTable">订单信息</param>
    /// <returns>返回Dataset</returns>
    public DataSet GetStatusDS(int P_Int_OrderID,string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetStatus", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
        OrderID.Value = P_Int_OrderID;
        myCmd.Parameters.Add(OrderID);
        //执行过程
        myConn.Open();
        myCmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(myCmd);
        DataSet ds=new DataSet ();
        da.Fill(ds, P_Str_srcTable);
        myCmd.Dispose();
        myConn.Dispose();
        return ds;
    }
    /// <summary>
    /// 获取订单状态的Dataset数据集
    /// </summary>
    /// <param name="P_Int_OrderID">订单编号</param>
    /// <param name="P_Str_srcTable">订单信息</param>
    /// <returns>返回Dataset</returns>
    public DataSet GetOdIfDS(int P_Int_OrderID, string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetOdIf", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
        OrderID.Value = P_Int_OrderID;
        myCmd.Parameters.Add(OrderID);
        //执行过程
        myConn.Open();
        myCmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(myCmd);
        DataSet ds = new DataSet();
        da.Fill(ds, P_Str_srcTable);
        myCmd.Dispose();
        myConn.Dispose();
        return ds;
    }
    /// <summary>
    /// 通过订单ID代号，获取商品信息
    /// </summary>
    /// <param name="P_Int_OrderID">订单ID代号</param>
    /// <param name="P_Str_srcTable">信息</param>
    /// <returns>返回信息的数据集Ds</returns>
    public DataSet GetGIByOID(int P_Int_OrderID, string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetGIByOID", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
        OrderID.Value = P_Int_OrderID;
        myCmd.Parameters.Add(OrderID);
        //执行过程
        myConn.Open();
        myCmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(myCmd);
        DataSet ds = new DataSet();
        da.Fill(ds, P_Str_srcTable);
        myCmd.Dispose();
        myConn.Dispose();
        return ds;
    }
    /// <summary>
    ///  修改订单中的信息
    /// </summary>
    /// <param name="P_Int_OrderID">订单编号</param>
    /// <param name="P_Bl_IsConfirm">是否确认</param>
    /// <param name="P_Bl_IsPayment">是否付款</param>
    /// <param name="P_Bl_IsConsignment">是否已发货</param>
    /// <param name="P_Bl_IsPigeonhole">是否已归档</param>
    public void UpdateOI(int P_Int_OrderID,bool P_Bl_IsConfirm,bool P_Bl_IsPayment,bool P_Bl_IsConsignment,bool P_Bl_IsPigeonhole)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_UpdateOI", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
        OrderID.Value = P_Int_OrderID;
        myCmd.Parameters.Add(OrderID);
        //添加参数
        SqlParameter IsConfirm = new SqlParameter("@IsConfirm", SqlDbType.Bit, 1);
        IsConfirm.Value = P_Bl_IsConfirm;
        myCmd.Parameters.Add(IsConfirm);
        //添加参数
        SqlParameter IsPayment = new SqlParameter("@IsPayment", SqlDbType.Bit, 1);
        IsPayment.Value = P_Bl_IsPayment;
        myCmd.Parameters.Add(IsPayment);
        //添加参数
        SqlParameter IsConsignment = new SqlParameter("@IsConsignment", SqlDbType.Bit, 1);
        IsConsignment.Value = P_Bl_IsConsignment;
        myCmd.Parameters.Add(IsConsignment);
        //添加参数
        SqlParameter IsPigeonhole = new SqlParameter("@IsPigeonhole", SqlDbType.Bit, 1);
        IsPigeonhole.Value = P_Bl_IsPigeonhole;
        myCmd.Parameters.Add(IsPigeonhole);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
    }
    //*************************************************************************************************
    /// <summary>
    /// 添加商品类别名称
    /// </summary>
    /// <param name="P_Str_ClassName">商品类别名称</param>
    /// <param name="P_Str_categoryUrl">商品类别图像</param>
    /// <returns></returns>
    public int AddCategory(string P_Str_ClassName, string P_Str_categoryUrl)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_AddCategory", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter ClassName = new SqlParameter("@ClassName", SqlDbType.VarChar, 50);
        ClassName.Value = P_Str_ClassName;
        myCmd.Parameters.Add(ClassName);
        //添加参数
        SqlParameter categoryUrl = new SqlParameter("@categoryUrl", SqlDbType.VarChar, 50);
        categoryUrl.Value = P_Str_categoryUrl;
        myCmd.Parameters.Add(categoryUrl);
        //添加参数
        SqlParameter returnValue = myCmd.Parameters.Add("returnValue", SqlDbType.Int, 4);
        returnValue.Direction = ParameterDirection.ReturnValue;
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
        int P_Int_returnValue = Convert.ToInt32(returnValue.Value.ToString());
        return P_Int_returnValue;
    }
    /// <summary>
    /// 获取商品类别的数据集
    /// </summary>
    /// <param name="P_Str_srcTable">商品类别信息表名</param>