ok-admin框架，第七天菜单列表

后台代码：

using Newtonsoft.Json;
using StudentSys.data;
using StudentSys.Filter;
using StudentSys.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Web;
using System.Web.Mvc;

namespace StudentSys.Controllers
{
[LoginFilter]
public class MenuListController : Controller
{
// GET: MenuList

public ActionResult Index()
{
return View();
}
///

/// 分页数据
///

///
///
///
public string LoadPageList(int page, int limit, SysMenu where)
{
//实例化数据库上下文
YuanGongDb dbcontext = new YuanGongDb();
List data = null;
Expression> wherelambad = u => 1 == 1;//查询条件;
if (where.name != null && where.name != "")
{
//Contains模糊查找
wherelambad = wherelambad = u => u.name.Contains(where.name);
}
int count = 0;
data = dbcontext.SysMenu.Where(wherelambad).OrderBy(o => o.createtime)
.Skip((page - 1) * limit).Take(limit).ToList();
count = dbcontext.SysMenu.Where(wherelambad).Count();
var result = new
{
code = 0,
count = count,
data = data,
msg = ""
};
return JsonConvert.SerializeObject(result);
}

///

/// 加载上级菜单
///

///
public ActionResult InitMenus()
{
YuanGongDb dbcontext = new YuanGongDb();
List data = dbcontext.SysMenu.Where(o=>o.pid==0&&o.type=="1").ToList();
return Json(data, JsonRequestBehavior.AllowGet);
}

///

/// 新增页面
///

///
public ActionResult Add()
{
return View();
}
///

/// 新增菜单
///

///
///
[HttpPost]
public string Add(SysMenu _user)
{
//User _user
//实例化数据库上下文
YuanGongDb dbcontext = new YuanGongDb();
SysMenu model = new SysMenu();
model.name = _user.name;
model.url = _user.url;
model.type = _user.type;
model.pid = _user.pid;
model.createtime = DateTime.Now.ToString();
model.updatetime = DateTime.Now.ToString();
ResponseData res = new ResponseData();//返回的数据格式code,msg
dbcontext.SysMenu.Add(model);
if (dbcontext.SaveChanges() > 0)
{
res.code = 0;
res.msg = "菜单添加成功";
var data = JsonConvert.SerializeObject(res);
return data;
}
else
{
res.code = 1;
res.msg = "菜单添加失败";
var data = JsonConvert.SerializeObject(res);
return data;
}
}

///

/// 更新页面
///

///
public ActionResult Update()
{
int id = int.Parse(Request["id"]);
YuanGongDb dbcontext = new YuanGongDb();
var data = dbcontext.SysMenu.FirstOrDefault(o => o.id == id);
return View(data);
}

///

/// 更新菜单
///

///
///
[HttpPost]
public string Update(SysMenu _user)
{
YuanGongDb dbcontext = new YuanGongDb();
ResponseData res = new ResponseData();//返回的数据格式code,msg
var entity = dbcontext.Set().FirstOrDefault(o => o.id == _user.id);
entity.name = _user.name;
entity.url = _user.url;
entity.type = _user.type;
entity.pid = _user.pid;
entity.updatetime = DateTime.Now.ToString();
if (dbcontext.SaveChanges() > 0)
{
res.code = 0;
res.msg = "更新成功";
var data = JsonConvert.SerializeObject(res);
return data;
}
else
{
res.code = 1;
res.msg = "更新失败";
var data = JsonConvert.SerializeObject(res);
return data;
}
}
}
}

前台代码：

@{
ViewBag.Title = "菜单列表";
Layout = null;
}