Exemple #1
0
        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());
        }