//匹配当地所有号段 void mainWhile(object tel) { DateTime hdStart = DateTime.Now; int hdnum = 0; string telStr = tel.ToString(); string strSql = "select SUBSTRING(Number7,1,3) q3w from TelphoneData where SUBSTRING(Number7,4,4)=" + telStr.Substring(3, 4) + " and city='" + textBox2.Text + "'"; DataTable returnDt = SqlHelp.bangding(strSql); string telStr8 = telStr.Substring(3, 8); for (int i = 0; i < returnDt.Rows.Count; i++) { string keyword = returnDt.Rows[i][0].ToString() + telStr8; int bl = CollectRule.MainWhile(search, keyword); if (bl == 1) { num++; hdnum++; } else if (bl == -1) { MessageBox.Show(DateTime.Now.ToString() + "执行到:" + keyword + "时,当前IP开始被" + search + "屏蔽,未启动VPN!\r\n"); } } DateTime hdEnd = DateTime.Now; StringHelp.Write(StringHelp.pathError, hdEnd.ToString() + "号码:" + telStr + "执行结束。" + "用时:" + DateHelp.DateDiff(hdEnd, hdStart) + "获取个数:" + hdnum + "\r\n"); }
private void btnLogin_Click(object sender, EventArgs e) { //System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList; string strHostName = Dns.GetHostName(); //得到本机的主机名 IPHostEntry IpEntry = Dns.GetHostEntry(strHostName); //取得本机IP string strAddr = ""; for (int i = 0; i < IpEntry.AddressList.Length; i++) { //从IP地址列表中筛选出IPv4类型的IP地址 //AddressFamily.InterNetwork表示此IP为IPv4, //AddressFamily.InterNetworkV6表示此地址为IPv6类型 if (IpEntry.AddressList[i].AddressFamily == AddressFamily.InterNetwork) { strAddr = IpEntry.AddressList[i].ToString(); } } string strSql = "select * from LoginUser where UserName='******' and Password='******' and Computer='" + strHostName + "'";//' and ipAdress='" + strAddr + " DataTable returnDt = SqlHelp.bangding(strSql); if (returnDt.Rows.Count >= 1) { Main main = new Main(); main.Show(); this.Hide(); } else { MessageBox.Show("登录失败!"); } }
private void button3_Click(object sender, EventArgs e) { string strSql = ""; for (int i = 0; i < 100; i++) { strSql = "SELECT SUBSTRING(Telphone, 9, 3)%100 '序号',Telphone '电话',CASE sellMark WHEN 0 THEN '未售' ELSE '已售' end '是否已售' FROM TelphoneSource WHERE SUBSTRING(Telphone, 8, 4) > " + i * 100 + " AND SUBSTRING(Telphone, 8, 4)<= " + (i + 1) * 100 + " AND SUBSTRING(Telphone,4, 4)= 0539"; DataTable returnDt = SqlHelp.bangding(strSql); for (int r = 0; r < returnDt.Rows.Count; r++) { } } }
private void button2_Click(object sender, EventArgs e) { string sql = ""; for (int i = 0; i < 100; i++) { sql += ad("0539", i * 100, (i + 1) * 100); } string ss = sql.Substring(0, sql.Length - 10); SqlHelp.connStr = "Data Source=47.93.253.194;Initial Catalog=HZSoftFramework_Base_2016;User ID=sa;Password=system@123"; DataTable returnDt = SqlHelp.bangding(ss); dataGridView1.DataSource = returnDt; }
void mainWhile(object tel) { string telStr = tel.ToString(); string strSql = "select SUBSTRING(Number7,1,3) q3w from TelphoneData where SUBSTRING(Number7,4,4)=" + telStr.Substring(3, 4) + " and city='" + textBox2.Text + "'"; DataTable returnDt = SqlHelp.bangding(strSql); string telStr8 = telStr.Substring(3, 8); for (int i = 0; i < returnDt.Rows.Count; i++) { string keyword = returnDt.Rows[i][0].ToString() + telStr8; int bl = CollectRule.MainWhile(search, keyword); if (bl == 1) { num++; } else if (bl == -1) { MessageBox.Show(DateTime.Now.ToString() + "执行到:" + keyword + "时,当前IP开始被" + search + "屏蔽,未启动VPN!\r\n"); } } }
private void button1_Click(object sender, EventArgs e) { //C:\Users\Administrator\Documents\Visual Studio 2015\Projects\号码采集系统\号码采集系统\bin\x86\Debug\20170914 string spath = Environment.CurrentDirectory + "\\" + dateStr; if (!Directory.Exists(spath)) { DirectoryInfo directoryInfo = new DirectoryInfo(spath); directoryInfo.Create(); } StringHelp.filePathOut = spath + "\\baidu手机万号采集_" + textBox2.Text.Trim() + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls"; StringHelp.pathError = spath + "\\baidu手机万号采集_" + textBox2.Text.Trim() + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".txt"; //创建excel文件 StringHelp.CreateExcel(); if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "") { MessageBox.Show("城市或号段不能为空!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } dt = DateTime.Now; label3.Text = dt + "正在执行……"; z4Str = textBox2.Text; ThreadPool.SetMaxThreads(4, 4); //设置最大线程数 StringHelp.Write(StringHelp.pathError, DateTime.Now.ToString() + "\r\n--------------------------------" + textBox2.Text + "号段开始-------------------------------------" + "\r\n"); string strSql = "select SUBSTRING(Number7,1,3) q3w from TelphoneData where SUBSTRING(Number7,4,4)=" + textBox2.Text.Trim() + " and city='" + textBox1.Text.Trim() + "' AND SUBSTRING(Number7,1,3) NOT IN ('170','171')"; DataTable returnDt = SqlHelp.bangding(strSql); for (int i = 0; i < returnDt.Rows.Count; i++) { ThreadPool.QueueUserWorkItem(new WaitCallback(mainWhile), returnDt.Rows[i][0].ToString()); } //是否结束所有线程 rhw = ThreadPool.RegisterWaitForSingleObject(new System.Threading.AutoResetEvent(false), CheckThreadPool, null, 5000, false); }