public void ExecuteSql()
{
try
{
SODatabase db = base.MainForm.GetCurrentDatabase();
string cmdText = textEditorControl1.Text;
if (this.CurrentDatabase != db)
{
this.CurrentDatabase = db;
}
DataSet ds = DbSchemaHelper.Instance.CurrentSchema.ExecuteQuery(CurrentDatabase, cmdText);
if (ds != null && ds.Tables.Count > 0)
{
dataGridView1.DataSource = ds.Tables[0].DefaultView;
richTextBox1.Text = string.Format("({0} 行受影响)", ds.Tables[0].Rows.Count);
tabControl1.SelectedTab = tabPage1;
}
else
{
richTextBox1.Text = "已成功执行查询";
dataGridView1.DataSource = null;
tabControl1.SelectedTab = tabPage2;
}
}
catch (Exception ex)
{
tabControl1.SelectedTab = tabPage2;
richTextBox1.Text = ex.ToString();
}
}
/// <summary>
/// 获取表列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOTable> GetTableList(SODatabase db)
{
string cmdText = string.Format("use [{0}];exec sp_tables;", db.Name);
SortedDictionary <string, SOTable> dic = new SortedDictionary <string, SOTable>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
if (row["TABLE_TYPE"].ToString() != "TABLE")
{
continue;
}
if (row["TABLE_OWNER"].ToString() == "sys")
{
continue;
}
SOTable table = new SOTable {
Parent = db, Name = row["TABLE_NAME"].ToString(), Owner = row["TABLE_OWNER"].ToString()
};
table.SchemaName = table.Owner;
table.Comment = GetTableComment(table);
dic.Add(table.Name, table);
}
return(dic.Values.ToList <SOTable>());
}
public static SODatabase ToSODatabase(PDPackage package)
{
if (package == null)
{
return(null);
}
SODatabase db = new SODatabase();
db.Name = package.Code;
db.Comment = string.IsNullOrEmpty(package.Comment) ? package.Name : package.Comment;
db.TableList = new List <SOTable>();
foreach (PDTable item in package.TableList)
{
db.TableList.Add(ToSOTable(item));
}
db.ViewList = new List <SOView>();
//foreach (PDView item in package.ViewList)
//{
// db.ViewList.Add(ToSOView(item));
//}
db.CommandList = new List <SOCommand>();
//foreach (PDProcedure item in package.ProcedureList)
//{
// db.CommandList.Add(ToSOCommand(item));
//}
return(db);
}
public static SODatabase ToSODatabase(PDModel model)
{
if (model == null)
{
return(null);
}
SODatabase db = new SODatabase();
db.Name = model.Code;
db.Comment = string.IsNullOrEmpty(model.Comment) ? model.Name : model.Comment;
db.TableList = new List <SOTable>();
foreach (PDTable item in model.AllTableList)
{
db.TableList.Add(ToSOTable(item));
}
db.ViewList = new List <SOView>();
//foreach (PDView item in model.AllViewList)
//{
// db.ViewList.Add(ToSOView(item));
//}
db.CommandList = new List <SOCommand>();
//foreach (PDProcedure item in model.AllProcedureList)
//{
// db.CommandList.Add(ToSOCommand(item));
//}
return(db);
}
/// <summary>
/// 获取表列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOTable> GetTableList(SODatabase db)
{
string cmdText = string.Format(@"select t.OWNER,t.TABLE_NAME,t.NUM_ROWS,c.TABLE_TYPE,c.COMMENTS
from dba_tables t left join dba_tab_comments c on t.TABLE_NAME = c.TABLE_NAME where t.owner='{0}'", db.Name);
SortedDictionary <string, SOTable> dic = new SortedDictionary <string, SOTable>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
//if (row["TABLE_TYPE"].ToString() != "TABLE") continue;
if (row["TABLE_NAME"].ToString().StartsWith("BIN$"))
{
continue;
}
SOTable table = new SOTable {
Parent = db, Name = row["TABLE_NAME"].ToString(), Owner = row["OWNER"].ToString(), Comment = row["COMMENTS"].ToString()
};
table.SchemaName = table.Owner;
if (!dic.ContainsKey(table.Name))
{
dic.Add(table.Name, table);
}
}
return(dic.Values.ToList <SOTable>());
}
/// <summary>
/// 在指定数据库上执行一个查询，返回一个结果集
/// </summary>
/// <param name="db"></param>
/// <param name="cmdText"></param>
/// <returns></returns>
public virtual DataSet ExecuteQuery(SODatabase db, string cmdText)
{
this.DbProvider.CurrentDatabaseName = db.Name.Contains("[") ? db.Name.Replace("[", "").Replace("]", "") : db.Name;
DataSet ds = this.DbProvider.ExecuteDataSet(CommandType.Text, cmdText);
return(ds);
}
public override List <SODatabase> GetDatabaseList()
{
List <SODatabase> list = new List <SODatabase>();
string cmdText = "select * from dba_users";
if (!IsDBA)
{
cmdText = "select * from user_users";
}
try
{
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
SODatabase db = new SODatabase();
db.Name = row["USERNAME"].ToString();
db.Comment = db.Name;
db.Parent = this;
list.Add(db);
}
}
catch (Exception)
{
}
return(list);
}
// /// <summary>
// /// 获取表所拥有的索引列表
// /// </summary>
// /// <param name="table"></param>
// /// <returns></returns>
// public override List<SOIndex> GetTableIndexList(SOTable table)
// {
// string cmdText = string.Format(@"SELECT *
// FROM INFORMATION_SCHEMA.`constraints`
// WHERE table_schema='{0}' AND table_name='{1}';", table.Database.Name, table.Name);
// List<SOIndex> indexList = new List<SOIndex>();
// List<SOColumn> columnList = GetTableColumnList(table);
// DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
// foreach (DataRow row in dt.Rows)
// {
// SOIndex index = new SOIndex
// {
// Parent = table,
// Name = row["constraint_name"].ToString(),
// Comment = row["constraint_name"].ToString(),
// IsCluster = false,
// IsFullText = row["constraint_type"].ToString() == "Full Text",
// IsPrimaryKey = row["constraint_type"].ToString() == "PRIMARY KEY",
// IsUnique = row["constraint_type"].ToString() == "UNIQUE"
// };
// indexList.Add(index);
// string cmdText2 = string.Format(@"SELECT column_name
// FROM INFORMATION_SCHEMA.`statistics`
// WHERE table_schema='{0}' AND table_name='{1}';", table.Database.Name, table.Name);
// DataTable dt2 = this.DbProvider.ExecuteDataSet(CommandType.Text, cmdText2).Tables[0];
// index.Columns = new List<SOColumn>();
// foreach (DataRow row2 in dt2.Rows)
// {
// foreach (SOColumn column in columnList)
// {
// if (row2[0].ToString() == column.Name) index.Columns.Add(column);
// }
// }
// }
// return indexList;
// }
/// <summary>
/// 获取视图列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOView> GetViewList(SODatabase db)
{
string cmdText = string.Format("use [{0}];exec sp_tables;", db.Name);
SortedDictionary <string, SOView> dic = new SortedDictionary <string, SOView>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
if (row["TABLE_TYPE"].ToString() != "VIEW")
{
continue;
}
if (row["TABLE_OWNER"].ToString() == "sys" || row["TABLE_OWNER"].ToString() == "INFORMATION_SCHEMA")
{
continue;
}
SOView view = new SOView {
Parent = db, Name = row["TABLE_NAME"].ToString(), Owner = row["TABLE_OWNER"].ToString()
};
view.SchemaName = view.Owner;
dic.Add(view.Name, view);
}
return(dic.Values.ToList <SOView>());
}
/// <summary>
/// 在指定数据库上执行一个查询，返回一个结果集
/// </summary>
/// <param name="db"></param>
/// <param name="cmdText"></param>
/// <returns></returns>
public virtual DataSet ExecuteQuery(SODatabase db, string cmdText)
{
this.DbProvider.CurrentDatabaseName = db.Name;
DataSet ds = this.DbProvider.ExecuteDataSet(CommandType.Text, cmdText);
return(ds);
}
/// <summary>
/// 加载数据表
/// </summary>
/// <param name="connectionName"></param>
private void LoadTable(String connectionName)
{
// 加载数据库
nowConnectionName = connectionName;
var dal = new DbConnConfigDAL();
var model = dal.FindOne(connectionName);
this.nowDbSchema = DbSchemaFactory.Create(new MySqlDatabase(model.ConnectionString, MySqlClientFactory.Instance));
try
{
nowDb = this.nowDbSchema.GetDatabase(model.DefaultDb);
}
catch (Exception e1)
{
MsgBox.ShowErrorMessage("数据库打开失败:" + e1.Message);
return;
}
// 加载表
this.listBox1.Items.Clear();
this.listBox2.Items.Clear();
this.unSelectedTableList.Clear();
this.selectedTableList.Clear();
foreach (SOTable t in nowDb.TableList)
{
listBox1.Items.Add(t);
unSelectedTableList.Add(t);
}
}
////使用实体层模板批量生成代码
//private void menuItemBatchBuildEnityCode_Click(object sender, EventArgs e)
//{
// SODatabase db = tvDatabase.SelectedNode.Tag as SODatabase;
// BatchBuildEntityCode dialog = new BatchBuildEntityCode(db);
// dialog.ShowDialog();
//}
////使用数据层模板批量生成代码
//private void menuItemBatchBuildDALCode_Click(object sender, EventArgs e)
//{
// SODatabase db = tvDatabase.SelectedNode.Tag as SODatabase;
// BatchBuildDALCode dialog = new BatchBuildDALCode(db);
// dialog.ShowDialog();
//}
//批量生成代码
private void menuItemBatchBuildCode_Click(object sender, EventArgs e)
{
SODatabase db = tvDatabase.SelectedNode.Tag as SODatabase;
BatchBuildCode dialog = new BatchBuildCode(db);
dialog.Show(this.DockPanel);
}
private string GetDBComment(SODatabase db)
{
string cmdText = string.Format(@"use [{0}];
SELECT value as 'comment'
FROM fn_listextendedproperty(default, default, default, default, default, default, default); ", db.Name);
return(this.DbProvider.ExecuteScalar <string>(CommandType.Text, cmdText));
}
public void AddDbListItem(SODatabase db)
{
try
{
toolItemDbList.Items.Add(db);
}
catch { }
}
//加载数据库元数据架构信息
void LoadDbSchema(TreeNode dbNode)
{
this.Cursor = Cursors.WaitCursor;
dbNode.Nodes.Clear();
SODatabase db = dbNode.Tag as SODatabase;
TreeNode tableNode = new TreeNode("表", 2, 2);
TreeNode viewNode = new TreeNode("视图", 2, 2);
TreeNode spNode = new TreeNode("存储过程", 2, 2);
//加载表列表
IList <SOTable> tableList = dbSchema.GetTableList(db);
foreach (SOTable t in tableList)
{
//TreeNode tn = new TreeNode(t.FullName, 3, 3);
TreeNode tn = new TreeNode(t.Name, 3, 3);
tn.Tag = t;
tn.ToolTipText = string.IsNullOrEmpty(t.Comment) ? t.Name : t.Comment;
tn.ContextMenuStrip = cmsTable;
tableNode.Nodes.Add(tn);
}
//加载视图列表
IList <SOView> viewList = dbSchema.GetViewList(db);
foreach (SOView v in viewList)
{
//TreeNode tn = new TreeNode(v.FullName, 4, 4);
TreeNode tn = new TreeNode(v.Name, 4, 4);
tn.Tag = v;
tn.ToolTipText = string.IsNullOrEmpty(v.Comment) ? v.Name : v.Comment;
tn.ContextMenuStrip = cmsView;
viewNode.Nodes.Add(tn);
}
//加载存储过程列表
IList <SOCommand> spList = dbSchema.GetCommandList(db);
if (spList != null && spList.Count > 0)
{
foreach (SOCommand p in spList)
{
//TreeNode tn = new TreeNode(p.FullName, 5, 5);
TreeNode tn = new TreeNode(p.Name, 5, 5);
tn.Tag = p;
tn.ToolTipText = string.IsNullOrEmpty(p.Comment) ? p.Name : p.Comment;
tn.ContextMenuStrip = cmsSp;
spNode.Nodes.Add(tn);
}
}
dbNode.Nodes.Add(tableNode);
dbNode.Nodes.Add(viewNode);
dbNode.Nodes.Add(spNode);
this.Cursor = Cursors.Default;
}
//add behabiour of type t to state
public void AddBehaviour(System.Type t)
{
if (!t.IsSubclassOf(typeof(StateBehaviour)))
{
return;
}
SODatabase.Add(state, (StateBehaviour)CreateInstance(t), state.behaviours);
fold.Add(true);
}
public void SetCurrentDB(SODatabase db)
{
foreach (object item in toolItemDbList.Items)
{
if (item.ToString() == db.Name)
{
toolItemDbList.SelectedItem = item;
}
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="database">要使用的数据库</param>
/// <param name="tableList">要使用的表列表</param>
/// <param name="templateInfoList">要使用的模板列表</param>
/// <param name="nameRuleConfig">命名规则</param>
/// <param name="paramList">生成的参数信息</param>
/// <param name="savePath">保存路径</param>
/// <param name="typeMapConfigList">类型映射</param>
public GenerateBase(SODatabase database, List <SOTable> tableList, List <TemplateInfo> templateInfoList,
List <TypeMapConfig> typeMapConfigList, NameRuleConfig nameRuleConfig, List <ParamItem> paramList, String savePath)
{
this.TableList = tableList;
this.Database = database;
this.TemplateInfoList = templateInfoList;
this.TypeMapConfigList = typeMapConfigList;
this.NameRuleConfig = nameRuleConfig;
this.ParamList = paramList;
this.SavePath = savePath;
}
public void Add(System.Type varType)
{
if (!varType.IsSubclassOf(typeof(Variable)))
{
return;
}
Variable v = (Variable)CreateInstance(varType);
SODatabase.Add(varHandle, v, varHandle.Variables);
v.name = "Variable";
fold.Add(true);
}
private void CreateScorerOptions()
{
newScorerType = AISEditorUtil.allScorers[EditorGUILayout.Popup("New Scorer Type:", AISEditorUtil.allScorers.IndexOf(newScorerType), AISEditorUtil.allScorers.Select(x => x.Name).ToArray())];
if (GUILayout.Button("Create new Scorer"))
{
AISScorer scorer = CreateInstance(newScorerType) as AISScorer;
if (scorer != null)
{
scorer.name = "New";
scorer.owner = this;
SODatabase.Add(this, scorer, scorers);
}
}
}
public static VarHandleTemplateEditor GetCreateEditor(VarHandleTemplate vh)
{
VarHandleTemplateEditor vhe = SODatabase.GetSubObjectOfType <VarHandleTemplateEditor>(vh);
if (vhe)
{
return(vhe);
}
vhe = CreateInstance <VarHandleTemplateEditor>();
vhe.varHandle = vh;
vhe.name = vh.name + "Editor";
AssetDatabase.AddObjectToAsset(vhe, vh);
return(vhe);
}
/// <summary>
/// 获取表列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOTable> GetTableList(SODatabase db)
{
string cmdText = string.Format("SELECT table_name,table_type,table_comment FROM INFORMATION_SCHEMA.`TABLES` WHERE table_schema='{0}' AND table_type='BASE TABLE';", db.Name);
List <SOTable> tableList = new List <SOTable>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
SOTable table = new SOTable {
Parent = db, Name = row["table_name"].ToString(), Comment = row["table_comment"].ToString()
};
tableList.Add(table);
}
return(tableList);
}
/// <summary>
/// 生成一个表
/// </summary>
/// <param name="dataBaseObj">数据库对象</param>
/// <param name="templateItem">模板列表</param>
/// <param name="savedFileName">保存到的文件名</param>
/// <param name="paramData">参数数据</param>
private String BuildTable(SODatabase dataBaseObj, TemplateInfo templateItem, out String savedFileName)
{
//生成代码文件
DatabaseHost host = new DatabaseHost(dataBaseObj, this.NameRuleConfig, this.TypeMapConfigList);
host.TemplateFile = templateItem.FilePath;
// 额外参数追加
if (this.ParamList != null && this.ParamList.Count > 0)
{
foreach (var item in this.ParamList)
{
host.SetValue(item.ParamName, item.ParamValue);
}
}
Engine engine = new Engine();
string templateContent = File.ReadAllText(templateItem.FilePath);
var outputContent = engine.ProcessTemplate(templateContent, host);
savedFileName = Path.Combine(this.SavePath, string.Format("{0}{1}", templateItem.TemplateName, host.FileExtention));
if (String.IsNullOrWhiteSpace(host.OutputFileName) == false)
{
savedFileName = Path.Combine(this.SavePath, host.OutputFileName);
}
StringBuilder sb = new StringBuilder();
if (host.ErrorCollection != null && host.ErrorCollection.HasErrors)
{
foreach (CompilerError err in host.ErrorCollection)
{
sb.AppendLine(err.ToString());
}
return(sb.ToString());
}
if (Directory.Exists(this.SavePath) == false)
{
Directory.CreateDirectory(this.SavePath);
}
File.WriteAllText(savedFileName, outputContent, host.FileEncoding);
return(String.Empty);
}
/// <summary>
/// 获取数据库列表
/// </summary>
/// <returns></returns>
public virtual List <SODatabase> GetDatabaseList()
{
List <SODatabase> list = new List <SODatabase>();
DataTable dt = GetSchema(MetaDataCollectionName_Databases);
foreach (DataRow dr in dt.Rows)
{
SODatabase db = new SODatabase();
db.Name = dr["database_name"].ToString();
db.Comment = db.Name;
db.Parent = this;
list.Add(db);
}
return(list);
}
/// <summary>
/// 获取存储过程列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOCommand> GetCommandList(SODatabase db)
{
string cmdText = string.Format(@"select PROCEDURE_NAME from dba_procedures where owner='{0}'", db.Name);
List <SOCommand> commandList = new List <SOCommand>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
SOCommand command = new SOCommand {
Parent = db, Name = row["PROCEDURE_NAME"].ToString(), Comment = row["PROCEDURE_NAME"].ToString()
};
commandList.Add(command);
}
return(commandList);
}
/// <summary>
/// 获取视图列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOView> GetViewList(SODatabase db)
{
string cmdText = string.Format("select VIEW_NAME,TEXT from dba_views where owner='{0}'", db.Name);
SortedDictionary <string, SOView> dic = new SortedDictionary <string, SOView>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
SOView view = new SOView {
Parent = db, Name = row["VIEW_NAME"].ToString(), SqlText = row["TEXT"].ToString(), Owner = db.Name
};
view.SchemaName = view.Owner;
dic.Add(view.Name, view);
}
return(dic.Values.ToList <SOView>());
}
// /// <summary>
// /// 获取视图所拥有的索引列表
// /// </summary>
// /// <param name="view"></param>
// /// <returns></returns>
// public override List<SOIndex> GetViewIndexList(SOView view)
// {
// string cmdText = string.Format(@"SELECT *
// FROM INFORMATION_SCHEMA.`constraints`
// WHERE table_schema='{0}' AND table_name='{1}';", view.Database.Name, view.Name);
// List<SOIndex> indexList = new List<SOIndex>();
// List<SOColumn> columnList = GetViewColumnList(view);
// DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
// foreach (DataRow row in dt.Rows)
// {
// SOIndex index = new SOIndex
// {
// Parent = view,
// Name = row["constraint_name"].ToString(),
// Comment = row["constraint_name"].ToString(),
// IsCluster = false,
// IsFullText = row["constraint_type"].ToString() == "Full Text",
// IsPrimaryKey = row["constraint_type"].ToString() == "PRIMARY KEY",
// IsUnique = row["constraint_type"].ToString() == "UNIQUE"
// };
// indexList.Add(index);
// string cmdText2 = string.Format(@"SELECT column_name
// FROM INFORMATION_SCHEMA.`statistics`
// WHERE table_schema='{0}' AND table_name='{1}';", view.Database.Name, view.Name);
// DataTable dt2 = this.DbProvider.ExecuteDataSet(CommandType.Text, cmdText2).Tables[0];
// index.Columns = new List<SOColumn>();
// foreach (DataRow row2 in dt2.Rows)
// {
// foreach (SOColumn column in columnList)
// {
// if (row2[0].ToString() == column.Name) index.Columns.Add(column);
// }
// }
// }
// return indexList;
// }
/// <summary>
/// 获取存储过程列表
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public override List <SOCommand> GetCommandList(SODatabase db)
{
string cmdText = string.Format(@"use [{0}];SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_catalog='{0}' AND routine_type='PROCEDURE';", db.Name);
List <SOCommand> commandList = new List <SOCommand>();
DataTable dt = this.DbProvider.ExecuteDataSet(System.Data.CommandType.Text, cmdText).Tables[0];
foreach (DataRow row in dt.Rows)
{
SOCommand command = new SOCommand {
Parent = db, Name = row["routine_name"].ToString(), Comment = row["routine_name"].ToString()
};
commandList.Add(command);
}
return(commandList);
}
private void CreateChildOptions()
{
GUILayout.BeginHorizontal();
newChildType = AISEditorUtil.allActions[EditorGUILayout.Popup("New Child Type:", AISEditorUtil.allActions.IndexOf(newChildType), AISEditorUtil.allActions.Select(x => x.Name).ToArray())];
if (GUILayout.Button("Create new child"))
{
AISAction child = CreateInstance(newChildType) as AISAction;
if (child != null)
{
child.name = "New";
child.order = order + 1;
child.parent = this;
child.ai = ai;
SODatabase.Add(this, child, children);
}
}
GUILayout.EndHorizontal();
}
void OnGUI()
{
GUILayout.BeginVertical();
item = EditorGUILayout.ObjectField("Item: ", item, typeof(Item), false) as Item;
if (item)
{
item.OnGui();
GUILayout.BeginHorizontal();
newCompType = Item.allComponents[EditorGUILayout.Popup(Item.allComponents.IndexOf(newCompType), Item.allComponents.ToArray())];
if (GUILayout.Button("Create component"))
{
ItemComponent c = CreateInstance(newCompType) as ItemComponent;
if (c)
{
c.item = item;
c.name = "New " + c.GetType().ToString();
SODatabase.Add(item, c, item.components);
}
}
GUILayout.EndHorizontal();
if (GUILayout.Button("Save"))
{
EditorUtility.SetDirty(item);
foreach (ItemComponent c in item.components)
{
EditorUtility.SetDirty(c);
}
}
}
else
{
EditorGUILayout.LabelField("Choose an Item");
item = Selection.activeObject as Item;
}
GUILayout.EndVertical();
}
private void tvDatabase_MouseDoubleClick(object sender, MouseEventArgs e)
{
TreeView tv = sender as TreeView;
TreeNode tn = tv.GetNodeAt(e.X, e.Y);
if (tn != null && tn.Level == 1 && tn.Nodes.Count == 0)
{
LoadDbSchema(tn);
tn.Expand();
}
if (tn != null && tn.Parent != null && tn.Level == 3)
{
if (tn.Parent.Text == "表")
{
if (this.DockPanel.ActiveDocument is CodeBuilder)
{
SOTable t = tvDatabase.SelectedNode.Tag as SOTable;
if (t == null)
{
return;
}
CodeBuilder builder = this.DockPanel.ActiveDocument as CodeBuilder;
builder.Table = t;
builder.ColumnList = dbSchema.GetTableColumnList(t);
builder.LoadColumnList();
}
}
}
if (tn != null && tn.Parent != null && tn.Level == 1 && (tvDatabase.SelectedNode.Tag is SODatabase))
{
SODatabase _db = (SODatabase)tvDatabase.SelectedNode.Tag;
CodeBuilder builder = this.DockPanel.ActiveDocument as CodeBuilder;
if (builder == null)
{
builder = new CodeBuilder();
builder.Show(this.DockPanel);
}
builder.DataBase = _db;
}
}
private void NewQuery(SODatabase db, string sqlText)
{
QueryAnalyzer qa = new QueryAnalyzer();
qa.CurrentDatabase = db;
base.MainForm.SetCurrentDB(db);
int count = 1;
string fileName = string.Format("SqlQuery{0}.sql", count.ToString());
while (base.MainForm.FindDockDocument(fileName) != null)
{
count++;
fileName = string.Format("SqlQuery{0}.sql", count.ToString());
}
qa.FileName = fileName;
qa.SqlText = sqlText;
qa.Show(DockPanel);
}
