示例#1
0
文件: XTable.cs 项目: fmpfmp/X-1
 /// <summary>写入</summary>
 /// <param name="writer"></param>
 void IXmlSerializable.WriteXml(XmlWriter writer)
 {
     ModelHelper.WriteXml(this, writer);
 }
示例#2
0
文件: XTable.cs 项目: fmpfmp/X-1
 /// <summary>读取</summary>
 /// <param name="reader"></param>
 void IXmlSerializable.ReadXml(XmlReader reader)
 {
     ModelHelper.ReadXml(this, reader);
 }
示例#3
0
 /// <summary>导出模型</summary>
 /// <param name="tables"></param>
 /// <returns></returns>
 public static String Export(IEnumerable <IDataTable> tables)
 {
     return(ModelHelper.ToXml(tables));
 }
示例#4
0
 /// <summary>导出模型</summary>
 /// <param name="tables"></param>
 /// <returns></returns>
 public static String Export(IEnumerable <IDataTable> tables) => ModelHelper.ToXml(tables);
示例#5
0
        /// <summary>检查表说明和索引</summary>
        /// <param name="entitytable"></param>
        /// <param name="dbtable"></param>
        /// <param name="mode"></param>
        /// <returns></returns>
        protected virtual String CheckTableDescriptionAndIndex(IDataTable entitytable, IDataTable dbtable, Migration mode)
        {
            var onlySql  = mode <= Migration.ReadOnly;
            var noDelete = mode < Migration.Full;

            var sb = new StringBuilder();

            #region 表说明
            if (entitytable.Description + "" != dbtable.Description + "")
            {
                //// 先删除旧注释
                //if (!String.IsNullOrEmpty(dbtable.Description)) PerformSchema(sb, onlySql, DDLSchema.DropTableDescription, dbtable);

                // 加上新注释
                if (!String.IsNullOrEmpty(entitytable.Description))
                {
                    PerformSchema(sb, onlySql, DDLSchema.AddTableDescription, entitytable);
                }
            }
            #endregion

            #region  除索引
            var dbdis = dbtable.Indexes;
            if (dbdis != null)
            {
                foreach (var item in dbdis.ToArray())
                {
                    // 计算的索引不需要删除
                    //if (item.Computed) continue;

                    // 主键的索引不能删
                    if (item.PrimaryKey)
                    {
                        continue;
                    }

                    var di = ModelHelper.GetIndex(entitytable, item.Columns);
                    if (di != null && di.Unique == item.Unique)
                    {
                        continue;
                    }

                    PerformSchema(sb, noDelete, DDLSchema.DropIndex, item);
                    dbdis.Remove(item);
                }
            }
            #endregion

            #region 新增索引
            var edis = entitytable.Indexes;
            if (edis != null)
            {
                foreach (var item in edis.ToArray())
                {
                    if (item.PrimaryKey)
                    {
                        continue;
                    }

                    var di = ModelHelper.GetIndex(dbtable, item.Columns);
                    // 计算出来的索引,也表示没有,需要创建
                    if (di != null && di.Unique == item.Unique)
                    {
                        continue;
                    }
                    //// 如果这个索引的唯一字段是主键,则无需建立索引
                    //if (item.Columns.Length == 1 && entitytable.GetColumn(item.Columns[0]).PrimaryKey) continue;
                    // 如果索引全部就是主键,无需创建索引
                    if (entitytable.GetColumns(item.Columns).All(e => e.PrimaryKey))
                    {
                        continue;
                    }

                    PerformSchema(sb, onlySql, DDLSchema.CreateIndex, item);

                    if (di == null)
                    {
                        edis.Add(item.Clone(dbtable));
                    }
                    //else
                    //    di.Computed = false;
                }
            }
            #endregion

            if (!onlySql)
            {
                return(null);
            }

            return(sb.ToString());
        }