/// <summary>
/// 返回报告模版编号
/// </summary>
/// <param name="templateName">实验名</param>
/// <param name="unitId">机组编号</param>
/// <returns></returns>
public int GetTemplateID(string templateName, string unitId)
{
DataTable dt = null;
try
{
string sql = "SELECT TemplateID FROM ADMINISTRATOR.ThermalTestTemplate WHERE TemplateName='" + templateName + "' AND UNITID='" + unitId + "'";
if (unitId == "0")
{
if (templateName != "0")
{
sql = "SELECT TemplateID FROM ADMINISTRATOR.ThermalTestTemplate WHERE TemplateName='" + templateName + "'";
}
else
{
return(0);
}
}
//else
//{
// if (templateName == "0")
// sql = "SELECT TemplateID FROM ADMINISTRATOR.ThermalTestTemplate WHERE TemplateName='" + templateName + "'";
//}
DataLink link = new DataLink();
dt = link.ExcuteRetureTable(sql);
}
catch (Exception ex)
{
throw ex;
}
return(Convert.ToInt32(dt.Rows[0][0]));
}
/// <summary>
/// 获取实验报告模版
/// </summary>
/// <returns></returns>
public DataTable GetReportByTempleteID()
{
DataTable dt = null;
try
{
string sql = "SELECT * FROM ADMINISTRATOR.ThermalTestTemplate WHERE ID_KEY=" + ID_KEY + "";
DataLink link = new DataLink();
dt = link.ExcuteRetureTable(sql);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
/// <summary>
/// 判断实验模版参数是否存在
/// </summary>
/// <param name="templateId">模版编号</param>
/// <param name="paraId">参数编号</param>
/// <returns></returns>
public bool IsExitTemplatePara(int templateId, string paraId)
{
bool flag = false;
string sql = "SELECT count(*) FROM ADMINISTRATOR.ThermalTestTemplate WHERE PARAID='" + paraId + "' AND TemplateID=" + templateId;
DataLink link = new DataLink();
DataTable dt = link.ExcuteRetureTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() != "0")
{
flag = true;
}
}
return(flag);
}
/// <summary>
/// 获取所有不同实验名
/// </summary>
/// <returns></returns>
public DataTable GetReportName()
{
DataTable dt = null;
try
{
string sql = "";
//if (UnitID == "0")
// //sql = "SELECT DISTINCT(TemplateName),TemplateID FROM ADMINISTRATOR.ThermalTestTemplate";
// sql = "SELECT DISTINCT(TemplateName) FROM ADMINISTRATOR.ThermalTestTemplate";
//else
sql = "SELECT DISTINCT(TemplateName),TEMPLATEID FROM ADMINISTRATOR.ThermalTestTemplate WHERE UNITID='" + UnitID + "'";
DataLink link = new DataLink();
dt = link.ExcuteRetureTable(sql);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}
/// <summary>
/// 返回报告模版编号集
/// </summary>
/// <param name="templateName"></param>
/// <param name="unitId"></param>
/// <returns></returns>
public DataTable GetTemplateIDs(string templateName, string unitId)
{
DataTable dt = null;
try
{
string sql = "SELECT TemplateID FROM ADMINISTRATOR.ThermalTestTemplate WHERE TemplateName='" + templateName + "' AND UNITID='" + unitId + "'";
if (unitId == "0")
{
if (templateName != "0")
{
sql = "SELECT TemplateID FROM ADMINISTRATOR.ThermalTestTemplate WHERE TemplateName='" + templateName + "'";
}
}
DataLink link = new DataLink();
dt = link.ExcuteRetureTable(sql);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}