首先要建一张表,
CREATE TABLE [AutoLogin] (
[ID] [int] IDENTITY (1, 1) NOT NULL,
[UserID] [int] NULL,
[IPStart] [nvarchar] (50) NULL,
[IPStartNum] [nvarchar] (50) NULL,
[IPEnd] [nvarchar] (50) NULL,
[IPEndNum] [nvarchar] (50) NULL,
[State] [tinyint] NULL,
[CreatDate] [smalldatetime] NULL,
[Remark] [nvarchar] (500) NULL,
[Bind] [tinyint] NULL,
[DisPlay] [tinyint] NULL)
预先将将起始IP和截至IP转换成对应的64位整数,保存到数据库表中,这样就可以通过ip对应的数字查询客户ip地址是不是在自动登陆的ip地址段内,将IP转换成数字的函数如下
# region 将IP地址转换成数值
/// <summary>
/// 将IP地址转换成数值
/// </summary>
/// <param name="sIP"> 用户IP </param>
/// <returns> 返回结果是64位整型 </returns>
public static long IPToNum( string sIP)
{
long lIPAddrToInt;
try
{
if (sIP ==
/// <summary>
/// 将IP地址转换成数值
/// </summary>
/// <param name="sIP"> 用户IP </param>
/// <returns> 返回结果是64位整型 </returns>
public static long IPToNum( string sIP)
{
long lIPAddrToInt;
try
{
if (sIP ==