private void btnTestConnection_Click(object sender, EventArgs e)
{
try
{
if (checkData())
{
ThreadPool.QueueUserWorkItem(o =>
{
DbConfigInfo dbConfigInfo = getDbConfigInfo();
string conString =
dbConfigInfo.ConnectionString.Trim(new char[] { '"' });
string dbProvider =
DBType.GetDbProviderString(dbConfigInfo.DbType);
DNCCFrameWork.DataAccess.IDbHelper db =
new DNCCFrameWork.DataAccess.DbFactory(conString,
dbProvider).
IDbHelper;
bool success = db.TestConnection();
string tip = "数据库连接失败";
if (success)
{
tip = "数据库连接成功";
}
MessageBox.Show(this, tip, "提示", MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1);
});
}
}
catch (System.Data.Common.DbException ex)
{
MessageBox.Show(this, ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void execute()
{
try
{
DNCCFrameWork.DataAccess.IDbHelper db = new DNCCFrameWork.DataAccess.DbFactory(
gt.dbConnectionString.Trim(new[] { '"' }),
DBType.GetDbProviderString(gt.dbType)).IDbHelper;
string[] sql = tbScript.Text.Split(new[] { "--MQ TG" }, StringSplitOptions.RemoveEmptyEntries);
if (gt.OriginalEncoding != null && gt.TargetEncoding != null)
{
foreach (string str in sql)
{
if (!string.IsNullOrEmpty(str))
{
db.ExecuteNonQuery(str);
}
}
}
MessageBox.Show(this, "执行成功", "提示", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(this, "执行失败[" + ex.Message + "]", "提示",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
private void execute()
{
try
{
bool flag = false;
string temp = tbComment.Text.Trim();
if (!string.IsNullOrEmpty(temp))
{
DataRow[] drs = sc.dsTable.Tables[sc.dbName + sc.DBtable].Select("name = '" + tableInfo.TableName + "'");
if (drs != null && drs.Length > 0)
{
drs[0]["comments"] = temp;
flag = true;
DBFileHelper.WriteXml(sc.dsTable);
}
}
foreach (ColumnInfo column in tableInfo.Columns)
{
if (column.IsChanged)
{
temp = column.Comments;
DataRow[] drs = sc.dsTableColumn.Tables[sc.dbName + sc.DBtablesColumns].Select("TABLE_NAME = '" + tableInfo.TableName + "' and COLUMN_NAME = '" + column.Name + "'");
drs[0]["COMMENTS"] = temp;
flag = true;
DBFileHelper.WriteXml(sc.dsTableColumn);
}
}
if (flag && cbExecuteDB.Checked)
{
DNCCFrameWork.DataAccess.IDbHelper db =
new DNCCFrameWork.DataAccess.DbFactory(
sc.dbConnectionString.Trim(new[] { '"' }),
DBType.GetDbProviderString(sc.dbType))
.IDbHelper;
string[] sql = createCommentSql().Split(new[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
foreach (var s in sql)
{
if (!string.IsNullOrEmpty(s))
{
string t = s.Trim(new[] { '\t', '\r', '\n', ' ', ';' });
if (sc.OriginalEncoding != null &&
sc.TargetEncoding != null)
{
t = EncodingHelper.
ConvertEncoder(sc.TargetEncoding,
sc.OriginalEncoding,
t);
}
if (!string.IsNullOrEmpty(t))
{
db.ExecuteNonQuery(t);
}
}
}
}
MessageBox.Show(this, "执行成功", "提示", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(this, "执行失败[" + ex.Message + "]", "提示",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
