private void UgrdView_Bind() { MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info(); DataSet rDs = objBSC.GetAllList(); ugrdView.Clear(); if (rDs.Tables.Count > 0) { ugrdView.DataSource = rDs; ugrdView.DataBind(); } }
private void ViewInfo_ddlBind() { MicroBSC.BSC.Biz.Biz_Bsc_View_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info(); DataSet rDs = objBSC.GetAllList(); ddlStgViewInfo.Items.Add(new ListItem(":: 전체 ::", "0")); if (rDs.Tables.Count > 0) { for (int i = 0; i < rDs.Tables[0].Rows.Count; i++) { ddlStgViewInfo.Items.Add(new ListItem(rDs.Tables[0].Rows[i]["VIEW_NAME"].ToString(), rDs.Tables[0].Rows[i]["VIEW_REF_ID"].ToString())); } } }
private void SetKpiStatusGraph2() { MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card(); DataSet dsGraph = new DataSet(); List <string> listYMDs = new List <string>(); Chart objChart = this.chtPart; //dsGraph = TempData3(); //관점별 1년치데이타 foreach (string str in GetBeforeMonth(listYMDs)) { dsGraph.Merge(objBSC.GetEstDeptKpiViewTypeList(this.IEstTermRefID , str , this.ISumType , this.IEstDeptID)); } dsGraph.AcceptChanges(); dsGraph = this.ModifyData(dsGraph); foreach (DataRow dr in dsGraph.Tables[0].Rows) { dr["YMD"] = string.Format("{0}년{1}월", dr["YMD"].ToString().Substring(0, 4), DataTypeUtility.GetToInt32(dr["YMD"].ToString().Substring(4, 2))); } if (dsGraph.Tables[0].Rows.Count > 0) { DundasCharts.DundasChartBase(objChart , ChartImageType.Png , 680 , 130 , BorderSkinStyle.Emboss , Color.FromArgb(181, 64, 1) , 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0x20, 0x80, 0xD0) , ChartDashStyle.Solid , -1 , ChartHatchStyle.None , GradientType.TopBottom , AntiAliasing.None); objChart.DataSource = dsGraph; objChart.Series.Clear(); MicroBSC.BSC.Biz.Biz_Bsc_View_Info objViewInfo = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info(); DataSet rDs = objViewInfo.GetAllList(); if (rDs.Tables != null && rDs.Tables[0].Rows.Count == 4) { Series series4 = DundasCharts.CreateSeries(objChart, "sp1", "Default", rDs.Tables[0].Rows[0]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 224, 64, 10), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64)); Series series1 = DundasCharts.CreateSeries(objChart, "sp2", "Default", rDs.Tables[0].Rows[1]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 192, 192, 192), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64)); Series series3 = DundasCharts.CreateSeries(objChart, "sp3", "Default", rDs.Tables[0].Rows[2]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(objChart, "sp4", "Default", rDs.Tables[0].Rows[3]["VIEW_NAME"].ToString(), null, SeriesChartType.Area, 1, Color.FromArgb(240, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 9, Color.FromArgb(64, 64, 64)); series1.ValueMembersY = "ACHV_RATE1"; series2.ValueMembersY = "ACHV_RATE2"; series3.ValueMembersY = "ACHV_RATE3"; series4.ValueMembersY = "ACHV_RATE4"; series1.ValueMemberX = "YMD"; foreach (Series series in objChart.Series) { objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisX.Margin = false; objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False; objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY.Interval = 30; series.Href = HttpContext.Current.Request.Url.ToString().Substring(0 , HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0404S1.ASPX"; } objChart.DataBind(); } } }
private void DrawMapTreeDetail(TreeView iTrvMap, int iEstTermRefID, int iEstDeptRefID, int iMapVersionID, string iSelectedKey) { int cntRow = 0; int cntStg = 0; int cntKpi = 0; string strKey = ""; string strVal = ""; strKey = "D" + ";" + Convert.ToString(this.IEstDeptRefID) + ";0"; strVal = this.IEstDeptName + " 전략맵"; TreeNode topNode = new TreeNode(strVal, strKey); iTrvMap.Nodes.Clear(); iTrvMap.Nodes.Add(topNode); topNode.ImageUrl = "../images/stg/TREE_D.gif"; TreeNode vNode; MicroBSC.BSC.Biz.Biz_Bsc_View_Info objView = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info(); DataSet dsView = objView.GetAllList(); TreeNode sNode; MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg objSTG = new Biz_Bsc_Map_Stg(); DataSet dsSTG = new DataSet(); TreeNode kNode; MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKPI = new Biz_Bsc_Map_Kpi(); DataSet dsKPI = new DataSet(); cntRow = dsView.Tables[0].Rows.Count; for (int i = 0; i < cntRow; i++) { string imgWork = "<img alt='' src='../images/stg/TREE_W.gif'/>"; string imgExec = "<img alt='' src='../images/stg/TREE_E.gif'/>"; strKey = "V" + ";" + dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString() + ";0"; strVal = dsView.Tables[0].Rows[i]["VIEW_NAME"].ToString(); vNode = new TreeNode(strVal, strKey); vNode.ImageUrl = "../images/stg/TREE_V.gif"; topNode.ChildNodes.Add(vNode); if (iSelectedKey == strKey) { vNode.Select(); vNode.ExpandAll(); vNode.SelectAction = TreeNodeSelectAction.Select; } int stgrefid = 0; int kpirefid = 0; dsSTG = objSTG.GetStrategyPerView(IEstTermRefID, IEstDeptRefID, IMapVersionID, int.Parse(dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString())); cntStg = dsSTG.Tables[0].Rows.Count; for (int j = 0; j < cntStg; j++) { strKey = "S" + ";" + dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString() + ";0"; stgrefid = Convert.ToInt32(dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString()); kpirefid = 0; strVal = dsSTG.Tables[0].Rows[j]["STG_NAME"].ToString() + (WorkCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgWork : "") + (ExecCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgExec : ""); sNode = new TreeNode(strVal, strKey); sNode.ImageUrl = "../images/stg/TREE_S.gif"; vNode.ChildNodes.Add(sNode); if (iSelectedKey == strKey) { sNode.Select(); sNode.ExpandAll(); sNode.SelectAction = TreeNodeSelectAction.Select; } dsKPI = objKPI.GetKpiListPerStg(IEstTermRefID, IEstDeptRefID, IMapVersionID, int.Parse(dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString())); cntKpi = dsKPI.Tables[0].Rows.Count; for (int k = 0; k < cntKpi; k++) { strKey = "K" + ";" + dsKPI.Tables[0].Rows[k]["KPI_REF_ID"].ToString() + ";" + dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString(); kpirefid = Convert.ToInt32(dsKPI.Tables[0].Rows[k]["KPI_REF_ID"].ToString()); strVal = dsKPI.Tables[0].Rows[k]["KPI_NAME"].ToString() + (WorkCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgWork : "") + (ExecCount(IEstTermRefID, IEstDeptRefID, stgrefid, kpirefid) ? imgExec : ""); kNode = new TreeNode(strVal, strKey); kNode.ImageUrl = "../images/stg/TREE_K.gif"; sNode.ChildNodes.Add(kNode); if (iSelectedKey == strKey) { kNode.Select(); kNode.ExpandAll(); kNode.SelectAction = TreeNodeSelectAction.Select; } } } } if (iTrvMap.SelectedNode == null) { topNode.Select(); } iTrvMap.ExpandAll(); }
private void SetKpiStatusGraph2() { MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card(); DataSet dsGraph = new DataSet(); List <string> listYMDs = new List <string>(); Dundas.Charting.WebControl.Chart objChart = this.chtPart; //dsGraph = TempData3(); //관점별 1년치데이타 foreach (string str in GetBeforeMonth(listYMDs)) { dsGraph.Merge(objBSC.GetEstDeptKpiViewTypeList (this.IEstTermRefID , str , this.ISumType , this.IEstDeptID)); } dsGraph.AcceptChanges(); dsGraph = this.ModifyData(dsGraph); if (dsGraph.Tables[0].Rows.Count > 0) { DundasCharts.DundasChartBase(objChart , Dundas.Charting.WebControl.ChartImageType.Flash , 680, 180 , Dundas.Charting.WebControl.BorderSkinStyle.None , Color.FromArgb(181, 64, 1) , 1 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0x20, 0x80, 0xD0) , Dundas.Charting.WebControl.ChartDashStyle.Solid , -1 , Dundas.Charting.WebControl.ChartHatchStyle.None , Dundas.Charting.WebControl.GradientType.TopBottom , Dundas.Charting.WebControl.AntiAliasing.None); objChart.DataSource = dsGraph; objChart.Series.Clear(); MicroBSC.BSC.Biz.Biz_Bsc_View_Info objViewInfo = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info(); DataSet rDs = objViewInfo.GetAllList(); if (rDs.Tables != null && rDs.Tables[0].Rows.Count == 4) { Dundas.Charting.WebControl.Series series1 = DundasCharts.CreateSeries(objChart, "sp1", "AreaView", rDs.Tables[0].Rows[0]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 224, 64, 10), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64)); Dundas.Charting.WebControl.Series series2 = DundasCharts.CreateSeries(objChart, "sp2", "AreaView", rDs.Tables[0].Rows[1]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 192, 192, 192), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64)); Dundas.Charting.WebControl.Series series3 = DundasCharts.CreateSeries(objChart, "sp3", "AreaView", rDs.Tables[0].Rows[2]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 65, 140, 240), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64)); Dundas.Charting.WebControl.Series series4 = DundasCharts.CreateSeries(objChart, "sp4", "AreaView", rDs.Tables[0].Rows[3]["VIEW_NAME"].ToString(), null, Dundas.Charting.WebControl.SeriesChartType.Line, 1, Color.FromArgb(240, 252, 180, 65), Color.FromArgb(180, 26, 59, 105), Color.Transparent, 1, 5, Color.FromArgb(64, 64, 64)); series1.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle; series2.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle; series3.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle; series4.MarkerStyle = Dundas.Charting.WebControl.MarkerStyle.Circle; series1.MarkerBorderColor = Color.FromArgb(240, 224, 64, 10); series1.MarkerColor = Color.FromArgb(240, 224, 64, 10); series2.MarkerBorderColor = Color.FromArgb(240, 192, 192, 192); series2.MarkerColor = Color.FromArgb(240, 192, 192, 192); series3.MarkerBorderColor = Color.FromArgb(240, 65, 140, 240); series3.MarkerColor = Color.FromArgb(240, 65, 140, 240); series4.MarkerBorderColor = Color.FromArgb(240, 252, 180, 65); series4.MarkerColor = Color.FromArgb(240, 252, 180, 65); series1.ValueMembersY = "ACHV_RATE1"; series2.ValueMembersY = "ACHV_RATE2"; series3.ValueMembersY = "ACHV_RATE3"; series4.ValueMembersY = "ACHV_RATE4"; series1.ValueMemberX = "YMD"; foreach (Dundas.Charting.WebControl.Series series in objChart.Series) { //objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisX.Margin = false; //objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False; //objChart.ChartAreas[objChart.Series[series.Name].ChartArea].AxisY.Interval = 30; //series.Url = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0404S1.ASPX"; } DundasAnimations.DundasChartBase(objChart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(objChart, series1, 0.5, 2.0, true); DundasAnimations.GrowingAnimation(objChart, series2, 0.5, 2.0, true); DundasAnimations.GrowingAnimation(objChart, series3, 0.5, 2.0, true); DundasAnimations.GrowingAnimation(objChart, series4, 0.5, 2.0, true); objChart.DataBind(); } } }