Exemplo n.º 1
0
        public bool RemoveCtrlInfo(string ctrl_id)
        {
            int affectedRow = 0;

            Dac_CtrlEstMaps  ctrlEstMap  = new Dac_CtrlEstMaps();
            Dac_CtrlDeptMaps ctrlDeptMap = new Dac_CtrlDeptMaps();

            IDbConnection conn = DbAgentHelper.CreateDbConnection();

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

            try
            {
                affectedRow += ctrlDeptMap.Delete(conn
                                                  , trx
                                                  , ctrl_id
                                                  , 0);

                affectedRow += ctrlEstMap.Delete(conn
                                                 , trx
                                                 , ctrl_id
                                                 , "");

                affectedRow += _ctrlInfo.Delete(conn
                                                , trx
                                                , ctrl_id
                                                , 0
                                                , "");

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

            return((affectedRow > 0) ? true : false);
        }