public IEnumerable <KeyValuePair <Guid, SubMenuView> > QuerySubMenus(Guid menu)
{
var result = new List <KeyValuePair <Guid, SubMenuView> >();
var sql = "SELECT Id,Name,SortLevel,Remark,Valid,Display,[Address] FROM dbo.T_Menu WHERE Parent=@PARENT AND Depth=2";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("PARENT", menu);
using (var reader = dbOperator.ExecuteReader(sql)) {
while (reader.Read())
{
var subMenuId = reader.GetGuid(0);
var subMenuView = new SubMenuView()
{
Name = reader.GetString(1),
SortLevel = reader.GetInt32(2),
Remark = reader.IsDBNull(3) ? string.Empty : reader.GetString(3),
Valid = reader.GetBoolean(4),
Display = reader.IsDBNull(5) || reader.GetBoolean(5),
Address = reader.IsDBNull(6) ? string.Empty: reader.GetString(6)
};
result.Add(new KeyValuePair <Guid, SubMenuView>(subMenuId, subMenuView));
}
}
}
return(result);
}
/// <summary>
/// 修改子菜单
/// </summary>
/// <param name="subMenuId">子菜单id</param>
/// <param name="subMenuView">子菜单信息</param>
/// <param name="operatorAccount">操作员账号</param>
public static void UpdateSubMenu(Guid subMenuId, SubMenuView subMenuView, string operatorAccount)
{
var subMenu = SubMenu.GetSubMenu(subMenuId, subMenuView);
var repository = Factory.CreateSystemResourceRepository();
repository.Update(subMenu);
LogHelper.SaveUpdateSubMenuLog(subMenu, operatorAccount);
}
/// <summary>
/// 添加子菜单
/// </summary>
/// <param name="website">网站</param>
/// <param name="menu">主菜单id</param>
/// <param name="subMenuView">子菜单信息</param>
/// <param name="operatorAccount">操作员账号</param>
public static SubMenu RegisterSubMenu(Website website, Guid menu, SubMenuView subMenuView, string operatorAccount)
{
var subMenu = SubMenu.GetSubMenu(subMenuView);
var repository = Factory.CreateSystemResourceRepository();
repository.Register(website, menu, subMenu);
LogHelper.SaveRegisterSubMenuLog(menu, subMenu, operatorAccount);
return(subMenu);
}
/// <summary>
/// 修改子菜单
/// </summary>
/// <param name="subMenuId">子菜单id</param>
/// <param name="subMenuView">子菜单信息</param>
/// <param name="operatorAccount">操作员账号</param>
public void UpdateSubMenu(string subMenuId, SubMenuView subMenuView)
{
SystemResourceService.UpdateSubMenu(Guid.Parse(subMenuId), subMenuView, this.CurrentUser.UserName);
}
/// <summary>
/// 添加子菜单
/// </summary>
/// <param name="subMenuView">子菜单信息</param>
/// <param name="operatorAccount">操作员账号</param>
public void RegisterSubMenu(Website website, string pid, SubMenuView subMenuView)
{
SystemResourceService.RegisterSubMenu(website, Guid.Parse(pid), subMenuView, this.CurrentUser.UserName);
}
