probuy.cs

人事/工资/考勤管理系统广泛应用于工业、商业、企业、行政等单位

				this.textProBuyID.Enabled=true;
				this.textProID.Enabled=true;				
				this.textProviderID.Enabled=true;				
				this.combUnit.Enabled=true;
				this.textProNumber.Enabled=true;
				this.textProPrice.Enabled=true;												
				this.dateTimePicker1.Enabled=true;
				this.textPeople.Enabled=true;								
				this.textRemark.Enabled=true;
				
			}
			else
			{
				this.textProBuyID.Enabled=false;
				this.textProID.Enabled=false;
				this.textProName.Enabled=false;
				this.textProviderID.Enabled=false;
				this.textProviderName.Enabled=false;
				this.combUnit.Enabled=false;
				this.textProNumber.Enabled=false;
				this.textProPrice.Enabled=false;												
				this.dateTimePicker1.Enabled=false;
				this.textPeople.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()
		{
			DataSetProBuy objDataSetTemp=new DataSetProBuy();
			try
			{
				this.FillDataSet(objDataSetTemp);

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

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.BindingContext[this.objDataSetProBuy,"ProBuy"].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.objDataSetProBuy,"ProBuy"].Count>0)&
				(MessageBox.Show("真的要删除此记录吗","确定删除",MessageBoxButtons.OKCancel,MessageBoxIcon.Question).Equals(DialogResult.OK)))
			{
				try
				{
					int currentPosition=this.BindingContext[this.objDataSetProBuy,"ProBuy"].Position;
					this.objDataSetProBuy.ProBuy.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);
		
		}

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

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

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

			}	
		}
		

		void ModifyProStock()
		{
			SqlCommand ProBuy=new SqlCommand();
			ProBuy.Connection=this.sqlConnection1;
			ProBuy.CommandType=CommandType.StoredProcedure;
			ProBuy.CommandText="dbo.StoredProcedureProBuy";
			SqlParameter parinput=ProBuy.Parameters.Add("@ProID",SqlDbType.Char);
			parinput.Direction=ParameterDirection.Input;
			parinput.Value=this.textProID.Text;
			parinput=ProBuy.Parameters.Add("@BuyNumber",
				SqlDbType.Int);			;
			parinput.Value=this.textProNumber.Text;
			try
			{
				this.sqlConnection1.Open();	
				ProBuy.ExecuteNonQuery();
				this.sqlConnection1.Close();				
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}	
		}		
		private void btnApply_Click(object sender, System.EventArgs e)
		{
			string proID=this.textProID.Text;
			string providerID=this.textProviderID.Text;
			int proNumber=Convert.ToInt16(this.textProNumber.Text);										
			this.textProName.Text=addName.AddProductName(proID);//填充商品名称
			this.textProviderName.Text=addName.AddProviderName(providerID);	//填充供应商名称
			modifyProStock.AddProStock(proID,proNumber);//修改商品库存
			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.objDataSetProBuy,"ProBuy"].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();
		}

	}
}