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