コード例 #1
0
ファイル: Form1.cs プロジェクト: fh123321/ModelsCreator
        /// <summary>
        /// 連線按鈕事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Connect_Click(object sender, EventArgs e)
        {
            txtConnError.Text = "";

            //LEVEL 1 CHECK SELECT
            if (DbSelect.SelectedItem == null || String.IsNullOrEmpty(DbSelect.SelectedItem.ToString()))
            {
                MessageBox.Show("您尚未選擇資料庫型態", "Error");
            }
            else
            {
                param.DBType = DbSelect.SelectedItem.ToString();
                //LEVEL 2 CHECK DB TEST
                if (String.IsNullOrEmpty(ConnStr.Text))
                {
                    MessageBox.Show("您沒有輸入資料庫連線字串", "Error");
                }
                else
                {
                    param.ConnectionString = ConnStr.Text;
                    //Using DI INJECT INTO
                    Dao.Dao testconn = new Dao.Dao();
                    Type    type     = Type.GetType("ModelHalper.Dao.Dao" + param.DBType);
                    testconn.SQL = (IDao)Activator.CreateInstance(type);
                    //IF CONNECTION ERROR
                    if (!testconn.TestSql(param))
                    {
                        txtConnError.Text = "您的連線字串有誤";
                    }
                    else
                    {
                        Connect.Enabled       = false;
                        DbSelect.Enabled      = false;
                        ConnStr.Enabled       = false;
                        ConnName.Enabled      = false;
                        SettingSelect.Enabled = false;
                        SaveConn.Enabled      = false;
                        DisConnect.Enabled    = true;
                        tablesearch.Enabled   = true;
                        CrtClass.Enabled      = true;
                        OutClass.Enabled      = true;
                        txtConnError.Text     = "連線成功";
                        var tables = testconn.GetTable(param);
                        foreach (TableModel table in tables)
                        {
                            TableSelect.Items.Add(table.Owner + "-" + table.Table_Name);
                        }
                    }
                }
            }
        }
コード例 #2
0
ファイル: Form1.cs プロジェクト: fh123321/ModelsCreator
        /// <summary>
        /// 搜尋表單按鈕事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tablesearch_Click(object sender, EventArgs e)
        {
            //clear all
            TableSelect.Items.Clear();

            param.Table_Name = TableName.Text;
            param.Owner      = Owner.Text;

            Dao.Dao testconn = new Dao.Dao();
            Type    type     = Type.GetType("ModelHelper.Dao.Dao" + param.DBType);

            testconn.SQL = (IDao)Activator.CreateInstance(type);
            var tables = testconn.GetTable(param);

            foreach (TableModel table in tables)
            {
                TableSelect.Items.Add(table.Owner + "-" + table.Table_Name);
            }
        }