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