procheck.cs

企业管理系统

			this.Controls.Add(this.btnApply);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.btnCancel);
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.Name = "ProCheck";
			this.Text = "商品盘点";
			this.Load += new System.EventHandler(this.ProStock_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.objDataSetProStock)).EndInit();
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

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

		private void TextEnableControl(bool valid)
		{
			if(valid)
			{				
				this.textProID.Enabled=true;
				this.textProName.Enabled=true;
				this.comboUnit.Enabled=true;
				this.textProNumber.Enabled=true;																				
				this.textRemark.Enabled=true;
				
			}
			else
			{
				this.textProID.Enabled=false;
				this.textProName.Enabled=false;
				this.comboUnit.Enabled=false;
				this.textProNumber.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()
		{
			DataSetProStock objDataSetTemp=new DataSetProStock();
			try
			{
				this.FillDataSet(objDataSetTemp);

			}
			catch (System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			try
			{
				this.objDataSetProStock.Clear();
				this.objDataSetProStock.Merge(objDataSetTemp);
			}
			catch(System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			
		}
		
		private void FillDataSet(DataSetProStock 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 ProStock_Load(object sender, System.EventArgs e)
		{
			this.LoadDataSet();				
			this.TextEnableControl(false);
			this.ButtonEnableControl(false);			
			//SqlCommandBuilder sd=new SqlCommandBuilder(this.sqlDataAdapter1);
		
		}
				

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

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

	
		public void UpdateDataSet()
		{
			this.BindingContext[this.objDataSetProStock,"ProStock"].EndCurrentEdit();
			DataSetProStock objDataSetTemp=new DataSetProStock();
			objDataSetTemp=(DataSetProStock)(this.objDataSetProStock.GetChanges());
			try
			{
				this.UpdateDataSource(objDataSetTemp);
				this.objDataSetProStock.Merge(objDataSetTemp);
				this.objDataSetProStock.AcceptChanges();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			this.dataGrid1.Refresh();
		}
		

		public void UpdateDataSource(DataSetProStock 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.TextEnableControl(false);
			this.ButtonEnableControl(false);
		}

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

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

	}
}