/// <summary>
/// 선택된 전략 리스트
/// </summary>
/// <param name="isSelectAll"></param>
private void SetStrategy(bool isSelectAll)
{
int intFindStgID = (txtFindStgID.Text == "") ? 0 : int.Parse(txtFindStgID.Text);
string strFindStgNM = txtFindStgNM.Text;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg objSTG = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg();
DataSet dsSTG = objSTG.GetStrategyPerView(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue));
ugrdStgPerView.Clear();
ugrdStgPerView.DataSource = dsSTG;
ugrdStgPerView.DataBind();
ugrdStgAll.Clear();
if (isSelectAll)
{
DataSet dsSTGAll = objSTG.GetAllStrategyExceptDept(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, intFindStgID, strFindStgNM);
ugrdStgAll.DataSource = dsSTGAll;
ugrdStgAll.DataBind();
}
}
/// <summary>
/// 하위 KPI 대상 리스트
/// </summary>
//private void SetKpiChildTargetGrid()
//{
// MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Info();
// DataSet rDs = objBSC.GetKpiChildTargetList(this.IEstTermRefID, int.Parse(this.ITreeSelValue),"","", "","");
// ugrdKpiTargetList.Clear();
// ugrdKpiTargetList.DataSource = rDs;
// ugrdKpiTargetList.DataBind();
//}
/// <summary>
/// 관점별 전략 추가/삭제
/// </summary>
/// <param name="iType"></param>
private void AddDelStrategy(string iType)
{
DataTable rDT1 = new DataTable("BSC_MAP_STG");
rDT1.Columns.Add("ITYPE", typeof(string));
rDT1.Columns.Add("ESTTERM_REF_ID", typeof(int));
rDT1.Columns.Add("EST_DEPT_REF_ID", typeof(int));
rDT1.Columns.Add("MAP_VERSION_ID", typeof(int));
rDT1.Columns.Add("VIEW_REF_ID", typeof(int));
rDT1.Columns.Add("STG_REF_ID", typeof(int));
rDT1.Columns.Add("SORT_ORDER", typeof(int));
rDT1.Columns.Add("STG_NAME", typeof(string));
rDT1.Columns.Add("TXR_USER", typeof(int));
int intLogInUser = gUserInfo.Emp_Ref_ID;
DataRow rDR1;
DataRow rDR2;
CheckBox chkCheck;
int intRow = (iType == "A") ? ugrdStgAll.Rows.Count : ugrdStgPerView.Rows.Count;
for (int i = 0; i < intRow; i++)
{
if (iType == "A")
{
TemplatedColumn unit_col = (TemplatedColumn)ugrdStgAll.Columns.FromKey("selchk");
chkCheck = (CheckBox)((CellItem)unit_col.CellItems[ugrdStgAll.Rows[i].BandIndex]).FindControl("cBox");
if (chkCheck.Checked)
{
rDR1 = rDT1.NewRow();
rDR1["ITYPE"] = iType;
rDR1["ESTTERM_REF_ID"] = this.IEstTermRefID;
rDR1["EST_DEPT_REF_ID"] = this.IEstDeptRefID;
rDR1["MAP_VERSION_ID"] = this.IMapVersionID;
rDR1["VIEW_REF_ID"] = (this.ITreeSelValue == "") ? 0 : int.Parse(this.ITreeSelValue);
rDR1["STG_REF_ID"] = (ugrdStgAll.Rows[i].Cells.FromKey("STG_REF_ID").Value == null) ? 0 : int.Parse(ugrdStgAll.Rows[i].Cells.FromKey("STG_REF_ID").Value.ToString());
rDR1["SORT_ORDER"] = 0;
rDR1["STG_NAME"] = (ugrdStgAll.Rows[i].Cells.FromKey("STG_NAME").Value == null) ? "" : ugrdStgAll.Rows[i].Cells.FromKey("STG_NAME").Value.ToString();
rDR1["TXR_USER"] = intLogInUser;
rDT1.Rows.Add(rDR1);
}
}
else if (iType == "D")
{
TemplatedColumn unit_col = (TemplatedColumn)ugrdStgPerView.Columns.FromKey("selchk");
chkCheck = (CheckBox)((CellItem)unit_col.CellItems[ugrdStgPerView.Rows[i].BandIndex]).FindControl("cBox");
if (chkCheck.Checked)
{
rDR1 = rDT1.NewRow();
rDR1["ITYPE"] = iType;
rDR1["ESTTERM_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value == null) ? this.IEstTermRefID : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value.ToString());
rDR1["EST_DEPT_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value == null) ? this.IEstDeptRefID : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value.ToString());
rDR1["MAP_VERSION_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value.ToString());
rDR1["VIEW_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("VIEW_REF_ID").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("VIEW_REF_ID").Value.ToString());
rDR1["STG_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("STG_REF_ID").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("STG_REF_ID").Value.ToString());
rDR1["SORT_ORDER"] = (ugrdStgPerView.Rows[i].Cells.FromKey("SORT_ORDER").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("SORT_ORDER").Value.ToString());
rDR1["STG_NAME"] = (ugrdStgPerView.Rows[i].Cells.FromKey("STG_NAME").Value == null) ? "" : ugrdStgPerView.Rows[i].Cells.FromKey("STG_NAME").Value.ToString();
rDR1["TXR_USER"] = intLogInUser;
rDT1.Rows.Add(rDR1);
}
}
else if (iType == "U")
{
rDR1 = rDT1.NewRow();
rDR1["ITYPE"] = iType;
rDR1["ESTTERM_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value == null) ? this.IEstTermRefID : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value.ToString());
rDR1["EST_DEPT_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value == null) ? this.IEstDeptRefID : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value.ToString());
rDR1["MAP_VERSION_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value.ToString());
rDR1["VIEW_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("VIEW_REF_ID").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("VIEW_REF_ID").Value.ToString());
rDR1["STG_REF_ID"] = (ugrdStgPerView.Rows[i].Cells.FromKey("STG_REF_ID").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("STG_REF_ID").Value.ToString());
rDR1["SORT_ORDER"] = (ugrdStgPerView.Rows[i].Cells.FromKey("SORT_ORDER").Value == null) ? 0 : int.Parse(ugrdStgPerView.Rows[i].Cells.FromKey("SORT_ORDER").Value.ToString());
rDR1["STG_NAME"] = (ugrdStgPerView.Rows[i].Cells.FromKey("STG_NAME").Value == null) ? "" : ugrdStgPerView.Rows[i].Cells.FromKey("STG_NAME").Value.ToString();
rDR1["TXR_USER"] = intLogInUser;
rDT1.Rows.Add(rDR1);
}
}
if (rDT1.Rows.Count > 0)
{
MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg objSTG = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg();
objSTG.TxrAllBscStgMap(rDT1);
ltrScript.Text = JSHelper.GetAlertScript(objSTG.Transaction_Message, false);
this.SetStrategy(true);
this.DrawMapTree();
}
}
private void DrawMapTreeDetail(TreeView iTrvMap, int iEstTermRefID, int iEstDeptRefID1, int iMapVersionID, string iSelectedKey)
{
int cntRow = 0;
int cntStg = 0;
int cntKpi = 0;
string strKey = "";
string strVal = "";
strKey = "D" + ";" + Convert.ToString(this.IEstDeptRefID1) + ";0";
strVal = this.IEstDeptName1 + " 전략맵";
TreeNode topNode = new TreeNode(strVal, strKey);
iTrvMap.Nodes.Clear();
iTrvMap.Nodes.Add(topNode);
topNode.ImageUrl = "../images/stg/TREE_D.gif";
TreeNode vNode;
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objView = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet dsView = objView.GetAllList();
TreeNode sNode;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg objSTG = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg();
DataSet dsSTG = new DataSet();
TreeNode kNode;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKPI = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi();
DataSet dsKPI = new DataSet();
cntRow = dsView.Tables[0].Rows.Count;
for (int i = 0; i < cntRow; i++)
{
string imgWork = "<img alt='' src='../images/stg/TREE_W.gif'/>";
string imgExec = "<img alt='' src='../images/stg/TREE_E.gif'/>";
strKey = "V" + ";" + dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString() + ";0";
strVal = dsView.Tables[0].Rows[i]["VIEW_NAME"].ToString();
vNode = new TreeNode(strVal, strKey);
vNode.ImageUrl = "../images/stg/TREE_V.gif";
topNode.ChildNodes.Add(vNode);
if (iSelectedKey == strKey)
{
vNode.Select();
vNode.ExpandAll();
vNode.SelectAction = TreeNodeSelectAction.Select;
}
int stgrefid = 0;
int kpirefid = 0;
dsSTG = objSTG.GetStrategyPerView(IEstTermRefID, IEstDeptRefID1, IMapVersionID, int.Parse(dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString()));
cntStg = dsSTG.Tables[0].Rows.Count;
for (int j = 0; j < cntStg; j++)
{
strKey = "S" + ";" + dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString() + ";0";
stgrefid = Convert.ToInt32(dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString());
kpirefid = 0;
strVal = dsSTG.Tables[0].Rows[j]["STG_NAME"].ToString()
+ (WorkCount(IEstTermRefID, IEstDeptRefID1, stgrefid, kpirefid) ? imgWork : "")
+ (ExecCount(IEstTermRefID, IEstDeptRefID1, stgrefid, kpirefid) ? imgExec : "");
sNode = new TreeNode(strVal, strKey);
sNode.ImageUrl = "../images/stg/TREE_S.gif";
vNode.ChildNodes.Add(sNode);
if (iSelectedKey == strKey)
{
sNode.Select();
sNode.ExpandAll();
sNode.SelectAction = TreeNodeSelectAction.Select;
}
dsKPI = objKPI.GetKpiListPerStg(IEstTermRefID, IEstDeptRefID1, IMapVersionID, int.Parse(dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString()));
cntKpi = dsKPI.Tables[0].Rows.Count;
for (int k = 0; k < cntKpi; k++)
{
strKey = "K" + ";" + dsKPI.Tables[0].Rows[k]["KPI_REF_ID"].ToString() + ";" + dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString();
kpirefid = Convert.ToInt32(dsKPI.Tables[0].Rows[k]["KPI_REF_ID"].ToString());
strVal = dsKPI.Tables[0].Rows[k]["KPI_NAME"].ToString()
+ (WorkCount(IEstTermRefID, IEstDeptRefID1, stgrefid, kpirefid) ? imgWork : "")
+ (ExecCount(IEstTermRefID, IEstDeptRefID1, stgrefid, kpirefid) ? imgExec : "");
kNode = new TreeNode(strVal, strKey);
kNode.ImageUrl = "../images/stg/TREE_K.gif";
sNode.ChildNodes.Add(kNode);
if (iSelectedKey == strKey)
{
kNode.Select();
kNode.ExpandAll();
kNode.SelectAction = TreeNodeSelectAction.Select;
}
}
}
}
if (iTrvMap.SelectedNode == null)
{
topNode.Select();
}
iTrvMap.ExpandAll();
}
/// <summary>
/// 전략맵 트리구성
/// </summary>
/// <param name="iTrvMap">트리</param>
/// <param name="iEstTermRefID">평가기간</param>
/// <param name="iEstDeptRefID">평가부서</param>
public void DrawMapTree(TreeView iTrvMap, int iEstTermRefID, int iEstDeptRefID, int iMapVersionID, string iSelectedKey)
{
/* 수정작업 : 이천십일년 삼월 치릴
* 수정작자 : 장동건
* 수정내용 : BSC1004S1.ASPX 자화전자(성덕여왕 요청)
* 측정주기 변경시 평가조직이 변경이 안됨
* 조건변수를 두개로 날림
* */
MicroBSC.Estimation.Dac.DeptInfos objDept = new MicroBSC.Estimation.Dac.DeptInfos(iEstDeptRefID);
int cntRow = 0;
int cntStg = 0;
int cntKpi = 0;
string strKey = "";
string strVal = "";
strKey = "D" + objDept.Dept_Ref_ID.ToString();
strVal = objDept.Dept_Name + " 전략맵";
TreeNode topNode = new TreeNode(strVal, strKey);
iTrvMap.Nodes.Clear();
iTrvMap.Nodes.Add(topNode);
topNode.ImageUrl = "../images/stg/TREE_D.gif";
TreeNode vNode;
MicroBSC.BSC.Biz.Biz_Bsc_View_Info objView = new MicroBSC.BSC.Biz.Biz_Bsc_View_Info();
DataSet dsView = objView.GetAllList();
TreeNode sNode;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg objSTG = new Biz_Bsc_Map_Stg();
DataSet dsSTG = new DataSet();
TreeNode kNode;
MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKPI = new Biz_Bsc_Map_Kpi();
DataSet dsKPI = new DataSet();
cntRow = dsView.Tables[0].Rows.Count;
for (int i = 0; i < cntRow; i++)
{
strKey = "V" + dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString();
strVal = dsView.Tables[0].Rows[i]["VIEW_NAME"].ToString();
vNode = new TreeNode(strVal, strKey);
vNode.ImageUrl = "../images/stg/TREE_V.gif";
topNode.ChildNodes.Add(vNode);
if (iSelectedKey == strKey)
{
vNode.Select();
vNode.ExpandAll();
vNode.SelectAction = TreeNodeSelectAction.Select;
}
dsSTG = objSTG.GetStrategyPerView(iEstTermRefID, iEstDeptRefID, iMapVersionID, int.Parse(dsView.Tables[0].Rows[i]["VIEW_REF_ID"].ToString()));
cntStg = dsSTG.Tables[0].Rows.Count;
for (int j = 0; j < cntStg; j++)
{
strKey = "S" + dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString();
strVal = dsSTG.Tables[0].Rows[j]["STG_NAME"].ToString();
sNode = new TreeNode(strVal, strKey);
sNode.ImageUrl = "../images/stg/TREE_S.gif";
vNode.ChildNodes.Add(sNode);
if (iSelectedKey == strKey)
{
sNode.Select();
sNode.ExpandAll();
sNode.SelectAction = TreeNodeSelectAction.Select;
}
dsKPI = objKPI.GetKpiListPerStg(iEstTermRefID, iEstDeptRefID, iMapVersionID, int.Parse(dsSTG.Tables[0].Rows[j]["STG_REF_ID"].ToString()));
cntKpi = dsKPI.Tables[0].Rows.Count;
for (int k = 0; k < cntKpi; k++)
{
strKey = "K" + dsKPI.Tables[0].Rows[k]["KPI_REF_ID"].ToString();
strVal = dsKPI.Tables[0].Rows[k]["KPI_NAME"].ToString();
kNode = new TreeNode(strVal, strKey);
kNode.ImageUrl = "../images/stg/TREE_K.gif";
sNode.ChildNodes.Add(kNode);
if (iSelectedKey == strKey)
{
kNode.Select();
kNode.ExpandAll();
kNode.SelectAction = TreeNodeSelectAction.Select;
}
}
}
}
if (iTrvMap.SelectedNode == null)
{
topNode.Select();
}
iTrvMap.ExpandAll();
}