private void InitializeBox(string tableName, string schemaName)
        {
            minRow = 1;
            minCol = 1;
            MySqlDataAdapter data = new MySqlDataAdapter(
                "select count(*) from " + tableName,
                ConnectionStatus.thisConnection);
            DataSet dataSet = new DataSet();

            data.Fill(dataSet);
            DataTable dataTable = dataSet.Tables[0];

            maxRow = (long)dataTable.Rows[0].ItemArray[0];
            data   = new MySqlDataAdapter(
                "select count(*) from information_schema.columns where table_schema='" +
                schemaName + "' and table_name='" + tableName + "'",
                ConnectionStatus.thisConnection);
            dataSet = new DataSet();
            data.Fill(dataSet);
            dataTable = dataSet.Tables[0];
            maxCol    = (long)dataTable.Rows[0].ItemArray[0];
            MySQLOperation mysqlObj    = new MySQLOperation();
            DataTable      columnNames = mysqlObj.GetColumnNames(
                ConnectionStatus.thisConnection, tableName);

            keyCol.Items.Clear();
            for (int i = 0; i < columnNames.Rows.Count; i++)
            {
                var item = columnNames.Rows[i].ItemArray[0];
                keyCol.Items.Add(item);
                colExcList.Add(item);
                ColExc.Items.Add(item);
                ExportData.colExport.Add(item);
            }
        }
        private void Schema_Changed(object sender, EventArgs e)
        {
            TableComboBox.Items.Clear();
            MySQLOperation thisOperation = new MySQLOperation();

            System.Data.DataTable tableNames = thisOperation.GetTableNames(
                ConnectionStatus.thisConnection, SchemaComboBox.Text);
            for (int i = 0; i < tableNames.Rows.Count; i++)
            {
                DataRow row = tableNames.Rows[i];
                TableComboBox.Items.Add(row.ItemArray[0]);
            }
        }
        public ExportData()
        {
            InitializeComponent();
            MySQLOperation thisOperation = new MySQLOperation();

            System.Data.DataTable schemaNames = thisOperation.GetSchemaNames(
                ConnectionStatus.thisConnection);
            for (int i = 0; i < schemaNames.Rows.Count; i++)
            {
                DataRow row = schemaNames.Rows[i];
                SchemaComboBox.Items.Add(row.ItemArray[0]);
            }
        }
