public static Menu LoadFromDataBaseByAppId(string appid)
{
W_WeChatInfoBLL weChatInfoBll = new W_WeChatInfoBLL();
W_WeChatInfo weChatInfo = weChatInfoBll.GetByAppID(appid);
W_MenuBLL menuBll = new W_MenuBLL();
List<W_Menu> menuButtons = menuBll.GetByWeChatInfo(weChatInfo).OrderBy(temp => temp.Sort).ToList();// 获取对应的一级菜单并按 sort 排序。
Menu menu = new Menu();
foreach (W_Menu menuButton in menuButtons)
{
MenuButton button = new MenuButton();
button.Name = menuButton.MenuName;
if (menuButton.MenuType == "click")
{
button.Type = MenuButtonType.Click;
button.Key = menuButton.MenuKey;
}
else if (menuButton.MenuType == "view")
{
button.Type = MenuButtonType.View;
button.Url = menuButton.MenuURL;
}
List<W_Menu> menuSubButtons = menuBll.GetChildButtons(menuButton).OrderBy(temp => temp.Sort).ToList();
foreach (W_Menu menuSubButton in menuSubButtons)
{
MenuSubButton subButton = new MenuSubButton();
subButton.Name = menuButton.MenuName;
if (menuSubButton.MenuType == "click")
{
subButton.Type = MenuButtonType.Click;
subButton.Key = menuButton.MenuKey;
}
else if (menuSubButton.MenuType == "view")
{
subButton.Type = MenuButtonType.View;
subButton.Url = menuSubButton.MenuURL;
}
button.SubButton.Add(subButton);
}
menu.Button.Add(button);
}
return menu;
}
public static bool SaveToDataBase(Menu menu, string appid)
{
try
{
#region delete current database menu
W_WeChatInfoBLL weChatInfoBll = new W_WeChatInfoBLL();
W_WeChatInfo weChatInfo = weChatInfoBll.GetByAppID(appid);
W_MenuBLL menuBll = new W_MenuBLL();
List<W_Menu> menus = menuBll.GetByWeChatInfo(weChatInfo);// 一级菜单
foreach (W_Menu wMenu in menus)
{
List<W_Menu> subMenus = menuBll.GetChildButtons(wMenu);
foreach (W_Menu subMenu in subMenus)
{
menuBll.Delete(subMenu);
}
menuBll.Delete(wMenu);
}
#endregion
#region add current to database
List<W_Menu> addList = new List<W_Menu>();
foreach (var button in menu.Button)
{
W_Menu w = new W_Menu();
w.MenuID = Guid.NewGuid().ToString();
w.WID = weChatInfo.WID;
w.MenuName = button.Name;
if (button.Type == MenuButtonType.Click)
{
w.MenuType = "click";
w.MenuKey = button.Key;
}
else if (button.Type == MenuButtonType.View)
{
w.MenuType = "view";
w.MenuURL = button.Key;
}
w.PMenuID = "0";
w.ResponseType = "";
w.ResourcesID = "";
w.CreateTime = DateTime.Now;
w.IsDelete = 0;
addList.Add(w);
foreach (var subButton in button.SubButton)
{
W_Menu ww = new W_Menu();
ww.MenuID = Guid.NewGuid().ToString();
ww.WID = Guid.NewGuid().ToString();
ww.MenuName = subButton.Name;
if (subButton.Type == MenuButtonType.Click)
{
ww.MenuType = "click";
ww.MenuKey = subButton.Key;
}
else if (subButton.Type == MenuButtonType.View)
{
ww.MenuType = "view";
ww.MenuURL = subButton.Url;
}
ww.PMenuID = w.MenuID;
ww.ResponseType = "";
ww.ResourcesID = "";
ww.CreateTime = DateTime.Now;
ww.IsDelete = 0;
addList.Add(ww);
}
}
foreach (var temp in addList)
{
menuBll.Add(temp);
}
return true;
#endregion
}
catch
{
return false;
}
}