/// <summary>
/// 刪除
/// </summary>
/// <param name="_MenuClass"></param>
/// <param name="_MenuViewModelList"></param>
/// <returns></returns>
public static bool DeleteMenu(MenuClassEnum _MenuClass, List <MenuViewModel> _MenuViewModelList)
{
string MenuClassName = Enum.GetName(typeof(MenuClassEnum), _MenuClass);
using (var context = new EG_MagicCubeEntities())
{
switch (_MenuClass)
{
case MenuClassEnum.AuthorArea:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_AuthorsArea = context.Menu_AuthorsArea.FirstOrDefault(x => x.AuthorsAreaNo == _MenuViewModel.MenuID);
if (delobj_AuthorsArea != null)
{
delobj_AuthorsArea.IsDel = "Y";
}
}
break;
case MenuClassEnum.AuthorTag:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_AuthorsTag = context.Menu_AuthorsTag.FirstOrDefault(x => x.AuthorsTagNo == _MenuViewModel.MenuID);
if (delobj_Menu_AuthorsTag != null)
{
delobj_Menu_AuthorsTag.IsDel = "Y";
}
}
break;
case MenuClassEnum.CountNoun:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_CountNoun = context.Menu_CountNoun.FirstOrDefault(x => x.CountNounNo == _MenuViewModel.MenuID);
if (delobj_Menu_CountNoun != null)
{
delobj_Menu_CountNoun.IsDel = "Y";
}
}
break;
case MenuClassEnum.Genre:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Genre = context.Menu_Genre.FirstOrDefault(x => x.GenreNo == _MenuViewModel.MenuID);
if (delobj_Menu_Genre != null)
{
delobj_Menu_Genre.IsDel = "Y";
}
}
break;
case MenuClassEnum.Material:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Material = context.Menu_Material.FirstOrDefault(x => x.MaterialNo == _MenuViewModel.MenuID);
if (delobj_Menu_Material != null)
{
delobj_Menu_Material.IsDel = "Y";
}
}
break;
case MenuClassEnum.Style:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Style = context.Menu_Style.FirstOrDefault(x => x.StyleNo == _MenuViewModel.MenuID);
if (delobj_Menu_Style != null)
{
delobj_Menu_Style.IsDel = "Y";
}
}
break;
case MenuClassEnum.WareType:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_WareType = context.Menu_WareType.FirstOrDefault(x => x.WareTypeNo == _MenuViewModel.MenuID);
if (delobj_Menu_WareType != null)
{
delobj_Menu_WareType.IsDel = "Y";
}
}
break;
case MenuClassEnum.Owner:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Owner = context.Menu_Owner.FirstOrDefault(x => x.OwnerNo == _MenuViewModel.MenuID);
if (delobj_Menu_Owner != null)
{
delobj_Menu_Owner.IsDel = "Y";
}
}
break;
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
/// <summary>
/// 新增Menu
/// </summary>
/// <param name="_MenuClass">Meun類型</param>
/// <param name="_MenuViewModelList"></param>
/// <returns></returns>
public bool InsertMenu(MenuClassEnum _MenuClass, List <MenuViewModel> _MenuViewModelList)
{
string MenuClassName = Enum.GetName(typeof(MenuClassEnum), _MenuClass);
using (var context = new EG_MagicCubeEntities())
{
switch (_MenuClass)
{
case MenuClassEnum.AuthorArea:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_AuthorsArea.Add(new Menu_AuthorsArea()
{
AuthorsAreaNo = _MenuViewModel.MenuID, AuthorsAreaName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.AuthorTag:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_AuthorsTag.Add(new Menu_AuthorsTag()
{
AuthorsTagNo = _MenuViewModel.MenuID, AuthorsTagName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.CountNoun:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_CountNoun.Add(new Menu_CountNoun()
{
CountNounNo = _MenuViewModel.MenuID, CountNounName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Genre:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Genre.Add(new Menu_Genre()
{
GenreNo = _MenuViewModel.MenuID, GenreName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Material:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Material.Add(new Menu_Material()
{
MaterialNo = _MenuViewModel.MenuID, MaterialName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Style:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Style.Add(new Menu_Style()
{
StyleNo = _MenuViewModel.MenuID, StyleName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.WareType:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_WareType.Add(new Menu_WareType()
{
WareTypeNo = _MenuViewModel.MenuID, WareTypeName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Owner:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Owner.Add(new Menu_Owner()
{
OwnerNo = _MenuViewModel.MenuID, OwnerName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
public static bool UpdateMenu(MenuClassEnum _MenuClass, string MenuNo, string MenuName)
{
int _MenuNo = int.Parse(MenuNo);
using (var context = new EG_MagicCubeEntities())
{
string MenuClassName = Enum.GetName(typeof(MenuClassEnum), _MenuClass);
switch (_MenuClass)
{
case MenuClassEnum.AuthorArea:
var AuthorArea = context.Menu_AuthorsArea.First(c => c.AuthorsAreaNo == _MenuNo);
if (AuthorArea != null)
{
AuthorArea.AuthorsAreaName = MenuName;
}
break;
case MenuClassEnum.AuthorTag:
var AuthorTag = context.Menu_AuthorsTag.First(c => c.AuthorsTagNo == _MenuNo);
if (AuthorTag != null)
{
AuthorTag.AuthorsTagName = MenuName;
}
break;
case MenuClassEnum.CountNoun:
var CountNoun = context.Menu_CountNoun.First(c => c.CountNounNo == _MenuNo);
if (CountNoun != null)
{
CountNoun.CountNounName = MenuName;
}
break;
case MenuClassEnum.Genre:
var Genre = context.Menu_Genre.First(c => c.GenreNo == _MenuNo);
if (Genre != null)
{
Genre.GenreName = MenuName;
}
break;
case MenuClassEnum.Material:
var Material = context.Menu_Material.First(c => c.MaterialNo == _MenuNo);
if (Material != null)
{
Material.MaterialName = MenuName;
}
break;
case MenuClassEnum.Style:
var Style = context.Menu_Style.First(c => c.StyleNo == _MenuNo);
if (Style != null)
{
Style.StyleName = MenuName;
}
break;
case MenuClassEnum.WareType:
var WareType = context.Menu_WareType.First(c => c.WareTypeNo == _MenuNo);
if (WareType != null)
{
WareType.WareTypeName = MenuName;
}
break;
case MenuClassEnum.Owner:
var Owner = context.Menu_Owner.First(c => c.OwnerNo == _MenuNo);
if (Owner != null)
{
Owner.OwnerName = MenuName;
}
break;
case MenuClassEnum.AccountRole:
var AccountRole = context.UserAccountRoles.First(c => c.RoleNo == _MenuNo);
if (AccountRole != null)
{
AccountRole.RoleName = MenuName;
}
break;
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
/// <summary>
/// 取得Menu
/// </summary>
/// <param name="_MenuClass"></param>
/// <returns></returns>
public List <MenuViewModel> GetMenu(MenuClassEnum _MenuClass)
{
List <MenuViewModel> _MenuViewModel = new List <MenuViewModel>();
string MenuClassName = Enum.GetName(typeof(MenuClassEnum), _MenuClass);
using (var context = new EG_MagicCubeEntities())
{
switch (_MenuClass)
{
case MenuClassEnum.AuthorArea:
_MenuViewModel.AddRange(context.Menu_AuthorsArea.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.AuthorsAreaNo, MenuName = c.AuthorsAreaName
}).ToList());
break;
case MenuClassEnum.AuthorTag:
_MenuViewModel.AddRange(context.Menu_AuthorsTag.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.AuthorsTagNo, MenuName = c.AuthorsTagName
}).ToList());
break;
case MenuClassEnum.CountNoun:
_MenuViewModel.AddRange(context.Menu_CountNoun.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.CountNounNo, MenuName = c.CountNounName
}).ToList());
break;
case MenuClassEnum.Genre:
_MenuViewModel.AddRange(context.Menu_Genre.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.GenreNo, MenuName = c.GenreName
}).ToList());
break;
case MenuClassEnum.Material:
_MenuViewModel.AddRange(context.Menu_Material.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.MaterialNo, MenuName = c.MaterialName
}).ToList());
break;
case MenuClassEnum.Style:
_MenuViewModel.AddRange(context.Menu_Style.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.StyleNo, MenuName = c.StyleName
}).ToList());
break;
case MenuClassEnum.WareType:
_MenuViewModel.AddRange(context.Menu_WareType.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.WareTypeNo, MenuName = c.WareTypeName
}).ToList());
break;
case MenuClassEnum.Owner:
_MenuViewModel.AddRange(context.Menu_Owner.AsQueryable().Where(c => c.IsDel != "Y").Select(c => new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = c.OwnerNo, MenuName = c.OwnerName
}).ToList());
break;
case MenuClassEnum.AccountRole:
_MenuViewModel.AddRange((from f in context.UserAccountRoles
select new MenuViewModel()
{
MenuClass = MenuClassName, MenuID = f.RoleNo, MenuName = f.RoleName
}).ToList());
break;
}
}
return(_MenuViewModel);
}
