public string AddData_DB(string kpi_pool_ver_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_Ver_MAP dacBscKpiPoolVerMap = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver_MAP();
affectedRow = dacBscKpiPoolVerMap.DeleteData_DB(conn
, trx
, kpi_pool_ver_id);
try
{
foreach (string kpi_pool_ref_id in kpi_pool_ref_id_list)
{
affectedRow = dacBscKpiPoolVerMap.InsertData_DB(conn
, trx
, kpi_pool_ver_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_ver_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_Ver dacBscKpiPoolVer = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver_MAP dacBscKpiPoolVerMap = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver_MAP();
try
{
affectedRow = dacBscKpiPoolVer.DeleteData_DB(conn
, trx
, kpi_pool_ver_id);
affectedRow = dacBscKpiPoolVerMap.DeleteData_DB(conn
, trx
, kpi_pool_ver_id);
trx.Commit();
}
catch (Exception ex)
{
reVal = ex.Message;
trx.Rollback();
return(ex.Message);
}
finally
{
conn.Close();
}
return(reVal);
}
public DataTable GetBscKpiPoolVerMap_DB(string kpi_pool_ver_id)
{
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver_MAP dacBscKpiPoolVerMap = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver_MAP();
return(dacBscKpiPoolVerMap.SelectData_DB(kpi_pool_ver_id));
}
