lzh19950320的博客

原创 分页查询

sqlserver配合layui 分页展示数据 page limit 参数 public JsonResult getCyjjDNList(string CYLX, int page = 1, int limit = 5) { try { string sql = "select DYYQMC,DNJT,YQID from (select ROW_NUMBER() OVER(Order by DNJT desc) AS RowNumber, * from CYY_CYJJ where 1=1 “; if