public ActionResult Index() { using (DataClassesDataContext data = new DataClassesDataContext()) { UserDTO currentUser = data.UserDTO .Where(u => u.Login_ID == this.User.Identity.Name) .Single(); string sql = "SELECT b.* FROM dbo.T_PERMISSION a left join dbo.T_RESOURCE b on a.Resource_Code=b.Code WHERE a.Role_Code='" + currentUser.Role_Code + "' ORDER BY b.Sort ASC"; var items = data.ExecuteQuery<ResourceDTO>(sql).ToList(); ViewData["authorities"] = items; } return View(); }
public ActionResult List() { ActionResult retval = null; using (DataClassesDataContext data = new DataClassesDataContext()) { string sql = "SELECT A.Login_ID, A.Username, A.Department_ID, A.Role_Code, B.Name AS Department_Name, C.Code AS Role_Code, C.Name AS Role_Name FROM dbo.T_USER A LEFT JOIN dbo.T_DEPARTMENT B ON A.DEPARTMENT_ID=B.ID LEFT JOIN dbo.T_ROLE C ON A.ROLE_CODE=C.CODE ORDER BY A.Login_ID ASC"; var items = data.ExecuteQuery<UserModel>(sql).ToList(); retval = Json(items, JsonRequestBehavior.AllowGet); } return retval; }