Exemplo n.º 1
0
        /// <summary>
        /// 连接数据库
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void skinBtnConnect_Click(object sender, EventArgs e)
        {
            _dbConfig.Port     = skinTextBoxPort.Text.ToInt32();
            _dbConfig.Account  = skinTextBoxAccount.Text;
            _dbConfig.Password = skinTextBoxPassword.Text;
            _dbConfig.Ip       = skinTextBoxAddress.Text;
            _dbConfig.DbType   = GetBaseType();
            DbGenerate dbModelGenerate = new DbGenerate(_dbConfig);
            var        r = dbModelGenerate.GetDataBase();

            skinComboBoxDatabase.DataSource = r;
            using (FileStream fileStream =
                       new FileStream("appconfig.bin", FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite))
            {
                var modelConfig = JsonConvert.SerializeObject(_dbConfig);
                var b           = Encoding.UTF8.GetBytes(modelConfig);
                fileStream.Write(b, 0, b.Length);
            }
            DataBaseType GetBaseType()
            {
                DataBaseType dataBaseType = DataBaseType.MsSQL;

                switch (skinComboxDatabaseName.SelectedIndex)
                {
                case 0:
                    dataBaseType = DataBaseType.MsSQL;
                    break;

                case 1:
                    dataBaseType = DataBaseType.MySQL;
                    break;
                }
                return(dataBaseType);
            }
        }