/// <summary> /// 상위전략 리스트 /// </summary> private void SetParentStg() { MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent(); DataSet dsStg = objBSC.GetParentStgList(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue)); TugrdUpStgList.Clear(); TugrdUpStgList.DataSource = dsStg; TugrdUpStgList.DataBind(); DataSet dsAllStg = objBSC.GetDeptStgListExceptParentStg(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue)); TugrdStgPerDept.Clear(); TugrdStgPerDept.DataSource = dsAllStg; TugrdStgPerDept.DataBind(); }
public bool TxrAllBscStgMap(DataTable iDT) { int intRow = iDT.Rows.Count; int intTxrCnt = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent objPrt = new Biz_Bsc_Map_Stg_Parent(); MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKpi = new Biz_Bsc_Map_Kpi(); try { for (int i = 0; i < intRow; i++) { if (iDT.Rows[i]["ITYPE"].ToString() == "D") { this.DeleteData(conn , trx , int.Parse(iDT.Rows[i]["ESTTERM_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["EST_DEPT_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["MAP_VERSION_ID"].ToString()) , int.Parse(iDT.Rows[i]["STG_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["VIEW_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["TXR_USER"].ToString()) ); objPrt.DeleteAllData (conn , trx , int.Parse(iDT.Rows[i]["ESTTERM_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["EST_DEPT_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["MAP_VERSION_ID"].ToString()) , int.Parse(iDT.Rows[i]["STG_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["TXR_USER"].ToString()) ); objKpi.DeleteKpiPerStgData (conn , trx , int.Parse(iDT.Rows[i]["ESTTERM_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["EST_DEPT_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["MAP_VERSION_ID"].ToString()) , int.Parse(iDT.Rows[i]["STG_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["TXR_USER"].ToString()) ); } else { this.InsertData(conn , trx , int.Parse(iDT.Rows[i]["ESTTERM_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["EST_DEPT_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["MAP_VERSION_ID"].ToString()) , int.Parse(iDT.Rows[i]["STG_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["VIEW_REF_ID"].ToString()) , int.Parse(iDT.Rows[i]["SORT_ORDER"].ToString()) , int.Parse(iDT.Rows[i]["TXR_USER"].ToString()) ); } } base.Transaction_Message = "정상적으로 처리되었습니다."; base.Transaction_Result = "Y"; trx.Commit(); } catch (Exception e) { base.Transaction_Message = e.Message; base.Transaction_Result = "N"; trx.Rollback(); return(false); } finally { conn.Close(); } return(true); }
/// <summary> /// 상위전략 추가/삭제 /// </summary> /// <param name="iType"></param> private void AddDelParentStrategy(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("STG_REF_ID", typeof(int)); rDT1.Columns.Add("UP_STG_REF_ID", typeof(int)); rDT1.Columns.Add("TXR_USER", typeof(int)); int intRow = (iType == "A") ? TugrdStgPerDept.Rows.Count : TugrdUpStgList.Rows.Count; CheckBox chkCheck; DataRow rDR1; int intLogInUser = gUserInfo.Emp_Ref_ID; for (int i = 0; i < intRow; i++) { if (iType == "A") { TemplatedColumn unit_col = (TemplatedColumn)TugrdStgPerDept.Columns.FromKey("selchk"); chkCheck = (CheckBox)((CellItem)unit_col.CellItems[TugrdStgPerDept.Rows[i].BandIndex]).FindControl("cBox"); if (chkCheck.Checked) { rDR1 = rDT1.NewRow(); rDR1["ITYPE"] = iType; rDR1["ESTTERM_REF_ID"] = (TugrdStgPerDept.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value == null) ? this.IEstTermRefID : int.Parse(TugrdStgPerDept.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value.ToString()); rDR1["EST_DEPT_REF_ID"] = (TugrdStgPerDept.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value == null) ? this.IEstDeptRefID : int.Parse(TugrdStgPerDept.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value.ToString()); rDR1["MAP_VERSION_ID"] = (TugrdStgPerDept.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value == null) ? this.IMapVersionID : int.Parse(TugrdStgPerDept.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value.ToString()); rDR1["STG_REF_ID"] = (TugrdStgPerDept.Rows[i].Cells.FromKey("STG_REF_ID").Value == null) ? 0 : int.Parse(TugrdStgPerDept.Rows[i].Cells.FromKey("STG_REF_ID").Value.ToString()); rDR1["UP_STG_REF_ID"] = (TugrdStgPerDept.Rows[i].Cells.FromKey("UP_STG_REF_ID").Value == null) ? 0 : int.Parse(TugrdStgPerDept.Rows[i].Cells.FromKey("UP_STG_REF_ID").Value.ToString()); rDR1["TXR_USER"] = intLogInUser; rDT1.Rows.Add(rDR1); } } else if (iType == "D") { TemplatedColumn unit_col = (TemplatedColumn)TugrdUpStgList.Columns.FromKey("selchk"); chkCheck = (CheckBox)((CellItem)unit_col.CellItems[TugrdUpStgList.Rows[i].BandIndex]).FindControl("cBox"); if (chkCheck.Checked) { rDR1 = rDT1.NewRow(); rDR1["ITYPE"] = iType; rDR1["ESTTERM_REF_ID"] = (TugrdUpStgList.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value == null) ? this.IEstTermRefID : int.Parse(TugrdUpStgList.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value.ToString()); rDR1["EST_DEPT_REF_ID"] = (TugrdUpStgList.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value == null) ? this.IEstDeptRefID : int.Parse(TugrdUpStgList.Rows[i].Cells.FromKey("EST_DEPT_REF_ID").Value.ToString()); rDR1["MAP_VERSION_ID"] = (TugrdUpStgList.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value == null) ? this.IMapVersionID : int.Parse(TugrdUpStgList.Rows[i].Cells.FromKey("MAP_VERSION_ID").Value.ToString()); rDR1["STG_REF_ID"] = (TugrdUpStgList.Rows[i].Cells.FromKey("STG_REF_ID").Value == null) ? 0 : int.Parse(TugrdUpStgList.Rows[i].Cells.FromKey("STG_REF_ID").Value.ToString()); rDR1["UP_STG_REF_ID"] = (TugrdUpStgList.Rows[i].Cells.FromKey("UP_STG_REF_ID").Value == null) ? 0 : int.Parse(TugrdUpStgList.Rows[i].Cells.FromKey("UP_STG_REF_ID").Value.ToString()); rDR1["TXR_USER"] = intLogInUser; rDT1.Rows.Add(rDR1); } } } if (rDT1.Rows.Count > 0) { MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent objSTG = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent(); bool blnRtn = objSTG.TxrAllBscStgParent(rDT1); this.SetParentStg(); //ltrScript.Text = JSHelper.GetAlertBackScript(objSTG.Transaction_Message); } }