childadvreport.cs

报刊广告管理系统。CSharp编写

using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using System.Data;

namespace WWAM.Forms.Child
{
	public class ChildAdvReport : WWAM.Forms.Child.ChdBase
	{
		#region ChildAdvReport
		private System.Windows.Forms.Panel mainPanel;
		private DevExpress.XtraGrid.Columns.GridColumn colCode;
		private DevExpress.XtraGrid.Columns.GridColumn colPaperName;
		private DevExpress.XtraGrid.Columns.GridColumn colPaperSpaceNum;
		private DevExpress.XtraGrid.Columns.GridColumn colPaperSpace;
		private DevExpress.XtraBars.Docking.DockManager dockManager1;
		private DevExpress.XtraGrid.GridControl gcAdv;
		private WWAM.BLL.NavBarBtns nbbAdv;
		private DevExpress.XtraGrid.Views.Grid.GridView gvAdv;
		private WWAM.DBA.WWAMDS wwamds1;
		private DevExpress.XtraGrid.Columns.GridColumn colAdvContent;
		private DevExpress.XtraGrid.Columns.GridColumn colIsPay;
		private DevExpress.XtraGrid.Columns.GridColumn colIsAuth;
		private DevExpress.XtraGrid.Columns.GridColumn colClientCode;
		private DevExpress.XtraGrid.Columns.GridColumn colDateIssue;
		private DevExpress.XtraGrid.Columns.GridColumn colPaperPerNum;
		private DevExpress.XtraGrid.Columns.GridColumn colAdvSpec;
		private DevExpress.XtraGrid.Columns.GridColumn colInvoiceNum;
		private DevExpress.XtraGrid.Columns.GridColumn colPayType;
		private DevExpress.XtraGrid.Columns.GridColumn colClientType;
		private DevExpress.XtraGrid.Columns.GridColumn colDatePay;
		private DevExpress.XtraGrid.Columns.GridColumn colPayReal;
		private DevExpress.XtraGrid.Columns.GridColumn colPaySum;
		private DevExpress.XtraGrid.Columns.GridColumn colPayPer;
		private DevExpress.XtraGrid.Columns.GridColumn colAuthor;
		private DevExpress.XtraGrid.Columns.GridColumn colOpUser;
		private DevExpress.XtraGrid.Columns.GridColumn colPayNum;
		private DevExpress.XtraGrid.Columns.GridColumn colPayUnit;
		private DevExpress.XtraGrid.Columns.GridColumn colColor;
		private DevExpress.XtraGrid.Columns.GridColumn colMemo;
		private DevExpress.XtraBars.Docking.DockPanel dpFilter;
		private DevExpress.XtraBars.Docking.ControlContainer dockPanel1_Container;
		private DevExpress.XtraEditors.ComboBoxEdit txtPaperName;
		private DevExpress.XtraEditors.CheckEdit fchkAuthor;
		private DevExpress.XtraEditors.CheckEdit fchkIsPay;
		private DevExpress.XtraEditors.CheckEdit fchkIsAuth;
		private DevExpress.XtraEditors.CheckEdit fchkPaperPerNum;
		private DevExpress.XtraEditors.CheckEdit fchkPaperSpaceNum;
		private DevExpress.XtraEditors.CheckEdit fchkPaperSpace;
		private DevExpress.XtraEditors.CheckEdit fchkColor;
		private DevExpress.XtraEditors.CheckEdit fchkPayUnit;
		private DevExpress.XtraEditors.CheckEdit fchkPaperName;
		private DevExpress.XtraEditors.CheckEdit fchkClientType;
		private DevExpress.XtraEditors.CheckEdit fchkInvoice;
		private DevExpress.XtraEditors.CheckEdit fchkDateIssue;
		private DevExpress.XtraEditors.CheckEdit fchkDatePay;
		private DevExpress.XtraEditors.CheckEdit fchkAuthDate;
		private DevExpress.XtraEditors.CheckEdit fchkAdvContent;
		private DevExpress.XtraEditors.CheckEdit fchkAuthContent;
		private DevExpress.XtraEditors.DateEdit txtDateIssue1;
		private DevExpress.XtraEditors.DateEdit txtAuthDate2;
		private DevExpress.XtraEditors.TextEdit txtCode;
		private DevExpress.XtraEditors.DateEdit txtDatePay1;
		private DevExpress.XtraEditors.DateEdit txtDatePay2;
		private DevExpress.XtraEditors.TextEdit txtInvoiceNum;
		private DevExpress.XtraEditors.DateEdit txtDateIssue2;
		private DevExpress.XtraEditors.DateEdit txtAuthDate1;
		private DevExpress.XtraEditors.TextEdit txtPaperSpaceNum;
		private DevExpress.XtraEditors.ComboBoxEdit txtPaperSpace;
		private DevExpress.XtraEditors.ComboBoxEdit txtColor;
		private DevExpress.XtraEditors.ComboBoxEdit txtPayUnit;
		private DevExpress.XtraEditors.CheckEdit fchkClientCode;
		private DevExpress.XtraEditors.ComboBoxEdit txtClientType;
		private DevExpress.XtraEditors.ComboBoxEdit txtAuthor;
		private DevExpress.XtraEditors.CheckEdit fchkMemo;
		private DevExpress.XtraEditors.TextEdit txtAdvContent;
		private DevExpress.XtraEditors.TextEdit txtAuthContent;
		private DevExpress.XtraEditors.TextEdit txtClientCode;
		private DevExpress.XtraEditors.CheckEdit fchkInvoiceNum;
		private DevExpress.XtraEditors.CheckEdit fchkCode;
		private DevExpress.XtraEditors.TextEdit txtMemo;
		private DevExpress.XtraEditors.CheckEdit fchkOpUser;
		private DevExpress.XtraEditors.ComboBoxEdit txtOpUser;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label4;
		private DevExpress.XtraEditors.SpinEdit txtPaperPerNum1;
		private DevExpress.XtraEditors.SpinEdit txtPaperPerNum2;
		private DevExpress.XtraEditors.SimpleButton btnSearch;
		private DevExpress.XtraEditors.ComboBoxEdit txtIsAuth;
		private DevExpress.XtraEditors.ComboBoxEdit txtIsPay;
		private DevExpress.XtraEditors.CheckEdit fchkPayType;
		private DevExpress.XtraEditors.ComboBoxEdit txtPayType;
		private System.Windows.Forms.Label label5;
		private DevExpress.XtraEditors.SimpleButton btnModelDelete;
		private DevExpress.XtraEditors.ComboBoxEdit txtReportModel;
		private DevExpress.XtraEditors.SimpleButton btnModelSaveAs;
		private System.ComponentModel.IContainer components = null;

