reward.cs

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

			this.dataGrid1.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
			this.dataGrid1.HeaderForeColor = System.Drawing.Color.Lavender;
			this.dataGrid1.LinkColor = System.Drawing.Color.Teal;
			this.dataGrid1.Location = new System.Drawing.Point(16, 184);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.ParentRowsBackColor = System.Drawing.Color.Lavender;
			this.dataGrid1.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid1.ReadOnly = true;
			this.dataGrid1.SelectionBackColor = System.Drawing.Color.Teal;
			this.dataGrid1.SelectionForeColor = System.Drawing.Color.PaleGreen;
			this.dataGrid1.Size = new System.Drawing.Size(416, 240);
			this.dataGrid1.TabIndex = 1;
			// 
			// btnApply
			// 
			this.btnApply.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnApply.Image = ((System.Drawing.Image)(resources.GetObject("btnApply.Image")));
			this.btnApply.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnApply.Location = new System.Drawing.Point(504, 248);
			this.btnApply.Name = "btnApply";
			this.btnApply.Size = new System.Drawing.Size(56, 24);
			this.btnApply.TabIndex = 106;
			this.btnApply.Text = "保存";
			this.btnApply.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
			// 
			// btnCancel
			// 
			this.btnCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnCancel.Image")));
			this.btnCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnCancel.Location = new System.Drawing.Point(504, 216);
			this.btnCancel.Name = "btnCancel";
			this.btnCancel.Size = new System.Drawing.Size(56, 24);
			this.btnCancel.TabIndex = 96;
			this.btnCancel.Text = "取消";
			this.btnCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			// 
			// btnLast
			// 
			this.btnLast.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnLast.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnLast.Location = new System.Drawing.Point(336, 144);
			this.btnLast.Name = "btnLast";
			this.btnLast.Size = new System.Drawing.Size(64, 24);
			this.btnLast.TabIndex = 92;
			this.btnLast.Text = "最后一条";
			this.btnLast.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnLast.Click += new System.EventHandler(this.btnLast_Click);
			// 
			// btnFirst
			// 
			this.btnFirst.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnFirst.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnFirst.Location = new System.Drawing.Point(24, 144);
			this.btnFirst.Name = "btnFirst";
			this.btnFirst.Size = new System.Drawing.Size(56, 24);
			this.btnFirst.TabIndex = 95;
			this.btnFirst.Text = "第一条";
			this.btnFirst.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
			// 
			// lblRecord
			// 
			this.lblRecord.BackColor = System.Drawing.SystemColors.Window;
			this.lblRecord.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.lblRecord.ForeColor = System.Drawing.SystemColors.Desktop;
			this.lblRecord.Location = new System.Drawing.Point(152, 144);
			this.lblRecord.Name = "lblRecord";
			this.lblRecord.Size = new System.Drawing.Size(112, 23);
			this.lblRecord.TabIndex = 96;
			this.lblRecord.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// btnPrevious
			// 
			this.btnPrevious.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnPrevious.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnPrevious.Location = new System.Drawing.Point(88, 144);
			this.btnPrevious.Name = "btnPrevious";
			this.btnPrevious.Size = new System.Drawing.Size(56, 24);
			this.btnPrevious.TabIndex = 94;
			this.btnPrevious.Text = "上一条";
			this.btnPrevious.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnPrevious.Click += new System.EventHandler(this.btnPrevious_Click);
			// 
			// btnNext
			// 
			this.btnNext.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnNext.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnNext.Location = new System.Drawing.Point(272, 144);
			this.btnNext.Name = "btnNext";
			this.btnNext.Size = new System.Drawing.Size(56, 24);
			this.btnNext.TabIndex = 93;
			this.btnNext.Text = "下一条";
			this.btnNext.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnNext.Click += new System.EventHandler(this.btnLast_Click);
			// 
			// tabPage2
			// 
			this.tabPage2.Controls.Add(this.groupBox1);
			this.tabPage2.Controls.Add(this.btnRewardCancel);
			this.tabPage2.Controls.Add(this.btnRewardSearch);
			this.tabPage2.Controls.Add(this.btnRewardExport);
			this.tabPage2.Controls.Add(this.dataGrid2);
			this.tabPage2.Location = new System.Drawing.Point(4, 21);
			this.tabPage2.Name = "tabPage2";
			this.tabPage2.Size = new System.Drawing.Size(608, 439);
			this.tabPage2.TabIndex = 1;
			this.tabPage2.Text = "惩罚记录查询";
			this.tabPage2.Visible = false;
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.checkBox1);
			this.groupBox1.Controls.Add(this.dateTimePicker3);
			this.groupBox1.Controls.Add(this.dateTimePicker4);
			this.groupBox1.Controls.Add(this.label3);
			this.groupBox1.Controls.Add(this.label11);
			this.groupBox1.Controls.Add(this.label4);
			this.groupBox1.Controls.Add(this.label5);
			this.groupBox1.Controls.Add(this.comboRewardType2);
			this.groupBox1.Controls.Add(this.textEmployeeID2);
			this.groupBox1.Location = new System.Drawing.Point(8, 16);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(320, 112);
			this.groupBox1.TabIndex = 109;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "奖惩记录";
			// 
			// checkBox1
			// 
			this.checkBox1.Location = new System.Drawing.Point(16, 80);
			this.checkBox1.Name = "checkBox1";
			this.checkBox1.Size = new System.Drawing.Size(64, 24);
			this.checkBox1.TabIndex = 40;
			this.checkBox1.Text = "按时间";
			// 
			// dateTimePicker3
			// 
			this.dateTimePicker3.Enabled = false;
			this.dateTimePicker3.Format = System.Windows.Forms.DateTimePickerFormat.Short;
			this.dateTimePicker3.Location = new System.Drawing.Point(88, 80);
			this.dateTimePicker3.Name = "dateTimePicker3";
			this.dateTimePicker3.Size = new System.Drawing.Size(88, 21);
			this.dateTimePicker3.TabIndex = 37;
			this.dateTimePicker3.Value = new System.DateTime(2003, 12, 20, 0, 0, 0, 0);
			// 
			// dateTimePicker4
			// 
			this.dateTimePicker4.Enabled = false;
			this.dateTimePicker4.Format = System.Windows.Forms.DateTimePickerFormat.Short;
			this.dateTimePicker4.Location = new System.Drawing.Point(192, 80);
			this.dateTimePicker4.Name = "dateTimePicker4";
			this.dateTimePicker4.Size = new System.Drawing.Size(88, 21);
			this.dateTimePicker4.TabIndex = 36;
			this.dateTimePicker4.Value = new System.DateTime(2003, 12, 20, 0, 0, 0, 0);
			// 
			// label3
			// 
			this.label3.Location = new System.Drawing.Point(208, 56);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(56, 23);
			this.label3.TabIndex = 39;
			this.label3.Text = "截至日期";
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(104, 56);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(64, 23);
			this.label11.TabIndex = 38;
			this.label11.Text = "起始日期";
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(8, 32);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(48, 23);
			this.label4.TabIndex = 28;
			this.label4.Text = "职工号";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(120, 24);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(56, 23);
			this.label5.TabIndex = 34;
			this.label5.Text = "奖惩类型";
			// 
			// comboRewardType2
			// 
			this.comboRewardType2.ItemHeight = 12;
			this.comboRewardType2.Location = new System.Drawing.Point(176, 24);
			this.comboRewardType2.Name = "comboRewardType2";
			this.comboRewardType2.Size = new System.Drawing.Size(80, 20);
			this.comboRewardType2.TabIndex = 35;
			// 
			// textEmployeeID2
			// 
			this.textEmployeeID2.Location = new System.Drawing.Point(56, 24);
			this.textEmployeeID2.Name = "textEmployeeID2";
			this.textEmployeeID2.Size = new System.Drawing.Size(56, 21);
			this.textEmployeeID2.TabIndex = 29;
			this.textEmployeeID2.Text = "";
			// 
			// btnRewardCancel
			// 
			this.btnRewardCancel.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnRewardCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnRewardCancel.Image")));
			this.btnRewardCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnRewardCancel.Location = new System.Drawing.Point(440, 32);
			this.btnRewardCancel.Name = "btnRewardCancel";
			this.btnRewardCancel.Size = new System.Drawing.Size(56, 24);
			this.btnRewardCancel.TabIndex = 108;
			this.btnRewardCancel.Text = "取消";
			this.btnRewardCancel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// btnRewardSearch
			// 
			this.btnRewardSearch.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnRewardSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnRewardSearch.Image")));
			this.btnRewardSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnRewardSearch.Location = new System.Drawing.Point(440, 64);
			this.btnRewardSearch.Name = "btnRewardSearch";
			this.btnRewardSearch.Size = new System.Drawing.Size(56, 24);
			this.btnRewardSearch.TabIndex = 107;
			this.btnRewardSearch.Text = "查找";
			this.btnRewardSearch.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// btnRewardExport
			// 
			this.btnRewardExport.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnRewardExport.Image = ((System.Drawing.Image)(resources.GetObject("btnRewardExport.Image")));
			this.btnRewardExport.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnRewardExport.Location = new System.Drawing.Point(512, 32);
			this.btnRewardExport.Name = "btnRewardExport";
			this.btnRewardExport.Size = new System.Drawing.Size(56, 24);
			this.btnRewardExport.TabIndex = 106;
			this.btnRewardExport.Text = "导出";
			this.btnRewardExport.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// dataGrid2
			// 
			this.dataGrid2.AlternatingBackColor = System.Drawing.Color.GhostWhite;
			this.dataGrid2.BackColor = System.Drawing.Color.GhostWhite;
			this.dataGrid2.BackgroundColor = System.Drawing.Color.Lavender;
			this.dataGrid2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.dataGrid2.CaptionBackColor = System.Drawing.Color.RoyalBlue;
			this.dataGrid2.CaptionForeColor = System.Drawing.Color.White;
			this.dataGrid2.DataMember = "";
			this.dataGrid2.FlatMode = true;
			this.dataGrid2.Font = new System.Drawing.Font("Tahoma", 8F);
			this.dataGrid2.ForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid2.GridLineColor = System.Drawing.Color.RoyalBlue;
			this.dataGrid2.HeaderBackColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid2.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
			this.dataGrid2.HeaderForeColor = System.Drawing.Color.Lavender;
			this.dataGrid2.LinkColor = System.Drawing.Color.Teal;
			this.dataGrid2.Location = new System.Drawing.Point(16, 144);
			this.dataGrid2.Name = "dataGrid2";
			this.dataGrid2.ParentRowsBackColor = System.Drawing.Color.Lavender;
			this.dataGrid2.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
			this.dataGrid2.SelectionBackColor = System.Drawing.Color.Teal;
			this.dataGrid2.SelectionForeColor = System.Drawing.Color.PaleGreen;
			this.dataGrid2.Size = new System.Drawing.Size(496, 264);
			this.dataGrid2.TabIndex = 0;
			// 
			// Reward
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(672, 525);
			this.Controls.Add(this.tabControl1);
			this.Name = "Reward";
			this.Text = "Reward";
			this.Load += new System.EventHandler(this.Reward_Load);
			this.tabControl1.ResumeLayout(false);
			this.tabPage1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.tabPage2.ResumeLayout(false);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void btnExit_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}
		private void Reward_Load(object sender, System.EventArgs e)
		{
			
			this.DataSet_Binding();
			this.lblRecord_Change();
			this.Buttons_Control(false);
			
		}
		private void DataSet_Binding()
		{
			try
			{
				this.Connection1.Open();
				this.dataAdapter1.Fill(this.DataSetReward,"Reward");				
			}
			catch(Exception E)
			{
				MessageBox.Show(E.ToString());
			}
			finally
			{
				this.Connection1.Close();			
			}			
			this.dataGrid1.DataSource=this.DataSetReward;
			this.dataGrid1.DataMember="Reward";	
			try
			{
				this.textEmployeeID.DataBindings.Add("Text",this.DataSetReward,"Reward.EmployeeID");				
				this.comboRewardType.DataBindings.Add("Text",this.DataSetReward,"Reward.RewardType");
				this.textRemark.DataBindings.Add("Text",this.DataSetReward,"Reward.Remark");
				this.dateTimePicker1.DataBindings.Add("Text",this.DataSetReward,"Reward.Date");			
				this.Combo_Fill();
			}
			catch(Exception E)