//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 Close()
{
if (conn == null)
{
return;
}
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
static void Main(string[] args)
{
try
{
cnn.ConnectionString = "Server=localhost; User Id=SYSDBA; PWD=SYSDBA";
cnn.Open();
Program program = new Program();
program.TestFunc();
cnn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
