public IEnumerable <Model.CommentNo> GetWorkPage(Model.CommentPage page)
{
using (IDbConnection cn = new MySqlConnection(cns)) {
string sql = "with a as(select row_number() over(order by commentTime desc) as num,Comment.* from Comment where Comment.workId=@workId)";
sql += "select* from a where num between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize;";
return(cn.Query <Model.CommentNo>(sql, page));
}
}
public ActionResult getWorkPage([FromBody] Model.CommentPage page)
{
var result = DAL.Comment.Instance.GetWorkPage(page);
if (result.Count() == 0)
{
return(Json(Result.Err("返回记录数为0")));
}
else
{
return(Json(Result.Ok(result)));
}
}
