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