/// <summary>
/// 전략맵 & 전략맵기간 추가/삭제
/// </summary>
private void AddDelMapInfo()
{
if (!CheckMapInfoForm())
{
return;
}
int LoginUser = gUserInfo.Emp_Ref_ID;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objMap = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info();
objMap.TxrMapInfo(this.IType
, this.IEstTermRefID
, this.IEstDeptRefID
, (this.IType == "A") ? 0 : this.IMapVersionID
, txtMapVersionName.Text
, txtDeptVision.Text
, txtMapDesc.Text
, (hdfBSCChampionID.Value == "") ? 0 : int.Parse(hdfBSCChampionID.Value)
, "Y"
, LoginUser
, this.GetMapTermList(LoginUser)
);
ltrScript.Text = JSHelper.GetAlertScript(objMap.Transaction_Message, false);
if (objMap.Transaction_Result == "Y" && this.IType == "A")
{
this.SetMapVersionDDL();
this.ddlMapVersion.SelectedItem.Value = objMap.Imap_version_id.ToString();
}
else if (objMap.Transaction_Result == "Y" && this.IType == "U")
{
this.SetMapInfo(true);
}
}
private void SetMapinfo()
{
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objMapinfo = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info(this.IEstTermRefID, this.IEstDeptID, this.IYmd);
lblDeptVision.Text = objMapinfo.Idept_vision;
lblChampName.Text = objMapinfo.Ibscchampion_name;
lblEstDeptName.Text = objMapinfo.Iest_dept_name;
}
/// <summary>
/// 전략맵 트리 초기화
/// </summary>
private void DrawMapTreeInit()
{
string strSelVal = "";
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objTrv = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info();
objTrv.DrawMapTree(trvStgMap, this.IEstTermRefID, this.IEstDeptRefID, -1, strSelVal);
}
public void GridBinding()
{
int estterm_ref_id = (ddlEstTermInfo.Items.Count > 0) ? int.Parse(ddlEstTermInfo.SelectedValue.ToString()) : 0;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info();
DataSet ds = objBSC.GetMapListByDeptTree(estterm_ref_id, PageUtility.GetByValueDropDownList(ddlEstTermMonth));
ugrdMapList.DataSource = ds;
ugrdMapList.DataBind();
}
/// <summary>
/// 전략맵 트리설정
/// </summary>
private void DrawMapTree()
{
string strSelVal = "";
if (trvStgMap.SelectedNode != null)
{
strSelVal = trvStgMap.SelectedNode.Value;
}
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objTrv = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info();
objTrv.DrawMapTree(trvStgMap, this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, strSelVal);
}
/// <summary>
/// 맵기본정보설정
/// </summary>
/// <param name="IsMapTermRefresh">맵기본정보를 재설정할것인지 여부</param>
private void SetMapInfo(bool IsMapTermRefresh)
{
this.IMapVersionID = PageUtility.GetIntByValueDropDownList(ddlMapVersion);
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objMap = null;
if (this.IMapVersionID < 1 && (!IsPostBack))
{
objMap = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info(this.IEstTermRefID, this.IEstDeptRefID, this.IYmd);
ddlMapVersion.SelectedValue = objMap.Imap_version_id.ToString();
this.IMapVersionID = objMap.Imap_version_id;
}
else
{
objMap = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID);
}
this.DrawMapTree();
txtTermDesc.Text = objMap.Iest_term_name;
txtEstDeptName.Text = objMap.Iest_dept_name;
hdfBSCChampionID.Value = objMap.Ibscchampion_emp_id.ToString();
txtBSCChampion.Text = objMap.Ibscchampion_name;
txtDeptVision.Text = objMap.Idept_vision;
txtMapVersionID.Text = objMap.Imap_version_id.ToString();
txtMapVersionName.Text = objMap.Imap_version_name;
txtMapDesc.Text = objMap.Imap_desc;
if (IsMapTermRefresh)
{
DataSet dsTerm = objMap.GetMapTermList(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID);
ugrdTerm.Clear();
ugrdTerm.DataSource = dsTerm;
ugrdTerm.DataBind();
}
if (trvStgMap.SelectedNode != null)
{
this.SetFormType();
}
}
private void SetFormData()
{
this.IEstTermRefID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
this.IYmd = PageUtility.GetByValueDropDownList(ddlEstTermMonth);
if (this.IEstDeptRefID < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("부서를 선택해 주십시오", false);
ugrdLoadMapList.Clear();
return;
}
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objMap = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info(this.IEstTermRefID, this.IEstDeptRefID, this.IYmd);
ltEstDeptName.Text = objMap.Iest_dept_name;
lblChampName.Text = objMap.Ibscchampion_name;
lblSTGMapName.Text = objMap.Idept_vision;
MicroBSC.BSC.Biz.Biz_Bsc_EstDept_LoadMap objLoadMap = new MicroBSC.BSC.Biz.Biz_Bsc_EstDept_LoadMap();
DataSet rDs = objLoadMap.GetLoadMapPerEstDept(this.IEstTermRefID, this.IEstDeptRefID);
ugrdLoadMapList.Clear();
ugrdLoadMapList.DataSource = rDs;
ugrdLoadMapList.DataBind();
}
/// <summary>
/// 전략맵 버젼 Dropdownlist설정
/// </summary>
private void SetMapVersionDDL()
{
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objVer = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info();
DataSet dsVer = objVer.GetMapVersionList(this.IEstTermRefID, this.IEstDeptRefID);
ddlMapVersion.DataSource = dsVer;
ddlMapVersion.DataTextField = "MAP_VERSION_NAME";
ddlMapVersion.DataValueField = "MAP_VERSION_ID";
ddlMapVersion.DataBind();
if (ddlMapVersion.Items.Count > 0)
{
ddlMapVersion.SelectedIndex = 0;
this.IMapVersionID = int.Parse(ddlMapVersion.SelectedValue);
this.IType = "U";
}
else
{
this.IMapVersionID = 0;
this.IType = "A";
}
this.SetButton();
}
public void SetDeptScoreCard()
{
MicroBSC.BSC.Biz.Biz_Bsc_Score_Card objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Score_Card();
DataSet iDs = objBSC.GetEstDeptTotalScore(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsViw = objBSC.GetEstDeptKpiViewTypeList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsKpi = objBSC.GetEstDeptKpiScoreList
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsTot = objBSC.GetEstDeptTotalScore
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataSet dsTree = new DataSet();
if (ddlMapLevel.SelectedValue == "SP")
{
DataSet dsStg = objBSC.GetScorePerStrategy
(this.IEstTermRefID
, this.IYmd
, this.ISumType
, this.ISelDeptID
, this.IExtKpiYN);
DataTable dtStg = dsStg.Tables[0].Copy();
DataTable dtKpi = dsKpi.Tables[0].Copy();
dsTree = dsViw.Copy();
dsTree.Tables.Add(dtStg);
dsTree.Tables.Add(dtKpi);
dsTree.Relations.Add("SCORE_CARD_STG", dsTree.Tables[0].Columns["VIEW_REF_ID"], dsTree.Tables[1].Columns["VIEW_REF_ID"]);
dsTree.Relations.Add("SCORE_CARD_KPI", dsTree.Tables[1].Columns["STG_REF_ID"], dsTree.Tables[2].Columns["STG_REF_ID"]);
}
else
{
DataTable dtKpi = dsKpi.Tables[0].Copy();
dsTree = dsViw.Copy();
dsTree.Tables.Add(dtKpi);
dsTree.Relations.Add("SCORE_CARD_KPI", dsTree.Tables[0].Columns["VIEW_REF_ID"], dsTree.Tables[1].Columns["VIEW_REF_ID"]);
}
ugrdScoreCard.Clear();
ugrdScoreCard.DataSource = dsTree.Tables[0].DefaultView;
ugrdScoreCard.DataBind();
lblTotalScore.Style.Add("align", "right");
lblTotalScore.Text = (dsTot.Tables[0].Rows.Count > 0) ? double.Parse(dsTot.Tables[0].Rows[0]["POINT"].ToString()).ToString("#,##0.00") : "0";
MicroBSC.BSC.Biz.Biz_Bsc_Map_Info objMap = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Info(this.IEstTermRefID
, this.ISelDeptID
, this.IYmd);
lblDeptName.Text = objMap.Iest_dept_name;
lblDeptVision.Text = objMap.Idept_vision;
lblBSCChampion.Text = objMap.Ibscchampion_name;
}
