/// <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);
}
