public void TestFunc()
{
DmCommand command = new DmCommand();
command.Connection = cnn;
try
{
string a, b, c;
command.CommandText = "select * from Production.Product;";
var reader = command.ExecuteReader();
while (reader.Read())
{
a = reader.GetString(0);
b = reader.GetString(1);
c = reader.GetString(2);
Console.WriteLine("Name：" + a);
Console.WriteLine("Author: " + b);
Console.WriteLine("Publisher: " + c);
Console.WriteLine("-----------------------------");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
ret = 0;
}
}
//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 override DbCommand GetCommand(string sql, SugarParameter[] parameters)
{
DmCommand sqlCommand = new DmCommand(sql, (DmConnection)this.Connection);
sqlCommand.CommandType = this.CommandType;
sqlCommand.CommandTimeout = this.CommandTimeOut;
if (this.Transaction != null)
{
sqlCommand.Transaction = (DmTransaction)this.Transaction;
}
if (parameters.HasValue())
{
IDataParameter[] ipars = ToIDbDataParameter(parameters);
sqlCommand.Parameters.AddRange((DmParameter[])ipars);
}
CheckConnection();
return(sqlCommand);
}
/// <summary>
/// SqlDataAdapter
/// </summary>
/// <param name="command"></param>
public MyDmDataAdapter(DmCommand command)
{
this.command = command;
}
