register.aspx.cs

完成一个网上书店系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data.SqlClient;

public partial class register : System.Web.UI.Page
{
    Class1 db = new Class1();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    
    protected void Button2_Click(object sender, EventArgs e)
    {//注册用户，写入用户表
        if (Page.IsValid && IsUsed() && UserNameLength() && PwdLength())
        {
            //读取数据库连接字符串
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["BookShopConnectionString"]);
            //创建数据库连接对象
            SqlConnection myconn = new SqlConnection(settings);
            //打开数据库连接
            myconn.Open();

            //创建数据库命令
            SqlCommand mycmd = new SqlCommand("AddUser", myconn);
            //设置数据库命令类型为存储过程
            mycmd.CommandType = CommandType.StoredProcedure;

            SqlParameter UserNameparameter = mycmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 50);
            UserNameparameter.Value = TextBox3.Text;

            SqlParameter Emailparameter = mycmd.Parameters.Add("@EMail", SqlDbType.NVarChar, 50);
            Emailparameter.Value = TextBox6.Text;

            SqlParameter Password = mycmd.Parameters.Add("@Password", SqlDbType.NVarChar, 50);
            Password.Value = TextBox4.Text;


            SqlParameter Address = mycmd.Parameters.Add("@Address", SqlDbType.NVarChar, 50);
            Address.Value = TextBox7.Text;

           // SqlParameter UserID = mycmd.Parameters.Add("UserID", SqlDbType.Int);
          //  UserID.Direction = ParameterDirection.Output;

            mycmd.ExecuteNonQuery();
            myconn.Close();
            Session["Level"] = '1';
          //  Session["UserID"] = UserID.Value;
            //定向用户页面
            Response.Redirect("Default.aspx");
        }
    }
    //检查用户名是否可用
    public bool IsUsed()
    {
        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["BookShopConnectionString"]);
        //创建数据库连接对象
        SqlConnection myconn = new SqlConnection(settings);
        //打开数据库连接
        myconn.Open();

        //创建数据库命令
        SqlCommand mycmd = new SqlCommand("CheckUser", myconn);
        //设置数据库命令类型为存储过程
        mycmd.CommandType = CommandType.StoredProcedure;

        //命令参数
        SqlParameter UserNameparameter = mycmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 50);
        UserNameparameter.Value = TextBox3.Text.Trim();

        SqlDataReader mydr = mycmd.ExecuteReader();
        try
        {
            if (mydr.Read())
            {
                Label9.Text = "该用户名已经被使用";
                Label9.Visible = true;
                return false;
            }
            else
            {
                return true;
            }
        }
        finally
        {
            //关闭操作
            mydr.Close();
            myconn.Close();
        }
    }
    public bool UserNameLength()
    {
        //获取用户名长度
        int length = TextBox3.Text.Length;

        if (length < 4)
        {
            Label9.Text = "用户名长度太短";
            Label9.Visible = true;
            return false;
        }
        else if (length > 16)
        {
            Label9.Text = "用户名长度太长";
            Label9.Visible = true;
            return false;
        }
        else
        {
            return true;
        }
    }
    public bool PwdLength()
    {
        //获取用户名长度
        int length = TextBox4.Text.Length;

        if (length < 4)
        {
            Label9.Text = "密码太短";
            Label9.Visible = true;
            return false;
        }
        else if (length > 12)
        {
            Label9.Text = "密码太长";
            Label9.Visible = true;
            return false;
        }
        else
        {
            return true;
        }
    }

   
    protected void Button3_Click(object sender, EventArgs e)
    {
        TextBox3.Text = "";
        TextBox6.Text = "";

    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        //验证用户名
        string name = TextBox3.Text;
        string sql = "select * from Users where UserName='" + name + "'";
        SqlDataReader dr = db.Reader(sql);
        if (dr.Read())
        {
            Label8.Text = "用户名已存在";
        }
        else
        {
            Label8.Text = "恭喜您，可以使用";
        }
    }
}