//중점과제(WorkInfo)조회 private void SetMapSKIEList(string NodeValue) { mArgs = NodeValue.ToString().Split(';'); if (mArgs.Length < 3) { return; } if (mArgs.Length >= 1) { if (mArgs[GetArgsInfo(EN_ARGS_INFO.GUBUN)] == "S") { this.IStgRefID = Convert.ToInt32(mArgs[GetArgsInfo(EN_ARGS_INFO.STG)]); Biz_Bsc_Map_Sk_Ie objBSC = new Biz_Bsc_Map_Sk_Ie(); DataSet rDs = objBSC.GetStgList(this.IEstTermRefID, this.IEstDeptRefID, this.IStgRefID); ugrdMapSKIE.Clear(); ugrdMapSKIE.DataSource = rDs; ugrdMapSKIE.DataBind(); } else if (mArgs[GetArgsInfo(EN_ARGS_INFO.GUBUN)] == "K") { this.IStgRefID = Convert.ToInt32(mArgs[GetArgsInfo(EN_ARGS_INFO.STG)]); this.IKpiRefID = Convert.ToInt32(mArgs[GetArgsInfo(EN_ARGS_INFO.KPI)]); Biz_Bsc_Map_Sk_Ie objBSC = new Biz_Bsc_Map_Sk_Ie(); DataSet rDs = objBSC.GetStgKpiList(this.IEstTermRefID, this.IEstDeptRefID, this.IStgRefID, this.IKpiRefID); ugrdMapSKIE.Clear(); ugrdMapSKIE.DataSource = rDs; ugrdMapSKIE.DataBind(); } } }
//중점과제(WorkInfo)조회 private void SetWorkInfoList() { if (IStgKpi == "S" || IStgKpi == "K") { pnlWorkInfo.Visible = true; ugrdWorkInfoList.Clear(); ugrdWorkExecList.Clear(); lblEstTerm1.Text = this.IEstTermName + ">>"; lblEstDept1.Text = this.IEstDeptName2 + ">>"; if (IStgKpi == "S") { Biz_Bsc_Map_Sk_Ie objSTGWORK = new Biz_Bsc_Map_Sk_Ie(); DataSet rDs = objSTGWORK.GetStgWorkList(this.IEstTermRefID, this.IEstDeptRefID1, this.IStgRefID, this.IKpiRefID, this.IEstDeptRefID2); ugrdWorkInfoList.DataSource = rDs; ugrdWorkInfoList.DataBind(); } else { Biz_Bsc_Map_Sk_Ie objKPIWORK = new Biz_Bsc_Map_Sk_Ie(); DataSet rDs = objKPIWORK.GetKpiWorkList(this.IEstTermRefID, this.IEstDeptRefID1, this.IStgRefID, this.IKpiRefID, this.IEstDeptRefID2); ugrdWorkInfoList.DataSource = rDs; ugrdWorkInfoList.DataBind(); } IExecRefID = 0; } }
//중점과제의 하위 실행과제(WorkExec) 조회 private void SetWorkExecList() { pnlWorkExec.Visible = true; ugrdWorkExecList.Clear(); lblWorkInfo2.Text = this.IWorkName + ">>"; if (IStgKpi == "S") { Biz_Bsc_Map_Sk_Ie objSTGEXEC = new Biz_Bsc_Map_Sk_Ie(); DataSet rDs = objSTGEXEC.GetStgExecList(this.IEstTermRefID, this.IEstDeptRefID1, this.IStgRefID, this.IKpiRefID, this.IEstDeptRefID2); ugrdWorkExecList.DataSource = rDs; ugrdWorkExecList.DataBind(); } else { Biz_Bsc_Map_Sk_Ie objKPIEXEC = new Biz_Bsc_Map_Sk_Ie(); DataSet rDs = objKPIEXEC.GetKpiExecList(this.IEstTermRefID, this.IEstDeptRefID1, this.IStgRefID, this.IKpiRefID, this.IEstDeptRefID2); ugrdWorkExecList.DataSource = rDs; ugrdWorkExecList.DataBind(); } }
protected void iBtnWorkInfoUpdate_Click(object sender, ImageClickEventArgs e) { if (ugrdWorkInfoList.Rows.Count > 0) { DataTable rDT1 = new DataTable("BSC_MAP_SK_IE"); 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("STG_REF_ID", typeof(int)); rDT1.Columns.Add("KPI_REF_ID", typeof(int)); rDT1.Columns.Add("DEPT_REF_ID", typeof(int)); rDT1.Columns.Add("WORK_REF_ID", typeof(int)); rDT1.Columns.Add("EXEC_REF_ID", typeof(int)); rDT1.Columns.Add("ORDER_SEQ", typeof(int)); rDT1.Columns.Add("TXR_USER", typeof(int)); int intLogInUser = gUserInfo.Emp_Ref_ID; DataRow rDR1; CheckBox chkCheck; int intRow = ugrdWorkInfoList.Rows.Count; for (int i = 0; i < intRow; i++) { TemplatedColumn unit_col = (TemplatedColumn)ugrdWorkInfoList.Columns.FromKey("selchk"); chkCheck = (CheckBox)((CellItem)unit_col.CellItems[ugrdWorkInfoList.Rows[i].BandIndex]).FindControl("cBox"); string stgkpi = ugrdWorkInfoList.Rows[i].Cells.FromKey("STGKPI").Value.ToString(); if (chkCheck.Checked == true) { if (stgkpi == "0") // 신규 { rDR1 = rDT1.NewRow(); rDR1["ITYPE"] = "A"; rDR1["ESTTERM_REF_ID"] = this.IEstTermRefID; rDR1["EST_DEPT_REF_ID"] = this.IEstDeptRefID1; rDR1["STG_REF_ID"] = this.IStgRefID; rDR1["KPI_REF_ID"] = this.IKpiRefID; rDR1["DEPT_REF_ID"] = this.IEstDeptRefID2; rDR1["WORK_REF_ID"] = ugrdWorkInfoList.Rows[i].Cells.FromKey("WORK_REF_ID").Value.ToString(); rDR1["EXEC_REF_ID"] = 0; rDR1["ORDER_SEQ"] = 0; rDR1["TXR_USER"] = intLogInUser; rDT1.Rows.Add(rDR1); } } else { if (stgkpi != "0") //삭제 { rDR1 = rDT1.NewRow(); rDR1["ITYPE"] = "D"; rDR1["ESTTERM_REF_ID"] = this.IEstTermRefID; rDR1["EST_DEPT_REF_ID"] = this.IEstDeptRefID1; rDR1["STG_REF_ID"] = this.IStgRefID; rDR1["KPI_REF_ID"] = this.IKpiRefID; rDR1["DEPT_REF_ID"] = this.IEstDeptRefID2; rDR1["WORK_REF_ID"] = ugrdWorkInfoList.Rows[i].Cells.FromKey("WORK_REF_ID").Value.ToString(); rDR1["EXEC_REF_ID"] = 0; rDR1["ORDER_SEQ"] = 0; rDR1["TXR_USER"] = intLogInUser; rDT1.Rows.Add(rDR1); } } } if (rDT1.Rows.Count > 0) { Biz_Bsc_Map_Sk_Ie objSKIE = new Biz_Bsc_Map_Sk_Ie(); objSKIE.TxrAllBscSKIE(rDT1); ltrScript.Text = JSHelper.GetAlertScript(objSKIE.Transaction_Message, false); this.SetMapVersion(); this.SetMapInfo(true); pnlWorkInfo.Visible = false; pnlWorkExec.Visible = false; this.SetWorkInfoList(); } } }