reg.aspx.cs

图书销售系统源码

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class Reg : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

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

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

                SqlParameter accountparameter = mycmd.Parameters.Add("@UserAccount", SqlDbType.NVarChar, 50);
                accountparameter.Value = tbx_user.Text;

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

                SqlParameter userpwd = mycmd.Parameters.Add("@UserPwd", SqlDbType.NVarChar, 50);
                userpwd.Value = tbx_pwd.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("UserCenter/Default.aspx");
            }
        }

    }
    //检查用户名是否可用
    public bool IsUsed()
    {
        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        //创建数据库连接对象
        SqlConnection myconn = new SqlConnection(settings);
        //打开数据库连接
        myconn.Open();

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

        //命令参数
        SqlParameter accountparameter = mycmd.Parameters.Add("@UserAccount", SqlDbType.NVarChar, 50);
        accountparameter.Value = tbx_user.Text.Trim();

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

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

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

    protected void btn_clear_Click(object sender, EventArgs e)
    {
        tbx_user.Text = "";
        tbx_email.Text = "";
    }
}