int DevartOracleClient()
{
System.Data.OracleClient.OracleConnectionStringBuilder connBuilder = new System.Data.OracleClient.OracleConnectionStringBuilder();
connBuilder.DataSource = txtDataSource.Text.Trim();
connBuilder.UserID = txtUserId.Text.Trim();
connBuilder.Password = txtPwd.Text.Trim();
int rows = 0;
using (Devart.Data.Oracle.OracleConnection conn = new Devart.Data.Oracle.OracleConnection(connBuilder.ConnectionString))
{
Devart.Data.Oracle.OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = txtSql.Text.Trim();
cmd.CommandTimeout = 300;
conn.Open();
using (Devart.Data.Oracle.OracleDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
object[] objs = new object[500];
dr.GetValues(objs);
rows++;
}
}
return(rows);
}
}
private static void PrepareCommandCurrency(DbCommand cmd, DbConnection conn, DbTransaction trans, CommandType cmdType, string cmdText, ParameterCollection cmdParms)
{
if (conn is System.Data.SqlClient.SqlConnection)
{
System.Data.SqlClient.SqlConnection sqlconn = new System.Data.SqlClient.SqlConnection();
sqlconn.ConnectionString = conn.ConnectionString;
sqlconn.FireInfoMessageEventOnUserErrors = true;
sqlconn.InfoMessage += new System.Data.SqlClient.SqlInfoMessageEventHandler(SqlConnection_InfoMessage);
conn = sqlconn;
}
if (conn is Devart.Data.Oracle.OracleConnection)
{
Devart.Data.Oracle.OracleConnection oraconn = new Devart.Data.Oracle.OracleConnection();
oraconn.ConnectionString = conn.ConnectionString;
oraconn.InfoMessage += new Devart.Data.Oracle.OracleInfoMessageEventHandler(OracleConnection_InfoMessage);
conn = oraconn;
}
if (conn is System.Data.OleDb.OleDbConnection)
{
System.Data.OleDb.OleDbConnection oledbconn = new System.Data.OleDb.OleDbConnection();
oledbconn.ConnectionString = conn.ConnectionString;
oledbconn.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(OleDbConnection_InfoMessage);
conn = null;
conn = oledbconn;
}
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (trans != null)
cmd.Transaction = trans;
cmd.CommandType = cmdType;
cmd.CommandTimeout = Timeout;
//if (cmdParms != null)
//{
// foreach (DbParameter parm in cmdParms)
// if (parm != null)
// cmd.Parameters.Add(parm);
//}
if ((cmdParms != null) && (cmdParms.Count > 0))
{
for (int i = 0; i < cmdParms.Count; i++)
{
cmdParms[i].InitRealParameter();
cmd.Parameters.Add(cmdParms[i].RealParameter as DbParameter);
}
}
}
public static System.Data.Common.DbConnection GetDbConnection(Model.CodeMaker.DbLinkInfo info)
{
System.Data.Common.DbConnection conn = null;
try
{
DataBaseTypeEnum fc = DataBaseType.GetDataBaseType(info.DbType);
string characterSet = ConfigurationManager.AppSettings["CharacterSet"] == null ? "" : ConfigurationManager.AppSettings["CharacterSet"];
switch (fc)
{
case DataBaseTypeEnum.SQLServer:
conn = new System.Data.SqlClient.SqlConnection();
string port = "";
if (!string.IsNullOrEmpty(info.Port))
{
port = "," + info.Port;
}
conn.ConnectionString = "Data Source=" + info.DataSource + port + ";Initial Catalog=" + info.DbName + ";User ID=" + info.UserName + ";Password="******"(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST =" + info.DataSource + ")(PORT =" + info.Port + "))) (CONNECT_DATA = (SERVICE_NAME =" + info.DbName + ")))";
conn.ConnectionString = "Data Source=" + dataSource + ";User ID=" + info.UserName + ";Password="******"";
break;
case DataBaseTypeEnum.Access:
conn = new System.Data.OleDb.OleDbConnection();
string AccessDataSource = info.DataSource;
if (AccessDataSource.IndexOf("CodeMaker.mdb") > 0)
{
AccessDataSource = DBConfig.GetConString("AccessCodeMaker");
}
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AccessDataSource;
break;
case DataBaseTypeEnum.SQLite:
conn = new System.Data.SQLite.SQLiteConnection();
string connstring = @"Data Source=" + info.DataSource + ";Version=3;";
if (info.PassWord.Trim() != "")
{
connstring = connstring + "Password="******"";
//if (!string.IsNullOrEmpty(characterSet))
// charset = ";Charset=" + characterSet;
conn = new MySql.Data.MySqlClient.MySqlConnection();
conn.ConnectionString = "server=" + info.DataSource + ";database=" + info.DbName + ";port=" + info.Port + ";user id=" + info.UserName + ";password="******";Allow Zero Datetime=true" + charset;
//conn.ConnectionString = "Data Source=" + info.DataSource + ";port=" + info.Port+";Initial Catalog=" + info.DbName + ";User ID=" + info.UserName + ";Password="******"server=" + info.DataSource + ";database=" + info.DbName + ";port=" + info.Port + ";user id=" + info.UserName + ";password="******";Allow Zero Datetime=true";
// break;
}
return(conn);
}
catch (Exception ex)
{
//rstmsg = "操作失败。" + ex.Message;
}
return(conn);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tstBtn_Click(object sender, EventArgs e)
{
tstBtn.Enabled = false;
if (rdBtn_devart.Checked)
{
var connectionStringBuilder = new Devart.Data.Oracle.OracleConnectionStringBuilder();
connectionStringBuilder.Direct = true;
connectionStringBuilder.ServiceName = txtBx_serviceName.Text;
connectionStringBuilder.Sid = txtBx_sid.Text;
connectionStringBuilder.Server = txtBx_server.Text;
connectionStringBuilder.Port = Int32.Parse(txtBx_port.Text);
connectionStringBuilder.UserId = txtBx_user.Text;
connectionStringBuilder.Password = txtBx_pass.Text;
var connection = new Devart.Data.Oracle.OracleConnection(connectionStringBuilder.ConnectionString);
if (connection != null)
{
for (int i = 0; i <= Int32.Parse(txtBx_qtd.Text); i++)
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
MessageBox.Show("Conexão estabelecida");
}
Thread.Sleep(5000);
connection.Close();
MessageBox.Show("Conexão encerrada");
Thread.Sleep(3000);
}
}
}
else if (rdBtn_native.Checked)
{
var connectionStringBuilder = new OracleConnectionStringBuilder();
connectionStringBuilder.DataSource = txtBx_sid.Text;
connectionStringBuilder.UserID = txtBx_user.Text;
connectionStringBuilder.Password = txtBx_pass.Text;
var connectionOracleClient = new OracleConnection(connectionStringBuilder.ConnectionString);
if (connectionOracleClient != null)
{
for (int i = 0; i <= Int32.Parse(txtBx_qtd.Text); i++)
{
if (connectionOracleClient.State != ConnectionState.Open)
{
connectionOracleClient.Open();
MessageBox.Show("Conexão estabelecida");
}
Thread.Sleep(5000);
connectionOracleClient.Close();
MessageBox.Show("Conexão encerrada");
Thread.Sleep(3000);
}
}
}
else
{
MessageBox.Show("Selecione uma opção de driver.");
}
tstBtn.Enabled = true;
}
private int GetDbLink(out string DbTime, out string rstmsg)
{
int rst = 0;
DbTime = "";
rstmsg = "";
string connstring = "";
DataTable dt = new DataTable();
string sql = "";
//DbLinkInfo info = GetDbLinkInfo();
//DbConnection conn = DBConfig.GetDbConnection(info);
switch (cob_DbType.Text)
{
case "SQLServer":
string port = "";
if (!string.IsNullOrEmpty(tb_Port.Text))
{
port = "," + tb_Port.Text;
}
connstring = "Data Source=" + tb_DataSource.Text + port + ";Initial Catalog=" + tb_DbName.Text + ";User ID=" + tb_UserName.Text + ";Password="******"select Getdate() as DbTime";
try
{
//DbCommand cmd=new System.Data.SqlClient.SqlCommand();
//DbDataAdapter da =new System.Data.SqlClient.SqlDataAdapter();
DbConnection conn = new System.Data.SqlClient.SqlConnection();
conn.ConnectionString = connstring;
dt = DbHelper.ExecuteTableCurrency(conn, CommandType.Text, sql, null);
DbTime = dt.Rows[0]["DbTime"].ToString();
if (DbTime.Length > 6)
{
rst = 1;
}
}
catch (Exception ex)
{
rst = -1;
rstmsg = ex.Message;
}
break;
case "Oracle":
string dataSource = "(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST =" + tb_DataSource.Text.Trim() + ")(PORT =" + tb_Port.Text.Trim() + "))) (CONNECT_DATA = (SERVICE_NAME =" + tb_DbName.Text + ")))";
connstring = "Data Source=" + dataSource + ";User ID=" + tb_UserName.Text + ";Password="******"";
sql = "select sysdate DbTime from dual";
try
{
//DbCommand cmd = new Devart.Data.Oracle.OracleCommand();
//DbDataAdapter da = new Devart.Data.Oracle.OracleDataAdapter();
DbConnection conn = new Devart.Data.Oracle.OracleConnection();
conn.ConnectionString = connstring;
dt = DbHelper.ExecuteTableCurrency(conn, CommandType.Text, sql, null);
DbTime = dt.Rows[0]["DbTime"].ToString();
if (DbTime.Length > 6)
{
rst = 1;
}
}
catch (Exception ex)
{
rst = -1;
rstmsg = ex.Message;
}
break;
case "Access":
connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + tb_DataSource.Text + ";Persist Security Info=True;";
sql = "select now() as DbTime";
try
{
//DbCommand cmd = new System.Data.OleDb.OleDbCommand();
//DbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter();
DbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = connstring;
dt = DbHelper.ExecuteTableCurrency(conn, CommandType.Text, sql, null);
DbTime = dt.Rows[0]["DbTime"].ToString();
if (DbTime.Length > 6)
{
rst = 1;
}
}
catch (Exception ex)
{
rst = -1;
rstmsg = ex.Message;
}
break;
case "SQLite":
connstring = @"Data Source=" + tb_DataSource.Text + ";Version=3;";
connstring = connstring + "FailIfMissing=false;";
if (tb_Password.Text.Trim() != "")
{
connstring = connstring + "Password="******"select DATETIME('now') as DbTime";
try
{
DbConnection conn = new System.Data.SQLite.SQLiteConnection();
conn.ConnectionString = connstring;
dt = DbHelper.ExecuteTableCurrency(conn, CommandType.Text, sql, null);
DbTime = dt.Rows[0]["DbTime"].ToString();
if (DbTime.Length > 6)
{
rst = 1;
}
}
catch (Exception ex)
{
rst = -1;
rstmsg = ex.Message;
}
break;
case "MySql":
//connstring = "data source=" + tb_DataSource.Text + ";database=" + tb_DbName.Text + ";uid=" + tb_UserName.Text + ";pwd=" + tb_Password.Text + ";";
connstring = "server=" + tb_DataSource.Text + ";database=" + tb_DbName.Text + ";port=" + tb_Port.Text + ";user id=" + tb_UserName.Text + ";password="******";Charset=" + txt_Charset.Text; //";CharSet=gbk;Allow Zero Datetime=true";
//connstring = "Data Source=" + tb_DataSource.Text + ";port=" + tb_Port.Text + ";Initial Catalog=" + tb_DbName.Text + ";user id=" + tb_UserName.Text + ";password="******";Charset=" + txt_Charset.Text;
sql = "select now() DbTime;";
try
{
DbConnection conn = new MySql.Data.MySqlClient.MySqlConnection();
conn.ConnectionString = connstring;
dt = DbHelper.ExecuteTableCurrency(conn, CommandType.Text, sql, null);
DbTime = dt.Rows[0]["DbTime"].ToString();
if (DbTime.Length > 6)
{
rst = 1;
}
}
catch (Exception ex)
{
rst = -1;
rstmsg = ex.Message;
}
break;
}
return(rst);
}
