/// <summary> /// 分页获取教师上课表 /// </summary> /// <param name="search"></param> /// <returns></returns> public static PagedList <vw_ClassAttendanceList> GetAttendanceRecordList(TeacherClassListSearch search) { string table = string.Empty, fields = string.Empty, orderby = string.Empty, where = string.Empty; //定义结构 fields = @" * "; //输出字段 table = @" vw_ClassAttendanceList "; //表或者视图 orderby = "ClassIndex"; //排序信息 StringBuilder sb = new StringBuilder(); //构建where条件 sb.Append(" 1=1 "); if (!string.IsNullOrWhiteSpace(search.timeStart))//开班时间 { sb.AppendFormat(" and ClassDate > = '{0}' ", search.timeStart); } if (!string.IsNullOrWhiteSpace(search.timeEnd))//结束时间 { sb.AppendFormat(" and ClassDate <= '{0}' ", search.timeEnd); } if (!string.IsNullOrWhiteSpace(search.teacherID))//vw_AttendanceRecord ID { sb.AppendFormat(" and (TeacherID ='{0}' or Teacher2ID ='{0}') ", search.teacherID); } where = sb.ToString(); int allcount = 0; var list = CommonPage <vw_ClassAttendanceList> .GetPageList( out allcount, table, fields : fields, where : where.Trim(), orderby : orderby, pageindex : search.CurrentPage, pagesize : search.PageSize, connect : DBKeys.PRX); return(new PagedList <vw_ClassAttendanceList>(list, search.CurrentPage, search.PageSize, allcount)); }
//GET: /TeacherClass/ //<summary> //教师对应的上课记录 //</summary> //<returns></returns> public ActionResult TeacherClassList(TeacherClassListSearch search) { WX_TeacherClassListViewModel model = new WX_TeacherClassListViewModel(); model.search = search; model.search.PageSize = 15; model.search.CurrentPage = Convert.ToInt32(Request["CurrentPage"]) <= 0 ? 1 : Convert.ToInt32(Request["CurrentPage"]);//获取当前页 DateTime dt = DateTime.Now; //当前时间 //本周,以星期天为第一天 //DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一 //DateTime endWeek = startWeek.AddDays(6); //本周周日 int weeknow = Convert.ToInt32(dt.DayOfWeek); //因为是以星期一为第一天,所以要判断weeknow等于0时,要向前推6天。 weeknow = (weeknow == 0 ? (7 - 1) : (weeknow - 1)); int daydiff = (-1) * weeknow; //本周第一天 DateTime startWeek = dt.AddDays(daydiff); //星期天为最后一天 int weeknow1 = Convert.ToInt32(dt.DayOfWeek); weeknow1 = (weeknow1 == 0 ? 7 : weeknow1); int daydiff1 = (7 - weeknow1); //本周最后一天 DateTime endWeek = dt.AddDays(daydiff1); if (search.timeStart == null) { string timeStart = startWeek.ToString("yyyy-MM-dd"); search.timeStart = timeStart += " 00:00:00:000"; string timeEnd = endWeek.ToString("yyyy-MM-dd"); search.timeEnd = timeEnd += " 23:59:59.999"; } else { //上课时间-开始时间 search.timeStart = search.timeStart += " 00:00:00:000";//对日期做特殊处理,取第一个星期的最小值 // 上课时间-结束时间 search.timeEnd = search.timeEnd += " 23:59:59.999";//对日期做特殊处理,取最后一个星期的最大值 } search.PageSize = model.search.PageSize * model.search.CurrentPage;//微信端显示数量 search.CurrentPage = 1; Teachers s = TeacherData.GetTeachByMobilePhone(UserSessionWX.userid);//获取当前教师 if (s != null) { model.search.teacherID = s.ID; model.TeacherClassList = TeacherClassData.GetAttendanceRecordList(search); model.search.TotalPageCount = model.TeacherClassList.TotalPageCount; } else { } return(View(model)); }