		public ChildAdvReport()
		{
			// 该调用是 Windows 窗体设计器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 调用后添加任何初始化
		}

		public ChildAdvReport(DevExpress.XtraNavBar.NavBarItem item):base(item)
		{
			// 该调用是 Windows 窗体设计器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 调用后添加任何初始化
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region 设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ChildAdvReport));
			this.mainPanel = new System.Windows.Forms.Panel();
			this.gcAdv = new DevExpress.XtraGrid.GridControl();
			this.wwamds1 = new WWAM.DBA.WWAMDS();
			this.gvAdv = new DevExpress.XtraGrid.Views.Grid.GridView();
			this.colCode = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPaperPerNum = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colDateIssue = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colAdvContent = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPaperName = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPaperSpaceNum = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPaperSpace = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colAdvSpec = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colColor = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colClientCode = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colClientType = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colIsPay = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPaySum = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPayReal = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPayPer = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colDatePay = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPayType = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colIsAuth = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colAuthor = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colInvoiceNum = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colOpUser = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPayNum = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colPayUnit = new DevExpress.XtraGrid.Columns.GridColumn();
			this.colMemo = new DevExpress.XtraGrid.Columns.GridColumn();
			this.nbbAdv = new WWAM.BLL.NavBarBtns();
			this.dockManager1 = new DevExpress.XtraBars.Docking.DockManager();
			this.dpFilter = new DevExpress.XtraBars.Docking.DockPanel();
			this.dockPanel1_Container = new DevExpress.XtraBars.Docking.ControlContainer();
			this.label4 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.btnSearch = new DevExpress.XtraEditors.SimpleButton();
			this.fchkDateIssue = new DevExpress.XtraEditors.CheckEdit();
			this.fchkDatePay = new DevExpress.XtraEditors.CheckEdit();
			this.fchkAuthDate = new DevExpress.XtraEditors.CheckEdit();
			this.fchkAuthor = new DevExpress.XtraEditors.CheckEdit();
			this.fchkPaperPerNum = new DevExpress.XtraEditors.CheckEdit();
			this.fchkPaperSpace = new DevExpress.XtraEditors.CheckEdit();
			this.fchkAdvContent = new DevExpress.XtraEditors.CheckEdit();
			this.fchkColor = new DevExpress.XtraEditors.CheckEdit();
			this.fchkPayUnit = new DevExpress.XtraEditors.CheckEdit();
			this.fchkAuthContent = new DevExpress.XtraEditors.CheckEdit();
			this.txtDateIssue1 = new DevExpress.XtraEditors.DateEdit();
			this.txtAuthDate2 = new DevExpress.XtraEditors.DateEdit();
			this.txtPaperName = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtCode = new DevExpress.XtraEditors.TextEdit();
			this.txtDatePay1 = new DevExpress.XtraEditors.DateEdit();
			this.txtDatePay2 = new DevExpress.XtraEditors.DateEdit();
			this.txtInvoiceNum = new DevExpress.XtraEditors.TextEdit();
			this.txtDateIssue2 = new DevExpress.XtraEditors.DateEdit();
			this.txtAuthDate1 = new DevExpress.XtraEditors.DateEdit();
			this.txtPaperPerNum1 = new DevExpress.XtraEditors.SpinEdit();
			this.txtPaperPerNum2 = new DevExpress.XtraEditors.SpinEdit();
			this.fchkPaperName = new DevExpress.XtraEditors.CheckEdit();
			this.txtPaperSpaceNum = new DevExpress.XtraEditors.TextEdit();
			this.txtPaperSpace = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtColor = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtPayUnit = new DevExpress.XtraEditors.ComboBoxEdit();
			this.fchkClientType = new DevExpress.XtraEditors.CheckEdit();
			this.fchkClientCode = new DevExpress.XtraEditors.CheckEdit();
			this.txtClientType = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtAuthor = new DevExpress.XtraEditors.ComboBoxEdit();
			this.fchkPaperSpaceNum = new DevExpress.XtraEditors.CheckEdit();
			this.fchkMemo = new DevExpress.XtraEditors.CheckEdit();
			this.txtAdvContent = new DevExpress.XtraEditors.TextEdit();
			this.txtAuthContent = new DevExpress.XtraEditors.TextEdit();
			this.txtClientCode = new DevExpress.XtraEditors.TextEdit();
			this.fchkInvoiceNum = new DevExpress.XtraEditors.CheckEdit();
			this.fchkCode = new DevExpress.XtraEditors.CheckEdit();
			this.txtMemo = new DevExpress.XtraEditors.TextEdit();
			this.fchkOpUser = new DevExpress.XtraEditors.CheckEdit();
			this.txtOpUser = new DevExpress.XtraEditors.ComboBoxEdit();
			this.label2 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.txtIsAuth = new DevExpress.XtraEditors.ComboBoxEdit();
			this.fchkIsAuth = new DevExpress.XtraEditors.CheckEdit();
			this.txtIsPay = new DevExpress.XtraEditors.ComboBoxEdit();
			this.fchkIsPay = new DevExpress.XtraEditors.CheckEdit();
			this.txtPayType = new DevExpress.XtraEditors.ComboBoxEdit();
			this.fchkPayType = new DevExpress.XtraEditors.CheckEdit();
			this.fchkInvoice = new DevExpress.XtraEditors.CheckEdit();
			this.label5 = new System.Windows.Forms.Label();
			this.txtReportModel = new DevExpress.XtraEditors.ComboBoxEdit();
			this.btnModelDelete = new DevExpress.XtraEditors.SimpleButton();
			this.btnModelSaveAs = new DevExpress.XtraEditors.SimpleButton();
			this.mainPanel.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.gcAdv)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.wwamds1)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.gvAdv)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dockManager1)).BeginInit();
			this.dpFilter.SuspendLayout();
			this.dockPanel1_Container.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.fchkDateIssue.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkDatePay.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkAuthDate.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkAuthor.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkPaperPerNum.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkPaperSpace.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkAdvContent.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkColor.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkPayUnit.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkAuthContent.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtDateIssue1.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtAuthDate2.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperName.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtCode.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtDatePay1.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtDatePay2.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtInvoiceNum.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtDateIssue2.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtAuthDate1.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperPerNum1.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperPerNum2.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.fchkPaperName.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperSpaceNum.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperSpace.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtColor.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPayUnit.Properties)).BeginInit();