provider.cs

企业管理系统

				this.textPeople.Enabled=false;
				this.textTelNo.Enabled=false;
				//this.textFaxNo.Enabled=false;
				this.textAddress.Enabled=false;
				this.textPostalCode.Enabled=false;
				//this.textWebSite.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()
		{
			DataSetProvider objDataSetTemp=new DataSetProvider();
			try
			{
				this.FillDataSet(objDataSetTemp);

			}
			catch (System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			try
			{
				this.objDataSetProvider.Clear();
				this.objDataSetProvider.Merge(objDataSetTemp);
			}
			catch(System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			
		}
		
		private void FillDataSet(DataSetProvider 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 Provider_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.objDataSetProvider,"Provider"].Position+=1;
			this.ButtonPositonChange();
			this.DatasetPostionChange();

		}
		

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

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

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

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.BindingContext[this.objDataSetProvider,"Provider"].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.objDataSetProvider,"Provider"].Count>0)&
		    (MessageBox.Show("真的要删除此记录吗","确定删除",MessageBoxButtons.OKCancel,MessageBoxIcon.Question).Equals(DialogResult.OK)))
            {
                 try
				 {
                      int currentPosition=this.BindingContext[this.objDataSetProvider,"Provider"].Position;
					  this.objDataSetProvider.Provider.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)
		{
			string queryString="SELECT Number, Name, People, TelNo, FaxNo, WebSite, Address, PostalCode, Remark F" +
				"ROM Provider";
			if(this.rbtnId.Checked)
			{
				queryString=queryString+" where Number="+(string)this.textId.Text;
			}
			else if(this.rbtnName.Checked)
			{
                queryString=queryString+" where Name="+(string)this.textName.Text;
			}

			this.sqlSelectCommand1.CommandText=queryString;
			this.LoadDataSet();			
		
		}*/
		
		public void UpdateDataSet()
		{
			this.BindingContext[this.objDataSetProvider,"Provider"].EndCurrentEdit();
			DataSetProvider objDataSetTemp=new DataSetProvider();
			objDataSetTemp=(DataSetProvider)(this.objDataSetProvider.GetChanges());
			try
			{
				this.UpdateDataSource(objDataSetTemp);
				this.objDataSetProvider.Merge(objDataSetTemp);
				this.objDataSetProvider.AcceptChanges();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		}
		

		public void UpdateDataSource(DataSetProvider 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.objDataSetProvider,"Provider"].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();
		}

		/*private void rbtnName_CheckedChanged(object sender, System.EventArgs e)
		{
			
			if(this.rbtnName.Checked)
			{
				this.textName.Enabled=true;
				this.textId.Enabled=false;
			}						

		
		}*/

		/*private void rbtnId_CheckedChanged(object sender, System.EventArgs e)
		{
			if(this.rbtnId.Checked)
			{
				this.textId.Enabled=true;
				this.textName.Enabled=false;
			}
		
		}*/

		
	}
}