/// <summary>
/// 获取ip库对应的区域信息
/// </summary>
/// <param name="ipinfo">ip库记录</param>
/// <returns>区域信息</returns>
public string GetIPArea(string strIPAddr)
{
SysIPInfo ipinfo = Get_CityByIP(strIPAddr);
string Area_Name = "";
if (ipinfo != null)
{
Area_Name = ipinfo.country + " " + ipinfo.city;
}
return(Area_Name);
}
/// <summary>
/// 根据IP获取ip库记录实体
/// </summary>
/// <param name="strIPAddr">ip地址</param>
/// <returns>ip库记录实体</returns>
public SysIPInfo Get_CityByIP(string strIPAddr)
{
SysIPInfo ipinfo = null;
long ipnum = Get_IPNum(strIPAddr);
int cityid = 0;
IList <SysIPInfo> entitys = MyBLL.GetSysIPs(ipnum);
if (entitys != null)
{
ipinfo = entitys[0];
}
return(ipinfo);
}
/// <summary>
/// 获取IP信息
/// </summary>
/// <param name="userIP">IP编码</param>
/// <returns>IP实体信息集合</returns>
public virtual IList <SysIPInfo> GetSysIPs(long userIP)
{
IList <SysIPInfo> entitys = null;
SysIPInfo entity = null;
string SqlList;
SqlDataReader RdrList = null;
try
{
SqlList = "select * from Sys_IP where (onip<=" + userIP + ") and (offip>=" + userIP + ")";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SysIPInfo>();
while (RdrList.Read())
{
entity = new SysIPInfo();
entity.oniptxt = Tools.NullStr(RdrList["oniptxt"]);
entity.offiptxt = Tools.NullStr(RdrList["offiptxt"]);
entity.ProvinceID = Tools.NullInt(RdrList["ProvinceID"]);
entity.CityID = Tools.NullInt(RdrList["CityID"]);
entity.CountyID = Tools.NullInt(RdrList["CountyID"]);
entity.country = Tools.NullStr(RdrList["country"]);
entity.city = Tools.NullStr(RdrList["city"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
/// <summary>
/// 根据IP获取ip库记录实体
/// </summary>
/// <returns>ip库记录实体</returns>
public SysIPInfo Get_CityByIP()
{
SysIPInfo ipinfo = new SysIPInfo();
long ipnum = Get_IPNum();
int cityid = 0;
IList <SysIPInfo> entitys = MyBLL.GetSysIPs(ipnum);
if (entitys != null)
{
ipinfo = entitys[0];
}
if (ipinfo.CityID == 0)
{
ipinfo.CityID = 1;
}
if (ipinfo.ProvinceID == 1)
{
ipinfo.ProvinceID = 1;
}
return(ipinfo);
}
