Esempio n. 1
0
        public bool RemoveMenuinfo(DataTable dataTable)
        {
            int affectedRow = 0;

            IDbConnection conn = DbAgentHelper.CreateDbConnection();

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

            Dac_RoleMenuRels _roleMenuRel = new Dac_RoleMenuRels();

            try
            {
                foreach (DataRow dataRow in dataTable.Rows)
                {
                    affectedRow += _dac_menuinfo.Delete(conn
                                                        , trx
                                                        , DataTypeUtility.GetToInt32(dataRow["MENU_REF_ID"]));

                    affectedRow += _roleMenuRel.Delete(conn
                                                       , trx
                                                       , 0
                                                       , DataTypeUtility.GetToInt32(dataRow["MENU_REF_ID"]));
                }

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

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