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