public DataExport(string longservername, string dbname) { InitializeComponent(); DbName = dbname; dbset = Maticsoft.CmConfig.DbConfig.GetSetting(longservername); dbobj = Maticsoft.DBFactory.DBOMaker.CreateDbObj(dbset.DbType); dbobj.DbConnectStr = dbset.ConnectStr; cb = new Maticsoft.CodeBuild.CodeBuilders(dbobj); dsb = Maticsoft.DBFactory.DBOMaker.CreateScript(dbset.DbType);// ObjHelper.CreatDsb(longservername); this.lblServer.Text = dbset.Server; }
private void btn_Ok_Click(object sender, System.EventArgs e) { try { string server = this.txtServer.Text.Trim(); string user = this.txtUser.Text.Trim(); string pass = this.txtPass.Text.Trim(); if (this.radBtn_DB.Checked) { GetConstr(); if (server == "") { MessageBox.Show(this, "数据库不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } if (this.radBtn_Constr.Checked) { if (txtConstr.Text == "") { MessageBox.Show(this, "数据库不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } string constr = this.txtConstr.Text; //测试连接 OleDbConnection myCn = new OleDbConnection(constr); try { this.Text = "正在连接数据库,请稍候..."; myCn.Open(); } catch { this.Text = "连接数据库失败!"; MessageBox.Show(this, "连接数据库失败!请检查数据库地址或用户名密码是否正确!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } myCn.Close(); this.Text = "连接数据库成功!"; if (dbobj == null) { dbobj = new Maticsoft.CmConfig.DbSettings(); } //将当前配置写入配置文件 dbobj.DbType = "OleDb"; dbobj.Server = server; dbobj.ConnectStr = constr; dbobj.DbName = ""; Maticsoft.CmConfig.DbConfig.AddSettings(dbobj); this.DialogResult = DialogResult.OK; this.Close(); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning); LogInfo.WriteLog(ex); } }
private void CreatDbObj(string servername) { Maticsoft.CmConfig.DbSettings dbset = Maticsoft.CmConfig.DbConfig.GetSetting(servername); dbobj = Maticsoft.DBFactory.DBOMaker.CreateDbObj(dbset.DbType); dbobj.DbConnectStr = dbset.ConnectStr; }