public ActionResult updateOrgRoles()
{
IEnumerable <string> Ids = Request.Params["IDs"].Split(",".ToArray()).AsEnumerable(); //新的角色ID串
string orgID = Request.Params["orgID"];
using (MyDB mydb = new MyDB())
{
EntityObjectLib.Organization org = mydb.Organizations.Find(orgID);
IQueryable <string> OriRoleIDs = org.Roles.Select(r => r.ID) == null ? null : org.Roles.Select(r => r.ID).AsQueryable();
OriRoleIDs.Load();
string[] removeIDS = OriRoleIDs.Except(Ids).ToArray();
foreach (string s in removeIDS)
{
org.Roles.Remove(mydb.Roles.Find(s));
}
string[] appendIDS = Ids.Except(OriRoleIDs).ToArray();
foreach (string s in appendIDS)
{
org.Roles.Add(mydb.Roles.Find(s));
}
mydb.SaveChanges();
}
return(Json(new { success = true }));
}
public ActionResult DeleteOrg()
{
using (MyDB mydb = new MyDB())
{
EntityObjectLib.Organization p = mydb.Organizations.Find(Request.Form["ID"]);
mydb.Organizations.Remove(p);
mydb.SaveChanges();
}
return(Json(new { success = true }));
}
private EntityObjectLib.Organization getOrg(HttpRequestBase request, MyDB mydb)
{
EntityObjectLib.Organization p = mydb.Organizations.Find(Request.Form["ID"]);
if (p == null)
{
p = new EntityObjectLib.Organization();
}
p.ID = request.Form["ID"];
p.Code = request.Form["Code"];
p.Name = request.Form["Name"];
return(p);
}
public ActionResult UpdateOrg()
{
using (MyDB mydb = new MyDB())
{
EntityObjectLib.Organization p = getOrg(Request, mydb);
////mydb.Modules.Attach(p);
//mydb.Entry<EntityObjectLib.User>(p).State = System.Data.EntityState.Modified;
//mydb.Entry<EntityObjectLib.Organization>(p.Organization).State = System.Data.EntityState.Modified;
mydb.SaveChanges();
}
return(Json(new { success = true }));
}
public ActionResult getOrg()
{
using (MyDB mydb = new MyDB())
{
EntityObjectLib.Organization p = mydb.Organizations.Find(Request.Form["ID"]);
return(Json(new
{
success = true,
data = new { p.ID, p.Code, p.Name, p.OrderNO }
}
));
}
}
private object getOrg(string OrgID, MyDB mydb)
{
EntityObjectLib.Organization org = mydb.Organizations.Local.FirstOrDefault(o => o.ID.Equals(OrgID));
return(new
{
ID = OrgID,
org.Name,
org.Code,
//expanded = true,
leaf = org.Children.Count == 0 /*org.Children.Count() == 0*/,
//@checked = false,
//iconCls = "icon-org",
children = org.Children.Select(o => getOrg(o.ID, mydb)).ToArray()
});
}
public ActionResult CreateOrg()
{
//将JSON格式转换为Module类型
//return Json(new { success = false, errors = new { clientCode = "", portOfLoading = "" } });
using (MyDB mydb = new MyDB())
{
EntityObjectLib.Organization p = getOrg(Request, mydb);
p.ID = Guid.NewGuid().ToString();
mydb.Organizations.Add(p);
mydb.SaveChanges();
}
return(Json(new { success = true }));
}
private object getOrgAndUser(string OrgID, MyDB mydb)
{
EntityObjectLib.Organization org = mydb.Organizations.Local.FirstOrDefault(o => o.ID.Equals(OrgID));
return(new
{
id = OrgID,
text = org.Name,
expanded = true,
leaf = org.Users.Count == 0 && org.Children.Count == 0 /*org.Children.Count() == 0*/,
//@checked = false,
//iconCls = "icon-org",
children =
org.Children.Select(o => getOrgAndUser(o.ID, mydb))
.Union(org.Users.Select(u => new { id = u.Code, text = u.Name, leaf = true, iconCls = "icon-user", @checked = false }))
.ToArray()
});
}
public ActionResult updateOrgUsers()
{
IEnumerable <string> Ids = Request.Params["IDs"].Split(",".ToArray()).AsEnumerable(); //新的用户ID串
string orgID = Request.Params["orgID"];
using (MyDB mydb = new MyDB())
{
EntityObjectLib.Organization org = mydb.Organizations.Find(orgID);
mydb.Users.Load();
foreach (string userID in Ids)
{
mydb.Users.Local.FirstOrDefault(u => u.ID.Equals(userID)).Organization = org;
}
mydb.SaveChanges();
}
return(Json(new { success = true }));
}
