frmdatamanager.cs

此文件为c#小程序,如果有感兴趣的朋友,请告知

using System;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;

namespace MPNumberProject
{
	/// <summary>
	/// frmDataManager 的摘要说明。
	/// </summary>
	public class frmDataManager : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Button btnDelete;
		private System.Windows.Forms.Button btnSave;
		private System.Windows.Forms.Button btnClose;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;
		private System.Windows.Forms.DataGrid dbgMessage;
		DataAccess access=new DataAccess ();
		private DataRow row;
		private string connectionString="server=127.0.0.1;database=Mobilephone;uid=tangrong;pwd=716";
		private SqlConnection conn;
		private SqlDataAdapter adapter;
		private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
		private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;
		private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn2;
		private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn3;
		private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn4;
		private DataSet dataset;

		public frmDataManager()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
			if(conn==null)
			{
				conn=new SqlConnection (connectionString);
				
			}
			if(conn.State!=ConnectionState.Open)
			{
				conn.Open();
			}

		}

		/// <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.dbgMessage = new System.Windows.Forms.DataGrid();
			this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
			this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.dataGridTextBoxColumn4 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.btnDelete = new System.Windows.Forms.Button();
			this.btnSave = new System.Windows.Forms.Button();
			this.btnClose = new System.Windows.Forms.Button();
			((System.ComponentModel.ISupportInitialize)(this.dbgMessage)).BeginInit();
			this.SuspendLayout();
			// 
			// dbgMessage
			// 
			this.dbgMessage.DataMember = "";
			this.dbgMessage.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dbgMessage.Location = new System.Drawing.Point(0, 0);
			this.dbgMessage.Name = "dbgMessage";
			this.dbgMessage.PreferredColumnWidth = 120;
			this.dbgMessage.Size = new System.Drawing.Size(576, 336);
			this.dbgMessage.TabIndex = 0;
			this.dbgMessage.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								   this.dataGridTableStyle1});
			this.dbgMessage.Click += new System.EventHandler(this.dbgMessage_Click);
			// 
			// dataGridTableStyle1
			// 
			this.dataGridTableStyle1.DataGrid = this.dbgMessage;
			this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.dataGridTextBoxColumn1,
																												  this.dataGridTextBoxColumn2,
																												  this.dataGridTextBoxColumn3,
																												  this.dataGridTextBoxColumn4});
			this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle1.MappingName = "MPNumber";
			// 
			// dataGridTextBoxColumn1
			// 
			this.dataGridTextBoxColumn1.Format = "";
			this.dataGridTextBoxColumn1.FormatInfo = null;
			this.dataGridTextBoxColumn1.MappingName = "Id";
			this.dataGridTextBoxColumn1.ReadOnly = true;
			this.dataGridTextBoxColumn1.Width = 0;
			// 
			// dataGridTextBoxColumn2
			// 
			this.dataGridTextBoxColumn2.Format = "";
			this.dataGridTextBoxColumn2.FormatInfo = null;
			this.dataGridTextBoxColumn2.HeaderText = "号段";
			this.dataGridTextBoxColumn2.MappingName = "号段";
			this.dataGridTextBoxColumn2.Width = 75;
			// 
			// dataGridTextBoxColumn3
			// 
			this.dataGridTextBoxColumn3.Format = "";
			this.dataGridTextBoxColumn3.FormatInfo = null;
			this.dataGridTextBoxColumn3.HeaderText = "所在省";
			this.dataGridTextBoxColumn3.MappingName = "省";
			this.dataGridTextBoxColumn3.Width = 75;
			// 
			// dataGridTextBoxColumn4
			// 
			this.dataGridTextBoxColumn4.Format = "";
			this.dataGridTextBoxColumn4.FormatInfo = null;
			this.dataGridTextBoxColumn4.HeaderText = "所在市";
			this.dataGridTextBoxColumn4.MappingName = "市";
			this.dataGridTextBoxColumn4.Width = 75;
			// 
			// btnDelete
			// 
			this.btnDelete.Location = new System.Drawing.Point(288, 344);
			this.btnDelete.Name = "btnDelete";
			this.btnDelete.TabIndex = 1;
			this.btnDelete.Text = "删除";
			this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
			// 
			// btnSave
			// 
			this.btnSave.Location = new System.Drawing.Point(384, 344);
			this.btnSave.Name = "btnSave";
			this.btnSave.TabIndex = 2;
			this.btnSave.Text = "保存";
			this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
			// 
			// btnClose
			// 
			this.btnClose.Location = new System.Drawing.Point(480, 344);
			this.btnClose.Name = "btnClose";
			this.btnClose.TabIndex = 3;
			this.btnClose.Text = "关闭";
			this.btnClose.Click += new System.EventHandler(this.btnClose_Click);
			// 
			// frmDataManager
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(576, 378);
			this.Controls.Add(this.btnClose);
			this.Controls.Add(this.btnSave);
			this.Controls.Add(this.btnDelete);
			this.Controls.Add(this.dbgMessage);
			this.Name = "frmDataManager";
			this.Text = "手机归属地数据管理";
			this.Load += new System.EventHandler(this.frmDataManager_Load);
			((System.ComponentModel.ISupportInitialize)(this.dbgMessage)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void btnClose_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void frmDataManager_Load(object sender, System.EventArgs e)
		{
			string sqlString="select Id,Number as 号段 ,Province as 省,City as 市 from MPNumber";
			DataTable datatable=access.Query("MPNumber",sqlString);
			dataset=datatable.DataSet;
			this.dbgMessage.DataSource=datatable;
			adapter=new SqlDataAdapter();			

		}

		private void btnSave_Click(object sender, System.EventArgs e)
		{
			string insertString="insert into MPNumber(Number,Province,City) values(@Number,@Province,@City)";

			adapter.InsertCommand=new SqlCommand(insertString,conn);
			SqlParameter parms11=adapter.InsertCommand.Parameters.Add(new SqlParameter("@Number",SqlDbType.VarChar,7));
			parms11.SourceColumn="号段";
			parms11.SourceVersion=DataRowVersion.Current;
			
			SqlParameter parms12=adapter.InsertCommand.Parameters.Add(new SqlParameter("@Province",SqlDbType.VarChar,20));
			parms12.SourceColumn="省";
			parms12.SourceVersion=DataRowVersion.Current;
			SqlParameter parms13=adapter.InsertCommand.Parameters.Add(new SqlParameter("@City",SqlDbType.VarChar,20));
			parms13.SourceColumn="市";
			parms13.SourceVersion=DataRowVersion.Current;

			
				string updateString="update MPNumber set Number=@Number,Province=@Province,City=@City where Id=@Id";
				adapter.UpdateCommand=new SqlCommand(updateString,conn);

				SqlParameter parms1=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Number",SqlDbType.VarChar,7));
				parms1.SourceColumn="号段";
				parms1.SourceVersion=DataRowVersion.Current;
				SqlParameter parms2=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Province",SqlDbType.VarChar,20));
				parms2.SourceColumn="省";
				parms2.SourceVersion=DataRowVersion.Current;
				SqlParameter parms3=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@City",SqlDbType.VarChar,20));
				parms3.SourceColumn="市";
				parms3.SourceVersion=DataRowVersion.Current;
				SqlParameter parms4=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Id",SqlDbType.Int));
				parms4.SourceColumn="Id";
				parms4.SourceVersion=DataRowVersion.Original;
				if(dataset.HasChanges())
				{
					
					adapter.Update(dataset,"MPNumber");
					MessageBox.Show("修改数据成功！！");
				}

			


		
		}

		private void dbgMessage_Click(object sender, System.EventArgs e)
		{
			if(((DataTable)this.dbgMessage.DataSource)!=null)
			{
				row=((DataTable)this.dbgMessage.DataSource).NewRow();
				if(((DataTable)this.dbgMessage.DataSource).Rows.Count>this.dbgMessage.CurrentRowIndex)
				{
					row=((DataTable)this.dbgMessage.DataSource).Rows[this.dbgMessage.CurrentRowIndex];
				}

			}
		
		}

		private void btnDelete_Click(object sender, System.EventArgs e)
		{
			dataset=new DataSet();
			string sqlString="select * from MPNumber";
			adapter=new SqlDataAdapter(sqlString,conn);
			adapter.Fill(dataset,"MPNumber");
			try
			{
				string delString="delete  from MPNumber where Id=@Id";
				adapter.DeleteCommand=new SqlCommand (delString,conn);
				SqlParameter parm=adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Id",SqlDbType.Int,4));
				parm.SourceColumn="Id";
				parm.SourceVersion=DataRowVersion.Original;
				dataset.Tables[0].Rows[this.dbgMessage.CurrentRowIndex].Delete();
				if(dataset.HasChanges())
				{
					adapter.Update(dataset,"MPNumber");
					MessageBox.Show("删除记录成功");
					((DataTable)(this.dbgMessage.DataSource)).Rows[this.dbgMessage.CurrentRowIndex].Delete();
				}
			}
			catch(Exception ee)
			{
				MessageBox.Show(ee.Message);
			}
		}
			}
	
}