예제 #1
0
        public bool ChangePower(int rid, List <int> ids)
        {
            HashSet <int> hs = new HashSet <int>(ids);

            try
            {
                //先根据角色id删除已有权限
                Model.Power p = new Model.Power()
                {
                    RoleID = rid
                };
                if (DalBase.Delete(p) != 0)
                {
                    foreach (int item in hs)
                    {
                        Model.Power p1 = new Model.Power()
                        {
                            MenuID = item,
                            RoleID = rid
                        };
                        DalBase.Insert(p1);
                    }
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception)
            {
                return(false);
            }
        }
예제 #2
0
        public IList <Model.Power> GetPowerByRoleIdAndPrarentId(int roleId, int prarentId)
        {
            IList <Model.Power> list = new List <Model.Power>();
            string proName           = "Usp_GetPowerByRoleIdAndPrarentId";

            SqlParameter[] pars = new SqlParameter[]
            {
                new SqlParameter("@roleId", roleId),
                new SqlParameter("@prarentId", prarentId)
            };
            using (SqlDataReader reader = DBHelper.ExecuteReaderProc(proName, pars))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Model.Power p = new Model.Power();
                        p.PowerId     = (int)reader["PowerId"];
                        p.PowerName   = (string)reader["PowerName"];
                        p.prarentId   = (int)reader["prarentId"];
                        p.URL         = (string)reader["URL"];
                        p.Description = (string)reader["Description"];
                        list.Add(p);
                    }
                }
            }

            return(list);
        }
예제 #3
0
        public string AddPower(Model.Power power)
        {
            string proName = "usp_AddNewPower";

            SqlParameter[] pars = new SqlParameter[]
            {
                new SqlParameter("@PowerName", power.PowerName),
                new SqlParameter("@URL", power.URL),
                new SqlParameter("@prarentId", power.prarentId),
                new SqlParameter("@description", power.Description),
            };
            return(DBHelper.ExecuteNonQueryProc(proName, pars).ToString());
        }
예제 #4
0
        public IList <Model.Power> selectAllPowersByUserId(int uid)
        {
            IList <Model.Power> list = new List <Model.Power>();
            string proName           = "usp_selectAllPowersByUserId";

            using (SqlDataReader reader = DBHelper.ExecuteReaderProc(proName, new SqlParameter("@uid", uid)))
            {
                while (reader.Read())
                {
                    Model.Power p = new Model.Power();
                    p.PowerId     = (int)reader["PowerId"];
                    p.PowerName   = (string)reader["PowerName"];
                    p.prarentId   = (int)reader["prarentId"];
                    p.URL         = (string)reader["URL"];
                    p.Description = (string)reader["Description"];
                    list.Add(p);
                }
            }

            return(list);
        }
예제 #5
0
        public IList <Model.Power> SelectPowersByRoleId(int roleId)
        {
            string proName           = "usp_selectPowersByRoleId";
            IList <Model.Power> list = new List <Model.Power>();

            using (SqlDataReader reader = DBHelper.ExecuteReaderProc(proName, new SqlParameter("@roleId", roleId)))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Model.Power power = new Model.Power();
                        power.Description = (string)reader["Description"];
                        power.PowerId     = (int)reader["PowerId"];
                        power.PowerName   = (string)reader["PowerName"];
                        power.prarentId   = (int)reader["prarentId"];
                        power.URL         = (string)reader["URL"];

                        list.Add(power);
                    }
                }
            }
            return(list);
        }
예제 #6
0
 public string AddPower(Model.Power power)
 {
     return(rolePowerService.AddPower(power));
 }