/// <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);
//}
}
}
}
