/// <summary> /// /// </summary> /// <returns></returns> public void SecondDBInit(int DeviceID, DateTime begin, DateTime end) { ReportSeachWhereOR whereOR = new ReportSeachWhereOR(); whereOR.StartTime = begin; whereOR.EndTime = end; DeviceOR devObj = new DeviceDA().SelectDeviceORByID(DeviceID.ToString()); if (devObj == null) { throw new Exception("设备不存!"); } List<int> ListDevs = new List<int>(); ListDevs.Add(devObj.DeviceID); //获取数据库设备 whereOR.ListDevices = GetBussDataBase(DeviceID); // whereOR.DeviceName = devObj.DeviceName; // whereOR.DeviceType = devObj.DeviceTypeID; whereOR.StationID = devObj.StationID; whereOR.ReportType = "day"; whereOR.ListChanncel = new List<SearchChanncelOR>() { new SearchChanncelOR(){ ChanncelNo= 42109}//--连接数 ,new SearchChanncelOR(){ ChanncelNo= 42105}//--%可用 ,new SearchChanncelOR(){ ChanncelNo= 41601} //缓冲器 ,new SearchChanncelOR(){ ChanncelNo= 41602} //数据字典 ,new SearchChanncelOR(){ ChanncelNo= 41603} //库 ,new SearchChanncelOR(){ ChanncelNo= 41101} //连接时间 }; PDFReportSearch DataDA = new PDFReportSearch(); DataDA.SearchReportDataToTemp(whereOR); }
public void SecondMiddlewareInit(int DeviceID, DateTime begin, DateTime end) { ReportSeachWhereOR whereOR = new ReportSeachWhereOR(); whereOR.StartTime = begin; whereOR.EndTime = end; DeviceOR devObj = new DeviceDA().SelectDeviceORByID(DeviceID.ToString()); if (devObj == null) { throw new Exception("设备不存!"); } List<int> ListDevs = new List<int>(); ListDevs.Add(devObj.DeviceID); //获取中间件 whereOR.ListDevices = GetBussMiddleware(DeviceID); whereOR.StationID = devObj.StationID; whereOR.ReportType = "day"; /* * web 活动会话数 21102 * 数据库连接池 活动连接 22603 * 当前 JVM堆大小(kb) 22505 * */ whereOR.ListChanncel = new List<SearchChanncelOR>() { new SearchChanncelOR(){ ChanncelNo= 21102}//--活动会话数 ,new SearchChanncelOR(){ ChanncelNo= 22603}//--活动连接 ,new SearchChanncelOR(){ ChanncelNo= 22505} //JVM堆大小 }; PDFReportSearch DataDA = new PDFReportSearch(); DataDA.SearchReportDataToTemp(whereOR); }
/// <summary> /// /// </summary> /// <returns></returns> public void InitHostInfo(int DeviceID, DateTime begin, DateTime end) { ReportSeachWhereOR whereOR = new ReportSeachWhereOR(); whereOR.StartTime = begin; whereOR.EndTime = end; DeviceOR devObj = new DeviceDA().SelectDeviceORByID(DeviceID.ToString()); if (devObj == null) { throw new Exception("设备不存!"); } List<int> ListDevs = new List<int>(); ListDevs.Add(devObj.DeviceID); //获取数据库设备 whereOR.ListDevices = GetBussDataHost(DeviceID); whereOR.StationID = devObj.StationID; whereOR.ReportType = "day"; whereOR.ListChanncel = new List<SearchChanncelOR>() { new SearchChanncelOR(){ ChanncelNo= 25201}//--主机CPU利用率 ,new SearchChanncelOR(){ ChanncelNo= 25202}//--内存压力 ,new SearchChanncelOR(){ ChanncelNo= 25203} //磁盘 }; PDFReportSearch DataDA = new PDFReportSearch(); DataDA.SearchReportDataToTemp(whereOR); }