/// <summary> /// 绑定数据源 /// </summary> private void bind() { string id = Request.QueryString["id"].ToString(); AttendanceBLL attendBLL = new AttendanceBLL(); attend = attendBLL.get(id); CourseTableBLL ctBLL = new CourseTableBLL(); CourseTable ct = ctBLL.get(attend.CourTableID); ClassBLL classBLL = new ClassBLL(); TeacherBLL teacherBLL = new TeacherBLL(); CourseBLL courseBLL = new CourseBLL(); StudentBLL stuBLL = new StudentBLL(); #region 绑定页面数据 Label_class.Text = classBLL.get(ct.ClassID).Name; Label_course.Text = courseBLL.get(ct.CourId).Name; Label_teacher.Text = teacherBLL.get(ct.TeachID).Name; Label_student.Text = stuBLL.get(attend.StudID).Name; Label_oldStatus.Text = attend.Status; Label_week.Text = ct.Week; Label_weekDay.Text = ct.WeekDay; Label_courseTime.Text = ct.CourseTime; Label_place.Text = ct.Place; #endregion }
protected void Button_submit_Click(object sender, EventArgs e) { ClassBLL classBLL = new ClassBLL(); if (!string.IsNullOrEmpty(classBLL.get(DropDownList_class.SelectedValue).MonitorID)) { AttendanceBLL attendBLL = new AttendanceBLL(); Attendance attend = new Attendance(); attend.Status = DropDownList_status.SelectedValue; attend.Remark = ""; attend.Recorder = "班长"; attend.RecorderID = classBLL.get(DropDownList_class.SelectedValue).MonitorID; attend.StudID = DropDownList_student.SelectedValue; attend.CourTableID = Label_courTableId.Text; attendBLL.save(attend); Response.Write("<script>alert('添加成功!');location.href='increaseStudentAttendanceRecords.aspx';</script>"); } else { Response.Write("<script>alert('添加失败!该班级没有班长!');location.href='increaseStudentAttendanceRecords.aspx';</script>"); } }
public object get(string id) { Attendance att = null; string selectSql = "SELECT * FROM t_attendance WHERE ID=@ID"; SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", id) }; DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas); if (ds.Tables[0].Rows.Count != 0) { att = new Attendance(); att.Id = ds.Tables[0].Rows[0][0].ToString(); att.Status = ds.Tables[0].Rows[0][1].ToString(); att.Remark = ds.Tables[0].Rows[0][2].ToString(); att.Recorder = ds.Tables[0].Rows[0][3].ToString(); att.RecorderID = ds.Tables[0].Rows[0][4].ToString(); att.StudID = ds.Tables[0].Rows[0][5].ToString(); att.CourTableID = ds.Tables[0].Rows[0][6].ToString(); } return att; }
protected void ImageButton_delete_Click(object sender, EventArgs e) { LinkButton linkButton = sender as LinkButton; string id = linkButton.CommandArgument; Attendance attend = new Attendance(); attend.Id = id; AttendanceBLL attendBLL = new AttendanceBLL(); attendBLL.delete(attend); Response.Write("<script>alert('删除成功!');location.href='attendanceStatistics.aspx';</script>"); }
public void bind() { courTableID = Request.QueryString["courTableID"]; User user = Session["User"] as User; TeacherBLL teachBLL = new TeacherBLL(); StudentBLL studBLL = new StudentBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); CourseTable ct = ctBLL.get(courTableID); ClassBLL classBll = new ClassBLL(); Class cla = classBll.get(ct.ClassID); className.Text = cla.Name; dt = studBLL.getByClassId(ct.ClassID).Tables[0]; if (Session["attenList"] != null) { attenList = Session["attenList"] as List<Attendance>; } else { attenList = new List<Attendance>(); foreach (DataRow dr in dt.Rows) { Attendance attend = new Attendance(); attend.Status = "正常"; attend.Remark = ""; attend.Recorder = "教师"; attend.RecorderID = teachBLL.getByUserId(user.Id).Id; attend.StudID = dr["ID"].ToString(); attend.CourTableID = courTableID; attenList.Add(attend); } } AspNetPager1.RecordCount = dt.Rows.Count; int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1; int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1; GridView1.DataSource = PageUtil.resort(PageUtil.getPaged(dt, from, to)); GridView1.DataBind(); initStatusAndRemark(); }
protected void Button_submit_Click(object sender, EventArgs e) { AttendanceBLL attendBLL = new AttendanceBLL(); Attendance attend = new Attendance(); attend.Status = DropDownList_status.SelectedValue; attend.Remark = ""; attend.Recorder = "教师"; attend.RecorderID = DropDownList_teacher.SelectedValue; attend.StudID = DropDownList_student.SelectedValue; attend.CourTableID = Label_courTableId.Text; attendBLL.save(attend); Response.Write("<script>alert('添加成功!');location.href='increaseStudentAttendanceRecords.aspx';</script>"); }