private void AddPolicyToComboxBox(Infragistics.Win.UltraWinEditors.UltraComboEditor combo, Sql.Policy p)
        {
            ValueListItem item = new ValueListItem();

            item.DisplayText = "   " + GetDisplayNameForAssessmentInCombo(p);
            item.Tag         = item.Tag = p;
            combo.Items.Add(item);
        }
        private void AddCategoryToComboBox(Infragistics.Win.UltraWinEditors.UltraComboEditor combo, string category)
        {
            ValueListItem item = new ValueListItem();

            item.DisplayText = category;
            item.Tag         = null;
            item.Appearance.FontData.Bold = DefaultableBoolean.True;
            combo.Items.Add(item);
        }
Beispiel #3
0
        public void GTRLoadCombo(ref Infragistics.Win.UltraWinEditors.UltraComboEditor cbo, string sqlQuery, string DisplayMember, string ValueMember)
        {
            clsConnection clsCon = new clsConnection();

            try
            {
                System.Data.DataSet ds = new System.Data.DataSet();

                clsCon.GTRFillDatasetWithSQLCommand(ref ds, sqlQuery);
                cbo.DataSource = ds.Tables[0];

                cbo.DisplayMember = DisplayMember;
                cbo.ValueMember   = ValueMember;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                clsCon = null;
            }
        }
