/// <summary>
/// Run lynx.store_clr_dlls.
/// </summary>
public void RunClrDll()
{
try
{
Console.WriteLine("Running lynx.store_clr_dlls ...");
OracleAccessor oc = new OracleAccessor();
oc.ConnectToOracle();
oc.Transaction = oc.Connection.BeginTransaction();
OracleProcedureInput pic = new OracleProcedureInput();
pic.numberOfParameters = 0;
pic.procedureName = "lynx.store_clr_dlls";
oc.NonQueryProcedure(pic);
oc.Transaction.Commit();
oc.Connection.Close();
Console.WriteLine("Finished lynx.store_clr_dlls.");
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine("lynx.store_clr_dlls Failed!");
}
}
public MainViewModel(IWindowManager manager)
{
_manager = manager;
_accessor = null;
Connected = false;
QueryTab = new QueryViewModel(_manager, this);
QueryTab.RequireUpdate += UpdateHandler;
Browser = new TableBrowserViewModel(_manager, this);
Browser.RequireUpdate += UpdateHandler;
}
public void LogIn( )
{
try
{
Accessor = new OracleAccessor(DataSource, UserName, Password, Tablespace);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
TryClose( );
}
/// <summary>
/// Test if the xml file is setup correctly for a database connection.
/// </summary>
static void TestDbConnection(string UserId, string Password, string Privilege)
{
Console.WriteLine("Testing Database Connection...");
try
{
OracleAccessor oc = new OracleAccessor();
oc.ConnectToOracle(UserId, Password, Privilege);
oc.Connection.Close();
}
catch
{
}
}
public void LogIn( )
{
AuthorizationViewModel authorization = new AuthorizationViewModel( )
{
DisplayName = "Authorization"
};
_manager.ShowDialog(authorization);
_accessor = authorization.Accessor;
if (_accessor != null)
{
Connected = true;
}
}
public static DbAccessor NewDbAccessor(string connectionString, string providerName)
{
DbAccessor dba = null;
if (string.IsNullOrEmpty(providerName) ||
providerName == "System.Data.SqlClient" ||
providerName.ToLower() == DbProviderName.SqlServer.ToString().ToLower())
{
dba = new SqlServerAccessor(connectionString);
EvnValService.SetDbAccessorDbProviderName(dba, DbProviderName.SqlServer);
}
else if (providerName.ToLower() == DbProviderName.Oracle.ToString().ToLower())
{
dba = new OracleAccessor(connectionString);
EvnValService.SetDbAccessorDbProviderName(dba, DbProviderName.Oracle);
}
else if (providerName.ToLower() == DbProviderName.MySql.ToString().ToLower())
{
dba = new MySqlAccessor(connectionString);
EvnValService.SetDbAccessorDbProviderName(dba, DbProviderName.MySql);
}
else
{
Type tProviderName = Type.GetType(providerName);
if (tProviderName == null)
{
throw new Exception(string.Format("ConnectionString（{0}）的ProviderName（{1}）找不到该类型！", connectionString, providerName));
}
else if (!(tProviderName.IsSubclassOf(typeof(DbAccessor))))
{
throw new Exception(string.Format("ConnectionString（{0}）的ProviderName（{1}）该类型不是DbAccessor的实现类！", connectionString, providerName));
}
object oProviderName = Activator.CreateInstance(tProviderName, connectionString);
dba = oProviderName as DbAccessor;
}
return(dba);
}
public static void Main( )
{
OracleConnectionStringBuilder builder = new OracleConnectionStringBuilder( );
builder.DataSource = @"10.4.0.119";
builder.Password = @"123456";
builder.UserID = @"12201";
builder.PersistSecurityInfo = true;
using (OracleAccessor connector = new OracleAccessor("10.4.0.119", "12201", "123456", "USERS"))
{
using (var dataReader = connector.GetTableInfo("ROGOLEV_GOODS"))
{
//while ( dataReader.Read( ) )
//{
// string str = dataReader.GetString( dataReader.GetOrdinal( "table_name" ) );
// Console.WriteLine( dataReader[0].ToString( ) );
//}
foreach (DbDataRecord row in dataReader)
{
for (int i = 0; i < row.FieldCount; ++i)
{
Console.WriteLine(row.GetValue(i));
}
}
}
}
//using ( OracleConnection connection = new OracleConnection( builder.ToString( ) ) )
//{
// connection.Open( );
// using ( OracleCommand command = connection.CreateCommand( ) )
// {
// command.CommandText = @"select * from all_tables";
// DataTable table = connection.GetSchema( @"foreignKeyColumns" );
// foreach ( DataRow row in table.Rows )
// {
// if ( !row["TABLE_NAME"].ToString( ).Contains( "ROGOLEV" ) )
// continue;
// foreach ( DataColumn column in table.Columns )
// Console.WriteLine( "{0} = {1}", column.ColumnName, row[column] );
// Console.WriteLine( );
// }
// //using ( var dataReader = command.ExecuteReader( ) )
// //{
// // while ( dataReader.Read( ) )
// // {
// // string str = dataReader.GetString( dataReader.GetOrdinal( "table_name" ) );
// // //try
// // //{
// // // str += " " + dataReader.GetString( dataReader.GetOrdinal( "tablespace_name" ) );
// // //}
// // //catch ( InvalidCastException e )
// // //{
// // // str += " null";
// // //}
// // Console.WriteLine( dataReader[0].ToString( ) );
// // }
// //}
// }
//}
// using ( dataReader )
// {
// while ( dataReader.Read( ) )
// {
// string str = dataReader.GetString( dataReader.GetOrdinal( "table_name" ) );
// //try
// //{
// // str += " " + dataReader.GetString( dataReader.GetOrdinal( "tablespace_name" ) );
// //}
// //catch ( InvalidCastException e )
// //{
// // str += " null";
// //}
// Console.WriteLine( dataReader[0].ToString( ) );
// }
// }
//}
Console.ReadKey( );
}
public AuthorizationViewModel( )
{
DataSource = "10.4.0.119";
UserName = "******";
Accessor = null;
}
public void LogOut( )
{
_accessor.Dispose( );
_accessor = null;
Connected = false;
}
