Exemple #1
0
 public PanelDbView(DBtool database, Logger logger)
 {
     DB     = database;
     Logger = logger;
     InitializeComponent();
     Panel_Procedure = new PanelProcedure(DB, Logger)
     {
         Dock = DockStyle.Fill
     };
     Panel_Sql = new PanelSql(DB, Logger)
     {
         Dock = DockStyle.Fill
     };
     Panel_TableCreate = new PanelTableCreate(DB, Logger)
     {
         Dock = DockStyle.Fill
     };
     Panel_TableData = new PanelTableData(DB, Logger)
     {
         Dock = DockStyle.Fill
     };
     Panel_TableList = new PanelTableList(DB, Logger)
     {
         Dock = DockStyle.Fill
     };
     Panel_Trigger = new PanelTrigger(DB, Logger)
     {
         Dock = DockStyle.Fill
     };
     Panel_Procedure.OnProcedureRun += OnPocedureRun_ChangePanel;
     Panel_Sql.OnQuery += OnQuery_ChangePanel;
     Panel_TableCreate.OnTableCreate += OnTableCreate_ChangePanel;
     Panel_TableList.OnTableDelete   += OnTableCreate_ChangePanel;
     Panel_TableList.OnTableClick    += OnTableClick_ChangePanel;
 }
Exemple #2
0
 public FormProcedure(DBtool DB)
 {
     this.DB = DB;
     InitializeComponent();
     table1.TableInit(
         new string[] { "Направление", "Имя", "Тип", "Размер", "" },
         new float[] { 20, 20, 20, 20, 20 }
         );
     AddRow();
 }
Exemple #3
0
 public PanelTrigger(DBtool database, Logger logger)
 {
     DB     = database;
     Logger = logger;
     InitializeComponent();
     table_trigger.TableInit(
         new string[] { "Имя", "Время", "Событие", "Действия" },
         new float[] { 20, 20, 20, 40 }
         );
 }
Exemple #4
0
 public PanelProcedure(DBtool database, Logger logger)
 {
     DB     = database;
     Logger = logger;
     InitializeComponent();
     table_procedure.TableInit(
         new string[] { "Имя", "Тип", "Действия" },
         new float[] { 25, 25, 50 }
         );
 }
Exemple #5
0
 public PanelTableList(DBtool database, Logger logger)
 {
     DB     = database;
     Logger = logger;
     InitializeComponent();
     table_tablelist.TableInit(
         new string[] { "Таблица", "Сравнение", "Тип", "Строки", "Действия" },
         new float[] { 30, 26, 12, 12, 20 }
         );
     table_tablelist.RowClick += ClickTable;
 }
Exemple #6
0
 public PanelTableCreate(DBtool database, Logger logger)
 {
     DB     = database;
     Logger = logger;
     InitializeComponent();
     table1.TableInit(
         new string[] { "Имя", "Тип", "Размер", "Индекс", "Подпись" },
         new float[] { 20, 20, 20, 20, 20 }
         );
     AddRow();
 }
Exemple #7
0
        private bool Authorisation()
        {
            FormConnect formConnect = new FormConnect();

            formConnect.ShowDialog();
            if (formConnect.DBConnection != null)
            {
                DB = formConnect.DBConnection;
                formConnect.Dispose();
                return(true);
            }
            else
            {
                Dispose();
                return(false);
            }
        }
Exemple #8
0
        private void connect_Click(object sender, EventArgs e)
        {
            string host;
            string username;
            string password;
            int    port;

            string[] host_arr = input_host.Text.Trim().Split(new char[] { ':' });
            switch (host_arr.Length)
            {
            case 1:
                port = 3306;
                break;

            case 2:
                try
                {
                    port = int.Parse(host_arr[1].Trim());
                }
                catch
                {
                    Logger.Info("Неверный формат порта сервера");
                    return;
                }
                break;

            default:
                Logger.Info("Неверный формат адреса сервера");
                return;
            }
            host     = host_arr[0].Trim();
            username = input_user.Text.Trim();
            password = input_pass.Text.Trim();

            if (save_login_check.Checked)
            {
                string auth_file_data = host + "\n" + port + "\n" + username + "\n" + password;
                try
                {
                    using (StreamWriter sw = new StreamWriter("auth", false, System.Text.Encoding.UTF8))
                    {
                        sw.WriteLine(auth_file_data);
                    }
                }
                catch (Exception er)
                {
                    Logger.Error(er.Message);
                }
            }

            DBtool DBConnection = new DBtool(host, username, password, port);

            if (DBConnection.ConnectError == "")
            {
                this._DBConnection = DBConnection;
                Close();
            }
            else
            {
                label_status.Text = DBConnection.ConnectError;
            }
        }
Exemple #9
0
 public PanelTableData(DBtool database, Logger logger)
 {
     DB     = database;
     Logger = logger;
     InitializeComponent();
 }
Exemple #10
0
 public PanelDbCreate(DBtool database, Logger logger)
 {
     DB     = database;
     Logger = logger;
     InitializeComponent();
 }
Exemple #11
0
 public FormTrigger(DBtool DB)
 {
     this.DB = DB;
     InitializeComponent();
 }