public DataTable Get_GoalTongDashboard(int estterm_ref_id , int est_dept_ref_id) { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Info dacBscKpiInfo = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Info(); return(dacBscKpiInfo.Select_GoalTongDashboard(estterm_ref_id , est_dept_ref_id)); }
/// <summary> /// 조직KPI에서 복사한 MBO를 삭제 /// </summary> /// <param></param> /// <returns></returns> public string RemoveMboToKpi_DB(int estterm_ref_id , string[] objList) { string rtnValue = string.Empty; int okCnt = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Info dacBscKpiInfo = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Info(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target_Version dacBscKpiTargetVersion = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target_Version(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result dacBscKpiResult = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Term dacBscKpiTerm = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Term(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target dacBscKpiTarget = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Threshold_Info dacBscKpiThresholdInfo = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Threshold_Info(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Initiative dacBscKpiInitiative = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Initiative(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Classification dacBscKpiClassification = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Classification(); foreach (string obj in objList) { okCnt = dacBscKpiInfo.Delete_DB(conn , trx , estterm_ref_id , obj); okCnt = dacBscKpiTargetVersion.Delete_DB(conn , trx , estterm_ref_id , obj); okCnt = dacBscKpiResult.DeleteData_DB(conn , trx , estterm_ref_id , obj); okCnt = dacBscKpiTerm.Delete_DB(conn , trx , estterm_ref_id , obj); okCnt = dacBscKpiTarget.Delete_DB(conn , trx , estterm_ref_id , obj); okCnt = dacBscKpiThresholdInfo.Delete_DB(conn , trx , estterm_ref_id , obj); okCnt = dacBscKpiInitiative.DeleteData_DB(conn , trx , estterm_ref_id , obj); okCnt = dacBscKpiClassification.Delete_DB(conn , trx , estterm_ref_id , obj); } trx.Commit(); } catch (Exception ex) { rtnValue = ex.Message; trx.Rollback(); } finally { conn.Close(); } return(rtnValue); }