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