/// <summary>
/// 返回SQL命令：(创建作业步骤 1，杀掉UTP进程)
/// </summary>
/// <returns></returns>
public string strSQLUTPKill(string sid)
{
JOB job = new JOB();
string strDatabaseName = string.Empty;
strDatabaseName = job.GetConfig("strDatabaseName") + ".dbo.";
string strSQLForUTPStart = "exec " + strDatabaseName + "PrJobUTPKill '" + sid + "'";
return(strSQLForUTPStart);
}
/// <summary>
/// 返回SQL命令：(创建作业步骤 1，检查UTP是否启动)
/// </summary>
/// <returns></returns>
public string strSQLUPTBilling(Job jb, string JobCommandString)
{
string strTemp = JobCommandString;
string[] strTemps = strTemp.Split('e');
JOB job = new JOB();
string strDatabaseName = string.Empty;
strDatabaseName = job.GetConfig("strDatabaseName") + ".dbo.";
string strSQLUPTBilling = "exec " + strDatabaseName + "[PrJobUTPBilling] '" + jb.JobID + "'," + "'" + JobCommandString + "'";
return(strSQLUPTBilling);
}
/// <summary>
/// 返回SQL命令：(创建作业步骤 1，杀掉UTP进程)
/// </summary>
/// <returns></returns>
public string strSQLUTPKill(string sid)
{
JOB job = new JOB();
string strDatabaseName = string.Empty;
strDatabaseName = job.GetConfig("strDatabaseName") + ".dbo.";
string strSQLForUTPStart = "exec " + strDatabaseName + "PrJobUTPKill '" + sid + "'";
return strSQLForUTPStart;
}
/// <summary>
/// 返回SQL命令：(创建作业步骤 1，检查UTP是否启动)
/// </summary>
/// <returns></returns>
public string strSQLUPTBilling(Job jb, string JobCommandString)
{
string strTemp = JobCommandString;
string[] strTemps = strTemp.Split('e');
JOB job = new JOB();
string strDatabaseName = string.Empty;
strDatabaseName = job.GetConfig("strDatabaseName") + ".dbo.";
string strSQLUPTBilling = "exec " + strDatabaseName + "[PrJobUTPBilling] '" + jb.JobID + "'," + "'" + JobCommandString + "'";
return strSQLUPTBilling;
}