/// <summary>
/// 测试连接
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbbServer.Text))
{
MessageBox.Show("服务器不能为空!");
return;
}
if (string.IsNullOrEmpty(txtUserName.Text))
{
MessageBox.Show("登陆名不能为空!");
return;
}
try
{
Hxj.IDBO.IDbObject dbObejct = new Hxj.DbObjects.MySQL.DbObject(false, cbbServer.Text, txtUserName.Text, txtPassword.Text, txtport.Text);
DataTable DBNameTable = dbObejct.GetDBList();
cbbDatabase.Items.Clear();
cbbDatabase.Items.Add("全部");
foreach (DataRow dr in DBNameTable.Rows)
{
cbbDatabase.Items.Add(dr[0].ToString());
}
cbbDatabase.Enabled = true;
cbbDatabase.SelectedIndex = 0;
MessageBox.Show("连接成功!");
}
catch (Exception ex)
{
MessageBox.Show("连接失败!\n\r" + ex.Message);
cbbDatabase.Enabled = false;
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ContentForm_Load(object sender, EventArgs e)
{
Hxj.IDBO.IDbObject dbObject = null;
if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer.ToString()))
{
dbObject = new Hxj.DbObjects.SQL2000.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer9.ToString()))
{
dbObject = new Hxj.DbObjects.SQL2005.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.MsAccess.ToString()))
{
dbObject = new Hxj.DbObjects.OleDb.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.Oracle.ToString()))
{
dbObject = new Hxj.DbObjects.Oracle.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.Sqlite3.ToString()))
{
dbObject = new Hxj.DbObjects.SQLite.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.MySql.ToString()))
{
dbObject = new Hxj.DbObjects.MySQL.DbObject(ConnectionModel.ConnectionString);
}
else
{
MessageBox.Show("未知数据库类型!");
return;
}
columnsdt = dbObject.GetColumnInfoList(DatabaseName, TableName);
gridColumns.DataSource = columnsdt;
DataTable primarykeydt = dbObject.GetKeyName(DatabaseName, TableName);
cbPrimarykey.Items.Clear();
if (null != primarykeydt && primarykeydt.Rows.Count > 0)
{
foreach (DataRow dr in primarykeydt.Rows)
{
cbPrimarykey.Items.Add(dr["ColumnName"].ToString());
}
cbPrimarykey.SelectedIndex = 0;
}
txtClassName.Text = TableName.Trim().Replace(' ', '_');
txtnamespace.Text = Utils.ReadNamespace();
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbbServer.Text))
{
MessageBox.Show("服务器不能为空!");
return;
}
if (string.IsNullOrEmpty(txtUserName.Text))
{
MessageBox.Show("登陆名不能为空!");
return;
}
Hxj.IDBO.IDbObject dbObejct = new Hxj.DbObjects.MySQL.DbObject(false, cbbServer.Text, txtUserName.Text, txtPassword.Text);
string tempconnectionstring = dbObejct.DbConnectStr;
try
{
using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(tempconnectionstring))
{
connection.Open();
}
}
catch (Exception ex)
{
MessageBox.Show("连接失败!\n\r" + ex.Message);
return;
}
Model.Connection connectionModel = new Hxj.Tools.EntityDesign.Model.Connection();
connectionModel.Database = cbbDatabase.SelectedIndex == 0 ? "all" : cbbDatabase.Text;
connectionModel.ID = Guid.NewGuid();
connectionModel.Name = cbbServer.Text + "(MySql)[" + connectionModel.Database + "]";
connectionModel.ConnectionString = tempconnectionstring;
connectionModel.DbType = Dos.ORM.DatabaseType.MySql.ToString();
Utils.AddConnection(connectionModel);
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbbServer.Text))
{
MessageBox.Show("服务器不能为空!");
return;
}
if (string.IsNullOrEmpty(txtUserName.Text))
{
MessageBox.Show("登陆名不能为空!");
return;
}
Hxj.IDBO.IDbObject dbObejct = new Hxj.DbObjects.MySQL.DbObject(false, cbbServer.Text, txtUserName.Text, txtPassword.Text, txtport.Text);
string tempconnectionstring = dbObejct.DbConnectStr;
try
{
using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(tempconnectionstring))
{
connection.Open();
}
}
catch (Exception ex)
{
MessageBox.Show("连接失败!\n\r" + ex.Message);
return;
}
Model.Connection connectionModel = new Hxj.Tools.EntityDesign.Model.Connection();
connectionModel.Database = cbbDatabase.SelectedIndex == 0 ? "all" : cbbDatabase.Text;
connectionModel.ID = Guid.NewGuid();
connectionModel.Name = cbbServer.Text + "(MySql)[" + connectionModel.Database + "]";
connectionModel.ConnectionString = tempconnectionstring;
connectionModel.DbType = Dos.ORM.DatabaseType.MySql.ToString();
Utils.AddConnection(connectionModel);
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// 测试连接
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbbServer.Text))
{
MessageBox.Show("服务器不能为空!");
return;
}
if (string.IsNullOrEmpty(txtUserName.Text))
{
MessageBox.Show("登陆名不能为空!");
return;
}
try
{
Hxj.IDBO.IDbObject dbObejct = new Hxj.DbObjects.MySQL.DbObject(false, cbbServer.Text, txtUserName.Text, txtPassword.Text, txtport.Text);
DataTable DBNameTable = dbObejct.GetDBList();
cbbDatabase.Items.Clear();
cbbDatabase.Items.Add("全部");
foreach (DataRow dr in DBNameTable.Rows)
{
cbbDatabase.Items.Add(dr[0].ToString());
}
cbbDatabase.Enabled = true;
cbbDatabase.SelectedIndex = 0;
MessageBox.Show("连接成功!");
}
catch (Exception ex)
{
MessageBox.Show("连接失败!\n\r" + ex.Message);
cbbDatabase.Enabled = false;
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ContentForm_Load(object sender, EventArgs e)
{
Hxj.IDBO.IDbObject dbObject = null;
if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer.ToString()))
{
dbObject = new Hxj.DbObjects.SQL2000.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer9.ToString()))
{
dbObject = new Hxj.DbObjects.SQL2005.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.MsAccess.ToString()))
{
dbObject = new Hxj.DbObjects.OleDb.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.Oracle.ToString()))
{
dbObject = new Hxj.DbObjects.Oracle.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.Sqlite3.ToString()))
{
dbObject = new Hxj.DbObjects.SQLite.DbObject(ConnectionModel.ConnectionString);
}
else if (ConnectionModel.DbType.Equals(Dos.ORM.DatabaseType.MySql.ToString()))
{
dbObject = new Hxj.DbObjects.MySQL.DbObject(ConnectionModel.ConnectionString);
}
else
{
MessageBox.Show("未知数据库类型!");
return;
}
columnsdt = dbObject.GetColumnInfoList(DatabaseName, TableName);
gridColumns.DataSource = columnsdt;
DataTable primarykeydt = dbObject.GetKeyName(DatabaseName, TableName);
cbPrimarykey.Items.Clear();
if (null != primarykeydt && primarykeydt.Rows.Count > 0)
{
foreach (DataRow dr in primarykeydt.Rows)
{
cbPrimarykey.Items.Add(dr["ColumnName"].ToString());
}
cbPrimarykey.SelectedIndex = 0;
}
txtClassName.Text = TableName.Trim().Replace(' ', '_');
txtnamespace.Text = Utils.ReadNamespace();
}
/// <summary>
///
/// </summary>
private void getDatabaseinfo()
{
TreeNode node = tview.SelectedNode;
Model.Connection conModel = list.Find(delegate(Model.Connection con) { return con.ID.ToString().Equals(node.Tag.ToString()); });
IDBO.IDbObject dbObject;
if (conModel.DbType.Equals(Dos.ORM.DatabaseType.MsAccess.ToString()))
{
dbObject = new Hxj.DbObjects.OleDb.DbObject(conModel.ConnectionString);
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(""), dbObject.GetVIEWs(""));
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.Sqlite3.ToString()))
{
dbObject = new Hxj.DbObjects.SQLite.DbObject(conModel.ConnectionString);
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(""), dbObject.GetVIEWs(""));
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer.ToString()) || conModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer9.ToString()))
{
if (conModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer.ToString()))
dbObject = new Hxj.DbObjects.SQL2000.DbObject(conModel.ConnectionString);
else
dbObject = new Hxj.DbObjects.SQL2005.DbObject(conModel.ConnectionString);
if (conModel.Database.Equals("all"))
{
DataTable dt = dbObject.GetDBList();
foreach (DataRow dr in dt.Rows)
{
TreeNode tnode = new TreeNode(dr[0].ToString(), 1, 1);
tnode.Tag = conModel.ConnectionString.Replace("master", dr[0].ToString());
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
else
{
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.Oracle.ToString()))
{
dbObject = new Hxj.DbObjects.Oracle.DbObject(conModel.ConnectionString);
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.MySql.ToString()))
{
dbObject = new Hxj.DbObjects.MySQL.DbObject(conModel.ConnectionString);
if (conModel.Database.Equals("all"))
{
DataTable dt = dbObject.GetDBList();
foreach (DataRow dr in dt.Rows)
{
TreeNode tnode = new TreeNode(dr[0].ToString(), 1, 1);
tnode.Tag = conModel.ConnectionString.Replace("master", dr[0].ToString());
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
else
{
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
}
/// <summary>
///
/// </summary>
private void getDatabaseinfo()
{
TreeNode node = tview.SelectedNode;
Model.Connection conModel = list.Find(delegate(Model.Connection con) { return(con.ID.ToString().Equals(node.Tag.ToString())); });
IDBO.IDbObject dbObject;
if (conModel.DbType.Equals(Dos.ORM.DatabaseType.MsAccess.ToString()))
{
dbObject = new Hxj.DbObjects.OleDb.DbObject(conModel.ConnectionString);
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(""), dbObject.GetVIEWs(""));
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.Sqlite3.ToString()))
{
dbObject = new Hxj.DbObjects.SQLite.DbObject(conModel.ConnectionString);
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(""), dbObject.GetVIEWs(""));
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer.ToString()) || conModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer9.ToString()))
{
if (conModel.DbType.Equals(Dos.ORM.DatabaseType.SqlServer.ToString()))
{
dbObject = new Hxj.DbObjects.SQL2000.DbObject(conModel.ConnectionString);
}
else
{
dbObject = new Hxj.DbObjects.SQL2005.DbObject(conModel.ConnectionString);
}
if (conModel.Database.Equals("all"))
{
DataTable dt = dbObject.GetDBList();
foreach (DataRow dr in dt.Rows)
{
TreeNode tnode = new TreeNode(dr[0].ToString(), 1, 1);
tnode.Tag = conModel.ConnectionString.Replace("master", dr[0].ToString());
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
else
{
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.Oracle.ToString()))
{
dbObject = new Hxj.DbObjects.Oracle.DbObject(conModel.ConnectionString);
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
else if (conModel.DbType.Equals(Dos.ORM.DatabaseType.MySql.ToString()))
{
dbObject = new Hxj.DbObjects.MySQL.DbObject(conModel.ConnectionString);
if (conModel.Database.Equals("all"))
{
DataTable dt = dbObject.GetDBList();
foreach (DataRow dr in dt.Rows)
{
TreeNode tnode = new TreeNode(dr[0].ToString(), 1, 1);
tnode.Tag = conModel.ConnectionString.Replace("master", dr[0].ToString());
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
else
{
TreeNode tnode = new TreeNode(conModel.Database, 1, 1);
tnode.Tag = conModel.ConnectionString;
tnode.ContextMenuStrip = contextMenuStripOneDataBase;
node.Nodes.Add(tnode);
gettables(tnode, dbObject.GetTables(tnode.Text), dbObject.GetVIEWs(tnode.Text));
}
}
}
