/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
User user = Session["User"] as User;
TeacherBLL teacherBLL = new TeacherBLL();
Teacher teacher = teacherBLL.getByUserId(user.Id);
CommonBLL commBLL = new CommonBLL();
GridView1.DataSource = commBLL.getClassesByTeacherId(teacher.Id);
GridView1.DataBind();
}
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();
}
public void bind()
{
User user = (User)Session["user"];
TeacherBLL teacherBll = new TeacherBLL();
Teacher teacher = teacherBll.getByUserId(user.Id);
CommonBLL commonBll = new CommonBLL();
DataTable dt = commonBll.getAllRecordByRecordId(teacher.Id);
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.getPaged(dt, from, to);
GridView1.DataBind();
}
private void bind()
{
User user = (User)Session["user"];
TeacherBLL teachBll = new TeacherBLL();
Teacher teacher = teachBll.getByUserId(user.Id);
CommonBLL commonBll = new CommonBLL();
// 根据教师ID得到课程信息
string filter = "1=1";
filter += weekId.SelectedIndex == 0 ? "" : " and week='" + weekId.SelectedValue + "'";
DataTable dt = PageUtil.getProcessedDataTable(commonBll.getWorkAttendanceByTeachID(teacher.Id), filter);
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.getPaged(dt, from, to);
GridView1.DataBind();
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string studID = Request.QueryString["studID"].ToString();
CommonBLL commBLL = new CommonBLL();
User user = (User)Session["user"];
TeacherBLL teacherBll = new TeacherBLL();
Teacher teacher = teacherBll.getByUserId(user.Id);
string filter = "teacherID='" + teacher.Id + "'";
DataTable dt = PageUtil.getProcessedDataTable(commBLL.getDetailStudentAttendStatistics(studID, true), filter);
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.getPaged(dt, from, to);
GridView1.DataBind();
}
public void bind()
{
string classID = Request.QueryString["classID"].ToString();
string courID = Request.QueryString["courId"].ToString();
//courseName.Text = new CourseBLL().get(courID).Name;//courseName改成className
className.Text = new ClassBLL().get(classID).Name;
User user = (User)Session["user"];
TeacherBLL teacherBll = new TeacherBLL();
Teacher teacher = teacherBll.getByUserId(user.Id);
CommonBLL commBLL = new CommonBLL();
DataTable dt = commBLL.getClassStudentAttendStatistics(classID,teacher.Id, true);
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.getPaged(dt, from, to);
GridView1.DataBind();
}
