手机号码归属地查询

app.config

<configuration>
  <connectionStrings>
    <add name="Constr" connectionString="Data Source=./SQLEXPRESS;
AttachDBFilename=D:/My Documents/Documents/Visual Studio 2010/Projects/号码查询/号码查询/Numbers.mdf;
Integrated Security=True;User Instance=True"/>
  </connectionStrings>
</configuration>

form1.cs

Code:

1. using System;   
2. using System.Collections.Generic;   
3. using System.ComponentModel;   
4. using System.Data;   
5. using System.Drawing;   
6. using System.Linq;   
7. using System.Text;   
8. using System.Windows.Forms;   
9. using System.Data.SqlClient;   
10. using System.Configuration;   
11. using System.IO;   
12.   
13. namespace 号码查询   
14. {   
15.     public partial class Form1 : Form   
16.     {   
17.         public Form1()   
18.         {   
19.             InitializeComponent();   
20.         }   
21.   
22.         private void btnImport_Click(object sender, EventArgs e)   
23.         {   
24.             FolderBrowserDialog Dialog = new FolderBrowserDialog();//打开文件选择框   
25.             if (Dialog.ShowDialog() != DialogResult.OK)   
26.             {   
27.                 return;   
28.             }   
29.             string path = Dialog.SelectedPath;   
30.   
31.   
32.             string connstr=ConfigurationManager.ConnectionStrings["Constr"].ConnectionString;   
33.             using (SqlConnection conn = new SqlConnection(connstr))   
34.             {   
35.                 conn.Open();   
36.                 using (SqlCommand cmd = conn.CreateCommand())   
37.                 {   
38.                     cmd.CommandText = "Delete from T_Numbers";   
39.                     cmd.ExecuteNonQuery();   
40.                 }   
41.             }   
42.   
43.             string[] files = Directory.GetFiles(path,"*.txt",SearchOption.AllDirectories );//筛选文件   
44.               
45.             using (SqlConnection conn = new SqlConnection(connstr))   
46.             {   
47.                 conn.Open();   
48.                 using (SqlCommand cmd = conn.CreateCommand())   
49.                 {   
50.                     cmd.CommandText = "Insert into T_Numbers(FirstNumber,EndNumber,Callerloc) values(@FirstNo,@EndNO,@Callerloc)";   
51.                     foreach (string file in files)   
52.                     {   
53.                         string MOBILE = Path.GetFileNameWithoutExtension(file);   
54.                         string[] lines = File.ReadAllLines(file,Encoding.Default);   
55.                         foreach (string line in lines)   
56.                         {   
57.                             string[] str = line.Split('-');   
58.                             string FirstNumber = str[0];   
59.                             string EndNumber = str[1];   
60.                             string City = str[2];   
61.   
62.                             cmd.Parameters.Clear();   
63.                             cmd.Parameters.Add(new SqlParameter("FirstNo", FirstNumber));   
64.                             cmd.Parameters.Add(new SqlParameter("EndNo", EndNumber));   
65.                             cmd.Parameters.Add(new SqlParameter("Callerloc", MOBILE+City));   
66.                             cmd.ExecuteNonQuery();   
67.                         }   
68.                     }   
69.                 }   
70.             }   
71.                
72.         }   
73.   
74.         private void button1_Click(object sender, EventArgs e)   
75.         {   
76.             string connstr=ConfigurationManager.ConnectionStrings["Constr"].ConnectionString;   
77.             using (SqlConnection conn = new SqlConnection(connstr))   
78.             {   
79.                 conn.Open();   
80.                 using (SqlCommand cmd = conn.CreateCommand())   
81.                 {   
82.                     cmd.CommandText = "select Callerloc from T_Numbers where FirstNumber<=@No and EndNumber>=@No";   
83.                     cmd.Parameters.AddWithValue("No", textBox1.Text);   
84.                     using (SqlDataReader reader = cmd.ExecuteReader())   
85.                     {   
86.                         if (reader.Read())   
87.                         {   
88.                             string name = reader.GetString(reader.GetOrdinal("Callerloc"));   
89.                             MessageBox.Show(name);   
90.                         }   
91.                         else  
92.                         {   
93.                             MessageBox.Show("没有找到该号码归属地！");   
94.                         }   
95.                     }   
96.                 }   
97.             }   
98.         }   
99.     }   
100. }