public string AddData_DB(string kpi_pool_templete_name
, string kpi_pool_templete_note
, 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 dacBscKpiPoolTemplete = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete();
try
{
int kpi_pool_templete_id = dacBscKpiPoolTemplete.SelectMax_DB(conn, trx);
affectedRow += dacBscKpiPoolTemplete.InsertData_DB(conn
, trx
, kpi_pool_templete_id
, kpi_pool_templete_name
, kpi_pool_templete_note
, 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 GetBscKpiPoolTemplete_DB()
{
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete dacBscKpiPoolTemplete = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Templete();
return(dacBscKpiPoolTemplete.Select_DB());
}
