private void BindData() { DataTable dt_Memory = new DataTable(); DataTable dt_ProcHit = new DataTable(); DataTable dt_ProcSize = new DataTable(); cloud.w_SQLMemory(ServerNum, Convert.ToInt32(ConfigurationManager.AppSettings["ChartDataDuration"])); //dt_Memory = Func_SetColum_SqlMemory(cloud.dsReturn.Tables[0]); dt_Memory = cloud.dsReturn.Tables[0]; int numDuration = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ChartDataDuration"]); cloud.w_PCID_Instance(ServerNum, numDuration, "P091"); dt_ProcSize = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_CacheSize = Lib.ConvertingProc.GetColumname(dt_ProcSize.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P138"); dt_ProcHit = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_CacheHit = Lib.ConvertingProc.GetColumname(dt_ProcHit.Columns); //챠트바인드 List <Lib.chartProperty> cplst = new List <Lib.chartProperty>(); StringBuilder sb = new StringBuilder(); cplst = SetChartProperty(); cplst = Lib.Flotr2.SetArrayString_Lines(dt_Memory, cplst); cplst = Lib.Flotr2.SetArrayString_Lines(dt_ProcSize, cplst, "PROCCACHESIZE_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_ProcHit, cplst, "PROCCACHEHIT_LINE_CHART"); sb = Lib.Flotr2.SetStringValue(cplst, sb, ServerNum.ToString()); litScript_Pop.Text += Lib.Util.BoxingScript(sb.ToString()); }
private void BindData() { DataTable dt_DISKTIME = new DataTable(); DataTable dt_DISKIDLETIME = new DataTable(); DataTable dt_CURRENTDISKQUEUELENGTH = new DataTable(); DataTable dt_AVGDISKQUEUE = new DataTable(); DataTable dt_AVGDISKBYTESREAD = new DataTable(); DataTable dt_AVGDISKBYTESWRITE = new DataTable(); DataTable dt_FREEDISKSPACEMB = new DataTable(); DataTable dt_FREEDISKSPACEPER = new DataTable(); int numDuration = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ChartDataDuration"]); cloud.w_PCID_Instance(ServerNum, numDuration, "P015"); dt_DISKTIME = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_DISKTIME = Lib.ConvertingProc.GetColumname(dt_DISKTIME.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P190"); dt_DISKIDLETIME = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_DISKIDLETIME = Lib.ConvertingProc.GetColumname(dt_DISKIDLETIME.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P194"); dt_CURRENTDISKQUEUELENGTH = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_CURRENTDISKQUEUELENGTH = Lib.ConvertingProc.GetColumname(dt_CURRENTDISKQUEUELENGTH.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P017"); dt_AVGDISKQUEUE = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_AVGDISKQUEUE = Lib.ConvertingProc.GetColumname(dt_AVGDISKQUEUE.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P191"); dt_AVGDISKBYTESREAD = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_AVGDISKBYTESREAD = Lib.ConvertingProc.GetColumname(dt_AVGDISKBYTESREAD.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P193"); dt_AVGDISKBYTESWRITE = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_AVGDISKBYTESWRITE = Lib.ConvertingProc.GetColumname(dt_AVGDISKBYTESWRITE.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P018"); dt_FREEDISKSPACEMB = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_FREEDISKSPACEMB = Lib.ConvertingProc.GetColumname(dt_FREEDISKSPACEMB.Columns); cloud.w_PCID_Instance(ServerNum, numDuration, "P164"); dt_FREEDISKSPACEPER = Lib.ConvertingProc.Pivot(cloud.dsReturn.Tables[0], "Instancename", "TimeIn", "PValue"); strColumn_FREEDISKSPACEPER = Lib.ConvertingProc.GetColumname(dt_FREEDISKSPACEPER.Columns); //챠트바인드 List <Lib.chartProperty> cplst = new List <Lib.chartProperty>(); StringBuilder sb = new StringBuilder(); cplst = SetChartProperty(); cplst = Lib.Flotr2.SetArrayString_Lines(dt_DISKTIME, cplst, "DISKTIME_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_DISKIDLETIME, cplst, "DISKIDLETIME_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_CURRENTDISKQUEUELENGTH, cplst, "CURRENTDISKQUEUELENGTH_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_AVGDISKQUEUE, cplst, "AVGDISKQUEUE_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_AVGDISKBYTESREAD, cplst, "AVGDISKBYTESREAD_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_AVGDISKBYTESWRITE, cplst, "AVGDISKBYTESWRITE_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_FREEDISKSPACEMB, cplst, "FREEDISKSPACEMB_LINE_CHART"); cplst = Lib.Flotr2.SetArrayString_Lines(dt_FREEDISKSPACEPER, cplst, "FREEDISKSPACEPER_LINE_CHART"); sb = Lib.Flotr2.SetStringValue(cplst, sb, ServerNum.ToString()); litScript_Pop.Text += Lib.Util.BoxingScript(sb.ToString()); }