/// <summary> /// 更新权限 /// </summary> public static bool UpdatePowers(int rid, int[] Powers) { try { //先删除原有权限 BaseDAL.ExecuteNonQuery("delete Power where RoleID=" + rid); //添加新的权限 foreach (var item in Powers) { if (Convert.ToInt32(BaseDAL.ExecuteScalar("select count(*) from Power where RoleID=" + rid + " and MenuID=" + item)) == 0) { BaseDAL.ExecuteNonQuery("insert into Power (RoleID, MenuID) values (" + rid + ", " + item + ")"); } } return(true); } catch { return(false); } }
/// <summary> /// 检查密码是否正确 /// </summary> public static int CheckOldPwd(string pwd, int userID) { return(Convert.ToInt32(BaseDAL.ExecuteScalar("select count(*) from Users where UserID=@UserID and UserLPWD=@UserLPWD" , new SqlParameter("@UserID", userID), new SqlParameter("@UserLPWD", BitConverter.ToString(MD5.Create().ComputeHash(Encoding.Default.GetBytes(pwd))))))); }
/// <summary> /// 统计角色下共有多少个用户 /// </summary> public static int CountUserByRole(int roleID) { return(Convert.ToInt32(BaseDAL.ExecuteScalar("select count(*) from Users where roleid=" + roleID))); }
/// <summary> /// 检查用户名是否存在 /// </summary> public static bool IsLoginNameTrue(string name) { return(Convert.ToInt32(BaseDAL.ExecuteScalar("select count(*) from Users where UserLName=@name", new SqlParameter("@name", name))) > 0); }
/// <summary> /// 查询指定客户流失原因 /// </summary> public static string SelectClReason(int clID) { return(Convert.ToString(BaseDAL.ExecuteScalar("select CLReason from CustomLosts where CLID=" + clID))); }
/// <summary> /// 判断指定角色是否拥有指定菜单权限 /// </summary> public static bool HasPower(int roleID, int menuID) { return(Convert.ToInt32(BaseDAL.ExecuteScalar(string.Format("select count(*) from Power where RoleID={0} and MenuID={1}", roleID, menuID))) > 0); }