/// <summary> /// 菜单管理 详情查询 /// </summary> public object Get(int id) { base_menus info = menusBLL.GetInfo(id, out errmsg); if (!string.IsNullOrEmpty(errmsg)) { return(new { Rcode = -1, Rmsg = "获取数据失败" }); } return(new { Rcode = 1, Rdata = info }); }
/// <summary> /// 菜单管理 添加数据 /// </summary> public object Post([FromBody] base_menus info) { info.status = 1; bool success = menusBLL.Add(info, out errmsg); if (!success || !string.IsNullOrEmpty(errmsg)) { return new { Rcode = -1, Rmsg = "添加失败" } } ; return(new { Rcode = 1, Rmsg = "添加成功" }); }
/// <summary> /// 菜单管理 更新数据 /// </summary> public object Put(int id, [FromBody] base_menus info) { info.menuid = id; bool success = menusBLL.Update(info, out errmsg); WriteSysLog(1, string.Format("更新菜单管理 id为 {0},返回{1} {2}", id, success, errmsg)); if (!success || !string.IsNullOrEmpty(errmsg)) { return new { Rcode = -1, Rmsg = "更新失败" } } ; return(new { Rcode = 1, Rmsg = "更新成功" }); }
private static void SetMenuChildren(base_menus parentmenu, List <base_menus> list) { parentmenu.children = new List <base_menus>(); List <base_menus> menuChildren = list.FindAll( delegate(base_menus c) { return(c.parentmenuid == parentmenu.menuid); }); foreach (base_menus menu in menuChildren) { parentmenu.children.Add(menu); SetMenuChildren(menu, list); } }
/// <summary> /// 菜单管理 添加数据 /// </summary> /// <param name="base_menus">要添加的菜单管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Add(base_menus info, out string errmsg) { List <DataParameter> pars = new List <DataParameter>(); pars.Add(new DataParameter("menuname", info.menuname)); pars.Add(new DataParameter("parentmenuid", info.parentmenuid)); pars.Add(new DataParameter("pagemark", info.pagemark)); pars.Add(new DataParameter("path", info.path)); pars.Add(new DataParameter("description", info.description)); pars.Add(new DataParameter("sorts", info.sorts)); pars.Add(new DataParameter("isoutlink", info.isoutlink)); pars.Add(new DataParameter("status", info.status)); string sqlstr = "insert into base_menus (menuname,parentmenuid,pagemark,path,description,sorts,isoutlink,status) values (@menuname,@parentmenuid,@pagemark,@path,@description,@sorts,@isoutlink,@status) "; return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0); }
/// <summary> /// 菜单管理 更新数据 /// </summary> /// <param name="base_menus">要更新的菜单管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Update(base_menus info, out string errmsg) { List <DataParameter> pars = new List <DataParameter>(); pars.Add(new DataParameter("menuname", info.menuname)); pars.Add(new DataParameter("parentmenuid", info.parentmenuid)); pars.Add(new DataParameter("pagemark", info.pagemark)); pars.Add(new DataParameter("path", info.path)); pars.Add(new DataParameter("description", info.description)); pars.Add(new DataParameter("isoutlink", info.isoutlink)); pars.Add(new DataParameter("sorts", info.sorts)); pars.Add(new DataParameter("status", info.status)); string sqlstr = "update base_menus set menuname=@menuname,parentmenuid=@parentmenuid,pagemark=@pagemark,path=@path,description=@description,isoutlink=@isoutlink,sorts=@sorts,status=@status where menuid=@menuid "; pars.Add(new DataParameter("menuid", info.menuid)); return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0); }
/// <summary> /// 菜单管理 列表查询 /// </summary> /// <param name="queryarr">查询条件</param> /// <param name="offset">起始条数</param> /// <param name="limit">获取条数</param> /// <param name="total">返回总记录数</param> public static List <base_menus> GetPageList(out string errmsg) { int total = 0; List <base_menus> list = menusDAL.GetPageList(new List <QueryModel>(), -1, 0, out total, out errmsg); if (!string.IsNullOrEmpty(errmsg) || list == null) { return(new List <base_menus>()); } foreach (base_menus menu in list) { menu.isoutlinkname = BaseBLL.GlobalCommonBLL.GetDicName("YesOrNo", menu.isoutlink.ToString()); // menu.statusname = BaseBLL.GlobalCommonBLL.GetDicName("EnableStatus", menu.status.ToString()); } base_menus rootmenu = new base_menus() { menuid = 0 }; SetMenuChildren(rootmenu, list); return(rootmenu.children); }
/// <summary> /// 菜单管理 更新数据 /// </summary> /// <param name="base_menus">要更新的菜单管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Update(base_menus info, out string errmsg) { return(menusDAL.Update(info, out errmsg)); }
/// <summary> /// 菜单管理 添加数据 /// </summary> /// <param name="base_menus">要添加的菜单管理对象</param> /// <param name="errmsg">错误信息</param> /// <returns>返回对象</returns> public static bool Add(base_menus info, out string errmsg) { return(menusDAL.Add(info, out errmsg)); }
/// <summary> /// 菜单管理 详情查询 /// </summary> public static base_menus GetInfo(int menuid, out string errmsg) { base_menus info = menusDAL.GetInfo(menuid, out errmsg); return(info); }