childmgrinfo.cs

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

			this.gcolClientMemo.Name = "gcolClientMemo";
			this.gcolClientMemo.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
			this.gcolClientMemo.OptionsColumn.ReadOnly = true;
			this.gcolClientMemo.Visible = true;
			this.gcolClientMemo.VisibleIndex = 7;
			this.gcolClientMemo.Width = 146;
			// 
			// nbbClient
			// 
			this.nbbClient.BtnImgAppend = ((System.Drawing.Image)(resources.GetObject("nbbClient.BtnImgAppend")));
			this.nbbClient.BtnImgDelete = ((System.Drawing.Image)(resources.GetObject("nbbClient.BtnImgDelete")));
			this.nbbClient.BtnImgEdit = ((System.Drawing.Image)(resources.GetObject("nbbClient.BtnImgEdit")));
			this.nbbClient.BtnImgExcel = ((System.Drawing.Image)(resources.GetObject("nbbClient.BtnImgExcel")));
			this.nbbClient.BtnImgFind = ((System.Drawing.Image)(resources.GetObject("nbbClient.BtnImgFind")));
			this.nbbClient.BtnImgPrint = ((System.Drawing.Image)(resources.GetObject("nbbClient.BtnImgPrint")));
			this.nbbClient.BtnImgRefresh = ((System.Drawing.Image)(resources.GetObject("nbbClient.BtnImgRefresh")));
			this.nbbClient.GridCtrl = this.gcClient;
			this.nbbClient.Location = new System.Drawing.Point(120, 8);
			this.nbbClient.Name = "nbbClient";
			this.nbbClient.Size = new System.Drawing.Size(138, 28);
			this.nbbClient.TabIndex = 2;
			this.nbbClient.ClickButton += new WWAM.BLL.NavBarBtns.ButtonEventHandler(this.nbbClient_ClickButton);
			// 
			// gcClientType
			// 
			this.gcClientType.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
				| System.Windows.Forms.AnchorStyles.Left)));
			this.gcClientType.DataSource = this.wwamds1.bType;
			// 
			// gcClientType.EmbeddedNavigator
			// 
			this.gcClientType.EmbeddedNavigator.Buttons.Append.Visible = false;
			this.gcClientType.EmbeddedNavigator.Buttons.CancelEdit.Visible = false;
			this.gcClientType.EmbeddedNavigator.Buttons.Edit.Visible = false;
			this.gcClientType.EmbeddedNavigator.Buttons.EndEdit.Visible = false;
			this.gcClientType.EmbeddedNavigator.Buttons.NextPage.Visible = false;
			this.gcClientType.EmbeddedNavigator.Buttons.PrevPage.Visible = false;
			this.gcClientType.EmbeddedNavigator.Buttons.Remove.Visible = false;
			this.gcClientType.EmbeddedNavigator.Name = "";
			this.gcClientType.EmbeddedNavigator.TextStringFormat = "{0}/{1}";
			this.gcClientType.Location = new System.Drawing.Point(8, 40);
			this.gcClientType.MainView = this.gvClientType;
			this.gcClientType.Name = "gcClientType";
			this.gcClientType.Size = new System.Drawing.Size(104, 304);
			this.gcClientType.TabIndex = 1;
			this.gcClientType.Tag = "";
			this.gcClientType.UseEmbeddedNavigator = true;
			this.gcClientType.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
																										this.gvClientType});
			// 
			// gvClientType
			// 
			this.gvClientType.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
																								this.gcolClientType_Code});
			this.gvClientType.GridControl = this.gcClientType;
			this.gvClientType.Name = "gvClientType";
			this.gvClientType.OptionsMenu.EnableFooterMenu = false;
			this.gvClientType.OptionsMenu.EnableGroupPanelMenu = false;
			this.gvClientType.OptionsView.ShowGroupPanel = false;
			this.gvClientType.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(this.gvClientType_FocusedRowChanged);
			// 
			// gcolClientType_Code
			// 
			this.gcolClientType_Code.Caption = "客户分类";
			this.gcolClientType_Code.FieldName = "Code";
			this.gcolClientType_Code.Name = "gcolClientType_Code";
			this.gcolClientType_Code.OptionsColumn.AllowEdit = false;
			this.gcolClientType_Code.OptionsFilter.AllowFilter = false;
			this.gcolClientType_Code.Visible = true;
			this.gcolClientType_Code.VisibleIndex = 0;
			this.gcolClientType_Code.Width = 136;
			// 
			// pagePaper
			// 
			this.pagePaper.Controls.Add(this.txtTypeName);
			this.pagePaper.Controls.Add(this.nbbPaper);
			this.pagePaper.Controls.Add(this.gcType);
			this.pagePaper.Name = "pagePaper";
			this.pagePaper.Size = new System.Drawing.Size(543, 351);
			this.pagePaper.Text = "基本资料";
			// 
			// txtTypeName
			// 
			this.txtTypeName.Location = new System.Drawing.Point(184, 12);
			this.txtTypeName.Name = "txtTypeName";
			// 
			// txtTypeName.Properties
			// 
			this.txtTypeName.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
																												new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
			this.txtTypeName.Size = new System.Drawing.Size(152, 21);
			this.txtTypeName.TabIndex = 4;
			this.txtTypeName.EditValueChanged += new System.EventHandler(this.txtTypeName_EditValueChanged);
			// 
			// nbbPaper
			// 
			this.nbbPaper.BtnImgAppend = ((System.Drawing.Image)(resources.GetObject("nbbPaper.BtnImgAppend")));
			this.nbbPaper.BtnImgDelete = ((System.Drawing.Image)(resources.GetObject("nbbPaper.BtnImgDelete")));
			this.nbbPaper.BtnImgEdit = ((System.Drawing.Image)(resources.GetObject("nbbPaper.BtnImgEdit")));
			this.nbbPaper.BtnImgExcel = ((System.Drawing.Image)(resources.GetObject("nbbPaper.BtnImgExcel")));
			this.nbbPaper.BtnImgFind = ((System.Drawing.Image)(resources.GetObject("nbbPaper.BtnImgFind")));
			this.nbbPaper.BtnImgPrint = ((System.Drawing.Image)(resources.GetObject("nbbPaper.BtnImgPrint")));
			this.nbbPaper.BtnImgRefresh = ((System.Drawing.Image)(resources.GetObject("nbbPaper.BtnImgRefresh")));
			this.nbbPaper.ButtonFind = false;
			this.nbbPaper.GridCtrl = this.gcType;
			this.nbbPaper.Location = new System.Drawing.Point(8, 8);
			this.nbbPaper.Name = "nbbPaper";
			this.nbbPaper.Size = new System.Drawing.Size(116, 28);
			this.nbbPaper.TabIndex = 3;
			this.nbbPaper.ClickButton += new WWAM.BLL.NavBarBtns.ButtonEventHandler(this.nbbPaper_ClickButton);
			// 
			// gcType
			// 
			this.gcType.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.gcType.DataSource = this.wwamds1.bType;
			// 
			// gcType.EmbeddedNavigator
			// 
			this.gcType.EmbeddedNavigator.Buttons.Append.Visible = false;
			this.gcType.EmbeddedNavigator.Buttons.CancelEdit.Visible = false;
			this.gcType.EmbeddedNavigator.Buttons.Edit.Visible = false;
			this.gcType.EmbeddedNavigator.Buttons.EndEdit.Visible = false;
			this.gcType.EmbeddedNavigator.Buttons.NextPage.Visible = false;
			this.gcType.EmbeddedNavigator.Buttons.PrevPage.Visible = false;
			this.gcType.EmbeddedNavigator.Buttons.Remove.Visible = false;
			this.gcType.EmbeddedNavigator.Name = "";
			this.gcType.EmbeddedNavigator.TextStringFormat = "第 {0} 条 / 共 {1} 条";
			this.gcType.Location = new System.Drawing.Point(8, 40);
			this.gcType.MainView = this.gvType;
			this.gcType.Name = "gcType";
			this.gcType.Size = new System.Drawing.Size(528, 304);
			this.gcType.TabIndex = 2;
			this.gcType.UseEmbeddedNavigator = true;
			this.gcType.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
																								  this.gvType});
			// 
			// gvType
			// 
			this.gvType.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
																						  this.gcolType_Code,
																						  this.gcolType_Memo});
			this.gvType.GridControl = this.gcType;
			this.gvType.Name = "gvType";
			this.gvType.OptionsMenu.EnableFooterMenu = false;
			this.gvType.OptionsMenu.EnableGroupPanelMenu = false;
			this.gvType.OptionsView.ShowGroupPanel = false;
			// 
			// gcolType_Code
			// 
			this.gcolType_Code.FieldName = "Code";
			this.gcolType_Code.Name = "gcolType_Code";
			this.gcolType_Code.OptionsColumn.ReadOnly = true;
			this.gcolType_Code.Visible = true;
			this.gcolType_Code.VisibleIndex = 0;
			this.gcolType_Code.Width = 158;
			// 
			// gcolType_Memo
			// 
			this.gcolType_Memo.Caption = "备注";
			this.gcolType_Memo.FieldName = "Memo";
			this.gcolType_Memo.Name = "gcolType_Memo";
			this.gcolType_Memo.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
			this.gcolType_Memo.OptionsColumn.ReadOnly = true;
			this.gcolType_Memo.OptionsFilter.AllowFilter = false;
			this.gcolType_Memo.Visible = true;
			this.gcolType_Memo.VisibleIndex = 1;
			this.gcolType_Memo.Width = 349;
			// 
			// ChildMgrInfo
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(552, 382);
			this.Controls.Add(this.mainTabPages);
			this.Name = "ChildMgrInfo";
			this.Controls.SetChildIndex(this.mainTabPages, 0);
			this.Controls.SetChildIndex(this.btnClose, 0);
			((System.ComponentModel.ISupportInitialize)(this.mainTabPages)).EndInit();
			this.mainTabPages.ResumeLayout(false);
			this.pageClient.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.chkAllType.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.gcClient)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.wwamds1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.gvClient)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.gcClientType)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.gvClientType)).EndInit();
			this.pagePaper.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.txtTypeName.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.gcType)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.gvType)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion
		#endregion
		
		#region From Event
		protected override void OnFormLoad()
		{
			base.OnFormLoad ();
			this.txtTypeName_DataBind(this.BaseDB.RunCmdGetTable("select * from bTypeName",0));
			this.dlgClient = new WWAM.Forms.Dlg.DlgDataClient(this);
			this.dlgType = new WWAM.Forms.Dlg.DlgDataType(this);
			this.setLayoutFileName("Client");
			this.ViewLoadLayout(this.gvClient);
		}
		protected override void OnFormClose()
		{
			this.ViewSaveLayout(this.gvClient);
		}
		protected override void OnFormShow()
		{
			base.OnFormShow ();
		}
		protected override void DataRefresh()
		{
			this.Cursor = Cursors.WaitCursor;
			if(this.CurrentPageIndex == 0)
			{
				this.gcClientType.DataSource = this.BaseDB.RunCmdGetTable("select * from bType where Type = 5",0);
				dtClient = this.BaseDB.RunCmdGetTable("select * from iClient",0);
				this.gcClient.DataSource = dtClient;
				this.gcClient_DataSoureSetFilter();
			}
			else
			{
				this.gcType.DataSource = this.BaseDB.RunCmdGetTable("select * from bType",0);
				this.gcType_DataSourceSetFilter();
			}
			this.Cursor = Cursors.Arrow;
		}
		#endregion

		#region Varible && Property
		Dlg.DlgDataType dlgType;
		Dlg.DlgDataClient dlgClient;
		DataTable dtClient;
		DataRow drType
		{
			get
			{
				return this.gvType.GetDataRow(this.gvType.FocusedRowHandle);
			}
		}
		DataRow drClientType
		{
			get
			{
				return this.gvClientType.GetDataRow(this.gvClientType.FocusedRowHandle);
			}
		}
		DataRow drClient
		{
			get
			{
				return this.gvClient.GetDataRow(this.gvClient.FocusedRowHandle);
			}
		}
		DataTable dtType
		{
			get
			{
				return (DataTable)this.gcType.DataSource;
			}
		}
		DataTable dtClientType
		{
			get
			{
				return (DataTable)this.gcClientType.DataSource;
			}
		}
		int CurrentPageIndex
		{
			get
			{
				return this.mainTabPages.SelectedTabPageIndex;
			}
		}
		int CurrentType
		{
			get
			{
				if(this.txtTypeName.EditValue==null)
					return -1;
				else
					return (int)this.txtTypeName.EditValue;