private void FormMainOrcl_Load(object sender, EventArgs e)
{
DataTable dt = (DbType == "Oracle")?DBconnectionOracle.ShowTableList():DBconnectionSQLServer.ShowTableList(DbName);
foreach (DataRow row in dt.Rows)
{
int index = TableView.Rows.Add();
TableView.Rows[index].Cells[0].Value = (DbType == "Oracle") ? row["table_name"].ToString():row["name"].ToString();
}
if (TableView.CurrentCell != null && TableView.CurrentCell.Value != null)
{
DataTable ds = (DbType == "Oracle") ? DBconnectionOracle.ShowTable(TableView.CurrentCell.Value.ToString()) : DBconnectionSQLServer.ShowTable(DbName, TableView.CurrentCell.Value.ToString());
try
{
DataView.DataSource = ds;//表从起始行显示在dataGridView里
}
catch (Exception)
{
MessageBox.Show("数据未能正确获得,请重试", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
System.Threading.Thread.CurrentThread.Abort();
//DBView.CurrentCell = DBView.Rows[0].Cells[0];
}
}
}
/// <summary>
/// 为Oracle数据库中某个表删除一个字段
/// </summary>
/// <param name="tableName"></param>
/// <param name="fieldName"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static bool DBOracleDeleteField(string tableName, string fieldName, ref string sql)
{
if (OracleCompareTable(tableName) == true)
{
sql = @"ALTER TABLE " + tableName + " DROP COLUMN " + fieldName;
return(DBconnectionOracle.ExecuteSql(sql));
}
return(false);
}
/// <summary>
/// Oracle查询表中索引数目
/// </summary>
/// <param name="tableName"></param>
/// <param name="indexNum"></param>
/// <returns></returns>
public static bool DBOracleCountIndex(string tableName, ref string indexNum)
{
if (OracleCompareTable(tableName) == true)
{
string sql = @"select count(*) from all_ind_columns a, all_indexes b where a.index_name=b.index_name and a.table_name = upper('" + tableName + "')";
return(DBconnectionOracle.ExecuteSql(sql, ref indexNum));
}
return(false);
}
/// <summary>
/// Oracle查询列名对应的索引名
/// </summary>
/// <param name="tableName"></param>
/// <param name="fieldName"></param>
/// <param name="indexName"></param>
/// <returns></returns>
public static bool DBOracleFieldToIndex(string tableName, string fieldName, ref string indexName)
{
if (OracleCompareTable(tableName) == true)
{
string sql = @"SELECT INDEX_NAME FROM USER_IND_COLUMNS WHERE TABLE_NAME = '" + tableName + "' AND COLUMN_NAME='" + fieldName + "'";
return(DBconnectionOracle.ExecuteSql(sql, ref indexName));
}
return(false);
}
/// <summary>
/// 为Oracle数据库某个表的某个字段删除一个非聚集索引
/// </summary>
/// <param name="indexName"></param>
/// <param name="tableName"></param>
/// <param name="fieldName"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static bool DBOracleDeleteIndex(string indexName, string tableName, string fieldName, ref string sql)
{
if (OracleCompareTable(tableName) == true)
{
sql = @"DROP INDEX " + indexName;
return(DBconnectionOracle.ExecuteSql(sql));
}
return(false);
//create index toys_color_i on toys(color);
}
/// <summary>
/// 为Oracle数据库某个表的某个字段添加一个非聚集索引
/// </summary>
/// <param name="indexName"></param>
/// <param name="tableName"></param>
/// <param name="fieldName"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static bool DBOracleAddIndex(string indexName, string tableName, string fieldName, ref string sql)
{
if (OracleCompareTable(tableName) == true)
{
sql = @"CREATE INDEX " + indexName + " ON " + tableName + "(" + fieldName + ")";
return(DBconnectionOracle.ExecuteSql(sql));
}
return(false);
//create index toys_color_i on toys(color);
}
private void FormMainOrcl_FormClosed(object sender, FormClosedEventArgs e)
{
if (justBack == false)
{
if (DbType == "Oracle")
{
DBconnectionOracle.CloseConnect();
}
else if (DbType == "SQLServer")
{
DBconnectionSQLServer.CloseConnect();
}
Application.Exit();
}
}
private void quit_Click(object sender, EventArgs e)
{
if (DbType == "Oracle")
{
DBconnectionOracle.CloseConnect();
}
else if (DbType == "SQLServer")
{
DBconnectionSQLServer.CloseConnect();
}
justBack = true;
FormLogin login = (FormLogin)this.Tag;
login.Show();
this.Close();
}
public static bool OracleCompareTable(string tableName)
{
DataTable dt = DBconnectionOracle.ShowTableList();
foreach (DataRow row in dt.Rows)
{
if (row["table_name"].ToString() != "tempdb")
{
if (tableName == row["table_name"].ToString())
{
return(true);
}
}
}
return(false);
}
/// <summary>
/// 为Oracle数据库中某个表添加一个字段
/// </summary>
/// <param name="tableName"></param>
/// <param name="fieldName"></param>
/// <param name="fieldType"></param>
/// <param name="fieldLength"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static bool DBOracleAddField(string tableName, string fieldName, string fieldType, string fieldLength, ref string sql)
{
if (OracleCompareTable(tableName) == true)
{
if (fieldType != "VARCHAR2")
{
sql = @"ALTER TABLE " + tableName + " ADD " + fieldName + " " + fieldType;
}
else
{
sql = @"ALTER TABLE " + tableName + " ADD " + fieldName + " " + fieldType + "(" + fieldLength + ")";
}
return(DBconnectionOracle.ExecuteSql(sql));
}
return(false);
}
/// <summary>
/// 为Oracle数据库中某个表修改一个字段
/// </summary>
/// <param name="tableName"></param>
/// <param name="fieldName"></param>
/// <param name="fieldType"></param>
/// <param name="fieldLength"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static bool DBOracleModifyField(string tableName, string fieldName, string fieldType, string fieldLength, ref string sql)
{
if (OracleCompareTable(tableName) == true)
{
if (fieldType != "VARCHAR2")
{
//ALTER TABLE tableName modify(columnName 类型);
sql = @"ALTER TABLE " + tableName + " MODIFY(" + fieldName + " " + fieldType + ")";
}
else
{
sql = @"ALTER TABLE " + tableName + " MODIFY(" + fieldName + " " + fieldType + "(" + fieldLength + "))";
}
return(DBconnectionOracle.ExecuteSql(sql));
}
return(false);
}
private void TableView_CurrentCellChanged(object sender, EventArgs e)
{
if (TableView.CurrentCell != null && TableView.CurrentCell.Value != null)
{
DataTable ds = (DbType == "Oracle") ? DBconnectionOracle.ShowTable(TableView.CurrentCell.Value.ToString()):DBconnectionSQLServer.ShowTable(DbName, TableView.CurrentCell.Value.ToString());
try
{
DataView.DataSource = ds;//表从起始行显示在dataGridView里
}
catch (Exception)
{
MessageBox.Show("数据未能正确获得,请重试", "ERROR",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
System.Threading.Thread.CurrentThread.Abort();
//DBView.CurrentCell = DBView.Rows[0].Cells[0];
}
}
}
private void FromXMLExecute_FormClosing(object sender, FormClosingEventArgs e)
{
//Do your stuff here.
TableView.Rows.Clear();
int findIndex = 0;
DataTable dt = (DbType == "Oracle") ? DBconnectionOracle.ShowTableList() : DBconnectionSQLServer.ShowTableList(DbName);
foreach (DataRow row in dt.Rows)
{
int index = TableView.Rows.Add();
TableView.Rows[index].Cells[0].Value = (DbType == "Oracle") ? row["table_name"].ToString() : row["name"].ToString();
string tableName = formxml.tableName;
if (tableName != "")
{
if ((string)TableView.Rows[index].Cells[0].Value == tableName)
{
findIndex = index;
}
}
}
TableView.CurrentCell = TableView.Rows[findIndex].Cells[0];
/*
* if (TableView.CurrentCell != null && TableView.CurrentCell.Value != null)
* {
* DataSet ds = (DbType == "Oracle") ? DBconnectionOracle.ShowTable(TableView.CurrentCell.Value.ToString()) : DBconnectionSQLServer.ShowTable(DbName, TableView.CurrentCell.Value.ToString());
*
* try
* {
* DataView.DataSource = ds.Tables[0].DefaultView;//表从起始行显示在dataGridView里
* }
* catch (Exception)
* {
* MessageBox.Show("数据未能正确获得,请重试", "ERROR",
* MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
* System.Threading.Thread.CurrentThread.Abort();
* //DBView.CurrentCell = DBView.Rows[0].Cells[0];
* }
* }*/
}
public static bool DBOrcaleAddTable(string tableName, List <ParsedInfo> infoLists, ref string sql)
{
if (OracleCompareTable(tableName) == false)
{
sql = @"CREATE TABLE " + tableName + "(";
foreach (ParsedInfo info in infoLists)
{
string value = info.TypeInfo.Values.First().ToString();
if (info.TypeInfo.Keys.First().ToString() != "VARCHAR2")
{
sql = sql + info.Column + " " + info.TypeInfo.Keys.First().ToString() + ",";
}
else
{
sql = sql + info.Column + " " + info.TypeInfo.Keys.First().ToString() + "(" + info.TypeInfo.Values.First().ToString() + ")" + ",";
}
}
sql = sql.Substring(0, sql.Length - 1);
sql += ")";
return(DBconnectionOracle.ExecuteSql(sql));
}
return(false);
}
