register.aspx.cs

小型物理试验管理系统Management system for small-scale physical experiments

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
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection myconnection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        DBConnection conn = new DBConnection();
        
        string username = USER.Text.ToString();
        string pass1 = PASSWORD1.Text.ToString();
        string pass2 = PASSWORD2.Text.ToString();
        string name = NAME.Text.ToString();
        string number = NUMBER.Text.ToString();
        string tag = "";
        string email = EMAIL.Text.ToString();
        string str1 = "";
        if (this.RadioButtonList1.Items[0].Selected == true)
        {    
            str1 = "学生";
        }
        if (this.RadioButtonList1.Items[1].Selected == true)
        {
            str1 = "教师";
        }
        if (pass1 == pass2)
        {
            string sql = "select * from yonghu where number ='" + number + "'and name='" + name + "'";
            SqlDataReader recm = conn.ExecuteReader(sql);
            if (recm.Read())
            { 
                recm.Close();
                sql = "select tag from yonghu where number ='"+number+"'";
                SqlDataReader rs = conn.ExecuteReader(sql);

                if (rs.Read())
                {
                    tag = rs["tag"].ToString();
                    Label1.Text = tag;
                    rs.Close();
                    if (tag == "false")
                    {
                        sql = "update yonghu set username='" + username + "'where number ='" + number + "'";
                        SqlDataReader rs1 = conn.ExecuteReader(sql);
                        rs1.Close();
                        sql = "update yonghu set pwd='" + pass1 + "'where number ='" + number + "'";
                        SqlDataReader rs2 = conn.ExecuteReader(sql);
                        rs2.Close();
                        sql = "update yonghu set email='" + email + "'where number ='" + number + "'";
                        SqlDataReader rs3 = conn.ExecuteReader(sql);
                        rs3.Close();
                        sql = "update yonghu set tag = 'true' where number ='" + number + "'";
                        SqlDataReader rs4 = conn.ExecuteReader(sql);
                        Page.Response.Redirect("Succeed.aspx");                        
                    }
                    else
                    {
                        Label1.Text = "您已经注册过！";
                    } 
                }
            }
            else
            {
                Label1.Text = "不存在该" + str1;
            }
        }
        else
        {
            label.Text = "两次密码输入不同！";
            PASSWORD1.Text = "";
            PASSWORD2.Text = "";
        }
    }
}