frmoperation.cs

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

					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",36,FontStyle.Bold ),Brushes.Blue ,nLeft+30,nTop+10);
					e.Graphics.DrawString ("业主",objFont,objBrush ,nLeft+10,nTop+60);
					e.Graphics.DrawString ("房号",objFont,objBrush ,nLeft+70,nTop+60);
					e.Graphics.DrawString ("水费",objFont,objBrush ,nLeft+100,nTop+60);
					e.Graphics.DrawString ("电费",objFont,objBrush ,nLeft+160,nTop+60);
					e.Graphics.DrawString ("停车费",objFont,objBrush ,nLeft+220,nTop+60);
					e.Graphics.DrawString ("管理费",objFont,objBrush ,nLeft+280,nTop+60);
					e.Graphics.DrawString ("排污费",objFont,objBrush ,nLeft+340,nTop+60);
					e.Graphics.DrawString ("煤气费",objFont,objBrush ,nLeft+400,nTop+60);
					e.Graphics.DrawString ("修改日期",objFont,objBrush ,nLeft+460,nTop+60);
					e.Graphics.DrawString ("状态",objFont,objBrush ,nLeft+580,nTop+60);
					try
					{
						objSqlConn=new SqlConnection ("Server=(local);database=atorregulate;user id=sa;password=;");
						objSqlConn.Open ();
						objSqlCommand=new SqlCommand ("Select * from trigfee",objSqlConn);
						objSqlDataReader=objSqlCommand.ExecuteReader ();			

						int nLine=1;
						while(objSqlDataReader.Read ())
						{
							e.Graphics .DrawString (objSqlDataReader["Musername"].ToString (),objFont,objBrush,nLeft+10,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mhomenumber"].ToString (),objFont,objBrush,nLeft+70,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mwater"].ToString (),objFont,objBrush,nLeft+100,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Melecticity"].ToString (),objFont,objBrush,nLeft+160,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mcar"].ToString (),objFont,objBrush,nLeft+220,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mregulate"].ToString (),objFont,objBrush,nLeft+280,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mrange"].ToString (),objFont,objBrush,nLeft+340,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mgas"].ToString (),objFont,objBrush,nLeft+400,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mdata"].ToString (),objFont,objBrush,nLeft+460,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Mtype"].ToString (),objFont,objBrush,nLeft+580,nTop+60+nLine*30);
							nLine++;
						}
					}
					catch(SqlException ex)
					{
						MessageBox.Show (ex.Message );
					}
					break;
				}
				case("楼房居住记录"):
				{
					objSqlConn=new SqlConnection("database=atorregulate;user id=sa;password=;SERVER=(local)");
					objSqlConn.Open();
					objSqlDataAdapter=new SqlDataAdapter();
					objSqlDataAdapter.SelectCommand=new SqlCommand("select Nstorey as 房号,Nitem as 所属栋,Nusername as 业主,Ntelnumber as 电话, Ndata as 修改日期,Ntype as 状态 from trigstorey",objSqlConn);
					objDataSet=new DataSet();
					objSqlDataAdapter.Fill(objDataSet,"trigstorey");
					//将DATAGRID控件绑定到数据集表
					this.dataGrid1.SetDataBinding(objDataSet,"trigstorey");
					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",36,FontStyle.Bold ),Brushes.Blue ,nLeft+30,nTop+10);
					e.Graphics.DrawString ("房号",objFont,objBrush ,nLeft+10,nTop+60);
					e.Graphics.DrawString ("所属栋",objFont,objBrush ,nLeft+70,nTop+60);
					e.Graphics.DrawString ("业主",objFont,objBrush ,nLeft+140,nTop+60);
					e.Graphics.DrawString ("电话",objFont,objBrush ,nLeft+220,nTop+60);
					e.Graphics.DrawString ("修改日期",objFont,objBrush ,nLeft+320,nTop+60);
					e.Graphics.DrawString ("状态",objFont,objBrush ,nLeft+500,nTop+60);
					try
					{
						objSqlConn=new SqlConnection ("Server=(local);database=atorregulate;user id=sa;password=;");
						objSqlConn.Open ();
						objSqlCommand=new SqlCommand ("Select * from trigstorey",objSqlConn);
						objSqlDataReader=objSqlCommand.ExecuteReader ();			

						int nLine=1;
						while(objSqlDataReader.Read ())
						{
							e.Graphics .DrawString (objSqlDataReader["Nstorey"].ToString (),objFont,objBrush,nLeft+10,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Nitem"].ToString (),objFont,objBrush,nLeft+70,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Nusername"].ToString (),objFont,objBrush,nLeft+140,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Ntelnumber"].ToString (),objFont,objBrush,nLeft+220,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Ndata"].ToString (),objFont,objBrush,nLeft+320,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Ntype"].ToString (),objFont,objBrush,nLeft+500,nTop+60+nLine*30);
							nLine++;
						}
					}
					catch(SqlException ex)
					{
						MessageBox.Show (ex.Message );
					}
					break;
				}
				case("员工在职记录"):
				{
					objSqlConn=new SqlConnection("database=atorregulate;user id=sa;password=;SERVER=(local)");
					objSqlConn.Open();
					objSqlDataAdapter=new SqlDataAdapter();
					objSqlDataAdapter.SelectCommand=new SqlCommand("select Wnumber as 编号,Wname as 姓名,Wcarcor as 职位,WIDcard as 身份证, Waddress as 地址,Wtime as 修改日期,Wtype as 状态 from trigworker",objSqlConn);
					objDataSet=new DataSet();
					objSqlDataAdapter.Fill(objDataSet,"trigworker");
					//将DATAGRID控件绑定到数据集表
					this.dataGrid1.SetDataBinding(objDataSet,"trigworker");
					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",36,FontStyle.Bold ),Brushes.Blue ,nLeft+30,nTop+10);
					e.Graphics.DrawString ("编号",objFont,objBrush ,nLeft+10,nTop+60);
					e.Graphics.DrawString ("姓名",objFont,objBrush ,nLeft+60,nTop+60);
					e.Graphics.DrawString ("职位",objFont,objBrush ,nLeft+140,nTop+60);
					e.Graphics.DrawString ("身份证",objFont,objBrush ,nLeft+220,nTop+60);
					e.Graphics.DrawString ("地址",objFont,objBrush ,nLeft+320,nTop+60);
					e.Graphics.DrawString ("修改日期",objFont,objBrush ,nLeft+400,nTop+60);
					e.Graphics.DrawString ("状态",objFont,objBrush ,nLeft+530,nTop+60);
					try
					{
						objSqlConn=new SqlConnection ("Server=(local);database=atorregulate;user id=sa;password=;");
						objSqlConn.Open ();
						objSqlCommand=new SqlCommand ("Select * from trigworker",objSqlConn);
						objSqlDataReader=objSqlCommand.ExecuteReader ();			

						int nLine=1;
						while(objSqlDataReader.Read ())
						{
							e.Graphics .DrawString (objSqlDataReader["Wnumber"].ToString (),objFont,objBrush,nLeft+10,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Wname"].ToString (),objFont,objBrush,nLeft+60,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Wcarcor"].ToString (),objFont,objBrush,nLeft+140,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["WIDcard"].ToString (),objFont,objBrush,nLeft+220,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Waddress"].ToString (),objFont,objBrush,nLeft+320,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Wtime"].ToString (),objFont,objBrush,nLeft+400,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Wtype"].ToString (),objFont,objBrush,nLeft+550,nTop+60+nLine*30);
							nLine++;
						}
					}
					catch(SqlException ex)
					{
						MessageBox.Show (ex.Message );
					}
					break;
				}
				case("员工工资发放记录"):
				{
					objSqlConn=new SqlConnection("database=atorregulate;user id=sa;password=;SERVER=(local)");
					objSqlConn.Open();
					objSqlDataAdapter=new SqlDataAdapter();
					objSqlDataAdapter.SelectCommand=new SqlCommand("select Enumber as 编号,Eearnings as 基本工资,Eprizc as 奖金,Edata as 修改日期,Etype as 状态 from trigworkerearnings",objSqlConn);
					objDataSet=new DataSet();
					objSqlDataAdapter.Fill(objDataSet,"trigworkerearnings");
					//将DATAGRID控件绑定到数据集表
					this.dataGrid1.SetDataBinding(objDataSet,"trigworkerearnings");
					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",36,FontStyle.Bold ),Brushes.Blue ,nLeft+30,nTop+10);
					e.Graphics.DrawString ("编号",objFont,objBrush ,nLeft+10,nTop+60);
					e.Graphics.DrawString ("基本工资",objFont,objBrush ,nLeft+60,nTop+60);
					e.Graphics.DrawString ("奖金",objFont,objBrush ,nLeft+200,nTop+60);
					e.Graphics.DrawString ("修改日期",objFont,objBrush ,nLeft+340,nTop+60);
					e.Graphics.DrawString ("状态",objFont,objBrush ,nLeft+500,nTop+60);
					try
					{
						objSqlConn=new SqlConnection ("Server=(local);database=atorregulate;user id=sa;password=;");
						objSqlConn.Open ();
						objSqlCommand=new SqlCommand ("Select * from trigworkerearnings",objSqlConn);
						objSqlDataReader=objSqlCommand.ExecuteReader ();			

						int nLine=1;
						while(objSqlDataReader.Read ())
						{
							e.Graphics .DrawString (objSqlDataReader["Enumber"].ToString (),objFont,objBrush,nLeft+10,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Eearnings"].ToString (),objFont,objBrush,nLeft+60,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Eprizc"].ToString (),objFont,objBrush,nLeft+200,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Edata"].ToString (),objFont,objBrush,nLeft+340,nTop+60+nLine*30);
							e.Graphics .DrawString (objSqlDataReader["Etype"].ToString (),objFont,objBrush,nLeft+500,nTop+60+nLine*30);
							nLine++;
						}
					}
					catch(SqlException ex)
					{
						MessageBox.Show (ex.Message );
					}
					break;
				}
			}
		}
	}
}