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)); }