public bool delete(string systemId)
{
using (AuthorizeEntities context = new AuthorizeEntities())
{
try
{
Guid guserId = new Guid(systemId);//从子表开始删除 一直到system表
var userid = from userinfo in context.User
where userinfo.UserID == guserId
select userinfo;
var userSystem = from usersys in context.UserSystem
where usersys.UserSystemID == guserId
select usersys;
var sys = from system in context.System
where system.SystemID == guserId
select system;
if (userid.FirstOrDefault() != null)
{
context.DeleteObject(userSystem.First());
context.SaveChanges();
}
if (userid.FirstOrDefault() != null)
{
context.DeleteObject(userid.First());
context.SaveChanges();
}
if (userid.FirstOrDefault() != null)
{
context.DeleteObject(sys.First().UserSystems);
context.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
return true;
}
}
