public ActionResult DeleteConfirmed(int id)
{
MenuSet menuSet = menuRepository.ObterPorId(id);
menuRepository.Apagar(menuSet);
return(RedirectToAction("Index"));
}
public List <MenuSet> GetMenuList()
{
// 세션이 끊긴 상태
if (DWUserInfo == null || DWUserInfo.ID == 0)
{
Response.StatusCode = 600;
return(null);
}
using (var db = new DWContext())
{
List <Menu> list = new List <Menu>();
KPIController kpi = new KPIController();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_menusByCompany", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@roleID", DWUserInfo.RoleID));
cmd.Parameters.Add(new MySqlParameter("@CompanyCode", DWUserInfo.CompanyCode));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (DWUserInfo.UserID == "*****@*****.**" && reader["Category"].ToString() == "FineReport")
{
}
else
{
list.Add(new Menu()
{
ID = Convert.ToInt32(reader["Id"]),
Category = reader["Category"].ToString(),
Close = reader["Close"].ToString(),
CompanyCode = Convert.ToInt32(reader["Id"]),
Title = reader["Title"].ToString(),
URL = reader["Url"].ToString(),
Level = reader["Level"].ToString(),
ParentID = reader["ParentID"].ToString(),
});
}
}
}
}
var results = list.GroupBy(o => o.Category);
List <MenuSet> menuSet = new List <MenuSet>();
foreach (var item in results)
{
MenuSet set = new MenuSet();
set.Category = item.Key;
set.Menus = getMenu(item);
menuSet.Add(set);
}
return(menuSet);
}
}
public ActionResult Edit([Bind(Include = "Id,nome,action,controller,route,ativo")] MenuSet menuSet)
{
if (ModelState.IsValid)
{
menuRepository.Atualizar(menuSet);
return(RedirectToAction("Index"));
}
return(View(menuSet));
}
public List <MenuSet> Get(string companyID)
{
var user = UserController.GetByKey(UserID, Request);
using (var db = new DWContext())
{
List <Menu> list = new List <Menu>();
KPIController kpi = new KPIController();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_menusByCompany", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@roleID", user.RoleID));
cmd.Parameters.Add(new MySqlParameter("@CompanyCode", companyID));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
//2020-01-23 임병규 수정 배포 : 사장님 FineReport 메뉴 사용안함 처리
if (user.UserID == "*****@*****.**" && reader["Category"].ToString() == "FineReport")
{
}
else
{
list.Add(new Menu()
{
ID = Convert.ToInt32(reader["Id"]),
Category = reader["Category"].ToString(),
Close = reader["Close"].ToString(),
CompanyCode = Convert.ToInt32(reader["Id"]),
Title = reader["Title"].ToString(),
URL = reader["Url"].ToString(),
Level = reader["Level"].ToString(),
ParentID = reader["ParentID"].ToString(),
});
}
}
}
}
var results = list.GroupBy(o => o.Category);
List <MenuSet> menuSet = new List <MenuSet>();
foreach (var item in results)
{
MenuSet set = new MenuSet();
set.Category = item.Key;
set.Menus = getMenu(item);
menuSet.Add(set);
}
return(menuSet);
}
}
public async Task MenuSetDelete([Bind(Prefix = "l")] MenuSet menuSet)
{
using (EFMenuSetContext menuSetContext = new EFMenuSetContext())
{
if (Request.IsAjaxRequest())
{
await menuSetContext.DeleteMenuSetAsync(menuSet.Id);
}
}
}
/// <summary>
/// Удаление настройки меню
/// </summary>
/// <param name="menuSetId"></param>
/// <returns></returns>
public async Task DeleteMenuSetAsync(Guid menuSetId)
{
MenuSet forDelete = await context.MenuSets.FindAsync(menuSetId);
if (forDelete != null)
{
context.MenuSets.Remove(forDelete);
}
await context.SaveChangesAsync();
}
public async Task MenuSetSave([Bind(Prefix = "l")] MenuSet menuSet)
{
using (EFMenuSetContext menuSetContext = new EFMenuSetContext())
{
if (ModelState.IsValid && Request.IsAjaxRequest())
{
await menuSetContext.SaveMenuSetAsync(menuSet);
}
}
}
// GET: Menu/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuSet menuSet = menuRepository.ObterPorId(id.Value);
if (menuSet == null)
{
return(HttpNotFound());
}
return(View(menuSet));
}
public void Inserir(MenuSet entity)
{
try
{
if (entity != null)
{
dbcontext.MenuSet.Add(entity);
dbcontext.Entry(entity).State = System.Data.Entity.EntityState.Added;
dbcontext.SaveChanges();
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public void Apagar(MenuSet entity)
{
try
{
if (entity != null)
{
dbcontext.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
dbcontext.MenuSet.Remove(entity);
dbcontext.SaveChanges();
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public List <MenuSet> GetMenuInScenario(string companyCode)
{
using (var db = new DWContext())
{
List <Menu> list = new List <Menu>();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand($"select Menu.ID, ifnull(Menu.Close, '') as Close, Menu.CompanyCode, Menu.Title as MenuTitle, Menu.Url, Menu.Level, Menu.ParentID, Category.Title as CategoryTitle from Menu inner join Category on Menu.categoryCode = Category.id where Menu.companyCode = '{companyCode}' and Menu.CategoryCode in (1, 2, 3)", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Menu()
{
ID = Convert.ToInt32(reader["ID"]),
Category = reader["CategoryTitle"].ToString(),
Close = reader["Close"].ToString(),
CompanyCode = Convert.ToInt32(reader["CompanyCode"]),
Title = reader["MenuTitle"].ToString(),
URL = reader["Url"].ToString(),
Level = reader["Level"].ToString(),
ParentID = reader["ParentID"].ToString(),
});
}
}
}
var results = list.GroupBy(o => o.Category);
List <MenuSet> menuSet = new List <MenuSet>();
foreach (var item in results)
{
MenuSet set = new MenuSet();
set.Category = item.Key;
set.Menus = getMenu(item);
menuSet.Add(set);
}
return(menuSet);
}
}
private List <ItemMenu> ObterTodosMenusPai(int perfilId)
{
var queryMenuPai = (from tab1 in MenuSet.ObterTodos()
where tab1.Url.Trim().Equals("#")
select new ItemMenu
{
PerfilId = perfilId,
MenuId = tab1.MenuId,
Ordem = tab1.Ordem,
MenuPaiId = tab1.MenuPaiId,
Nome = tab1.Nome,
Url = tab1.Url,
Icone = tab1.Url
}).Distinct();
return(queryMenuPai.ToList());
}
/// <summary>
/// private constructor
/// </summary>
private UIManager()
{
//initialize the main menu dictionary
mainMenus = new Dictionary <Menus, GameObject>()
{
};
//initialize the game menu dictionary
gameMenus = new Dictionary <Menus, GameObject>()
{
};
//set current menu set
currentMenuSet = MenuSet.MainMenus;
//set current menus dictionary
currentMenus = mainMenus;
}
/// <summary>
/// Сохранение настройки меню
/// </summary>
/// <param name="menuSet"></param>
/// <returns></returns>
public async Task SaveMenuSetAsync(MenuSet menuSet)
{
if (menuSet.Id == Guid.Empty)
{
menuSet.Id = Guid.NewGuid();
context.MenuSets.Add(menuSet);
}
else
{
MenuSet forChange = await context.MenuSets.FindAsync(menuSet.Id);
if (forChange != null)
{
//forChange.Group = menuSet.Group;
forChange.IsActive = menuSet.IsActive;
forChange.Link = menuSet.Link;
//forChange.Name = menuSet.Name;
forChange.Order = menuSet.Order;
}
}
await context.SaveChangesAsync();
}
/// <summary>
/// ChangeMenuSets is for changing menu sets between main menus and gameplay.
/// </summary>
/// <param name="newSet">the set to change to</param>
public void ChangeMenuSets(MenuSet newSet)
{
//set menu set enum
currentMenuSet = newSet;
//change current menus dictionary
switch (newSet)
{
case MenuSet.None:
break;
case MenuSet.MainMenus:
currentMenus = mainMenus;
break;
case MenuSet.GameMenus:
currentMenus = gameMenus;
break;
default:
break;
}
}
public MenuSub(MenuSet menuSet)
{
m_parent = menuSet;
}
static void AddCreationOptions(GenericMenu menu, Vector3 position, Vector3 normal)
{
var mainMenuOptions = new MenuSet();
var menuString = EditorGUIUtility.SerializeMainMenuToString();
var menus = menuString.Split('\n');
var pathParts = new List <string>();
var menuPaths = new List <string>();
var contextOptions = new Dictionary <string, List <string[]> >();
foreach (var m in menus)
{
var s = m.Split(new string[] { " " }, System.StringSplitOptions.None);
var n = s[s.Length - 1];
// Add to path parts.
if (pathParts.Count <= s.Length)
{
pathParts.Add(n);
}
else
{
pathParts[s.Length - 1] = n;
}
// Get full path.
var path = "";
var parts = new List <string>();
var menuSet = mainMenuOptions;
for (int i = 0; i < s.Length; i++)
{
var pp = pathParts[i];
parts.Add(pp);
path += pp;
if (!menuSet.children.ContainsKey(pp))
{
var ms = new MenuSet();
ms.fullPath = path;
ms.pathPart = pp;
menuSet.children.Add(pp, ms);
}
menuSet = menuSet.children[pp];
if (i != s.Length - 1)
{
path += "/";
}
}
// Context menus.
if (path.Contains("CONTEXT"))
{
var cParts = path.Split('/');
if (cParts.Length >= 3)
{
var component = cParts[1];
var label = cParts[2];
if (!contextOptions.ContainsKey(component))
{
contextOptions.Add(component, new List <string[]>());
}
contextOptions[component].Add(new string[] {
// Nice label.
component + "/" + label,
// Actual menu item.
path
});
}
}
menuPaths.Add(path);
}
// Options for creating an object.
var go = mainMenuOptions.children["GameObject"];
var list = new List <string>();
list.AddRange(go.children["3D Object"].GetSubPaths());
list.AddRange(go.children["Realtime-CSG"].GetSubPaths());
list.AddRange(go.children["Effects"].GetSubPaths());
list.AddRange(go.children["Light"].GetSubPaths());
foreach (var path in list)
{
menu.AddItem(new GUIContent(path), false, () => SpawnObject(position, normal, path));
}
menu.AddItem(new GUIContent("FSM/Spawn Point"), false, () => SpawnPrefab(position, normal, "FSM/Prefabs/SpawnPoint"));
menu.AddItem(new GUIContent("FSM/Teleport Destination"), false, () => SpawnPrefab(position, normal, "FSM/Prefabs/TeleportDestination"));
}
// Parses EditorGUIUtility.SerializeMainMenuToString so we can use custom context menus for internal objects like Transforms. Also for copying the Creation menu drop down.
static void InitMainMenuOptions()
{
mainMenuOptions = new MenuSet();
var menuString = EditorGUIUtility.SerializeMainMenuToString();
var menus = menuString.Split('\n');
var pathParts = new List <string>();
var menuPaths = new List <string>();
contextOptions = new Dictionary <string, List <string[]> >();
foreach (var m in menus)
{
var s = m.Split(new string[] { " " }, StringSplitOptions.None);
var n = s[s.Length - 1];
// Add to path parts.
if (pathParts.Count <= s.Length)
{
pathParts.Add(n);
}
else
{
pathParts[s.Length - 1] = n;
}
// Get full path.
var path = "";
var parts = new List <string>();
var menuSet = mainMenuOptions;
for (int i = 0; i < s.Length; i++)
{
var pp = pathParts[i];
parts.Add(pp);
path += pp;
if (!menuSet.children.ContainsKey(pp))
{
var ms = new MenuSet();
ms.fullPath = path;
ms.pathPart = pp;
menuSet.children.Add(pp, ms);
}
menuSet = menuSet.children[pp];
if (i != s.Length - 1)
{
path += "/";
}
}
// Context menus.
if (path.Contains("CONTEXT"))
{
var cParts = path.Split('/');
if (cParts.Length >= 3)
{
var component = cParts[1];
var label = cParts[2];
if (!contextOptions.ContainsKey(component))
{
contextOptions.Add(component, new List <string[]>());
}
contextOptions[component].Add(new string[] {
// Nice label.
component + "/" + label,
// Actual menu item.
path
});
}
}
menuPaths.Add(path);
}
// Options for creating an object.
var go = mainMenuOptions.children["GameObject"];
var list = new List <string>();
list.Add("GameObject/Create Empty");
list.AddRange(go.children["3D Object"].GetSubPaths());
list.AddRange(go.children["2D Object"].GetSubPaths());
list.AddRange(go.children["Effects"].GetSubPaths());
list.AddRange(go.children["Light"].GetSubPaths());
list.AddRange(go.children["Camera"].GetSubPaths());
creationOptions = list.ToArray();
}
public async Task <string> GetGroupByLinkAsync(string v)
{
MenuSet ms = await context.MenuSets.FirstOrDefaultAsync(m => m.Link == v);
return(ms == null ? null : ms.Group.ToString());
}
