public List <Abnormal> AbnormalNumber(string plantId, string id)
{
List <Abnormal> AbnormalList = new List <Abnormal>();
// string DBName = BeanTools.getPlantDB(plantId).realTimeDB;
Plant plant = BeanTools.getPlantDB(plantId);
string DBName = plant.realTimeDB;
if (!string.IsNullOrEmpty(id) && DBName.Length > 13)
{
IDao dao = new Dao(plant, false);
string sql = string.Format("select m.AS_Equipment_ID,m.AS_Equipment_FileName,m.AS_Equipment_Name,m.AS_Equipment_State from PSOG_AS_Equipment m,PSOG_ProcessMonitorObject n where n.PSOG_MonitorObject_MSPCModelID='{0}'AND n.PSOG_MonitorObject_Name=m.AS_Equipment_Process AND n.PSOG_MonitorObject_Name=m.AS_Equipment_Process AND m.AS_Equipment_State=-1 ", id);
DataSet ds = dao.executeQuery(sql.ToString());
if (BeanTools.DataSetIsNotNull(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Abnormal node = new Abnormal();
node.AS_Equipment_ID = BeanTools.ObjectToString(dr["AS_Equipment_ID"]);
node.AS_Equipment_Name = BeanTools.ObjectToString(dr["AS_Equipment_Name"]);
node.AS_Equipment_State = BeanTools.ObjectToString(dr["AS_Equipment_State"]);
//node.AS_Equipment_FileName = BeanTools.ObjectToString(dr["AS_Equipment_FileName"]);
AbnormalList.Add(node);
}
}
}
return(AbnormalList);
}
/// <summary>
/// 设备类型查询
/// </summary>
/// <param name="PesFileName"></param>
/// <param name="dao"></param>
/// <returns></returns>
public List <Equipment> loadEquipmentFuntion(Plant plant)
{
IDao dao = new Dao(plant, false);
List <Equipment> list = new List <Equipment>();
String sql = "select * from psog_processmonitorObject t where t.psog_monitorobject_type = '设备' order by id asc";
DataSet ds = dao.executeQuery(sql);
if (BeanTools.DataSetIsNotNull(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Equipment bo = new Equipment();
bo.id = BeanTools.ObjectToString(dr["PSOG_MonitorObject_MSPCModelID"]);
bo.monitorObject_Name = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Name"]);
bo.monitorObject_Type = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Type"]);
bo.monitorObject_Source = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Source"]);
bo.monitorObject_Status = BeanTools.ObjectToString(dr["MonitorObject_CurrStatus"]);
if (CommonStr.monitorObject_Source == bo.monitorObject_Source) //替换为自己的连接
{
string[] url = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Url"]).Split('?');
String parames = 2 <= url.Length ? url[1] : "";
bo.monitorObject_Url = "web_runstate_notiem.aspx?" + parames;
}
else
{
bo.monitorObject_Url = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Url"]);
}
list.Add(bo);
}
}
return(list);
}
public static Equipment getClickProcess(string id, Plant plant, string plantId)
{
Equipment equip = new Equipment();
string DBName = plant.historyDB;
if (!string.IsNullOrEmpty(id) && DBName.Length > 13)
{
IDao dao = new Dao(plant, false);
string sql = string.Format("select * from PSOG_ProcessMonitorObject where PSOG_MonitorObject_MSPCModelID='{0}' ", id);
DataSet ds = dao.executeQuery(sql.ToString());
if (BeanTools.DataSetIsNotNull(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
equip.id = BeanTools.ObjectToString(dr["PSOG_MonitorObject_MSPCModelID"]);
equip.monitorObject_Name = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Name"]);
equip.monitorObject_Type = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Type"]);
equip.monitorObject_Source = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Source"]);
equip.monitorObject_Status = BeanTools.ObjectToString(dr["MonitorObject_CurrStatus"]);
if (CommonStr.monitorObject_Source == equip.monitorObject_Source) //替换为自己的连接
{
string[] url = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Url"]).Split('?');
String parames = 2 <= url.Length ? url[1] : "";
//equip.monitorObject_Url = url[0] + "?" + parames + "&modelName=" + equip.monitorObject_Name;
equip.monitorObject_Url = url[0] + "?" + parames;
}
else
{
equip.monitorObject_Url = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Url"]);
}
}
}
return(equip);
}
/// <summary>
/// 获取工段名跟工段报警数
/// </summary>
/// <param name="DBName"></param>
/// <returns></returns>
public string qryMonitorJson(List <Plant> plants)
{
String monitorJson = "[";
if (null != plants && 1 <= plants.Count)
{
foreach (Plant plant in plants)
{
String monitorStr = "";
monitorJson += "{'plantId':'" + plant.id + "','plantName':'" + plant.organtreeName + "','monitorList':[";
String sql = "with tt as (select max(g.Time) recordtime from RTResEx_FDPCA g) ";
sql += "select m.PSOG_MonitorObject_Name,isnull(alarmNum,0) alarmNum,isnull(FDPCA_T2RealValue,0) FDPCA_T2RealValue from ( ";
sql += "select sum(case when FDPCA_TagDCSAlarmFlag <> 0 and FDPCA_TagDCSAlarmFlag is not null then 1 else 0 end) alarmNum, ";
sql += "ModelID,ModelName, max(FDPCA_T2RealValue) FDPCA_T2RealValue ";
sql += "from RTResEx_FDPCA t,tt ";
sql += "where t.Time = tt.recordtime ";
sql += "group by ModelID,ModelName ) alarm right join PSOG_ProcessMonitorObject m ";
sql += "on m.PSOG_MonitorObject_Name = ModelName ";
IDao dao = new Dao(plant, true);
DataSet ds = dao.executeQuery(sql);
if (BeanTools.DataSetIsNotNull(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
String monitorName = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Name"]);
String alarmNum = BeanTools.ObjectToString(dr["alarmNum"]);
double realValue = Convert.ToDouble(BeanTools.ObjectToString(dr["FDPCA_T2RealValue"]));
monitorStr += "{'monitorName':'" + monitorName + "','alarmNum':'" + alarmNum + "','realValue':" + realValue + "},";
}
}
monitorStr = "" == monitorStr ? "" : monitorStr.Substring(0, monitorStr.Length - 1) + "]},"; //去除最后的，
monitorJson += monitorStr;
}
if (monitorJson.EndsWith(","))
{
monitorJson = monitorJson.Substring(0, monitorJson.Length - 1);
}
monitorJson += "]";
}
return(monitorJson);
}
public static string getEquipName(Plant plant, string url)
{
// Equipment equip = new Equipment();
string monitorObject_Name = "";
string DBName = plant.historyDB;
if (DBName.Length > 13)
{
IDao dao = new Dao(plant, false);
string sql = string.Format("select * from PSOG_ProcessMonitorObject where PSOG_MonitorObject_Url like '{0}' ", url);
DataSet ds = dao.executeQuery(sql.ToString());
if (BeanTools.DataSetIsNotNull(ds))
{
DataRow dr = ds.Tables[0].Rows[0];
monitorObject_Name = BeanTools.ObjectToString(dr["PSOG_MonitorObject_Name"]);
}
}
return(monitorObject_Name);
}
/// <summary>
/// 质量分析查询
/// </summary>
/// <param name="page">页号</param>
/// <param name="rows">行数</param>
/// <returns></returns>
public EasyUIData getQualityList(String page, String rows, Plant plant)
{
IDao dao = new Dao(plant, false);
EasyUIData grid = new EasyUIData();
List <RTResExLimsPoint> limsPoint = new List <RTResExLimsPoint>();
String sql = "select count(1) over() allrowCount, LimsPoint_MATCODE,LimsPoint_SAMPLEPOINTDESC,LimsPoint_TESTNO,LimsPoint_ANALYLE,LimsPoint_fValue,LimsPoint_UNITS,Status,LimsPoint_High,LimsPoint_Low,Time from RTResEx_LimsPoint order by status asc , Time desc ";//LimsPoint_PLANT like '%二催化%'
DataSet ds = dao.executeQuery(sql, Int32.Parse(page), Int32.Parse(rows));
if (BeanTools.DataSetIsNotNull(ds))
{
grid.total = BeanTools.DBToInt(ds.Tables[0].Rows[0]["allrowCount"]); //获取总行数
foreach (DataRow dr in ds.Tables[0].Rows)
{
RTResExLimsPoint point = new RTResExLimsPoint();
String value = dr["LimsPoint_fValue"].ToString();
point.limsPointMatCode = (string)dr["LimsPoint_MATCODE"];
point.limsPointSamplePointDesc = dr["LimsPoint_SAMPLEPOINTDESC"].ToString();
point.limsPointTestNo = (string)dr["LimsPoint_TESTNO"];
point.limsPointAnalyle = (string)dr["LimsPoint_ANALYLE"];
if (value.Length > 4)
{
value = value.Substring(0, 4);
}
point.limsPointFValue = value;
point.limsPointUnits = (string)dr["LimsPoint_UNITS"];
point.status = (string)dr["Status"];
point.limsPointHigh = dr["LimsPoint_High"].ToString();
point.limsPointLow = dr["LimsPoint_Low"].ToString();
point.time = BeanTools.DataTimeToString(dr["Time"]);
limsPoint.Add(point);
}
}
grid.rows = limsPoint;
return(grid);
}
/// <summary>
/// 获取非正常的异常
/// </summary>
/// <param name="clickProcess"></param>
/// <param name="DBName"></param>
/// <returns></returns>
//public string unusualConNode(String clickProcess, String DBName)
//{
// String allNodeString = "";
// IDao dao = new Dao(DBName);
// String sql = "select '-1_' + convert(varchar(50),nodeid) + ',' + convert(varchar(32),projectid)+','+nodetext+':' + convert(varchar(32),nodeid) ";
// // sql += string.Format("from dbo.RTResEx_ASGraphRealTime t where t.nodefatherText='{0}'", clickProcess);
// sql += string.Format("from dbo.RTResEx_ASGraphRealTime t");
// DataSet ds = dao.executeQuery(sql);
// if (BeanTools.DataSetIsNotNull(ds))
// {
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// allNodeString += dr[0] + ",";
// }
// if ("" != allNodeString) allNodeString.Substring(0, allNodeString.Length - 1);
// }
// return allNodeString;
//}
public string unusualConNode(String clickProcess, Plant plant)
{
String allNodeString = "";
IDao dao = new Dao(plant, false);
String sql = "select '-1_' + convert(varchar(50),AS_Equipment_ID) + ',' + convert(varchar(32),AS_Equipment_State)+','+AS_Equipment_Name+':' + convert(varchar(32),AS_Equipment_ID) ";
sql += string.Format("from dbo.PSOG_AS_Equipment t where t.AS_Equipment_State='-1' and t.AS_Equipment_Process='{0}'", clickProcess);
DataSet ds = dao.executeQuery(sql);
if (BeanTools.DataSetIsNotNull(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
allNodeString += dr[0] + ",";
}
if ("" != allNodeString)
{
allNodeString.Substring(0, allNodeString.Length - 1);
}
}
return(allNodeString);
}