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