/// <summary> /// /// </summary> private void GetConnectStr() { //_dbConnectStr = DBInfoHelp.BinaryReadDBConnectStr(); _dbConnectStr = DBInfoHelp.ReadSysDBConnect(); if (!string.IsNullOrEmpty(_dbConnectStr)) { _dbProvierFactory = LibDBProviderFactory.GetDbProviderFactory(DBInfoHelp.ProviderType); DBInfoHelp.Key = GetAccoutKey(); if (!string.IsNullOrEmpty(DBInfoHelp.Key)) { _dbConnect = null; _dbcmd = null; _dbConnectStr = DBInfoHelp.ReadDBConnect(); } } }
/// <summary> /// 保存配置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { DBInfoHelp help = new DBInfoHelp(); DBInfo dbinfo = new DBInfo(); dbinfo.Key = DesCryptFactory.GenerateKey(); dbinfo.DataBase = this.txtDataBase.Text.Trim(); dbinfo.ServerAddr = this.txtServerAddr.Text.Trim(); dbinfo.UserId = this.txtUserId.Text.Trim(); dbinfo.Password = this.txtpwd.Text.Trim(); dbinfo.Guid = dbinfo.DataBase == ResFactory.ResManager.LogDBNm ? dbinfo.DataBase : Guid.NewGuid().ToString(); switch (this.combConType.SelectedText.Trim()) { case "TCP": dbinfo.ConnectType = LibConnectType.TCP; break; case "HTTP": dbinfo.ConnectType = LibConnectType.HTTP; break; } switch (this.combDataBaseType.Text.Trim()) { case "SQL SERVER": dbinfo.ProviderType = LibProviderType.SqlServer; break; case "ORACLE": dbinfo.ProviderType = LibProviderType.Oracle; break; } help.BinaryWriteDBInfo(dbinfo); //MessageBox.Show(help.ExceptionMessage); ILibDBHelp dbhelp = new DBHelpFactory().GetDBHelp(dbinfo.ProviderType); if (dbhelp.SaveAccout(dbinfo)) { MessageBox.Show("保存成功"); } else { MessageBox.Show("保存出错"); } }
private void DBConfig_Load(object sender, EventArgs e) { DataTable dt = new DataTable("DBServerInfo"); DataColumn col = null; col = new DataColumn("Guid"); col.Caption = "账套Guid"; dt.Columns.Add(col); col = new DataColumn("DataBase"); col.Caption = "账套"; dt.Columns.Add(col); col = new DataColumn("ServerAddr"); col.Caption = "服务地址"; dt.Columns.Add(col); col = new DataColumn("ConnectType"); col.Caption = "数据库链接方式"; dt.Columns.Add(col); col = new DataColumn("ProviderType"); col.Caption = "数据库驱动类型"; dt.Columns.Add(col); col = new DataColumn("UserId"); col.Caption = "用户名"; dt.Columns.Add(col); this.dataGridView1.DataSource = dt; foreach (DataGridViewColumn c in this.dataGridView1.Columns) { c.HeaderText = dt.Columns[c.Name].Caption; } DBInfoHelp help = new DBInfoHelp(); if (!string.IsNullOrEmpty(help.ReadSysDBConnect())) { List <DBInfo> dBInfos = help.GetAccoutSetting(); ILibDBHelp dbhelp = new DBHelpFactory().GetDBHelp(); DataTable accoutDT = dbhelp.GetAccout(); if (accoutDT != null && accoutDT.Rows != null) { DataRow row = null; foreach (DBInfo info in dBInfos) { DataRow[] rows = accoutDT.Select(string.Format("ID='{0}'", info.Guid)); if (rows == null || rows.Length == 0) { continue; } help.Guid = rows[0]["ID"].ToString(); help.Key = rows[0]["key"].ToString(); help.ReadDBConnect(); row = dt.NewRow(); row["Guid"] = rows[0]["ID"]; row["DataBase"] = rows[0]["AccoutNm"]; row["ServerAddr"] = rows[0]["IPAddress"]; row["ProviderType"] = help.ProviderType; dt.Rows.Add(row); } //foreach (DataRow dr in accoutDT.Rows) //{ // if (dr["AccoutNm"].ToString() == ResFactory.ResManager.SysDBNm) // { // help.ReadSysDBConnect(); // } // else // { // help.Guid = dr["ID"].ToString(); // help.Key = dr["key"].ToString(); // help.ReadDBConnect(); // } // row = dt.NewRow(); // row["Guid"] = dr["ID"]; // row["DataBase"] = dr["AccoutNm"]; // row["ServerAddr"] = dr["IPAddress"]; // row["ProviderType"] = help.ProviderType; // dt.Rows.Add(row); //} } } }