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); } }
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); }
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); }
public int DelRole(int id) { return(DalBase.Delete <Model.Role>(id)); }
public int delAct(int id) { return(DalBase.Delete <Model.Activitys>(id)); }
public int delLink(int id) { return(DalBase.Delete <Model.LinkMans>(id)); }
private int FuncDelete(T obj) { return(CurrentDAL.Delete(obj)); }