frmworkere.cs

小区物业管理:管理小区的费用、小区工作人员的编排和工资管理、小区的运作、对住户资料的管理、房产资源管理、小区事务的管理、对住户的需要管理、停车场管理

			this.txtEID.TabIndex = 16;
			this.txtEID.Text = "";
			// 
			// lblEID
			// 
			this.lblEID.Location = new System.Drawing.Point(0, 8);
			this.lblEID.Name = "lblEID";
			this.lblEID.Size = new System.Drawing.Size(80, 23);
			this.lblEID.TabIndex = 15;
			this.lblEID.Text = "员工编号：";
			// 
			// tabPage2
			// 
			this.tabPage2.Controls.Add(this.btnDEit);
			this.tabPage2.Controls.Add(this.btnDel1);
			this.tabPage2.Controls.Add(this.txtDID);
			this.tabPage2.Controls.Add(this.lblDID);
			this.tabPage2.Location = new System.Drawing.Point(4, 21);
			this.tabPage2.Name = "tabPage2";
			this.tabPage2.Size = new System.Drawing.Size(568, 191);
			this.tabPage2.TabIndex = 1;
			this.tabPage2.Text = "删除员工工资";
			// 
			// btnDEit
			// 
			this.btnDEit.Location = new System.Drawing.Point(376, 16);
			this.btnDEit.Name = "btnDEit";
			this.btnDEit.TabIndex = 6;
			this.btnDEit.Text = "返回";
			this.btnDEit.Click += new System.EventHandler(this.btnDEit_Click);
			// 
			// btnDel1
			// 
			this.btnDel1.Location = new System.Drawing.Point(272, 16);
			this.btnDel1.Name = "btnDel1";
			this.btnDel1.TabIndex = 4;
			this.btnDel1.Text = "删除";
			this.btnDel1.Click += new System.EventHandler(this.btnDel1_Click);
			// 
			// txtDID
			// 
			this.txtDID.Location = new System.Drawing.Point(104, 16);
			this.txtDID.Name = "txtDID";
			this.txtDID.Size = new System.Drawing.Size(144, 21);
			this.txtDID.TabIndex = 1;
			this.txtDID.Text = "";
			// 
			// lblDID
			// 
			this.lblDID.Location = new System.Drawing.Point(24, 16);
			this.lblDID.Name = "lblDID";
			this.lblDID.Size = new System.Drawing.Size(72, 23);
			this.lblDID.TabIndex = 0;
			this.lblDID.Text = "员工编号：";
			// 
			// frmworkerE
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(7, 14);
			this.ClientSize = new System.Drawing.Size(616, 334);
			this.Controls.Add(this.btnPrintprv);
			this.Controls.Add(this.btnPrint);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.btnAdd);
			this.Controls.Add(this.grpfind);
			this.Controls.Add(this.tabControl1);
			this.Controls.Add(this.dbgworker);
			this.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.ForeColor = System.Drawing.SystemColors.ActiveCaption;
			this.Name = "frmworkerE";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "员工工资";
			this.Load += new System.EventHandler(this.frmworker_Load);
			this.grpfind.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dbgworker)).EndInit();
			this.tabControl1.ResumeLayout(false);
			this.tabPage1.ResumeLayout(false);
			this.tabPage2.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>


		private void frmworker_Load(object sender, System.EventArgs e)
		{
			objSqlConnection=new SqlConnection ("database=atorregulate;uid=sa;pwd=;SERVER=(local)");
			objSqlConnection.Open ();
			objSqlDataAdapter=new SqlDataAdapter ();
			objSqlDataAdapter.SelectCommand =new SqlCommand ("select Enumber as 员工编号,Eearnings as 员工工资,Eprizc as 员工奖金,Eremark as 备注 from workerearnings",objSqlConnection);
			//objSqlDataAdapter.SelectCommand =new SqlCommand ("select * from workerearnings",objSqlConnection);
			objDataSet=new DataSet();
			objSqlDataAdapter.Fill (objDataSet,"workerearnings");

			//将DataSet控制定到数据集
			this.dbgworker .SetDataBinding (objDataSet,"workerearnings");
			//dbgworker.DataSource =objDataSet.Tables [0].DefaultView ;

			//定义插入命令
			string insCmd="Insert into workerearnings values (@Enumber,@Eearnings,@Eprizc,@Eremark)";

			//实例化InsertCommand
			this.objSqlDataAdapter .InsertCommand =new SqlCommand (insCmd,this.objSqlConnection );

			//设置插入命令参数
			objParam=objSqlDataAdapter.InsertCommand .Parameters .Add (new SqlParameter  ("@Enumber",System.Data .SqlDbType .Int ));
			objParam.SourceColumn ="员工编号";
			objParam.SourceVersion =DataRowVersion.Current ;
			objParam=objSqlDataAdapter.InsertCommand .Parameters .Add (new System .Data .SqlClient .SqlParameter ("@Eearnings",System.Data .SqlDbType.Money     ));
			objParam.SourceColumn ="员工工资";
			objParam.SourceVersion =DataRowVersion.Current ;
			objParam=objSqlDataAdapter.InsertCommand .Parameters .Add (new System .Data .SqlClient .SqlParameter ("@Eprizc",System.Data .SqlDbType .Money    ));
			objParam.SourceColumn ="员工奖金";
			objParam.SourceVersion =DataRowVersion.Current ;
			objParam=objSqlDataAdapter.InsertCommand .Parameters .Add (new System .Data .SqlClient .SqlParameter ("@Eremark",System.Data .SqlDbType .VarChar   ));
			objParam.SourceColumn ="备注";
			objParam.SourceVersion =DataRowVersion.Current ;
		}

		//验证插入记录的单个控件
		private bool ValidateFields()
		{
			bool returnValue=true;
			//检查有无空的员工编号
			if (this.txtEID  .Text .Trim ()==String.Empty||this.txtEarning  .Text .Trim ()==String.Empty   )
			{
				MessageBox.Show ("提供完整的详细信息","服务器拒绝");
				this.txtEID .Focus ();
				return false;
			}
			else
			{
				for(int i=0;i<this.txtEarning  .Text .Length ;i++)
				{
					if(!Char.IsNumber (txtEarning.Text .ToString (),i))
					{
						MessageBox.Show ("员工工资应为数字","服务器拒绝");
						this.txtEarning  .Focus ();
						returnValue=false;
						break;
					}
				}
				for(int i=0;i<this.txteprizc  .Text .Length ;i++)
				{
					if(!Char.IsNumber (txteprizc.Text .ToString (),i ))
					{
						MessageBox.Show ("员工奖金应为数字","服务器拒绝");
						this.txteprizc  .Focus ();
						returnValue=false;
						break;
					}
			}
				}
			return returnValue;
		}

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
            this.tabControl1 .Visible =true;
			this.btnAdd .Enabled =false;
			this.btnPrint .Enabled =false;
			this.btnPrintprv .Enabled =false;
		}

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


		private void btnRu_Click(object sender, System.EventArgs e)
		{
			this.dbgworker .Enabled =true;
			objSqlDataAdapter.SelectCommand =new SqlCommand ("select Enumber as 员工编号,Eearnings as 员工工资,Eprizc as 员工奖金,Eremark as 备注 from workerearnings ",objSqlConnection);
			objDataSet=new DataSet();
			objSqlDataAdapter.Fill (objDataSet,"workerearnings");
			this.dbgworker .SetDataBinding (objDataSet,"workerearnings");
		}

		private void btnPrint_Click(object sender, System.EventArgs e)
		{
			if(this.printworker .ShowDialog ()==DialogResult.OK )
			{
				this.pdocworker .Print ();
			}
		}

		private void pdocworker_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
		{
			Font objFont=new Font ("Tahoma",11,FontStyle.Regular );
			Brush objBrush=Brushes.Black ;
			Pen objPen=new Pen (objBrush);

			objPen.Width =2;

			int nLeft=this.pageSetupDialog1 .PageSettings .Margins .Left ;
			int nTop=this.pageSetupDialog1 .PageSettings .Margins .Top ;
			int nWidth=this.pageSetupDialog1 .PageSettings .PaperSize .Width -(this.pageSetupDialog1 .PageSettings .Margins .Left +this.pageSetupDialog1 .PageSettings .Margins .Right );
			int nHeight=this.pageSetupDialog1 .PageSettings .PaperSize .Height -(this.pageSetupDialog1 .PageSettings .Margins .Bottom );

			e.Graphics .DrawLine (objPen,nLeft,nTop,nLeft+nWidth,nTop);
			e.Graphics .DrawLine (objPen,nLeft,nTop+nHeight,nLeft+nWidth,nTop+nHeight);
			e.Graphics .DrawLine (objPen,nLeft,nTop,nLeft,nTop+nHeight);
			e.Graphics .DrawLine (objPen,nLeft+nWidth,nTop,nLeft+nWidth,nTop+nHeight);

			e.Graphics.DrawString ("员工工资",new Font ("Garamond",40,FontStyle.Bold ),Brushes.Blue ,nLeft+30,nTop+10);
			e.Graphics.DrawString ("员工编号",objFont,objBrush ,nLeft+20,nTop+60);
			e.Graphics.DrawString ("员工工资",objFont,objBrush ,nLeft+100,nTop+60);
			e.Graphics.DrawString ("员工奖金",objFont,objBrush ,nLeft+200,nTop+60);
			e.Graphics.DrawString ("备注",objFont,objBrush ,nLeft+270,nTop+60);

			try
			{
				objSqlConnection=new SqlConnection ("Server=(local);database=atorregulate;user id=sa;password=;");
				objSqlConnection.Open ();
				objSqlCommand=new SqlCommand ("Select * from workerearnings",objSqlConnection);
				objSqlDataReader=objSqlCommand.ExecuteReader ();			

				int nLine=1;
				while(objSqlDataReader.Read ())
				{
					e.Graphics .DrawString (objSqlDataReader["Enumber"].ToString (),objFont,objBrush,nLeft+20,nTop+60+nLine*30);
					e.Graphics .DrawString (objSqlDataReader["Eearnings"].ToString (),objFont,objBrush,nLeft+100,nTop+60+nLine*30);
					e.Graphics .DrawString (objSqlDataReader["Eprizc"].ToString (),objFont,objBrush,nLeft+200,nTop+60+nLine*30);
					e.Graphics .DrawString (objSqlDataReader["Eremark"].ToString (),objFont,objBrush,nLeft+270,nTop+60+nLine*30);
					nLine++;
				}
			}
			catch(SqlException ex)
			{
				MessageBox.Show (ex.Message );
			}
		}

		private void btnPrintprv_Click(object sender, System.EventArgs e)
		{
			this.ppdlgworker  .ShowDialog ();
		}

		private void btnRe_Click(object sender, System.EventArgs e)
		{
			this.txtEID .Clear ();
			this.txtEarning  .Clear ();
			this.txteprizc  .Clear ();
			this.txtremark .Clear  ();
			this.txtEID .Focus ();
		}

		private void btn_Click(object sender, System.EventArgs e)
		{
			this.tabControl1 .Visible =false;
			this.dbgworker .Visible =true;
			this.btnAdd .Enabled =true;
			this.btnPrint .Enabled =true;
			this.btnPrintprv .Enabled =true;
		}

		private void btnEbter_Click(object sender, System.EventArgs e)
		{
			try
			{
				if(string.Compare (cbofind1.Text ,"精确搜索",true)==0)
				{
						objSqlDataAdapter=new SqlDataAdapter ();
						objSqlDataAdapter.SelectCommand =new SqlCommand ("select Enumber as 员工编号,Eearnings as 员工工资,Eprizc as 员工奖金,Eremark as 备注 from workerearnings where Enumber= '"+this.txtfind1 .Text+"'",objSqlConnection);
						objDataSet=new DataSet ();
						objSqlDataAdapter.Fill (objDataSet," workerearnings");
						MessageBox.Show("已搜到 "+objDataSet.Tables[" workerearnings"].Rows.Count+" 条记录","注意");
						this.dbgworker .Enabled =false;

				}
				else if(string.Compare (cbofind1.Text ,"模糊搜索",true)==0)
				{
						objSqlDataAdapter=new SqlDataAdapter ();
						objSqlDataAdapter.SelectCommand =new SqlCommand ("select Enumber as 员工编号,Eearnings as 员工工资,Eprizc as 员工奖金,Eremark as 备注 from workerearnings where Enumber like '%"+this.txtfind1 .Text+"%'",objSqlConnection);
						objDataSet=new DataSet ();
						objSqlDataAdapter.Fill (objDataSet," workerearnings");
						MessageBox.Show("已搜到 "+objDataSet.Tables[" workerearnings"].Rows.Count+" 条记录","注意");
						this.dbgworker .Enabled =false;

				}
			}
			catch(SqlException ex)
			{
				MessageBox.Show (ex.Message );
			}
			catch(Exception ex)
			{
				MessageBox.Show (ex.Message );
			}
			finally
			{
				objSqlConnection.Close ();
			}
			//objSqlConnection.Close ();
			this.dbgworker .SetDataBinding (objDataSet," workerearnings");
			this.txtfind1 .Clear ();
		
		}

		private void btnaddwo_Click(object sender, System.EventArgs e)
		{
			try
			{
				
				if(this.txtEID .Text !=String.Empty &&this.txtEarning  .Text !=String.Empty  )
				{
					//如果有数据和字段。验证..
					if(ValidateFields())
					{
						DataRow objDataRow=objDataSet.Tables ["workerearnings"].NewRow ();
						objDataRow["员工编号"]=this.txtEID .Text ;
						objDataRow["员工工资"]=Decimal.Parse ( this.txtEarning  .Text) ;
						objDataRow["员工奖金"]=Decimal.Parse ( this.txteprizc  .Text) ;
						objDataRow["备注"]=this.txtremark .Text ;
						objDataSet.Tables ["workerearnings"].Rows .Add (objDataRow);
						objDataSet.HasChanges (DataRowState.Added );
						objSqlDataAdapter.Update (objDataSet,"workerearnings");
						MessageBox.Show ("成功插入员工工资资料");
						this.txtEID .Clear ();
						this.txtEarning  .Clear ();
						this.txteprizc  .Clear ();
						this.txtremark .Clear  ();
						this.dbgworker .Update ();
						this.txtEID .Focus ();
					}
									  
				}
					//如果所有字段均为空，则检查
					
				else if(objDataSet.HasChanges ())
				{
					objSqlDataAdapter.Update (objDataSet,"workerearnings");
					MessageBox.Show ("已成功插入记录");
				}
					//未输入数据按下按钮则显示
				else
					MessageBox.Show ("提供完整的详细信息");
			}
			catch(SqlException ex)
			{
				MessageBox.Show (ex.Message .ToString ());
			}
			catch(Exception genEx)
			{
				MessageBox.Show (genEx.Message .ToString ());
			}
		}


		private void btnDEit_Click(object sender, System.EventArgs e)
		{
			this.tabControl1 .Visible =false;
			this.dbgworker .Visible =true;
			this.btnAdd .Enabled =true;
			this.btnPrint .Enabled =true;
			this.btnPrintprv .Enabled =true;
		}

		private void btnDel1_Click(object sender, System.EventArgs e)
		{
			string num=this.txtDID .Text ;
			string delCmd="Delete from workerearnings where Enumber='"+num +"'";
			objSqlDataAdapter.DeleteCommand =new SqlCommand (delCmd,objSqlConnection);
			objParam=objSqlDataAdapter.DeleteCommand .Parameters .Add ("@Enumber",SqlDbType.Int  );
			objParam.SourceColumn ="员工编号";
			objParam.SourceVersion =DataRowVersion.Original ;


			objDialogResult=MessageBox.Show ("确定要删除当前忆录吗？","确定",MessageBoxButtons.YesNo ,MessageBoxIcon.Question );
			if(objDialogResult==DialogResult.Yes )
			{
				try
				{
					objDataSet.Tables [0].Rows [dbgworker.CurrentRowIndex ].Delete ();
					objSqlDataAdapter.Update (objDataSet,"workerearnings");
					MessageBox.Show ("已经删除记录");

					this.dbgworker .Enabled =true;
					objSqlDataAdapter.SelectCommand =new SqlCommand ("select Enumber as 员工编号,Eearnings as 员工工资,Eprizc as 员工奖金,Eremark as 备注 from workerearnings ",objSqlConnection);
					objDataSet=new DataSet();
					objSqlDataAdapter.Fill (objDataSet,"workerearnings");
					this.dbgworker .SetDataBinding (objDataSet,"workerearnings");
				}
				catch(SqlException ex)
				{
					MessageBox.Show (ex.Message );
				}
			}
			else
				return;
		}

	}
}