www.pudn.com > CRM.rar > service.cs

using System; 
using System.Drawing; 
using System.Collections; 
using System.ComponentModel; 
using System.Windows.Forms; 
using System.Data.SqlClient; 
using System.IO; 
 
namespace WindowsApplication1 
{ 
	/// 
 
	/// service 的摘要说明。 
	/// 
 
	public class service : System.Windows.Forms.Form 
	{ 
		private System.Windows.Forms.Label label1; 
		private System.Windows.Forms.TextBox textBox1; 
		private System.Windows.Forms.TextBox textBox2; 
		private System.Windows.Forms.Label label2; 
		private System.Windows.Forms.TextBox textBox3; 
		private System.Windows.Forms.Label label3; 
		private System.Windows.Forms.Button button1; 
		/// 
 
		/// 必需的设计器变量。 
		/// 
 
		private System.ComponentModel.Container components = null; 
 
		public service() 
		{ 
			// 
			// Windows 窗体设计器支持所必需的 
			// 
			InitializeComponent(); 
 
			// 
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码 
			// 
		} 
 
		/// 
 
		/// 清理所有正在使用的资源。 
		/// 
 
		protected override void Dispose( bool disposing ) 
		{ 
			if( disposing ) 
			{ 
				if(components != null) 
				{ 
					components.Dispose(); 
				} 
			} 
			base.Dispose( disposing ); 
		} 
 
		#region Windows 窗体设计器生成的代码 
		/// 
 
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改 
		/// 此方法的内容。 
		/// 
 
		private void InitializeComponent() 
		{ 
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(service)); 
			this.label1 = new System.Windows.Forms.Label(); 
			this.textBox1 = new System.Windows.Forms.TextBox(); 
			this.textBox2 = new System.Windows.Forms.TextBox(); 
			this.label2 = new System.Windows.Forms.Label(); 
			this.textBox3 = new System.Windows.Forms.TextBox(); 
			this.label3 = new System.Windows.Forms.Label(); 
			this.button1 = new System.Windows.Forms.Button(); 
			this.SuspendLayout(); 
			//  
			// label1 
			//  
			this.label1.Location = new System.Drawing.Point(0, 8); 
			this.label1.Name = "label1"; 
			this.label1.Size = new System.Drawing.Size(56, 16); 
			this.label1.TabIndex = 0; 
			this.label1.Text = "Service"; 
			//  
			// textBox1 
			//  
			this.textBox1.Location = new System.Drawing.Point(56, 8); 
			this.textBox1.Name = "textBox1"; 
			this.textBox1.Size = new System.Drawing.Size(192, 21); 
			this.textBox1.TabIndex = 1; 
			this.textBox1.Text = ""; 
			//  
			// textBox2 
			//  
			this.textBox2.Location = new System.Drawing.Point(56, 40); 
			this.textBox2.Name = "textBox2"; 
			this.textBox2.Size = new System.Drawing.Size(192, 21); 
			this.textBox2.TabIndex = 3; 
			this.textBox2.Text = ""; 
			//  
			// label2 
			//  
			this.label2.Location = new System.Drawing.Point(0, 40); 
			this.label2.Name = "label2"; 
			this.label2.Size = new System.Drawing.Size(48, 16); 
			this.label2.TabIndex = 2; 
			this.label2.Text = "userid"; 
			//  
			// textBox3 
			//  
			this.textBox3.Location = new System.Drawing.Point(56, 72); 
			this.textBox3.Name = "textBox3"; 
			this.textBox3.PasswordChar = '*'; 
			this.textBox3.Size = new System.Drawing.Size(192, 21); 
			this.textBox3.TabIndex = 5; 
			this.textBox3.Text = ""; 
			//  
			// label3 
			//  
			this.label3.Location = new System.Drawing.Point(0, 72); 
			this.label3.Name = "label3"; 
			this.label3.Size = new System.Drawing.Size(56, 16); 
			this.label3.TabIndex = 4; 
			this.label3.Text = "password"; 
			//  
			// button1 
			//  
			this.button1.Location = new System.Drawing.Point(88, 104); 
			this.button1.Name = "button1"; 
			this.button1.TabIndex = 6; 
			this.button1.Text = "测试连接"; 
			this.button1.Click += new System.EventHandler(this.button1_Click); 
			//  
			// service 
			//  
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); 
			this.ClientSize = new System.Drawing.Size(256, 134); 
			this.Controls.Add(this.button1); 
			this.Controls.Add(this.textBox3); 
			this.Controls.Add(this.label3); 
			this.Controls.Add(this.textBox2); 
			this.Controls.Add(this.label2); 
			this.Controls.Add(this.textBox1); 
			this.Controls.Add(this.label1); 
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); 
			this.MaximizeBox = false; 
			this.Name = "service"; 
			this.Text = "service"; 
			this.ResumeLayout(false); 
 
		} 
		#endregion 
		private bool contest(string service,string uid,string pwd) 
		{ 
			SqlConnection con=new SqlConnection(); 
			con.ConnectionString="data source=" + service + "; uid=" + uid + "; pwd=" + pwd + "; DataBase=CRM;"; 
			try 
			{ 
					con.Open(); 
				con.Close(); 
				return true;				 
			} 
			catch(Exception e1) 
			{MessageBox.Show(e1.Message,"连接错误"); 
			return false;} 
		} 
 
		private void button1_Click(object sender, System.EventArgs e) 
		{ 
			if(contest(this.textBox1.Text.Trim(),this.textBox2.Text.Trim(),this.textBox3.Text.Trim())==true) 
			{ 
				 
				if(File.Exists(Application.StartupPath+"\\service.ini")) 
				{ 
					File.Delete(Application.StartupPath+"\\service.ini"); 
					//File.Create(Application.StartupPath+"\\service.ini"); 
					 
					using (StreamWriter sw = new StreamWriter(Application.StartupPath+"\\service.ini"))  
					{ 
						sw.WriteLine(this.textBox1.Text.Trim()); 
						sw.WriteLine(this.textBox2.Text.Trim()); 
						sw.WriteLine(this.textBox3.Text.Trim()); 
					} 
 
				} 
				else 
				{ 
					using (StreamWriter sw = new StreamWriter(Application.StartupPath+"\\service.ini"))  
					{ 
						sw.WriteLine(this.textBox1.Text.Trim()); 
						sw.WriteLine(this.textBox2.Text.Trim()); 
						sw.WriteLine(this.textBox3.Text.Trim()); 
					} 
				} 
				MessageBox.Show("些连接可用,配置成功","测试连接"); 
			this.Close(); 
		 
			} 
				 
		 
		 
		} 
	} 
}