using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Diagnostics;
using System.Linq;
using System.Runtime.Serialization;
using System.Xml;
using System.Xml.Schema;
using System.Xml.Serialization;
using NewLife.Collections;
using NewLife.Xml;

namespace XCode.DataAccessLayer
{
    /// <summary>表模型</summary>
    [DebuggerDisplay("{Name} {Description}")]
    [Serializable]
    [DisplayName("表模型")]
    [Description("表模型")]
    [XmlRoot("Table")]
    class XTable : IDataTable, ICloneable, IXmlSerializable
    {
        #region 基本属性
        ///// <summary>编号</summary>
        //[XmlAttribute]
        //[DisplayName("编号")]
        //[Description("编号")]
        //public Int32 ID { get; set; }

        /// <summary>名称</summary>
        [XmlAttribute]
        [DisplayName("名称")]
        [Description("名称")]
        public String Name { get; set; }

        /// <summary>表名</summary>
        [XmlAttribute]
        [DisplayName("表名")]
        [Description("表名")]
        public String TableName { get; set; }

        private String _Description;
        /// <summary>描述</summary>
        [XmlAttribute]
        [DisplayName("描述")]
        [Description("描述")]
        public String Description
        {
            get { return _Description; }
            set
            {
                if (!String.IsNullOrEmpty(value)) value = value.Replace("\r\n", "。").Replace("\r", " ").Replace("\n", " ");
                _Description = value;
            }
        }

        /// <summary>是否视图</summary>
        [XmlAttribute]
        [DisplayName("是否视图")]
        [Description("是否视图")]
        public Boolean IsView { get; set; }

        /// <summary>所有者</summary>
        [XmlAttribute]
        [DisplayName("所有者")]
        [Description("所有者")]
        public String Owner { get; set; }

        /// <summary>连接名</summary>
        [XmlAttribute]
        [DisplayName("连接名")]
        [Description("连接名")]
        public String ConnName { get; set; }

        /// <summary>数据库类型</summary>
        [XmlAttribute]
        [DisplayName("数据库类型")]
        [Description("数据库类型")]
        public DatabaseType DbType { get; set; }

        /// <summary>基类</summary>
        [XmlAttribute]
        [DisplayName("基类")]
        [Description("基类")]
        public String BaseType { get; set; }

        /// <summary>仅插入的日志型数据</summary>
        [XmlAttribute]
        [DisplayName("只写")]
        [Description("只写")]
        public Boolean InsertOnly { get; set; }
        #endregion

        #region 扩展属性
        /// <summary>字段集合。可以是空集合，但不能为null。</summary>
        [XmlIgnore, IgnoreDataMember]
        [Category("集合")]
        [DisplayName("字段集合")]
        [Description("字段集合")]
        public List<IDataColumn> Columns { get; private set; }

        /// <summary>索引集合。可以是空集合，但不能为null。</summary>
        [XmlIgnore, IgnoreDataMember]
        [Category("集合")]
        [DisplayName("索引集合")]
        [Description("索引集合")]
        public List<IDataIndex> Indexes { get; private set; }

        /// <summary>主字段。主字段作为业务主要字段，代表当前数据行意义</summary>
        [XmlIgnore, IgnoreDataMember]
        public IDataColumn Master => Columns.FirstOrDefault(e => e.Master) ?? Columns.FirstOrDefault(e => e.PrimaryKey);

        /// <summary>主键集合。可以是空集合，但不能为null。</summary>
        [XmlIgnore, IgnoreDataMember]
        public IDataColumn[] PrimaryKeys => Columns.FindAll(item => item.PrimaryKey).ToArray();

        private String _DisplayName;
        /// <summary>显示名</summary>
        [XmlAttribute]
        [DisplayName("显示名")]
        [Description("显示名")]
        public String DisplayName
        {
            get
            {
                if (String.IsNullOrEmpty(_DisplayName)) _DisplayName = ModelResolver.Current.GetDisplayName(Name, _Description);
                return _DisplayName;
            }
            //set
            //{
            //    if (!String.IsNullOrEmpty(value)) value = value.Replace("\r\n", "。").Replace("\r", " ").Replace("\n", " ");
            //    _DisplayName = value;

            //    if (String.IsNullOrEmpty(_Description))
            //        _Description = _DisplayName;
            //    else if (!_Description.StartsWith(_DisplayName))
            //        _Description = _DisplayName + "。" + _Description;
            //}
        }

        /// <summary>扩展属性</summary>
        [XmlIgnore, IgnoreDataMember]
        [Category("扩展")]
        [DisplayName("扩展属性")]
        [Description("扩展属性")]
        public IDictionary<String, String> Properties { get; private set; }

        ///// <summary>忽略名称大小写</summary>
        //[XmlAttribute]
        //[DisplayName("是否忽略大小写")]
        //[Description("是否忽略大小写")]
        //public String IgnoreNameCase { get; set; }
        #endregion

        #region 构造
        /// <summary>初始化</summary>
        public XTable()
        {
            IsView = false;

            Columns = new List<IDataColumn>();
            Indexes = new List<IDataIndex>();

            Properties = new NullableDictionary<String, String>(StringComparer.OrdinalIgnoreCase);
        }

        /// <summary>初始化</summary>
        /// <param name="name">名称</param>
        public XTable(String name) : this() => TableName = name;
        #endregion

        #region 方法
        /// <summary>创建字段</summary>
        /// <returns></returns>
        public virtual IDataColumn CreateColumn() => new XField { Table = this };

        /// <summary>创建索引</summary>
        /// <returns></returns>
        public virtual IDataIndex CreateIndex() => new XIndex { Table = this };

        /// <summary>修正数据</summary>
        public virtual IDataTable Fix() => ModelResolver.Current.Fix(this);

        /// <summary>已重载。</summary>
        /// <returns></returns>
        public override String ToString()
        {
            if (String.IsNullOrEmpty(DisplayName))
                return Name;
            else
                return $"{Name}({DisplayName})";
        }
        #endregion

        #region 导入导出
        /// <summary>导出</summary>
        /// <returns></returns>
        public String Export() => this.ToXml();

        /// <summary>导入</summary>
        /// <param name="xml"></param>
        /// <returns></returns>
        public static XTable Import(String xml)
        {
            if (String.IsNullOrEmpty(xml)) return null;

            return xml.ToXmlEntity<XTable>();
        }
        #endregion

        #region ICloneable 成员
        /// <summary>克隆</summary>
        /// <returns></returns>
        Object ICloneable.Clone() => Clone();

        /// <summary>克隆</summary>
        /// <returns></returns>
        public XTable Clone()
        {
            var table = base.MemberwiseClone() as XTable;
            // 浅表克隆后，集合还是指向旧的，需要重新创建
            table.Columns = new List<IDataColumn>();
            foreach (var item in Columns)
            {
                table.Columns.Add(item.Clone(table));
            }
            table.Indexes = new List<IDataIndex>();
            foreach (var item in Indexes)
            {
                table.Indexes.Add(item.Clone(table));
            }
            return table;
        }
        #endregion

        #region IXmlSerializable 成员
        /// <summary>获取架构</summary>
        /// <returns></returns>
        XmlSchema IXmlSerializable.GetSchema() { return null; }

        /// <summary>读取</summary>
        /// <param name="reader"></param>
        void IXmlSerializable.ReadXml(XmlReader reader) { ModelHelper.ReadXml(this, reader); }

        /// <summary>写入</summary>
        /// <param name="writer"></param>
        void IXmlSerializable.WriteXml(XmlWriter writer) { ModelHelper.WriteXml(this, writer); }
        #endregion
    }
}