private void btnOK_Click(object sender, EventArgs e)
{
if (!CheckInput())
{
return;
}
bool flag = TestConn(sqlType);
if (flag)
{
if (chkRem.Checked)
{
DataSet ds = dal.GetList("IP='" + cboServer.Text.Trim() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
dal.DeleteByCond("IP='" + cboServer.Text.Trim() + "'");
}
DbConnect model = new DbConnect();
model.CreateDate = DateTime.Now.ToString();
model.IP = cboServer.Text.Trim();
model.Pwd = DESEncryptHelper.Encrypt(txtPassword.Text.Trim(), "test332211");
model.User = cboUser.Text.Trim();
model.Remark = sqlType.ToString().ToLower();
dal.Add(model);
}
strConn = DESEncryptHelper.Encrypt(BuildConn(sqlType), "test332211");
DBName = txtDB.Text.Trim();
MessageBox.Show("连接成功");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("测试连接失败");
}
}
private void cboServer_SelectedIndexChanged(object sender, EventArgs e)
{
DataRow[] drs = dt.Select("IP='" + cboServer.Text.Trim() + "'");
if (drs.Length > 0)
{
cboUser.Text = drs[0]["User"].ToString();
txtPassword.Text = DESEncryptHelper.Decrypt(drs[0]["Pwd"].ToString(), "test332211");
}
}
/// <summary>
/// 初始化日志表
/// </summary>
/// <param name="strExistsTbSql">判断日志表是否存在的sql语句</param>
/// <param name="strTbName">表名</param>
/// <param name="strDbName">数据库名</param>
/// <returns></returns>
private bool InitLogTable(string strExistsTbSql, string strTbName, string strDbName)
{
bool flag = true;
string strConn = DESEncryptHelper.Decrypt(txtConnection.Text.Trim(), "test332211");
SqlType sqlType = SqlType.SQLite;
if (cboLogType.Text == "sqlite")
{
sqlType = SqlType.SQLite;
}
else if (cboLogType.Text == "sqlserver")
{
sqlType = SqlType.SqlServer;
}
else if (cboLogType.Text == "mysql")
{
sqlType = SqlType.MySql;
}
IDbHelper dbHelper = LoggerHelper.GetDBHelper(sqlType, strConn);
if (dbHelper != null)
{
dbHelper.CreateCommand(strExistsTbSql);
int intResult = dbHelper.ExecuteQuery().Rows.Count;
if (intResult > 0)
{
if (MessageBox.Show("已经存在日志记录表" + strTbName + ",是否删除重新建立？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string strDropTable = "DROP TABLE " + strTbName + "";
dbHelper.CreateCommand(strDropTable);
try
{
dbHelper.ExecuteNonQuery();
}
catch (Exception)
{
MessageBox.Show("删除失败");
flag = false;
}
flag = DoCreateTable(dbHelper);
}
}
else
{
flag = DoCreateTable(dbHelper);
}
}
return(flag);
}
/// <summary>获取日志存储库连接字符串
///
/// </summary>
/// <returns></returns>
public static string GetConn()
{
string conn = string.Empty;
if (!string.IsNullOrEmpty(StaticInfoHelper.ConnString))
{
conn = StaticInfoHelper.ConnString;
}
else
{
string strFilePath = Application.StartupPath + "\\log.ini";
if (File.Exists(strFilePath))
{
conn = INIOperationHelper.INIGetStringValue(strFilePath, "LogConnection", "Connection", null);
conn = DESEncryptHelper.Decrypt(conn, "test332211");
StaticInfoHelper.ConnString = conn;
}
}
return(conn);
}
/// <summary>创建本地配置文件
/// 创建本地配置文件
/// </summary>
private void CreateIniFile()
{
string filePath = Application.StartupPath + "\\" + "Log.ini";
if (!File.Exists(filePath))
{
File.Create(filePath).Close();
}
else
{
File.Delete(filePath);
File.Create(filePath).Close();
}
if (cboLogType.Text.Trim().ToLower() == "sqlite")
{
INIOperationHelper.INIWriteValue(filePath, "LogConnection", "Connection", DESEncryptHelper.Encrypt("LogLocalDB", "test332211"));
}
else
{
INIOperationHelper.INIWriteValue(filePath, "LogConnection", "Connection", txtConnection.Text.Trim());
}
INIOperationHelper.INIWriteValue(filePath, "LogType", "Type", cboLogType.Text.Trim().ToLower() + "log");
}