register.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 Register : System.Web.UI.Page
{
    private ArrayList alYear;
    private ArrayList alMonth;
    private ArrayList alDay;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.Session["userID"]== null)
        {
            Response.Redirect("Login.aspx");
        }
        else
        {
            if (!this.IsPostBack)
            {
                InitData();
            }
        }
    }
    private void InitData()
    {
        alYear = new ArrayList();
        alMonth = new ArrayList();
        alDay = new ArrayList();

        for (int i = 1950; i < 2100; i++)
            alYear.Add(i.ToString());

        for (int i = 1; i <= 12; i++)
            alMonth.Add(i.ToString());

        for (int i = 1; i < 32; i++)
            alDay.Add(i.ToString());

        ddlYear.DataSource = alYear;
        ddlYear.DataBind();

        ddlMonth.DataSource = alMonth;
        ddlMonth.DataBind();

        ddlDay.DataSource = alDay;
        ddlDay.DataBind();
    }
    /// <summary>
    /// 验证用户是否存在按钮事件
    /// </summary>
    protected void btnValidate_Click(object sender, EventArgs e)
    {
        int i=userNameValidate(); //调用验证方法        
    }
    /// <summary>
    /// 验证用户是否存在方法
    /// </summary>
    private int userNameValidate()
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DBConnectionString"]);//创建连接数据库对象
        SqlCommand selectCmd = new SqlCommand("select * from Users where userId='" + txtName.Text.Trim() + "'", conn); //创建操作数据库对象
        int i = 0;
        try
        {
            conn.Open();   //打开连接
            SqlDataReader sdr = selectCmd.ExecuteReader();//从数据库读取记录
            if (sdr.Read())
            {
                i = 1;
                lblMessage.Text = "此用户名已存在，请输入其他用户名！";//给出提示信息
            }
            else
            {
                lblMessage.Text = "此用户名可用！";   //给出提示信息
            }
        }
        catch (System.Exception ee)
        {
            Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
        }
        finally
        {
            conn.Close();
        }
        return i;
    }
    /// <summary>
    /// 注册按钮事件
    /// </summary>
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        int i=userNameValidate();
        if (i == 0)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DBConnectionString"]);//创建连接数据库对象
            SqlCommand insertCmd = new SqlCommand("insert into Users values(@userId,@userPwd,@userName,@userSex,@userBirth,@userPhone,@userMobilePhone,@userCode,@userAddress,@userEmail,@userQQ)", conn);
            insertCmd.Parameters.Add("@userId", SqlDbType.VarChar,15);   //为Command对象添加参数
            insertCmd.Parameters.Add("@userPwd", SqlDbType.VarChar, 20);
            insertCmd.Parameters.Add("@userName", SqlDbType.VarChar, 20);
            insertCmd.Parameters.Add("@userSex", SqlDbType.VarChar, 2);
            insertCmd.Parameters.Add("@userBirth", SqlDbType.DateTime, 8);
            insertCmd.Parameters.Add("@userPhone", SqlDbType.VarChar, 15);
            insertCmd.Parameters.Add("@userMobilePhone", SqlDbType.VarChar, 11);
            insertCmd.Parameters.Add("@userCode", SqlDbType.VarChar, 6);
            insertCmd.Parameters.Add("@userAddress", SqlDbType.VarChar, 200);
            insertCmd.Parameters.Add("@userEmail", SqlDbType.VarChar, 100);
            insertCmd.Parameters.Add("@userQQ", SqlDbType.VarChar, 20);
            insertCmd.Parameters["@userId"].Value = txtName.Text;         //给参数赋值
            insertCmd.Parameters["@userPwd"].Value=txtPwd.Text;
            insertCmd.Parameters["@userName"].Value=txtUname.Text;
            insertCmd.Parameters["@userSex"].Value=rltSex.SelectedItem.Text;
            insertCmd.Parameters["@userBirth"].Value=Convert.ToDateTime(ddlYear.SelectedValue+"-"+ddlMonth.SelectedValue+"-"+ddlDay.SelectedValue);
            insertCmd.Parameters["@userPhone"].Value=txtUtel2.Text;
            insertCmd.Parameters["@userMobilePhone"].Value = txtUtel3.Text;
            insertCmd.Parameters["@userCode"].Value=txtUzip.Text;
            insertCmd.Parameters["@userAddress"].Value=txtUaddr.Text;
            insertCmd.Parameters["@userEmail"].Value=txtUemail.Text;
            insertCmd.Parameters["@userQQ"].Value=txtUQQ.Text;
            try
            {
                conn.Open();      //打开连接
                int flag = insertCmd.ExecuteNonQuery();  //执行插入
                if (flag > 0)
                {
                    Response.Write("<script language=javascript>alert('成功完成注册！')</script>");
                }
                else 
                {
                    Response.Write("<script language=javascript>alert('注册失败！请检查输入是否符合要求')</script>");
                }
                Response.Redirect("Login.aspx");
            }
            catch (System.Exception ee)
            {
                Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
            }
            finally
            {
                conn.Close();        //关闭连接        
            }
        }
    }
}