childadvmodel.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 ChildAdvModel : WWAM.Forms.Child.ChdBase
	{
		#region ChildAdvModel
		private System.Windows.Forms.Panel mainPanel;
		private DevExpress.XtraBars.Docking.DockManager dockManager1;
		private DevExpress.XtraGrid.GridControl gcAdvModel;
		private DevExpress.XtraBars.Docking.DockPanel dpDetail;
		private DevExpress.XtraBars.Docking.ControlContainer dockPanel1_Container;
		private WWAM.DBA.WWAMDS wwamds1;
		private DevExpress.XtraEditors.CheckEdit chkQuickAppend;
		private DevExpress.XtraEditors.ComboBoxEdit txtPaperName;
		private DevExpress.XtraEditors.SpinEdit txtPayNum;
		private DevExpress.XtraEditors.ComboBoxEdit txtPaperSpace;
		private DevExpress.XtraEditors.CalcEdit txtPaySum;
		private DevExpress.XtraEditors.ComboBoxEdit txtColor;
		private DevExpress.XtraEditors.CalcEdit txtPayPrice;
		private DevExpress.XtraEditors.TextEdit txtPaperSpaceNum;
		private DevExpress.XtraEditors.ComboBoxEdit txtPayUnit;
		private DevExpress.XtraEditors.TextEdit txtAdvSpec;
		private DevExpress.XtraEditors.MemoEdit txtMemo;
		private DevExpress.XtraEditors.TextEdit txtCode;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label1;
		private DevExpress.XtraGrid.Views.Grid.GridView gvAdvModel;
		private WWAM.BLL.NavBarBtns nbbAdvModel;
		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.XtraGrid.Columns.GridColumn colAdvSpec;
		private DevExpress.XtraGrid.Columns.GridColumn colColor;
		private DevExpress.XtraGrid.Columns.GridColumn colPayUnit;
		private System.Windows.Forms.Label label27;
		private DevExpress.XtraEditors.ComboBoxEdit ftxtPaperName;
		private System.ComponentModel.IContainer components = null;

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

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

		public ChildAdvModel(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(ChildAdvModel));
			this.mainPanel = new System.Windows.Forms.Panel();
			this.ftxtPaperName = new DevExpress.XtraEditors.ComboBoxEdit();
			this.label27 = new System.Windows.Forms.Label();
			this.chkQuickAppend = new DevExpress.XtraEditors.CheckEdit();
			this.gcAdvModel = new DevExpress.XtraGrid.GridControl();
			this.wwamds1 = new WWAM.DBA.WWAMDS();
			this.gvAdvModel = new DevExpress.XtraGrid.Views.Grid.GridView();
			this.colCode = 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.colPayUnit = new DevExpress.XtraGrid.Columns.GridColumn();
			this.nbbAdvModel = new WWAM.BLL.NavBarBtns();
			this.dockManager1 = new DevExpress.XtraBars.Docking.DockManager();
			this.dpDetail = new DevExpress.XtraBars.Docking.DockPanel();
			this.dockPanel1_Container = new DevExpress.XtraBars.Docking.ControlContainer();
			this.txtAdvSpec = new DevExpress.XtraEditors.TextEdit();
			this.txtMemo = new DevExpress.XtraEditors.MemoEdit();
			this.txtCode = new DevExpress.XtraEditors.TextEdit();
			this.txtPayUnit = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtColor = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtPayPrice = new DevExpress.XtraEditors.CalcEdit();
			this.txtPayNum = new DevExpress.XtraEditors.SpinEdit();
			this.txtPaperSpaceNum = new DevExpress.XtraEditors.TextEdit();
			this.txtPaperName = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtPaperSpace = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtPaySum = new DevExpress.XtraEditors.CalcEdit();
			this.label12 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.mainPanel.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.ftxtPaperName.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.chkQuickAppend.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.gcAdvModel)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.wwamds1)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.gvAdvModel)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dockManager1)).BeginInit();
			this.dpDetail.SuspendLayout();
			this.dockPanel1_Container.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.txtAdvSpec.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtMemo.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtCode.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPayUnit.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtColor.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPayPrice.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPayNum.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperSpaceNum.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperName.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaperSpace.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPaySum.Properties)).BeginInit();
			this.SuspendLayout();
			// 
			// btnClose
			// 
			this.btnClose.Name = "btnClose";
			// 
			// mainPanel
			// 
			this.mainPanel.Controls.Add(this.ftxtPaperName);
			this.mainPanel.Controls.Add(this.label27);
			this.mainPanel.Controls.Add(this.chkQuickAppend);
			this.mainPanel.Controls.Add(this.gcAdvModel);
			this.mainPanel.Controls.Add(this.nbbAdvModel);
			this.mainPanel.Dock = System.Windows.Forms.DockStyle.Fill;
			this.mainPanel.Location = new System.Drawing.Point(0, 0);
			this.mainPanel.Name = "mainPanel";
			this.mainPanel.Size = new System.Drawing.Size(552, 182);
			this.mainPanel.TabIndex = 7;
			// 
			// ftxtPaperName
			// 
			this.ftxtPaperName.EnterMoveNextControl = true;
			this.ftxtPaperName.Location = new System.Drawing.Point(312, 14);
			this.ftxtPaperName.Name = "ftxtPaperName";
			// 
			// ftxtPaperName.Properties
			// 
			this.ftxtPaperName.Properties.AppearanceFocused.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(224)), ((System.Byte)(192)));
			this.ftxtPaperName.Properties.AppearanceFocused.Options.UseBackColor = true;
			this.ftxtPaperName.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
																												  new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
			this.ftxtPaperName.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
			this.ftxtPaperName.Size = new System.Drawing.Size(144, 21);
			this.ftxtPaperName.TabIndex = 60;
			this.ftxtPaperName.EditValueChanged += new System.EventHandler(this.FilterControl_EditValueChanged);
			// 
			// label27
			// 
			this.label27.Location = new System.Drawing.Point(272, 14);
			this.label27.Name = "label27";
			this.label27.Size = new System.Drawing.Size(72, 23);
			this.label27.TabIndex = 61;
			this.label27.Text = "报刊：";
			this.label27.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// chkQuickAppend
			// 
			this.chkQuickAppend.Location = new System.Drawing.Point(190, 13);
			this.chkQuickAppend.Name = "chkQuickAppend";
			// 
			// chkQuickAppend.Properties
			// 
			this.chkQuickAppend.Properties.Caption = "连续添加";
			this.chkQuickAppend.Size = new System.Drawing.Size(74, 19);
			this.chkQuickAppend.TabIndex = 6;
			// 
			// gcAdvModel
			// 
			this.gcAdvModel.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
				| System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.gcAdvModel.DataSource = this.wwamds1.iAdvModel;
			// 
			// gcAdvModel.EmbeddedNavigator
			// 
			this.gcAdvModel.EmbeddedNavigator.Buttons.Append.Visible = false;
			this.gcAdvModel.EmbeddedNavigator.Buttons.CancelEdit.Visible = false;
			this.gcAdvModel.EmbeddedNavigator.Buttons.Edit.Visible = false;
			this.gcAdvModel.EmbeddedNavigator.Buttons.EndEdit.Visible = false;
			this.gcAdvModel.EmbeddedNavigator.Buttons.NextPage.Visible = false;
			this.gcAdvModel.EmbeddedNavigator.Buttons.PrevPage.Visible = false;
			this.gcAdvModel.EmbeddedNavigator.Buttons.Remove.Visible = false;
			this.gcAdvModel.EmbeddedNavigator.Name = "";
			this.gcAdvModel.EmbeddedNavigator.TextStringFormat = "第 {0} 条 / 共 {1} 条";
			this.gcAdvModel.Location = new System.Drawing.Point(16, 40);
			this.gcAdvModel.MainView = this.gvAdvModel;
			this.gcAdvModel.Name = "gcAdvModel";
			this.gcAdvModel.Size = new System.Drawing.Size(528, 134);
			this.gcAdvModel.TabIndex = 5;
			this.gcAdvModel.UseEmbeddedNavigator = true;
			this.gcAdvModel.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
																									  this.gvAdvModel});
			// 
			// wwamds1
			// 
			this.wwamds1.DataSetName = "WWAMDS";
			this.wwamds1.Locale = new System.Globalization.CultureInfo("en-US");
			// 
			// gvAdvModel
			// 
			this.gvAdvModel.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
																							  this.colCode,
																							  this.colPaperName,
																							  this.colPaperSpaceNum,
																							  this.colPaperSpace,
																							  this.colAdvSpec,
																							  this.colColor,
																							  this.colPayUnit});
			this.gvAdvModel.GridControl = this.gcAdvModel;
			this.gvAdvModel.Name = "gvAdvModel";
			this.gvAdvModel.OptionsBehavior.Editable = false;
			this.gvAdvModel.OptionsCustomization.AllowFilter = false;
			this.gvAdvModel.OptionsMenu.EnableFooterMenu = false;
			this.gvAdvModel.OptionsMenu.EnableGroupPanelMenu = false;
			this.gvAdvModel.OptionsView.ColumnAutoWidth = false;
			this.gvAdvModel.OptionsView.ShowGroupPanel = false;
			this.gvAdvModel.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(this.gvAdvMdoel_FocusedRowChanged);
			this.gvAdvModel.Layout += new System.EventHandler(this.View_Layout);
			// 
			// colCode
			// 
			this.colCode.Caption = "模版编号";
			this.colCode.FieldName = "Code";
			this.colCode.Name = "colCode";
			this.colCode.Visible = true;
			this.colCode.VisibleIndex = 0;
			this.colCode.Width = 86;
			// 
			// colPaperName
			// 
			this.colPaperName.Caption = "报刊名称";
			this.colPaperName.FieldName = "PaperName";
			this.colPaperName.Name = "colPaperName";
			this.colPaperName.Width = 106;
			// 
			// colPaperSpaceNum
			// 
			this.colPaperSpaceNum.Caption = "版号";
			this.colPaperSpaceNum.FieldName = "PaperSpaceNum";
			this.colPaperSpaceNum.Name = "colPaperSpaceNum";
			this.colPaperSpaceNum.Visible = true;
			this.colPaperSpaceNum.VisibleIndex = 1;
			this.colPaperSpaceNum.Width = 59;
			// 
			// colPaperSpace
			// 
			this.colPaperSpace.Caption = "版面";
			this.colPaperSpace.FieldName = "PaperSpace";
			this.colPaperSpace.Name = "colPaperSpace";
			this.colPaperSpace.Visible = true;
			this.colPaperSpace.VisibleIndex = 2;
			this.colPaperSpace.Width = 100;
			// 
			// colAdvSpec
			// 
			this.colAdvSpec.Caption = "规格";
			this.colAdvSpec.FieldName = "AdvSpec";
			this.colAdvSpec.Name = "colAdvSpec";
			this.colAdvSpec.Visible = true;
			this.colAdvSpec.VisibleIndex = 3;
			this.colAdvSpec.Width = 142;
			// 
			// colColor
			// 
			this.colColor.Caption = "色彩";
			this.colColor.FieldName = "Color";
			this.colColor.Name = "colColor";
			this.colColor.Visible = true;
			this.colColor.VisibleIndex = 4;
			this.colColor.Width = 69;