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