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