public bool Person_LinkEAs(int Person_id, List <int> EquipArchi_IDs) { try { using (var db = base.NewDB()) { var p = db.Persons.Where(s => s.Person_Id == Person_id).First(); var ps_old = p.Person_EquipEAs.ToList(); if (ps_old.Count > 0) { p.Person_EquipEAs.Clear(); } foreach (var item in EquipArchi_IDs) { Equip_Archi r = db.EArchis.Where(s => s.EA_Id == item).First(); p.Person_EquipEAs.Add(r); } db.SaveChanges(); return(true); } } catch { return(false); } }
public List <Equip_Archi> getZzByPerson(int Person_Id) { using (var db = base.NewDB()) { try { //Equip_Archi EA = new Equip_Archi(); Equip_Archi EA; List <Equip_Archi> EA_list = new List <Equip_Archi>(); // var EA_Set = db.EArchis.Where(a => a.EA_Title == "车间" && a.EA_Childs.Where(s => s.Equips_Belong.Where(t => t.Equip_Manager.Where(b => b.Person_Id == Person_Id).Count() > 0).Count() > 0).Count() > 0); var EA_Set = db.EArchis.Where(a => a.EA_Title == "装置" && a.Equips_Belong.Where(t => t.Equip_Manager.Where(b => b.Person_Id == Person_Id).Count() > 0).Count() > 0); foreach (var item in EA_Set) { EA = new Equip_Archi(); EA.EA_Id = item.EA_Id; EA.EA_Name = item.EA_Name; EA.EA_Code = item.EA_Code; EA.EA_Title = item.EA_Title; EA_list.Add(EA); } return(EA_list); } catch { return(null); } } }
//修改设备信息相关信息 //参数:New_Equip_Info 新的设备信息 //装置 EA_Id 新的设备所属装置Id public bool ModifyEquip(Equip_Info New_Equip_Info, int EA_Id) { using (var db = base.NewDB()) { try { var E = db.Equips.Where(a => a.Equip_Code == New_Equip_Info.Equip_Code).First(); Equip_Archi eItem = db.EArchis.Where(a => a.EA_Id == EA_Id && a.EA_Title == "装置").First(); if (E == null || eItem == null) { return(false); } else { E.Equip_ABCmark = New_Equip_Info.Equip_ABCmark; E.Equip_Code = New_Equip_Info.Equip_Code; E.Equip_ManufactureDate = New_Equip_Info.Equip_ManufactureDate; E.Equip_Manufacturer = New_Equip_Info.Equip_Manufacturer; E.Equip_PhaseB = New_Equip_Info.Equip_PhaseB; E.Equip_Specialty = New_Equip_Info.Equip_Specialty; E.Equip_Type = New_Equip_Info.Equip_Type; E.Equip_GyCode = New_Equip_Info.Equip_GyCode; E.Equip_Location = New_Equip_Info.Equip_Location; E.Equip_PerformanceParasJson = New_Equip_Info.Equip_PerformanceParasJson; E.Equip_Location = eItem; db.SaveChanges(); return(true); } } catch { return(false); } } }
public List <Equip_Archi> getEquip_ZzBelong(int Equip_Id) { List <Equip_Archi> E_ZzCjInfo = new List <Equip_Archi>(); Equip_Archi m = Es.getEquip_EA(Equip_Id); E_ZzCjInfo.Add(m); E_ZzCjInfo.Add(EAs.getEA_Parent(m.EA_Id)); return(E_ZzCjInfo); }
//添加一个菜单 //parentID == -1 ,添加到根节点 public bool AddEquipArchiItem(int parent_Id, Equip_Archi add) { if (parent_Id == -1) { Equip_Archi root = GetRootItem(); return(db_equip_archi.AddEquipArchi(root.EA_Id, add)); } else { return(db_equip_archi.AddEquipArchi(parent_Id, add)); } }
public Equip_Archi getEA_Archi(int EA_Id) { using (var db = base.NewDB()) { try { Equip_Archi EA = db.EArchis.Where(a => a.EA_Id == EA_Id).First(); return(EA); } catch { return(null); } } }
public List <Equip_Archi> getEAs_isCj() { using (var db = base.NewDB()) { try { Equip_Archi EA = db.EArchis.Where(a => a.EA_Title == "车间").First(); return(EA.EA_Childs.ToList()); } catch { return(null); } } }
public List <Equip_Archi> getEA_Childs(string EA_Name) { using (var db = base.NewDB()) { try { Equip_Archi EA = db.EArchis.Where(a => a.EA_Name == EA_Name).First(); return(EA.EA_Childs.ToList()); } catch { return(null); } } }
public JsonResult Additem(string json1) { JObject item = (JObject)JsonConvert.DeserializeObject(json1); Equip_Archi new_menu = new Equip_Archi(); new_menu.EA_Id = Convert.ToInt32(item["EA_Id"].ToString()); new_menu.EA_Name = item["EA_Name"].ToString(); new_menu.EA_Code = item["EA_Code"].ToString(); new_menu.EA_Title = item["EA_Title"].ToString(); bool res = menuconfig.AddEquipArchiItem(Convert.ToInt32(item["Parent_id"].ToString()), new_menu); return(Json(new { result = res })); }
public bool AddEA_Euip(int EA_Id, Equip_Info New_Equip_Info) { using (var db = base.NewDB()) { try { Equip_Archi EA = db.EArchis.Where(a => a.EA_Id == EA_Id).First(); if (EA == null) { return(false); } EA.Equips_Belong.Add(New_Equip_Info); db.SaveChanges(); return(true); } catch { return(false); } } }
//添加设备,并将其和装置建立链接 public bool AddEquip(Equip_Info New_Equip_Info, int ZzId) { try { using (var db = base.NewDB()) { Equip_Info e = db.Equips.Add(New_Equip_Info); Equip_Archi eItem = db.EArchis.Where(a => a.EA_Id == ZzId).First(); e.Equip_Location = eItem; db.SaveChanges(); return(true); } } catch { return(false); } }
public bool ModifyEquip_Archi(int EA_Id, Equip_Archi New_Equip_Archi) { using (var db = base.NewDB()) { try { Equip_Archi EA = db.EArchis.Where(a => a.EA_Id == EA_Id).First(); if (EA == null) { return(false); } EA.EA_Name = New_Equip_Archi.EA_Name; EA.EA_Title = New_Equip_Archi.EA_Title; db.SaveChanges(); return(true); } catch { return(false); } } }
public bool DeleteEquip_Archi(int EA_Id) { using (var db = base.NewDB()) { try { Equip_Archi EA = db.EArchis.Where(a => a.EA_Id == EA_Id).First(); if (EA == null) { return(false); } EA.Equips_Belong.Clear(); db.EArchis.Remove(EA); db.SaveChanges(); return(true); } catch { return(false); } } }
public bool AddEquipArchi(int parentID, Equip_Archi newMenu) { using (var db = base.NewDB()) { try { Equip_Archi parent = db.EArchis.Where(a => a.EA_Id == parentID).First(); if (parent == null) { return(false); } parent.EA_Childs.Add(newMenu); db.SaveChanges(); return(true); } catch { return(false); } } }
public List <Equip_Info> getEA_Equips(int EA_Id, string username = null) { List <Equip_Info> E = new List <Equip_Info>(); using (var db = base.NewDB()) { try { if (username != null && username != "sa") { //List<Equip_Info> e = db.Persons.Where(a => a.Person_Name == username).First().Person_Equips.ToList(); //foreach (var temp in e) //{ // if (temp.Equip_Location.EA_Id == EA_Id) // E.Add(temp); //} //return E; E = db.Equips.Where(a => a.Equip_Specialty == "动" && a.Equip_Location.EA_Id == EA_Id).ToList(); return(E); } else if (username == "sa") { Equip_Archi EA = db.EArchis.Where(a => a.EA_Id == EA_Id).First(); return(EA.Equips_Belong.ToList()); } else { E = db.Equips.Where(a => a.Equip_Specialty == "动" && a.Equip_Location.EA_Id == EA_Id).ToList(); return(E); } } catch { return(null); } } }
public List <MenuListNode1> BuildMenuList() { Equip_Archi root = GetRootItem(); MenuListNode1 rmn = new MenuListNode1(); rmn.EA_Id = root.EA_Id; rmn.EA_Name = root.EA_Name; rmn.EA_Code = root.EA_Code; rmn.EA_Title = root.EA_Title; rmn.level = -1; List <MenuListNode1> list = new List <MenuListNode1>(); BuildMenuList_inter(rmn, list); foreach (MenuListNode1 mn in list) { if (mn.Parent_id == root.EA_Id) { mn.Parent_id = 0; } } return(list); }
//修改一个菜单 public bool ModifyEquipArchiItem(Equip_Archi modify) { return(db_equip_archi.ModifyEquipArchi(modify.EA_Id, modify)); }