Пример #1
0
        public string Delete_DB(int IDX, int UPDATE_USER)
        {
            string rtnValue = string.Empty;

            int           okCnt = 0;
            IDbConnection conn  = DbAgentHelper.CreateDbConnection();

            conn.Open();
            IDbTransaction trx = conn.BeginTransaction();

            try
            {
                MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq();

                okCnt = dacBscFaq.Delete_DB(conn, trx, IDX, UPDATE_USER);

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

            return(rtnValue);
        }
Пример #2
0
        public string Insert_DB(int FAQ_CATEGORY
                                , string FAQ_QUESTION
                                , string FAQ_ANSWER
                                , int CREATE_USER)
        {
            string rtnValue = string.Empty;

            int           okCnt = 0;
            IDbConnection conn  = DbAgentHelper.CreateDbConnection();

            conn.Open();
            IDbTransaction trx = conn.BeginTransaction();

            try
            {
                MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq();
                okCnt = dacBscFaq.InsertData_DB(conn, trx, FAQ_CATEGORY, FAQ_QUESTION, FAQ_ANSWER, CREATE_USER);
                trx.Commit();
            }
            catch (Exception ex)
            {
                rtnValue = ex.Message;
                trx.Rollback();
            }
            finally
            {
                conn.Close();
            }
            return(rtnValue);
        }
Пример #3
0
 public DataTable SelectBscFaqIdxAll(int IDX)
 {
     MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq();
     return(dacBscFaq.SelectBscFaqIdxAll(IDX));
 }
Пример #4
0
 public DataTable SelectBscFaqCateAll(int faq_category)
 {
     MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq();
     return(dacBscFaq.SelectBscFaqCateAll(faq_category));
 }
Пример #5
0
 public DataTable SelectBscFaqAll(string question)
 {
     MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq dacBscFaq = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Faq();
     return(dacBscFaq.SelectBscFaqAll(question));
 }