user.cs

《C#数据库项目案例导航》一书的配套光盘

																																																			  new System.Data.Common.DataColumnMapping("UserName", "UserName"),
																																																			  new System.Data.Common.DataColumnMapping("UserSpecity", "UserSpecity"),
																																																			  new System.Data.Common.DataColumnMapping("UserRemark", "UserRemark")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT UserId, UserName, UserSpecity, UserRemark FROM [User]";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = "INSERT INTO [User] (UserId, UserName, UserSpecity, UserRemark) VALUES (@UserId, @" +
				"UserName, @UserSpecity, @UserRemark); SELECT UserId, UserName, UserSpecity, User" +
				"Remark FROM [User] WHERE (UserId = @UserId)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserId", System.Data.SqlDbType.VarChar, 3, "UserId"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 20, "UserName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserSpecity", System.Data.SqlDbType.VarChar, 20, "UserSpecity"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserRemark", System.Data.SqlDbType.VarChar, 50, "UserRemark"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE [User] SET UserId = @UserId, UserName = @UserName, UserSpecity = @UserSpecity, UserRemark = @UserRemark WHERE (UserId = @Original_UserId) AND (UserName = @Original_UserName OR @Original_UserName IS NULL AND UserName IS NULL) AND (UserRemark = @Original_UserRemark OR @Original_UserRemark IS NULL AND UserRemark IS NULL) AND (UserSpecity = @Original_UserSpecity OR @Original_UserSpecity IS NULL AND UserSpecity IS NULL); SELECT UserId, UserName, UserSpecity, UserRemark FROM [User] WHERE (UserId = @UserId)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserId", System.Data.SqlDbType.VarChar, 3, "UserId"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 20, "UserName"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserSpecity", System.Data.SqlDbType.VarChar, 20, "UserSpecity"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserRemark", System.Data.SqlDbType.VarChar, 50, "UserRemark"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserId", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserId", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserName", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserRemark", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserRemark", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserSpecity", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserSpecity", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM [User] WHERE (UserId = @Original_UserId) AND (UserName = @Original_UserName OR @Original_UserName IS NULL AND UserName IS NULL) AND (UserRemark = @Original_UserRemark OR @Original_UserRemark IS NULL AND UserRemark IS NULL) AND (UserSpecity = @Original_UserSpecity OR @Original_UserSpecity IS NULL AND UserSpecity IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserId", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserId", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserRemark", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserRemark", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserSpecity", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserSpecity", System.Data.DataRowVersion.Original, null));
			// 
			// objDataSetUser
			// 
			this.objDataSetUser.DataSetName = "DataSetUser";
			this.objDataSetUser.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// User
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(592, 357);
			this.Controls.Add(this.btnPrint);
			this.Controls.Add(this.btnQuery);
			this.Controls.Add(this.btnApply);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.btnAdd);
			this.Controls.Add(this.btnDelete);
			this.Controls.Add(this.btnModify);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.btnCancel);
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "User";
			this.Text = "用户信息维护";
			this.Load += new System.EventHandler(this.User_Load);
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.objDataSetUser)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		public void ErrorHandle(System.Exception E)
		{
			MessageBox.Show(E.ToString());
		}		

		private void ButtonPositonChange()
		{
			this.btnPrevious.Enabled=true;
			this.btnNext.Enabled=true;
			this.btnFirst.Enabled=true;
			this.btnLast.Enabled=true;
			if(this.BindingContext[this.objDataSetUser,"User"].Position==0)
			{
				this.btnFirst.Enabled=false;
				this.btnPrevious.Enabled=false;
			}
			if(this.BindingContext[this.objDataSetUser,"User"].Position==this.BindingContext[this.objDataSetUser,"User"].Count-1)
			{
				this.btnNext.Enabled=false;
				this.btnLast.Enabled=false;
			}
		}
		
		private void DatasetPostionChange()
		{
			this.lblDatasetPosition.Text=(this.BindingContext[this.objDataSetUser,"User"].Position+1)+"的"+
				(this.BindingContext[this.objDataSetUser,"User"].Count);
		}

		private void TextEnableControl(bool valid)
		{
			if(valid)
			{
				this.textId.Enabled=true;
				this.textName.Enabled=true;
				this.textSpecity.Enabled=true;				
				this.textRemark.Enabled=true;
			}
			else
			{
				this.textId.Enabled=false;
				this.textName.Enabled=false;				
				this.textSpecity.Enabled=false;
				this.textRemark.Enabled=false;
			}
		}

		private void ButtonEnableControl(bool valid)
		{
			if(valid)
			{
				this.btnCancel.Enabled=true;
				this.btnApply.Enabled=true;
			}
			else
			{
				this.btnCancel.Enabled=false;
				this.btnApply.Enabled=false;
			}
		}
						
		private void LoadDataSet()
		{
			DataSetUser objDataSetTemp=new DataSetUser();
			try
			{
				this.FillDataSet(objDataSetTemp);

			}
			catch (System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			try
			{
				this.objDataSetUser.Clear();
				this.objDataSetUser.Merge(objDataSetTemp);
			}
			catch(System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			
		}
		
		private void FillDataSet(DataSetUser dataset)
		{
			dataset.EnforceConstraints=false;
			try
			{
				this.sqlConnection1.Open();
				this.sqlDataAdapter1.Fill(dataset);
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		
			finally
			{
				dataset.EnforceConstraints=true;
				this.sqlConnection1.Close();
			}
		}

		private void User_Load(object sender, System.EventArgs e)
		{
			this.LoadDataSet();
			this.DatasetPostionChange();
			this.ButtonPositonChange();
			this.TextEnableControl(false);
			this.ButtonEnableControl(false);
		
		}
		
		private void btnNext_Click(object sender, System.EventArgs e)
		{
			this.BindingContext[this.objDataSetUser,"User"].Position+=1;
			this.ButtonPositonChange();
			this.DatasetPostionChange();

		}
		

		private void btnPrevious_Click(object sender, System.EventArgs e)
		{
			this.BindingContext[this.objDataSetUser,"User"].Position-=1;
			this.ButtonPositonChange();
			this.DatasetPostionChange();
		
		}

		private void btnFirst_Click(object sender, System.EventArgs e)
		{
			this.BindingContext[this.objDataSetUser,"User"].Position=0;
			this.ButtonPositonChange();
			this.DatasetPostionChange();
		}

		private void btnLast_Click(object sender, System.EventArgs e)
		{
			this.BindingContext[this.objDataSetUser,"User"].Position=this.BindingContext[this.objDataSetUser,"User"].Count-1;
			this.ButtonPositonChange();
			this.DatasetPostionChange();
		}		

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.BindingContext[this.objDataSetUser,"User"].AddNew();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			this.DatasetPostionChange();
			this.ButtonPositonChange();	
			this.TextEnableControl(true);
			this.ButtonEnableControl(true);
		}

		private void btnDelete_Click(object sender, System.EventArgs e)
		{
			if((this.BindingContext[this.objDataSetUser,"User"].Count>0)&
				(MessageBox.Show("真的要删除此记录吗","确定删除",MessageBoxButtons.OKCancel,MessageBoxIcon.Question).Equals(DialogResult.OK)))
			{
				try
				{
					int currentPosition=this.BindingContext[this.objDataSetUser,"User"].Position;
					this.objDataSetUser.User.Rows[currentPosition].Delete();
				}
				catch(System.Exception E)
				{
					this.ErrorHandle(E);
				}
				this.ButtonPositonChange();
				this.DatasetPostionChange();
			}
			else
				return;
		}

		
		private void btnModify_Click(object sender, System.EventArgs e)
		{
			this.TextEnableControl(true);
			this.ButtonEnableControl(true);
		
		}

		private void btnQuery_Click(object sender, System.EventArgs e)
		{

		
		}
		
		public void UpdateDataSet()
		{
			this.BindingContext[this.objDataSetUser,"User"].EndCurrentEdit();
			DataSetUser objDataSetTemp=new DataSetUser();
			objDataSetTemp=(DataSetUser)(this.objDataSetUser.GetChanges());
			try
			{
				this.UpdateDataSource(objDataSetTemp);
				this.objDataSetUser.Merge(objDataSetTemp);
				this.objDataSetUser.AcceptChanges();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		}
		

		public void UpdateDataSource(DataSetUser Changerows)
		{
			try
			{
				this.sqlConnection1.Open();
				this.sqlDataAdapter1.Update(Changerows);
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			finally
			{
				this.sqlConnection1.Close();

			}	
		}

		private void btnApply_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.UpdateDataSet();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}			
			this.ButtonPositonChange();
			this.DatasetPostionChange();
			this.TextEnableControl(false);
			this.ButtonEnableControl(false);
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.BindingContext[this.objDataSetUser,"User"].CancelCurrentEdit();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}			
			this.DatasetPostionChange();
			this.TextEnableControl(false);
			this.TextEnableControl(false);
			this.ButtonEnableControl(false);
			
		}

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


	}
}