private void DisplayScore() { writeLog(string.Format("{0} : DisplayScore() Start", Request.PhysicalPath)); string dept_id = ""; string dept_name = ""; string est_dept_id = ""; string bdept_id = ""; string bdept_name = ""; string best_dept_id = ""; Biz_Bsc_Intro_Score bizDeptInfo = new Biz_Bsc_Intro_Score(); DataTable dtbizDeptInfo = bizDeptInfo.GetJeonsaInfo(DataTypeUtility.GetToInt32(IEstTermRefID).ToString() ); if (dtbizDeptInfo.Rows.Count > 0) { est_dept_id = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][0]); dept_name = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][1]); } int score = 0; Biz_Bsc_Intro_Score bizScore = new Biz_Bsc_Intro_Score(); DataTable dtbizScore = bizScore.GetOrgScore("TS" , DataTypeUtility.GetToInt32(IEstTermRefID).ToString() , IYmd , DataTypeUtility.GetToInt32(est_dept_id).ToString()); if (dtbizScore.Rows.Count > 0) { score = Convert.ToInt32(dtbizScore.Rows[0][6]); if (score < 0) { score = 0; } } lblTEAMname.Text = dept_name; lblTEAMname.ToolTip = dept_name; lblTEAMscore.Text = String.Format("{0:##0}", score); lblTEAMscore.CssClass = searchColor(score); string ESTTERM_REF_ID = DataTypeUtility.GetToInt32(IEstTermRefID).ToString(); string YMD = IYmd; string SUM_TYPE = "TS"; string url = "BSC0408S6.ASPX?ESTTERM_REF_ID={0}&YMD={1}&SUM_TYPE={2}"; //string url = "BSC0408S4.ASPX?ESTTERM_REF_ID={0}&YMD={1}&SUM_TYPE={2}"; KPI_URL = string.Format(url, ESTTERM_REF_ID, YMD, SUM_TYPE); writeLog(string.Format("{0} : DisplayScore() End", Request.PhysicalPath)); }
private void DoBinding_Chart() { DataTable dtTemp = new DataTable(); dtTemp.Columns.Add("TS_GRADE"); dtTemp.Columns.Add("GRADE_COUNT", typeof(double)); DataRow row = dtTemp.NewRow(); row["TS_GRADE"] = "D"; row["GRADE_COUNT"] = 0; dtTemp.Rows.Add(row); row = dtTemp.NewRow(); row["TS_GRADE"] = "C"; row["GRADE_COUNT"] = 0; dtTemp.Rows.Add(row); row = dtTemp.NewRow(); row["TS_GRADE"] = "B"; row["GRADE_COUNT"] = 0; dtTemp.Rows.Add(row); row = dtTemp.NewRow(); row["TS_GRADE"] = "A"; row["GRADE_COUNT"] = 0; dtTemp.Rows.Add(row); row = dtTemp.NewRow(); row["TS_GRADE"] = "S"; row["GRADE_COUNT"] = 0; dtTemp.Rows.Add(row); DataTable dtOrg = dtTemp.Copy(); DataTable dtPri = dtTemp.Copy(); Biz_Bsc_Intro_Score bizNHIT = new Biz_Bsc_Intro_Score(); DataTable dtNHIT = bizNHIT.GetOrgRankBunpo(IEstTermRefID, IYmd, "7", "TS"); if (dtNHIT.Rows.Count > 0) { for (int i = 0; i < dtOrg.Rows.Count; i++) { string ts_grade = DataTypeUtility.GetValue(dtOrg.Rows[i]["TS_GRADE"]); DataRow[] rows = dtNHIT.Select(string.Format(" TS_GRADE = '{0}' ", ts_grade)); if (rows.Length > 0) { dtOrg.Rows[i]["GRADE_COUNT"] = rows[0]["GRADE_COUNT"]; } } DoDrawingChart1(dtOrg, chart1); } dtNHIT = bizNHIT.GetPriRankBunpo(IEstTermRefID, IYmd); if (dtNHIT.Rows.Count > 0) { for (int i = 0; i < dtPri.Rows.Count; i++) { string ts_grade = DataTypeUtility.GetValue(dtPri.Rows[i]["TS_GRADE"]); DataRow[] rows = dtNHIT.Select(string.Format(" TS_GRADE = '{0}' ", ts_grade)); if (rows.Length > 0) { dtPri.Rows[i]["GRADE_COUNT"] = rows[0]["GRADE_COUNT"]; } } DoDrawingChart2(dtPri, chart2); } }
private void DisplayScore() { writeLog(string.Format("{0} : DisplayScore() Start", Request.PhysicalPath)); string mbo_name = ""; int mbo_score = 0; int team_score = 0; int bonbu_score = 0; int jeonsa_score = 0; string dept_id = ""; string dept_name = ""; string est_dept_id = ""; string bdept_id = ""; string bdept_name = ""; string best_dept_id = ""; string jdept_id = ""; string jdept_name = ""; string jest_dept_id = ""; string Jeonsa_id = ""; string Jeonsa_name = ""; Biz_Bsc_Intro_Score bizDeptInfo = new Biz_Bsc_Intro_Score(); DataTable dtbizDeptInfo = bizDeptInfo.GetJeonsaInfo(DataTypeUtility.GetToInt32(IEstTermRefID).ToString() ); if (dtbizDeptInfo.Rows.Count > 0) { Jeonsa_id = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][0]); Jeonsa_name = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][1]); } int score = 0; //MBO 점수 가져오기 Biz_Bsc_Intro_Score bizScore = new Biz_Bsc_Intro_Score(); DataTable dtbizScore = bizScore.GetMboScore(IEstTermRefID, IYmd, gUserInfo.LoginID); if (dtbizScore.Rows.Count > 0) { dept_id = dtbizScore.Rows[0][1].ToString(); score = Convert.ToInt32(dtbizScore.Rows[0][3]); if (score < 0) { score = 0; } mbo_score = score; } mbo_name = gUserInfo.Emp_Name; //팀,본부,전사 명칭 가져오기 dtbizScore = null; dtbizScore = bizScore.GetDeptInfo(Convert.ToInt32(dept_id)); if (dtbizScore.Rows.Count > 0) { est_dept_id = dtbizScore.Rows[0][0].ToString(); dept_name = dtbizScore.Rows[0][2].ToString(); bdept_id = ""; best_dept_id = dtbizScore.Rows[0][7].ToString(); bdept_name = dtbizScore.Rows[0][15].ToString(); if (est_dept_id == best_dept_id) { best_dept_id = Jeonsa_id; bdept_name = Jeonsa_name; } jest_dept_id = Jeonsa_id; jdept_name = Jeonsa_name; } //팀점수 score = 0; dtbizScore = null; dtbizScore = bizScore.GetOrgScore("TS" , DataTypeUtility.GetToInt32(IEstTermRefID).ToString() , IYmd , DataTypeUtility.GetToInt32(est_dept_id).ToString()); if (dtbizScore.Rows.Count > 0) { score = Convert.ToInt32(dtbizScore.Rows[0][6]); if (score < 0) { score = 0; } team_score = score; } //본부점수 score = 0; dtbizScore = null; dtbizScore = bizScore.GetOrgScore("TS" , DataTypeUtility.GetToInt32(IEstTermRefID).ToString() , IYmd , DataTypeUtility.GetToInt32(best_dept_id).ToString()); if (dtbizScore.Rows.Count > 0) { score = Convert.ToInt32(dtbizScore.Rows[0][6]); if (score < 0) { score = 0; } bonbu_score = score; } //전사점수 score = 0; dtbizScore = null; dtbizScore = bizScore.GetOrgScore("TS" , DataTypeUtility.GetToInt32(IEstTermRefID).ToString() , IYmd , DataTypeUtility.GetToInt32(jest_dept_id).ToString()); if (dtbizScore.Rows.Count > 0) { score = Convert.ToInt32(dtbizScore.Rows[0][6]); if (score < 0) { score = 0; } jeonsa_score = score; } if (gUserInfo.Position_Rank_Code == "210") { //display lblUserName.Text = Utils.GetSubText(dept_name, 4, true); lblUserName.ToolTip = dept_name; lblMBOscore.Text = String.Format("{0:##0}", team_score); lblMBOscore.CssClass = searchColor(team_score); lblTEAMname.Text = bdept_name; lblTEAMname.ToolTip = bdept_name; lblTEAMscore.Text = String.Format("{0:##0}", bonbu_score); lblTEAMscore.CssClass = searchColor(bonbu_score); lblBONBUname.Text = jdept_name; lblBONBUname.ToolTip = jdept_name; lblBONBUscore.Text = String.Format("{0:##0}", jeonsa_score); lblBONBUscore.CssClass = searchColor(jeonsa_score); } else { //display lblUserName.Text = Utils.GetSubText(mbo_name, 4, true); lblUserName.ToolTip = mbo_name; if (KPI_URL == "BSC1004S1.ASPX") { lblMBOscore.Text = String.Format("{0:##0}", mbo_score); lblMBOscore.CssClass = searchColor(mbo_score); } else { lblMBOscore.Text = String.Format("{0:##0}", team_score); lblMBOscore.CssClass = searchColor(team_score); }; //lblMBOscore.Text = String.Format("{0:##0}", mbo_score); //lblMBOscore.CssClass = searchColor(mbo_score); lblTEAMname.Text = dept_name; lblTEAMname.ToolTip = dept_name; lblTEAMscore.Text = String.Format("{0:##0}", team_score); lblTEAMscore.CssClass = searchColor(team_score); lblBONBUname.Text = bdept_name; lblBONBUname.ToolTip = bdept_name; lblBONBUscore.Text = String.Format("{0:##0}", bonbu_score); lblBONBUscore.CssClass = searchColor(bonbu_score); } writeLog(string.Format("{0} : DisplayScore() End", Request.PhysicalPath)); }
private void DisplayScore() { writeLog(string.Format("{0} : DisplayScore() Start", Request.PhysicalPath)); string dept_id = ""; string dept_name = ""; string est_dept_id = ""; string bdept_id = ""; string bdept_name = ""; string best_dept_id = ""; string Jeonsa_id = ""; string Jeonsa_name = ""; Biz_Bsc_Intro_Score bizDeptInfo = new Biz_Bsc_Intro_Score(); DataTable dtbizDeptInfo = bizDeptInfo.GetJeonsaInfo(DataTypeUtility.GetToInt32(IEstTermRefID).ToString() ); if (dtbizDeptInfo.Rows.Count > 0) { Jeonsa_id = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][0]); Jeonsa_name = DataTypeUtility.GetString(dtbizDeptInfo.Rows[0][1]); } int score = 0; //MBO 점수 가져오기 Biz_Bsc_Intro_Score bizScore = new Biz_Bsc_Intro_Score(); DataTable dtbizScore = bizScore.GetMboScore(IEstTermRefID, IYmd, gUserInfo.LoginID); if (dtbizScore.Rows.Count > 0) { //lblUserName.Text = Utils.GetSubText(gUserInfo.Emp_Name, 4, true); //lblUserName.ToolTip = gUserInfo.Emp_Name; dept_id = dtbizScore.Rows[0][1].ToString(); score = Convert.ToInt32(dtbizScore.Rows[0][3]); if (score < 0) { score = 0; } } //lblMBOscore.Text = String.Format("{0:##0}", score); //lblMBOscore.CssClass = searchColor(score); dtbizScore = null; dtbizScore = bizScore.GetDeptInfo(Convert.ToInt32(dept_id)); if (dtbizScore.Rows.Count > 0) { est_dept_id = dtbizScore.Rows[0][0].ToString(); dept_name = dtbizScore.Rows[0][2].ToString(); bdept_id = ""; best_dept_id = dtbizScore.Rows[0][7].ToString(); bdept_name = dtbizScore.Rows[0][15].ToString(); if (est_dept_id == best_dept_id) { best_dept_id = Jeonsa_id; bdept_name = Jeonsa_name; } } score = 0; dtbizScore = null; dtbizScore = bizScore.GetOrgScore("TS" , DataTypeUtility.GetToInt32(IEstTermRefID).ToString() , IYmd , DataTypeUtility.GetToInt32(est_dept_id).ToString()); if (dtbizScore.Rows.Count > 0) { score = Convert.ToInt32(dtbizScore.Rows[0][6]); if (score < 0) { score = 0; } } lblTEAMname.Text = dept_name; lblTEAMname.ToolTip = dept_name; lblTEAMscore.Text = String.Format("{0:##0}", score); lblTEAMscore.CssClass = searchColor(score); score = 0; //dtbizScore = null; //dtbizScore = bizScore.GetOrgScore("TS" // , DataTypeUtility.GetToInt32(IEstTermRefID).ToString() // , IYmd // , DataTypeUtility.GetToInt32(best_dept_id).ToString()); //if (dtbizScore.Rows.Count > 0) //{ // lblBONBUname.Text = bdept_name; // lblBONBUname.ToolTip = bdept_name; // score = Convert.ToInt32(dtbizScore.Rows[0][6]); // if (score < 0) // score = 0; //} //lblBONBUscore.Text = String.Format("{0:##0}", score); //lblBONBUscore.CssClass = searchColor(score); writeLog(string.Format("{0} : DisplayScore() End", Request.PhysicalPath)); }