public void UpdateColNode(ZippyCoder.Entity.Col col) { _Modified = true; ChangeTitle(false); if (_CurrentTreeViewItem.Tag is ZippyCoder.Entity.Col) { _CurrentTreeViewItem.Tag = col; _CurrentTreeViewItem.Header = col.Title + "[" + col.Name + "]"; } else if (_CurrentTreeViewItem.Tag is ZippyCoder.Entity.Table) { ZippyCoder.Entity.Table table = _CurrentTreeViewItem.Tag as ZippyCoder.Entity.Table; //int insPos = table.Cols.Count; //if (insPos >= 9) //懒人列 //{ // insPos = insPos - 8; //} //table.Cols.Insert(insPos, col); table.Cols.Add(col); TreeViewItem tviCol = new TreeViewItem(); _CurrentTreeViewItem.Items.Add(tviCol); //_CurrentTreeViewItem.Items.Insert(insPos, tviCol); _CurrentTreeViewItem.IsExpanded = true; tviCol.Tag = col; tviCol.Header = col.Title + "[" + col.Name + "]"; } }
private void CreateCol() { ZippyCoder.Entity.Col col = new ZippyCoder.Entity.Col(); _uiCol.Project = _Project; _uiCol.Col = col; Navigate(_uiCol); }
public static void BatchTenantID(ZippyCoder.Entity.Col col) { if (col.Name == "TenantID" && !col.IsPK) { col.DataType = System.Data.SqlDbType.UniqueIdentifier; col.Default = "'00000000-0000-0000-0000-000000000000'"; col.RenderType = ZippyCoder.Entity.RenderTypes.UrlQuery; col.CssClass = ""; col.CssClassLength = ""; //col.UIColType = col.UIColType & (~ZippyCoder.Entity.UIColTypes.Editable); } else if (col.Name == "Creator" || col.Name == "Updater") { col.DataType = System.Data.SqlDbType.UniqueIdentifier; col.RenderType = ZippyCoder.Entity.RenderTypes.Hidden; col.Default = ""; col.CssClass = ""; col.CssClassLength = ""; //col.UIColType = col.UIColType & (~ZippyCoder.Entity.UIColTypes.Editable); } if (col.WidthPx == 0 && (!string.IsNullOrEmpty(col.CssClassLength))) { try { int length = int.Parse(col.CssClassLength.Substring(1)); if (length <= 32) { col.WidthPx = length * 30; } } catch { } } }
public void InitClipBoard() { IDataObject iobj = Clipboard.GetDataObject(); object colObj = iobj.GetData(typeof(ZippyCoder.Entity.Col)); object tableObj = iobj.GetData(typeof(ZippyCoder.Entity.Table)); if (colObj != null) { _ClipboardCol = colObj as ZippyCoder.Entity.Col; } if (tableObj != null) { _ClipboardTable = tableObj as ZippyCoder.Entity.Table; } }
public void WriteSqlLog(ZippyCoder.Entity.Col col, string oldColName) { if (_CurrentTreeViewItem.Tag is ZippyCoder.Entity.Table) { SqlMonitor.WriteSqlServerChangeLog(swSqlWriter, _CurrentTreeViewItem.Tag as ZippyCoder.Entity.Table, col, operation, oldColName); } else if (_CurrentTreeViewItem.Tag is ZippyCoder.Entity.Col) { TreeViewItem parentTVI = _CurrentTreeViewItem.Parent as TreeViewItem; if (parentTVI.Tag is ZippyCoder.Entity.Table) { SqlMonitor.WriteSqlServerChangeLog(swSqlWriter, parentTVI.Tag as ZippyCoder.Entity.Table, col, operation, oldColName); } } }
private void CopyNode() { if (_CurrentNode == Nodes.Table) { _ClipboardTable = _CurrentTreeViewItem.Tag as ZippyCoder.Entity.Table; //_ClipboardTable = table; DataObject dataobj = new DataObject(typeof(ZippyCoder.Entity.Table), _ClipboardTable); Clipboard.SetDataObject(dataobj); } else if (_CurrentNode == Nodes.Col) { _ClipboardCol = _CurrentTreeViewItem.Tag as ZippyCoder.Entity.Col; //_ClipboardCol = col; DataObject dataobj = new DataObject(typeof(ZippyCoder.Entity.Col), _ClipboardCol); Clipboard.SetDataObject(dataobj); } }
private void PasteNode() { _Modified = true; ChangeTitle(false); if (_CurrentNode == Nodes.Project && (_ClipboardTable != null)) //table 直接加入,因为带有下面的列数据 { operation = ChangeTypes.None; _uiProject.Visibility = Visibility.Hidden; _uiTable.Visibility = Visibility.Hidden; _uiCol.Visibility = Visibility.Hidden; ZippyCoder.Entity.Table table = _ClipboardTable; table.Name = table.Name; TreeViewItem tviTable = new TreeViewItem(); _CurrentTreeViewItem.Items.Add(tviTable); tviTable.Tag = table; tviTable.Header = table.Title + "[" + table.Name + "]"; foreach (ZippyCoder.Entity.Col col in table.Cols) { TreeViewItem tviCol = new TreeViewItem(); tviTable.Items.Add(tviCol); tviTable.IsExpanded = true; tviCol.Tag = col; tviCol.Header = col.Title + "[" + col.Name + "]"; } _Project.Tables.Add(table); } else if (_CurrentNode == Nodes.Table && (_ClipboardCol != null)) //列加入的时候,确认一下 { operation = ChangeTypes.AddCol; ZippyCoder.Entity.Col col = _ClipboardCol; col.Name = col.Name; _uiCol.Project = _Project; _uiCol.Col = col; Navigate(_uiCol); } }
private void DeleteNode() { if (MessageBox.Show("是否删除当前节点?", "请确认", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } _Modified = true; ChangeTitle(false); if (_CurrentNode == Nodes.Table) { ZippyCoder.Entity.Table table = _CurrentTreeViewItem.Tag as ZippyCoder.Entity.Table; operation = ChangeTypes.DropTable; WriteSqlLog(null, null); //没有col,但有当前 table,通过 ChangeTypes.DropTable 删除表 TreeViewItem parentTV = _CurrentTreeViewItem.Parent as TreeViewItem; parentTV.Items.Remove(_CurrentTreeViewItem); _Project.Tables.Remove(table); ShowInfo("删除成功!"); } else if (_CurrentNode == Nodes.Col) { ZippyCoder.Entity.Col col = _CurrentTreeViewItem.Tag as ZippyCoder.Entity.Col; operation = ChangeTypes.DropCol; WriteSqlLog(col, null); //删除列 TreeViewItem parentTV = _CurrentTreeViewItem.Parent as TreeViewItem; parentTV.Items.Remove(_CurrentTreeViewItem); ZippyCoder.Entity.Table table = parentTV.Tag as ZippyCoder.Entity.Table; table.Cols.Remove(col); ShowInfo("删除成功!"); } }
/// <summary> /// 新建懒人列 /// </summary> /// <param name="tviTable"></param> /// <param name="table"></param> public static void CreateLazyCols(TreeNode tviTable, ZippyCoder.Entity.Table table) { TreeNode tviCol; ZippyCoder.Entity.Col col; col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = table.Name + "ID"; col.IsPK = true; col.IsNull = false; col.Unique = true; col.AutoIncrease = true; col.CssClass = "textBox"; col.CssClassLength = "w1"; col.DataType = System.Data.SqlDbType.BigInt; col.Title = table.Title + "编号"; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable | ZippyCoder.Entity.UIColTypes.Listable | ZippyCoder.Entity.UIColTypes.Sortable; tviCol = new TreeNode(); tviCol.Text = table.Title + "编号[" + table.Name + "ID]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = "TenantID"; col.IsPK = false; col.IsNull = false; col.Unique = false; col.AutoIncrease = false; col.IsIndex = true; col.Default = "'00000000-0000-0000-0000-000000000000'"; col.CssClass = ""; col.CssClassLength = ""; col.DataType = System.Data.SqlDbType.UniqueIdentifier; col.Title = "租户"; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable; tviCol = new TreeNode(); tviCol.Text = "租户[TenantID]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = table.Name + "Type"; col.DataType = System.Data.SqlDbType.Int; col.Default = "1"; col.Title = table.Title + "类型"; col.EnumType = table.Name + "Types"; col.ResourceType = "Resources.X"; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable | ZippyCoder.Entity.UIColTypes.Queryable | ZippyCoder.Entity.UIColTypes.Editable | ZippyCoder.Entity.UIColTypes.Listable; col.RenderType = ZippyCoder.Entity.RenderTypes.CheckBoxList; tviCol = new TreeNode(); tviCol.Text = col.Title + "[" + col.Name + "]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = table.Name + "Status"; col.DataType = System.Data.SqlDbType.Int; col.Default = "1"; col.Title = table.Title + "状态"; col.EnumType = table.Name + "Status"; col.ResourceType = "Resources.X"; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable | ZippyCoder.Entity.UIColTypes.Queryable | ZippyCoder.Entity.UIColTypes.Editable | ZippyCoder.Entity.UIColTypes.Listable; col.RenderType = ZippyCoder.Entity.RenderTypes.RadioButtonList; tviCol = new TreeNode(); tviCol.Text = col.Title + "[" + col.Name + "]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = "DisplayOrder"; col.CssClass = "textBox"; col.CssClassLength = "w1"; col.DataType = System.Data.SqlDbType.Int; col.Default = "0"; col.Title = "排列顺序"; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable | ZippyCoder.Entity.UIColTypes.Editable | ZippyCoder.Entity.UIColTypes.Sortable; tviCol = new TreeNode(); tviCol.Text = "排列顺序[DisplayOrder]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = "CreateDate"; col.AutoIncrease = false; col.CssClass = "textBox"; col.CssClassLength = "w3"; col.DataType = System.Data.SqlDbType.DateTime; col.Default = "(GetDate())"; col.Title = "创建时间"; col.RenderType = ZippyCoder.Entity.RenderTypes.TextBox; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable | ZippyCoder.Entity.UIColTypes.Listable | ZippyCoder.Entity.UIColTypes.Queryable | ZippyCoder.Entity.UIColTypes.Sortable; tviCol = new TreeNode(); tviCol.Text = "创建时间[CreateDate]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = "Creator"; col.CssClass = "textBox"; col.CssClassLength = "w1"; col.DataType = System.Data.SqlDbType.UniqueIdentifier; //col.Default = "0"; col.Title = "创建人"; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable; tviCol = new TreeNode(); tviCol.Text = "创建人[Creator]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = "UpdateDate"; col.AutoIncrease = false; col.CssClass = "textBox"; col.CssClassLength = "w3"; col.DataType = System.Data.SqlDbType.DateTime; col.Title = "更新时间"; col.RenderType = ZippyCoder.Entity.RenderTypes.TextBox; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable; tviCol = new TreeNode(); tviCol.Text = "更新时间[UpdateDate]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Name = "Updater"; col.CssClass = "textBox"; col.CssClassLength = "w1"; col.DataType = System.Data.SqlDbType.UniqueIdentifier; //col.Default = "0"; col.Title = "更新人"; col.UIColType = ZippyCoder.Entity.UIColTypes.Detailable; tviCol = new TreeNode(); tviCol.Text = "更新人[Updater]"; tviCol.Tag = col; tviTable.Nodes.Add(tviCol); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(ddlDatabase.Text)) { return; } project.Namespace = ddlDatabase.Text; project.Title = ddlDatabase.Text; string conStr1 = "Server={0};Port={1};Uid={2};Pwd={3};Database={4}"; string conStr = string.Format(conStr1, tbxServer.Text, tbxPort.Text, tbxUserName.Text, tbxPassword.Text, ddlDatabase.Text); MessageBox.Show(conStr); MySqlConnection con = new MySqlConnection(conStr); try { con.Open(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } List <string> tableNames = new List <string>(); MySqlCommand cmd = new MySqlCommand("show tables", con); IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tableNames.Add(reader.GetString(0)); } reader.Close(); #region 查询列结构 foreach (string strTableName in tableNames) { ZippyCoder.Entity.Table table = new ZippyCoder.Entity.Table(); table.Name = strTableName; table.Title = strTableName; project.Tables.Add(table); string sql = "SHOW COLUMNS FROM " + strTableName; MySqlCommand cmdColProperty = new MySqlCommand(sql, con); IDataReader readerCol = cmdColProperty.ExecuteReader(); List <ZippyCoder.Entity.Col> fkCols = new List <ZippyCoder.Entity.Col>(); while (readerCol.Read()) { object _colName = readerCol.GetValue(0); object _mysqlType = readerCol.GetValue(1); object _canNull = readerCol.GetValue(2); object _isKey = readerCol.GetValue(3); object _defVal = readerCol.GetValue(4); object _extra = readerCol.GetValue(5); string colName = _colName == null ? "" : _colName.ToString(); string mysqlType = _mysqlType == null ? "" : _mysqlType.ToString(); string canNull = _canNull == null ? "" : _canNull.ToString(); string isKey = _isKey == null ? "" : _isKey.ToString(); string defVal = _defVal == null ? "" : _defVal.ToString(); string extra = _extra == null ? "" : _extra.ToString(); string dataType = string.Empty, dataLen = string.Empty; var match = System.Text.RegularExpressions.Regex.Match(mysqlType, @"([\w]+).*?([\d\,]+).*"); var matchCount = match.Groups.Count; if (matchCount > 1) { dataType = match.Groups[1].Value; } if (matchCount > 2) { dataLen = match.Groups[2].Value; } if (string.IsNullOrEmpty(dataType)) { dataType = mysqlType; } ZippyCoder.Entity.Col col = table.Exists(colName); if (col == null) { col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Parent = table; } col.Name = colName; col.Title = colName; col.DataType = ZippyCoder.TypeConverter.ToSqlDbType(dataType); col.Default = (defVal == "NULL" ? "" : defVal); col.Length = dataLen; col.IsPK = (isKey != null && isKey.ToLower() == "pri"); col.IsNull = (canNull != null && canNull.ToLower() == "yes"); col.AutoIncrease = (extra != null && extra.ToLower() == "auto_increment"); } readerCol.Close(); } #endregion con.Close(); _Owner.Project = project; _Owner.UpdateUI(); }
public static void WriteSqlServerChangeLog(System.IO.StreamWriter sw, ZippyCoder.Entity.Table table, ZippyCoder.Entity.Col col, ChangeTypes changeType, string oldColName) { if (sw == null) { return; } if (table == null) { return; } switch (changeType) { case ChangeTypes.AddCol: if (col != null) { sw.Write("ALTER TABLE [" + table.Name + "] "); sw.Write("ADD [" + col.Name + "] "); if (!string.IsNullOrEmpty(col.Length)) { sw.Write("(" + col.Length + ") "); } if (col.AutoIncrease) { sw.Write("IDENTITY(1,1) "); } if (col.IsPK) { sw.Write("PRIMARY KEY "); } if (col.Unique) { sw.Write("UNIQUE "); } if (col.IsNull) { sw.Write("NULL "); } else { sw.Write("NOT NULL "); } if (!string.IsNullOrEmpty(col.Default)) { sw.Write("DEFAULT (" + col.Default + ") "); } if ((!string.IsNullOrEmpty(col.RefTable)) && (!string.IsNullOrEmpty(col.RefCol))) { sw.Write("REFERENCES [" + col.RefTable + "]([" + col.RefCol + "])"); } sw.WriteLine(); sw.WriteLine("GO"); sw.WriteLine("----------------------------------"); } break; case ChangeTypes.AlterCol: if (col != null) { if (col.Name == oldColName) { sw.Write("ALTER TABLE [" + table.Name + "] "); sw.Write("ALTER COLUMN [" + col.Name + "] "); sw.Write(col.DataType.ToString()); if (!string.IsNullOrEmpty(col.Length)) { sw.Write("(" + col.Length + ") "); } if (col.AutoIncrease) { sw.Write("IDENTITY(1,1) "); } if (col.IsPK) { sw.Write("PRIMARY KEY "); } if (col.Unique) { sw.Write("UNIQUE "); } if (col.IsNull) { sw.Write("NULL "); } else { sw.Write("NOT NULL "); } if (col.Default != "") { sw.Write("DEFAULT (" + col.Default + ") "); } if (col.RefTable != null && col.RefTable != "" && col.RefCol != null && col.RefCol != "") { sw.Write("REFERENCES [" + col.RefTable + "]([" + col.RefCol + "])"); } sw.WriteLine(); sw.WriteLine("GO"); sw.WriteLine("----------------------------------"); } else { sw.Write("ALTER TABLE [" + table.Name + "] "); sw.Write("DROP COLUMN [" + oldColName + "] "); sw.WriteLine(); sw.WriteLine("GO"); sw.WriteLine("----------------------------------"); sw.Write("ALTER TABLE [" + table.Name + "] "); sw.Write("ADD [" + col.Name + "] "); sw.Write(col.DataType.ToString() + " "); if (!string.IsNullOrEmpty(col.Length)) { sw.Write("(" + col.Length + ") "); } if (col.AutoIncrease) { sw.Write("IDENTITY(1,1) "); } if (col.IsPK) { sw.Write("PRIMARY KEY "); } if (col.Unique) { sw.Write("UNIQUE "); } if (col.IsNull) { sw.Write("NULL "); } else { sw.Write("NOT NULL "); } if (!string.IsNullOrEmpty(col.Default)) { sw.Write("DEFAULT (" + col.Default + ") "); } if ((!string.IsNullOrEmpty(col.RefTable)) && (!string.IsNullOrEmpty(col.RefCol))) { sw.Write("REFERENCES [" + col.RefTable + "]([" + col.RefCol + "])"); } sw.WriteLine(); sw.WriteLine("GO"); sw.WriteLine("----------------------------------"); } } break; case ChangeTypes.DropCol: if (col != null) { sw.Write("ALTER TABLE [" + table.Name + "] "); sw.Write("DROP COLUMN [" + col.Name + "] "); sw.WriteLine(); sw.WriteLine("GO"); sw.WriteLine("----------------------------------"); } break; case ChangeTypes.DropTable: sw.Write("DROP TABLE [" + table.Name + "] "); sw.WriteLine(); sw.WriteLine("GO"); sw.WriteLine("----------------------------------"); break; } sw.Write(""); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(ddlDatabase.Text)) { return; } project.Namespace = ddlDatabase.Text; project.Title = ddlDatabase.Text; string conStr1 = "Persist Security Info=False;User ID={1};Password={2};Server={0};Initial Catalog={3}"; string conStr2 = "Persist Security Info=False;Integrated Security=true;Server={0};Initial Catalog={1}"; string conStr = ""; if (string.IsNullOrEmpty(tbxUserName.Text.Trim())) { conStr = string.Format(conStr2, tbxServer.Text, ddlDatabase.Text); } else { conStr = string.Format(conStr1, tbxServer.Text, tbxUserName.Text, tbxPassword.Text, ddlDatabase.Text); } SqlConnection con = new SqlConnection(conStr); try { con.Open(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } List <string> tableNames = new List <string>(); SqlCommand cmd = new SqlCommand("select name from sysobjects where xtype='U' order by name", con); IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tableNames.Add(reader.GetString(0)); } reader.Close(); foreach (string strTableName in tableNames) { ZippyCoder.Entity.Table table = new ZippyCoder.Entity.Table(); table.Name = strTableName; table.Title = strTableName; project.Tables.Add(table); string sql = @"SELECT INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME, INFORMATION_SCHEMA.COLUMNS.DATA_TYPE, INFORMATION_SCHEMA.COLUMNS.COLUMN_DEFAULT, INFORMATION_SCHEMA.COLUMNS.CHARACTER_MAXIMUM_LENGTH, INFORMATION_SCHEMA.COLUMNS.NUMERIC_PRECISION, INFORMATION_SCHEMA.COLUMNS.NUMERIC_SCALE, INFORMATION_SCHEMA.COLUMNS.IS_NULLABLE, COLUMNPROPERTY(OBJECT_ID('" + strTableName + @"'), INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME, 'IsIdentity') AS IsIdentity, INFORMATION_SCHEMA.TABLE_CONSTRAINTS.CONSTRAINT_TYPE FROM INFORMATION_SCHEMA.COLUMNS LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ON INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME = INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE.COLUMN_NAME AND INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE.TABLE_NAME LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS ON INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE.CONSTRAINT_NAME = INFORMATION_SCHEMA.TABLE_CONSTRAINTS.CONSTRAINT_NAME AND INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE.TABLE_NAME = INFORMATION_SCHEMA.TABLE_CONSTRAINTS.TABLE_NAME WHERE INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = '" + strTableName + "'"; //System.Diagnostics.Debug.WriteLine(sql); //return; SqlCommand cmdColProperty = new SqlCommand(sql, con); IDataReader readerCol = cmdColProperty.ExecuteReader(); List <ZippyCoder.Entity.Col> fkCols = new List <ZippyCoder.Entity.Col>(); while (readerCol.Read()) { string colName = readerCol.GetValue(0).ToString(); ZippyCoder.Entity.Col col = table.Exists(colName); if (col == null) { col = new ZippyCoder.Entity.Col(); table.Cols.Add(col); col.Parent = table; } col.Name = colName; col.Title = colName; col.DataType = ZippyCoder.TypeConverter.ToSqlDbType(readerCol.GetValue(1).ToString()); col.Default = readerCol.GetValue(2).ToString(); if (col.DataType == SqlDbType.VarChar || col.DataType == SqlDbType.NVarChar || col.DataType == SqlDbType.Char || col.DataType == SqlDbType.NChar) { col.Length = readerCol.GetValue(3).ToString(); } else if (col.DataType == SqlDbType.Decimal) { col.Length = "(" + readerCol.GetValue(4).ToString() + "," + readerCol.GetValue(5).ToString() + ")"; } if ((readerCol.GetValue(6).ToString().ToUpper() == "NO")) { col.IsNull = false; } if (readerCol.GetValue(7).ToString() == "1") { col.AutoIncrease = true; } if (readerCol.GetValue(8).ToString() == "PRIMARY KEY") { col.IsPK = true; } if (readerCol.GetValue(8).ToString() == "UNIQUE") { col.Unique = true; } if (readerCol.GetValue(8).ToString() == "FOREIGN KEY") //将有外键约束的列记录下来,待查。 { fkCols.Add(col); } } readerCol.Close(); } con.Close(); _Owner.Project = project; _Owner.UpdateUI(); }