userinfoclass.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>
/// UserInfoClass 的摘要说明
/// </summary>
public class UserInfoClass
{
    DBClass dbObj = new DBClass();
	public UserInfoClass()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    //***************************************登录界面************************************************************
    /// <summary>
    /// 判断用户是否存在
    /// </summary>
    /// <param name="P_Str_Name">会员登录名</param>
    /// <param name="P_Str_Password">会员登录密码</param>
    /// <returns></returns>
    public int UserExists(string P_Str_Name,string P_Str_Password)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_UserExists", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
        Name.Value = P_Str_Name;
        myCmd.Parameters.Add(Name);
        //添加参数
        SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
        Password.Value = P_Str_Password;
        myCmd.Parameters.Add(Password);
        //添加参数
        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_Name">会员登录名</param>
  /// <param name="P_Str_Password">会员登录密码</param>
  /// <param name="P_Str_srcTable">查询表信息</param>
  /// <returns></returns>
    public DataSet ReturnUIDs(string P_Str_Name, string P_Str_Password,string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetUserInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
        Name.Value = P_Str_Name;
        myCmd.Parameters.Add(Name);
        //添加参数
        SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
        Password.Value = P_Str_Password;
        myCmd.Parameters.Add(Password);
        //执行过程
        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_Str_Name">会员名</param>
    /// <param name="P_Bl_Sex">性别</param>
    /// <param name="P_Str_Password">密码</param>
    /// <param name="P_Str_TrueName">真实姓名</param>
    /// <param name="P_Str_Questions">找回密码问题</param>
    /// <param name="P_Str_Answers">找回密码答案</param>
    /// <param name="P_Str_Phonecode">电话号码</param>
    /// <param name="P_Str_Emails">E_Mail</param>
    /// <param name="P_Str_City">会员所在城市</param>
    /// <param name="P_Str_Address">会员详细地址</param>
    /// <param name="P_Str_PostCode">邮编</param>
    /// <param name="P_Flt_AdvancePayment">预付金额</param>
    /// <param name="P_Date_LoadDate">登录日期</param>
    public int AddUInfo(string P_Str_Name, bool P_Bl_Sex, string P_Str_Password, string P_Str_TrueName, string P_Str_Questions, string P_Str_Answers, string P_Str_Phonecode, string P_Str_Emails, string P_Str_City, string P_Str_Address, string P_Str_PostCode)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_InsertUInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
        Name.Value = P_Str_Name;
        myCmd.Parameters.Add(Name);
        //添加参数
        SqlParameter sex = new SqlParameter("@sex", SqlDbType.Bit,1);
        sex.Value = P_Bl_Sex;
        myCmd.Parameters.Add(sex);
        //添加参数
        SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
        Password.Value = P_Str_Password;
        myCmd.Parameters.Add(Password);
        //添加参数
        SqlParameter TrueName = new SqlParameter("@TrueName", SqlDbType.VarChar, 50);
        TrueName.Value = P_Str_TrueName;
        myCmd.Parameters.Add(TrueName);
        //添加参数
        SqlParameter Questions = new SqlParameter("@Questions", SqlDbType.VarChar, 50);
        Questions.Value = P_Str_Questions;
        myCmd.Parameters.Add(Questions);
        //添加参数
        SqlParameter Answers = new SqlParameter("@Answers", SqlDbType.VarChar, 50);
        Answers.Value = P_Str_Answers;
        myCmd.Parameters.Add(Answers);
        //添加参数
        SqlParameter Phonecode = new SqlParameter("@Phonecode", SqlDbType.VarChar, 20);
        Phonecode.Value = P_Str_Phonecode;
        myCmd.Parameters.Add(Phonecode);
        //添加参数
        SqlParameter Emails = new SqlParameter("@Emails", SqlDbType.VarChar, 50);
        Emails.Value = P_Str_Emails;
        myCmd.Parameters.Add(Emails);
        //添加参数
        SqlParameter City = new SqlParameter("@City", SqlDbType.VarChar, 50);
        City.Value = P_Str_City;
        myCmd.Parameters.Add(City);
        //添加参数
        SqlParameter Address = new SqlParameter("@Address", SqlDbType.VarChar, 200);
        Address.Value = P_Str_Address;
        myCmd.Parameters.Add(Address);
        //添加参数
        SqlParameter PostCode = new SqlParameter("@PostCode", SqlDbType.Char, 10);
        PostCode.Value = P_Str_PostCode;
        myCmd.Parameters.Add(PostCode);
        //添加参数
        SqlParameter MemberId = myCmd.Parameters.Add("@MemberId",SqlDbType.BigInt,8);
        MemberId.Direction = ParameterDirection.Output;
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw(ex);
           
        }
        finally
        {
             myCmd.Dispose();
             myConn.Close();
        }
        return Convert.ToInt32(MemberId.Value.ToString());
      
    }
    /// <summary>
    /// 修改会员充值
    /// </summary>
    /// <param name="P_Int_MemberID">会员ID</param>
    /// <param name="P_Flt_AdvancePayment">充值金额</param>
    public void UpdateAP(int P_Int_MemberID, float P_Flt_AdvancePayment)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_UpdateAP", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.BigInt, 8);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);
        //添加参数
        SqlParameter AdvancePayment = new SqlParameter("@AdvancePayment", SqlDbType.Float, 8);
        AdvancePayment.Value = P_Flt_AdvancePayment;
        myCmd.Parameters.Add(AdvancePayment);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);

        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();
        }
      
    
    }
    //********************************更新用户信息*************************************************
    /// <summary>
    /// 获取会员信息
    /// </summary>
    /// <param name="P_Int_MemberID">会员编号</param>
    /// <param name="P_Str_srcTable">表的信息</param>
    /// <returns></returns>
    public DataSet ReturnUIDsByID(int P_Int_MemberID, string P_Str_srcTable)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_GetUIByID", 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_Str_Name">会员名</param>
    /// <param name="P_Bl_Sex">性别</param>
    /// <param name="P_Str_Password">密码</param>
    /// <param name="P_Str_TrueName">真实姓名</param>
    /// <param name="P_Str_Questions">找回密码问题</param>
    /// <param name="P_Str_Answers">找回密码答案</param>
    /// <param name="P_Str_Phonecode">电话号码</param>
    /// <param name="P_Str_Emails">E_Mail</param>
    /// <param name="P_Str_City">会员所在城市</param>
    /// <param name="P_Str_Address">会员详细地址</param>
    /// <param name="P_Str_PostCode">邮编</param>
    /// <param name="P_Flt_AdvancePayment">预付金额</param>
    /// <param name="P_Date_LoadDate">登录日期</param>
    public void  UpdateUInfo(string P_Str_Name, bool P_Bl_Sex, string P_Str_Password, string P_Str_TrueName, string P_Str_Questions, string P_Str_Answers, string P_Str_Phonecode, string P_Str_Emails, string P_Str_City, string P_Str_Address, string P_Str_PostCode,int P_Int_MemberID)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Proc_UpdateUIbyID", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
        Name.Value = P_Str_Name;
        myCmd.Parameters.Add(Name);
        //添加参数
        SqlParameter sex = new SqlParameter("@sex", SqlDbType.Bit, 1);
        sex.Value = P_Bl_Sex;
        myCmd.Parameters.Add(sex);
        //添加参数
        SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
        Password.Value = P_Str_Password;
        myCmd.Parameters.Add(Password);
        //添加参数
        SqlParameter TrueName = new SqlParameter("@TrueName", SqlDbType.VarChar, 50);
        TrueName.Value = P_Str_TrueName;
        myCmd.Parameters.Add(TrueName);
        //添加参数
        SqlParameter Questions = new SqlParameter("@Questions", SqlDbType.VarChar, 50);
        Questions.Value = P_Str_Questions;
        myCmd.Parameters.Add(Questions);
        //添加参数
        SqlParameter Answers = new SqlParameter("@Answers", SqlDbType.VarChar, 50);
        Answers.Value = P_Str_Answers;
        myCmd.Parameters.Add(Answers);
        //添加参数
        SqlParameter Phonecode = new SqlParameter("@Phonecode", SqlDbType.VarChar, 20);
        Phonecode.Value = P_Str_Phonecode;
        myCmd.Parameters.Add(Phonecode);
        //添加参数
        SqlParameter Emails = new SqlParameter("@Emails", SqlDbType.VarChar, 50);
        Emails.Value = P_Str_Emails;
        myCmd.Parameters.Add(Emails);
        //添加参数
        SqlParameter City = new SqlParameter("@City", SqlDbType.VarChar, 50);
        City.Value = P_Str_City;
        myCmd.Parameters.Add(City);
        //添加参数
        SqlParameter Address = new SqlParameter("@Address", SqlDbType.VarChar, 200);
        Address.Value = P_Str_Address;
        myCmd.Parameters.Add(Address);
        //添加参数
        SqlParameter PostCode = new SqlParameter("@PostCode", SqlDbType.Char, 10);
        PostCode.Value = P_Str_PostCode;
        myCmd.Parameters.Add(PostCode);
        //添加参数
        SqlParameter MemberId = new SqlParameter("@MemberId", SqlDbType.BigInt, 8);
        MemberId.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberId);