rptfrm.aspx.cs

某大型国企试用的网上订餐管理系统完整源代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace WebApplication1
{
	/// <summary>
	/// RptFrm 的摘要说明。
	/// </summary>
	public class RptFrm : System.Web.UI.Page
	{
		protected System.Data.Odbc.OdbcConnection odbcConnection1;
		protected System.Data.Odbc.OdbcCommand odbcSelectCommand1;
		protected System.Data.Odbc.OdbcCommand odbcInsertCommand1;
		protected System.Data.Odbc.OdbcCommand odbcUpdateCommand1;
		protected System.Data.Odbc.OdbcCommand odbcDeleteCommand1;
		protected System.Data.Odbc.OdbcDataAdapter odbcDataAdapter1;
		protected System.Data.DataSet dataSet1;
		protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
		protected CrystalDecisions.CrystalReports.Engine.ReportDocument reportDocument1;
		protected CrystalDecisions.Shared.ParameterFields ParameterFields1; 
		//protected CrystalDecisions.Shared.ParameterField ParameterField1;
		//protected System.IO.FileSystemWatcher fileSystemWatcher1;
		//protected CrystalDecisions.Shared.ParameterDiscreteValue ParameterDiscreteValue1;

		protected CrystalDecisions.Shared.ParameterField PKind;
		protected CrystalDecisions.Shared.ParameterDiscreteValue PDKind;
		protected CrystalDecisions.Shared.ParameterField PStartDate;
		protected CrystalDecisions.Shared.ParameterDiscreteValue PDStartDate;
		protected CrystalDecisions.Shared.ParameterField PEndDate;
		protected CrystalDecisions.Shared.ParameterDiscreteValue PDEndDate;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			string strCommand;
			string strReport,StartDate,EndDate;
			string strKind;
			int PageSize;

			//传递参数
			//strConnect = (string)Session["strConnect"];
			strCommand = (string)Session["strCommand"];
			strReport = (string)Session["strReport"];
			StartDate = (string)Session["StartDate"];
			EndDate = (string)Session["EndDate"];
			strKind = (string)Session["strKind"];
			//2006-05-07
			PageSize = (int)Session["PageSize"];

			if(!Global.CheckUserValidation((string)Session["strRole"], Global.MENU_VIEWRPT))
			{
				Response.Redirect("err_session.htm", true);
			}

			//连接DB
			connectionDB();

			odbcDataAdapter1.SelectCommand.CommandText = strCommand;
			odbcDataAdapter1.SelectCommand.Connection = odbcConnection1;
			//dataSet1 = new DataSet();
			
			reportDocument1  = new  CrystalDecisions.CrystalReports.Engine.ReportDocument();
			ParameterFields1 = new CrystalDecisions.Shared.ParameterFields();
			//ParameterField1 = new CrystalDecisions.Shared.ParameterField();
			//ParameterDiscreteValue1 = new CrystalDecisions.Shared.ParameterDiscreteValue();
			
			switch(strReport)
			{
				case "t_order":
					odbcDataAdapter1.Fill(dataSet1,"T_ORDER");						
					//传递参数给CrystalReports			
					PKind = new CrystalDecisions.Shared.ParameterField();
					PDKind = new CrystalDecisions.Shared.ParameterDiscreteValue();
					PKind.ParameterFieldName = "strKind";
					PDKind.Value = strKind;
					PKind.CurrentValues.Add(PDKind);
					ParameterFields1.Add(PKind);
					
					reportDocument1.Load(Server.MapPath("Order_Rpt.rpt"));
					break;
				case "t_batch_order":
					odbcDataAdapter1.Fill(dataSet1,"T_BATCH_ORDER");						
					//传递参数给CrystalReports			
					PKind = new CrystalDecisions.Shared.ParameterField();
					PDKind = new CrystalDecisions.Shared.ParameterDiscreteValue();
					PKind.ParameterFieldName = "strKind";
					PDKind.Value = strKind;
					PKind.CurrentValues.Add(PDKind);
					ParameterFields1.Add(PKind);
					
					reportDocument1.Load(Server.MapPath("Batch_order_rpt.rpt"));
					break;
				case "Batch_Date_rpt":
					odbcDataAdapter1.Fill(dataSet1,"Batch_Date_Total");						
					//传递参数给CrystalReports	
					PStartDate = new CrystalDecisions.Shared.ParameterField();
					PDStartDate = new CrystalDecisions.Shared.ParameterDiscreteValue();
					PEndDate = new CrystalDecisions.Shared.ParameterField();
					PDEndDate = new CrystalDecisions.Shared.ParameterDiscreteValue();
					PStartDate.ParameterFieldName = "StartDate";
					PDStartDate.Value = StartDate;
					PStartDate.CurrentValues.Add (PDStartDate);
					ParameterFields1.Add(PStartDate);					
					PEndDate.ParameterFieldName = "EndDate";
					PDEndDate.Value = EndDate;
					PEndDate.CurrentValues.Add (PDEndDate);
					ParameterFields1.Add(PEndDate);
					
					reportDocument1.Load(Server.MapPath("Batch_Date_rpt.rpt"));
					break;

				case "Order_Date_rpt":
					odbcDataAdapter1.Fill(dataSet1,"Order_Date_Total");						
					//传递参数给CrystalReports	
					PStartDate = new CrystalDecisions.Shared.ParameterField();
					PDStartDate = new CrystalDecisions.Shared.ParameterDiscreteValue();
					PEndDate = new CrystalDecisions.Shared.ParameterField();
					PDEndDate = new CrystalDecisions.Shared.ParameterDiscreteValue();
					PStartDate.ParameterFieldName = "StartDate";
					PDStartDate.Value = StartDate;
					PStartDate.CurrentValues.Add (PDStartDate);
					ParameterFields1.Add(PStartDate);					
					PEndDate.ParameterFieldName = "EndDate";
					PDEndDate.Value = EndDate;
					PEndDate.CurrentValues.Add (PDEndDate);
					ParameterFields1.Add(PEndDate);
					
					reportDocument1.Load(Server.MapPath("Order_Date_rpt.rpt"));
					break;					
			}

			//2006-05-07
			switch(PageSize)
			{
				case 0:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
					break;
				case 1:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.PaperA4;
					break;
				case 2:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.PaperA5;
					break;
				case 3:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.PaperB4;
					break;
				case 4:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.PaperB5;
					break;
				case 5:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.PaperA3;
					break;
				case 6:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.PaperLetter;
					break;
				case 7:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.Paper10x14;
					break;
				case 8:					
					reportDocument1.PrintOptions.PaperSize=CrystalDecisions.Shared.PaperSize.Paper11x17;
					break;
			}
			CrystalDecisions.Shared.PageMargins margins;
			margins = new CrystalDecisions.Shared.PageMargins();
			margins = reportDocument1.PrintOptions.PageMargins; 
			margins.bottomMargin = 250; 
			margins.leftMargin = 350; 
			margins.rightMargin = 350; 
			margins.topMargin = 250;     
			reportDocument1.PrintOptions.ApplyPageMargins(margins);


			CrystalReportViewer1.ParameterFieldInfo = ParameterFields1;	
			reportDocument1.SetDataSource(dataSet1); 
			CrystalReportViewer1.ReportSource = reportDocument1;
			CrystalReportViewer1.DataBind();
			CrystalReportViewer1.SeparatePages = false;
			CrystalReportViewer1.DisplayGroupTree = false;
			CrystalReportViewer1.DisplayToolbar = false;

		//	Global.WriteLog(ref odbcConnection1, strUser,Global.MENU_PRINT,Global.ACTION_OTHER,"打印"); //+strDate+DListIndex+RptDList.SelectedItem.Text

			closeDB();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.odbcConnection1 = new System.Data.Odbc.OdbcConnection();
			this.odbcSelectCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcInsertCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcUpdateCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcDeleteCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcDataAdapter1 = new System.Data.Odbc.OdbcDataAdapter();
			this.dataSet1 = new System.Data.DataSet();
			this.reportDocument1 = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
			//this.fileSystemWatcher1 = new System.IO.FileSystemWatcher();
			((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
			//((System.ComponentModel.ISupportInitialize)(this.fileSystemWatcher1)).BeginInit();
			// 
			// odbcDataAdapter1
			// 
			this.odbcDataAdapter1.DeleteCommand = this.odbcDeleteCommand1;
			this.odbcDataAdapter1.InsertCommand = this.odbcInsertCommand1;
			this.odbcDataAdapter1.SelectCommand = this.odbcSelectCommand1;
			this.odbcDataAdapter1.UpdateCommand = this.odbcUpdateCommand1;
			// 
			// dataSet1
			// 
			this.dataSet1.DataSetName = "NewDataSet";
			this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// reportDocument1
			// 
			this.reportDocument1.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation;
			this.reportDocument1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
			this.reportDocument1.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Upper;
			this.reportDocument1.PrintOptions.PrinterDuplex = CrystalDecisions.Shared.PrinterDuplex.Default;
			// 
			// fileSystemWatcher1
			// 
			//this.fileSystemWatcher1.EnableRaisingEvents = true;
			//this.fileSystemWatcher1.Changed += new System.IO.FileSystemEventHandler(this.fileSystemWatcher1_Changed);
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
			//((System.ComponentModel.ISupportInitialize)(this.fileSystemWatcher1)).EndInit();

		}
		#endregion

		private void connectionDB()
		{
			Global.OpenConnection(ref odbcConnection1);
	
		}
		private void closeDB()
		{
			odbcConnection1.Close();	
		}

		private void fileSystemWatcher1_Changed(object sender, System.IO.FileSystemEventArgs e)
		{
		
		}
	}
}