public JsonResult Insert(sysmenu menu)
{
string msg = ValidInput(menu);
OperateResultModel orm = new OperateResultModel();
if (string.IsNullOrEmpty(msg))
{
DateTime dtnow = DateTime.Now;
UserModel um = SessionUser;
menu.creater = um.UserNo;
menu.createdate = dtnow;
menu.editer = um.UserNo;
menu.editdate = dtnow;
Permission permission = new Permission();
orm = permission.InsertMenu(menu);
orm.rows = menu;
}
else
{
orm.success = false;
orm.message = msg;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
/// <summary>
/// 修改操作
/// </summary>
/// <param name="db"></param>
/// <param name="model"></param>
/// <param name="adminUser"></param>
/// <returns></returns>
public ResultJson Change(SqlSugarClient db, sysmenu model, string adminUser)
{
var json = new ResultJson()
{
backurl = "close", msg = "保存成功~"
};
model.UpdateDate = DateTime.Now;
model.SysID = 1;
if (model.ID == 0)
{
var tempM = db.Insertable(model).ExecuteReutrnIdentity();
if (model.ParentId > 0)
{
//说明有父级 根据父级，查询对应的模型
var parModel = db.Queryable <sysmenu>().InSingle(model.ParentId);
if (parModel != null)
{
model.ClassList = parModel.ClassList + Convert.ToInt32(tempM) + ",";
model.ClassLayer = parModel.ClassLayer + 1;
model.ID = Convert.ToInt32(tempM);
}
}
else
{
//没有父级
model.ClassList = "," + Convert.ToInt32(tempM) + ",";
}
db.Updateable(model).ExecuteCommand();
}
else
{
//判断修改之前的父级栏目是否和当前的相当
if (FytRequest.GetFormInt("SouParentId") != model.ParentId)
{
//不相等更改等级
var parModel = db.Queryable <sysmenu>().InSingle(model.ParentId);
if (parModel != null)
{
model.ClassList = parModel.ClassList + model.ID + ",";
model.ClassLayer = parModel.ClassLayer + 1;
}
}
db.Updateable(model).ExecuteCommand();
}
db.Insertable(new syslog()
{
UserName = adminUser,
Title = "修改菜单：" + model.Name,
IP = FytRequest.GetIp(),
LogType = 6,
LogGrade = "1",
RequestUrl = FytRequest.GetUrl(),
AddDate = DateTime.Now
}).ExecuteCommand();
return(json);
}
/// <summary>
/// 建立菜单树
/// </summary>
/// <param name="menus">菜单集合</param>
/// <param name="menu">当前菜单</param>
public void BuildMenusTree(List <sysmenu> menus, sysmenu menu)
{
var submenus = menus.Where(p => p.parentno == menu.menuno);
foreach (sysmenu sub in submenus)
{
BuildMenusTree(menus, sub);
}
menu.children = submenus.ToList();
}
public ActionResult Change(int id)
{
var pid = FytRequest.GetQueryInt("pid", 0);
var model = new sysmenu();
Service.Command <MenuOutsourcing>((db, o) =>
{
model = db.Queryable <sysmenu>().Single(m => m.ID == id) ?? new sysmenu()
{
ParentId = pid, SysID = 1, Sort = 0, IsShow = true
};
#region 拉框父级
var list = db.Queryable <sysmenu>().ToList();
var sList = o.RecursiveModule(list);
var selectList = sList.Select(p => new SelectListItem
{
Text = Utils.LevelName(p.Name, p.ClassLayer),
Value = p.ID.ToString(CultureInfo.InvariantCulture)
}).ToList();
selectList.Insert(0, new SelectListItem()
{
Text = "父级", Value = "0"
});
ViewBag.selectList = selectList.AsEnumerable().ToList();
#endregion
#region 查询排序的最大值
if (id == 0)
{
var pModel = db.Queryable <sysmenu>().OrderBy(m => m.Sort, OrderByType.Desc).First();
if (pModel != null)
{
model.Sort = pModel.Sort + 1;
}
else
{
model.Sort = 1;
}
}
#endregion
});
if (model != null)
{
return(View(model));
}
return(View());
}
public JsonResult Change(sysmenu model)
{
var jsonm = new ResultJson();
try
{
Service.Command <MenuOutsourcing>((db, o) =>
{
jsonm = o.Change(db, model, GetAdminModel().sysadmin.LoginName);
});
}
catch (Exception ex)
{
jsonm.msg = "保存数据发生错误！ 消息：" + ex.Message;
jsonm.status = 500;
}
return(Json(jsonm));
}
public JsonResult Update(sysmenu menu)
{
string msg = ValidInput(menu);
OperateResultModel orm = new OperateResultModel();
if (string.IsNullOrEmpty(msg))
{
menu.editdate = DateTime.Now;
menu.editer = SessionUser.UserNo;
Permission permission = new Permission();
orm = permission.UpdateMenu(menu);
orm.rows = menu;
}
else
{
orm.success = false;
orm.message = msg;
}
return(JsonResultHelper.ConvertToJsonResult(orm));
}
public PartialViewResult Edit(string menuno, string type)
{
if (type == "add")
{
if (menuno == null)
{
@ViewBag.Top = "Y";//是否创建顶级菜单
menuno = "0";
}
else
{
@ViewBag.Top = "N";
}
}
Permission permission = new Permission();
sysmenu menu = null;
if (type == "edit")
{
menu = permission.QueryMenu(menuno);
}
else if (type == "add")
{
if (menuno == "0")
{
@ViewBag.ParentNo = menuno;
@ViewBag.MenuNo = menuno;
}
else
{
menu = permission.QueryMenu(menuno);
@ViewBag.ParentNo = menu.parentno;
@ViewBag.MenuNo = menu.menuno;
menu = null;
}
}
return(PartialView(menu));
}
private string ValidInput(sysmenu menu)
{
string msg = string.Empty;
if (string.IsNullOrEmpty(menu.parentno))
{
msg += "请选择同级还是下级<br />";
}
if (string.IsNullOrEmpty(menu.menuno))
{
msg += "请输入菜单编号<br />";
}
if (string.IsNullOrEmpty(menu.menuname))
{
msg += "请输入菜单名称<br />";
}
if (string.IsNullOrEmpty(menu.isvalid))
{
msg += "请选择是否有效<br />";
}
return(msg);
}
public void OnGet(string guid)
{
MenuModel = _sysmenuService.GetByGuidAsync(guid).Result.data;
}
/// <summary>
/// 更新角色信息
/// </summary>
/// <param name="menu">菜单实体</param>
/// <returns></returns>
public OperateResultModel UpdateMenu(sysmenu menu)
{
SysMenuDal dal = new SysMenuDal();
return(dal.Update(menu));
}
/// <summary>
/// 插入菜单信息
/// </summary>
/// <param name="menu">菜单实体</param>
/// <returns></returns>
public OperateResultModel InsertMenu(sysmenu menu)
{
SysMenuDal dal = new SysMenuDal();
return(dal.Insert(menu));
}
public Task <ApiResult <string> > AddAsync(sysmenu parm)
{
throw new NotImplementedException();
}
