private string DDLScript()
{
CleanDataStep = enumCleanDataStep.DDLScript;
DataTable dataTable = MySqlHelper.ExecuteDataset(EnvironmentInfo.ConnectionString, "show create table sync_xmpp;").Tables[0];
string ddlScript = dataTable.Rows[0]["Create Table"].ToString();
return(ddlScript);
}
private void DeleteFile(string xmppidb)
{
if (CleanDataStep > enumCleanDataStep.DeleteFile)
{
return;
}
CleanDataStep = enumCleanDataStep.DeleteFile;
ShowMessage("正在删除sync_xmpp.ibd...");
if (File.Exists(xmppidb))
{
File.Delete(xmppidb);
ShowMessage("sync_xmpp.ibd文件已删除...");
}
}
private void DropTable()
{
if (CleanDataStep > enumCleanDataStep.DropTable)
{
return;
}
CleanDataStep = enumCleanDataStep.DropTable;
ShowMessage("正在销毁sync_xmpp表...");
try
{
MySqlHelper.ExecuteNonQuery(EnvironmentInfo.ConnectionString, "drop table sync_xmpp");
ShowMessage("sync_xmpp表已销毁...");
}
catch (Exception)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("sync_xmpp表销毁失败，请复制下面的脚本在Navicat中执行：").Append(Environment.NewLine);
stringBuilder.Append("drop table sync_xmpp;").Append(Environment.NewLine);
}
}
private void StartMySql()
{
if (CleanDataStep > enumCleanDataStep.StartMySql)
{
return;
}
CleanDataStep = enumCleanDataStep.StartMySql;
ShowMessage("正在启动MySql服务...");
if (!ProcessHelper.IsServiceRunning("mysql"))
{
ProcessHelper.StartService("mysql");
}
if (!ProcessHelper.IsServiceRunning("mysql"))
{
ShowMessage("MySql服务启动失败，请手动重启...");
}
else
{
ShowMessage("MySql服务已启动...");
}
}
private void CreateTable(string ddlScript)
{
if (CleanDataStep > enumCleanDataStep.CreateTable)
{
return;
}
CleanDataStep = enumCleanDataStep.CreateTable;
ShowMessage("正在创建sync_xmpp表...");
try
{
MySqlHelper.ExecuteNonQuery(EnvironmentInfo.ConnectionString, ddlScript);
ShowMessage("sync_xmpp表已重新创建...");
CleanDataStep = enumCleanDataStep.DDLScript;
ShowMessage("sync_xmpp表数据清理完成...");
}
catch (Exception)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("sync_xmpp表创建失败，请复制下面的脚本在Navicat中执行：").Append(Environment.NewLine);
stringBuilder.Append(ddlScript).Append(";").Append(Environment.NewLine);
}
}
private void StopMySql()
{
if (CleanDataStep > enumCleanDataStep.StopMySql)
{
return;
}
CleanDataStep = enumCleanDataStep.StopMySql;
ShowMessage("正在停止MySql服务...");
if (ProcessHelper.IsServiceRunning("mysql"))
{
ProcessHelper.StopService("mysql");
}
if (ProcessHelper.IsServiceRunning("mysql"))
{
ShowMessage("MySql服务暂停失败！请重新尝试或者手动停止...");
CleanDataStep = enumCleanDataStep.Finsh;
return;
}
else
{
ShowMessage("MySql服务已停止...");
}
}
