ZLPMS/PMS.BusinessModels/EasyUI/DataGridModel.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace PMS.BusinessModels.EasyUI
{
    /// <summary>
    /// DataGrid的属性
    /// </summary>
    public class DataGridModel
    {
        /// <summary>
        /// 初始化DataGrid对象
        /// </summary>
        public DataGridModel()
        {
            this.ColumnList = new List<ColumnAttribute>();
            this.TotalRows = 0;
        }

        /// <summary>
        /// 初始化DataGrid对象
        /// </summary>
        /// <param name="columns">数据列名称集合</param>
        public DataGridModel(params string[] columns)
        {
            this.ColumnList = new List<ColumnAttribute>();
            this.TotalRows = 0;
            if (columns != null || columns.Length > 0)
            {
                foreach (var col in columns)
                {
                    this.ColumnList.Add(new ColumnAttribute(col));
                }
            }

        }

        /// <summary>
        /// 初始化DataGrid对象
        /// </summary>
        /// <param name="totalRows">总行数</param>
        /// <param name="columns">列集合</param>
        public DataGridModel(int totalRows, params string[] columns)
        {
            this.ColumnList = new List<ColumnAttribute>();
            if (totalRows < 0)
            {
                totalRows = 0;
            }
            this.TotalRows = totalRows;

            if (columns != null || columns.Length > 0)
            {
                foreach (var col in columns)
                {
                    this.ColumnList.Add(new ColumnAttribute(col));
                }
            }

        }

        /// <summary>
        /// 初始化DataGrid对象
        /// </summary>
        /// <param name="spiltChar">分割字符</param>
        /// <param name="columns">数据列与显示列名称的集合，每个都使用自定义的分割字符去分割  每一个为数据列  每二个为显示列</param>
        public DataGridModel(char spiltChar, params string[] columns)
        {
            this.ColumnList = new List<ColumnAttribute>();
            this.TotalRows = 0;
            if (columns != null || columns.Length > 0)
            {
                foreach (var col in columns)
                {
                    if (!string.IsNullOrEmpty(col))
                    {
                        if (!string.IsNullOrEmpty(spiltChar.ToString()))
                        {
                            var list = col.Split(spiltChar);
                            if (list.Length > 1)
                            {
                                this.ColumnList.Add(new ColumnAttribute(list[0], list[1]));
                            }
                            else
                            {
                                this.ColumnList.Add(new ColumnAttribute(col));
                            }
                        }
                        else
                        {
                            this.ColumnList.Add(new ColumnAttribute(col));
                        }
                    }
                }
            }
        }

        /// <summary>
        /// 初始化DataGrid对象
        /// </summary>
        /// <param name="totalRows">总行数</param>
        /// <param name="spiltChar">分割字符</param>
        /// <param name="columns">数据列与显示列名称的集合，每个都使用自定义的分割字符去分割  每一个为数据列  每二个为显示列</param>
        public DataGridModel(int totalRows, char spiltChar, params string[] columns)
        {
            this.ColumnList = new List<ColumnAttribute>();
            if (totalRows < 0)
            {
                totalRows = 0;
            }
            this.TotalRows = totalRows;

            if (columns != null || columns.Length > 0)
            {
                foreach (var col in columns)
                {
                    if (!string.IsNullOrEmpty(col))
                    {
                        if (!string.IsNullOrEmpty(spiltChar.ToString()))
                        {
                            var list = col.Split(spiltChar);
                            if (list.Length > 1)
                            {
                                this.ColumnList.Add(new ColumnAttribute(list[0], list[1]));
                            }
                            else
                            {
                                this.ColumnList.Add(new ColumnAttribute(col));
                            }
                        }
                        else
                        {
                            this.ColumnList.Add(new ColumnAttribute(col));
                        }
                    }
                }
            }
        }

        /// <summary>
        /// 初始化DataGrid对象
        /// </summary>
        /// <param name="columns">数据列字段集合</param>
        /// <param name="spiltChar">分割字符</param>
        public DataGridModel(string columns, char spiltChar)
        {
            this.ColumnList = new List<ColumnAttribute>();
            this.TotalRows = 0;

            if (string.IsNullOrEmpty(columns) || string.IsNullOrEmpty(spiltChar.ToString()))
            {
                return;
            }
            var list = columns.Split(spiltChar);
            foreach (var col in list)
            {
                this.ColumnList.Add(new ColumnAttribute(col));
            }
        }

        /// <summary>
        /// 初始化DataGrid对象
        /// </summary>
        /// <param name="totalRows">总行数</param>
        /// <param name="columns">数据列字段集合</param>
        /// <param name="spiltChar">分割字符</param>
        public DataGridModel(int totalRows, string columns, char spiltChar)
        {
            this.ColumnList = new List<ColumnAttribute>();
            if (totalRows < 0)
            {
                totalRows = 0;
            }
            this.TotalRows = totalRows;

            if (string.IsNullOrEmpty(columns) || string.IsNullOrEmpty(spiltChar.ToString()))
            {
                return;
            }
            var list = columns.Split(spiltChar);
            foreach (var col in list)
            {
                this.ColumnList.Add(new ColumnAttribute(col));
            }
        }

        /// <summary>
        /// 添加列
        /// </summary>
        /// <param name="column"></param>
        public void AddColumn(string column)
        {
            if (this.ColumnList == null)
            {
                this.ColumnList = new List<ColumnAttribute>();
            }
            if (string.IsNullOrEmpty(column))
            {
                return;
            }

            this.ColumnList.Add(new ColumnAttribute(column));
        }

        /// <summary>
        /// 添加列
        /// </summary>
        /// <param name="dataColumn">数据列名称</param>
        /// <param name="textColumn">显示列名称</param>
        public void AddColumn(string dataColumn, string textColumn)
        {
            if (this.ColumnList == null)
            {
                this.ColumnList = new List<ColumnAttribute>();
            }

            if (string.IsNullOrEmpty(dataColumn) && string.IsNullOrEmpty(textColumn))
            {
                return;
            }

            if (string.IsNullOrEmpty(dataColumn))
            {
                dataColumn = textColumn;
            }

            if (string.IsNullOrEmpty(textColumn))
            {
                textColumn = dataColumn;
            }

            this.ColumnList.Add(new ColumnAttribute(dataColumn, textColumn));
        }

        /// <summary>
        /// 总行数
        /// </summary>
        public int TotalRows { get; set; }

        /// <summary>
        /// 消耗时间
        /// </summary>
        private double WasteTime = 0.01;

        /// <summary>
        /// 查询消耗时间
        /// </summary>
        public double SetWasteTime
        {
            set
            {
                if (value < 0.01)
                {
                    this.WasteTime = 0.01;
                }
                else
                {
                    this.WasteTime = value;
                }
            }
        }

        /// <summary>
        /// 列名称集合
        /// </summary>
        private List<ColumnAttribute> ColumnList;

        /// <summary>
        /// 基础数据表
        /// </summary>
        private DataTable basicTable { get; set; }

        /// <summary>
        /// 设置数据表
        /// </summary>
        public DataTable SetDataTable
        {
            set
            {
                if (value == null || value.Rows.Count == 0)
                {
                    return;
                }
                this.basicTable = value.Copy();
            }
        }

        /// <summary>
        /// 通过DataTable转成对应的Json格式字段串
        /// </summary>
        /// <returns></returns>
        public string ToJsonString()
        {
            if (this.basicTable == null || this.basicTable.Rows.Count == 0 || this.ColumnList.Count == 0)
            {
                return "{\"total\":0,\"ctime\":" + this.WasteTime + ",\"rows\":[]}";
            }
            StringBuilder sb = new StringBuilder();

            int total = this.TotalRows;//获取是否设置了总行数
            if (total == 0)
            {
                total = this.basicTable.Rows.Count;
            }

            sb.Append("{\"total\":" + total + ",\"ctime\":" + this.WasteTime + ",\"rows\":[");
            var colList = this.ColumnList;

            foreach (DataRow dr in this.basicTable.Rows)
            {
                sb.Append("{");//一行的开始
                foreach (var col in colList)
                {
                    //判断数据库列是否存在
                    if (this.basicTable.Columns.Contains(col.DataColumn))
                    {
                        var value = dr[col.DataColumn].ToString().Trim().Replace("\r", "\\r").Replace("\n", "\\n");
                        sb.Append("\"" + col.TextColumn + "\":\"" + value + "\",");
                    }
                    else
                    {
                        sb.Append("\"" + col.TextColumn + "\":\"\",");
                    }
                }
                sb.Remove(sb.Length - 1, 1);//移除最后一个逗号
                sb.Append("},");//一行的结束
            }
            sb.Remove(sb.Length - 1, 1);//去除最后的逗号
            sb.Append("]}");//一行的结束
            return sb.ToString();
        }
    }
}