CY_ZZJY.EasyUI/BuildJosnData_EasyUI.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Web.Script.Serialization;

namespace CY_ZZJY.EasyUI
{
    public class BuildJosnData_EasyUI
    {
        /*
         
            {"total":28,"rows":[
	            {"productid":"FI-SW-01","unitcost":10.00,"status":"P","listprice":36.50,"attr1":"Large","itemid":"EST-1"},
	            {"productid":"K9-DL-01","unitcost":12.00,"status":"P","listprice":18.50,"attr1":"Spotted Adult Female","itemid":"EST-10"},
	            {"productid":"RP-SN-01","unitcost":12.00,"status":"P","listprice":28.50,"attr1":"Venomless","itemid":"EST-11"},
	            {"productid":"RP-SN-01","unitcost":12.00,"status":"P","listprice":26.50,"attr1":"Rattleless","itemid":"EST-12"},
	            {"productid":"RP-LI-02","unitcost":12.00,"status":"P","listprice":35.50,"attr1":"Green Adult","itemid":"EST-13"},
	            {"productid":"FL-DSH-01","unitcost":12.00,"status":"P","listprice":158.50,"attr1":"Tailless","itemid":"EST-14"},
	            {"productid":"FL-DSH-01","unitcost":12.00,"status":"P","listprice":83.50,"attr1":"With tail","itemid":"EST-15"},
	            {"productid":"FL-DLH-02","unitcost":12.00,"status":"P","listprice":63.50,"attr1":"Adult Female","itemid":"EST-16"},
	            {"productid":"FL-DLH-02","unitcost":12.00,"status":"P","listprice":89.50,"attr1":"Adult Male","itemid":"EST-17"},
	            {"productid":"AV-CB-01","unitcost":92.00,"status":"P","listprice":63.50,"attr1":"Adult Male","itemid":"EST-18"}
            ],"footer":[
	            {"unitcost":19.80,"listprice":60.40,"productid":"Average:"},
	            {"unitcost":198.00,"listprice":604.00,"productid":"Total:"}
            ]}
         
         
        */
        /// <summary>
        /// 返回 EasyUI 的 DataGrid 的数据格式
        /// </summary>
        /// <param name="RecordNum">数据条数</param>
        /// <param name="dt">返回的datatable</param>
        /// <returns></returns>
        public static string BuildJosnData_By_DataTable_NoFooter(int RecordNum, DataTable dt)
        {
            string strRetJson = "{\"total\":" + RecordNum + ", \"rows\":";

            if (dt != null && dt.Rows.Count > 0)
            {
                return strRetJson + JsonHelper_New.DataTableToJson(dt) + "}";
            }
            else
            {
                return strRetJson + "\"\"}";
            }
        }
        #region 生成百度地图坐标json
        public static string BuildJosnData_To_BaiDuMap(string id, string name, string icon, DataTable dt)
        {
            string strRetJson = string.Empty;
            strRetJson += "{";
            strRetJson += "\"rows\": [";
            strRetJson += "{";
            strRetJson += "\"id\": \"" + id + "\",";
            strRetJson += "\"name\": \"" + name + "\",";
            strRetJson += "\"icon\": \"" + icon + "\",";