散文网-散文随笔-诗歌散文

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Text;

public partial class admin_json_json_grid : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {

            int pageSize = 10;            int start = 0;            if (!string.IsNullOrEmpty(Request["limit"]))            {                pageSize = int.Parse(Request["limit"]);                start = int.Parse(Request["start"]);            }

           string sqlstr = "select hca_art_id,hca_art_title,hca_art_author,hca_art_ComputerName,hca_art_date from hca_art";           Response.Write(jsongrid(DbHelperSQL.Query(sqlstr), start, pageSize));

        }

        public static string jsongrid(DataSet ds, int start, int pageSize)        {

            StringBuilder json = new StringBuilder();            foreach (DataTable dt in ds.Tables)            {                json.Append("{");                json.Append("\"totalCount");                json.Append("\":");                json.Append(ds.Tables[0].Rows.Count);                json.Append(",");                json.Append("\"data");                json.Append("\":[");                int itemCount = (start + pageSize) > ds.Tables[0].Rows.Count ? ds.Tables[0].Rows.Count : (start + pageSize);                for (int i = start; i < itemCount; i++)                {                    json.Append("{");                    for (int j = 0; j < dt.Columns.Count; j++)                    {                        json.Append("\"");                        json.Append(dt.Columns[j].ColumnName);                        json.Append("\":\"");                        json.Append(dt.Rows[i][j].ToString());                        json.Append("\",");                    }                    json.Remove(json.Length - 1, 1);                    json.Append("},");                }                json.Remove(json.Length - 1, 1);                json.Append("]");                json.Append("}");            }            return json.ToString();        }

    }