protected void Page_Load(object sender, EventArgs e)
{
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
//context.Response.Write("Hello World");
BaoKao baoKao = new BaoKao();
// baoKao.Sid= context.Request.QueryString["sid"];
Students students = (Students)Session["account"];
baoKao.Sid = students.id;
baoKao.Eid = Convert.ToInt32(Request.QueryString["eid"]);
string sql = "select * from baokao where sid='" + baoKao.Sid + "' and Eid=" + baoKao.Eid;
string str = "baokao.aspx?id=" + baoKao.Sid;
//已报考
if (SqlHelper.GetTable(sql, System.Data.CommandType.Text).Rows.Count > 0)
{
Server.Transfer(str);
}
else
{
baoKao.ApplyTime = DateTime.Now;
baoKao.Estate = 1;//待考试
examSubjectDalServer.InsertBK(baoKao);
Server.Transfer(str);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
// context.Response.Write("Hello World");
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
ExamSubject examSubject = new ExamSubject();
examSubject.id = Convert.ToInt32(context.Request.QueryString["id"]);
examSubjectDalServer.DeletSubject(examSubject);
context.Response.Redirect("SubjectManage.aspx");
}
public void ProcessRequest(HttpContext context)
{
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
context.Response.ContentType = "html/plain";
//context.Response.Write("Hello World");
BaoKao baoKao = new BaoKao();
baoKao.Sid = context.Request.QueryString["sid"];
baoKao.Eid = Convert.ToInt32(context.Request.QueryString["eid"]);
examSubjectDalServer.DeletBK(baoKao);
string str = "detailStudent.aspx?id=" + baoKao.Sid;
context.Response.Redirect(str);
}
protected void Page_Load(object sender, EventArgs e)
{
Students students = new Students();
students = (Students)Session["account"];
BaoKao baoKao = new BaoKao();
baoKao.Sid = students.id;
baoKao.Eid = Convert.ToInt32(Request.QueryString["id"]);
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
examSubjectDalServer.DeletBK(baoKao);
string str = "detailStudent.aspx?id=" + baoKao.Sid;
Response.Redirect(str);
}
public void ProcessRequest(HttpContext context)
{
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
context.Response.ContentType = "html/plain";
//context.Response.Write("Hello World");
BaoKao baoKao = new BaoKao();
baoKao.Sid = context.Request.QueryString["sid"];
baoKao.Eid = Convert.ToInt32(context.Request.QueryString["eid"]);
baoKao.ApplyTime = DateTime.Now;
baoKao.Estate = 2;
examSubjectDalServer.InsertBK(baoKao);
string str = "baokao.aspx?id=" + baoKao.Sid;
context.Response.Redirect(str);
}
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 Button1_Click(object sender, EventArgs e)
{
Major major = new Major();
major.name = TextBox1.Text;
if (major.name == "")
{
Response.Write("<script>alert('输入为空！');</script>");
return;
}
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
if (examSubjectDalServer.ExistMajor(major))
{
Response.Write("<script>alert('请勿重复添加');</script>");
}
else
{
examSubjectDalServer.AddMajor(major);
Response.Redirect("MajorManage.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
ExamSubject examSubject = new ExamSubject();
examSubject.name = Request.Form["mz"].Trim();
examSubject.ApplyStar = Convert.ToDateTime(Request.Form["as"]);
examSubject.ApplyEnd = Convert.ToDateTime(Request.Form["ae"]);
examSubject.ExamEnd = Convert.ToDateTime(Request.Form["ee"]);
examSubject.ExamStar = Convert.ToDateTime(Request.Form["es"]);
examSubject.examPlace = TextBox3.Text;
examSubject.detail = TextBox1.Text;
examSubject.classifyName = DropDownList1.SelectedValue;
Major major = null;
List <Major> mlist = new List <Major>();
for (int i = 0; i < CheckBoxList2.Items.Count; i++)
{
if (CheckBoxList2.Items[i].Selected)
{
major = new Major();
major.name = CheckBoxList2.Items[i].Text;
mlist.Add(major);
}
}
List <CheckGrade> clist = new List <CheckGrade>();
CheckGrade cg = null;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
cg = new CheckGrade();
cg.grade = CheckBoxList1.Items[i].Text;
clist.Add(cg);
}
}
ExamSubjectDalServer examSubjectDalServer = new ExamSubjectDalServer();
if (Request.Form["r1"] == "无限制")
{
clist.Clear();
}
if (Request.Form["r2"] == "无限制")
{
mlist.Clear();
}
//string
// DropDownList1.SelectedValue
//classifyName
examSubjectDalServer.AddSubject(examSubject);
examSubjectDalServer.AddMajors(mlist, clist, examSubject);
Response.Redirect("SubjectManage.aspx");
}
}
