public object GetListAdmin()
{
//return db_C56.Admins
// .Where(a => a.Status != "D").ToList();
var query1 = db_C56.Admins.Join(db_C56.Area, a => a.AreaID, ar => ar.ID, (a, ar) => new
{
userName = a.UserName,
pwd = a.Password,
dName = a.DisplayName,
areaId = a.AreaID,
hasNode = a.HasNode,
roleName = a.RoleName,
status = a.Status,
areaName = ar.Name
});
var query = from a in db_C56.Admins
join ar in db_C56.Area
on a.AreaID equals ar.ID
where a.Status != "D"
select new
{
userName = a.UserName,
pwd = a.Password,
dName = a.DisplayName,
areaId = a.AreaID,
hasNode = a.HasNode,
roleName = a.RoleName,
status = a.Status,
areaName = ar.Name
};
return query.ToList().Select(C => new Admin
{
UserName = C.userName,
Password = C.pwd,
DisplayName = C.dName,
AreaID = C.areaId,
AreaPath = C.areaName,
HasNode = C.hasNode,
RoleName = C.roleName,
Status = C.status,
});
}public object GetListAdmin()
{