static void Main(string[] args)
{
DBChecker _checker = new DBChecker();
_checker.CheckDB();
Console.ReadKey();
}
/// <summary>
/// 获取更新数据的SQL
/// </summary>
/// <returns></returns>
public string GetUpdateDBText()
{
List <string> lstSQL = DBChecker.CheckDataBase(this);
StringBuilder sbSQL = new StringBuilder();
foreach (string sql in lstSQL)
{
sbSQL.AppendLine(sql);
}
return(sbSQL.ToString());
}
private void btnSubmit_Click(object sender, EventArgs e)
{
List <string> resault = DBChecker.ExecuteSQL(TestDB.GetDBinfo().DefaultOperate, _lstSql);
StringBuilder sbRet = new StringBuilder();
foreach (string res in resault)
{
sbRet.AppendLine(res);
}
txtOut.Text = sbRet.ToString();
}
/// <summary>
/// 检查并更新数据库结构
/// </summary>
/// <returns></returns>
public string UpdateDataBase()
{
List <string> sql = DBChecker.CheckDataBase(this);
List <string> res = DBChecker.ExecuteSQL(DefaultOperate, sql);
StringBuilder sbRet = new StringBuilder();
foreach (string str in res)
{
sbRet.AppendLine(str);
}
return(sbRet.ToString());
}
private void btnSubmit_Click(object sender, EventArgs e)
{
DBConfigInfo dbcinfo = FrmDBSetting.GetDBConfigInfo(DesignerInfo, "");
DBInfo dbInfo = dbcinfo.CreateDBInfo();
rtbOutput.Text = "";
if (_lstSql == null || _lstSql.Count == 0)
{
return;
}
List <string> resault = DBChecker.ExecuteSQL(dbInfo.DefaultOperate, _lstSql);
StringBuilder sbRet = new StringBuilder();
foreach (string res in resault)
{
sbRet.AppendLine(res);
}
rtbOutput.Text = sbRet.ToString();
}
/// <summary>
/// 检查数据库结构
/// </summary>
/// <returns></returns>
public List <string> CheckDataBase()
{
return(DBChecker.CheckDataBase(this));
}
