mangerclass.cs

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

        myCmd.Parameters.Add(ShipWay);
        //添加参数
        SqlParameter ShipFee = new SqlParameter("@ShipFee", SqlDbType.Float , 8);
        ShipFee.Value = P_Flt_ShipFee;
        myCmd.Parameters.Add(ShipFee);
       
        //添加参数
        SqlParameter ClassID = new SqlParameter("@ClassID", SqlDbType.BigInt, 8);
        ClassID.Value = P_int_ClassID;
        myCmd.Parameters.Add(ClassID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
    public void UpdateShip(int P_Int_ShipID, string P_Str_ShipWay, float P_Flt_ShipFee, int P_int_ClassID)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_UpdateShipInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter ShipID = new SqlParameter("@ShipID", SqlDbType.BigInt, 8);
        ShipID.Value = P_Int_ShipID;
        myCmd.Parameters.Add(ShipID);
        //添加参数
        SqlParameter ShipWay = new SqlParameter("@ShipWay", SqlDbType.VarChar, 50);
        ShipWay.Value = P_Str_ShipWay;
        myCmd.Parameters.Add(ShipWay);
        //添加参数
        SqlParameter ShipFee = new SqlParameter("@ShipFee", SqlDbType.Float , 8);
        ShipFee.Value = P_Flt_ShipFee;
        myCmd.Parameters.Add(ShipFee);

        //添加参数
        SqlParameter ClassID = new SqlParameter("@ClassID", SqlDbType.BigInt, 8);
        ClassID.Value = P_int_ClassID;
        myCmd.Parameters.Add(ClassID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
    //*********************************************************************************************
    /// <summary>
    /// 获取支付方式的数据集
    /// </summary>
    /// <param name="P_Str_srcTable">支付方式表的信息</param>
    /// <returns>返回支付方式的数据集</returns>
    public DataSet ReturnPayDs(string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetPayInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //执行过程
        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_PayID">支付方式ID</param>
    /// <param name="P_Str_srcTable">支付方式信息</param>
    /// <returns></returns>
    public DataSet ReturnPayDsByID(int P_Int_PayID, string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetPayInfoByID", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter PayID = new SqlParameter("@PayID", SqlDbType.BigInt, 8);
        PayID.Value = P_Int_PayID;
        myCmd.Parameters.Add(PayID);
        //执行过程
        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_PayID">指定支付方式的ID</param>
    public void DeletePayInfo(int P_Int_PayID)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_DeletePayInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter PayID = new SqlParameter("@PayID", SqlDbType.BigInt, 8);
        PayID.Value = P_Int_PayID;
        myCmd.Parameters.Add(PayID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
    public void InsertPay(string P_Str_PayWay)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_InsertPayInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter PayWay = new SqlParameter("@PayWay", SqlDbType.VarChar, 50);
        PayWay.Value = P_Str_PayWay;
        myCmd.Parameters.Add(PayWay);  
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
    public void UpdatePay(int P_Int_PayID, string P_Str_PayWay)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_UpdatePayInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter PayID = new SqlParameter("@PayID", SqlDbType.BigInt, 8);
        PayID.Value = P_Int_PayID;
        myCmd.Parameters.Add(PayID);
        //添加参数
        SqlParameter PayWay = new SqlParameter("@PayWay", SqlDbType.VarChar, 50);
        PayWay.Value = P_Str_PayWay;
        myCmd.Parameters.Add(PayWay);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
   //*********************************************************
    /// <summary>
    /// 查询所有配送地点信息
    /// </summary>
    /// <param name="P_Str_srcTable">地点表信息</param>
    /// <returns>返回所有配送地点信息数据集</returns>
    public DataSet ReturnAreaDs(string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetAreaInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //执行过程
        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_AreaID">地点编号</param>
    public void DeleteAreaInfo(int P_Int_AreaID)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_DeleteAreaInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter AreaID = new SqlParameter("@AreaID", SqlDbType.BigInt, 8);
        AreaID.Value = P_Int_AreaID;
        myCmd.Parameters.Add(AreaID);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
    /// <summary>
    /// 查询指定地点编号信息的数据集
    /// </summary>
    /// <param name="P_Int_AreaID">地点编号</param>
    /// <param name="P_Str_srcTable">地点数据表</param>
    /// <returns>返回指定地点编号信息的数据集</returns>
    public DataSet ReturnAreaDsByID(int P_Int_AreaID, string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetAreaInfoByID", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter AreaID = new SqlParameter("@AreaID", SqlDbType.BigInt, 8);
        AreaID.Value = P_Int_AreaID;
        myCmd.Parameters.Add(AreaID);
        //执行过程
        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;
    }
    public void InsertArea(string P_Str_AreaName,int P_Int_AreaKM)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_InsertAreaInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter AreaName = new SqlParameter("@AreaName", SqlDbType.VarChar, 50);
        AreaName.Value = P_Str_AreaName;
        myCmd.Parameters.Add(AreaName);
        //添加参数
        SqlParameter AreaKM = new SqlParameter("@AreaKM", SqlDbType.Int, 4);
        AreaKM.Value = P_Int_AreaKM;
        myCmd.Parameters.Add(AreaKM);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
    public void UpdateArea(int P_Int_AreaID,string P_Str_AreaName, int P_Int_AreaKM)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_UpdateAreaInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter AreaID = new SqlParameter("@AreaID", SqlDbType.BigInt, 8);
        AreaID.Value = P_Int_AreaID;
        myCmd.Parameters.Add(AreaID);
        //添加参数
        SqlParameter AreaName = new SqlParameter("@AreaName", SqlDbType.VarChar, 50);
        AreaName.Value = P_Str_AreaName;
        myCmd.Parameters.Add(AreaName);
        //添加参数
        SqlParameter AreaKM = new SqlParameter("@AreaKM", SqlDbType.Int, 4);
        AreaKM.Value = P_Int_AreaKM;
        myCmd.Parameters.Add(AreaKM);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();

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

        }
    }
    /// <summary>
    /// 用来将字符串保留到指定长度，将超出部分用“...”代替。
    /// </summary>
    /// <param name="sString">sString原字符串。</param>
    /// <param name="nLeng">nLeng长度。</param>
    /// <returns>处理后的字符串。</returns>
    public string SubStr(string sString, int nLeng)
    {
        if (sString.Length <= nLeng)
        {
            return sString;
        }
        int nStrLeng = nLeng - 3;
        string sNewStr = sString.Substring(0, nStrLeng);
        sNewStr = sNewStr + "...";
        return sNewStr;
    }
    /// <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));
    }

}