book.cs

Csharp SQL图书馆管理系统 Csharp SQL图书馆管理系统源码

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



		private void TextEnableControl(bool valid)
		{
			if(valid)
			{
				this.textId.Enabled=true;
				this.textName.Enabled=true;
				this.textPrice.Enabled=true;
				this.textPublish.Enabled=true;				
				this.textPublishDate.Enabled=true;
				this.textWriter.Enabled=true;
				this.textSort.Enabled=true;
				this.textAmount.Enabled=true;
				this.textRemain.Enabled=true;				
				
			}
			else
			{
				this.textId.Enabled=false;
				this.textName.Enabled=false;								
				this.textPrice.Enabled=false;
				this.textPublish.Enabled=false;				
				this.textPublishDate.Enabled=false;
				this.textWriter.Enabled=false;
				this.textSort.Enabled=false;
				this.textAmount.Enabled=false;
				this.textRemain.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(string sqlQuery)
		{
			DataSetBook objDataSetTemp=new DataSetBook();
			try
			{
				this.FillDataSet(objDataSetTemp,sqlQuery);

			}
			catch (System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			try
			{
				this.objDataSetBook.Clear();
				this.objDataSetBook.Merge(objDataSetTemp);
			}
			catch(System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			
		}
		
	
		private void FillDataSet(DataSetBook dataset,string sqlQuery)
		{
			dataset.EnforceConstraints=false;
			try
			{
				da.SelectCommand.CommandText=sqlQuery;
				conn.Open();
				da.Fill(dataset);
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		
			finally
			{
				dataset.EnforceConstraints=true;
				conn.Close();
			}
		}

		private void Book_Load(object sender, System.EventArgs e)
		{
			
			if(this.userSort!="reader")
			{
				if( this.sqlQuery!="")
				{
					this.LoadDataSet(sqlQuery);
					this.TextEnableControl(true);
					this.ButtonEnableControl(true);
				}
				else
				{
					addnewBook();
				}
			}
			
			else
			{
				this.LoadDataSet(sqlQuery);
				this.TextEnableControl(false);
				this.ButtonEnableControl(false);
			}

		}
		
		

		private void addnewBook()
		{
		
		try
			{
				this.BindingContext[this.objDataSetBook,"Book"].AddNew();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			this.TextEnableControl(true);
			this.ButtonEnableControl(true);
		
		}


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

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

		public void UpdateDataSource(DataSetBook Changerows)
		{
			try
			{
				conn.Open();
				da.Update(Changerows);
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			finally
			{
				conn.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.objDataSetBook,"Book"].CancelCurrentEdit();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}			

			this.TextEnableControl(false);
			this.TextEnableControl(false);
			this.ButtonEnableControl(false);
			
		}

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

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

	}
}