/// <summary> /// 新增 /// </summary> /// <returns></returns> public static int Add(VModel.SyNav.Form m) { using (var db = new fz_basicEntities()) { if (db.sy_nav.Where(w => w.SId == m.SId && w.Name == m.Name.Trim()).Count() > 0) { return(-1);//导航已存在 } sy_nav dbm = new sy_nav { PId = m.PId == null?db.sy_nav.Where(w => w.Type == 3 && w.SId == m.SId).Select(s => s.Id).FirstOrDefault() : m.PId, Type = m.PId == null ? 1 : 2, Name = m.Name, SId = m.SId, Url = m.Url, PageOpen = m.PageOpen, Icon = m.Icon, Level = m.PId == null ? 1 : 2, Sort = m.Sort, IsEnabled = m.IsEnabled, IsSystem = true }; db.sy_nav.Add(dbm); db.SaveChanges(); } Common.Caches.RemoveCache("sy_nav"); return(200); }
/// <summary> /// 编辑 /// </summary> /// <returns></returns> public static int Edit(VModel.SyNav.Form m) { using (var db = new fz_basicEntities()) { sy_nav dbm = db.sy_nav.Find(m.Id); if (dbm.Name.Trim() != m.Name.Trim() && db.sy_nav.Where(w => w.SId == m.SId && w.Name == m.Name.Trim()).Count() > 0) { return(-1);//导航已存在 } dbm.PId = m.PId == null?db.sy_nav.Where(w => w.Type == 3 && w.SId == m.SId).Select(s => s.Id).FirstOrDefault() : m.PId; dbm.Name = m.Name; //dbm.Type = m.PId == null ? 1 : 2; dbm.Url = m.Url; dbm.PageOpen = m.PageOpen; //dbm.Level = m.PId == null ? 1 : 2; dbm.Icon = m.Icon; dbm.Sort = m.Sort; dbm.IsEnabled = m.IsEnabled; db.SaveChanges(); } Common.Caches.RemoveCache("sy_nav"); return(200); }
/// <summary> /// 新增 /// </summary> /// <returns></returns> public static int Add(VModel.SySystem.Form m) { using (var db = new fz_basicEntities()) { sy_system dbm = new sy_system { PId = m.PId, Type = 2, Name = m.Name, IsNav = m.IsNav, Url = m.Url, PageOpen = m.PageOpen, Level = 2, Sort = m.Sort, IsEnabled = m.IsEnabled, IsSystem = true }; sy_nav dbnav = new sy_nav { SId = dbm.Id, Type = 3, Name = dbm.Name, PageOpen = dbm.PageOpen, Level = 1, Sort = dbm.Sort, IsEnabled = dbm.IsEnabled, IsSystem = dbm.IsSystem }; db.sy_system.Add(dbm); db.sy_nav.Add(dbnav); db.SaveChanges(); } Common.Caches.RemoveCache("sy_system"); return(200); }