resultpanel.cs

c#源代码

/*
 * Created by SharpDevelop.
 * User: Forstmeier Peter
 * Date: 25.02.2005
 * Time: 10:22
 * 
 * To change this template use Tools | Options | Coding | Edit Standard Headers.
 */

using System;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using System.Xml;
using System.Data;
using System.Data.OleDb;


using ICSharpCode.SharpDevelop.Gui.Dialogs;
using ICSharpCode.SharpDevelop.Internal.Project;

using ICSharpCode.Core.Properties;
using ICSharpCode.Core.Services;
using ICSharpCode.Core.AddIns.Codons;

using ICSharpCode.SharpDevelop.Services;

using SharpReport;
using SharpReportCore;

using SharpQuery.SchemaClass;
using SharpQuery.Connection;
using SharpQuery.Gui.DataView;
using SharpQuery.Collections;

namespace ReportGenerator{
	/// <summary>
	/// This Class show the Result of the Query build in the previos window,
	/// also we can create *.xsd File's (Schema onla and/or Data + Schema)
	/// </summary>
	public class ResultPanel : AbstractWizardPanel{
		
		const string contextMenuPath = "/ReportGenerator/ResultPanel/ContextMenu";
		
		
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox txtSqlString;
		private System.Windows.Forms.DataGrid grdQuery;
		
		private ReportGenerator generator = null;
		private IProperties customizer    = null;
		
		private IMessageService messageService; 
		private ResourceService resourceService;
		private MenuService menuService;
		
		private SharpQuerySchemaClassCollection parametersClass;
		
		private DataSet resultDataSet;
		
		public ResultPanel(){
			InitializeComponent();
			base.EnableFinish = true;
			base.EnableCancel = true;
			base.EnableNext = true;
			base.Refresh();
			messageService =(IMessageService)ServiceManager.Services.GetService(typeof(IMessageService));
			resourceService = (ResourceService)ServiceManager.Services.GetService(typeof(ResourceService));
			this.label1.Text = resourceService.GetString("SharpReport.Wizard.PullModel.CommandText");
		}
		
		#region Fill data
		private void FillGrid() {
			
			this.grdQuery.DataSource = null;
			this.txtSqlString.Text = null;
			ReportModel model = generator.FillReportModel(new ReportModel());
			
			resultDataSet = new DataSet();
			this.txtSqlString.Text = model.ReportSettings.CommandText;
			
			if (model.ReportSettings.CommandType == CommandType.StoredProcedure){

				if (generator.SharpQueryProcedure == null) {
					throw new NullReferenceException("ResultPanel:FillGrid");
				}
				SharpQueryProcedure proc = generator.SharpQueryProcedure;
		
				// we have some Parameters, to get themw we use the Dialogfrom SharpQuery
				if (proc.GetSchemaParameters() != null && proc.GetSchemaParameters().Count > 0) {				
					SharpQuerySchemaClassCollection tmp = proc.GetSchemaParameters();
					SharpQueryParameterCollection parameters = new SharpQueryParameterCollection(tmp);
					
					using (SQLParameterInput inputform = new SQLParameterInput(parameters)){
						if ( inputform.ShowDialog() != DialogResult.OK ){
							parametersClass = null;
						}else{
							parametersClass	= parameters.ToBaseSchemaCollection();
							if (parametersClass != null) {
								resultDataSet = (DataSet) proc.Execute(0,parametersClass);
								generator.Parameters = parametersClass;
							}
						}
					}
				} else {
					try {
						// Stored Proc without Parameters
						resultDataSet = (DataSet) proc.Execute(0,proc.GetSchemaParameters());
					} catch (Exception) {
						throw;
					}
					
				}
			}
			
			// from here we create from an SqlString like "Select...."
			if (model.ReportSettings.CommandType == CommandType.Text){
				try {
					generator.Parameters = null;
					this.txtSqlString.Text = model.ReportSettings.CommandText;
					resultDataSet = BuildFromSqlString(model.ReportSettings);
					
				} catch (OleDbException oleDbex) {
					throw oleDbex;
				}
				catch (Exception e) {
					throw e;
				}
			}
			//For now we show only the first table, but we should find a better solution?
			if (resultDataSet != null) {
				this.grdQuery.DataSource = resultDataSet.Tables[0];
			} else {
				NullReferenceException e = new NullReferenceException("ResultPanel:FillGrid");
				throw e;
			}
		}
		
		
		DataSet BuildFromSqlString(ReportSettings settings) {
			OLEDBConnectionWrapper con = null;
			DataSet ds = null;
			if (settings.CommandText.IndexOf("?") > 0) {
				throw new NotSupportedException ("Parameters in SqlText are not supportet");
			}
			
			try {
				con = new OLEDBConnectionWrapper(settings.ConnectionString);
				con.Open();
				if (con.IsOpen) {
					ds = (DataSet)con.ExecuteSQL(settings.CommandText,0);
					return ds;
				}
			} catch (Exception) {
				throw;
			} finally {
				con.Close();
			}
			return null;
		}
		#endregion
		
