public void ResetConfiguration()
{
OracleDb.Reset();
PostgresDb.Reset();
oldDslCompiler = DslCompiler;
Targets.Reset(DslCompiler);
}
private void ButtonGeneratePlSql_Click(object sender, EventArgs e)
{
try
{
var sel = ComboTableForProcedureGenerate.SelectedItem;
if (string.IsNullOrEmpty(sel?.ToString()))
{
return;
}
var selectedItem = sel.ToString();
var list = OracleDb.ListColumns(selectedItem);
if (list == null)
{
ActionException(new Exception("Column list is null!"));
return;
}
var result = Utils.GeneratePlSqlProcedure(selectedItem, list);
txtPlSql.Text = result;
}
catch (Exception exp)
{
ActionException(exp);
}
}
private void ButtonGenerateView_Click(object sender, EventArgs e)
{
try
{
var sel = ComboView.SelectedItem;
if (string.IsNullOrEmpty(sel?.ToString()))
{
return;
}
var selectedItem = sel.ToString();
var list = OracleDb.ListColumns(selectedItem);
if (list == null)
{
ActionException(new Exception("Column list is null!"));
return;
}
var className = selectedItem.ToUpperCamelCase(true);
// Gen class
txtClass.Text = Utils.GenerateClassData(className, list);
var funcData = Utils.GenerateViewFunction(className, list, selectedItem);
txtViewFunction.Text = funcData;
_Settings.Ui.ComboView = selectedItem;
_Settings.Save();
}
catch (Exception exp)
{
ActionException(exp);
}
}
private void UpdateProcCombo()
{
ComboProcedureList.Items.Clear();
// ReSharper disable CoVariantArrayConversion
var ownerName = _Settings.DbConfig.Username.ToUpperInvariant();
ComboProcedureList.Items.AddRange(OracleDb.ListPackages(ownerName).ToArray());
ComboProcedureList.Items.AddRange(OracleDb.ListProcedures(ownerName).ToArray());
// ReSharper restore CoVariantArrayConversion
ComboProcedureList.DisplayMember = "Value";
ComboProcedureList.ValueMember = "Id";
var i = 0;
foreach (ComboboxItem item in ComboProcedureList.Items)
{
if (item.Id == _Settings.Ui.ComboView)
{
ComboProcedureList.SelectedIndex = i;
break;
}
i++;
}
}
private void InitOracleDatabase()
{
//初始化数据库
using (var database = new OracleDb()) //新增
{
database.Database.EnsureDeleted();
database.Database.EnsureCreated();
}
var services = new ServiceCollection();
services.AddSummerBoot();
var connectionString = MyConfiguration.GetConfiguration("oracleDbConnectionString");
if (string.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentNullException("oracle connectionString must not be null");
}
services.AddSummerBootRepository(it =>
{
it.DbConnectionType = typeof(OracleConnection);
it.ConnectionString = connectionString;
});
serviceProvider = services.BuildServiceProvider();
serviceProvider = serviceProvider.CreateScope().ServiceProvider;
}
// Reference: https://stackoverflow.com/questions/27551249/how-to-use-a-oracle-database-in-asp-net-without-entity-framework
internal static DataTable GetPlantItemsFromDatabase(ItemType item)
{
// Get Connection String to DB
var connectionString = "user id = system; password = Oracle01; Data source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = RJDELL)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = SPPIDORCL)))";
// Build Query (PlantItem - (4):PipeRun Type)
var sqlQuery = $"select * from SPPIDPLANTPID.t_plantitem pl where pl.plantitemtype = {(int)item} and rownum < 100";
// Get Data
OracleDb oracleDb = new OracleDb();
DataTable dataTable = new DataTable();
dataTable = oracleDb.LoadData(connectionString, sqlQuery);
return(dataTable);
}
private void Connect()
{
Cursor = Cursors.WaitCursor;
try
{
OracleDb.Init(txtHostname.Text,
txtUsername.Text,
txtPassword.Text,
txtServiceName.Text,
txtPort.Text
);
if (OracleDb.CheckConnection())
{
_Settings.DbConfig.HostName = txtHostname.Text;
_Settings.DbConfig.ServiceName = txtServiceName.Text;
_Settings.DbConfig.Password = txtPassword.Text;
_Settings.DbConfig.Port = Convert.ToInt32(txtPort.Text);
_Settings.DbConfig.Username = txtUsername.Text;
_Settings.Save();
UpdateProcCombo();
UpdateTableCombo();
UpdateViewCombo();
MessageBoxEx.Show(
this,
@"Success!",
@"Info",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
else
{
throw new Exception("Invalid data provided!");
}
}
catch (Exception exp)
{
ActionException(exp);
}
Cursor = Cursors.Default;
}
private void UpdateTableCombo()
{
ComboTableForProcedureGenerate.Items.Clear();
// ReSharper disable once CoVariantArrayConversion
ComboTableForProcedureGenerate.Items.AddRange(OracleDb.ListTables().ToArray());
ComboTableForProcedureGenerate.DisplayMember = "Value";
ComboTableForProcedureGenerate.ValueMember = "Id";
var i = 0;
foreach (ComboboxItem item in ComboTableForProcedureGenerate.Items)
{
if (item.Id == _Settings.Ui.ComboView)
{
ComboTableForProcedureGenerate.SelectedIndex = i;
break;
}
i++;
}
}
