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); }