reward.cs

主要介绍了系统的需求分析

			{
				MessageBox.Show(E.ToString());
			}			

		}

		private void lblRecord_Change()
		{
			int position=this.BindingContext[this.DataSetReward,"Reward"].Position+1;
			int count=this.BindingContext[this.DataSetReward,"Reward"].Count;
			lblRecord.Text=position+"/"+count+"条记录";

		}
		private void Combo_Fill()
		{  			
			try
			{
				if(this.Connection1.State==ConnectionState.Closed)
					this.Connection1.Open();						
				this.commandStr="select * from RewardType";									
				this.Command1.CommandText=this.commandStr;
				this.DataReader1=this.Command1.ExecuteReader();
				while(this.DataReader1.Read())
				{
					this.comboRewardType.Items.Add(this.DataReader1[1].ToString());
					this.comboRewardType2.Items.Add(this.DataReader1[1].ToString());
				}					
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			finally
			{
				this.DataReader1.Close();
				this.Connection1.Close();
			}
		}

		private void btnApply_Click(object sender, System.EventArgs e)
		{				
			try
			{
				if(this.Connection1.State==ConnectionState.Closed)
					this.Connection1.Open();
				this.BindingContext[this.DataSetReward,"Reward"].EndCurrentEdit();
				OleDbCommandBuilder commandbuilder1=new OleDbCommandBuilder(this.dataAdapter1);				
				this.dataAdapter1.Update(this.DataSetReward,"Reward");				
				this.DataSetReward.AcceptChanges();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			finally
			{			
				this.Connection1.Close();
			}			
			this.Buttons_Control(false);			
		}

		private void btnNext_Click(object sender, System.EventArgs e)
		{
			int position=this.BindingContext[this.DataSetReward,"Reward"].Position;
			int count=this.BindingContext[this.DataSetReward,"Reward"].Count;
			if(position>=count-1)
			{
				this.BindingContext[this.DataSetReward,"Reward"].Position=0;

			}
			else
			{
				this.BindingContext[this.DataSetReward,"Reward"].Position+=1;
			}	
			this.lblRecord_Change();
			
		}

		private void btnLast_Click(object sender, System.EventArgs e)
		{
			
			this.BindingContext[this.DataSetReward,"Reward"].Position=this.BindingContext[this.DataSetReward,"Reward"].Count-1;
			this.lblRecord_Change();
		}

		private void btnFirst_Click(object sender, System.EventArgs e)
		{
			this.BindingContext[this.DataSetReward,"Reward"].Position=0;
			this.lblRecord_Change();
		
		}

		private void btnPrevious_Click(object sender, System.EventArgs e)
		{
			int position=this.BindingContext[this.DataSetReward,"Reward"].Position;
			int count=this.BindingContext[this.DataSetReward,"Reward"].Count;
			if(position==0)
			{
				this.BindingContext[this.DataSetReward,"Reward"].Position=count-1;

			}
			else
			{
				this.BindingContext[this.DataSetReward,"Reward"].Position-=1;
			}
			this.lblRecord_Change();
		}

		private void btnDelete_Click(object sender, System.EventArgs e)
		{
			if((this.BindingContext[this.DataSetReward,"Reward"].Count>0)&
				(MessageBox.Show("真的要删除此记录吗","确定删除",MessageBoxButtons.OKCancel,MessageBoxIcon.Question).Equals(DialogResult.OK)))
			{
				try
				{					
					int position=this.BindingContext[this.DataSetReward,"Reward"].Position;
					this.BindingContext[this.DataSetReward,"Reward"].RemoveAt(position);					
					this.BindingContext[this.DataSetReward,"Reward"].EndCurrentEdit();			
					if(this.Connection1.State==ConnectionState.Closed)
						this.Connection1.Open();
					OleDbCommandBuilder commandbuilder1=new OleDbCommandBuilder(this.dataAdapter1);					
					this.dataAdapter1.Update(this.DataSetReward,"Reward");
					this.DataSetReward.AcceptChanges();
					
				}
				catch(System.Exception E)
				{
					this.ErrorHandle(E);
				}
				finally
				{			
					this.Connection1.Close();
				}			
				this.Buttons_Control(false);				
				this.lblRecord_Change();
			}
			else
				return;		
			
		}
		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			this.Buttons_Control(true);			
			this.BindingContext[this.DataSetReward,"Reward"].AddNew();				
		
		}
		public void ErrorHandle(System.Exception E)
		{
			MessageBox.Show(E.ToString());
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.BindingContext[this.DataSetReward,"Reward"].CancelCurrentEdit();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			this.Buttons_Control(false);
		}
		private void Buttons_Control(bool IsValid)
		{
			if(IsValid)
			{
				this.btnCancel.Enabled=true;
				this.btnApply.Enabled=true;								
				this.dateTimePicker1.Enabled=true;
				this.textEmployeeID.Enabled=true;
				this.comboRewardType.Enabled=true;	
				this.textRemark.Enabled=true;
				
			}
			else
			{
				this.btnCancel.Enabled=false;
				this.btnApply.Enabled=false;								
				this.dateTimePicker1.Enabled=false;	
				this.textEmployeeID.Enabled=false;
				this.comboRewardType.Enabled=false;			
				this.textRemark.Enabled=false;
				

			}

		}

		private void btnModify_Click(object sender, System.EventArgs e)
		{			
			this.Buttons_Control(true);			
			
		}

		private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e)
		{
			this.lblRecord_Change();
		}		

		private void btnRewardCancel_Click(object sender, System.EventArgs e)
		{
			this.textEmployeeID2.Text="";
			this.comboRewardType2.Text="";
		
		}		

		private void btnRewardSearch_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.Connection1.Open();					
				this.DataViewReward.Table=this.DataSetViewReward.Tables["View_Reward"];
				this.DataViewReward.RowFilter=this.RewardStr_Made();
				this.dataGrid2.DataSource=this.DataViewReward;				
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			finally
			{
				this.Connection1.Close();
			}
			if(this.DataViewReward.Count==0)
				MessageBox.Show("没有符合查询条件的记录","没有记录",MessageBoxButtons.OK,MessageBoxIcon.Information);			
			this.textEmployeeID2.Clear();
			this.comboRewardType2.Text="";
		
		}
		private string RewardStr_Made()
		{
			string searchStr=null;
			bool first=true;

			if(this.textEmployeeID2.Text!="")
			{				
				searchStr="EmployeeID="+"'"+this.textEmployeeID2.Text+"'";
				first=false;

			}
			if(this.comboRewardType2.Text!="")
			{
				if(first)
				{
					searchStr="RewardType="+"'"+this.comboRewardType2.Text+"'";
					first=false;
				}
				else
				{
					searchStr=searchStr+" and RewardType="+"'"+this.comboRewardType2.Text+"'";
				}

			}
			if(this.checkBox1.Checked)
			{
				if(first)
				{
					searchStr="Date>"+"'"+this.dateTimePicker3.Text+"'"+" and "+"Date<"+"'"+this.dateTimePicker4.Text+"'" ;					
					this.selectStr="日期：在"+this.dateTimePicker3.Text+"和"+this.dateTimePicker4.Text+"之间";
				}

				else
				{
					searchStr=searchStr+" and (Date>"+"'"+this.dateTimePicker3.Text+"'"+" and "+"Date<"+"'"+this.dateTimePicker4.Text+"')";
					this.selectStr+=" 日期：在"+this.dateTimePicker3.Text+"和"+this.dateTimePicker4.Text+"之间";
				}
			
			}
			return searchStr;
		}

		private void tabControl1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(this.tabControl1.TabIndex==1)
			{
				this.DataSetViewReward.Clear();
				this.dataAdapter2.Fill(this.DataSetViewReward,"View_Reward");
			}
		}

		

		private void btnRewardExport_Click(object sender, System.EventArgs e)
		{
			Excel.Application myExcel = new Excel.Application ( ) ;
			myExcel.Application.Workbooks.Add ( true ) ;
			//让Excel文件可见
			myExcel.Visible=true;
			//第一行为报表名称
			myExcel.Cells[1,3]="奖惩查询";
			myExcel.Cells[2,4]="'"+System.DateTime.Now.ToString();
			//逐行写入数据，
			for(int j=0;j<6;j++)
			{
				myExcel.Cells[3,1+j]=this.ListHeader[j];

			}			
			this.Connection1.Open();									
			for(int i=0;i<this.DataViewReward.Count;i++)
			{
				for(int j=0;j<6;j++)
				{
					//以单引号开头，表示该单元格为纯文本
					myExcel.Cells[5+i,1+j]="'"+this.DataViewReward[i][j];
				}
			}	
		
		}

		private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
		{
			if(this.checkBox1.Checked)
			{
				this.dateTimePicker3.Enabled=true;
				this.dateTimePicker4.Enabled=true;
			}
			else
			{
				this.dateTimePicker3.Enabled=false;
				this.dateTimePicker4.Enabled=false;
			}
		}
	}
}