protected void Page_Load(object sender, EventArgs e)
{
String modelId = Request.QueryString["modelId"];
modelId = null == modelId ? "" : modelId;
String plantId = Request.QueryString["plantCode"];
plantId = null == plantId ? "" : plantId;
string DBName = BeanTools.getPlantDB(plantId).historyDB; //数据库名
Plant plant = BeanTools.getPlantDB(plantId);
IList list = new ArrayList();
list = new AlarmAnalysis().ftaModelTags(plant, id2ModelId[int.Parse(modelId) - 1]);
pcaModelJson = BeanTools.ToJson(list);
string ftaStateTemp = "";
ftaStateTemp = new AlarmAnalysis().FaultTreeResultById(plant, id2ModelId[int.Parse(modelId) - 1]);
ftaState = ftaStateTemp.Split(',')[0];
ftaStateStartTime = ftaStateTemp.Split(',')[1];
EasyUIData grid = new AlarmAnalysis().ftaAbnormalHistory(plant, id2ModelId[int.Parse(modelId) - 1]);
ftaHistory = BeanTools.ToJson(grid);
}
/// <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 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);
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime time = DateTime.Now;
String plantCode = Request.QueryString["plantCode"];
// String plantId = Request.QueryString["plantId"];
String DBName = BeanTools.getPlantDB(plantCode).historyDB;
Plant plant = BeanTools.getPlantDB(plantCode);
endTime = Request.QueryString["endTime"];
endTime = null == endTime?time.ToString("yyyy-MM-dd HH:mm:ss") : endTime;
startTime = Request.QueryString["startTime"];
startTime = null == startTime?time.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss") : startTime;
String modelId = Request.QueryString["modelId"];
modelId = null == modelId ? "" : modelId; //表名
//String url = "%process_monitor_state.aspx?modelId=" + modelId +"&plantCode=" + plantCode;
String url = "%process_monitor_state.aspx?modelId=" + modelId + "&%";
//String modelName = Request.QueryString["modelName"];
String modelName = Common.getEquipName(plant, url);
modelName = null == modelName ? "" : modelName; //表名
chartStr = new AlarmAnalysis().alarmNotIEMchartLine(plant, startTime, endTime, modelId, modelName);
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime time = DateTime.Now;
String plantId = Request.QueryString["plantId"];
plantId = null == plantId ? "" : plantId;
string DBName = BeanTools.getPlantDB(plantId).historyDB; //数据库名
Plant plant = BeanTools.getPlantDB(plantId);
endTime = Request.QueryString["endTime"];
endTime = null == endTime?time.ToString("yyyy-MM-dd HH:mm:ss") : endTime;
startTime = Request.QueryString["startTime"];
startTime = null == startTime?time.AddHours(-12).ToString("yyyy-MM-dd HH:mm:ss") : startTime;
String tableName = Request.QueryString["tableName"];
tableName = null == tableName ? "" : tableName; //表名
String upLine = Request.QueryString["upLine"];
String downLine = Request.QueryString["downLine"];
chartStr = new AlarmAnalysis().alarmAnychartLine3(plant, startTime, endTime, tableName, upLine, downLine);
}
protected void Page_Load(object sender, EventArgs e)
{
String userId = ((SysUser)Session[CommonStr.session_user]).userId;
string parentMenuCode = Request.QueryString["parentMenuCode"];
List <TreeNode> treeNodeList = new SysManage().loadManageTree(userId, parentMenuCode);
headMenuJson = BeanTools.ToJson(treeNodeList);
}
protected void Page_Load(object sender, EventArgs e)
{
String plantId = Request.QueryString["plantId"];
string DBName = BeanTools.getPlantDB(plantId).realTimeDB;
Plant plant = BeanTools.getPlantDB(plantId);
dataJson = new ArtTch().produceJson(plant);
}
protected void Page_Load(object sender, EventArgs e)
{
List <TreeNode> treeList = new List <TreeNode>();
SysManage sysManage = new SysManage();
treeList = sysManage.qrtMenuAndPlantTree();
headMenuJson = BeanTools.ToJson(treeList);
}
protected void Page_Load(object sender, EventArgs e)
{
String plantId = Request.QueryString["plantId"];
plantId = null == plantId ? "" : plantId;
String DBName = BeanTools.getPlantDB(plantId).realTimeDB;
Plant plant = BeanTools.getPlantDB(plantId);
list = new DeviceTch().loadEquipmentFuntion(plant);
}
protected void Page_Load(object sender, EventArgs e)
{
String plantId = Request.Form["plantId"];
string DBName = BeanTools.getPlantDB(plantId).realTimeDB;
Plant plant = BeanTools.getPlantDB(plantId);
MainPage mainPage = new MainPage();
String returnStr = mainPage.getNewPageJson(plant);
Response.Write(returnStr);
}
protected void Page_Load(object sender, EventArgs e)
{
String plantId = Request.QueryString["plantId"];
plantId = null == plantId ? "" : plantId;
plantName = new SysManage().getPlantName(plantId);
string DBName = BeanTools.getPlantDB(plantId).historyDB; //数据库名
Plant plant = BeanTools.getPlantDB(plantId);
jsonStr = new AlarmAnalysis().FaultTreeResult(plant);
}
public String functionNos = ""; //主页要显示的各功能表单 形式如002,003；002代表工艺检测
protected void Page_Load(object sender, EventArgs e)
{
String plantId = Request.QueryString["plantId"];
string DBName = BeanTools.getPlantDB(plantId).realTimeDB;
Plant plant = BeanTools.getPlantDB(plantId);
string userId = ((SysUser)Session[CommonStr.session_user]).userId;
jsonStr = new MainPage().getPageJson(plant);
//ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert(1);window.onload = show('" + jsonStr + "')", true); //添加数据
functionNos = new SysManage().qryFunctionNos(userId);
}
protected void Page_Load(object sender, EventArgs e)
{
String plantId = Request.QueryString["plantId"];
string DBName = BeanTools.getPlantDB(plantId).realTimeDB;
Plant plant = BeanTools.getPlantDB(plantId);
list = new ArtTch().loadEquipmentFuntion(plant);
string userId = ((SysUser)Session[CommonStr.session_user]).userId;
functionList = new SysManage().qryFunctionNodeWithArt(userId);
}
/// <summary>
/// 报警次数统计
/// </summary>
/// <param name="dt"></param>
/// <param name="sheet"></param>
/// <param name="row"></param>
/// <param name="datastyle"></param>
/// <param name="datafont"></param>
/// <param name="style"></param>
/// <param name="font"></param>
/// <param name="rowIndex"></param>
public static void fillStatisData(DataTable dt, ISheet sheet, IRow row, ICellStyle datastyle, IFont datafont, ICellStyle style, IFont font, int rowIndex)
{
//设置列宽
sheet.SetColumnWidth(0, 4500);
sheet.SetColumnWidth(1, 4500);
sheet.SetColumnWidth(2, 10000);
//设置行高
sheet.DefaultRowHeight = 350;
//表头数据
ICell cell0 = row.CreateCell(0);
cell0.SetCellValue("位号");
cell0.CellStyle = style;
ICell cell1 = row.CreateCell(1);
cell1.SetCellValue("次数");
cell1.CellStyle = style;
ICell cell2 = row.CreateCell(2);
cell2.SetCellValue("描述");
cell2.CellStyle = style;
//填充数据
if (null != dt)
{
foreach (DataRow dr in dt.Rows)
{
rowIndex++;
row = sheet.CreateRow(rowIndex);
cell0 = row.CreateCell(0);
cell0.SetCellValue(BeanTools.ObjectToString(dr["alarmmanager_history_items"]));
cell0.CellStyle = datastyle;
cell1 = row.CreateCell(1);
cell1.SetCellValue(BeanTools.ObjectToString(dr["statisNo"]));
cell1.CellStyle = datastyle;
cell1.CellStyle.Alignment = HorizontalAlignment.LEFT;
cell2 = row.CreateCell(2);
cell2.SetCellValue(BeanTools.ObjectToString(dr["alarmmanager_describe"]));
cell2.CellStyle = datastyle;
}
}
}
public String functionNos = ""; //主页要显示的各功能表单 形式如002,003；002代表工艺检测
protected void Page_Load(object sender, EventArgs e)
{
String plantId = Request.QueryString["plantId"];
string userId = ((SysUser)Session[CommonStr.session_user]).userId;
string DBName = BeanTools.getPlantDB(plantId).realTimeDB;
plantName = BeanTools.getPlantDB(plantId).organtreeName;
Plant plant = BeanTools.getPlantDB(plantId);
jsonStr = new MainPage().getPageJson(plant);
functionNos = new SysManage().qryFunctionNos(userId);
}
protected void Page_Load(object sender, EventArgs e)
{
List <TreeNode> treeList = new List <TreeNode>();
SysManage sysManage = new SysManage();
treeList = sysManage.qryHeadOrganNode();
headOrganJson = BeanTools.ToJson(treeList);
if (null != BeanTools.ToJson(treeList))
{
headOrganJson = System.Text.RegularExpressions.Regex.Replace(headOrganJson, "isChecked", "checked");
}
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime time = DateTime.Now;
endTime = time.ToString("yyyy-MM-dd HH:mm:ss");
startTime = time.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss");
String plantId = Request.QueryString["plantId"];
string DBName = BeanTools.getPlantDB(plantId).realTimeDB;
Plant plant = BeanTools.getPlantDB(plantId);
string userId = ((SysUser)Session[CommonStr.session_user]).userId;
jsonStr = new MainPage().getNewPageJson(plant);
functionNos = new SysManage().qryFunctionNos(userId);
}
/// <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);
}
protected void Page_Load(object sender, EventArgs e)
{
String modelId = Request.QueryString["modelId"];
string plantId = Request.QueryString["plantId"];
Plant plant = BeanTools.getPlantDB(plantId);
String DBName = plant.realTimeDB;
String hisDBName = plant.historyDB;
try
{
Equipment equip = Common.getClickProcess(modelId, plant, plantId);
dataStr[0] = new ArtTch().unusualConNode(equip.monitorObject_Name, plant);
dataStr[1] = equip.monitorObject_Url;
}
catch
{ }
}
protected void Page_Load(object sender, EventArgs e)
{
roleId = Request.QueryString["roleId"];
List <TreeNode> treeList = new List <TreeNode>();
SysManage sysManage = new SysManage();
treeList = sysManage.qrtHeadMenuTree(roleId);
headMenuJson = BeanTools.ToJson(treeList);
if (null != headMenuJson)
{
headMenuJson = System.Text.RegularExpressions.Regex.Replace(headMenuJson, "isChecked", "checked");
}
plantList = sysManage.qryPlantByRole(roleId);
}
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);
}
//public string[] id2ModelId = { "7750", "7879", "7960", "7993", "8038", "7807", "7852", "9501", "9534", "9579", "8188", "8317", "8398", "8431", "8476",
// "8245", "8626", "8755", "8836", "8869", "8914", "8683", "9064", "9193", "9274", "9307", "9352", "9121"};
protected void Page_Load(object sender, EventArgs e)
{
String modelId = Request.QueryString["modelId"];
modelId = null == modelId ? "" : modelId;
String plantId = Request.QueryString["plantCode"];
plantId = null == plantId ? "" : plantId;
string DBName = BeanTools.getPlantDB(plantId).historyDB; //数据库名
Plant plant = BeanTools.getPlantDB(plantId);
//关键变量状态
IList list = new ArrayList();
list = new AlarmAnalysis().ftaModelTags(plant, modelId);
pcaModelJson = BeanTools.ToJson(list);
string ftaStateTemp = "";
ftaStateTemp = new AlarmAnalysis().FaultTreeResultById(plant, modelId);
ftaState = ftaStateTemp.Split(',')[0];
ftaStateStartTime = ftaStateTemp.Split(',')[1];
ftaName = ftaStateTemp.Split(',')[2];
ftaJson = new AlarmAnalysis().FaultTreeJsonById(plant, modelId);
FileStream fs = new FileStream(Request.PhysicalApplicationPath + "aspx\\FT_Jsons\\" + modelId + ".html", FileMode.OpenOrCreate, FileAccess.ReadWrite);
StreamWriter m_StreamWriter = new StreamWriter(fs);
m_StreamWriter.BaseStream.Seek(0, SeekOrigin.Begin);
m_StreamWriter.Write(ftaJson);
m_StreamWriter.Flush();
m_StreamWriter.Close();
fs.Close();
//ftaJson = BeanTools.ToJson(ftaJson);
EasyUIData grid = new AlarmAnalysis().ftaAbnormalHistory(plant, "" + (int.Parse(modelId) + 1));
ftaHistory = BeanTools.ToJson(grid);
}
protected void Page_Load(object sender, EventArgs e)
{
String userId = ((SysUser)Session[CommonStr.session_user]).userId;
String plantIds = new SysManage().qryPlantsByUserId(userId);
plantList = new MainPage().qryPlantList(plantIds);
TreeNode headNode = new TreeNode();
for (int i = 0; i < plantList.Count; i++)
{
Plant plant = (Plant)plantList[i];
TreeNode node = new TreeNode();
if ("1".Equals(plant.level))
{
headNode.id = plant.organtreeCode;
headNode.text = plant.organtreeName;
headNode.state = "open";
headNode.attributes = "0:root";
headNode.iconCls = "sysMan_organ";
}
else
{
node.id = plant.id;
node.text = plant.organtreeName;
node.state = "open";
node.attributes = "0:plant";
node.iconCls = "sysMan_plant_click";
headNode.children.Add(node);
}
}
List <TreeNode> treeList = new List <TreeNode>();
treeList.Add(headNode);
headMenuJson = BeanTools.ToJson(treeList);
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime time = DateTime.Now;
string plantId = Request.QueryString["plantId"];
String DBName = BeanTools.getPlantDB(plantId).historyDB;; //数据库名
Plant plant = BeanTools.getPlantDB(plantId);
endTime = Request.QueryString["endTime"];
endTime = null == endTime?time.ToString("yyyy-MM-dd HH:mm:ss") : endTime;
startTime = Request.QueryString["startTime"];
startTime = null == startTime?time.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss") : startTime;
compAnaly = new AlarmAnalysis().comprehensiveAnaysis(startTime, endTime, plant);
string pageid = Request.QueryString["sys_menu_code"];
string userId = ((SysUser)Session[CommonStr.session_user]).userId;
list = new SysManage().qryListLimit(userId, pageid);
}
/// <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);
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime time = DateTime.Now;
String plantId = Request.QueryString["plantId"];
plantId = null == plantId ? "" : plantId;
string DBName = BeanTools.getPlantDB(plantId).historyDB; //数据库名
Plant plant = BeanTools.getPlantDB(plantId);
string midTime = Request.QueryString["time"];
if (!string.IsNullOrEmpty(midTime))
{
time = Convert.ToDateTime(midTime);
endTime = time.AddHours(6).ToString("yyyy-MM-dd HH:mm:ss");
startTime = time.AddHours(-6).ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
endTime = Request.QueryString["endTime"];
endTime = null == endTime?time.ToString("yyyy-MM-dd HH:mm:ss") : endTime;
startTime = Request.QueryString["startTime"];
startTime = null == startTime?time.AddHours(-12).ToString("yyyy-MM-dd HH:mm:ss") : startTime;
}
String tableName = Request.QueryString["tableName"];
tableName = null == tableName ? "" : tableName; //表名
String tagId = Request.QueryString["tagId"];
tagId = null == tagId ? "" : tagId; //仪器主键
chartStr = new AlarmAnalysis().alarmMonitorchartLine(plant, startTime, endTime, tableName, tagId);
}
protected void Page_Load(object sender, EventArgs e)
{
String userId = ((SysUser)Session[CommonStr.session_user]).userId;
String plantIds = new SysManage().qryPlantsByUserId(userId);
plantList = new MainPage().qryPlantList(plantIds);
TreeNode headNode = new TreeNode();
for (int i = 0; i < plantList.Count; i++)
{
Plant plant = (Plant)plantList[i];
TreeNode node = new TreeNode();
if ("1".Equals(plant.level))
{
headNode.id = plant.organtreeCode;
headNode.text = plant.organtreeName;
headNode.state = "open";
headNode.attributes = "0:root";
headNode.iconCls = "sysMan_organ";
}
else
{
node.id = plant.id;
node.text = plant.organtreeName;
node.state = "closed";
node.attributes = "3:plant";
node.iconCls = "sysMan_plant_click";
TreeNode bjgzNode = new TreeNode();
bjgzNode.id = "bjgz#" + plant.id;
bjgzNode.text = "报警规则";
bjgzNode.state = "closed";
bjgzNode.attributes = "4:gz";
bjgzNode.iconCls = "sysMan_gztype";
List <TreeNode> specialList = AddSpecialNode(bjgzNode.id);
bjgzNode.children.AddRange(specialList);
node.children.Add(bjgzNode);
TreeNode yjgzNode = new TreeNode();
yjgzNode.id = "yjgz#" + plant.id;
yjgzNode.text = "预警规则";
yjgzNode.state = "closed";
yjgzNode.attributes = "4:gz";
yjgzNode.iconCls = "sysMan_gztype";
List <TreeNode> yjspecialList = AddSpecialNode(yjgzNode.id);
yjgzNode.children.AddRange(yjspecialList);
node.children.Add(yjgzNode);
TreeNode ycgzNode = new TreeNode();
ycgzNode.id = "ycgz#" + plant.id;
ycgzNode.text = "异常规则";
ycgzNode.state = "closed";
ycgzNode.attributes = "4:gz";
ycgzNode.iconCls = "sysMan_gztype";
List <TreeNode> ycspecialList = AddSpecialNode(ycgzNode.id);
ycgzNode.children.AddRange(ycspecialList);
node.children.Add(ycgzNode);
headNode.children.Add(node);
}
}
List <TreeNode> treeList = new List <TreeNode>();
treeList.Add(headNode);
headMenuJson = BeanTools.ToJson(treeList);
}
/// <summary>
/// 调用模板生成word
/// </summary>
/// <param name="templateFile">模板文件</param>
/// <param name="fileName">生成的具有模板样式的新文件</param>
public void ExportWordFunction()
{
try
{
#region 生成word应用程序对象
string startTime = messages[1].Replace(":", "").Replace("-", "").Replace(" ", "");
string endTime = messages[2].Replace(":", "").Replace("-", "").Replace(" ", "");
//生成word程序对象
object obj = System.Reflection.Missing.Value;
Word.Application app = new Word.Application();
//模板文件
string TemplateFile = messages[3] + "report 20150117.dot";
//生成的具有模板样式的新文件
string FileName = messages[3] + messages[0] + startTime + endTime + ".doc";
//模板文件拷贝到新文件
File.Copy(TemplateFile, FileName);
//生成documnet对象
//Word.Document doc = app.Documents.Add(ref obj,ref obj ,ref obj ,ref obj);
//Word.Document doc=app.Documents.Add(ref obj,ref obj,ref obj,ref,obj,ref obj);
Word.Document doc = new Word.Document();
object Obj_FileName = FileName;
object Visible = true;
object ReadOnly = false;
object missing = System.Reflection.Missing.Value;
//打开文件
doc = app.Documents.Open(ref Obj_FileName, ref missing, ref ReadOnly, ref missing,
ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref Visible,
ref missing, ref missing, ref missing,
ref missing);
doc.Activate();
#endregion
//赋值数据到书签的位置
System.Data.DataRow[] tempTables;
string plantName = "";
if (messages[0] == "JJSH_CJYYT")
{
plantName = "1#常减压";
}
if (messages[0] == "JJSH_CLHCJ")
{
plantName = "1#催化裂化";
}
if (messages[0] == "JJSH_YJHYT")
{
plantName = "延迟焦化";
}
if (messages[0] == "ZHLH_YCJY")
{
plantName = "1#常减压";
}
doc.Bookmarks.get_Item(ref BookMark[0]).Range.Text = plantName;//插入文本
doc.Bookmarks.get_Item(ref BookMark[1]).Range.Text = messages[1] + "---" + messages[2];
doc.Bookmarks.get_Item(ref BookMark[2]).Range.Text = plantName;
//插入表格
//文档中创建表格
Range range = doc.Bookmarks.get_Item(ref BookMark[3]).Range;//表格插入位置
Word.Table newTable = doc.Tables.Add(range, 9, 4, ref missing, ref missing);
//设置表格样式
newTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
newTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
newTable.Columns[1].Width = 70f;
newTable.Columns[2].Width = 60f;
newTable.Columns[3].Width = 60f;
newTable.Columns[4].Width = 250f;
newTable.Cell(1, 1).Range.Text = "";
newTable.Cell(1, 2).Range.Text = "当前值";
newTable.Cell(1, 3).Range.Text = "目标值";
newTable.Cell(1, 4).Range.Text = "备注";
List <AlarmLevelTotal> lists = BeanTools.getBoList <AlarmLevelTotal>(messages[4]);
for (int i = 0; i < 8; i++)
{
//填充表格内容
newTable.Cell(i + 2, 1).Range.Text = lists[i].index_name;
newTable.Cell(i + 2, 2).Range.Text = lists[i].plant_num;
newTable.Cell(i + 2, 3).Range.Text = lists[i].index_goal;
newTable.Cell(i + 2, 4).Range.Text = lists[i].remark;
}
//插入图片
doc.Bookmarks.get_Item(ref BookMark[4]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_0.png", ref missing, ref missing, ref missing);
//插入图片
doc.Bookmarks.get_Item(ref BookMark[5]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_1.png", ref missing, ref missing, ref missing);
//插入图片
doc.Bookmarks.get_Item(ref BookMark[6]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_2.png", ref missing, ref missing, ref missing);
//插入图片
doc.Bookmarks.get_Item(ref BookMark[7]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_3.png", ref missing, ref missing, ref missing);
//插入图片
doc.Bookmarks.get_Item(ref BookMark[8]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_4.png", ref missing, ref missing, ref missing);
//插入图片
doc.Bookmarks.get_Item(ref BookMark[9]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_5.png", ref missing, ref missing, ref missing);
//插入图片
doc.Bookmarks.get_Item(ref BookMark[10]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_6.png", ref missing, ref missing, ref missing);
//插入图片
doc.Bookmarks.get_Item(ref BookMark[11]).Select();
app.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.InlineShapes.AddPicture(messages[3] + messages[0] + startTime + endTime + "_7.png", ref missing, ref missing, ref missing);
//插入表格
List <AlarmTop20> lists_2 = BeanTools.getBoList <AlarmTop20>(messages[5]);
//文档中创建表格
range = doc.Bookmarks.get_Item(ref BookMark[12]).Range;//表格插入位置
newTable = doc.Tables.Add(range, 1 + lists_2.Count, 4, ref missing, ref missing);
//设置表格样式
newTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
newTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
//newTable.Columns[1].Width = 100f;
//newTable.Columns[2].Width = 100f;
//newTable.Columns[3].Width = 10f;
//newTable.Columns[4].Width = 105f;
newTable.Cell(1, 1).Range.Text = "位号";
newTable.Cell(1, 2).Range.Text = "工段";
newTable.Cell(1, 3).Range.Text = "报警次数";
newTable.Cell(1, 4).Range.Text = "占总数%";
for (int i = 0; i < lists_2.Count; i++)
{
//填充表格内容
newTable.Cell(i + 2, 1).Range.Text = lists_2[i].tagname;
newTable.Cell(i + 2, 2).Range.Text = lists_2[i].area;
newTable.Cell(i + 2, 3).Range.Text = lists_2[i].count.ToString();
newTable.Cell(i + 2, 4).Range.Text = lists_2[i].percent.ToString();
}
//插入表格
List <AlarmStanding> lists_3 = BeanTools.getBoList <AlarmStanding>(messages[6]);
//文档中创建表格
range = doc.Bookmarks.get_Item(ref BookMark[13]).Range;//表格插入位置
newTable = doc.Tables.Add(range, 1 + lists_3.Count, 5, ref missing, ref missing);
//设置表格样式
newTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
newTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
//newTable.Columns[1].Width = 100f;
//newTable.Columns[2].Width = 100f;
//newTable.Columns[3].Width = 10f;
//newTable.Columns[4].Width = 105f;
newTable.Cell(1, 1).Range.Text = "位号";
newTable.Cell(1, 2).Range.Text = "工段";
newTable.Cell(1, 3).Range.Text = "报警开始时间";
newTable.Cell(1, 4).Range.Text = "报警结束时间";
newTable.Cell(1, 5).Range.Text = "报警持续时间（分钟）";
for (int i = 0; i < lists_3.Count; i++)
{
//填充表格内容
newTable.Cell(i + 2, 1).Range.Text = lists_3[i].tagname;
newTable.Cell(i + 2, 2).Range.Text = lists_3[i].area;
newTable.Cell(i + 2, 3).Range.Text = lists_3[i].startTime;
newTable.Cell(i + 2, 4).Range.Text = lists_3[i].endTime;
newTable.Cell(i + 2, 5).Range.Text = lists_3[i].alarmInterval.ToString();
}
//插入表格
List <AlarmChattering> lists_4 = BeanTools.getBoList <AlarmChattering>(messages[7]);
//文档中创建表格
range = doc.Bookmarks.get_Item(ref BookMark[14]).Range;//表格插入位置
newTable = doc.Tables.Add(range, 1 + lists_4.Count, 5, ref missing, ref missing);
//设置表格样式
newTable.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
newTable.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
//newTable.Columns[1].Width = 100f;
//newTable.Columns[2].Width = 100f;
//newTable.Columns[3].Width = 10f;
//newTable.Columns[4].Width = 105f;
newTable.Cell(1, 1).Range.Text = "位号";
newTable.Cell(1, 2).Range.Text = "工段";
newTable.Cell(1, 3).Range.Text = "重复报警次数";
newTable.Cell(1, 4).Range.Text = "报警总次数";
newTable.Cell(1, 5).Range.Text = "重复报警率";
for (int i = 0; i < lists_4.Count; i++)
{
//填充表格内容
newTable.Cell(i + 2, 1).Range.Text = lists_4[i].tagname;
newTable.Cell(i + 2, 2).Range.Text = lists_4[i].area;
newTable.Cell(i + 2, 3).Range.Text = lists_4[i].chatteringCount.ToString();
newTable.Cell(i + 2, 4).Range.Text = lists_4[i].totalCount.ToString();
newTable.Cell(i + 2, 5).Range.Text = lists_4[i].percent.ToString();
}
//输出完毕后关闭doc对象
object IsSave = true;
doc.Close(ref IsSave, ref missing, ref missing);
}
catch (Exception Ex)
{
return;
}
}
