/// ------------------------------------------------------- /// <summary> /// Menu 페이지 : Show Menu Dropdwon Filter List /// </summary> /// ------------------------------------------------------- public ActionResult MenuFilter(int intMenuGroupNo) { MHKIM_BILL_DBEntities db = new MHKIM_BILL_DBEntities(); int?menuGroupNo = Convert.ToInt16(intMenuGroupNo); List <TAdminMenu> lstAdminMenu = new List <TAdminMenu>(); var menuGroupList = db.TAdminMenuGroup.ToList(); if (menuGroupNo.Equals(0)) { DataTable dtManager = new DataTable(); menuDao.ShowMenuDataAll(dtManager); foreach (DataRow dtrow in dtManager.Rows) { TAdminMenu objAdminMenuLogs = new TAdminMenu(); objAdminMenuLogs.MenuNo = Convert.ToInt16(dtrow["MenuNo"].ToString()); objAdminMenuLogs.MenuName = dtrow["MenuName"].ToString(); objAdminMenuLogs.MenuENName = dtrow["MenuENName"].ToString(); objAdminMenuLogs.MenuLink = dtrow["MenuLink"].ToString(); objAdminMenuLogs.MenuSort = Convert.ToInt16(dtrow["MenuSort"].ToString()); objAdminMenuLogs.AdminID = dtrow["AdminID"].ToString(); objAdminMenuLogs.RegDate = Convert.ToDateTime(dtrow["RegDate"].ToString()); objAdminMenuLogs.UpdDate = (dtrow["UpdDate"] == DBNull.Value) ? (DateTime?)null : ((DateTime)dtrow["UpdDate"]); lstAdminMenu.Add(objAdminMenuLogs); } } else { DataTable dtManager = new DataTable(); menuDao.ShowMenuDataManage(dtManager, intMenuGroupNo); foreach (DataRow dtrow in dtManager.Rows) { TAdminMenu objAdminMenuLogs = new TAdminMenu(); objAdminMenuLogs.MenuNo = Convert.ToInt16(dtrow["MenuNo"].ToString()); objAdminMenuLogs.MenuName = dtrow["MenuName"].ToString(); objAdminMenuLogs.MenuENName = dtrow["MenuENName"].ToString(); objAdminMenuLogs.MenuLink = dtrow["MenuLink"].ToString(); objAdminMenuLogs.MenuSort = Convert.ToInt16(dtrow["MenuSort"].ToString()); objAdminMenuLogs.AdminID = dtrow["AdminID"].ToString(); objAdminMenuLogs.RegDate = Convert.ToDateTime(dtrow["RegDate"].ToString()); objAdminMenuLogs.UpdDate = (dtrow["UpdDate"] == DBNull.Value) ? (DateTime?)null : ((DateTime)dtrow["UpdDate"]); lstAdminMenu.Add(objAdminMenuLogs); } } return(PartialView("_ShowMenuList", lstAdminMenu)); }
/// ------------------------------------------------------- /// <summary> /// Menu 페이지 : Show Menu Dropdwon List /// </summary> /// ------------------------------------------------------- public ActionResult MenuForm() { MHKIM_BILL_DBEntities db = new MHKIM_BILL_DBEntities(); TAdminMenu objAdminMenu = new TAdminMenu(); var menuGroupList = db.TAdminMenuGroup.ToList().Where(a => a.UseFlag.Equals("Y")); objAdminMenu.MenuGroupList = (from d in menuGroupList select new SelectListItem { Value = d.MenuGroupNo.ToString(), Text = d.MenuGroupName }).ToList(); List <TAdminMenu> lstAdminMenu = new List <TAdminMenu>(); DataTable dtManager = new DataTable(); menuDao.ShowMenuDataAll(dtManager); foreach (DataRow dtrow in dtManager.Rows) { TAdminMenu objAdminMenulogs = new TAdminMenu(); objAdminMenulogs.MenuNo = Convert.ToInt16(dtrow["MenuNo"].ToString()); objAdminMenulogs.MenuName = dtrow["MenuName"].ToString(); objAdminMenulogs.MenuENName = dtrow["MenuENName"].ToString(); objAdminMenulogs.MenuLink = dtrow["MenuLink"].ToString(); objAdminMenulogs.MenuSort = Convert.ToInt16(dtrow["MenuSort"].ToString()); objAdminMenulogs.AdminID = dtrow["AdminID"].ToString(); objAdminMenulogs.RegDate = Convert.ToDateTime(dtrow["RegDate"].ToString()); objAdminMenulogs.UpdDate = (dtrow["UpdDate"] == DBNull.Value) ? (DateTime?)null : ((DateTime)dtrow["UpdDate"]); lstAdminMenu.Add(objAdminMenulogs); } objAdminMenu.AdminMenuGrid = lstAdminMenu; return(View("MenuForm", objAdminMenu)); }