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