using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace smsphone
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Button button1;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.TextBox textBox6;
private System.Windows.Forms.TextBox textBox7;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label9;
public SqlConnection conn;
public Form1()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.button1 = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.label9 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.label8 = new System.Windows.Forms.Label();
this.textBox7 = new System.Windows.Forms.TextBox();
this.textBox6 = new System.Windows.Forms.TextBox();
this.button2 = new System.Windows.Forms.Button();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.textBox5 = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.textBox4 = new System.Windows.Forms.TextBox();
this.groupBox1.SuspendLayout();
this.groupBox2.SuspendLayout();
this.SuspendLayout();
//
// button1
//
this.button1.Location = new System.Drawing.Point(160, 48);
this.button1.Name = "button1";
this.button1.TabIndex = 0;
this.button1.Text = "批量导入";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(16, 48);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 1;
this.textBox1.Text = "133699";
//
// label1
//
this.label1.Location = new System.Drawing.Point(8, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(136, 16);
this.label1.TabIndex = 2;
this.label1.Text = "请输入手机号的前7位：";
//
// groupBox1
//
this.groupBox1.Controls.Add(this.label9);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.textBox3);
this.groupBox1.Controls.Add(this.textBox2);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Controls.Add(this.textBox1);
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.Location = new System.Drawing.Point(8, 200);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(280, 168);
this.groupBox1.TabIndex = 3;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "手机号批量导入";
//
// label9
//
this.label9.ForeColor = System.Drawing.SystemColors.ActiveCaption;
this.label9.Location = new System.Drawing.Point(16, 136);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(240, 23);
this.label9.TabIndex = 7;
//
// label3
//
this.label3.Location = new System.Drawing.Point(128, 112);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(16, 23);
this.label3.TabIndex = 6;
this.label3.Text = "-";
//
// label2
//
this.label2.Location = new System.Drawing.Point(8, 80);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(128, 16);
this.label2.TabIndex = 5;
this.label2.Text = "输入后4位的号段：";
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(144, 104);
this.textBox3.Name = "textBox3";
this.textBox3.TabIndex = 4;
this.textBox3.Text = "3";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(16, 104);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(104, 21);
this.textBox2.TabIndex = 3;
this.textBox2.Text = "0";
//
// groupBox2
//
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.textBox7);
this.groupBox2.Controls.Add(this.textBox6);
this.groupBox2.Controls.Add(this.button2);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.textBox5);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.textBox4);
this.groupBox2.Location = new System.Drawing.Point(8, 16);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(280, 168);
this.groupBox2.TabIndex = 4;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "数据库信息";
//
// label8
//
this.label8.Location = new System.Drawing.Point(120, 136);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(120, 23);
this.label8.TabIndex = 9;
//
// textBox7
//
this.textBox7.Location = new System.Drawing.Point(136, 104);
this.textBox7.Name = "textBox7";
this.textBox7.TabIndex = 8;
this.textBox7.Text = "sa";
//
// textBox6
//
this.textBox6.Location = new System.Drawing.Point(8, 104);
this.textBox6.Name = "textBox6";
this.textBox6.TabIndex = 7;
this.textBox6.Text = "sa";
//
// button2
//
this.button2.Location = new System.Drawing.Point(8, 136);
this.button2.Name = "button2";
this.button2.TabIndex = 6;
this.button2.Text = "测试连接";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// label7
//
this.label7.Location = new System.Drawing.Point(136, 80);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(100, 16);
this.label7.TabIndex = 5;
this.label7.Text = "密码：";
//
// label6
//
this.label6.Location = new System.Drawing.Point(8, 80);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(100, 16);
this.label6.TabIndex = 4;
this.label6.Text = "用户名：";
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(136, 48);
this.textBox5.Name = "textBox5";
this.textBox5.TabIndex = 3;
this.textBox5.Text = "usm_sgip";
//
// label5
//
this.label5.Location = new System.Drawing.Point(136, 24);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(96, 16);
this.label5.TabIndex = 2;
this.label5.Text = "数据库名称：";
//
// label4
//
this.label4.Location = new System.Drawing.Point(8, 24);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(88, 16);
this.label4.TabIndex = 1;
this.label4.Text = "服务器名称：";
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(8, 48);
this.textBox4.Name = "textBox4";
this.textBox4.TabIndex = 0;
this.textBox4.Text = "USER-41V1A4IKRT//BULBUL";
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(296, 373);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.groupBox1);
this.Name = "Form1";
this.Text = "手机号批量导入系统";
this.Load += new System.EventHandler(this.Form1_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void Form1_Load(object sender, System.EventArgs e)
{
}
private void button2_Click(object sender, System.EventArgs e)
{
//数据库地址
string Dbserver = this.textBox4.Text;
//数据库名字
string Dbase = this.textBox5.Text;
//数据库用户名
string DbUserId = this.textBox6.Text;
//数据库密码
string DbUserPSW = this.textBox7.Text;
//连接数据库字串
string sqlconn = "server=" + Dbserver + ";database=" + Dbase + ";UID=" + DbUserId + ";PWD=" + DbUserPSW + "";
SqlConnection conn = new SqlConnection(sqlconn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
this.label8.Text = "数据库连接成功！";
}
else
{
this.label8.Text = "数据库连接失败请检查你的输入！";
}
}
private void button1_Click(object sender, System.EventArgs e)
{
int i;
string strSQL;
//数据库地址
string Dbserver = this.textBox4.Text;
//数据库名字
string Dbase = this.textBox5.Text;
//数据库用户名
string DbUserId = this.textBox6.Text;
//数据库密码
string DbUserPSW = this.textBox7.Text;
//号码段
string Forward = this.textBox2.Text;
string Back = this.textBox3.Text;
string PhoneId = this.textBox1.Text;
//连接数据库字串
string sqlconn = "server=" + Dbserver + ";database=" + Dbase + ";UID=" + DbUserId + ";PWD=" + DbUserPSW + "";
//SqlConnection conn=new SqlConnection("server=USER-41V1A4IKRT//BULBUL;database=usm_sgip;uid=sa;pwd=sa");
SqlConnection conn = new SqlConnection(sqlconn);
for(i=int.Parse(Forward);i<int.Parse(Back);i++)
{
string InPut;
InPut = PhoneId + FormatKey(((object)i).ToString());
strSQL = "INSERT INTO phone (phone) VALUES ("+InPut+")";
SqlCommand cmd=new SqlCommand(strSQL,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
this.label9.Text = "导入成功！";
}
private string FormatKey(string InPut)
{
if (InPut.Length==1)
{
InPut="000"+InPut;
}
if (InPut.Length==2)
{
InPut="00"+InPut;
}
if (InPut.Length==3)
{
InPut="0"+InPut;
}
if (InPut.Length==4)
{
InPut=InPut;
}
return InPut;
}
}
}