st_addstudent.aspx.cs

来自「学生管理系统。C#开发。偏重与数据库的应用。」· CS 代码 · 共 127 行

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 ST_addstudent : System.Web.UI.Page
{
    SqlConnection st_conn;
    protected void Page_Load(object sender, EventArgs e)
    {
        //班级名称下拉列表框绑定
        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
			SqlConnection st_conn1=new SqlConnection(st_connstr);
            if (!IsPostBack)
            {
                st_conn1.Open();
                //查询所有的班级名称
                string mysql = "select * from ST_class";
                SqlCommand st_comm1 = new SqlCommand(mysql, st_conn1);
                SqlDataReader st_dr1 = st_comm1.ExecuteReader();
                //将查出的班级作为下拉列表的数据项
                while (st_dr1.Read())
                {
                    st_ddl_class.Items.Add(new ListItem(st_dr1["ST_Class_name"].ToString(), st_dr1["ST_Class_id"].ToString()));
                }
                st_conn1.Close();
            }
            // 在此处放置用户代码以初始化页面
            st_conn = new SqlConnection(st_connstr);	
    }
    protected void st_btn_ok_Click(object sender, EventArgs e)
    {
        SqlCommand st_comm = new SqlCommand("insert_student_1", st_conn);
        st_comm.CommandType = CommandType.StoredProcedure;
        try
        {
            st_comm.Parameters.Add(new SqlParameter("@Student_id", SqlDbType.VarChar, 50));
            st_comm.Parameters["@Student_id"].Value = st_tbx_id.Text;
            st_comm.Parameters.Add(new SqlParameter("@Student_name", SqlDbType.VarChar, 50));
            st_comm.Parameters["@Student_name"].Value = st_tbx_name.Text;
            st_comm.Parameters.Add(new SqlParameter("@Student_sex", SqlDbType.Char, 10));
            st_comm.Parameters["@Student_sex"].Value = st_ddl_sex.SelectedItem.Value;
            st_comm.Parameters.Add(new SqlParameter("@Student_nation", SqlDbType.Char, 10));
            st_comm.Parameters["@Student_nation"].Value = st_tbx_nation.Text;
            st_comm.Parameters.Add(new SqlParameter("@Student_birthday", SqlDbType.DateTime, 8));
            st_comm.Parameters["@Student_birthday"].Value = st_tbx_birthst_day.Text;
            st_comm.Parameters.Add(new SqlParameter("@Student_time", SqlDbType.DateTime, 8));
            st_comm.Parameters["@Student_time"].Value = st_tbx_time.Text;
            st_comm.Parameters.Add(new SqlParameter("@Student_classid", SqlDbType.VarChar, 50));
            st_comm.Parameters["@Student_classid"].Value = st_ddl_class.SelectedItem.Value;
            st_comm.Parameters.Add(new SqlParameter("@Student_home", SqlDbType.VarChar, 50));
            st_comm.Parameters["@Student_home"].Value = st_tbx_home.Text;
            st_comm.Parameters.Add(new SqlParameter("@Student_else", SqlDbType.VarChar, 50));
            st_comm.Parameters["@Student_else"].Value = st_tbx_else.Text;
            st_comm.Connection.Open();
            st_comm.ExecuteNonQuery();
            st_comm.Connection.Close();
            st_insert();
        }
        catch
        {
            st_lbl_note.Text = "添加失败,请检查输入！";
            st_lbl_note.Style["color"] = "red";
        }
    }
    public void st_insert()
    {
        string strsl = "insert into ST_users(ST_User_id,ST_User_password,ST_User_power) values(@User_id,@User_pwd,0)";
        SqlCommand st_comm = new SqlCommand(strsl, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@User_id", SqlDbType.VarChar, 50));
        st_comm.Parameters["@User_id"].Value = st_tbx_id.Text;
        st_comm.Parameters.Add(new SqlParameter("@User_pwd", SqlDbType.VarChar, 50));
        st_comm.Parameters["@User_pwd"].Value = st_tbx_id.Text;
        st_comm.Connection.Open();
        try
        {
            st_comm.ExecuteNonQuery();
            Response.Redirect("ST_student.aspx");
        }
        catch (SqlException)
        {
            st_lbl_note.Text = "添加失败";
            st_lbl_note.Style["color"] = "red";
        }
        st_comm.Connection.Close();
    }
    protected void st_btn_reset_Click(object sender, EventArgs e)
    {
        Response.Redirect("ST_addstudent.aspx");
    }
    protected void st_cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
    {
        //获得数据库连接字符串
        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
        //建立连接
        st_conn = new SqlConnection(st_connstr);
        //打开连接
        st_conn.Open();
        //创建命令字符串
        SqlCommand st_comm = new SqlCommand("select_student_1", st_conn);
        //指定为调用存储过程
        st_comm.CommandType = CommandType.StoredProcedure;
        //添加参数
        st_comm.Parameters.Add("@Student_id", SqlDbType.VarChar, 50);
        st_comm.Parameters["@Student_id"].Value = st_tbx_id.Text;
        //生成结果集
        SqlDataReader st_dr = st_comm.ExecuteReader();
        //存在性判断，返回结果
        if (st_dr.Read())
        {
            args.IsValid = false;
        }
        else
        {
            args.IsValid = true;
        }
        //关闭连接
        st_conn.Close();
    }
}