public Select_DataBase_Form(Form pParentForm,Log_DBConnection my_connection, string sTitle) { m_ParentForm = pParentForm; m_Title = sTitle; m_SQL_Connection = my_connection; InitializeComponent(); }
public WriteLog2DB_Form(Log_DBConnection xm_LogDB_con, string xUserName, string xDescription) { InitializeComponent(); m_LogDB_con = xm_LogDB_con; Log_PathFile = LogFile.LogFolder + LogFile.LogFileName; m_UserName = xUserName; m_Description = xDescription; }
public TestConnectionForm(Form xParentForm,Log_DBConnection sqlCon, bool bTimerClose, bool bDataBaseConnection,string sTitle) { m_ParentForm = xParentForm; this.Owner = m_ParentForm; m_bDataBaseConnection = bDataBaseConnection; m_Title = sTitle; m_bTimerClose = bTimerClose; sqlConn = sqlCon; InitializeComponent(); m_eStartPositionOfTestConnectionForm = sqlCon.StartPositionOfTestConnectionForm; }
public CreateDataBase_Form(ref Log_DBConnection con) { // // Required for Windows Form Designer support // InitializeComponent(); m_con = con; // // TODO: Add any constructor code after InitializeComponent call // }
public Log(Log_DBConnection xcon) { select = new selection(this); where = new WHERE(this); m_con = xcon; tablename = Log.tablename_const; myUpdateObjects = UpdateObjects; o_id.col_name = Log.id.name; o_id.col_type.m_Type = "int"; o_id.col_type.bPRIMARY_KEY = true; o_id.col_type.bFOREIGN_KEY = false; o_id.col_type.bUNIQUE = false; o_id.col_type.bNULL = false; Add(o_id); o_LogFile_id.col_name = Log.LogFile_id.name; o_LogFile_id.col_type.m_Type = "int"; o_LogFile_id.col_type.bPRIMARY_KEY = false; o_LogFile_id.col_type.bFOREIGN_KEY = true; o_LogFile_id.col_type.bUNIQUE = false; o_LogFile_id.col_type.bNULL = false; Add(o_LogFile_id); o_LogTime.col_name = Log.LogTime.name; o_LogTime.col_type.m_Type = "datetime"; o_LogTime.col_type.bPRIMARY_KEY = false; o_LogTime.col_type.bFOREIGN_KEY = false; o_LogTime.col_type.bUNIQUE = false; o_LogTime.col_type.bNULL = false; Add(o_LogTime); o_Log_Type_id.col_name = Log.Log_Type_id.name; o_Log_Type_id.col_type.m_Type = "int"; o_Log_Type_id.col_type.bPRIMARY_KEY = false; o_Log_Type_id.col_type.bFOREIGN_KEY = true; o_Log_Type_id.col_type.bUNIQUE = false; o_Log_Type_id.col_type.bNULL = false; Add(o_Log_Type_id); o_Log_Description_id.col_name = Log.Log_Description_id.name; o_Log_Description_id.col_type.m_Type = "int"; o_Log_Description_id.col_type.bPRIMARY_KEY = false; o_Log_Description_id.col_type.bFOREIGN_KEY = true; o_Log_Description_id.col_type.bUNIQUE = false; o_Log_Description_id.col_type.bNULL = false; Add(o_Log_Description_id); }
public ConnectionDialog(Form parentForm, ConnectionDialog_enum ConnectionConnectionDialog_type, Log_DBConnection con, string sTitle) { m_Title = sTitle; my_ConnectionDialog_enum = ConnectionConnectionDialog_type; m_ParentForm = parentForm; InitializeComponent(); this.cmb_ServerName.RecentItemsFolder = con.RecentItemsFolder; this.cmb_DataBaseName.RecentItemsFolder = con.RecentItemsFolder; this.cmb_UserName.RecentItemsFolder = con.RecentItemsFolder; Y[0] = cmb_DataBaseName.Top; Y[1] = rdb_UseWindowsAuthentication.Top; Y[2] = rdb_SQL_Server_Authentication.Top; Y[3] = cmb_UserName.Top; Y[4] = txt_Password.Top; m_con = con; switch (m_con.DBType) { case Log_DBConnection.eDBType.MYSQL: rdb_UseWindowsAuthentication.Enabled = false; rdb_SQL_Server_Authentication.Enabled = false; this.radioButton_MicrosoftSQL.Checked = false; this.radioButton_MySqlServer.Checked = true; break; case Log_DBConnection.eDBType.MSSQL: this.radioButton_MicrosoftSQL.Checked = true; rdb_UseWindowsAuthentication.Enabled = true; rdb_SQL_Server_Authentication.Enabled = true; if (m_con.WindowsAuthentication) { rdb_UseWindowsAuthentication.Checked = true; } else { rdb_SQL_Server_Authentication.Checked = true; } break; } }
public Connection_Control(Log_DBConnection con) { InitializeComponent(); m_con = con; this.lbl_DataSourceAndDatabase.AutoSize = true; switch (m_con.DBType) { case Log_DBConnection.eDBType.SQLITE: this.lbl_ServerType.Text = m_con.ConnectionName+":" + lngConn.s_ServerType.s + " = SQLITE"; this.lbl_DataSourceAndDatabase.Text = m_con.DataBase; break; case Log_DBConnection.eDBType.MSSQL: this.lbl_ServerType.Text = m_con.ConnectionName + ":" + lngConn.s_ServerType.s + " = MSSQL"; this.lbl_DataSourceAndDatabase.Text = lngConn.s_Server.s + " = " + m_con.DataSource + ", " + lngConn.s_DataBase.s + " = " + m_con.DataBase; break; case Log_DBConnection.eDBType.MYSQL: this.lbl_ServerType.Text = m_con.ConnectionName + ":" + lngConn.s_ServerType.s + " = MYSQL"; this.lbl_DataSourceAndDatabase.Text = lngConn.s_Server.s + " = " + m_con.DataSource + ", " + lngConn.s_DataBase.s + " = " + m_con.DataBase; break; } this.Width = this.lbl_DataSourceAndDatabase.Left + this.lbl_DataSourceAndDatabase.Width + 10; }
public LogFile_DataSet_ScalarFunctions(Log_DBConnection xcon) { m_con = xcon; }
public LogFile_DataSet_Procedures(Log_DBConnection xcon) { m_con = xcon; }
public LogFile_Attachment_VIEW(Log_DBConnection xcon) { select = new selection(this); where = new WHERE(this); m_con = xcon; tablename = LogFile_Attachment_VIEW.tablename_const; myUpdateObjects = UpdateObjects; o_id.col_name = LogFile_Attachment_VIEW.id.name; o_id.col_type.m_Type = "int"; Add(o_id); o_LogFile_id.col_name = LogFile_Attachment_VIEW.LogFile_id.name; o_LogFile_id.col_type.m_Type = "int"; Add(o_LogFile_id); o_Attachment.col_name = LogFile_Attachment_VIEW.Attachment.name; o_Attachment.col_type.m_Type = "varbinary"; Add(o_Attachment); o_Attachment_type.col_name = LogFile_Attachment_VIEW.Attachment_type.name; o_Attachment_type.col_type.m_Type = "nvarchar"; Add(o_Attachment_type); o_LogFile_Attachment_Type_id.col_name = LogFile_Attachment_VIEW.LogFile_Attachment_Type_id.name; o_LogFile_Attachment_Type_id.col_type.m_Type = "int"; Add(o_LogFile_Attachment_Type_id); }
public LogFile_Attachment(Log_DBConnection xcon) { select = new selection(this); where = new WHERE(this); m_con = xcon; tablename = LogFile_Attachment.tablename_const; myUpdateObjects = UpdateObjects; o_id.col_name = LogFile_Attachment.id.name; o_id.col_type.m_Type = "int"; o_id.col_type.bPRIMARY_KEY = true; o_id.col_type.bFOREIGN_KEY = false; o_id.col_type.bUNIQUE = false; o_id.col_type.bNULL = false; Add(o_id); o_LogFile_id.col_name = LogFile_Attachment.LogFile_id.name; o_LogFile_id.col_type.m_Type = "int"; o_LogFile_id.col_type.bPRIMARY_KEY = false; o_LogFile_id.col_type.bFOREIGN_KEY = true; o_LogFile_id.col_type.bUNIQUE = false; o_LogFile_id.col_type.bNULL = false; Add(o_LogFile_id); o_LogFile_Attachment_Type_id.col_name = LogFile_Attachment.LogFile_Attachment_Type_id.name; o_LogFile_Attachment_Type_id.col_type.m_Type = "int"; o_LogFile_Attachment_Type_id.col_type.bPRIMARY_KEY = false; o_LogFile_Attachment_Type_id.col_type.bFOREIGN_KEY = true; o_LogFile_Attachment_Type_id.col_type.bUNIQUE = false; o_LogFile_Attachment_Type_id.col_type.bNULL = false; Add(o_LogFile_Attachment_Type_id); o_Attachment.col_name = LogFile_Attachment.Attachment.name; o_Attachment.col_type.m_Type = "varbinary"; o_Attachment.col_type.bPRIMARY_KEY = false; o_Attachment.col_type.bFOREIGN_KEY = false; o_Attachment.col_type.bUNIQUE = false; o_Attachment.col_type.bNULL = true; Add(o_Attachment); o_Description.col_name = LogFile_Attachment.Description.name; o_Description.col_type.m_Type = "nvarchar"; o_Description.col_type.bPRIMARY_KEY = false; o_Description.col_type.bFOREIGN_KEY = false; o_Description.col_type.bUNIQUE = false; o_Description.col_type.bNULL = true; Add(o_Description); }
private static bool CheckTables(Log_DBConnection m_LogDB_con) { string Err = null; LogFile_DataSet.Log_VIEW m_Log_VIEW = new LogFile_DataSet.Log_VIEW(m_LogDB_con); m_Log_VIEW.Clear(); m_Log_VIEW.select.all(true); if (m_Log_VIEW.Read(2, ref Err)) { return true; } else { return false; } }
public sysdiagrams(Log_DBConnection xcon) { select = new selection(this); where = new WHERE(this); m_con = xcon; tablename = sysdiagrams.tablename_const; myUpdateObjects = UpdateObjects; o_name.col_name = sysdiagrams.name__.name; o_name.col_type.m_Type = "nvarchar"; o_name.col_type.bPRIMARY_KEY = false; o_name.col_type.bFOREIGN_KEY = false; o_name.col_type.bUNIQUE = true; o_name.col_type.bNULL = false; Add(o_name); o_principal_id.col_name = sysdiagrams.principal_id.name; o_principal_id.col_type.m_Type = "int"; o_principal_id.col_type.bPRIMARY_KEY = false; o_principal_id.col_type.bFOREIGN_KEY = false; o_principal_id.col_type.bUNIQUE = true; o_principal_id.col_type.bNULL = false; Add(o_principal_id); o_diagram_id.col_name = sysdiagrams.diagram_id.name; o_diagram_id.col_type.m_Type = "int"; o_diagram_id.col_type.bPRIMARY_KEY = true; o_diagram_id.col_type.bFOREIGN_KEY = false; o_diagram_id.col_type.bUNIQUE = false; o_diagram_id.col_type.bNULL = false; Add(o_diagram_id); o_version.col_name = sysdiagrams.version.name; o_version.col_type.m_Type = "int"; o_version.col_type.bPRIMARY_KEY = false; o_version.col_type.bFOREIGN_KEY = false; o_version.col_type.bUNIQUE = false; o_version.col_type.bNULL = true; Add(o_version); o_definition.col_name = sysdiagrams.definition.name; o_definition.col_type.m_Type = "varbinary"; o_definition.col_type.bPRIMARY_KEY = false; o_definition.col_type.bFOREIGN_KEY = false; o_definition.col_type.bUNIQUE = false; o_definition.col_type.bNULL = true; Add(o_definition); }
public Log_VIEW(Log_DBConnection xcon) { select = new selection(this); where = new WHERE(this); m_con = xcon; tablename = Log_VIEW.tablename_const; myUpdateObjects = UpdateObjects; o_LogFile_id.col_name = Log_VIEW.LogFile_id.name; o_LogFile_id.col_type.m_Type = "int"; Add(o_LogFile_id); o_Log_Time.col_name = Log_VIEW.Log_Time.name; o_Log_Time.col_type.m_Type = "datetime"; Add(o_Log_Time); o_Log_TypeName.col_name = Log_VIEW.Log_TypeName.name; o_Log_TypeName.col_type.m_Type = "nvarchar"; Add(o_Log_TypeName); o_Log_Type_id.col_name = Log_VIEW.Log_Type_id.name; o_Log_Type_id.col_type.m_Type = "int"; Add(o_Log_Type_id); o_Log_Description.col_name = Log_VIEW.Log_Description.name; o_Log_Description.col_type.m_Type = "nvarchar"; Add(o_Log_Description); o_Log_Description_id.col_name = Log_VIEW.Log_Description_id.name; o_Log_Description_id.col_type.m_Type = "int"; Add(o_Log_Description_id); o_ComputerName.col_name = Log_VIEW.ComputerName.name; o_ComputerName.col_type.m_Type = "nvarchar"; Add(o_ComputerName); o_Log_Computer_id.col_name = Log_VIEW.Log_Computer_id.name; o_Log_Computer_id.col_type.m_Type = "int"; Add(o_Log_Computer_id); o_UserName.col_name = Log_VIEW.UserName.name; o_UserName.col_type.m_Type = "nvarchar"; Add(o_UserName); o_Log_UserName_id.col_name = Log_VIEW.Log_UserName_id.name; o_Log_UserName_id.col_type.m_Type = "int"; Add(o_Log_UserName_id); o_Program.col_name = Log_VIEW.Program.name; o_Program.col_type.m_Type = "nvarchar"; Add(o_Program); o_Log_Program_id.col_name = Log_VIEW.Log_Program_id.name; o_Log_Program_id.col_type.m_Type = "int"; Add(o_Log_Program_id); o_LogFile_Description.col_name = Log_VIEW.LogFile_Description.name; o_LogFile_Description.col_type.m_Type = "nvarchar"; Add(o_LogFile_Description); o_LogFile_Description_id.col_name = Log_VIEW.LogFile_Description_id.name; o_LogFile_Description_id.col_type.m_Type = "int"; Add(o_LogFile_Description_id); }
public View_AccessR_Form(Log_DBConnection con) { m_con = con; InitializeComponent(); }
public Log_UserName(Log_DBConnection xcon) { select = new selection(this); where = new WHERE(this); m_con = xcon; tablename = Log_UserName.tablename_const; myUpdateObjects = UpdateObjects; o_id.col_name = Log_UserName.id.name; o_id.col_type.m_Type = "int"; o_id.col_type.bPRIMARY_KEY = true; o_id.col_type.bFOREIGN_KEY = false; o_id.col_type.bUNIQUE = false; o_id.col_type.bNULL = false; Add(o_id); o_UserName.col_name = Log_UserName.UserName.name; o_UserName.col_type.m_Type = "nvarchar"; o_UserName.col_type.bPRIMARY_KEY = false; o_UserName.col_type.bFOREIGN_KEY = false; o_UserName.col_type.bUNIQUE = false; o_UserName.col_type.bNULL = false; Add(o_UserName); }
public CheckConnectionThreadParam(Log_DBConnection xConn, bool bDataBaseConnection) { m_bDataBaseConnection = bDataBaseConnection; m_Conn = xConn; }
public LogFile(Log_DBConnection xcon) { select = new selection(this); where = new WHERE(this); m_con = xcon; tablename = LogFile.tablename_const; myUpdateObjects = UpdateObjects; o_id.col_name = LogFile.id.name; o_id.col_type.m_Type = "int"; o_id.col_type.bPRIMARY_KEY = true; o_id.col_type.bFOREIGN_KEY = false; o_id.col_type.bUNIQUE = false; o_id.col_type.bNULL = false; Add(o_id); o_LogFileImportTime.col_name = LogFile.LogFileImportTime.name; o_LogFileImportTime.col_type.m_Type = "datetime"; o_LogFileImportTime.col_type.bPRIMARY_KEY = false; o_LogFileImportTime.col_type.bFOREIGN_KEY = false; o_LogFileImportTime.col_type.bUNIQUE = false; o_LogFileImportTime.col_type.bNULL = false; Add(o_LogFileImportTime); o_Log_Computer_id.col_name = LogFile.Log_Computer_id.name; o_Log_Computer_id.col_type.m_Type = "int"; o_Log_Computer_id.col_type.bPRIMARY_KEY = false; o_Log_Computer_id.col_type.bFOREIGN_KEY = true; o_Log_Computer_id.col_type.bUNIQUE = false; o_Log_Computer_id.col_type.bNULL = false; Add(o_Log_Computer_id); o_Log_UserName_id.col_name = LogFile.Log_UserName_id.name; o_Log_UserName_id.col_type.m_Type = "int"; o_Log_UserName_id.col_type.bPRIMARY_KEY = false; o_Log_UserName_id.col_type.bFOREIGN_KEY = true; o_Log_UserName_id.col_type.bUNIQUE = false; o_Log_UserName_id.col_type.bNULL = true; Add(o_Log_UserName_id); o_Log_Program_id.col_name = LogFile.Log_Program_id.name; o_Log_Program_id.col_type.m_Type = "int"; o_Log_Program_id.col_type.bPRIMARY_KEY = false; o_Log_Program_id.col_type.bFOREIGN_KEY = true; o_Log_Program_id.col_type.bUNIQUE = false; o_Log_Program_id.col_type.bNULL = false; Add(o_Log_Program_id); o_Log_PathFile_id.col_name = LogFile.Log_PathFile_id.name; o_Log_PathFile_id.col_type.m_Type = "int"; o_Log_PathFile_id.col_type.bPRIMARY_KEY = false; o_Log_PathFile_id.col_type.bFOREIGN_KEY = true; o_Log_PathFile_id.col_type.bUNIQUE = false; o_Log_PathFile_id.col_type.bNULL = false; Add(o_Log_PathFile_id); o_LogFile_Description_id.col_name = LogFile.LogFile_Description_id.name; o_LogFile_Description_id.col_type.m_Type = "int"; o_LogFile_Description_id.col_type.bPRIMARY_KEY = false; o_LogFile_Description_id.col_type.bFOREIGN_KEY = true; o_LogFile_Description_id.col_type.bUNIQUE = false; o_LogFile_Description_id.col_type.bNULL = true; Add(o_LogFile_Description_id); }
public SQL_LogTables(Log_DBConnection x_LogDB_con) { m_LogDB_con = x_LogDB_con; }
public Select_DataSource_Form(Log_DBConnection con) { m_con = con; InitializeComponent(); this.lbl_SelectedServer.Text = lngConn.s_Select_Server.s + ":"; }
public static bool Manage_DBConnection(Form ParentForm,string recent_items_folder, bool bChangeConnection) { if ((Settings.Log2DB_flags & const_Log2DB_flag_Write2DB_on_exit) > 0) { // Check LogDataBaseConnection if (m_LogDB_con == null) { m_LogDB_con = new Log_DBConnection(recent_items_folder); } Log_RemoteDB_data_ProgramSettings = new Log_RemoteDB_data(const_inifile_prefix, 1, Log_DBConnection.eDBType.MSSQL, LanguageControl.lngRPM.s_Connection_To_LogTables_defualt_ProgramSettings.s); return GetConnection(ParentForm, Log_RemoteDB_data_ProgramSettings, bChangeConnection); } else { return true; } }