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); }