api 调用sql server 存储过程分页

最新推荐文章于 2023-03-17 16:04:38 发布

顺丰枣子哥

最新推荐文章于 2023-03-17 16:04:38 发布

阅读量177

点赞数

本文链接：https://blog.youkuaiyun.com/Zuansman/article/details/107682149

版权

    public AllModel PageShow(string name,int pindex=1,int psize=3)
    {
        if (!string.IsNullOrEmpty(name))
        {
            string where = "and SName like '%"+name+"%'";
            SqlParameter[] paras = new SqlParameter[] {
                new SqlParameter("@where",SqlDbType.NVarChar,4000){Value=where,Direction=ParameterDirection.Input },
                 new SqlParameter("@pindex",SqlDbType.Int){Value=pindex,Direction=ParameterDirection.Input },
                  new SqlParameter("@psize",SqlDbType.Int){Value=psize,Direction=ParameterDirection.Input },
                   new SqlParameter("@allcount",SqlDbType.Int){Value=0,Direction=ParameterDirection.InputOutput },
                    new SqlParameter("@pagecount",SqlDbType.Int){Value=0,Direction=ParameterDirection.InputOutput },
            };
            AllModel d = new AllModel();
            d.List= JsonConvert.DeserializeObject<List<Student>>(JsonConvert.SerializeObject(db.ProcShow("Proc_Page", paras)));
            d.Pindex = pindex;
            d.Psize = psize;
            d.AllCount =Convert.ToInt32(paras[3].Value);
            d.PageCount = Convert.ToInt32(paras[4].Value);
            return d;
        }
        else
        {
            SqlParameter[] paras = new SqlParameter[] {
                new SqlParameter("@where",SqlDbType.NVarChar,4000){Value="",Direction=ParameterDirection.Input },
                 new SqlParameter("@pindex",SqlDbType.Int){Value=pindex,Direction=ParameterDirection.Input },
                  new SqlParameter("@psize",SqlDbType.Int){Value=psize,Direction=ParameterDirection.Input },
                   new SqlParameter("@allcount",SqlDbType.Int){Value=0,Direction=ParameterDirection.InputOutput },
                    new SqlParameter("@pagecount",SqlDbType.Int){Value=0,Direction=ParameterDirection.InputOutput },
            };
            AllModel d = new AllModel();
            d.List = JsonConvert.DeserializeObject<List<Student>>(JsonConvert.SerializeObject(db.ProcShow("Proc_Page", paras)));
            d.Pindex = pindex;
            d.Psize = psize;
            d.AllCount = Convert.ToInt32(paras[3].Value);
            d.PageCount = Convert.ToInt32(paras[4].Value);
            return d;
        }
    }