/// <summary>
/// 分页获取学生列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public static PagedList <vw_AttendanceRecord> GetAttendanceRecordList(StudentScheduleSearchModel search)
{
string table = string.Empty, fields = string.Empty, orderby = string.Empty, where = string.Empty; //定义结构
fields = @" * "; //输出字段
table = @" vw_AttendanceRecord "; //表或者视图
orderby = "ID"; //排序信息
StringBuilder sb = new StringBuilder(); //构建where条件
sb.Append(" 1=1 ");
if (!string.IsNullOrWhiteSpace(search.Name)) //学员姓名
{
sb.AppendFormat(" and Name like '%{0}%' ", search.Name);
}
//if (search.timeStart != null && search.timeEnd != null)//时间
// sb.AppendFormat(" and ClassDate between '{0}' and '{1}'", search.timeStart, search.timeEnd);
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.AttendanceRecord_StudentID))//学号
{
sb.AppendFormat(" and StudentID ='{0}' ", search.AttendanceRecord_StudentID);
}
if (!string.IsNullOrWhiteSpace(search.AttendanceRecord_ID))//vw_AttendanceRecord ID
{
sb.AppendFormat(" and ID ='{0}' ", search.AttendanceRecord_ID);
}
if (!string.IsNullOrWhiteSpace(search.StudentID))//vw_AttendanceRecord ID
{
sb.AppendFormat(" and StudentID ='{0}' ", search.StudentID);
}
if (!string.IsNullOrWhiteSpace(search.ComCode))//校区
{
sb.AppendFormat(" and [ComCode] = '{0}' ", search.ComCode);
}
where = sb.ToString();
int allcount = 0;
var list = CommonPage <vw_AttendanceRecord> .GetPageList(
out allcount, table, fields : fields, where : where.Trim(),
orderby : orderby, pageindex : search.CurrentPage, pagesize : search.PageSize, connect : DBKeys.PRX);
return(new PagedList <vw_AttendanceRecord>(list, search.CurrentPage, search.PageSize, allcount));
}
//
// GET: /Curriculum/
public ActionResult StudentScheduleList(StudentScheduleSearchModel search)
{
StudentScheduleListViewModel model = new StudentScheduleListViewModel(); //页面模型
model.search = search; //页面的搜索模型
model.search.PageSize = 15; //每页显示
model.search.CurrentPage = Convert.ToInt32(Request["pageindex"]) <= 0 ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页
//分校下拉项
List <CommonEntity> ComCodeIL = CommonData.Get_SYS_Company_COMP_Code(UserSession.comcode);//分校
model.search.ComCodeIL = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL);
if (UserSession.comcode != null && UserSession.comcode != "1")
{
search.ComCode = UserSession.comcode;//默认查询当前分校的人员
}
model.AttendanceRecordlist = StudentScheduleListData.GetAttendanceRecordList(search); //填充页面模型数据
return(View(model)); //返回页面模型
}
/// <summary>
/// 查询上课记录
/// </summary>
/// <returns></returns>
public ActionResult FSConnectionlist(StudentScheduleSearchModel search)
{
WX_FSConnectionlistModel model = new WX_FSConnectionlistModel();
model.search = search;
model.search.PageSize = 15; //每页显示15条数据
model.search.CurrentPage = model.search.CurrentPage <= 0 ? 1 : model.search.CurrentPage; //获取当前页
Students s = StudentData.GetStudentByAccountID(UserSessionWX.userid); //获取学员
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";//对日期做特殊处理,取最后一个星期的最大值
}
if (s != null)
{
search.AttendanceRecord_StudentID = s.ID;//获取学号
}
PagedList <vw_AttendanceRecord> vw_AttendanceRecord = StudentScheduleListData.GetAttendanceRecordList(search);//查询学员课程表
model.FSConnectionlist = vw_AttendanceRecord;
return(View(model));
}
