?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 static string connstr = "Server=localhost;Database=Materialsystem;User ID=sa";
    SqlConnection stuinfoconn = new SqlConnection(connstr);
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void regbutton_Click(object sender, EventArgs e)
    {
        SqlCommand testcomm = new SqlCommand("SELECT count(*) FROM Studentinfo WHERE Snum='" + numtextbox.Text.ToString().Trim() + "'", stuinfoconn);
        if (stuinfoconn.State == ConnectionState.Closed)
        {
            stuinfoconn.Open();
            int n = (int)testcomm.ExecuteScalar();
            stuinfoconn.Close();
            if (n > 0)
            {
                Response.Redirect("<script>alert('用戶名已存在！');</script>");
            }
            else
            {
                string sexstr, sdeptstr;
                if (womanradiobutton.Checked)
                {
                    sexstr = womanradiobutton.Text;
                }
                else
                {
                    sexstr = manradiobutton.Text;
                }
                sdeptstr = DropDownList1.SelectedValue;
                SqlCommand insertstu = new SqlCommand("INSERT INTO Studentinfo VALUES('" + numtextbox.Text.ToString().Trim() + "','" + nametextbox.Text.ToString().Trim() + "','" + sexstr + "','" + sdeptstr + "','" + majortextbox.Text.ToString().Trim() + "','" + classtextbox.Text.ToString().Trim() + "')", stuinfoconn);
                stuinfoconn.Open();
                insertstu.ExecuteNonQuery();
                stuinfoconn.Close();
                SqlCommand insertcard = new SqlCommand("INSERT INTO Cardinfo VALUES('" + cardnumtextbox.Text.ToString().Trim() + "','" + numtextbox.Text.ToString().Trim() + "','" + cardpwdtextbox.Text.ToString().Trim() + "')", stuinfoconn);
                stuinfoconn.Open();
                insertcard.ExecuteNonQuery();
                stuinfoconn.Close();
                Response.Write("<script>alert('注冊成功，請登錄！');</script>");

            }

        }
    }
    protected void rebutton_Click(object sender, EventArgs e)
    {
        numtextbox.Text = "";
        nametextbox.Text = "";
        majortextbox.Text = "";
        classtextbox.Text = "";
        cardnumtextbox.Text = "";
        cardpwdtextbox.Text="";
        suretextbox.Text="";
    }
}