protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int CourseId = Convert.ToInt32(Request.Params["CourseId"]); StuNum = new CourseManege().QueryStuNum(CourseId); coursename.Text = (new CourseManege().queryCourseById(CourseId)).CourseName; List <Model.Class> clalist = new CourseManege().queryClassByCourseId(CourseId); string ClassId; foreach (Model.Class Class in clalist) { ClassId = Class.ClassId; ddlclass.Items.Add(ClassId); } List <Students> stulist = new StudentManage().queryStudentByCourseId(CourseId); foreach (Students stu in stulist) { stu.KqNum = new KqManage().queryStuKqNum(stu.StuId, CourseId); stu.HwNum = new HomeworkManage().queryStuHwNum(stu.StuId, CourseId); } Repeater1.DataSource = stulist; Repeater1.DataBind(); List <Homework> HwList = new HomeworkManage().queryAllHKByTea(CourseId); DataList2.DataSource = HwList; DataList2.DataBind(); List <KQ> KqList = new KqManage().queryAllKq(CourseId); Repeater2.DataSource = KqList; Repeater2.DataBind(); List <JXGG> gglist = new GGManage().LookJXGG(CourseId); Repeater3.DataSource = gglist; Repeater3.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { int KQId = Convert.ToInt32(Request.Params["KQId"]); int CourseId = Convert.ToInt32(Request.Params["CourseId"]); List <Students> stuCheckedlist = new KqManage().queryCheckedStu(KQId); Repeater1.DataSource = stuCheckedlist; Repeater1.DataBind(); List <Students> stuUnchecklist = new KqManage().queryUncheckStu(KQId, CourseId); Repeater2.DataSource = stuUnchecklist; Repeater2.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { DateTime KqTime = DateTime.Now; int minutes = Convert.ToInt32(TextBox1.Text.Trim()); KQ kq = new KQ() { CourseId = Convert.ToInt32(Request.Params["CourseId"]), KqTime = DateTime.Now, EndTime = KqTime.AddMinutes(minutes) }; int result = new KqManage().publishAttendance(kq); if (result > 0) { Response.Write("<script>window.alert('发布成功!');history.go(-2)</script>"); } }
//签到 protected void Button3_Click(object sender, EventArgs e) { int KQId = Convert.ToInt32(((Button)sender).CommandArgument); int StuId = Convert.ToInt32(((Model.Login)Session["CurrentUser"]).UserName); DateTime time = DateTime.Now; int result = new KqManage().AddKqRecord(StuId, KQId, time); if (result == 1) { Response.Write("<script>window.alert('签到成功!');</script>"); } if (result == -1) { Response.Write("<script>window.alert('请勿重复签到!');</script>"); } if (result == -2) { Response.Write("<script>window.alert('签到超时!');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int StuId = ((Model.Login)Session["CurrentUser"]).UserName; int CourseId = Convert.ToInt32(Request.Params["CourseId"]); coursename.Text = (new CourseManege().queryCourseById(CourseId)).CourseName; //绑定未完成作业 List <Homework> ufhkList = new HomeworkManage().queryUnfinishedHw(CourseId, StuId); DataList1.DataSource = ufhkList; DataList1.DataBind(); //绑定已完成作业 List <Homework> fhkList = new HomeworkManage().queryfinishedHw(CourseId, StuId); DataList3.DataSource = fhkList; DataList3.DataBind(); //绑定已审批作业 List <Homework> chkList = new HomeworkManage().querycheckedHw(CourseId, StuId); DataList4.DataSource = chkList; DataList4.DataBind(); //绑定考勤 List <KQ> KqList = new KqManage().queryAllKq(CourseId); foreach (KQ kq in KqList) { int State = new KqManage().HasChecked(StuId, kq.KQId); if (State > 0) { kq.state = "已签到"; } else { kq.state = "<span style='color:red;'>未签到<span>"; } } DataList2.DataSource = KqList; DataList2.DataBind(); //绑定公告 List <JXGG> gglist = new GGManage().LookJXGG(CourseId); Repeater3.DataSource = gglist; Repeater3.DataBind(); } }