//绑定搜索到的教师数据 protected void DataListBind() { DalOperationUsers dos = new DalOperationUsers(); DataView dv = dos.SearchTeacher(txtKeyword.Text.Trim(), ddltTeacherType.SelectedValue).Tables[0].DefaultView; this.AspNetPager2.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = CommonUtility.pageSize; this.dlSearchTeacher.DataSource = pds; this.dlSearchTeacher.DataBind(); if (pds.Count > 0) { dlSearchTeacher.ShowFooter = false; } }
/// <summary> /// /// </summary> /// <param name="termTag"></param> /// <param name="searchKey"></param> /// <param name="teacherType"></param> /// <returns></returns> public DataSet getTeacherLoad(string termTag,string searchKey,string teacherType) { DataSet ds = new DataSet(); DataTable datatable = new DataTable(); DataSet normDs = GetFirstNorms(termTag); DataTable dt = normDs.Tables[0]; int[] ids = new int[dt.Rows.Count]; datatable.Columns.Add("教师"); datatable.Columns.Add("硕士教学"); for (int i = 0; i < dt.Rows.Count; i++) { datatable.Columns.Add(dt.Rows[i]["name"].ToString()); ids[i] = Convert.ToInt32( dt.Rows[i]["normId"]); } datatable.Columns.Add("合计"); ds.Tables.Add(datatable); datatable.TableName = "工作汇总"; DalOperationUsers daluser = new DalOperationUsers(); DataTable teachers = daluser.SearchTeacher(searchKey, teacherType).Tables[0]; DataTable normValues = GetNormValuesByTerm(termTag).Tables[0]; for (int i = 0; i < teachers.Rows.Count; i++) { DataRow dr = datatable.NewRow(); dr.SetField(datatable.Columns[0], teachers.Rows[i]["teacherName"].ToString().Trim()); DataRow[] shuoshirows = normValues.Select("normId=-1 and teacherNo='" + teachers.Rows[i]["teacherNo"].ToString().Trim() + "'"); if (shuoshirows.Length == 0) { dr.SetField(datatable.Columns[1], 0); } else { dr.SetField(datatable.Columns[1], shuoshirows[0]["value"]); } for (int j = 2; j < datatable.Columns.Count - 1; j++) { Object value = null; DataRow[] rows = normValues.Select("normId=" + ids[j - 2] + " and teacherNo='" + teachers.Rows[i]["teacherNo"].ToString().Trim() + "'"); if (GetNormType(ids[j - 2]) == 0) { if (rows.Length > 0) value = rows[0]["value"]; float factValue = 0; if (value != null) { factValue = float.Parse(value.ToString()); } dr.SetField(datatable.Columns[j], factValue); } else { if (rows.Length > 0) dr.SetField(datatable.Columns[j], rows[0]["textValue"]); } } DataRow[] rootrow = normValues.Select("normId=" + 0 + " and teacherNo='" + teachers.Rows[i]["teacherNo"].ToString().Trim() + "'"); object roots = null; if (rootrow.Length > 0) roots = rootrow[0]["value"]; float rootValue = 0; if (roots != null) { rootValue = float.Parse(roots.ToString()); } dr.SetField("合计", rootValue); datatable.Rows.Add(dr); } DataTable shuoshitable = new DataTable(); shuoshitable.TableName = "硕士教学"; shuoshitable.Columns.Add("教师"); shuoshitable.Columns.Add("课程名称"); shuoshitable.Columns.Add("学期"); shuoshitable.Columns.Add("类型"); shuoshitable.Columns.Add("理论课时"); shuoshitable.Columns.Add("实验课时"); DataTable shuoshinormChildValues = this.GetChildNorms(-1,termTag).Tables[0]; for (int i = 0; i < shuoshinormChildValues.Rows.Count; i++) { shuoshitable.Columns.Add(shuoshinormChildValues.Rows[i]["name"].ToString()); } for (int i = 0; i < teachers.Rows.Count; i++) { DataTable shuoshit = this.GetCourseStatistic(teachers.Rows[i]["teacherNo"].ToString().Trim(), termTag); for (int rownum = 0; rownum < shuoshit.Rows.Count; rownum++) { DataRow dr = shuoshitable.NewRow(); dr.SetField(shuoshitable.Columns[0], teachers.Rows[i]["teacherName"].ToString().Trim()); for (int col = 3; col < shuoshit.Columns.Count; col++) { dr.SetField(shuoshit.Columns[col].ColumnName, shuoshit.Rows[rownum][shuoshit.Columns[col]].ToString().Trim()); } shuoshitable.Rows.Add(dr); } } ds.Tables.Add(shuoshitable); for (int ci = 0; ci < dt.Rows.Count; ci++) { DataTable childTable = new DataTable(); childTable.TableName = dt.Rows[ci]["name"].ToString(); DataTable normChildValues = this.GetChildNorms(int.Parse(dt.Rows[ci]["normId"].ToString()),termTag).Tables[0]; int[] dids = new int[normChildValues.Rows.Count]; childTable.Columns.Add("教师"); for (int i = 0; i < normChildValues.Rows.Count; i++) { childTable.Columns.Add(normChildValues.Rows[i]["name"].ToString()); dids[i] = Convert.ToInt32(normChildValues.Rows[i]["normId"]); } for (int i = 0; i < teachers.Rows.Count; i++) { DataRow dr = childTable.NewRow(); dr.SetField(childTable.Columns[0], teachers.Rows[i]["teacherName"].ToString().Trim()); for (int j = 1; j < childTable.Columns.Count; j++) { Object value = null; DataRow[] rows = normValues.Select("normId=" + dids[j - 1] + " and teacherNo='" + teachers.Rows[i]["teacherNo"].ToString().Trim() + "'"); if (GetNormType(dids[j - 1]) == 0) { if (rows.Length > 0) value = rows[0]["value"]; float factValue = 0; if (value != null) { factValue = float.Parse(value.ToString()); } dr.SetField(childTable.Columns[j], factValue); } else { if (rows.Length > 0) dr.SetField(childTable.Columns[j], rows[0]["textValue"]); } } childTable.Rows.Add(dr); } ds.Tables.Add(childTable); } conn.Close(); return ds; }
//绑定搜索到的教师数据 protected void DataListBind() { UserAuth auth = dalua.GetUserAuth(pageName); if (auth != null) { string ids = auth.userIds; string[] _ids = ids.Split(','); for (int i = 0; i < _ids.Length; i++) { authIds.Add(_ids[i]); } } DalOperationUsers dos = new DalOperationUsers(); DataView dv = dos.SearchTeacher(txtKeyword.Text.Trim(), ddltTeacherType.SelectedValue).Tables[0].DefaultView; this.AspNetPager2.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = CommonUtility.pageSize; this.dlSearchTeacher.DataSource = pds; this.dlSearchTeacher.DataBind(); if (pds.Count > 0) { dlSearchTeacher.ShowFooter = false; } }