Esempio n. 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);
            }
        }
Esempio n. 2
0
        public int DelChance(int id)
        {
            //1.根据 session里面的用户名去得到这个人的角色ID 和角色名

            //2.判断如果角色名if(==销售 主管 ){直接删除} eles if(==销售经理){ 机会的创建人ID==登录人的ID } else {没有权限删除}

            //机会创建人id
            string sql = string.Format(@"select ChanCreateMan from Chances where ChanID=@ChanID");

            SqlParameter[] sp = new SqlParameter[] {
                new SqlParameter("@ChanID", id)
            };
            int crid = DalBase.SelectObj(sql, sp);

            //当前登录人id
            string UserLName = Session["UserLName"].ToString();
            string sql1      = string.Format(@"select UserID from Users where UserLName=@UserLName");

            SqlParameter[] sp1 = new SqlParameter[] {
                new SqlParameter("@UserLName", UserLName)
            };
            int uid = DalBase.SelectObj(sql1, sp1);

            //当前登录人角色id
            string sql2 = string.Format(@"select RoleID from Users where UserLName=@UserLName");

            SqlParameter[] sp2 = new SqlParameter[] {
                new SqlParameter("@UserLName", UserLName)
            };
            int rid = DalBase.SelectObj(sql2, sp2);

            if (rid <= 2)
            {
                DalBase.Delete <Model.Chances>(id);
            }
            else if (rid == 3)
            {
                if (crid == uid)
                {
                    DalBase.Delete <Model.Chances>(id);
                }
                else
                {
                    return(-1);
                }
            }

            return(1);
        }
Esempio n. 3
0
        public int DelUsersById(int id)
        {
            //根据当前登录name查询id
            //判断是否相等
            //当前登录人id
            string UserLName = Session["UserLName"].ToString();
            string sql1      = string.Format(@"select UserID from Users where UserLName=@UserLName");

            SqlParameter[] sp1 = new SqlParameter[] {
                new SqlParameter("@UserLName", UserLName)
            };
            int uid = DalBase.SelectObj(sql1, sp1);

            if (id != uid)
            {
                return(DalBase.Delete <Model.Users>(id));
            }
            return(-1);
        }
Esempio n. 4
0
 public int DelRole(int id)
 {
     return(DalBase.Delete <Model.Role>(id));
 }
Esempio n. 5
0
 public int delAct(int id)
 {
     return(DalBase.Delete <Model.Activitys>(id));
 }
Esempio n. 6
0
 public int delLink(int id)
 {
     return(DalBase.Delete <Model.LinkMans>(id));
 }
Esempio n. 7
0
 private int FuncDelete(T obj)
 {
     return(CurrentDAL.Delete(obj));
 }