teachertj.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 TeacherTJ : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = Session["uid"].ToString() + "，欢迎您来到教师管理首页! ";
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection myconnection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        DBConnection conn = new DBConnection();
        
        string enumber = TextBox1.Text.ToString();
        string ename = TextBox2.Text.ToString();
        string etime = TextBox3.Text.ToString();
        string eaddress = TextBox4.Text.ToString();
       
        string str1 = TextBox6.Text.ToString();

        int n = Convert.ToInt32(str1);

        
       
            string sql = "select * from shiyan where enumber ='" + enumber + "'";
            SqlDataReader recm = conn.ExecuteReader(sql);
            if (recm.Read())
            { 
                Label3.Text = "该实验号已经被使用,请换一个!" ;
            }
          
            else
            {
                recm.Close();
                string sqlstr = "insert into shiyan values('" + enumber + "','" + ename + "','" + etime + "','" + eaddress + "','" + Session["uid"] + "','" + n + "','" + 0 + "')";
                SqlDataReader rs4 = conn.ExecuteReader(sqlstr);
                Page.Response.Redirect("Succeed.aspx");                        
             }
                      
    }
}