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 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 List <Page> Get() { // 세션이 끊긴 상태 if (DWUserInfo == null || DWUserInfo.ID == 0) { Response.StatusCode = 600; return(null); } try { using (var db = new DWContext()) { List <Page> list = new List <Page>(); KPIController kpi = new KPIController(); using (MySqlConnection conn = new MySqlConnection(db.ConnectionString)) { conn.Open(); MySqlCommand cmd = new MySqlCommand("select * from pages where userID = '" + DWUserInfo.UserID + "' and companyCode = '" + DWUserInfo.CompanyCode + "' order by seq asc", conn); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { list.Add(new Page() { ID = Convert.ToInt32(reader["Id"]), Seq = Convert.ToInt32(reader["Seq"]), KPIs = kpi.GetKpiByPage(Convert.ToInt32(reader["Id"]), DWUserInfo.CompanyCode.ToString()), Title = reader["Title"].ToString(), Layout = reader["Layout"].ToString() }); } } } return(list); } } catch (Exception ex) { List <Page> p = new List <Page>(); Page p1 = new Page(); p1.Title = ex.Message; p.Add(p1); Page p2 = new Page(); p2.Title = ex.InnerException.Message; p.Add(p2); return(p); } }
public List <Page> Get(string companyCode) { try { using (var db = new DWContext()) { var user = UserController.GetByKey(UserID, Request); List <Page> list = new List <Page>(); KPIController kpi = new KPIController(); using (MySqlConnection conn = new MySqlConnection(db.ConnectionString)) { conn.Open(); MySqlCommand cmd = new MySqlCommand("select * from pages where userID = '" + UserID + "' and companyCode = '" + companyCode + "' order by seq asc", conn); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { list.Add(new Page() { ID = Convert.ToInt32(reader["Id"]), Seq = Convert.ToInt32(reader["Seq"]), KPIs = GetKPIs(Convert.ToInt32(reader["Id"]), kpi, user, companyCode), Title = reader["Title"].ToString(), Layout = reader["Layout"].ToString() }); } } } return(list); } } catch (Exception ex) { List <Page> p = new List <Page>(); Page p1 = new Page(); p1.Title = ex.Message; p.Add(p1); Page p2 = new Page(); p2.Title = ex.InnerException.Message; p.Add(p2); return(p); } }
private List <KPI> GetKPIs(int v, KPIController c, DWBIUser user, string companyCode) { return(c.GetKpiByPage(v, companyCode)); }