/// <summary> /// 获取签到数据列表 /// </summary> /// <param name="option"></param> /// <returns></returns> public ActionResult SearchSignInRecords(SignInRecordPageOption option) { var data = _sigInRecordRespository.QuerySignInRecordByPage(option); return(Json(new DataResult() { Data = data, Status = true, Notify = "" })); }
public PageInfo <List <SignInRecord> > QuerySignInRecordByPage(SignInRecordPageOption option) { string sqlFilter = option.GetFilterStr; sqlFilter = string.IsNullOrEmpty(sqlFilter) ? "" : " where " + sqlFilter; string dataSql = $@"select * from( select *, row_number() over({option.BuildOrderByStr()}) num from SignInRecord {sqlFilter} ) as tbc where {option.BuildRangeStr("num")}"; string countSql = $"select count(*) from SignInRecord {sqlFilter}"; var data = DapperHelper.Instance.Page <SignInRecord>(DbConfig.DbConnStr, $"{dataSql};{countSql}"); return(new PageInfo <List <SignInRecord> >() { Total = data.Total, Rows = data.Data.ToList(), PageIndex = option.PageIndex, PageSize = option.PageSize }); }