/// 列表查询 /// </summary> /// <param name="search"></param> /// <returns></returns> public ActionResult AttendanceOriginal(AttendanceOriginalListSearchModel search) { AttendanceOriginalListViewModel model = new AttendanceOriginalListViewModel(); //页面模型 model.search = search; //页面的搜索模型 model.search.PageSize = 15; //每页显示 model.search.CurrentPage = Convert.ToInt32(Request["pageindex"]) <= 0 ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页 AttendanceOriginalData.DealAttendanceOriginal(UserSession.userid); model.AttendanceOriginallist = AttendanceOriginalData.GetAttendanceOriginalDataList(search); //填充页面模型数据 return(View(model)); //返回页面模型 }
/// <summary> /// 分页获取考勤识别列表 /// </summary> /// <param name="search"></param> /// <returns></returns> public static PagedList <vw_AttendanceOriginal> GetAttendanceOriginalDataList(AttendanceOriginalListSearchModel search) { string table = string.Empty, fields = string.Empty, orderby = string.Empty, where = string.Empty; //定义结构 fields = @" * "; //输出字段 table = @" vw_AttendanceOriginal "; //表或者视图 orderby = "InputDate desc"; //排序信息 StringBuilder sb = new StringBuilder(); //构建where条件 sb.Append(" 1=1 "); if (!string.IsNullOrWhiteSpace(search.username))//姓名 { sb.AppendFormat(" and username like '%{0}%' ", search.username); } if (!string.IsNullOrWhiteSpace(search.UserID))//学号 { sb.AppendFormat(" and UserID like '%{0}%' ", search.UserID); } if (!string.IsNullOrWhiteSpace(search.ClassName))//班级名称 { sb.AppendFormat(" and ClassName like '%{0}%' ", search.ClassName); } if (!string.IsNullOrWhiteSpace(search.InputDate_start))//开班时间 { sb.AppendFormat(" and InputDate > = '{0}' ", search.InputDate_start); } if (!string.IsNullOrWhiteSpace(search.InputDate_end))//结束时间 { sb.AppendFormat(" and InputDate <= '{0}' ", search.InputDate_end); } where = sb.ToString(); int allcount = 0; var list = CommonPage <vw_AttendanceOriginal> .GetPageList( out allcount, table, fields : fields, where : where.Trim(), orderby : orderby, pageindex : search.CurrentPage, pagesize : search.PageSize, connect : DBKeys.PRX); return(new PagedList <vw_AttendanceOriginal>(list, search.CurrentPage, search.PageSize, allcount)); }