Beispiel #4
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     Infragistics.Win.UltraWinSchedule.CalendarCombo.DateButton dateButton1 = new Infragistics.Win.UltraWinSchedule.CalendarCombo.DateButton();
     this.ultraGroupBox1           = new Infragistics.Win.Misc.UltraGroupBox();
     this.btnModify                = new Infragistics.Win.Misc.UltraButton();
     this.ultraLabel9              = new Infragistics.Win.Misc.UltraLabel();
     this.cmbMemberRight           = new Infragistics.Win.UltraWinEditors.UltraComboEditor();
     this.cmbEndDate2              = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor();
     this.chkEndDate2              = new Infragistics.Win.UltraWinEditors.UltraCheckEditor();
     this.cmdBeginDate             = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor();
     this.chkBeginDate             = new Infragistics.Win.UltraWinEditors.UltraCheckEditor();
     this.cmbEndDate               = new Infragistics.Win.UltraWinSchedule.UltraCalendarCombo();
     this.chkEndDate               = new Infragistics.Win.UltraWinEditors.UltraCheckEditor();
     this.ultraLabel8              = new Infragistics.Win.Misc.UltraLabel();
     this.txtCustomerService       = new Infragistics.Win.UltraWinEditors.UltraTextEditor();
     this.ultraLabel7              = new Infragistics.Win.Misc.UltraLabel();
     this.txtSales                 = new Infragistics.Win.UltraWinEditors.UltraTextEditor();
     this.ultraLabel6              = new Infragistics.Win.Misc.UltraLabel();
     this.cmbTrade                 = new Infragistics.Win.UltraWinEditors.UltraComboEditor();
     this.ultraLabel5              = new Infragistics.Win.Misc.UltraLabel();
     this.cmbEnterpriseType        = new Infragistics.Win.UltraWinEditors.UltraComboEditor();
     this.ultraLabel3              = new Infragistics.Win.Misc.UltraLabel();
     this.ultraLabel2              = new Infragistics.Win.Misc.UltraLabel();
     this.ultraLabel1              = new Infragistics.Win.Misc.UltraLabel();
     this.btnQuery                 = new Infragistics.Win.Misc.UltraButton();
     this.txtPaperNo               = new Infragistics.Win.UltraWinEditors.UltraTextEditor();
     this.txtMemberName            = new Infragistics.Win.UltraWinEditors.UltraTextEditor();
     this.txtMemberCardNo          = new Infragistics.Win.UltraWinEditors.UltraTextEditor();
     this.ultraGrid1               = new Infragistics.Win.UltraWinGrid.UltraGrid();
     this.ultraGridPrintDocument1  = new Infragistics.Win.UltraWinGrid.UltraGridPrintDocument(this.components);
     this.ultraPrintPreviewDialog1 = new Infragistics.Win.Printing.UltraPrintPreviewDialog(this.components);
     this.saveFileDialog1          = new System.Windows.Forms.SaveFileDialog();
     this.ultraGridExcelExporter1  = new Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter(this.components);
     this.ultraGroupBox2           = new Infragistics.Win.Misc.UltraGroupBox();
     ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).BeginInit();
     this.ultraGroupBox1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.cmbMemberRight)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbEndDate2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdBeginDate)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbEndDate)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtCustomerService)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtSales)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbTrade)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbEnterpriseType)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtPaperNo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtMemberName)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtMemberCardNo)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox2)).BeginInit();
     this.ultraGroupBox2.SuspendLayout();
     this.SuspendLayout();
     //
     // ultraGroupBox1
     //
     this.ultraGroupBox1.Controls.Add(this.btnModify);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel9);
     this.ultraGroupBox1.Controls.Add(this.cmbMemberRight);
     this.ultraGroupBox1.Controls.Add(this.cmbEndDate2);
     this.ultraGroupBox1.Controls.Add(this.chkEndDate2);
     this.ultraGroupBox1.Controls.Add(this.cmdBeginDate);
     this.ultraGroupBox1.Controls.Add(this.chkBeginDate);
     this.ultraGroupBox1.Controls.Add(this.cmbEndDate);
     this.ultraGroupBox1.Controls.Add(this.chkEndDate);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel8);
     this.ultraGroupBox1.Controls.Add(this.txtCustomerService);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel7);
     this.ultraGroupBox1.Controls.Add(this.txtSales);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel6);
     this.ultraGroupBox1.Controls.Add(this.cmbTrade);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel5);
     this.ultraGroupBox1.Controls.Add(this.cmbEnterpriseType);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel3);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel2);
     this.ultraGroupBox1.Controls.Add(this.ultraLabel1);
     this.ultraGroupBox1.Controls.Add(this.btnQuery);
     this.ultraGroupBox1.Controls.Add(this.txtPaperNo);
     this.ultraGroupBox1.Controls.Add(this.txtMemberName);
     this.ultraGroupBox1.Controls.Add(this.txtMemberCardNo);
     this.ultraGroupBox1.Location = new System.Drawing.Point(16, 24);
     this.ultraGroupBox1.Name     = "ultraGroupBox1";
     this.ultraGroupBox1.Size     = new System.Drawing.Size(952, 160);
     this.ultraGroupBox1.TabIndex = 0;
     this.ultraGroupBox1.Click   += new System.EventHandler(this.ultraGroupBox1_Click);
     //
     // btnModify
     //
     this.btnModify.ButtonStyle = Infragistics.Win.UIElementButtonStyle.VisualStudio2005Button;
     this.btnModify.Location    = new System.Drawing.Point(728, 112);
     this.btnModify.Name        = "btnModify";
     this.btnModify.Size        = new System.Drawing.Size(75, 23);
     this.btnModify.TabIndex    = 37;
     this.btnModify.Text        = "修改";
     this.btnModify.Click      += new System.EventHandler(this.btnModify_Click);
     //
     // ultraLabel9
     //
     this.ultraLabel9.Location = new System.Drawing.Point(80, 112);
     this.ultraLabel9.Name     = "ultraLabel9";
     this.ultraLabel9.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel9.TabIndex = 36;
     this.ultraLabel9.Text     = "会员资格:";
     //
     // cmbMemberRight
     //
     this.cmbMemberRight.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.cmbMemberRight.Location     = new System.Drawing.Point(184, 112);
     this.cmbMemberRight.Name         = "cmbMemberRight";
     this.cmbMemberRight.Size         = new System.Drawing.Size(104, 21);
     this.cmbMemberRight.TabIndex     = 35;
     //
     // cmbEndDate2
     //
     this.cmbEndDate2.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.cmbEndDate2.Location     = new System.Drawing.Point(712, 80);
     this.cmbEndDate2.MaskInput    = "{date} {time}";
     this.cmbEndDate2.Name         = "cmbEndDate2";
     this.cmbEndDate2.Size         = new System.Drawing.Size(144, 21);
     this.cmbEndDate2.TabIndex     = 32;
     //
     // chkEndDate2
     //
     this.chkEndDate2.ButtonStyle = Infragistics.Win.UIElementButtonStyle.VisualStudio2005Button;
     this.chkEndDate2.GlyphStyle  = Infragistics.Win.GlyphStyle.Office2007;
     this.chkEndDate2.Location    = new System.Drawing.Point(592, 80);
     this.chkEndDate2.Name        = "chkEndDate2";
     this.chkEndDate2.Size        = new System.Drawing.Size(120, 20);
     this.chkEndDate2.TabIndex    = 34;
     this.chkEndDate2.Text        = "结束时间";
     //
     // cmdBeginDate
     //
     this.cmdBeginDate.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.cmdBeginDate.Location     = new System.Drawing.Point(712, 48);
     this.cmdBeginDate.MaskInput    = "{date} {time}";
     this.cmdBeginDate.Name         = "cmdBeginDate";
     this.cmdBeginDate.Size         = new System.Drawing.Size(144, 21);
     this.cmdBeginDate.TabIndex     = 31;
     //
     // chkBeginDate
     //
     this.chkBeginDate.ButtonStyle = Infragistics.Win.UIElementButtonStyle.VisualStudio2005Button;
     this.chkBeginDate.GlyphStyle  = Infragistics.Win.GlyphStyle.Office2007;
     this.chkBeginDate.Location    = new System.Drawing.Point(592, 48);
     this.chkBeginDate.Name        = "chkBeginDate";
     this.chkBeginDate.Size        = new System.Drawing.Size(120, 20);
     this.chkBeginDate.TabIndex    = 33;
     this.chkBeginDate.Text        = "开始时间";
     //
     // cmbEndDate
     //
     this.cmbEndDate.BackColor = System.Drawing.SystemColors.Window;
     this.cmbEndDate.DateButtons.Add(dateButton1);
     this.cmbEndDate.Location          = new System.Drawing.Point(712, 16);
     this.cmbEndDate.Name              = "cmbEndDate";
     this.cmbEndDate.NonAutoSizeHeight = 23;
     this.cmbEndDate.Size              = new System.Drawing.Size(144, 21);
     this.cmbEndDate.TabIndex          = 30;
     //
     // chkEndDate
     //
     this.chkEndDate.Location = new System.Drawing.Point(592, 16);
     this.chkEndDate.Name     = "chkEndDate";
     this.chkEndDate.Size     = new System.Drawing.Size(72, 20);
     this.chkEndDate.TabIndex = 29;
     this.chkEndDate.Text     = "到期时间";
     //
     // ultraLabel8
     //
     this.ultraLabel8.Location = new System.Drawing.Point(352, 112);
     this.ultraLabel8.Name     = "ultraLabel8";
     this.ultraLabel8.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel8.TabIndex = 28;
     this.ultraLabel8.Text     = "客服姓名:";
     //
     // txtCustomerService
     //
     this.txtCustomerService.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.txtCustomerService.Location     = new System.Drawing.Point(464, 112);
     this.txtCustomerService.Name         = "txtCustomerService";
     this.txtCustomerService.Size         = new System.Drawing.Size(100, 21);
     this.txtCustomerService.TabIndex     = 27;
     //
     // ultraLabel7
     //
     this.ultraLabel7.Location = new System.Drawing.Point(352, 80);
     this.ultraLabel7.Name     = "ultraLabel7";
     this.ultraLabel7.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel7.TabIndex = 26;
     this.ultraLabel7.Text     = "销售人员:";
     //
     // txtSales
     //
     this.txtSales.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.txtSales.Location     = new System.Drawing.Point(464, 80);
     this.txtSales.Name         = "txtSales";
     this.txtSales.Size         = new System.Drawing.Size(100, 21);
     this.txtSales.TabIndex     = 25;
     //
     // ultraLabel6
     //
     this.ultraLabel6.Location = new System.Drawing.Point(360, 48);
     this.ultraLabel6.Name     = "ultraLabel6";
     this.ultraLabel6.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel6.TabIndex = 24;
     this.ultraLabel6.Text     = "行业:";
     //
     // cmbTrade
     //
     this.cmbTrade.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.cmbTrade.Location     = new System.Drawing.Point(464, 48);
     this.cmbTrade.Name         = "cmbTrade";
     this.cmbTrade.Size         = new System.Drawing.Size(104, 21);
     this.cmbTrade.TabIndex     = 23;
     //
     // ultraLabel5
     //
     this.ultraLabel5.Location = new System.Drawing.Point(80, 80);
     this.ultraLabel5.Name     = "ultraLabel5";
     this.ultraLabel5.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel5.TabIndex = 22;
     this.ultraLabel5.Text     = "企业性质:";
     //
     // cmbEnterpriseType
     //
     this.cmbEnterpriseType.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.cmbEnterpriseType.Location     = new System.Drawing.Point(184, 80);
     this.cmbEnterpriseType.Name         = "cmbEnterpriseType";
     this.cmbEnterpriseType.Size         = new System.Drawing.Size(104, 21);
     this.cmbEnterpriseType.TabIndex     = 21;
     //
     // ultraLabel3
     //
     this.ultraLabel3.Location = new System.Drawing.Point(80, 48);
     this.ultraLabel3.Name     = "ultraLabel3";
     this.ultraLabel3.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel3.TabIndex = 18;
     this.ultraLabel3.Text     = "工商注册号:";
     //
     // ultraLabel2
     //
     this.ultraLabel2.Location = new System.Drawing.Point(360, 16);
     this.ultraLabel2.Name     = "ultraLabel2";
     this.ultraLabel2.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel2.TabIndex = 17;
     this.ultraLabel2.Text     = "单位名称:";
     //
     // ultraLabel1
     //
     this.ultraLabel1.Location = new System.Drawing.Point(80, 16);
     this.ultraLabel1.Name     = "ultraLabel1";
     this.ultraLabel1.Size     = new System.Drawing.Size(100, 23);
     this.ultraLabel1.TabIndex = 16;
     this.ultraLabel1.Text     = "会员卡号:";
     //
     // btnQuery
     //
     this.btnQuery.ButtonStyle = Infragistics.Win.UIElementButtonStyle.VisualStudio2005Button;
     this.btnQuery.Location    = new System.Drawing.Point(608, 112);
     this.btnQuery.Name        = "btnQuery";
     this.btnQuery.Size        = new System.Drawing.Size(75, 23);
     this.btnQuery.TabIndex    = 8;
     this.btnQuery.Text        = "查询";
     this.btnQuery.Click      += new System.EventHandler(this.btnQuery_Click);
     //
     // txtPaperNo
     //
     this.txtPaperNo.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.txtPaperNo.Location     = new System.Drawing.Point(184, 48);
     this.txtPaperNo.Name         = "txtPaperNo";
     this.txtPaperNo.Size         = new System.Drawing.Size(100, 21);
     this.txtPaperNo.TabIndex     = 5;
     //
     // txtMemberName
     //
     this.txtMemberName.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.txtMemberName.Location     = new System.Drawing.Point(464, 16);
     this.txtMemberName.Name         = "txtMemberName";
     this.txtMemberName.Size         = new System.Drawing.Size(100, 21);
     this.txtMemberName.TabIndex     = 3;
     //
     // txtMemberCardNo
     //
     this.txtMemberCardNo.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.VisualStudio2005;
     this.txtMemberCardNo.Location     = new System.Drawing.Point(184, 16);
     this.txtMemberCardNo.Name         = "txtMemberCardNo";
     this.txtMemberCardNo.Size         = new System.Drawing.Size(100, 21);
     this.txtMemberCardNo.TabIndex     = 1;
     //
     // ultraGrid1
     //
     this.ultraGrid1.DisplayLayout.BorderStyle = Infragistics.Win.UIElementBorderStyle.None;
     this.ultraGrid1.Location          = new System.Drawing.Point(72, 64);
     this.ultraGrid1.Name              = "ultraGrid1";
     this.ultraGrid1.Size              = new System.Drawing.Size(200, 80);
     this.ultraGrid1.TabIndex          = 1;
     this.ultraGrid1.Text              = "会员档案";
     this.ultraGrid1.InitializePrint  += new Infragistics.Win.UltraWinGrid.InitializePrintEventHandler(this.ultraGrid1_InitializePrint);
     this.ultraGrid1.InitializeLayout += new Infragistics.Win.UltraWinGrid.InitializeLayoutEventHandler(this.ultraGrid1_InitializeLayout);
     this.ultraGrid1.InitializeRow    += new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(this.ultraGrid1_InitializeRow);
     //
     // ultraPrintPreviewDialog1
     //
     this.ultraPrintPreviewDialog1.Name = "ultraPrintPreviewDialog1";
     //
     // ultraGroupBox2
     //
     this.ultraGroupBox2.Controls.Add(this.ultraGrid1);
     this.ultraGroupBox2.Location = new System.Drawing.Point(24, 200);
     this.ultraGroupBox2.Name     = "ultraGroupBox2";
     this.ultraGroupBox2.Size     = new System.Drawing.Size(976, 368);
     this.ultraGroupBox2.TabIndex = 2;
     //
     // MemberFreeModify
     //
     this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
     this.ClientSize        = new System.Drawing.Size(1016, 573);
     this.Controls.Add(this.ultraGroupBox2);
     this.Controls.Add(this.ultraGroupBox1);
     this.Name  = "MemberFreeModify";
     this.Text  = Login.constApp.strCardTypeL8Name + "会员免费场次修改";
     this.Load += new System.EventHandler(this.MemberFileQuery_Load);
     ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).EndInit();
     this.ultraGroupBox1.ResumeLayout(false);
     this.ultraGroupBox1.PerformLayout();
     ((System.ComponentModel.ISupportInitialize)(this.cmbMemberRight)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbEndDate2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmdBeginDate)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbEndDate)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtCustomerService)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtSales)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbTrade)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.cmbEnterpriseType)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtPaperNo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtMemberName)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.txtMemberCardNo)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox2)).EndInit();
     this.ultraGroupBox2.ResumeLayout(false);
     this.ResumeLayout(false);
 }