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);
}
}
}
