/// <summary> /// 删除一条数据,及子表所有相关数据 /// </summary> public bool Delete(int id) { Hashtable sqllist = new Hashtable(); //删除管理角色权限 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "manager_role_value "); strSql.Append(" where role_id=@role_id"); MySqlParameter[] parameters = { new MySqlParameter("@role_id", MySqlDbType.Int32, 4) }; parameters[0].Value = id; sqllist.Add(strSql.ToString(), parameters); //删除管理角色 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "manager_role "); strSql2.Append(" where id=@id"); MySqlParameter[] parameters2 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters2[0].Value = id; sqllist.Add(strSql2.ToString(), parameters2); bool result = DbHelperMySql.ExecuteSqlTran(sqllist); if (result) { return(true); } else { return(false); } }