Exemple #4
0
        private void QuickConnectItems_Click(object sender, RibbonControlEventArgs e)
        {
            string hostName = e.Control.Id;
            string address, port, user, password, defaultSchema;

            ConnectionStatus.xmlPath = Environment.GetFolderPath(
                Environment.SpecialFolder.Personal) + "\\SEMC_SQL_For_Excel.xml";
            XmlDocument dbInfo = new XmlDocument();

            dbInfo.Load(ConnectionStatus.xmlPath);
            XmlNode root = dbInfo.DocumentElement;

            address = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
                                            hostName + "']/Address").InnerText;
            port = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
                                         hostName + "']/Port").InnerText;
            user = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
                                         hostName + "']/Account").InnerText;
            password = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
                                             hostName + "']/PWD").InnerText;
            defaultSchema = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
                                                  hostName + "']/DefaultSchema").InnerText;
            password = AESModel.AESHelper.AESDecryptWithVector(
                password, "SEMCWangsese8586", "SEMCWangVector00");
            MySQLOperation mySQLOperation = new MySQLOperation();

            if (mySQLOperation.MakeConnection(
                    hostName, address, user, password, port, defaultSchema))
            {
                System.Windows.Forms.MessageBox.Show("连接成功");
                ConnectionStatus.alive                        = true;
                ConnectionStatus.connectionName               = hostName;
                Globals.Ribbons.Ribbon1.Disconnect.Enabled    = true;
                Globals.Ribbons.Ribbon1.ExportFromSQL.Enabled = true;
                Globals.Ribbons.Ribbon1.ImportInDB.Enabled    = true;
            }
            else
            {
                System.Windows.Forms.MessageBox.Show(
                    "连接失败,请检查服务器或网络是否正常!");
            }
        }
        private void ConnectionManagerButtonOK_Click(object sender, EventArgs e)
        {
            string hostName, hostAddress, port, userName, password, defaultSchema;

            hostName      = HostNameComboBox.Text;
            hostAddress   = HostAddressTextBox.Text;
            port          = PortTextBox.Text;
            userName      = UserNameTextBox.Text;
            password      = PasswordTextBox.Text;
            defaultSchema = DefaultSchemaTextBox.Text;
            MySQLOperation newOperation = new MySQLOperation();

            if (hostName != "" && hostAddress != "" && port != "" &&
                userName != "" && password != "")
            {
                if (newOperation.MakeConnection(hostName, hostAddress, userName,
                                                password, port, defaultSchema))
                {
                    ActiveForm.Close();
                    MessageBox.Show("连接成功!");
                    ConnectionStatus.alive                        = true;
                    ConnectionStatus.connectionName               = hostName;
                    Globals.Ribbons.Ribbon1.Disconnect.Enabled    = true;
                    Globals.Ribbons.Ribbon1.ExportFromSQL.Enabled = true;
                    Globals.Ribbons.Ribbon1.ImportInDB.Enabled    = true;
                    password = AESModel.AESHelper.AESEncryptWithVector(password,
                                                                       "SEMCWangsese8586", "SEMCWangVector00");
                    if (newOperation.NewConnection(hostName, hostAddress, userName,
                                                   password, port, defaultSchema))
                    {
                        MessageBox.Show("新连接已存储!");
                    }
                }
                else
                {
                    MessageBox.Show("连接失败,请检查填写是否有误,网络状态或服务器是否正常!");
                }
            }
            return;
        }
 private void QuickConnectItems_Click(object sender, RibbonControlEventArgs e)
 {
     string hostName = e.Control.Id;
     string address, port, user, password, defaultSchema;
     ConnectionStatus.xmlPath = Environment.GetFolderPath(
     Environment.SpecialFolder.Personal) + "\\SEMC_SQL_For_Excel.xml";
     XmlDocument dbInfo = new XmlDocument();
     dbInfo.Load(ConnectionStatus.xmlPath);
     XmlNode root = dbInfo.DocumentElement;
     address = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
         hostName + "']/Address").InnerText;
     port = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
         hostName + "']/Port").InnerText;
     user = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
         hostName + "']/Account").InnerText;
     password = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
         hostName + "']/PWD").InnerText;
     defaultSchema = root.SelectSingleNode("//DBInfo/DB[@HostName='" +
         hostName + "']/DefaultSchema").InnerText;
     password = AESModel.AESHelper.AESDecryptWithVector(
         password, "SEMCWangsese8586", "SEMCWangVector00");
     MySQLOperation mySQLOperation = new MySQLOperation();
     if(mySQLOperation.MakeConnection(
         hostName, address, user, password, port, defaultSchema))
     {
         System.Windows.Forms.MessageBox.Show("连接成功");
         ConnectionStatus.alive = true;
         ConnectionStatus.connectionName = hostName;
         Globals.Ribbons.Ribbon1.Disconnect.Enabled = true;
         Globals.Ribbons.Ribbon1.ExportFromSQL.Enabled = true;
         Globals.Ribbons.Ribbon1.ImportInDB.Enabled = true;
     }
     else
     {
         System.Windows.Forms.MessageBox.Show(
             "连接失败,请检查服务器或网络是否正常!");
     }
 }
 private void ConnectionManagerButtonOK_Click(object sender, EventArgs e)
 {
     string hostName, hostAddress, port, userName, password, defaultSchema;
     hostName = HostNameComboBox.Text;
     hostAddress = HostAddressTextBox.Text;
     port = PortTextBox.Text;
     userName = UserNameTextBox.Text;
     password = PasswordTextBox.Text;
     defaultSchema = DefaultSchemaTextBox.Text;
     MySQLOperation newOperation = new MySQLOperation();
     if (hostName != "" && hostAddress != "" &&port != "" &&
         userName != "" && password != "")
     {
         if (newOperation.MakeConnection(hostName, hostAddress, userName,
             password,port,defaultSchema))
         {
             ActiveForm.Close();
             MessageBox.Show("连接成功!");
             ConnectionStatus.alive = true;
             ConnectionStatus.connectionName = hostName;
             Globals.Ribbons.Ribbon1.Disconnect.Enabled = true;
             Globals.Ribbons.Ribbon1.ExportFromSQL.Enabled = true;
             Globals.Ribbons.Ribbon1.ImportInDB.Enabled = true;
             password = AESModel.AESHelper.AESEncryptWithVector(password,
                 "SEMCWangsese8586", "SEMCWangVector00");
             if(newOperation.NewConnection(hostName, hostAddress, userName,
                 password, port, defaultSchema))
             {
                 MessageBox.Show("新连接已存储!");
             }
         }
         else
         {
             MessageBox.Show("连接失败,请检查填写是否有误,网络状态或服务器是否正常!");
         }
     }
     return;
 }
 private void InitializeBox(string tableName, string schemaName)
 {
     minRow = 1;
     minCol = 1;
     MySqlDataAdapter data = new MySqlDataAdapter(
         "select count(*) from " + tableName,
         ConnectionStatus.thisConnection);
     DataSet dataSet = new DataSet();
     data.Fill(dataSet);
     DataTable dataTable = dataSet.Tables[0];
     maxRow = (long)dataTable.Rows[0].ItemArray[0];
     data = new MySqlDataAdapter(
         "select count(*) from information_schema.columns where table_schema='" +
         schemaName + "' and table_name='" + tableName + "'",
         ConnectionStatus.thisConnection);
     dataSet = new DataSet();
     data.Fill(dataSet);
     dataTable = dataSet.Tables[0];
     maxCol = (long)dataTable.Rows[0].ItemArray[0];
     MySQLOperation mysqlObj = new MySQLOperation();
     DataTable columnNames = mysqlObj.GetColumnNames(
         ConnectionStatus.thisConnection, tableName);
     keyCol.Items.Clear();
     for (int i = 0; i < columnNames.Rows.Count; i++)
     {
         var item = columnNames.Rows[i].ItemArray[0];
         keyCol.Items.Add(item);
         colExcList.Add(item);
         ColExc.Items.Add(item);
         ExportData.colExport.Add(item);
     }
 }