Web/WebApp/LxEasyUITableHelperr.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Web;
using RhData;

namespace WebApp
{
    /// <summary>
    /// EasyUI
    /// </summary>
    public static class LxEasyUITableHelperr
    {
        delegate string FormatMethod(object obj);

        /// <summary>
        /// 数据转为前台Json数据
        /// </summary>
        /// <param name="data">行数据</param>
        /// <param name="footerData">页脚数据</param>
        /// <param name="dataCount">数据总数，如果数据总数设为0则以实际行数据数量为准</param>
        /// <returns>Json字符串</returns>
        public static string DataToJson(DataTable data, int dataCount = 0, DataTable footerData = null)
        {
            FormatMethod[] fmts = GetFormatMethodFromCols(data.Columns);
            System.Text.StringBuilder result = new System.Text.StringBuilder();
            result.Append("{\"total\":" + (dataCount > 0 ? dataCount : data.Rows.Count) + ",");
            result.Append("\"rows\":" + GetJson(data));
            if (footerData != null)
                result.Append(",\"footer\":" + GetJson(footerData));
            result.Append("}");
            return result.ToString();
        }

        /// <summary>
        /// 获取格式化为Json的DataTable数据
        /// </summary>
        /// <param name="data">DataTable数据</param>
        /// <returns>格式化后的Json数据</returns>
        private static string GetJson(DataTable data)
        {
            FormatMethod[] fmts = GetFormatMethodFromCols(data.Columns);
            System.Text.StringBuilder result = new System.Text.StringBuilder();
            result.Append("[ ");
            for (int i = 0; i < data.Rows.Count; i++)
            {
                DataRow row = data.Rows[i];
                result.Append("{");
                for (int j = 0; j < data.Columns.Count; j++)
                {
                    result.Append("\"" + data.Columns[j].ColumnName + "\":");
                    if (row.IsNull(j))
                        result.Append("null");
                    else
                        result.Append(fmts[j](row[j]));
                    result.Append(",");
                }
                result.Remove(result.Length - 1, 1);
                result.Append("},");