private DbCommand createCommand(string sqlstmt)
{
DbCommand ocmd = null;
switch (m_databaseEngine)
{
case csDatabaseEngine.SQL_SERVER:
ocmd = new SqlCommand(sqlstmt, m_ocn as SqlConnection);
break;
case csDatabaseEngine.POSTGRESQL:
throw new NotImplementedException();
case csDatabaseEngine.ORACLE:
ocmd = new OracleCommand(sqlstmt, m_ocn as OracleConnection);
break;
case csDatabaseEngine.CSREPORT_WEB:
ocmd = new cJSONCommand(sqlstmt, m_ocn as cJSONServerConnection);
break;
}
if(ocmd == null)
throw new Exception("The database engine is not supported " + m_databaseEngine.ToString());
ocmd.CommandTimeout = m_commandTimeout;
ocmd.CommandType = CommandType.Text;
return ocmd;
}