
复制using System; using System.Collections.Generic; using System.Text; using System.Data.SqlTypes; using System.Data.SqlClient; using Microsoft.SqlServer.Server; public class AddrInfo [Microsoft.SqlServer.Server.SqlProcedure] public static void getAddrInfo(SqlString ip,存储 out SqlString info) using (SqlConnection connection = new SqlConnection("context connection=true")) //IP地址转为数字 string[] tmp = ip.Value.Split(new string[]{"."},StringSplitOptions.None); Int64 ipn = ToInt(ToBinary(tmp[0]) + ToBinary(tmp[1]) + ToBinary(tmp[2]) + ToBinary(tmp[3])); connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "select addr_info from CZIP where ipn1<=" + ipn.ToString() + " and ipn2>=" + ipn.ToString(); SqlDataReader dr = cmd.ExecuteReader(); using (dr) if (dr.Read()) info = dr.GetString(0); else info = "<无归属地数据>"; } } /// <summary> /// INT32 转为二进制字符串 /// </summary> /// <paramname="piNumber"></param> /// <returns></returns> private static String ToBinary(string num) int piNumber = Int32.Parse(num); string strBinary = ""; int iTmp; do iTmp = piNumber % 2; strBinary = iTmp.ToString() + strBinary; piNumberpiNumber = piNumber / 2; }while (piNumber != 0); return strBinary.PadLeft(8, 0); } /// <summary> /// </summary> /// <paramname="pStrBinary"></param> /// <returns></returns> private static long ToInt(string pStrBinary) char[] charArr = pStrBinary.ToCharArray(); long iReturnValue = 0; int iPow = 0; for (int i = 0; i <charArr.Length; i++) if (charArr[i].ToString() != "0" && charArr[i].ToString() != "1") { throw new Exception("输入字符串格式不正确!"); } } for (int i = 0; i <charArr.Length; i++) iPow = Convert.ToInt32(charArr[i].ToString()); iReturnValue += iPow * Convert.ToInt64(Math.Pow(2, charArr.Length - i - 1)); } return iReturnValue; } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.