sale.cs

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

			this.label2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label2.Location = new System.Drawing.Point(16, 224);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(72, 23);
			this.label2.TabIndex = 1;
			this.label2.Text = "商品名称";
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.Location = new System.Drawing.Point(16, 184);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(72, 23);
			this.label1.TabIndex = 0;
			this.label1.Text = "商品编号";
			// 
			// btnAdd
			// 
			this.btnAdd.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnAdd.Location = new System.Drawing.Point(10, 362);
			this.btnAdd.Name = "btnAdd";
			this.btnAdd.Size = new System.Drawing.Size(56, 24);
			this.btnAdd.TabIndex = 40;
			this.btnAdd.Text = "添加";
			this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
			// 
			// btnDelete
			// 
			this.btnDelete.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnDelete.Location = new System.Drawing.Point(98, 362);
			this.btnDelete.Name = "btnDelete";
			this.btnDelete.Size = new System.Drawing.Size(56, 24);
			this.btnDelete.TabIndex = 41;
			this.btnDelete.Text = "删除";
			this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
			// 
			// btnQuery
			// 
			this.btnQuery.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnQuery.Location = new System.Drawing.Point(178, 362);
			this.btnQuery.Name = "btnQuery";
			this.btnQuery.Size = new System.Drawing.Size(56, 24);
			this.btnQuery.TabIndex = 42;
			this.btnQuery.Text = "查询";
			this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
			// 
			// btnModify
			// 
			this.btnModify.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnModify.Location = new System.Drawing.Point(266, 362);
			this.btnModify.Name = "btnModify";
			this.btnModify.Size = new System.Drawing.Size(56, 24);
			this.btnModify.TabIndex = 43;
			this.btnModify.Text = "修改";
			this.btnModify.Click += new System.EventHandler(this.btnModify_Click);
			// 
			// btnPrint
			// 
			this.btnPrint.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnPrint.Location = new System.Drawing.Point(354, 362);
			this.btnPrint.Name = "btnPrint";
			this.btnPrint.Size = new System.Drawing.Size(56, 24);
			this.btnPrint.TabIndex = 44;
			this.btnPrint.Text = "报表";
			// 
			// btnExit
			// 
			this.btnExit.Location = new System.Drawing.Point(534, 373);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(72, 24);
			this.btnExit.TabIndex = 45;
			this.btnExit.Text = "退出";
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// btnCancel
			// 
			this.btnCancel.Location = new System.Drawing.Point(438, 346);
			this.btnCancel.Name = "btnCancel";
			this.btnCancel.Size = new System.Drawing.Size(72, 24);
			this.btnCancel.TabIndex = 46;
			this.btnCancel.Text = "取消";
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			// 
			// Sale
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(616, 429);
			this.Controls.Add(this.btnApply);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.btnAdd);
			this.Controls.Add(this.btnDelete);
			this.Controls.Add(this.btnQuery);
			this.Controls.Add(this.btnModify);
			this.Controls.Add(this.btnPrint);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.btnCancel);
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "Sale";
			this.Text = "销售信息管理";
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			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.objDataSetSale,"Sale"].Position==0)
			{
				this.btnFirst.Enabled=false;
				this.btnPrevious.Enabled=false;
			}
			if(this.BindingContext[this.objDataSetSale,"Sale"].Position==this.BindingContext[this.objDataSetSale,"Sale"].Count-1)
			{
				this.btnNext.Enabled=false;
				this.btnLast.Enabled=false;
			}
		}
		
		private void DatasetPostionChange()
		{
			this.lblDatasetPosition.Text=(this.BindingContext[this.objDataSetSale,"Sale"].Position+1)+"的"+
				(this.BindingContext[this.objDataSetSale,"Sale"].Count);
		}

		private void TextEnableControl(bool valid)
		{
			if(valid)
			{
				this.textSaleId.Enabled=true;
				this.textClientId.Enabled=true;
				this.textProductId.Enabled=true;
				this.textProductName.Enabled=true;
				this.textClientName.Enabled=true;												
				this.textProductSpecity.Enabled=true;
				this.textProductUnit.Enabled=true;				
				this.textSaleAmount.Enabled=true;
				this.textSaleDate.Enabled=true;;				
				this.textSaleRemark.Enabled=true;
				this.textSalePrice.Enabled=true;
				
			}
			else
			{
				this.textSaleId.Enabled=false;
				this.textClientId.Enabled=false;
				this.textProductId.Enabled=false;
				this.textProductName.Enabled=false;
				this.textClientName.Enabled=false;												
				this.textProductSpecity.Enabled=false;
				this.textProductUnit.Enabled=false;				
				this.textSaleAmount.Enabled=false;
				this.textSaleDate.Enabled=false;				
				this.textSaleRemark.Enabled=false;
				this.textSalePrice.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()
		{
			DataSetSale objDataSetTemp=new DataSetSale();
			try
			{
				this.FillDataSet(objDataSetTemp);

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

		private void Sale_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.objDataSetSale,"Sale"].Position+=1;
			this.ButtonPositonChange();
			this.DatasetPostionChange();

		}
		

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

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

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

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.BindingContext[this.objDataSetSale,"Sale"].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.objDataSetSale,"Sale"].Count>0)&
				(MessageBox.Show("真的要删除此记录吗","确定删除",MessageBoxButtons.OKCancel,MessageBoxIcon.Question).Equals(DialogResult.OK)))
			{
				try
				{
					int currentPosition=this.BindingContext[this.objDataSetSale,"Sale"].Position;
					this.objDataSetSale.Sale.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.objDataSetSale,"Sale"].EndCurrentEdit();
			DataSetSale objDataSetTemp=new DataSetSale();
			objDataSetTemp=(DataSetSale)(this.objDataSetSale.GetChanges());
			try
			{
				this.UpdateDataSource(objDataSetTemp);
				this.objDataSetSale.Merge(objDataSetTemp);
				this.objDataSetSale.AcceptChanges();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		}
		

		public void UpdateDataSource(DataSetSale Changerows)
		{
			try
			{
				this.sqlConnection1.Open();
				this.sqlDataAdapterSale.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.objDataSetSale,"Sale"].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();
		}	


	}
}