public JsonResult GetRightInModule(string module, int UserID)
        {
            if (!UserID.Equals(""))
            {
                Rights rights = new Rights();
                rights.Accept = new List <GetUserFunction_Result>();
                rights.Deny   = new List <GetUserFunction_Result>();

                if (UserID == 1)
                {
                    var rightAccept = db.Database.SqlQuery <GetUserFunction_Result>("Account.GetUserAcceptByModuleAndUID {0}, {1}", module, UserID).ToList();
                    foreach (var r in rightAccept)
                    {
                        rights.Accept.Add(new GetUserFunction_Result()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                    var rightDeny = db.Database.SqlQuery <GetUserFunction_Result>("Account.GetUserDenyByModuleAndUID {0} {1}", module, UserID).ToList();
                    foreach (var r in rightDeny)
                    {
                        rights.Deny.Add(new GetUserFunction_Result()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                }
                else
                {
                    var rightAccept = db.Database.SqlQuery <GetUserFunction_Result>("Account.GetUserAcceptByModuleAndUID {0}, {1}", module, UserID).ToList();
                    foreach (var r in rightAccept)
                    {
                        rights.Accept.Add(new GetUserFunction_Result()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                    var rightDeny = db.Database.SqlQuery <GetUserFunction_Result>("Account.GetUserDenyByModuleAndUID {0}, {1}", module, UserID).ToList();
                    foreach (var r in rightDeny)
                    {
                        rights.Deny.Add(new GetUserFunction_Result()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                }
                return(Json(rights, JsonRequestBehavior.AllowGet));
            }
            else
            {
                RightsWhenCreate rights = new RightsWhenCreate();
                rights.Accept = new List <GetUserFunction_Result>();
                rights.Deny   = new List <GetUserFunction_Result>();
                var rightDeny = db.Database.SqlQuery <GetUserFunction_Result>("Account.GetFunctionsByModule {0}", module).ToList();
                foreach (var r in rightDeny)
                {
                    rights.Deny.Add(new GetUserFunction_Result()
                    {
                        ID      = r.ID,
                        Right   = r.Right,
                        GroupID = r.GroupID
                    });
                }
                return(Json(rights, JsonRequestBehavior.AllowGet));
            }
        }
Beispiel #2
0
        public JsonResult GetRightInModule(string module, int UserID)
        {
            if (!UserID.Equals(""))
            {
                Rights rights = new Rights();
                rights.Accept = new List <FunctionRight>();
                rights.Deny   = new List <FunctionRight>();

                if (UserID == 1)
                {
                    var rightAccept = db.Database.SqlQuery <FunctionRight>("select a.ID,a.[Right],a.GroupID from Account_Right a,Account_Right_Detail ar where a.ID=ar.RightID and a.ModuleID='" + module + "' and ar.AccountID='" + UserID + "' order by a.GroupID asc").ToList <FunctionRight>();
                    foreach (var r in rightAccept)
                    {
                        rights.Accept.Add(new FunctionRight()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                    var rightDeny = db.Database.SqlQuery <FunctionRight>("select distinct a.ID,a.[Right],a.GroupID from Account_Right a,Account_Right_Detail ar where a.ModuleID='" + module + "' and a.ID not in (select a.RightID from Account_Right_Detail a where a.AccountID='" + UserID + "') order by a.GroupID asc").ToList <FunctionRight>();
                    foreach (var r in rightDeny)
                    {
                        rights.Deny.Add(new FunctionRight()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                }
                else
                {
                    var rightAccept = db.Database.SqlQuery <FunctionRight>("select a.ID,a.[Right],a.GroupID from Account_Right a,Account_Right_Detail ar where a.ID=ar.RightID and a.ModuleID='" + module + "' and ar.AccountID='" + UserID + "' order by a.GroupID asc").ToList <FunctionRight>();
                    foreach (var r in rightAccept)
                    {
                        rights.Accept.Add(new FunctionRight()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                    var rightDeny = db.Database.SqlQuery <FunctionRight>("select distinct a.ID,a.[Right],a.GroupID from Account_Right a,Account_Right_Detail ar where a.ModuleID='" + module + "' and a.ID not in (select a.RightID from Account_Right_Detail a where a.AccountID='" + UserID + "') order by a.GroupID asc").ToList <FunctionRight>();
                    foreach (var r in rightDeny)
                    {
                        rights.Deny.Add(new FunctionRight()
                        {
                            ID      = r.ID,
                            Right   = r.Right,
                            GroupID = r.GroupID
                        });
                    }
                }
                return(Json(rights, JsonRequestBehavior.AllowGet));
            }
            else
            {
                RightsWhenCreate rights = new RightsWhenCreate();
                rights.Accept = new List <FunctionRight>();
                rights.Deny   = new List <FunctionRight>();
                var rightDeny = db.Database.SqlQuery <FunctionRight>("select a.ID,a.[Right],a.GroupID from Account_Right a where a.ModuleID='" + module + "' order by a.GroupID asc").ToList <FunctionRight>();
                foreach (var r in rightDeny)
                {
                    rights.Deny.Add(new FunctionRight()
                    {
                        ID      = r.ID,
                        Right   = r.Right,
                        GroupID = r.GroupID
                    });
                }
                return(Json(rights, JsonRequestBehavior.AllowGet));
            }
        }