Ejemplo n.º 1
0
 public string Login(string account)
 {
     using (CustomsEntities db = new CustomsEntities())
     {
         var user = db.UT_SYS_USER.FirstOrDefault(p => p.ACCOUNT == account && p.ISDELETED == "0");
         return(JsonConvert.SerializeObject(user));
     }
 }
Ejemplo n.º 2
0
        public string GetSysMenu(int userID)
        {
            using (CustomsEntities db = new CustomsEntities())
            {
                var query = from A in db.UT_SYS_USERROLE
                            join B in db.UT_SYS_ROLERIGHT
                            on A.ROLEID equals B.RoleID
                            join C in db.UT_SYS_RIGHT
                            on B.SystemRightID equals C.RIGHTID
                            join D in db.UT_SYS_RIGHT
                            on C.PARENTRIGHTID equals D.RIGHTID
                            where A.USERID == userID && C.TYPE != 2
                            select new SysRight
                {
                    ParentID   = C.PARENTRIGHTID,
                    Name       = C.RIGHTNAME,
                    NavUrl     = C.NAVIGATEURL,
                    SystemID   = C.RIGHTID,
                    ImageUrl   = C.IMAGEURL,
                    ParentName = D.RIGHTNAME,
                };

                //return JsonConvert.SerializeObject(query.ToList());
                var firstMenu = query.Where(q => q.ParentID != 0).GroupBy(p => new  { p.ParentID, p.ParentName }).Select(q => new { q.Key });

                List <RightModel> result = new List <RightModel>();

                var parentList = db.UT_SYS_RIGHT.Where(p => p.PARENTRIGHTID == 0).ToList();

                firstMenu.ToList().ForEach(p =>
                {
                    result.Add(new RightModel
                    {
                        ParentID  = p.Key.ParentID,
                        Name      = p.Key.ParentName,
                        ImageUrl  = parentList.FirstOrDefault(q => q.RIGHTID == p.Key.ParentID).IMAGEURL,
                        ChildList = query.Where(q => q.ParentID == p.Key.ParentID).ToList()
                    });
                });
                return(JsonConvert.SerializeObject(result));
            }
        }