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));
}
