/// <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
});
}
