private static OracleCommand getNewCommand(string funcName)
{
OracleCommand com = new OracleCommand();
var connection = DBSingleton.GetConnection();
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
com.Connection = connection;
com.CommandType = System.Data.CommandType.StoredProcedure;
com.CommandText = funcName;
return(com);
}
public static DataTable TrySelectSql(string TrySql)
{
try
{
OracleDataAdapter dataAdapter = new OracleDataAdapter();
dataAdapter.SelectCommand = new OracleCommand()
{
Connection = DBSingleton.GetConnection(),
CommandText = TrySql
};
DataTable dt = new DataTable();
dataAdapter.Fill(dt);
return(dt);
}
catch (Exception e)
{
return(null);
}
}
public static DataTable SelectSql(string sql)
{
try
{
OracleDataAdapter dataAdapter = new OracleDataAdapter();
dataAdapter.SelectCommand = new OracleCommand()
{
Connection = DBSingleton.GetConnection(),
CommandText = sql
};
DataTable dt = new DataTable();
dataAdapter.Fill(dt);
return(dt);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "SQL Error!");
return(null);
}
}
