/// 列表查询
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public ActionResult TeachAttendanceOriginal(TeachAttendanceOriginalListSearchModel search)
{
search.ComCode = UserSession.comcode;
TeachAttendanceOriginalListViewModel model = new TeachAttendanceOriginalListViewModel(); //页面模型
model.search = search; //页面的搜索模型
model.search.PageSize = 15; //每页显示
model.search.CurrentPage = Convert.ToInt32(Request["pageindex"]) <= 0 ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页
model.AttendanceOriginallist = TeachAttendanceOriginalData.GetAttendanceOriginalDataList(search); //填充页面模型数据
return(View(model)); //返回页面模型
}
/// <summary>
/// 分页获取考勤识别列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public static PagedList <vw_AttendanceOriginal> GetAttendanceOriginalDataList(TeachAttendanceOriginalListSearchModel 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 AND len(UserID) <=5");
if (!string.IsNullOrWhiteSpace(search.username))//姓名
{
sb.AppendFormat(" and username like '%{0}%' ", search.username);
}
if (!string.IsNullOrWhiteSpace(search.InputDate_start))//开班时间
{
sb.AppendFormat(" and workDates > = '{0}' ", search.InputDate_start);
}
if (!string.IsNullOrWhiteSpace(search.InputDate_end))//结束时间
{
sb.AppendFormat(" and workDates <= '{0}' ", search.InputDate_end + " 23:59:59");
}
if (!string.IsNullOrEmpty(search.ComCode))
{
if (search.ComCode == "1")//顺普
{
sb.AppendFormat(" and [iMachineNumber] = 1 ", search.username);
}
else if (search.ComCode == "3")
{
sb.AppendFormat(" and [iMachineNumber] = 7 ", search.username);
}
}
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));
}
