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