userinfoclass.cs

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

        }
    }
    //*********************************结账********************************************************
    public void ddlCityBind(DropDownList ddlName)
    {
     SqlConnection myConn=dbObj.GetConnection();
     string P_Str_Sqlstr="select * from tb_Area";
     SqlDataAdapter da = new SqlDataAdapter(P_Str_Sqlstr, myConn);
     DataSet ds = new DataSet();
     da.Fill(ds,"Area");
     ddlName.DataSource = ds.Tables["Area"].DefaultView;
     ddlName.DataTextField = ds.Tables["Area"].Columns[1].ToString();
     ddlName.DataValueField = ds.Tables["Area"].Columns[2].ToString();
     ddlName.DataBind();
    
    }
    public void ddlShipBind(DropDownList ddlName)
    {
        SqlConnection myConn = dbObj.GetConnection();
        string P_Str_Sqlstr = "select * from tb_ShipType";
        SqlDataAdapter da = new SqlDataAdapter(P_Str_Sqlstr, myConn);
        DataSet ds = new DataSet();
        da.Fill(ds, "Ship");
        ddlName.DataSource = ds.Tables["Ship"].DefaultView;
        ddlName.DataTextField = ds.Tables["Ship"].Columns[1].ToString();
        ddlName.DataValueField = ds.Tables["Ship"].Columns[0].ToString();
        ddlName.DataBind();  
    }
    public void ddlPayBind(DropDownList ddlName)
    {
        SqlConnection myConn = dbObj.GetConnection();
        string P_Str_Sqlstr = "select * from tb_PayType";
        SqlDataAdapter da = new SqlDataAdapter(P_Str_Sqlstr, myConn);
        DataSet ds = new DataSet();
        da.Fill(ds, "Pay");
        ddlName.DataSource = ds.Tables["Pay"].DefaultView;
        ddlName.DataTextField = ds.Tables["Pay"].Columns[1].ToString();
        ddlName.DataValueField = ds.Tables["Pay"].Columns[0].ToString();
        ddlName.DataBind();   
    }
    public int AddOrderInfo(float P_Flt_GoodsFee, float P_Flt_ShipFee, int P_Int_ShipType, int P_Int_PayType, int P_Int_MemberID, string P_Str_RName, string P_Str_RPhone, string P_Str_RPostCode, string P_Str_RAddress, string P_Str_REmails)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_InsertOrderInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;

        //添加参数
        SqlParameter GoodsFee = new SqlParameter("@GoodsFee", SqlDbType.Float, 8);
        GoodsFee.Value = P_Flt_GoodsFee;
        myCmd.Parameters.Add(GoodsFee);
        //添加参数
        SqlParameter ShipFee = new SqlParameter("@ShipFee", SqlDbType.Float , 8);
        ShipFee.Value = P_Flt_ShipFee;
        myCmd.Parameters.Add(ShipFee);
        //添加参数
        SqlParameter ShipType = new SqlParameter("@ShipType", SqlDbType.Int,4);
        ShipType.Value = P_Int_ShipType;
        myCmd.Parameters.Add(ShipType);
        //添加参数
        SqlParameter PayType = new SqlParameter("@PayType", SqlDbType.Int, 4);
        PayType.Value = P_Int_PayType;
        myCmd.Parameters.Add(PayType);
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID ", SqlDbType.BigInt,8);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);
        //添加参数
        SqlParameter RName = new SqlParameter("@RName", SqlDbType.VarChar, 50);
        RName.Value = P_Str_RName;
        myCmd.Parameters.Add(RName);
        //添加参数
        SqlParameter RPhone = new SqlParameter("@RPhone", SqlDbType.VarChar, 50);
        RPhone.Value = P_Str_RPhone;
        myCmd.Parameters.Add(RPhone);
        //添加参数
        SqlParameter RPostCode = new SqlParameter("@RPostCode", SqlDbType.Char, 10);
        RPostCode.Value = P_Str_RPostCode;
        myCmd.Parameters.Add(RPostCode);
        //添加参数
        SqlParameter RAddress = new SqlParameter("@RAddress", SqlDbType.VarChar, 200);
        RAddress.Value = P_Str_RAddress;
        myCmd.Parameters.Add(RAddress);
        
        //添加参数
        SqlParameter REmails = new SqlParameter("@REmails", SqlDbType.VarChar, 50);
        REmails.Value = P_Str_REmails;
        myCmd.Parameters.Add(REmails);
        //添加参数
        SqlParameter OrderID = myCmd.Parameters.Add("@OrderID", SqlDbType.BigInt,8);
        OrderID.Direction = ParameterDirection.Output;
       
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);

        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();
        }
        return Convert.ToInt32(OrderID.Value);
      

    }
    public void  AddBuyInfo(int P_Int_GoodsID, int P_Int_Num, int P_Int_OrderID, float  P_Flt_SumPrice, int P_Int_MemberID)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_InsertBuy", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter GoodsID = new SqlParameter("@GoodsID", SqlDbType.BigInt, 4);
        GoodsID.Value = P_Int_GoodsID;
        myCmd.Parameters.Add(GoodsID);
        //添加参数
        SqlParameter Num = new SqlParameter("@Num", SqlDbType.Int, 4);
        Num.Value = P_Int_Num;
        myCmd.Parameters.Add(Num);
        //添加参数
        SqlParameter OrderID = new SqlParameter("@OrderID", SqlDbType.BigInt, 8);
        OrderID.Value = P_Int_OrderID;
        myCmd.Parameters.Add(OrderID);
        //添加参数
        SqlParameter SumPrice = new SqlParameter("@SumPrice", SqlDbType.Float , 8);
        SumPrice.Value = P_Flt_SumPrice;
        myCmd.Parameters.Add(SumPrice);
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID ", SqlDbType.BigInt, 8);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);

        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();
        }
    }
    /// <summary>
    /// 查询购物车中的信息
    /// </summary>
    /// <param name="P_Int_MemberID">会员ID</param>
    /// <param name="P_Str_srcTable">信息表</param>
    /// <returns>返回购物车中的信息的数据集</returns>
    public DataSet ReturnSCDs(int P_Int_MemberID, string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetSCI", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.BigInt, 8);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
        SqlDataAdapter da = new SqlDataAdapter(myCmd);
        DataSet ds = new DataSet();
        da.Fill(ds, P_Str_srcTable);
        return ds;

    }
    /// <summary>
    /// 当购物车中的信息已生成订单后，删除购物车中的信息
    /// </summary>
    /// <param name="P_Int_MemberID">会员ID</param>
    public void DeleteSCInfo(int P_Int_MemberID)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_DeleteSC", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.BigInt, 8);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        } 
    }
   /// <summary>
   ///　获取运输费用
   /// </summary>
   /// <param name="P_Int_GoodsID">商品ID</param>
   /// <param name="P_Str_ShipWay">运输方式</param>
    /// <returns>返回运输费用</returns>
    public float  GetSFValue(int P_Int_GoodsID,string P_Str_ShipWay)
    {


        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GSF", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter GoodsID = new SqlParameter("@GoodsID", SqlDbType.BigInt, 8);
        GoodsID.Value = P_Int_GoodsID;
        myCmd.Parameters.Add(GoodsID);
        //添加参数
        SqlParameter ShipWay = new SqlParameter("@ShipWay", SqlDbType.VarChar,50);
        ShipWay.Value = P_Str_ShipWay;
        myCmd.Parameters.Add(ShipWay);
        //添加参数
        SqlParameter returnValue = myCmd.Parameters.Add("returnvalue", SqlDbType.Float, 8);
        returnValue.Direction = ParameterDirection.ReturnValue;
        //执行过程
        myConn.Open();
        myCmd.ExecuteScalar();
        try
        { 
            if (Convert.ToInt32(returnValue.Value) == 100)
                return 100;
            else
            { 
                float  P_Flt_SF=float.Parse(myCmd.ExecuteScalar().ToString());
                return P_Flt_SF;
            }
        
        }
        catch(Exception ex)
        {
            throw (ex);
        
        }
        finally
        {
         myCmd.Dispose();
        myConn.Close();
        
        }
        
    }
    /// <summary>
    /// 用会员卡结账时，对会员卡的修改
    /// </summary>
    /// <param name="P_Int_MemberID">会员ID</param>
    /// <param name="P_Flt_GoodsFee">商品总费用</param>
    /// <param name="P_Flt_ShipFee">运输费用</param>
    /// <returns>查看会员卡中的钱是否能购买商品</returns>
    public int  IsUserCart(int P_Int_MemberID, float P_Flt_GoodsFee, float P_Flt_ShipFee)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_IsUserCart", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.BigInt, 8);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);
        //添加参数
        SqlParameter GoodsFee = new SqlParameter("@GoodsFee", SqlDbType.Float, 8);
        GoodsFee.Value = P_Flt_GoodsFee;
        myCmd.Parameters.Add(GoodsFee);
        //添加参数
        SqlParameter ShipFee = new SqlParameter("@ShipFee", SqlDbType.Float , 8);
        ShipFee.Value = P_Flt_ShipFee;
        myCmd.Parameters.Add(ShipFee);
        //添加参数
        SqlParameter returnValue = myCmd.Parameters.Add("returnvalue", SqlDbType.Float , 8);
        returnValue.Direction=ParameterDirection.ReturnValue;
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();

        }
        return int.Parse(returnValue.Value.ToString());
       
    }
    /// <summary>
    /// 用来截取小数点后nleng位
    /// </summary>
    /// <param name="sString">sString原字符串。</param>
    /// <param name="nLeng">nLeng长度。</param>
    /// <returns>处理后的字符串。</returns>
    public string VarStr(string sString, int nLeng)
    {
        int index = sString.IndexOf(".");
        if (index == -1 || index + 2 >= sString.Length)
            return sString;
        else
            return sString.Substring(0, (index + nLeng + 1));
    }


}