public void RefreshTypes()
{
cbTypes.Items.Clear();
DBTypeList dbList = new DBTypeList();
foreach (DBDataTypes dt in dbList.Values)
{
cbTypes.Items.Add(dt);
}
}
/// <summary>
/// MSSql, MySql, Access, Oracle, HttpPost, SQLite
/// </summary>
public static string GetDBType(DBTypeList DBType)
{
switch (DBType)
{
case DBTypeList.MSSql: return "MSSql";
case DBTypeList.MySql: return "MySql";
case DBTypeList.Oracle: return "Oracle";
case DBTypeList.Access: return "Access";
case DBTypeList.HttpPost: return "HttpPost";
case DBTypeList.SQLite: return "SQLite";
default: return "";
}
}
public void FillCombos()
{
var domains = StaticTreeClass.Instance().GetDomainObjects(_dbReg);
cbDOMAIN.Items.Clear();
foreach (DomainClass domain in domains.Values)
{
cbDOMAIN.Items.Add(domain);
}
cbDOMAIN.Text = "";
cbFieldTypes.Items.Clear();
DBTypeList dbList = new DBTypeList();
foreach (DBDataTypes dt in dbList.Values)
{
cbFieldTypes.Items.Add(dt);
}
}
public FunctionForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, TreeNode tn, ContextMenuStrip cm, StateClasses.EditStateClass.eBearbeiten mode)
{
InitializeComponent();
this.MdiParent = parent;
Cm = cm;
Tn = tn;
_tables = tables;
try
{
BearbeitenMode = mode;
if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert)
{
FunctionObject = new FunctionClass();
FunctionObject.Name = "NEW_FUNCTION";
}
else
{
FunctionObject = (FunctionClass)tn.Tag;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
OldFunctionObject = (FunctionClass)FunctionObject.Clone();
_dbReg = dbReg;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
cbDatatype.Items.Clear();
DBTypeList dbList = new DBTypeList();
foreach (DBDataTypes dt in dbList.Values)
{
cbDatatype.Items.Add(dt);
}
DoEvents = true;
}
public ProcedureForm(Form parent, DBRegistrationClass dbReg, TreeNode tn, ContextMenuStrip cm, StateClasses.EditStateClass.eBearbeiten mode)
{
InitializeComponent();
this.MdiParent = parent;
_tn = tn;
_cm = cm;
try
{
BearbeitenMode = mode;
if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert)
{
_procedureObject = new ProcedureClass();
_procedureObject.Name = "NEW_PROCEDURE";
}
else
{
_procedureObject = (ProcedureClass)tn.Tag;
}
}
catch
{
}
_procedureObjectOld = (ProcedureClass)_procedureObject.Clone();
_dbReg = dbReg;
_localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler;
_localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler;
cbDatatype.Items.Clear();
DBTypeList dbList = new DBTypeList();
foreach (DBDataTypes dt in dbList.Values)
{
cbDatatype.Items.Add(dt);
}
_doEvents = true;
}