/// <summary>
/// 测试连接
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string ex = string.Empty;
ILibDBHelp help = null;
string connectStr = string.Empty;
switch (this.combDataBaseType.Text.Trim())
{
case "SQL SERVER":
help = new DBHelpFactory().GetDBHelp(LibProviderType.SqlServer);
connectStr = string.Format("server={0};database={1};uid={2};password={3}", this.txtServerAddr.Text, this.txtDataBase.Text, this.txtUserId.Text, this.txtpwd.Text);
break;
case "ORACLE":
help = new DBHelpFactory().GetDBHelp(LibProviderType.Oracle);
ex = string.Empty;
connectStr = string.Format("Provider=OraOLEDB.Oracle.1;User ID={0};Password={1};" +
"Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = {2})(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = {3})))",
this.txtUserId.Text.Trim(), this.txtpwd.Text.Trim(), this.txtServerAddr.Text.Trim(), this.txtDataBase.Text.Trim());
//connectStr = string.Format("User ID={0};Password={1};Data Source={2}",this.txtUserId.Text .Trim (),this.txtpwd .Text .Trim (),this.txtDataBase.Text .Trim ());
break;
}
if (help != null)
{
help.TestConnect(connectStr, out ex);
MessageBox.Show(ex);
}
}
public DataAccess()
{
if (_dbFactory == null)
{
_dbFactory = new DBHelpFactory();
}
_dbHelp = _dbFactory.GetDBHelp();
}
private void button3_Click(object sender, EventArgs e)
{
ILibDBHelp dbhelp = new DBHelpFactory().GetDBHelp();
//FileOperation file = new FileOperation();
//file.FilePath = SysConstManage.DBFilePath;
//string info= file.BinaryReadDBConnectStr();
object obj = dbhelp.ExecuteScalar("select nickname from ACCOUNT");
}
private void DoWritDataLog(LibTableObj[] tableObjs)
{
try
{
if (tableObjs != null)
{
DataTable dt = null;
//string logid = null;
string tablenm = null;
string ID = string.Empty;
string logtbnm = string.Empty;
//LibDbParameter[] parameters = null;
//List<string > sqlbuilder = new List<string>();
StringBuilder sqlbuilder = new StringBuilder();
//ColExtendedProperties colextprop = null;
TableExtendedProperties tbextprop = null;
ILibDBHelp dBHelp = new DBHelpFactory().GetDBHelp(ResFactory.ResManager.LogDBNm);
foreach (LibTableObj tableObj in tableObjs)
{
dt = tableObj.DataTable;
if (dt != null && dt.Rows != null)
{
tbextprop = Newtonsoft.Json.JsonConvert.DeserializeObject <TableExtendedProperties>(dt.ExtendedProperties[SysConstManage.ExtProp].ToString());
if (!tbextprop.Ignore)
{
continue;
}
foreach (DataRow dr in dt.Rows)
{
//logid = dr[SysConstManage.Sdp_LogId].ToString();
tablenm = dt.TableName;
switch (dr.RowState)
{
case DataRowState.Added:
sqlbuilder.Append(DoGetLogSqlStr(dr, tablenm, 1, dBHelp));
break;
case DataRowState.Modified:
sqlbuilder.Append(DoGetLogSqlStr(dr, tablenm, 2, dBHelp));
break;
}
}
}
}
if (!string.IsNullOrEmpty(sqlbuilder.ToString()))
{
dBHelp.ExecuteNonQuery(sqlbuilder.ToString());
}
}
}
catch (Exception ex)
{
this.ExceptionHelp.ThrowError(this, ex.Message, ex.StackTrace);
}
}
/// <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);
//}
}
}
}
