public string AddData_DB(string kpi_pool_templete_id , string[] kpi_pool_ref_id_list , DateTime create_date , int create_user) { string reVal = string.Empty; int affectedRow = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete_MAP dacBscKpiPoolTempleteMap = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete_MAP(); affectedRow = dacBscKpiPoolTempleteMap.DeleteData_DB(conn , trx , kpi_pool_templete_id); try { foreach (string kpi_pool_ref_id in kpi_pool_ref_id_list) { affectedRow = dacBscKpiPoolTempleteMap.InsertData_DB(conn , trx , kpi_pool_templete_id , kpi_pool_ref_id , create_date , create_user); } trx.Commit(); } catch (Exception ex) { reVal = ex.Message; trx.Rollback(); return(ex.Message); } finally { conn.Close(); } return(reVal); }
public string RemoveData_DB(string kpi_pool_templete_id) { string reVal = string.Empty; int affectedRow = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete dacBscKpiPoolTemplete = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete(); MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete_MAP dacBscKpiPoolTempleteMap = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete_MAP(); try { affectedRow = dacBscKpiPoolTemplete.DeleteData_DB(conn , trx , kpi_pool_templete_id); affectedRow = dacBscKpiPoolTempleteMap.DeleteData_DB(conn , trx , kpi_pool_templete_id); trx.Commit(); } catch (Exception ex) { reVal = ex.Message; trx.Rollback(); return(ex.Message); } finally { conn.Close(); } return(reVal); }
public DataTable GetBscKpiPoolTempleteMap_DB(string kpi_pool_templete_id) { MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete_MAP dacBscKpiPoolTempleteMap = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete_MAP(); return(dacBscKpiPoolTempleteMap.SelectData_DB(kpi_pool_templete_id)); }