/// <summary>
/// 创建并且打开数据库连接
/// </summary>
/// <returns>数据库连接</returns>
protected override IDbConnection GetConnection()
{
IDbConnection conn = base.GetConnection();
if (conn == null)
{
conn = new DmConnection(base.ConnectionString);
//conn.Open ();
}
return(conn);
}
public void CheckServerTime(Object state)
{
if (mForm.m_stopTest || bCheckRun)
{
return;
}
bCheckRun = true;
try //测试服务器是否还有效
{
#if DM7
DmConnection m_cn = new DmConnection(conStr);
#else
OleDbConnection m_cn = new OleDbConnection(conStr);
#endif
try
{
m_cn.Open();
m_cn.Close();
bCheckRun = false;
return;
}
catch (Exception e)
{
string str = e.Message;
}
try
{
m_cn.Open();
m_cn.Close();
bCheckRun = false;
return;
}
catch (Exception e)
{
string str = e.Message;
}
m_cn.Open();
m_cn.Close();
}
catch (Exception e)
{
if (bAutoRestartServer)
{
StartServer(null);
}
else
{
mForm.AddToTextBoxFail("连接服务器失败，自动测试被停止!\n" + e.Message, -1);
mForm.m_stopTest = true;
}
}
bCheckRun = false;
}
/// <summary>
/// 测试数据库是否正常连接
/// </summary>
public override bool TestConnection(string connectionString)
{
bool result = false;
using (DbConnection connection = new DmConnection(connectionString))
{
connection.Open();
if (connection.State == System.Data.ConnectionState.Open)
{
result = true;
}
}
return(result);
}
//public string ImportTestResult(DmDataReader dr)
public string ImportTestResult(OleDbDataReader dr)
{
//OleDbConnection m_cn = null;
DmConnection m_cn = null;
try //测试服务器是否还有效
{
m_cn = new DmConnection(conStr);
try
{
m_cn.Open();
}
catch (Exception e)
{
return(e.Message);
}
//OleDbCommand m_cm = m_cn.CreateCommand();
DmCommand m_cm = m_cn.CreateCommand();
try
{
m_cm.CommandText = "DROP TABLE TEST_RESULT";
m_cm.ExecuteNonQuery();
}
catch
{
}
m_cm.CommandText = "CREATE TABLE TEST_RESULT(ID INT IDENTITY(1,1) PRIMARY KEY, [NAME] VARCHAR(200), [PATH] VARCHAR(300), TEST_TIME DATETIME, IS_SUCCESS CHAR(1))";
m_cm.ExecuteNonQuery();
m_cm.CommandText = "CREATE INDEX I_TEST_RESULT ON TEST_RESULT([NAME], [PATH])";
m_cm.ExecuteNonQuery();
while (dr.Read())
{
string sql = "INSERT INTO TEST_RESULT(NAME, PATH, TEST_TIME, IS_SUCCESS) VALUES('";
sql += dr[0].ToString() + "','" + dr[1].ToString() + "','" + Convert.ToString(dr[2]) + "','" + dr[3].ToString() + "')";
m_cm.CommandText = sql;
m_cm.ExecuteNonQuery();
}
}
catch (Exception e)
{
m_cn.Close();
return(e.Message);
}
m_cn.Close();
return(null);
}
public void WaitServerStart()
{
int i = 100;
while (i-- > 0)
{
Thread.Sleep(3000);
try //测试服务器是否还有效
{
#if DM7
DmConnection m_cn = new DmConnection(conStr);
#else
OleDbConnection m_cn = new OleDbConnection(conStr);
#endif
m_cn.Open();
m_cn.Close();
return;
}
catch (Exception e)
{
string m_string = e.Message;
}
}
}
/// <summary>
/// SqlDataAdapter
/// </summary>
/// <param name="sql"></param>
/// <param name="_sqlConnection"></param>
public MyDmDataAdapter(string sql, DmConnection _sqlConnection)
{
this.sql = sql;
this._sqlConnection = _sqlConnection;
}
public void Open()
{
conn = new DmConnection();
conn.ConnectionString = ConnectionString;
conn.Open();
}
