public JsonResult GetQE_InfobyPerson() { int p_id = (Session["User"] as EquipModel.Entities.Person_Info).Person_Id; List <object> r = new List <object>(); QEntranceManagment qem = new QEntranceManagment(); Quick_Entrance[] qe = new Quick_Entrance[8] { null, null, null, null, null, null, null, null }; List <Quick_Entrance> QE = new List <Quick_Entrance>(); QE = qem.GetQ_EbyP_Id(p_id); foreach (var q in QE) { qe[q.xuhao - 1] = q; } for (int i = 0; i < 8; i++) { if (qe[i] == null) { object o = new { menuname = "", menulink = "", qe_id = i + 1 }; r.Add(o); } else { object o = new { menuname = qe[i].Menu.Menu_Name, menulink = qe[i].Menu.Link_Url, qe_id = qe[i].xuhao }; r.Add(o); } } return(Json(r.ToArray())); }
public bool AddQ_Entrance(int p_id, int m_id, int q_id) { //Menus ms = new Menus(); //Menu m = ms.GetMenu(m_id); //Person_Infos pis = new Person_Infos(); //Person_Info p = pis.GetPerson_info(p_id); using (var db = base.NewDB()) { try { //Quick_Entrance q_e = db.Quick_Entrance.Where(a => a.Quick_Entrance_id== q_id&&a.Person_Info.Person_Id==p_id).First(); var q_e = db.Quick_Entrance.Where(a => a.xuhao == q_id && a.Person_Info.Person_Id == p_id).ToList(); if (q_e.Count() != 0) { q_e.First().Menu = db.Sys_Menus.Where(a => a.Menu_Id == m_id).First(); db.SaveChanges(); return(true); } else { Quick_Entrance QE = new Quick_Entrance(); db.Quick_Entrance.Add(QE); QE.Menu = db.Sys_Menus.Where(a => a.Menu_Id == m_id).First(); QE.Person_Info = db.Persons.Where(a => a.Person_Id == p_id).First(); QE.xuhao = q_id; db.SaveChanges(); return(true); } } catch (Exception e) { return(false); } } }