public void SetDashBoardKpiGrid() { MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard(); DataSet rDs = objBSC.GetDashBoardKpiList(this.IEstTermRefID); ugrdKPIPool.Clear(); ugrdKPIPool.DataSource = rDs.Tables[0].DefaultView; ugrdKPIPool.DataBind(); //lblCountRow.Text = "Total Rows : " + ds.Tables[0].Rows.Count.ToString(); }
protected int RemoveKpiDashBoard() { CheckBox chk; UltraGridRow row; TemplatedColumn col; bool isOK = false; string isSuccessed = "0"; int intTxrUser = gUserInfo.Emp_Ref_ID; int intRtn = 0; int intRow = ugrdKPIPool.Rows.Count; MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard(); for (int i = 0; i < intRow; i++) { row = ugrdKPIPool.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox"); if (chk.Checked) { chk.Checked = false; //ltrScript.Text = JSHelper.GetAlertScript("그룹을 선택해주십시오.", false); int iKpiCode = Convert.ToInt32(row.Cells.FromKey("KPI_REF_ID").Value.ToString()); int iEstterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo); int iuser = intTxrUser; intRtn += objBSC.DeleteData(iEstterm_ref_id , iKpiCode , gUserInfo.Emp_Ref_ID); } } return(intRtn); }
private void SetKpiStatusGraph() { this.SetParameter(this.IEstDeptID); MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard(); DataSet rDs = objBSC.GetAllList(this.IEstTermRefID); int cntRow = 0; int cntCol = 0; int intEsttermRefID = 0; int intKpiRefID = 0; string strTrendType = ""; string strKpiName = ""; string strTypeName = ""; cntRow = rDs.Tables[0].Rows.Count; cntCol = rDs.Tables[0].Columns.Count; Chart objChart = null; for (int i = 0; i < cntRow; i++) { intEsttermRefID = Convert.ToInt32(rDs.Tables[0].Rows[i]["ESTTERM_REF_ID"].ToString()); intKpiRefID = Convert.ToInt32(rDs.Tables[0].Rows[i]["KPI_REF_ID"].ToString()); strTrendType = Convert.ToString(rDs.Tables[0].Rows[i]["SELECT_TYPE"].ToString()); strKpiName = Convert.ToString(rDs.Tables[0].Rows[i]["KPI_NAME"].ToString()); strTypeName = Convert.ToString(rDs.Tables[0].Rows[i]["SELECT_TYPE_NAME"].ToString()); DataSet dsGraph = objBSC.GetDashBoardForKpiAnalysis(intEsttermRefID , intKpiRefID , this.IYmd , "99999999" , this.ISumType); switch (i) { case 0: objChart = chtKPI1; objChart.Visible = true; break; case 1: objChart = chtKPI2; objChart.Visible = true; break; case 2: objChart = chtKPI3; objChart.Visible = true; break; case 3: objChart = chtKPI4; objChart.Visible = true; break; case 4: objChart = chtKPI5; objChart.Visible = true; break; case 5: objChart = chtKPI6; objChart.Visible = true; break; default: return; } DundasCharts.DundasChartBase(objChart , ChartImageType.Flash , 300 , 100 , BorderSkinStyle.Emboss, Color.FromArgb(26, 59, 105), 2 , Color.FromArgb(211, 223, 240) , Color.FromArgb(255, 255, 255) , Color.FromArgb(37, 58, 118) , ChartDashStyle.Solid , -1 , ChartHatchStyle.None , GradientType.TopBottom , AntiAliasing.None); Series serKpi = DundasCharts.CreateSeries(objChart , strTypeName , objChart.ChartAreas[0].Name , strTypeName , null , SeriesChartType.FastLine , 2 , GetSignalColor(i) , GetChartColor(i) , Color.FromArgb(64, 0, 0, 0) , 1 , 9 , Color.FromArgb(64, 64, 64)); objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].AxisX.Interval = 4; objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].Area3DStyle.Enable3D = false; objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].AxisY2.Enabled = AxisEnabled.False; objChart.ChartAreas[objChart.Series[serKpi.Name].ChartArea].AxisY.LabelStyle.Format = "#,##0"; //string strHerf = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) // + "/BSC0304S2.aspx?" // + "ESTTERM_REF_ID=" + intEsttermRefID.ToString() // + "&KPI_REF_ID=" + intKpiRefID.ToString() // + "&YMD=" + this.IYmd; string strURL = "gfOpenWindow('../BSC/BSC0304S2.aspx?iType=POP&ESTTERM_REF_ID=" + intEsttermRefID.ToString() + "&KPI_REF_ID=" + intKpiRefID.ToString() + "&YMD=" + this.IYmd + ", 840, 600, 'no', 'no');"; string strHerf = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + strURL; objChart.DataSource = dsGraph; serKpi.ValueMembersY = "RESULT_VALUE"; serKpi.ValueMemberX = "YMD"; objChart.DataBind(); objChart.Legends[0].Enabled = false; objChart.Titles[0].Text = strKpiName; objChart.Titles[0].Href = strHerf; dsGraph = null; serKpi = null; objChart = null; } }
protected int SaveDashBoardKpi() { CheckBox chk; UltraGridRow row; TemplatedColumn col; bool isOK = false; string isSuccessed = "0"; int intTxrUser = gUserInfo.Emp_Ref_ID; int intRtn = 0; int intRow = ugrdKPIPool.Rows.Count; MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard(); DropDownList ddlTempSelectType; TemplatedColumn selecttype_col = (TemplatedColumn)ugrdKPIPool.Columns.FromKey("SELECT_TYPE"); DropDownList ddlTempGraphType; TemplatedColumn graphtype_col = (TemplatedColumn)ugrdKPIPool.Columns.FromKey("GRAPH_TYPE"); DropDownList ddlTempSortOrder; TemplatedColumn sortorder_col = (TemplatedColumn)ugrdKPIPool.Columns.FromKey("SORT_ORDER"); for (int i = 0; i < intRow; i++) { row = ugrdKPIPool.Rows[i]; col = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox"); if (true) { chk.Checked = false; int iKpiCode = Convert.ToInt32(row.Cells.FromKey("KPI_REF_ID").Value.ToString()); int iEstterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo); ddlTempSelectType = (DropDownList)((CellItem)selecttype_col.CellItems[ugrdKPIPool.Rows[i].BandIndex]).FindControl("ddlSelectType"); //string iSelect_type = row.Cells.FromKey("SELECT_TYPE").ToString(); ddlTempGraphType = (DropDownList)((CellItem)graphtype_col.CellItems[ugrdKPIPool.Rows[i].BandIndex]).FindControl("ddlGraphType"); //string iGraph_type = Convert.ToString(row.Cells.FromKey("GRAPH_TYPE").Value); ddlTempSortOrder = (DropDownList)((CellItem)sortorder_col.CellItems[ugrdKPIPool.Rows[i].BandIndex]).FindControl("ddlSortOrder"); // int iSort_order = Convert.ToInt32(row.Cells.FromKey("SORT_ORDER").Value.ToString()); int iuser = intTxrUser; intRtn += objBSC.UpdateData(iEstterm_ref_id , iKpiCode , ddlTempSelectType.SelectedValue , ddlTempGraphType.SelectedValue , Convert.ToInt32(ddlTempSortOrder.SelectedValue) , gUserInfo.Emp_Ref_ID); } } return(intRtn); }
//private void SetResultGrid() //{ // Biz_Bsc_Kpi_Info objBSC = new Biz_Bsc_Kpi_Info(); // DataSet ds = objBSC.GetKpiListForResultAnalysis(this.IEstTermRefID // , this.IYmd // , "" // , "" // , "" // , "" // , this.IDeptID // , 1 // 우수 // , this.ISumType // , "" // , ""); // if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) // { // ds.Tables[0].Columns.Add("RANK", typeof(int)); // ds.Tables[0].Columns.Add("SORT_TYPE", typeof(string)); // DataTable dataTable = null; // // 순위정렬 성격에 따라 처리 내용 // dataTable = PageUtility.FilterSortData(ds.Tables[0], "", "ACHIEVE_RATE_DIFF DESC"); // SetRowNum(dataTable, "H"); // // DataRow 삭제 // DeleteExtraRowsByRowNum(dataTable, 10); // ugrdResultStatus.Clear(); // ugrdResultStatus.DataSource = dataTable; // ugrdResultStatus.DataBind(); // } //} private void SetKpiStatusGraph() { this.SetParameter(); MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Dashboard(); DataSet rDs = objBSC.GetAllList(this.IEstTermRefID); int cntRow = 0; int cntCol = 0; int intEsttermRefID = 0; int intKpiRefID = 0; string strTrendType = ""; string strKpiName = ""; string strTypeName = ""; cntRow = rDs.Tables[0].Rows.Count; cntCol = rDs.Tables[0].Columns.Count; Dundas.Charting.WebControl.Chart objChart = null; for (int i = 0; i < cntRow; i++) { intEsttermRefID = Convert.ToInt32(rDs.Tables[0].Rows[i]["ESTTERM_REF_ID"].ToString()); intKpiRefID = Convert.ToInt32(rDs.Tables[0].Rows[i]["KPI_REF_ID"].ToString()); strTrendType = Convert.ToString(rDs.Tables[0].Rows[i]["SELECT_TYPE"].ToString()); strKpiName = Convert.ToString(rDs.Tables[0].Rows[i]["KPI_NAME"].ToString()); strTypeName = Convert.ToString(rDs.Tables[0].Rows[i]["SELECT_TYPE_NAME"].ToString()); DataSet dsGraph = objBSC.GetDashBoardForKpiAnalysis(intEsttermRefID, intKpiRefID, "00000000", this.IYmd, this.ISumType); //DataSet dsGraph = objBSC.GetDashBoardForKpiAnalysis(intEsttermRefID, intKpiRefID, this.IYmd, "99999999", this.ISumType); switch (i) { case 0: objChart = chtKPI1; objChart.Visible = true; break; case 1: objChart = chtKPI2; objChart.Visible = true; break; case 2: objChart = chtKPI3; objChart.Visible = true; break; case 3: objChart = chtKPI4; objChart.Visible = true; break; case 4: objChart = chtKPI5; objChart.Visible = true; break; case 5: objChart = chtKPI6; objChart.Visible = true; break; default: return; } DundasCharts.DundasChartBase(objChart , Dundas.Charting.WebControl.ChartImageType.Flash , 400, 200 , Dundas.Charting.WebControl.BorderSkinStyle.None , Color.FromArgb(181, 64, 1) , 0 , 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); //MSCharts.DundasChartBase(objChart, ChartImageType.Jpeg, 400, 300 // , BorderSkinStyle.Emboss, Color.FromArgb(26, 59, 105), 2 // , Color.FromArgb(211, 223, 240) // , Color.FromArgb(255, 255, 255), Color.FromArgb(37, 58, 118), ChartDashStyle.Solid // , -1 // , ChartHatchStyle.None, MsGradientType.TopBottom, MsAntiAliasing.None); objChart.DataSource = dsGraph; Dundas.Charting.WebControl.Series series1 = DundasCharts.CreateSeries(objChart, objChart.ChartAreas[0].Name, "Default", strKpiName, null, Dundas.Charting.WebControl.SeriesChartType.Column, 1, GetSignalColor(i), GetChartColor2(i), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); objChart.ChartAreas[0].AxisX.Interval = 1; string strHerf = HttpContext.Current.Request.Url.ToString().Substring(0, HttpContext.Current.Request.Url.ToString().LastIndexOf('/')) + "/BSC0304S2.aspx?ESTTERM_REF_ID=" + intEsttermRefID.ToString() + "&KPI_REF_ID=" + intKpiRefID.ToString() + "&YMD=" + this.IYmd; series1.Color = GetChartColor2(i); series1.BorderWidth = 0; series1.ShadowOffset = 0; //series1.BorderColor = GetChartColor2(0); series1.Label = "#VALY{N0}"; series1.ValueMembersY = "RESULT_VALUE"; series1.ValueMemberX = "YMD"; series1.ToolTip = "#VALY{N0}"; objChart.Series[objChart.ChartAreas[0].Name]["PointWidth"] = "0.5"; //string sChartArea2 = chart.Series[series2.Name].ChartArea; //chart.ChartAreas[sChartArea2].AxisY.LabelStyle.Format = "P0"; //chart.ChartAreas[sChartArea2].AxisY.IsStartedFromZero = false; //chart.ChartAreas[sChartArea2].AxisX.IsMarginVisible = true; //chart.ChartAreas[sChartArea2].AxisY2.Enabled = AxisEnabled.False; //DoSettingChartStyles(chart,"#%"); // Show as 3D //if (rdoChartType.SelectedIndex == 0) // chart.ChartAreas[sChartArea2].Area3DStyle.Enable3D = false; //else // chart.ChartAreas[sChartArea2].Area3DStyle.Enable3D = true; DundasAnimations.DundasChartBase(objChart, AnimationTheme.None, -1, -1, false, 1); DundasAnimations.GrowingAnimation(objChart, series1, 0.5, 2.0, true); objChart.DataBind(); dsGraph = null; objChart = null; } }