public ActionResult getPage([FromBody] Model.WorkPage page)
{
var result = DAL.WorkInfo.Instance.GetPage(page);
if (result.Count() == 0)
return Json(Result.Err("返回记录数为0"));
else
return Json(Result.Ok(result));
}
public IEnumerable <Model.WorkInfo> GetPage(Model.WorkPage page)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "with a as(select row_number() over(order by uploadTime desc) as num,workinfo.* from workinfo where activityId in @activityIds)";
sql += "select * from a where num between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize;";
return(cn.Query <Model.WorkInfoNo>(sql, new { pageInedex = page.pageIndex, pageSize = page.pageSize, activityIds = page.activityIds }));
}
}
public IEnumerable <Model.WorkInfoNo> GetFindPage(Model.WorkPage page)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "with a as(select row_number() over(order by uploadTime desc) as num, workinfo.*,activityName from workinfo join activity on workinfo.activityId=activity.activityId where workverify='审核通过' and workName like concat('%',@workName,'%'))";
sql += "select * from a where num between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize";
return(cn.Query <Model.WorkInfoNo>(sql, page));
}
}
