/// <summary>
/// 添加新菜单
/// </summary>
/// <param name="data"></param>
/// <param name="resultMsg"></param>
/// <returns></returns>
public override bool AddMenu(Menu data, ref string resultMsg)
{
try
{
using (MyWebContext context = new MyWebContext())
{
var dbData = context.Menus.Find(data.MenuCode);
if (dbData != null)
{
resultMsg = String.Format("代码为 {0} 的数据已存在！", data.MenuCode);
return(false);
}
if (String.IsNullOrEmpty(data.ParentMenuCode))
{
// 根节点的 父节点为空.
data.ParentMenuCode = null;
}
context.Menus.Add(data);
// 物理保存.
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
resultMsg = ex.Message;
return(false);
}
}
/// <summary>
/// 获取全部的菜单数据.
/// </summary>
/// <returns></returns>
protected override List <Menu> GetAllMenuData()
{
using (MyWebContext context = new MyWebContext())
{
var query =
from data in context.Menus.Include("MenuPage")
select data;
List <Menu> resultList = query.ToList();
return(resultList);
}
}
public override Menu GetMenu(string code)
{
using (MyWebContext context = new MyWebContext())
{
var query =
from data in context.Menus.Include("MenuPage")
where
data.MenuCode == code
select data;
Menu result = query.FirstOrDefault();
return(result);
}
}
/// <summary>
/// 获取指定菜单的子菜单.
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public override List <Menu> GetSubMenu(string code)
{
using (MyWebContext context = new MyWebContext())
{
var query =
from data in context.Menus.Include("MenuPage")
where
data.ParentMenuCode == code
orderby
data.DisplayIndex
select data;
List <Menu> resultList = query.ToList();
return(resultList);
}
}
public List <Page> GetSubPageList(string code)
{
using (MyWebContext context = new MyWebContext())
{
var query =
from data in context.Pages
where
data.ParentPageCode == code
orderby
data.DisplayIndex
select
data;
var resultList = query.ToList();
return(resultList);
}
}
/// <summary>
/// 编辑菜单.
/// </summary>
/// <param name="data"></param>
/// <param name="resultMsg"></param>
/// <returns></returns>
public override bool EditMenu(Menu data, ref string resultMsg)
{
try
{
using (MyWebContext context = new MyWebContext())
{
var dbData = context.Menus.Find(data.MenuCode);
if (dbData == null)
{
resultMsg = String.Format("代码为 {0} 的数据不存在！", data.MenuCode);
return(false);
}
// 父节点.
dbData.ParentMenuCode = data.ParentMenuCode;
if (String.IsNullOrEmpty(dbData.ParentMenuCode))
{
// 根节点的 父节点为空.
dbData.ParentMenuCode = null;
}
// 显示顺序.
dbData.DisplayIndex = data.DisplayIndex;
// 菜单文本.
dbData.MenuText = data.MenuText;
// 描述.
dbData.MenuDesc = data.MenuDesc;
// 扩展信息.
dbData.MenuExpand = data.MenuExpand;
// 物理保存.
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
resultMsg = ex.Message;
return(false);
}
}
public void Log(string userName, string userPassword)
{
try
{
AdminInformationsTable adminTable = (from p in _loginContext.AdminInformations select p).First();
if (userName == adminTable.AdminName && userPassword == adminTable.AdminPassword)
{
status = true;
}
else
{
status = false;
}
}
catch (Exception)
{
_adminMainTable.AdminName = "admin";
_adminMainTable.AdminPassword = "******";
using (MyWebContext db = new MyWebContext())
{
db.AdminInformations.Add(_adminMainTable);
db.SaveChanges();
}
_adminMainTable = (from p in _loginContext.AdminInformations select p).First();
if (userName == _adminMainTable.AdminName && userPassword == _adminMainTable.AdminPassword)
{
status = true;
}
else
{
status = false;
}
}
}
/// <summary>
/// 删除菜单.
/// </summary>
/// <param name="menuCode"></param>
/// <param name="resultMsg"></param>
/// <returns></returns>
public override bool RemoveMenu(string menuCode, ref string resultMsg)
{
try
{
using (MyWebContext context = new MyWebContext())
{
var dbData = context.Menus.Find(menuCode);
if (dbData == null)
{
resultMsg = String.Format("代码为 {0} 的数据不存在！", menuCode);
return(false);
}
// 判断当前菜单， 是否有子菜单.
if (dbData.SubMenus.Count() > 0)
{
foreach (var subMenu in dbData.SubMenus)
{
// 子节点的父节点 = 当前被删除节点的父节点.
subMenu.ParentMenuCode = dbData.ParentMenuCode;
}
}
// 删除.
context.Menus.Remove(dbData);
// 物理保存.
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
resultMsg = ex.Message;
return(false);
}
}
static void Main(string[] args)
{
// 当 Code First 与数据库结构不一致时
// 自动升级到最新的版本.
Database.SetInitializer(new MigrateDatabaseToLatestVersion <MyWebContext, MyWeb.Migrations.Configuration>());
using (MyWebContext context = new MyWebContext())
{
var query =
from data in context.WebSites
select data;
foreach (var item in query)
{
Console.WriteLine(item);
}
}
Console.WriteLine("Finish!");
Console.ReadLine();
}
public ModelMedia()
{
_mediaContext = new MyWebContext();
_mediasTable = new MediasTable();
}
public ModelSocialMedia()
{
_socialContext = new MyWebContext();
_socialMediasTable = new SocialMediasTable();
}
public ContactController()
{
_contactContext = new MyWebContext();
_modelContact = new ModelContact();
_messageTable = new MessagesTable();
}
public ModelArticle()
{
_articlesContext = new MyWebContext();
_articlesTable = new ArticlesTable();
}
public ModelContact()
{
_messagesTable = new MessagesTable();
_contactContext = new MyWebContext();
}
public ModelMail()
{
_mailContext = new MyWebContext();
_mailsTable = new MailsTable();
}
public LoginCore()
{
_adminMainTable = new AdminInformationsTable();
_loginContext = new MyWebContext();
}
public ModelHome()
{
_homeContext = new MyWebContext();
}
public ModelWhatIDo()
{
_whatIDoContext = new MyWebContext();
_whatIDoTable = new WhatIDoTable();
}
public CustomUserStore(MyWebContext dbContext)
: base(dbContext)
{
_users = (DbSet <User>)dbContext.Set <User>();
}
public PageRepository(MyWebContext db)
{
this.DB = db;
}
public ModelInformation()
{
_admContext = new MyWebContext();
}
public ModelSearch()
{
_searchContext = new MyWebContext();
}
public ModelTags()
{
_tagsContext = new MyWebContext();
}
public ContentDetailController()
{
_detailContext = new MyWebContext();
_commentTable = new CommentsTable();
_modelDetail = new ModelDetail();
}
public AdmContactController()
{
_contactContext = new MyWebContext();
_contactsTable = new ContactsTable();
_modelContact = new ModelContact();
}
public ModelFile()
{
_fileContext = new MyWebContext();
}
public ModelDetail()
{
_detailContext = new MyWebContext();
_commentTable = new CommentsTable();
}
public ModelContact()
{
_contactContext = new MyWebContext();
_contactsTable = new ContactsTable();
}
public ModelSeo()
{
_seoContentsTable = new SeoContentsTable();
_seoContext = new MyWebContext();
}
public ModelComment()
{
_commentContext = new MyWebContext();
}