		#region Create *.Xsd File
		public void GrdQueryMouseUp(object sender, System.Windows.Forms.MouseEventArgs e){
			if (e.Button == MouseButtons.Right) {
				menuService = (MenuService)ICSharpCode.Core.Services.ServiceManager.Services.GetService(typeof(MenuService));
				ContextMenu ctMen = menuService.CreateContextMenu (this,contextMenuPath);
				ctMen.Show (this.grdQuery,new Point (e.X,e.Y));
				
			}
		}
		
		/// <summary>
		/// Create a *.xsd File
		/// </summary>
		/// <param name="schemaOnly">true = schema only</param>
		
		public void SaveXsdFile(bool schemaOnly){
			try {
				using (SaveFileDialog saveFileDialog = new SaveFileDialog()){
					saveFileDialog.Filter = GlobalValues.XsdFileFilter;
					saveFileDialog.DefaultExt = GlobalValues.XsdExtension;
					saveFileDialog.AddExtension    = true;
					
					if(saveFileDialog.ShowDialog() == DialogResult.OK){
						using (System.IO.FileStream fileStream =
						       new System.IO.FileStream(saveFileDialog.FileName,
						                                System.IO.FileMode.Create)){
							XmlTextWriter xmlWriter = new XmlTextWriter(fileStream, System.Text.Encoding.UTF8);
							xmlWriter.WriteStartDocument(true);
							
							if (schemaOnly) {
								resultDataSet.WriteXmlSchema(xmlWriter);
							} else {
								resultDataSet.WriteXml(xmlWriter,XmlWriteMode.WriteSchema);
							}
							xmlWriter.Close();
						}
					}
				}
			} catch (Exception ) {
				throw ;
			}
		}
		
		#endregion
		
		#region overrides
		public override bool ReceiveDialogMessage(DialogMessage message)
		{
			if (message == DialogMessage.Activated) {
				try {
					FillGrid();
					base.EnableNext = true;
					base.EnableFinish = true;
				} catch (Exception e) {
					messageService.ShowError(e.Message);
					base.EnableNext = false;
					base.EnableFinish = false;
				}
			}
			return true;
		}
		
		
		public override object CustomizationObject {
			get {
				return customizer;
			}
			set {
				this.customizer = (IProperties)value;
				generator = (ReportGenerator)customizer.GetProperty("Generator");
			}
		}

		#endregion
		
		#region Windows Forms Designer generated code
		/// <summary>
		/// This method is required for Windows Forms designer support.
		/// Do not change the method contents inside the source code editor. The Forms designer might
		/// not be able to load this method if it was changed manually.
		/// </summary>
		private void InitializeComponent() {
			this.grdQuery = new System.Windows.Forms.DataGrid();
			this.txtSqlString = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			((System.ComponentModel.ISupportInitialize)(this.grdQuery)).BeginInit();
			this.SuspendLayout();
			// 
			// grdQuery
			// 
			this.grdQuery.CaptionForeColor = System.Drawing.SystemColors.ActiveCaptionText;
			this.grdQuery.DataMember = "";
			this.grdQuery.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.grdQuery.Location = new System.Drawing.Point(16, 88);
			this.grdQuery.Name = "grdQuery";
			this.grdQuery.Size = new System.Drawing.Size(408, 264);
			this.grdQuery.TabIndex = 2;
			this.grdQuery.MouseUp += new System.Windows.Forms.MouseEventHandler(this.GrdQueryMouseUp);
			// 
			// txtSqlString
			// 
			this.txtSqlString.Location = new System.Drawing.Point(16, 48);
			this.txtSqlString.Name = "txtSqlString";
			this.txtSqlString.Size = new System.Drawing.Size(408, 20);
			this.txtSqlString.TabIndex = 0;
			this.txtSqlString.Text = "";
			// 
			// label1
			// 
			this.label1.Location = new System.Drawing.Point(16, 24);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(120, 16);
			this.label1.TabIndex = 1;
		
			// 
			// ResultPanel
			// 
			this.Controls.Add(this.grdQuery);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.txtSqlString);
			this.Name = "ResultPanel";
			this.Size = new System.Drawing.Size(440, 368);
			((System.ComponentModel.ISupportInitialize)(this.grdQuery)).EndInit();
			this.ResumeLayout(false);
		}
		#endregion
	}
}