分页查询

sqlserver配合layui 分页展示数据

分页参数:page limit
其他参数: CYLX （是本方法中需要使用到的参数）
public JsonResult getCyjjDNList(string CYLX=" “, int page = 1, int limit = 5)
{
try
{
string sql = " SELECT * FROM CYY_CYJJ where 1=1 “;
if (!string.IsNullOrEmpty(CYLX))
{
sql += " and zdcy LIKE '%” + CYLX + “%’”;
}
sql += " ORDER BY A.ID OFFSET " + (page - 1) * limit + " ROWS FETCH NEXT " + limit + " ROWS ONLY”;
其中A.ID需要是该表中的主键保证不重复
然后再去数据库中查询整条SQL就能读取到需要的值了

List<CYY_CYJJ> data = CYY_CYJJ.GetListItemQuerySQL<CYY_CYJJ>(sql);

var returnList = data.Select(d => new
{
YQMC = d.DYYQMC,
JTYS = d.DNJT,//产业
YQID = d.YQID,
//ff = fflist.Where(f => f.ProjectId.Contains(d.QYID)).FirstOrDefault()
});
return Json(new { code = 0, data = returnList }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { code = 1, msg = ex.Message }, JsonRequestBehavior.AllowGet);
}
}