コード例 #1
0
        public string AddData_DB(string kpi_pool_ver_name
                                 , string kpi_pool_ver_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_Ver dacBscKpiPoolVer = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver();

            try
            {
                int kpi_pool_ver_id = dacBscKpiPoolVer.SelectMax_DB(conn, trx);

                affectedRow += dacBscKpiPoolVer.InsertData_DB(conn
                                                              , trx
                                                              , kpi_pool_ver_id
                                                              , kpi_pool_ver_name
                                                              , kpi_pool_ver_note
                                                              , create_date
                                                              , create_user);

                trx.Commit();
            }
            catch (Exception ex)
            {
                reVal = ex.Message;
                trx.Rollback();
                return(ex.Message);
            }
            finally
            {
                conn.Close();
            }

            return(reVal);
        }
コード例 #2
0
        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);
        }
コード例 #3
0
        public DataTable GetBscKpiPoolVer_DB()
        {
            MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver dacBscKpiPoolVer = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Pool_Ver();

            return(dacBscKpiPoolVer.Select_DB());
        }