frmqsset.cs

以构建的方式来实现对通用的查询统计

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using dist.hb.EnvQueryStat.QuerySet;
using dist.hb.EnvQueryStat.StatSet;

namespace dist.hb.EnvQueryStat.Manage
{
	public partial class frmQSSet : Form
	{
		private ucTransField ucTrasField;//字段汉化对象
		private ucVTM ucVTM;//虚表管理
    private ucVTField ucVTFld;//虚表字段管理
    private ucQueryAction ucQA;//查询动作

    //查询相关
    private ucAbstractQuery ucAQ;//抽象查询
    private ucAbstractQueryField　ucAQField;//抽象查询字段设定
    private ucAbstractQueryAction ucAQAction;//抽象查询动作设定
    private ucQueryClass ucQC;//查询实例分类
    private ucQueryInst ucQI;//查询实例

    //统计相关
    private ucAbstractStat ucAS;//统计模板
    private ucAbstractStatSet ucASS;//抽象统计字段设定
    private ucStatClass ucSC;//统计实例分类
    private ucStatInst ucSI;//统计实例

		private OleDbConnection m_OleDbConn;
		public OleDbConnection OleDbConn
		{
			get { return m_OleDbConn; } 
			set {
				if(value == null) return;
				if(value == m_OleDbConn) return;	
				m_OleDbConn = value;
			} 
		}

		public frmQSSet()
		{
			InitializeComponent();
		}

		private void navBarItem1_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
		{
      if (ucTrasField != null) ucTrasField.Dispose();
      ucTrasField = new ucTransField();
			ucTrasField.OleDbConn = m_OleDbConn;
			splitContainerControl1.Panel2.Controls.Clear();
			splitContainerControl1.Panel2.Controls.Add(ucTrasField);
			ucTrasField.Dock = DockStyle.Fill;  
		}

		private void frmQSSet_Load(object sender, EventArgs e)
		{

		}

		private void navBarItem2_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
		{
      if (ucVTM != null) ucVTM.Dispose();
      ucVTM = new ucVTM();
			ucVTM.OleDbConn = m_OleDbConn;
			splitContainerControl1.Panel2.Controls.Clear();
			splitContainerControl1.Panel2.Controls.Add(ucVTM);
			ucVTM.Dock = DockStyle.Fill;  
		}

    private void navBarItem3_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucVTFld != null) ucVTFld.Dispose();
      ucVTFld = new ucVTField();
      ucVTFld.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucVTFld);
      ucVTFld.Dock = DockStyle.Fill;  
    }

    private void navBarItem4_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucQA != null) ucQA.Dispose();
      ucQA = new ucQueryAction();
      ucQA.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucQA);
      ucQA.Dock = DockStyle.Fill;  
    }

    private void navBarItem6_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucAQ != null) ucAQ.Dispose();
      ucAQ = new ucAbstractQuery();
      ucAQ.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucAQ);
      ucAQ.Dock = DockStyle.Fill;  
    }

    private void navBarItem7_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucAQField != null) ucAQField.Dispose();
      ucAQField = new ucAbstractQueryField();
      ucAQField.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucAQField);
      ucAQField.Dock = DockStyle.Fill;  
    }

    private void navBarItem8_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucAQAction != null) ucAQAction.Dispose();
      ucAQAction = new ucAbstractQueryAction();
      ucAQAction.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucAQAction);
      ucAQAction.Dock = DockStyle.Fill;  
    }

    private void navBarItem9_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucQC != null) ucQC.Dispose();
      ucQC = new ucQueryClass();
      ucQC.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucQC);
      ucQC.Dock = DockStyle.Fill;  
    }

    private void navBarItem10_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucQI != null) ucQI.Dispose();
      ucQI = new ucQueryInst();
      ucQI.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucQI);
      ucQI.Dock = DockStyle.Fill;  
      
    }

    private void navBarItem5_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucAS != null) ucAS.Dispose();
      ucAS = new ucAbstractStat();
      ucAS.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucAS);
      ucAS.Dock = DockStyle.Fill;  
    }

    private void navBarItem11_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucASS != null) ucASS.Dispose();
      ucASS = new ucAbstractStatSet();
      ucASS.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucASS);
      ucASS.Dock = DockStyle.Fill;  
    }

    private void navBarItem12_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucSC != null) ucSC.Dispose();
      ucSC = new ucStatClass();
      ucSC.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucSC);
      ucSC.Dock = DockStyle.Fill;  
    }

    private void navBarItem13_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
    {
      if (ucSI != null) ucSI.Dispose();
      ucSI = new ucStatInst();
      ucSI.OleDbConn = m_OleDbConn;
      splitContainerControl1.Panel2.Controls.Clear();
      splitContainerControl1.Panel2.Controls.Add(ucSI);
      ucSI.Dock = DockStyle.Fill;  
    }

	}
}