C#基于数据库存储过程的AJAX分页实例

2019-12-26 12:06:16王旭

        /// </summary>  
        /// <param name="context"></param>  
        public void ProcessRequest(HttpContext context)  
        {  
            context.Response.ContentType = "text/plain";  
            int pageSize = 10; //设定页大小,每页显示10条数据  
            int currentPage = Convert.ToInt32(context.Request.QueryString["currentPage"]); //设定当前页  
            int rowCount = 0;  //作为out参数传递给方法,在方法里给rowCount赋值  
            int pageCount = 0; //作为out参数传递给方法,在方法里给rowCount赋值  
            string jsonData = null;   
            List<Model.Location> list= DAL.Aticel.GetPageListByPageIndex(pageSize, currentPage, out rowCount, out pageCount);  
            if (list != null && list.Count > 0)  
            {  
                //创建Json序列化器,将对象转换成一个Json格式的字符串  
                JavaScriptSerializer jsz = new JavaScriptSerializer();  
                jsonData = jsz.Serialize(list); //将一个list对象转换成json格式的字符串  
                context.Response.Write(jsonData);  
            }  
            else  
            {  
                context.Response.Write("no");  
            }  
        }  
        public bool IsReusable