protected void Page_Load(object sender, EventArgs e) { if (Session["account"] == null) { Response.Write("<script>alert(\"请先登录!\");</script>"); Server.Transfer("index.aspx"); return; } Students students = new Students(); students = (Students)Session["account"]; //更新科目状态 string sql1 = "update baokao set Estate=2 where eid in ( select eid from baokao,examsubject where ExamEnd<'" + DateTime.Now + "' and Estate=1 and eid=id) and sid='" + students.id + "'"; // Response.Write(sql1); SqlHelper.GetExecuteNonQuery(sql1, CommandType.Text); MessageDalServer messageDalServer = new MessageDalServer(); Students st = new Students(); // st.id= Context.Request.QueryString["id"]; st = (Students)Session["account"]; //Response.Write(st.id); StudentsDalServer studentsDalServer = new StudentsDalServer(); ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer(); BaoKao bk = new BaoKao(); bk.Sid = st.id; examSubjectsList = examSubjectDalServer.BKtable(bk); Sstudents = studentsDalServer.SelectId(st); GetData(); if (!IsPostBack) { } }
protected void Button3_Click(object sender, EventArgs e) { // check() Students students = new Students(); var AderssUser = Request.UserHostAddress; StudentsDalServer studentsDalServer = new StudentsDalServer(); students.id = TextBox1.Text; //students.id = "asdsadadssadfsg"; //Response.Write(Request.Form["name"]+ students.id); students.name = TextBox3.Text; students.pwd = TextBox2.Text; students.grade = Request.Form["grade"]; students.major = DropDownList1.Text; students.imgUal = Image2.ImageUrl; students.state = 1;//学生状态默认为1 students.tel = tel.Text; students.emil = emil.Text; students.academy = academy.Text; students.state = 3; // Response.Write(students.ToString()); Students st = new Students(); st = studentsDalServer.SelectId(students); if (st.id == null) { students.img = new byte[1]; studentsDalServer.Add(students); Response.Redirect("addSuccess.html"); } else { Response.Write("<script>alert('此账号已被注册!')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { StudentsDalServer studentsDalServer = new StudentsDalServer(); StudentsList = studentsDalServer.GetTable(); }
protected void Button1_Click(object sender, EventArgs e) { if (Request.Form["id"] == "" || Request.Form["pwd"] == "") { return; } if (Request.Form["fx"] == "1")//学生登录 { StudentsDalServer studentsDalServer = new StudentsDalServer(); Students students = new Students(); students.id = Request.Form["id"]; students.pwd = Request.Form["pwd"]; if (studentsDalServer.login(students))//是否允许登录 { // students.GetType() Session["account"] = students; Session["type"] = "student"; // string str= "detailStudent.aspx?id="+students.id;//传去学生学号 // Server.Transfer(str); Server.Transfer("detailStudent.aspx"); } else { Response.Write("<script>alert('用户名或密码错误!')</script>"); } } else if (Request.Form["fx"] == "2")//管理员登录 { BASE_USERDalServer bASE_USERDalServer = new BASE_USERDalServer(); BASE_USER bASE_USER = new BASE_USER(); bASE_USER.pwd = Request.Form["pwd"]; bASE_USER.name = Request.Form["id"]; if (bASE_USERDalServer.login(bASE_USER)) { Session["account"] = bASE_USER; Session["type"] = "baseUser"; string str = "BaseUser.aspx"; Server.Transfer(str); } else { Response.Write("<script>alert('用户名或密码错误!')</script>"); } } else { BASE_USERDalServer bASE_USERDalServer = new BASE_USERDalServer(); teachers = new Teachers(); teachers.pwd = Request.Form["pwd"]; teachers.account = Request.Form["id"]; teachers = bASE_USERDalServer.loginTeacher(teachers); if (teachers.id == null) { Response.Write("<script>alert('用户名或密码错误!')</script>"); } else { Session["account"] = teachers; Session["type"] = "teacher"; string str = "Teacher.aspx"; //Response.Redirect(str); Server.Transfer(str); } } }