public void Form1_Load(object sender, EventArgs e) { DataGridViewCheckBoxColumn column0 = new DataGridViewCheckBoxColumn(); DataGridViewDisableButtonColumn column1 = new DataGridViewDisableButtonColumn(); column0.Name = "CheckBoxes"; column1.Name = "Buttons"; dataGridView1.Columns.Add(column0); dataGridView1.Columns.Add(column1); dataGridView1.RowCount = 8; dataGridView1.AutoSize = true; dataGridView1.AllowUserToAddRows = false; dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; // Set the text for each button. for (int i = 0; i < dataGridView1.RowCount; i++) { dataGridView1.Rows[i].Cells["Buttons"].Value = "Button " + i.ToString(); } dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellValueChanged); dataGridView1.CurrentCellDirtyStateChanged += new EventHandler(dataGridView1_CurrentCellDirtyStateChanged); dataGridView1.CellClick += new DataGridViewCellEventHandler(dataGridView1_CellClick); this.Controls.Add(dataGridView1); }
private void InitializeComponent() { this.components = (IContainer) new Container(); ComponentResourceManager componentResourceManager = new ComponentResourceManager(typeof(CQGInstruments)); this.lwInstruments = new DataGridView(); this.InstrumentId = new DataGridViewTextBoxColumn(); this.InstrumentName = new DataGridViewTextBoxColumn(); this.Active = new DataGridViewCheckBoxColumn(); this.scrollTimer = new Timer(this.components); this.panel2 = new Panel(); this.scrollPanel = new Panel(); this.bDown = new Button(); this.btScroll = new Button(); this.bUp = new Button(); this.panel4 = new Panel(); this.panel6 = new Panel(); this.panel7 = new Panel(); this.panel5 = new Panel(); this.label4 = new Label(); this.bSubmit = new Button(); this.tbInstrumentId = new TextBox(); this.button3 = new Button(); this.lInstumentId = new Label(); this.button1 = new Button(); this.button4 = new Button(); this.button2 = new Button(); this.label7 = new Label(); this.linkLabel1 = new LinkLabel(); this.label6 = new Label(); this.button8 = new Button(); this.label3 = new Label(); this.pictureBox2 = new PictureBox(); this.button5 = new Button(); this.button6 = new Button(); ((ISupportInitialize)this.lwInstruments).BeginInit(); this.panel2.SuspendLayout(); this.scrollPanel.SuspendLayout(); ((ISupportInitialize)this.pictureBox2).BeginInit(); this.SuspendLayout(); this.lwInstruments.AllowUserToAddRows = false; this.lwInstruments.BackgroundColor = Color.FromArgb(0, 22, 54); this.lwInstruments.BorderStyle = BorderStyle.None; this.lwInstruments.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.lwInstruments.ColumnHeadersVisible = false; this.lwInstruments.Columns.AddRange((DataGridViewColumn)this.InstrumentId, (DataGridViewColumn)this.InstrumentName, (DataGridViewColumn)this.Active); this.lwInstruments.GridColor = Color.FromArgb(0, 43, 73); this.lwInstruments.Location = new Point(6, 154); this.lwInstruments.Name = "lwInstruments"; this.lwInstruments.RowHeadersVisible = false; this.lwInstruments.RowTemplate.DefaultCellStyle.BackColor = Color.FromArgb(0, 22, 54); this.lwInstruments.RowTemplate.DefaultCellStyle.ForeColor = Color.White; this.lwInstruments.RowTemplate.DefaultCellStyle.SelectionBackColor = Color.FromArgb(73, 138, 243); this.lwInstruments.RowTemplate.DefaultCellStyle.SelectionForeColor = Color.White; this.lwInstruments.ScrollBars = ScrollBars.None; this.lwInstruments.Size = new Size(293, 372); this.lwInstruments.TabIndex = 72; this.InstrumentId.HeaderText = "Id"; this.InstrumentId.Name = "InstrumentId"; this.InstrumentId.Visible = false; this.InstrumentName.HeaderText = "Instrument Name"; this.InstrumentName.Name = "InstrumentName"; this.InstrumentName.ReadOnly = true; this.InstrumentName.Width = 200; this.Active.HeaderText = "Active"; this.Active.Name = "Active"; this.Active.Width = 80; this.scrollTimer.Tick += new EventHandler(this.scrollTimer_Tick); this.panel2.BackColor = Color.Black; this.panel2.BackgroundImage = (Image)Resources.lm16553; this.panel2.BackgroundImageLayout = ImageLayout.Center; this.panel2.Controls.Add((Control)this.scrollPanel); this.panel2.Controls.Add((Control)this.panel4); this.panel2.Controls.Add((Control)this.panel6); this.panel2.Controls.Add((Control)this.panel7); this.panel2.Controls.Add((Control)this.panel5); this.panel2.Controls.Add((Control)this.label4); this.panel2.Controls.Add((Control)this.bSubmit); this.panel2.Controls.Add((Control)this.tbInstrumentId); this.panel2.Controls.Add((Control)this.button3); this.panel2.Controls.Add((Control)this.lInstumentId); this.panel2.Controls.Add((Control)this.button1); this.panel2.Controls.Add((Control)this.button4); this.panel2.Controls.Add((Control)this.button2); this.panel2.Controls.Add((Control)this.label7); this.panel2.Controls.Add((Control)this.linkLabel1); this.panel2.Controls.Add((Control)this.label6); this.panel2.Controls.Add((Control)this.button8); this.panel2.Controls.Add((Control)this.label3); this.panel2.Controls.Add((Control)this.pictureBox2); this.panel2.Controls.Add((Control)this.button5); this.panel2.Controls.Add((Control)this.button6); this.panel2.Location = new Point(0, 0); this.panel2.Name = "panel2"; this.panel2.Size = new Size(330, 678); this.panel2.TabIndex = 66; this.panel2.MouseDown += new MouseEventHandler(this.panel2_MouseDown); this.panel2.MouseMove += new MouseEventHandler(this.panel2_MouseMove); this.scrollPanel.BackColor = Color.FromArgb(0, 22, 54); this.scrollPanel.Controls.Add((Control)this.bDown); this.scrollPanel.Controls.Add((Control)this.btScroll); this.scrollPanel.Controls.Add((Control)this.bUp); this.scrollPanel.Location = new Point(302, 137); this.scrollPanel.Name = "scrollPanel"; this.scrollPanel.Size = new Size(25, 397); this.scrollPanel.TabIndex = 93; this.scrollPanel.MouseDown += new MouseEventHandler(this.scrollPanel_MouseDown); this.bDown.BackColor = Color.FromArgb(0, 77, 111); this.bDown.BackgroundImage = (Image)Resources.ScrollDn; this.bDown.Cursor = Cursors.Hand; this.bDown.FlatAppearance.BorderSize = 0; this.bDown.FlatStyle = FlatStyle.Flat; this.bDown.ForeColor = Color.White; this.bDown.Location = new Point(3, 373); this.bDown.Name = "bDown"; this.bDown.Size = new Size(20, 21); this.bDown.TabIndex = 4; this.bDown.UseVisualStyleBackColor = false; this.bDown.Click += new EventHandler(this.bDown_Click); this.bDown.MouseDown += new MouseEventHandler(this.bDown_MouseDown); this.bDown.MouseLeave += new EventHandler(this.bDown_MouseLeave); this.bDown.MouseMove += new MouseEventHandler(this.bDown_MouseMove); this.bDown.MouseUp += new MouseEventHandler(this.bDown_MouseUp); this.btScroll.BackColor = Color.FromArgb(0, 77, 111); this.btScroll.BackgroundImage = (Image)Resources.Scroll; this.btScroll.Cursor = Cursors.Hand; this.btScroll.FlatAppearance.BorderSize = 0; this.btScroll.FlatStyle = FlatStyle.Flat; this.btScroll.Location = new Point(3, 25); this.btScroll.Name = "btScroll"; this.btScroll.Size = new Size(20, 42); this.btScroll.TabIndex = 3; this.btScroll.UseVisualStyleBackColor = false; this.btScroll.MouseDown += new MouseEventHandler(this.btScroll_MouseDown); this.btScroll.MouseLeave += new EventHandler(this.btScroll_MouseLeave); this.btScroll.MouseMove += new MouseEventHandler(this.btScroll_MouseMove); this.btScroll.MouseUp += new MouseEventHandler(this.btScroll_MouseUp); this.bUp.BackColor = Color.FromArgb(0, 77, 111); this.bUp.BackgroundImage = (Image)Resources.ScrollUp; this.bUp.Cursor = Cursors.Hand; this.bUp.FlatAppearance.BorderSize = 0; this.bUp.FlatStyle = FlatStyle.Flat; this.bUp.ForeColor = Color.White; this.bUp.Location = new Point(3, 2); this.bUp.Name = "bUp"; this.bUp.Size = new Size(20, 21); this.bUp.TabIndex = 1; this.bUp.UseVisualStyleBackColor = false; this.bUp.Click += new EventHandler(this.bUp_Click); this.bUp.MouseDown += new MouseEventHandler(this.bUp_MouseDown); this.bUp.MouseLeave += new EventHandler(this.bUp_MouseLeave); this.bUp.MouseMove += new MouseEventHandler(this.bUp_MouseMove); this.bUp.MouseUp += new MouseEventHandler(this.bUp_MouseUp); this.panel4.BackColor = Color.Gold; this.panel4.BackgroundImageLayout = ImageLayout.Stretch; this.panel4.Location = new Point(329, -8); this.panel4.Name = "panel4"; this.panel4.Size = new Size(31, 692); this.panel4.TabIndex = 90; this.panel6.BackColor = Color.Gold; this.panel6.BackgroundImageLayout = ImageLayout.Stretch; this.panel6.Location = new Point(-6, 677); this.panel6.Name = "panel6"; this.panel6.Size = new Size(362, 10); this.panel6.TabIndex = 88; this.panel7.BackColor = Color.Gold; this.panel7.BackgroundImageLayout = ImageLayout.Stretch; this.panel7.Location = new Point(-10, -9); this.panel7.Name = "panel7"; this.panel7.Size = new Size(362, 10); this.panel7.TabIndex = 89; this.panel5.BackColor = Color.Gold; this.panel5.BackgroundImageLayout = ImageLayout.Stretch; this.panel5.Location = new Point(-30, -5); this.panel5.Name = "panel5"; this.panel5.Size = new Size(31, 692); this.panel5.TabIndex = 91; this.label4.AutoSize = true; this.label4.BackColor = Color.Transparent; this.label4.Font = new Font("Microsoft Sans Serif", 8.25f, FontStyle.Regular, GraphicsUnit.Point, (byte)204); this.label4.ForeColor = Color.Gold; this.label4.Location = new Point(11, 632); this.label4.Name = "label4"; this.label4.Size = new Size(239, 39); this.label4.TabIndex = 84; this.label4.Text = "For add new instrument in list, enter Instrument ID\r\nNext Click \"Send\" button. \r\nFor Example: Instrument ID: X.US.DREURUSD"; this.bSubmit.BackColor = Color.Transparent; this.bSubmit.BackgroundImage = (Image)componentResourceManager.GetObject("bSubmit.BackgroundImage"); this.bSubmit.BackgroundImageLayout = ImageLayout.Stretch; this.bSubmit.Cursor = Cursors.Hand; this.bSubmit.FlatAppearance.BorderSize = 0; this.bSubmit.FlatAppearance.CheckedBackColor = Color.Transparent; this.bSubmit.FlatAppearance.MouseDownBackColor = Color.Transparent; this.bSubmit.FlatAppearance.MouseOverBackColor = Color.Transparent; this.bSubmit.FlatStyle = FlatStyle.Flat; this.bSubmit.Font = new Font("Arial", 12f); this.bSubmit.ForeColor = Color.White; this.bSubmit.Location = new Point(222, 598); this.bSubmit.Name = "bSubmit"; this.bSubmit.Size = new Size(101, 28); this.bSubmit.TabIndex = 64; this.bSubmit.Text = "Send"; this.bSubmit.UseVisualStyleBackColor = false; this.bSubmit.Click += new EventHandler(this.bSubmit_Click); this.bSubmit.MouseLeave += new EventHandler(this.bSubmit_MouseLeave); this.bSubmit.MouseMove += new MouseEventHandler(this.bSubmit_MouseMove); this.tbInstrumentId.BackColor = Color.FromArgb(0, 22, 54); this.tbInstrumentId.BorderStyle = BorderStyle.None; this.tbInstrumentId.ForeColor = Color.White; this.tbInstrumentId.Location = new Point(98, 606); this.tbInstrumentId.Name = "tbInstrumentId"; this.tbInstrumentId.Size = new Size(115, 13); this.tbInstrumentId.TabIndex = 63; this.tbInstrumentId.Text = "X.US.DREURUSD"; this.button3.BackColor = Color.Transparent; this.button3.BackgroundImage = (Image)componentResourceManager.GetObject("button3.BackgroundImage"); this.button3.BackgroundImageLayout = ImageLayout.Stretch; this.button3.Cursor = Cursors.Hand; this.button3.FlatAppearance.BorderSize = 0; this.button3.FlatAppearance.CheckedBackColor = Color.Transparent; this.button3.FlatAppearance.MouseDownBackColor = Color.Transparent; this.button3.FlatAppearance.MouseOverBackColor = Color.Transparent; this.button3.FlatStyle = FlatStyle.Flat; this.button3.Font = new Font("Arial", 12f, FontStyle.Regular, GraphicsUnit.Point, (byte)204); this.button3.ForeColor = Color.White; this.button3.Location = new Point(8, 552); this.button3.Name = "button3"; this.button3.Size = new Size(101, 28); this.button3.TabIndex = 77; this.button3.Text = "Select All"; this.button3.UseVisualStyleBackColor = false; this.button3.Click += new EventHandler(this.button3_Click); this.button3.MouseLeave += new EventHandler(this.button3_MouseLeave); this.button3.MouseMove += new MouseEventHandler(this.button3_MouseMove); this.lInstumentId.AutoSize = true; this.lInstumentId.BackColor = Color.Transparent; this.lInstumentId.Font = new Font("Arial", 9.75f, FontStyle.Regular, GraphicsUnit.Point, (byte)204); this.lInstumentId.ForeColor = Color.White; this.lInstumentId.Location = new Point(11, 603); this.lInstumentId.Name = "lInstumentId"; this.lInstumentId.Size = new Size(81, 16); this.lInstumentId.TabIndex = 62; this.lInstumentId.Text = "Instument ID"; this.button1.BackColor = Color.Transparent; this.button1.BackgroundImage = (Image)Resources.sv1; this.button1.BackgroundImageLayout = ImageLayout.Center; this.button1.Cursor = Cursors.Hand; this.button1.FlatAppearance.BorderSize = 0; this.button1.FlatAppearance.CheckedBackColor = Color.Transparent; this.button1.FlatAppearance.MouseDownBackColor = Color.Transparent; this.button1.FlatAppearance.MouseOverBackColor = Color.Transparent; this.button1.FlatStyle = FlatStyle.Flat; this.button1.Location = new Point(259, 2); this.button1.Name = "button1"; this.button1.Size = new Size(35, 35); this.button1.TabIndex = 16; this.button1.UseVisualStyleBackColor = false; this.button1.Click += new EventHandler(this.button1_Click); this.button1.MouseLeave += new EventHandler(this.button1_MouseLeave); this.button1.MouseMove += new MouseEventHandler(this.button1_MouseMove); this.button4.BackColor = Color.Transparent; this.button4.BackgroundImage = (Image)componentResourceManager.GetObject("button4.BackgroundImage"); this.button4.BackgroundImageLayout = ImageLayout.Stretch; this.button4.Cursor = Cursors.Hand; this.button4.FlatAppearance.BorderSize = 0; this.button4.FlatAppearance.CheckedBackColor = Color.Transparent; this.button4.FlatAppearance.MouseDownBackColor = Color.Transparent; this.button4.FlatAppearance.MouseOverBackColor = Color.Transparent; this.button4.FlatStyle = FlatStyle.Flat; this.button4.Font = new Font("Arial", 12f, FontStyle.Regular, GraphicsUnit.Point, (byte)204); this.button4.ForeColor = Color.White; this.button4.Location = new Point(115, 552); this.button4.Name = "button4"; this.button4.Size = new Size(101, 28); this.button4.TabIndex = 78; this.button4.Text = "Clear"; this.button4.UseVisualStyleBackColor = false; this.button4.Click += new EventHandler(this.button4_Click); this.button4.MouseLeave += new EventHandler(this.button4_MouseLeave); this.button4.MouseMove += new MouseEventHandler(this.button4_MouseMove); this.button2.BackColor = Color.Transparent; this.button2.BackgroundImage = (Image)Resources.zak1; this.button2.BackgroundImageLayout = ImageLayout.Center; this.button2.Cursor = Cursors.Hand; this.button2.FlatAppearance.BorderSize = 0; this.button2.FlatAppearance.CheckedBackColor = Color.Transparent; this.button2.FlatAppearance.MouseDownBackColor = Color.Transparent; this.button2.FlatAppearance.MouseOverBackColor = Color.Transparent; this.button2.FlatStyle = FlatStyle.Flat; this.button2.Location = new Point(295, 2); this.button2.Name = "button2"; this.button2.Size = new Size(35, 35); this.button2.TabIndex = 17; this.button2.UseVisualStyleBackColor = false; this.button2.Click += new EventHandler(this.button2_Click); this.button2.MouseLeave += new EventHandler(this.button2_MouseLeave); this.button2.MouseMove += new MouseEventHandler(this.button2_MouseMove); this.label7.AutoSize = true; this.label7.Font = new Font("Arial", 9.75f); this.label7.ForeColor = Color.White; this.label7.Location = new Point(282, 13); this.label7.Name = "label7"; this.label7.Size = new Size(0, 16); this.label7.TabIndex = 15; this.linkLabel1.ActiveLinkColor = Color.FromArgb(73, 138, 243); this.linkLabel1.AutoSize = true; this.linkLabel1.Font = new Font("Arial", 9f, FontStyle.Regular, GraphicsUnit.Point, (byte)204); this.linkLabel1.LinkColor = Color.White; this.linkLabel1.Location = new Point(282, 14); this.linkLabel1.Name = "linkLabel1"; this.linkLabel1.Size = new Size(0, 15); this.linkLabel1.TabIndex = 14; this.label6.AutoSize = true; this.label6.Font = new Font("Arial", 9.75f); this.label6.ForeColor = Color.White; this.label6.Location = new Point(277, 13); this.label6.Name = "label6"; this.label6.Size = new Size(0, 16); this.label6.TabIndex = 13; this.button8.BackColor = Color.Transparent; this.button8.BackgroundImage = (Image)componentResourceManager.GetObject("button8.BackgroundImage"); this.button8.BackgroundImageLayout = ImageLayout.Stretch; this.button8.Cursor = Cursors.Hand; this.button8.FlatAppearance.BorderSize = 0; this.button8.FlatAppearance.CheckedBackColor = Color.Transparent; this.button8.FlatAppearance.MouseDownBackColor = Color.Transparent; this.button8.FlatAppearance.MouseOverBackColor = Color.Transparent; this.button8.FlatStyle = FlatStyle.Flat; this.button8.Font = new Font("Arial", 12f, FontStyle.Regular, GraphicsUnit.Point, (byte)204); this.button8.ForeColor = Color.White; this.button8.Location = new Point(222, 552); this.button8.Name = "button8"; this.button8.Size = new Size(101, 28); this.button8.TabIndex = 61; this.button8.Text = "Save"; this.button8.UseVisualStyleBackColor = false; this.button8.Click += new EventHandler(this.button8_Click); this.button8.MouseLeave += new EventHandler(this.button8_MouseLeave); this.button8.MouseMove += new MouseEventHandler(this.button8_MouseMove); this.label3.AutoSize = true; this.label3.BackColor = Color.Transparent; this.label3.Font = new Font("Arial", 9.75f); this.label3.ForeColor = Color.FromArgb(73, 138, 243); this.label3.Location = new Point(37, 12); this.label3.Name = "label3"; this.label3.Size = new Size(109, 16); this.label3.TabIndex = 12; this.label3.Text = "CQG Instruments"; this.pictureBox2.BackColor = Color.Transparent; this.pictureBox2.BackgroundImage = (Image)Resources.User_blue3; this.pictureBox2.BackgroundImageLayout = ImageLayout.Center; this.pictureBox2.Location = new Point(2, 2); this.pictureBox2.Name = "pictureBox2"; this.pictureBox2.Size = new Size(35, 35); this.pictureBox2.TabIndex = 11; this.pictureBox2.TabStop = false; this.button5.FlatAppearance.BorderSize = 0; this.button5.FlatStyle = FlatStyle.Flat; this.button5.Location = new Point(896, 7); this.button5.Name = "button5"; this.button5.Size = new Size(26, 26); this.button5.TabIndex = 9; this.button5.UseVisualStyleBackColor = true; this.button6.FlatAppearance.BorderSize = 0; this.button6.FlatStyle = FlatStyle.Flat; this.button6.Location = new Point(923, 7); this.button6.Name = "button6"; this.button6.Size = new Size(26, 26); this.button6.TabIndex = 10; this.button6.UseVisualStyleBackColor = true; this.AutoScaleDimensions = new SizeF(6f, 13f); this.AutoScaleMode = AutoScaleMode.Font; this.BackgroundImageLayout = ImageLayout.Center; this.ClientSize = new Size(330, 678); this.Controls.Add((Control)this.lwInstruments); this.Controls.Add((Control)this.panel2); this.FormBorderStyle = FormBorderStyle.None; this.Icon = (Icon)componentResourceManager.GetObject("$this.Icon"); this.Location = new Point(620, 100); this.Name = nameof(CQGInstruments); this.Text = "CQG Instruments"; ((ISupportInitialize)this.lwInstruments).EndInit(); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); this.scrollPanel.ResumeLayout(false); ((ISupportInitialize)this.pictureBox2).EndInit(); this.ResumeLayout(false); }
private void InitializeComponent() { DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(SoftLicTypesViewport)); dataGridView = new DataGridView(); idSoftLicType = new DataGridViewTextBoxColumn(); softLicType = new DataGridViewTextBoxColumn(); softLicKeyDuplicateAllowed = new DataGridViewCheckBoxColumn(); ((System.ComponentModel.ISupportInitialize)(dataGridView)).BeginInit(); SuspendLayout(); // // dataGridView // dataGridView.AllowUserToAddRows = false; dataGridView.AllowUserToDeleteRows = false; dataGridView.AllowUserToResizeRows = false; dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView.BackgroundColor = System.Drawing.Color.White; dataGridView.BorderStyle = BorderStyle.Fixed3D; dataGridViewCellStyle1.Alignment = DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control; dataGridViewCellStyle1.Font = new System.Drawing.Font("Microsoft Sans Serif", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText; dataGridViewCellStyle1.Padding = new Padding(0, 2, 0, 2); dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle1.WrapMode = DataGridViewTriState.True; dataGridView.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1; dataGridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; dataGridView.Columns.AddRange(new DataGridViewColumn[] { idSoftLicType, softLicType, softLicKeyDuplicateAllowed }); dataGridView.Dock = DockStyle.Fill; dataGridView.EditMode = DataGridViewEditMode.EditOnEnter; dataGridView.Location = new System.Drawing.Point(3, 3); dataGridView.MultiSelect = false; dataGridView.Name = "dataGridView"; dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView.Size = new System.Drawing.Size(693, 345); dataGridView.TabIndex = 8; // // idSoftLicType // idSoftLicType.Frozen = true; idSoftLicType.HeaderText = "Идентификатор органа"; idSoftLicType.Name = "idSoftLicType"; idSoftLicType.ReadOnly = true; idSoftLicType.Visible = false; // // softLicType // softLicType.HeaderText = "Наименование"; softLicType.MinimumWidth = 100; softLicType.Name = "softLicType"; // // softLicKeyDuplicateAllowed // softLicKeyDuplicateAllowed.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; softLicKeyDuplicateAllowed.FillWeight = 1F; softLicKeyDuplicateAllowed.HeaderText = "Разрешить дублирование лиц. ключей"; softLicKeyDuplicateAllowed.MinimumWidth = 200; softLicKeyDuplicateAllowed.Name = "softLicKeyDuplicateAllowed"; softLicKeyDuplicateAllowed.Resizable = DataGridViewTriState.True; softLicKeyDuplicateAllowed.SortMode = DataGridViewColumnSortMode.Automatic; softLicKeyDuplicateAllowed.Width = 200; // // SoftLicTypesViewport // BackColor = System.Drawing.Color.White; ClientSize = new System.Drawing.Size(699, 351); Controls.Add(dataGridView); Font = new System.Drawing.Font("Microsoft Sans Serif", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); Name = "SoftLicTypesViewport"; Padding = new Padding(3); Text = "Виды лицензий на ПО"; ((System.ComponentModel.ISupportInitialize)(dataGridView)).EndInit(); ResumeLayout(false); }
private void ServerManager_Load(object sender, EventArgs e) { DBListSet = new DataSet(); mangosDBList.DropDown += new EventHandler(DBList_DropDown); charactersDBList.DropDown += new EventHandler(DBList_DropDown); realmdDBList.DropDown += new EventHandler(DBList_DropDown); HostNameTextBox.Text = ConnInfo.HostName; PWDTextBox.Text = ConnInfo.PassWord; UserNameTextBox.Text = ConnInfo.UserName; ServerManager.HostName = HostNameTextBox.Text; ServerManager.Password = PWDTextBox.Text; ServerManager.UserName = UserNameTextBox.Text; ServerManager.MangosDB = mangosDBList.Text; ServerManager.CharactersDB = charactersDBList.Text; ServerManager.RealmdDB = realmdDBList.Text; DataGridViewTextBoxColumn coln1 = new DataGridViewTextBoxColumn(); coln1.Width = 70; coln1.Name = "账号ID"; coln1.ReadOnly = true; DataGridViewTextBoxColumn coln2 = new DataGridViewTextBoxColumn(); coln2.Width = 80; coln2.Name = "账号名称"; coln2.ReadOnly = true; DataGridViewTextBoxColumn coln3 = new DataGridViewTextBoxColumn(); coln3.Width = 70; coln3.Name = "角色ID"; coln3.ReadOnly = true; DataGridViewTextBoxColumn coln4 = new DataGridViewTextBoxColumn(); coln4.Width = 80; coln4.Name = "角色名称"; coln4.ReadOnly = true; DataGridViewCheckBoxColumn checkboxColn1 = new DataGridViewCheckBoxColumn(); checkboxColn1.Width = 50; checkboxColn1.Name = "选择"; Mail_ReceiverDataGridView.Columns.Add(checkboxColn1); Mail_ReceiverDataGridView.Columns.Add(coln1); Mail_ReceiverDataGridView.Columns.Add(coln2); Mail_ReceiverDataGridView.Columns.Add(coln3); Mail_ReceiverDataGridView.Columns.Add(coln4); DataGridViewTextBoxColumn coln5 = new DataGridViewTextBoxColumn(); coln5.Width = 70; coln5.Name = "物品ID"; coln5.ReadOnly = true; DataGridViewTextBoxColumn coln6 = new DataGridViewTextBoxColumn(); coln6.Width = 80; coln6.Name = "物品名称"; coln6.ReadOnly = true; DataGridViewTextBoxColumn coln7 = new DataGridViewTextBoxColumn(); coln7.Width = 60; coln7.Name = "数量"; coln7.ReadOnly = false; DataGridViewCheckBoxColumn checkboxColn2 = new DataGridViewCheckBoxColumn(); checkboxColn2.Width = 50; checkboxColn2.Name = "选择"; Mail_ItemDataGridView.Columns.Add(checkboxColn2); Mail_ItemDataGridView.Columns.Add(coln5); Mail_ItemDataGridView.Columns.Add(coln6); Mail_ItemDataGridView.Columns.Add(coln7); }
private void InitializeComponent() { DataGridViewCellStyle dataGridViewCellStyle = new DataGridViewCellStyle(); DataGridViewCellStyle dataGridViewCellStyle2 = new DataGridViewCellStyle(); DataGridViewCellStyle dataGridViewCellStyle3 = new DataGridViewCellStyle(); DataGridViewCellStyle dataGridViewCellStyle4 = new DataGridViewCellStyle(); this.splitContainer1 = new SplitContainer(); this.DataGridView1 = new DataGridView(); this.DataGridView2 = new DataGridView(); this.DataGridViewTextBoxColumn1 = new DataGridViewCheckBoxColumn(); this.Column5 = new DataGridViewTextBoxColumn(); this.Column2 = new DataGridViewComboBoxColumn(); this.Column3 = new DataGridViewComboBoxColumn(); this.Column1 = new DataGridViewCheckBoxColumn(); this.Column4 = new DataGridViewTextBoxColumn(); this.Column6 = new DataGridViewButtonColumn(); ((ISupportInitialize)this.splitContainer1).BeginInit(); this.splitContainer1.Panel1.SuspendLayout(); this.splitContainer1.Panel2.SuspendLayout(); this.splitContainer1.SuspendLayout(); ((ISupportInitialize)this.DataGridView1).BeginInit(); ((ISupportInitialize)this.DataGridView2).BeginInit(); base.SuspendLayout(); this.splitContainer1.Dock = DockStyle.Fill; this.splitContainer1.FixedPanel = FixedPanel.Panel1; this.splitContainer1.IsSplitterFixed = true; this.splitContainer1.Location = new Point(0, 0); this.splitContainer1.Name = "splitContainer1"; this.splitContainer1.Panel1.Controls.Add(this.DataGridView1); this.splitContainer1.Panel2.Controls.Add(this.DataGridView2); this.splitContainer1.Size = new Size(491, 285); this.splitContainer1.SplitterDistance = 160; this.splitContainer1.SplitterWidth = 2; this.splitContainer1.TabIndex = 23; dataGridViewCellStyle.BackColor = Color.FromArgb(241, 244, 248); this.DataGridView1.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle; this.DataGridView1.BackgroundColor = Color.White; this.DataGridView1.BorderStyle = BorderStyle.Fixed3D; dataGridViewCellStyle2.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridViewCellStyle2.BackColor = SystemColors.Control; dataGridViewCellStyle2.Font = new Font("宋体", 9f, FontStyle.Regular, GraphicsUnit.Point, 134); dataGridViewCellStyle2.ForeColor = SystemColors.WindowText; dataGridViewCellStyle2.SelectionBackColor = SystemColors.Highlight; dataGridViewCellStyle2.SelectionForeColor = SystemColors.HighlightText; dataGridViewCellStyle2.WrapMode = DataGridViewTriState.True; this.DataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2; this.DataGridView1.ColumnHeadersHeight = 32; this.DataGridView1.Columns.AddRange(new DataGridViewColumn[] { this.Column1, this.Column4, this.Column6 }); this.DataGridView1.Dock = DockStyle.Fill; this.DataGridView1.GridColor = SystemColors.ActiveBorder; this.DataGridView1.Location = new Point(0, 0); this.DataGridView1.MultiSelect = false; this.DataGridView1.Name = "DataGridView1"; this.DataGridView1.RowTemplate.Height = 23; this.DataGridView1.SelectionMode = DataGridViewSelectionMode.CellSelect; this.DataGridView1.Size = new Size(160, 285); this.DataGridView1.TabIndex = 22; dataGridViewCellStyle3.BackColor = Color.FromArgb(241, 244, 248); this.DataGridView2.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle3; this.DataGridView2.BackgroundColor = Color.White; this.DataGridView2.BorderStyle = BorderStyle.Fixed3D; dataGridViewCellStyle4.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridViewCellStyle4.BackColor = SystemColors.Control; dataGridViewCellStyle4.Font = new Font("宋体", 9f, FontStyle.Regular, GraphicsUnit.Point, 134); dataGridViewCellStyle4.ForeColor = SystemColors.WindowText; dataGridViewCellStyle4.SelectionBackColor = SystemColors.Highlight; dataGridViewCellStyle4.SelectionForeColor = SystemColors.HighlightText; dataGridViewCellStyle4.WrapMode = DataGridViewTriState.True; this.DataGridView2.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle4; this.DataGridView2.ColumnHeadersHeight = 32; this.DataGridView2.Columns.AddRange(new DataGridViewColumn[] { this.DataGridViewTextBoxColumn1, this.Column5, this.Column2, this.Column3 }); this.DataGridView2.Dock = DockStyle.Fill; this.DataGridView2.GridColor = SystemColors.ActiveBorder; this.DataGridView2.Location = new Point(0, 0); this.DataGridView2.MultiSelect = false; this.DataGridView2.Name = "DataGridView2"; this.DataGridView2.RowTemplate.Height = 23; this.DataGridView2.SelectionMode = DataGridViewSelectionMode.CellSelect; this.DataGridView2.Size = new Size(329, 285); this.DataGridView2.TabIndex = 23; this.DataGridViewTextBoxColumn1.HeaderText = ""; this.DataGridViewTextBoxColumn1.Name = "DataGridViewTextBoxColumn1"; this.DataGridViewTextBoxColumn1.Resizable = DataGridViewTriState.True; this.DataGridViewTextBoxColumn1.SortMode = DataGridViewColumnSortMode.Automatic; this.DataGridViewTextBoxColumn1.Width = 25; this.Column5.HeaderText = "测量点号"; this.Column5.Name = "Column5"; this.Column5.Width = 40; this.Column2.HeaderText = "正反向"; this.Column2.Items.AddRange(new object[] { "正向", "反向", "" }); this.Column2.Name = "Column2"; this.Column3.HeaderText = "总加运算符标志"; this.Column3.Items.AddRange(new object[] { "加运算", "减运算", "" }); this.Column3.Name = "Column3"; this.Column1.HeaderText = ""; this.Column1.Name = "Column1"; this.Column1.Resizable = DataGridViewTriState.True; this.Column1.SortMode = DataGridViewColumnSortMode.Automatic; this.Column1.Width = 25; this.Column4.HeaderText = "总加组序号"; this.Column4.Name = "Column4"; this.Column4.Width = 70; this.Column6.HeaderText = "保存"; this.Column6.Name = "Column6"; this.Column6.Width = 20; base.AutoScaleDimensions = new SizeF(6f, 12f); base.ClientSize = new Size(491, 285); base.Controls.Add(this.splitContainer1); base.Name = "AFN04_14"; this.Text = "终端总加组配置参数"; this.splitContainer1.Panel1.ResumeLayout(false); this.splitContainer1.Panel2.ResumeLayout(false); ((ISupportInitialize)this.splitContainer1).EndInit(); this.splitContainer1.ResumeLayout(false); ((ISupportInitialize)this.DataGridView1).EndInit(); ((ISupportInitialize)this.DataGridView2).EndInit(); base.ResumeLayout(false); }
/// <summary> /// To grant a system privilege, /// you must either have been granted the system privilege with the ADMIN OPTION /// or /// have been granted the GRANT ANY PRIVILEGE system privilege. /// </summary> private void LoadPrivilege() { //Get privilege Privilege privilege = new Privilege() { Name = "GRANT ANY PRIVILEGE" }; List <Privilege> items; if (this.privilegeBLL.HasSystemPrivilege(this.currentUser.UserName, privilege)) { items = this.privilegeBLL.SystemPrivileges(); } else { items = this.privilegeBLL.SystemPrivileges(this.currentUser.UserName, true); } //Setup column DataGridViewCheckBoxColumn privilegeColumn = new DataGridViewCheckBoxColumn() { FalseValue = 0, TrueValue = 1, Visible = true, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn contentColumn = new DataGridViewTextBoxColumn() { Name = "Privilege", AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill }; DataGridViewCheckBoxColumn adminColumn = new DataGridViewCheckBoxColumn() { Name = "Admin", FalseValue = 0, TrueValue = 1, Visible = true, AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader }; this.DgvPrivilege.Columns.Add(privilegeColumn); this.DgvPrivilege.Columns.Add(contentColumn); this.DgvPrivilege.Columns.Add(adminColumn); foreach (var item in items) { DataGridViewRow row = new DataGridViewRow(); DataGridViewCheckBoxCell cellName = new DataGridViewCheckBoxCell { ToolTipText = item.Name, Value = false }; DataGridViewTextBoxCell cellPrivilege = new DataGridViewTextBoxCell() { Value = item.Name, }; DataGridViewCheckBoxCell cellAdmin = new DataGridViewCheckBoxCell { Value = false }; row.Cells.Add(cellName); row.Cells.Add(cellPrivilege); row.Cells.Add(cellAdmin); this.DgvPrivilege.Rows.Add(row); } contentColumn.ReadOnly = true; }
private DataGridView GetDGV(InventoryPouch pouch) { // Add DataGrid DataGridView dgv = new DataGridView { Dock = DockStyle.Fill, Text = pouch.Type.ToString(), Name = DGVPrefix + pouch.Type, AllowUserToAddRows = false, AllowUserToDeleteRows = false, AllowUserToResizeRows = false, AllowUserToResizeColumns = false, RowHeadersVisible = false, //ColumnHeadersVisible = false, MultiSelect = false, ShowEditingIcon = false, EditMode = DataGridViewEditMode.EditOnEnter, ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single, ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize, SelectionMode = DataGridViewSelectionMode.CellSelect, CellBorderStyle = DataGridViewCellBorderStyle.None, }; int c = 0; DataGridViewComboBoxColumn dgvItemVal = new DataGridViewComboBoxColumn { HeaderText = "Item", DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing, DisplayIndex = c++, Width = 135, FlatStyle = FlatStyle.Flat }; DataGridViewColumn dgvIndex = new DataGridViewTextBoxColumn(); { dgvIndex.HeaderText = "Count"; dgvIndex.DisplayIndex = c++; dgvIndex.Width = 45; dgvIndex.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; if (!Main.HaX) { ((DataGridViewTextBoxColumn)dgvIndex).MaxInputLength = (int)(Math.Log10(Math.Max(1, pouch.MaxCount)) + 1); } } dgv.Columns.Add(dgvItemVal); dgv.Columns.Add(dgvIndex); if (HasFreeSpace) { DataGridViewCheckBoxColumn dgvFree = new DataGridViewCheckBoxColumn { HeaderText = "Free", DisplayIndex = c++, Width = 40, FlatStyle = FlatStyle.Flat }; dgv.Columns.Add(dgvFree); } if (HasNew) { DataGridViewCheckBoxColumn dgvNew = new DataGridViewCheckBoxColumn { HeaderText = "NEW", DisplayIndex = c++, Width = 40, FlatStyle = FlatStyle.Flat }; dgv.Columns.Add(dgvNew); } var itemcount = pouch.Items.Length; string[] itemarr = Main.HaX ? (string[])itemlist.Clone() : GetItems(pouch.LegalItems); var combo = dgv.Columns[0] as DataGridViewComboBoxColumn; foreach (string t in itemarr) { combo.Items.Add(t); // add only the Item Names } dgv.Rows.Add(itemcount > 0 ? itemcount : itemarr.Length); dgv.CancelEdit(); return(dgv); }
//查询结果 public static void ReadGBT228(DataGridView dg, string testNo, string testSampleNo, DateTimePicker dtpFrom, DateTimePicker dtpTo, ZedGraph.ZedGraphControl zed) { BLL.TestSample bllTs = new HR_Test.BLL.TestSample(); string strWhere = string.Empty; if (!string.IsNullOrEmpty(testNo)) { strWhere += " and testNo like '%" + testNo + "%'"; } if (!string.IsNullOrEmpty(testSampleNo)) { strWhere += " and testSampleNo like '%" + testSampleNo + "%'"; } double maxValue = 0; DataSet dsmax = bllTs.GetMaxFm("isFinish=true and isEffective=false and testDate>=#" + dtpFrom.Value.Date + "# and testDate<=#" + dtpTo.Value.Date + "#" + strWhere); if (dsmax != null) { if (dsmax.Tables[0].Rows.Count > 0) { if (!string.IsNullOrEmpty(dsmax.Tables[0].Rows[0]["Fm"].ToString())) { maxValue = Convert.ToDouble(dsmax.Tables[0].Rows[0]["Fm"].ToString()); } } } DataSet ds = bllTs.GetFinishList("isFinish=true and isEffective=false and testDate>=#" + dtpFrom.Value.Date + "# and testDate<=#" + dtpTo.Value.Date + "#" + strWhere, maxValue); DataTable dt = ds.Tables[0]; dg.DataSource = dt; DataGridViewCheckBoxColumn chkcol = new DataGridViewCheckBoxColumn(); //DataGridViewDisableCheckBoxColumn chkcol = new DataGridViewDisableCheckBoxColumn(); chkcol.Name = "选择"; DataGridViewTextBoxColumn c = new DataGridViewTextBoxColumn(); c.Visible = true; c.Name = " "; dg.Columns.Insert(0, c); dg.Columns.Insert(0, chkcol); dg.Columns[1].Frozen = true; dg.Columns[2].Frozen = true; //dg.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells); dg.Columns[0].Width = 50; dg.Columns[1].Width = 50; dg.Columns[2].Width = 100; if (dg.ColumnCount > 0) { foreach (DataGridViewColumn dgvc in dg.Columns) { dgvc.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvc.SortMode = DataGridViewColumnSortMode.NotSortable; dgvc.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; } } dg.Refresh(); for (int i = 0; i < dg.Rows.Count; i++) { if (i > 19) { dg.Rows[i].Cells[1].Style.BackColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Style.ForeColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Value = _Color_Array[i % 20].ToString(); } else { dg.Rows[i].Cells[1].Style.BackColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Style.ForeColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Value = _Color_Array[i].ToString(); } } foreach (CurveItem ci in zed.GraphPane.CurveList) { ci.Clear(); ci.Label.Text = ""; } zed.AxisChange(); zed.Refresh(); ds.Dispose(); }
void _BGWAbsenceAndPeriodList_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { System.Windows.Forms.DataGridViewTextBoxColumn colName = new DataGridViewTextBoxColumn(); colName.HeaderText = "節次分類"; colName.MinimumWidth = 70; colName.Name = "colName"; colName.ReadOnly = true; colName.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; colName.Width = 70; this.dataGridViewX1.Columns.Add(colName); foreach (string absence in absenceList) { System.Windows.Forms.DataGridViewCheckBoxColumn newCol = new DataGridViewCheckBoxColumn(); newCol.HeaderText = absence; newCol.Width = 55; newCol.ReadOnly = false; newCol.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; newCol.Tag = absence; newCol.ValueType = typeof(bool); this.dataGridViewX1.Columns.Add(newCol); } foreach (string type in typeList) { DataGridViewRow row = new DataGridViewRow(); row.CreateCells(dataGridViewX1, type); row.Tag = type; dataGridViewX1.Rows.Add(row); } #region 讀取列印設定 Preference valueOnChange = true; //XmlElement config = CurrentUser.Instance.Preference[_preferenceElementName]; ConfigData cd = School.Configuration[_preferenceElementName]; string strr = cd["XmlData"]; XmlElement config; if (strr != "") { config = DSXmlHelper.LoadXml(strr); #region 已有設定檔則將設定檔內容填回畫面上 foreach (XmlElement type in config.SelectNodes("Type")) { string typeName = type.GetAttribute("Text"); foreach (DataGridViewRow row in dataGridViewX1.Rows) { if (typeName == ("" + row.Tag)) { foreach (XmlElement absence in type.SelectNodes("Absence")) { string absenceName = absence.GetAttribute("Text"); foreach (DataGridViewCell cell in row.Cells) { if (cell.OwningColumn is DataGridViewCheckBoxColumn && ("" + cell.OwningColumn.Tag) == absenceName) { cell.Value = true; } } } break; } } } #endregion } else { #region 產生空白設定檔 config = new XmlDocument().CreateElement(_preferenceElementName); //CurrentUser.Instance.Preference[_preferenceElementName] = config; cd.SetXml("XmlData", config); #endregion } cd.Save(); valueOnChange = false; #endregion }
public static void construirTablaReparacionesRealizadas(DataGridView dgv_tabla) { var id = new DataGridViewTextBoxColumn(); var razon = new DataGridViewTextBoxColumn(); var nrofactura = new DataGridViewTextBoxColumn(); var tipo = new DataGridViewTextBoxColumn(); var remito = new DataGridViewTextBoxColumn(); var total = new DataGridViewTextBoxColumn(); var fecha = new DataGridViewTextBoxColumn(); var link = new DataGridViewTextBoxColumn(); var url = new DataGridViewImageColumn(); var cobrada = new DataGridViewCheckBoxColumn(); var fecha_cobro = new DataGridViewTextBoxColumn(); var fecha_vto = new DataGridViewTextBoxColumn(); var vendedor = new DataGridViewTextBoxColumn(); var informacion = new DataGridViewImageColumn(); var maquina = new DataGridViewTextBoxColumn(); var problema = new DataGridViewTextBoxColumn(); var documento = new DataGridViewTextBoxColumn(); razon.HeaderText = "Razon Social"; razon.DataPropertyName = "Razon Social"; razon.Name = "Razon Social"; razon.ReadOnly = true; razon.Width = 200; maquina.HeaderText = "Máquina"; maquina.DataPropertyName = "Maquina"; maquina.ReadOnly = true; // problema.HeaderText = "Problema"; //problema.DataPropertyName = "Problema"; //problema.ReadOnly = true; nrofactura.HeaderText = "Nro Factura"; nrofactura.Name = "Nro Factura"; nrofactura.ReadOnly = true; nrofactura.DataPropertyName = "Nro Factura"; tipo.HeaderText = "Tipo"; tipo.Name = "Tipo"; tipo.DataPropertyName = "Tipo"; tipo.ReadOnly = true; remito.HeaderText = "Remito"; remito.Name = "Remito"; remito.DataPropertyName = "Remito"; remito.ReadOnly = true; total.HeaderText = "Total"; total.Name = "Total"; total.DataPropertyName = "Total"; total.ReadOnly = true; fecha.HeaderText = "Fecha"; fecha.Name = "Fecha"; fecha.DataPropertyName = "Fecha"; fecha.ReadOnly = true; link.HeaderText = "Link"; link.Name = "Link"; link.DataPropertyName = "Link"; link.ReadOnly = true; link.Visible = false; fecha_cobro.HeaderText = "Fecha de Cobro"; fecha_cobro.Name = "Fecha de Cobro"; fecha_cobro.DataPropertyName = "Fecha de Cobro"; fecha_cobro.ReadOnly = true; cobrada.HeaderText = "Cobrada"; cobrada.Name = "Cobrada"; cobrada.DataPropertyName = "Cobrada"; //cobrada.Visible = false; cobrada.ReadOnly = true; fecha_vto.HeaderText = "Vencimiento"; fecha_vto.Name = "Vencimiento"; fecha_vto.DataPropertyName = "Vencimiento"; fecha_vto.ReadOnly = true; vendedor.HeaderText = "Vendedor"; vendedor.Name = "Vendedor"; vendedor.DataPropertyName = "Vendedor"; vendedor.ReadOnly = true; id.HeaderText = "Id"; id.Name = "Id"; id.DataPropertyName = "Id"; id.ReadOnly = true; id.Visible = false; url.Name = "URL"; url.HeaderText = "URL"; url.DataPropertyName = "URL"; url.ReadOnly = true; informacion.Name = "Informacion"; informacion.HeaderText = "Info"; informacion.DataPropertyName = "Informacion"; informacion.ReadOnly = true; documento.Name = "Documento"; documento.HeaderText = "Documento"; documento.DataPropertyName = "Documento"; documento.ReadOnly = true; documento.Visible = false; dgv_tabla.Columns.AddRange(new DataGridViewColumn[] { id, razon, maquina, tipo, nrofactura, remito, total, fecha, fecha_vto, fecha_cobro, vendedor, cobrada, link, informacion, url, documento }); dgv_tabla.AutoGenerateColumns = false; llenar_reparaciones_realizadas(dgv_tabla); }
public static void readFinishSample(DataGridView dg, DataGridView dgSum, string testNo, DateTimePicker dtp, ZedGraph.ZedGraphControl zed) { //try //{ //dg.MultiSelect = true; if (dg != null) { dg.DataSource = null; dg.Columns.Clear(); dg.RowHeadersVisible = false; } BLL.TestSample bllTs = new HR_Test.BLL.TestSample(); if (!string.IsNullOrEmpty(testNo)) { //if (testNo.Contains('-')) // testNo = testNo.Substring(0, testNo.LastIndexOf("-")); //获取不重复的试验编号列表 DataSet ds = bllTs.GetNotOverlapList(" testNo='" + testNo + "' and testDate =#" + dtp.Value.Date + "#"); DataTable dt = ds.Tables[0]; int ab = 0; if (dt != null) { if (dt.Rows[0]["b0"].ToString() != "0") { ab = 1; } if (dt.Rows[0]["d0"].ToString() != "0") { ab = 2; } if (dt.Rows[0]["Do"].ToString() != "0") { ab = 3; } } DataSet ds1 = bllTs.GetNotOverlapList1(" testNo='" + testNo + "' and testDate =#" + dtp.Value.Date + "#"); DataTable dt1 = ds1.Tables[0]; DataSet dsmax = bllTs.GetMaxFm(" testNo='" + testNo + "' and testDate =#" + dtp.Value.Date + "#"); double maxvalue = 0; if (dsmax != null) { if (!string.IsNullOrEmpty(dsmax.Tables[0].Rows[0]["Fm"].ToString())) { maxvalue = Convert.ToDouble(dsmax.Tables[0].Rows[0]["Fm"].ToString()); } } string methodName = dt1.Rows[0]["testMethodName"].ToString(); if (dt1 != null) { StringBuilder[] tst = strSql_T(methodName, maxvalue); if (!string.IsNullOrEmpty(tst[0].ToString()) && dg != null) { dg.DataSource = CreateView_T(tst[0].ToString(), dt1.Rows[0]["testNo"].ToString(), ab); } if (!string.IsNullOrEmpty(tst[1].ToString())) { dgSum.DataSource = CreateAverageView(tst[0], tst[1], dt1.Rows[0]["testNo"].ToString(), ab); } } } else { DataSet ds = bllTs.GetFinishList(" testNo='" + testNo + "' and testDate=#" + dtp.Value.Date + "#", 0); DataTable dt = ds.Tables[0]; DataRow dr = dt.NewRow(); dt.Rows.Add(dr); if (dg != null) { dg.DataSource = dt; } ds.Dispose(); } //DataGridViewDisableCheckBoxColumn chkcol = new DataGridViewDisableCheckBoxColumn(); //DataGridViewCheckBoxColumn chkeffective = new DataGridViewCheckBoxColumn(); //chkeffective.Name = "是否有效"; //chkeffective.MinimumWidth = 60; //chkeffective.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; DataGridViewCheckBoxColumn chkcol = new DataGridViewCheckBoxColumn(); chkcol.Name = "选择"; chkcol.MinimumWidth = 50; chkcol.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; if (dg != null) { DataGridViewTextBoxColumn c = new DataGridViewTextBoxColumn(); c.Name = ""; dg.Columns.Insert(0, chkcol); dg.Columns.Insert(1, c); dg.Name = "tensile"; //dg.Rows[0].Cells[0].Value = false; //dg.Rows[0].Cells[0].Selected = false; int rCount = dg.Rows.Count; for (int i = 0; i < rCount; i++) { if (!string.IsNullOrEmpty(dg.Rows[i].Cells[2].Value.ToString())) { if (Convert.ToBoolean(dg.Rows[i].Cells[2].Value.ToString()) == true) { dg.Rows[i].DefaultCellStyle.BackColor = Color.IndianRed; } } if (i > 19) { dg.Rows[i].Cells[1].Style.BackColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Style.ForeColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i % 20]); dg.Rows[i].Cells[1].Value = _Color_Array[i % 20].ToString(); } else { dg.Rows[i].Cells[1].Style.BackColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Style.ForeColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i]); dg.Rows[i].Cells[1].Value = _Color_Array[i].ToString(); } } foreach (DataGridViewColumn dgvc in dg.Columns) { dgvc.SortMode = DataGridViewColumnSortMode.NotSortable; dgvc.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; } if (dg.Columns.Count > 3) { dg.Columns[0].Frozen = true; dg.Columns[1].Frozen = true; dg.Columns[2].Frozen = true; } if (dg.Columns.Count > 2) { dg.Columns[2].Frozen = true; } dg.Refresh(); } if (zed != null) { //clear all curves foreach (CurveItem ci in zed.GraphPane.CurveList) { ci.Clear(); ci.Label.Text = ""; } zed.AxisChange(); zed.Refresh(); } //} //catch (Exception ee) { throw ee; } }
public DataGridViewColumn[] ColumnasGrid() { DataGridViewTextBoxColumn colOrden = new DataGridViewTextBoxColumn() { Name = "colOrden", HeaderText = "Orden", DataPropertyName = "orden", MaxInputLength = 2, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colIdentificador = new DataGridViewTextBoxColumn() { Name = "colIdentificador", HeaderText = "Identificador", DataPropertyName = "identificador", Width = 80 }; DataGridViewTextBoxColumn colColumna = new DataGridViewTextBoxColumn() { Name = "colColumna", HeaderText = "Columna.", DataPropertyName = "nombre", Width = 120 }; DataGridViewButtonXColumn colColumnaBoton = new DataGridViewButtonXColumn() { Name = "colNombreBoton", HeaderText = "<-", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells, Tag = "colColumna", Image = General.Imagenes.Images["Listar.ico"], ColorTable = DevComponents.DotNetBar.eButtonColor.Blue }; DataGridViewComboBoxExColumn colTipoColumna = new DataGridViewComboBoxExColumn() { Name = "colTipoColumna", HeaderText = "Tipo columna.", DataPropertyName = "fktiposcolumna", ValueMember = "Objeto", DisplayMember = "nombre", FlatStyle = FlatStyle.Flat, Width = 200, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colCabecera = new DataGridViewTextBoxColumn() { Name = "colCabecera", HeaderText = "Texto Cabecera.", DataPropertyName = "cabecera", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colFormatoFecha = new DataGridViewTextBoxColumn() { Name = "colFormatoFecha", HeaderText = "Formato Fecha", DataPropertyName = "formatofecha", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewDateTimeInputColumn colFechaMinima = new DataGridViewDateTimeInputColumn() { Name = "colFechaMinima", HeaderText = "Fecha minima", DataPropertyName = "fechaminima", Format = DevComponents.Editors.eDateTimePickerFormat.Custom, CustomFormat = "yyyy-MM-dd", MinDate = new DateTime(1901, 02, 01), AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colPropertyName = new DataGridViewTextBoxColumn() { Name = "colPropertyName", HeaderText = "PropertyName", DataPropertyName = "propertyname", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colValueMember = new DataGridViewTextBoxColumn() { Name = "colValueMember", HeaderText = "ValueMember", DataPropertyName = "valuemember", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colDisplayMember = new DataGridViewTextBoxColumn() { Name = "colDisplayMember", HeaderText = "DisplayMember", DataPropertyName = "displaymember", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colTag = new DataGridViewTextBoxColumn() { Name = "colTag", HeaderText = "Tag", DataPropertyName = "tag", MaxInputLength = 255, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewComboBoxExColumn colBusqueda = new DataGridViewComboBoxExColumn() { Name = "colBusqueda", HeaderText = "Busqueda", DataPropertyName = "busqueda", //ValueMember = "Objeto", //DisplayMember = "nombre", FlatStyle = FlatStyle.Standard, Width = 130, DropDownStyle = ComboBoxStyle.DropDown }; DataGridViewComboBoxExColumn colAlineacion = new DataGridViewComboBoxExColumn() { Name = "colAlineacion", HeaderText = "Alineacion.", DataPropertyName = "fkalineacion", ValueMember = "Objeto", DisplayMember = "nombre", FlatStyle = FlatStyle.Flat, Width = 100, DropDownStyle = ComboBoxStyle.DropDownList }; DataGridViewTextBoxColumn colWidth = new DataGridViewTextBoxColumn() { Name = "colWidth", HeaderText = "Width", DataPropertyName = "width", MaxInputLength = 100, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewTextBoxColumn colMaxLength = new DataGridViewTextBoxColumn() { Name = "colMaxLength", HeaderText = "MaxLength", DataPropertyName = "maxlength", MaxInputLength = 100, AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colReadOnly = new DataGridViewCheckBoxColumn() { Name = "colReadOnly", HeaderText = "ReadOnly", DataPropertyName = "sololectura", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colVisible = new DataGridViewCheckBoxColumn() { Name = "colVisible", HeaderText = "Visible", DataPropertyName = "visible", AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells }; DataGridViewCheckBoxColumn colModificado = new DataGridViewCheckBoxColumn() { Name = "colModificado", HeaderText = "Modificado", DataPropertyName = "Modificado", Visible = false }; DataGridViewColumn[] listaColumnas = new DataGridViewColumn[] { colIdentificador, colOrden, colColumna, //colColumnaBoton, colTipoColumna, colCabecera, colFormatoFecha, colFechaMinima, colPropertyName, colValueMember, colDisplayMember, colTag, colBusqueda, colAlineacion, colWidth, colMaxLength, colReadOnly, colVisible, colModificado }; return(listaColumnas); }
private void configurarGrilla(DataSet ds) { dtgListado.Columns.Clear(); dtgListado.AutoGenerateColumns = false; DataGridViewTextBoxColumn clmIdCliente = new DataGridViewTextBoxColumn(); clmIdCliente.Width = 30; clmIdCliente.ReadOnly = true; clmIdCliente.DataPropertyName = "id_Cliente"; clmIdCliente.HeaderText = "ID"; dtgListado.Columns.Add(clmIdCliente); DataGridViewTextBoxColumn clmTipoDni = new DataGridViewTextBoxColumn(); clmTipoDni.Width = 35; clmTipoDni.ReadOnly = true; clmTipoDni.DataPropertyName = "Tipo_Dni"; clmTipoDni.HeaderText = "Tipo de Documento"; dtgListado.Columns.Add(clmTipoDni); DataGridViewTextBoxColumn clmDni = new DataGridViewTextBoxColumn(); clmDni.Width = 30; clmDni.ReadOnly = true; clmDni.DataPropertyName = "Dni"; clmDni.HeaderText = "Dni"; dtgListado.Columns.Add(clmDni); DataGridViewTextBoxColumn clmCuil = new DataGridViewTextBoxColumn(); clmCuil.Width = 30; clmCuil.ReadOnly = true; clmCuil.DataPropertyName = "Cuil"; clmCuil.HeaderText = "Cuil"; dtgListado.Columns.Add(clmCuil); DataGridViewTextBoxColumn clmApellido = new DataGridViewTextBoxColumn(); clmApellido.ReadOnly = true; clmApellido.DataPropertyName = "Apellido"; clmApellido.HeaderText = "Apellido"; dtgListado.Columns.Add(clmApellido); DataGridViewTextBoxColumn clmNombre = new DataGridViewTextBoxColumn(); clmNombre.ReadOnly = true; clmNombre.DataPropertyName = "Nombre"; clmNombre.HeaderText = "Nombre"; dtgListado.Columns.Add(clmNombre); DataGridViewTextBoxColumn clmFechaNac = new DataGridViewTextBoxColumn(); clmFechaNac.Width = 80; clmFechaNac.ReadOnly = true; clmFechaNac.DataPropertyName = "Fecha_nac"; clmFechaNac.HeaderText = "Fecha de Nacimiento"; dtgListado.Columns.Add(clmFechaNac); DataGridViewTextBoxColumn clmMail = new DataGridViewTextBoxColumn(); clmMail.ReadOnly = true; clmMail.DataPropertyName = "Mail"; clmMail.HeaderText = "Mail"; dtgListado.Columns.Add(clmMail); DataGridViewTextBoxColumn clmTelefono = new DataGridViewTextBoxColumn(); clmTelefono.ReadOnly = true; clmTelefono.DataPropertyName = "Telefono"; clmTelefono.HeaderText = "Teléfono"; dtgListado.Columns.Add(clmTelefono); DataGridViewTextBoxColumn clmDireccion = new DataGridViewTextBoxColumn(); clmDireccion.Width = 80; clmDireccion.ReadOnly = true; clmDireccion.DataPropertyName = "Direccion"; clmDireccion.HeaderText = "Dirección"; dtgListado.Columns.Add(clmDireccion); DataGridViewTextBoxColumn clmCiudad = new DataGridViewTextBoxColumn(); clmCiudad.ReadOnly = true; clmCiudad.DataPropertyName = "Dom_ciudad"; clmCiudad.HeaderText = "Ciudad"; dtgListado.Columns.Add(clmCiudad); DataGridViewTextBoxColumn clmCodigoPostal = new DataGridViewTextBoxColumn(); clmCodigoPostal.ReadOnly = true; clmCodigoPostal.DataPropertyName = "Dom_cod_postal"; clmCodigoPostal.HeaderText = "Código Postal"; dtgListado.Columns.Add(clmCodigoPostal); DataGridViewCheckBoxColumn clmActivo = new DataGridViewCheckBoxColumn(); clmActivo.Width = 60; clmActivo.ReadOnly = true; clmActivo.DataPropertyName = "Activo"; clmActivo.HeaderText = "Activo"; dtgListado.Columns.Add(clmActivo); dtgListado.DataSource = ds.Tables[0]; dtgListado.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
private void setupDataGridView() { // configure for readonly dataGridViewClients.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridViewClients.MultiSelect = false; dataGridViewClients.AllowUserToAddRows = false; dataGridViewClients.EditMode = DataGridViewEditMode.EditProgrammatically; dataGridViewClients.AllowUserToOrderColumns = false; dataGridViewClients.AllowUserToResizeColumns = false; dataGridViewClients.AllowUserToResizeRows = false; dataGridViewClients.ColumnHeadersDefaultCellStyle.Font = new Font(DataGridView.DefaultFont, FontStyle.Bold); //// add columns DataGridViewTextBoxColumn clientCode = new DataGridViewTextBoxColumn(); clientCode.Name = "clientCode"; clientCode.DataPropertyName = "ClientCode"; //has to match the Property Method name exactly clientCode.HeaderText = "Client Code"; clientCode.Width = 70; clientCode.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; clientCode.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; clientCode.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(clientCode); DataGridViewTextBoxColumn companyName = new DataGridViewTextBoxColumn(); companyName.Name = "companyName"; companyName.DataPropertyName = "CompanyName"; companyName.HeaderText = "Company Name"; companyName.Width = 160; companyName.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; companyName.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; companyName.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(companyName); DataGridViewTextBoxColumn address1 = new DataGridViewTextBoxColumn(); address1.Name = "address1"; address1.DataPropertyName = "Address1"; address1.HeaderText = "Address"; address1.Width = 160; address1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; address1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; address1.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(address1); //DataGridViewTextBoxColumn address2 = new DataGridViewTextBoxColumn(); //address2.Name = "address2"; //address2.DataPropertyName = "Address2"; //address2.HeaderText = "Address2"; //address2.Width = 160; //address2.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; //address2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //address2.SortMode = DataGridViewColumnSortMode.NotSortable; //dataGridViewClients.Columns.Add(address2); DataGridViewTextBoxColumn city = new DataGridViewTextBoxColumn(); city.Name = "city"; city.DataPropertyName = "City"; city.HeaderText = "City"; city.Width = 60; city.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; city.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; city.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(city); DataGridViewTextBoxColumn postalCode = new DataGridViewTextBoxColumn(); postalCode.Name = "postalCode"; postalCode.DataPropertyName = "PostalCode"; postalCode.HeaderText = "Postal Code"; postalCode.Width = 60; postalCode.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; postalCode.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; postalCode.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(postalCode); DataGridViewTextBoxColumn ytdsales = new DataGridViewTextBoxColumn(); ytdsales.Name = "ytdsales"; ytdsales.DataPropertyName = "YTDSales"; ytdsales.HeaderText = "YTDSales"; ytdsales.Width = 70; ytdsales.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; ytdsales.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; ytdsales.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(ytdsales); DataGridViewTextBoxColumn notes = new DataGridViewTextBoxColumn(); notes.Name = "notes"; notes.DataPropertyName = "Notes"; notes.HeaderText = "Notes"; notes.Width = 100; notes.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; notes.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; notes.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(notes); DataGridViewCheckBoxColumn creditHold = new DataGridViewCheckBoxColumn(); creditHold.Name = "creditHold"; creditHold.DataPropertyName = "CreditHold"; creditHold.HeaderText = "Credit Hold"; creditHold.Width = 50; // creditHold.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; // creditHold.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //looks better without the middle alightment creditHold.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridViewClients.Columns.Add(creditHold); }
private void Procesar(string loRutaArchivoMovimientos, int lnIniciarLecturaMovimientos, string loRutaArchivoCodigosMovimientos) { Cursor.Current = Cursors.WaitCursor; this.Enabled = false; DataGridViewCheckBoxColumn loAgregaCheck = new DataGridViewCheckBoxColumn(); lblProcesados.Text = "0"; lblImporteCargado.Text = "$ 00.00"; psArchivo = loRutaArchivoMovimientos; gvExistentes.DataSource = null; try { txtArchivo.Text = loRutaArchivoMovimientos; #region Filtrar datos solo abonos. DataTable poMovimientos = LeerArchivo(loRutaArchivoMovimientos, lnIniciarLecturaMovimientos); lblEstatus.Text = "Registros Procesados: " + poMovimientos.Rows.Count.ToString(); #endregion if (gvMovimientosCorrectos.Columns.Count < 1) { loAgregaCheck = new DataGridViewCheckBoxColumn(); CheckBoxHeaderCell loCheckheader = new CheckBoxHeaderCell(); loCheckheader.OnCheckBoxHeaderClick += loCheckheader_OnCheckBoxHeaderClick; loAgregaCheck.HeaderCell = loCheckheader; gvMovimientosCorrectos.Columns.Insert(0, loAgregaCheck); } if (gvMovimientosErrores.Columns.Count < 1) { loAgregaCheck = new DataGridViewCheckBoxColumn(); loAgregaCheck.Width = 1; gvMovimientosErrores.Columns.Insert(0, loAgregaCheck); this.gvMovimientosErrores.Columns[0].Resizable = 0; } poMovimientos.Columns.Add("Tipo_pago", typeof(string)); poMovimientos.Columns.Add("Suc", typeof(string)); poMovimientos.Columns.Add("Cliente", typeof(string)); poMovimientos.Columns.Add("#", typeof(int)); poMovimientos.Columns.Add("Forma_Pago", typeof(string)); poMovimientos.Columns.Add("Sucursal", typeof(string)); poMovimientos.Columns.Add("Status", typeof(string)); obtenerFormaDePago(poMovimientos); pbMovimientos.Minimum = 1; pbMovimientos.Maximum = poMovimientos.Rows.Count; pbMovimientos.Value = 1; pbMovimientos.Step = 1; poMovimientos = GenerarVista(poMovimientos); this.gvMovimientosCorrectos.DataSource = ObtenerSucursal(ValidaCobro(poMovimientos)); gvMovimientosCorrectos.Columns["#"].DisplayIndex = 1; gvMovimientosErrores.Columns["#"].DisplayIndex = 1; this.gvMovimientosCorrectos.Columns["Columna10"].Visible = false; this.gvMovimientosCorrectos.Columns["Forma_Pago"].Visible = false; this.gvMovimientosCorrectos.Columns["Suc"].Visible = false; this.gvMovimientosCorrectos.Columns["Status"].Visible = false; this.gvMovimientosErrores.Columns["Columna10"].Visible = false; this.gvMovimientosErrores.Columns["Forma_Pago"].Visible = false; this.gvMovimientosErrores.Columns["Suc"].Visible = false; this.gvMovimientosErrores.Columns["Status"].Visible = false; for (int ln = 1; ln < gvMovimientosCorrectos.Columns.Count; ln++) { gvMovimientosCorrectos.Columns[ln].ReadOnly = true; } MessageBox.Show("Archivo procesado correctamente.", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message + "\r\nFuente: " + ex.Source, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; this.Enabled = true; } }
private void button1_Click(object sender, EventArgs e) { //try // { if (!string.IsNullOrEmpty(textBox4.Text)) { string y; y = label10.Text; int v; v = Convert.ToInt32(y); cmd = new SqlCommand("select name,nationalId from student where nationalId='" + textBox4.Text + "' and restricted='" + '1' + "'", cn); cn.Open(); dr = cmd.ExecuteReader(); if (dr.Read()) { name = dr[0].ToString(); nationalid = dr[1].ToString(); dr.Close(); cm = new SqlCommand("select count(*) from registeration where nationalId='" + nationalid + "' and [year]=" + v + " and semester='" + label11.Text + "'", cn); dv = cm.ExecuteReader(); dv.Read(); string h = dv[0].ToString(); int r = Convert.ToInt32(h); dv.Close(); cn.Close(); ci = new SqlCommand("select count(*) from selection where nationalId='" + nationalid + "'", cn); cn.Open(); dv = ci.ExecuteReader(); dv.Read(); string p = dv[0].ToString(); int w; w = Convert.ToInt32(p); dv.Close(); cn.Close(); if (w > 0) { //رسالة يتم الان التسجيل بنفس الرقم MessageBox.Show(" يتم الان التسجيل بنفس الرقم", "رسالة", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); textBox4.Clear(); } else { if (r != 0) { //فى حالة ان الطالب مسجل من قبل textBox2.Hide(); button1.Hide(); label7.Hide(); label8.Text = "تم التسجيل من قبل"; this.Size = new Size(659, 249); textBox4.ReadOnly = true; } else { //فى حالة ان الطالب غير مسجل من قبل int year = Convert.ToInt32(label10.Text); string seme = label11.Text; double decide = 0; int test = 0; cmd = new SqlCommand("select count(gpa) from totalgpa where nationalid='" + nationalid + "' ", cn); cn.Open(); dv = cmd.ExecuteReader(); dv.Read(); test = Convert.ToInt32(dv[0].ToString()); dv.Close(); cn.Close(); if (test != 0) { if (seme == "first") { year = year - 1; cmd = new SqlCommand("exec sumgpa2 where @idofstudent='" + nationalid + "' and year=" + year + " ", cn); cn.Open(); dv = cmd.ExecuteReader(); dv.Read(); decide = Convert.ToDouble(dv[0].ToString()); dv.Close(); cn.Close(); } if (seme == "second") { seme = "first"; cmd = new SqlCommand("select gpa from totalgpa where nationalid='" + nationalid + "' and year=" + year + " and semester='" + seme + "'", cn); cn.Open(); dv = cmd.ExecuteReader(); dv.Read(); string bv = dv[0].ToString(); dv.Close(); cn.Close(); decide = Convert.ToDouble(bv); } if (seme == "summer") { seme = "second"; cmd = new SqlCommand("select gpa from totalgpa where nationalid='" + nationalid + "' and year=" + year + " and semester='" + seme + "'", cn); cn.Open(); dv = cmd.ExecuteReader(); dv.Read(); decide = Convert.ToDouble(dv[0].ToString()); dv.Close(); cn.Close(); } } else { decide = 100; } if (decide == 100) { label4.Text = "14"; label6.Text = "18"; } if (decide < 2) { label4.Text = "14"; label6.Text = "18"; } if ((decide >= 2) && (decide < 3)) { label4.Text = "18"; label6.Text = "18"; } //كمل باقى الحالات Da = new SqlDataAdapter("exec register @idstudent='" + nationalid + "'", cn); ds = new DataSet(); Da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; dataGridView2.DataSource = ds.Tables[1]; ca = new SqlCommand("select name from student where nationalId='" + nationalid + "' ", cn); cn.Open(); dr = ca.ExecuteReader(); dr.Read(); textBox2.Text = dr[0].ToString(); dr.Close(); cn.Close(); DataGridViewCheckBoxColumn sb = new DataGridViewCheckBoxColumn(); sb.HeaderText = "select"; dataGridView1.Columns.Add(sb); if (dataGridView1.ColumnCount == 3) { dataGridView1.Columns.RemoveAt(2); } dataGridView1.Columns[0].ReadOnly = true; for (int m = dataGridView1.Rows.Count - 1; m >= 0; m--) { dataGridView1.Rows[m].Cells[1].Value = false; } if (dataGridView2.Rows.Count == 0) { dataGridView2.Visible = false; } else { dataGridView2.Visible = true; DataGridViewCheckBoxColumn sa = new DataGridViewCheckBoxColumn(); sa.HeaderText = "select"; dataGridView2.Columns.Add(sa); if (dataGridView2.ColumnCount >= 3) { dataGridView2.Columns.RemoveAt(2); } dataGridView2.Columns[0].ReadOnly = true; for (int m = dataGridView2.Rows.Count - 1; m >= 0; m--) { dataGridView2.Rows[m].Cells[1].Value = false; } } button1.Visible = false; button6.Hide(); button5.Hide(); label8.Hide(); button4.Hide(); this.Size = new Size(659, 563); textBox4.ReadOnly = true; dr.Close(); } //............ } } else { //فى حالة ان الرقم غير متاح او لم يدخل رقم للطالب من الاساس MessageBox.Show("من فضللك ادخل رقم الجلوس الصحيح", "رسالة", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); textBox4.Clear(); dr.Close(); cn.Close(); } } /* } * * * * //-- * catch * { * MessageBox.Show("من فضللك التاكد من الاتصال بقاعده البيانات ", "رسالة", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); * }*/ }
private void dtgMetroGrid1() { int cntStandardMenu = 13; metroGrid1.Rows.Clear(); metroGrid1.RowHeadersVisible = false; DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn(); metroGrid1.Columns.Add(chk); chk.HeaderText = "선택"; metroGrid1.ColumnCount = mainFrm.CompetitionData.GetLength(1) - cntStandardMenu + 2; metroGrid1.ScrollBars = ScrollBars.Horizontal; metroGrid1.DefaultCellStyle.WrapMode = DataGridViewTriState.False; metroGrid1.DefaultCellStyle.Font = new Font("나눔고딕", 10); metroGrid1.Columns[1].Name = "무기명"; // 개요 metroGrid1.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(32, 56, 100); metroGrid1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; for (int i = 2; i < metroGrid1.Columns.Count; i++) { metroGrid1.Columns[i].Name = mainFrm.CompetitionData[0, i + cntStandardMenu - 2].ToString(); metroGrid1.Columns[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; metroGrid1.Columns[i].SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; metroGrid1.Columns[i].Resizable = DataGridViewTriState.False; metroGrid1.Columns[i].DefaultCellStyle.WrapMode = DataGridViewTriState.False; } ////// DB에 있는 무기체계들을 다 읽어와서 뿌려줌 string[] CompetitionWeapon = new string[mainFrm.CompetitionData.GetLength(0)]; for (int i = 1; i < mainFrm.CompetitionData.GetLength(0); i++) { CompetitionWeapon[i - 1] = mainFrm.CompetitionData[i, 3].ToString(); } CompetitionWeapon = CompetitionWeapon.Where(condition => condition != null).ToArray(); for (int i = 0; i < Competition2.RawWeaponDBData.Length; i++) { bool isSimilarWeapon = Competition2.isSimilarWeapon[i] == true ? false : true; if (isSimilarWeapon == true) { metroGrid1.Rows.Add(false); metroGrid1.Rows[i].Cells[1].Value = Competition2.RawWeaponDBData[i]; for (int j = 2; j < metroGrid1.ColumnCount; j++) { int WeaponIndex = Array.IndexOf(CompetitionWeapon, metroGrid1.Rows[i].Cells[1].Value.ToString()); metroGrid1.Rows[i].Cells[j].Value = mainFrm.CompetitionData[WeaponIndex + 1, j + cntStandardMenu - 2]; } } } ////////////////////////////////////////////////// this.metroGrid1.DefaultCellStyle.Font = new Font("나눔고딕", 9); for (int i = 0; i < metroGrid1.RowCount; i++) { metroGrid1.Rows[i].DefaultCellStyle.BackColor = Color.White; metroGrid1.Rows[i].DefaultCellStyle.WrapMode = DataGridViewTriState.False; metroGrid1.Rows[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; } for (int i = 1; i < metroGrid1.ColumnCount; i++) { metroGrid1.Columns[i].Width = 500; metroGrid1.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; metroGrid1.Columns[i].DefaultCellStyle.WrapMode = DataGridViewTriState.False; metroGrid1.Columns[i].ReadOnly = true; } int X = metroGrid1.ColumnHeadersHeight + metroGrid1.Rows.Cast <DataGridViewRow>().Sum(r => r.Height); metroGrid1.Height = X + 18; metroGrid1.CurrentCell = null; metroGrid1.Columns[0].Width = 50; metroButton1.Location = new Point(metroButton1.Location.X, metroGrid1.Location.Y + metroGrid1.Height + 50); //전체 폼 크기 변경 this.Size = new Size(this.Size.Width, metroGrid1.Height + metroButton1.Height + 150); this.CenterToScreen(); }
/// <summary> /// Обязательный метод для поддержки конструктора - не изменяйте содержимое данного метода при помощи редактора кода. /// </summary> private void InitializeComponent() { // // components // this.components = new Container(); // // timer // this.timer = new Timer(this.components); this.timer.Interval = 10000; this.timer.Tick += new EventHandler(this.timer_Tick); // // lblLists // this.lblLists = new Label(); this.lblLists.AutoSize = true; this.lblLists.Size = new Size(78, 13); this.lblLists.Location = new Point(6, 21); this.lblLists.TabIndex = 19; this.lblLists.Name = "lblLists"; this.lblLists.Text = "Списков (шт.):"; // // lblInterval // this.lblInterval = new Label(); this.lblInterval.AutoSize = true; this.lblInterval.Size = new Size(99, 13); this.lblInterval.Location = new Point(6, 81); this.lblInterval.TabIndex = 21; this.lblInterval.Name = "lblInterval"; this.lblInterval.Text = "Автозапуск (сек.):"; // // btnExecute // this.btnExecute = new Button(); this.btnExecute.Size = new Size(285, 30); this.btnExecute.Location = new Point(6, 19); this.btnExecute.TabIndex = 0; this.btnExecute.UseVisualStyleBackColor = true; this.btnExecute.Name = "btnExecute"; this.btnExecute.Text = "Запустить"; this.btnExecute.Click += new EventHandler(this.btnExecute_Click); // // btnClearLog // this.btnClearLog = new Button(); this.btnClearLog.Size = new Size(708, 30); this.btnClearLog.Location = new Point(6, 187); this.btnClearLog.TabIndex = 0; this.btnClearLog.UseVisualStyleBackColor = true; this.btnClearLog.Name = "btnClearLog"; this.btnClearLog.Text = "Очистить"; this.btnClearLog.Click += new EventHandler(this.btnClearLog_Click); // // lblError // this.lblError = new Label(); this.lblError.AutoSize = true; this.lblError.Size = new Size(58, 13); this.lblError.Location = new Point(6, 85); this.lblError.TabIndex = 2; this.lblError.Name = "lblError"; this.lblError.Text = "В ошибки:"; // // lblEnd // this.lblEnd = new Label(); this.lblEnd.AutoSize = true; this.lblEnd.Size = new Size(58, 13); this.lblEnd.Location = new Point(6, 51); this.lblEnd.TabIndex = 2; this.lblEnd.Name = "lblEnd"; this.lblEnd.Text = "До конца:"; // // lblNormal // this.lblNormal = new Label(); this.lblNormal.AutoSize = true; this.lblNormal.Size = new Size(74, 13); this.lblNormal.Location = new Point(6, 18); this.lblNormal.TabIndex = 2; this.lblNormal.Name = "lblNormal"; this.lblNormal.Text = "Нормальная:"; // // rbNormal // this.rbNormal = new RadioButton(); this.rbNormal.AutoSize = true; this.rbNormal.Checked = true; this.rbNormal.Size = new Size(14, 13); this.rbNormal.Location = new Point(110, 18); this.rbNormal.TabStop = true; this.rbNormal.TabIndex = 0; this.rbNormal.UseVisualStyleBackColor = true; this.rbNormal.Name = "rbNormal"; this.rbNormal.CheckedChanged += new EventHandler(this.rbCommon_CheckedChanged); // // rbEnd // this.rbEnd = new RadioButton(); this.rbEnd.AutoSize = true; this.rbEnd.Size = new Size(14, 13); this.rbEnd.Location = new Point(110, 51); this.rbEnd.TabStop = true; this.rbEnd.TabIndex = 1; this.rbEnd.UseVisualStyleBackColor = true; this.rbEnd.Name = "rbEnd"; this.rbEnd.CheckedChanged += new EventHandler(this.rbCommon_CheckedChanged); // // rbError // this.rbError = new RadioButton(); this.rbError.AutoSize = true; this.rbError.Size = new Size(14, 13); this.rbError.Location = new Point(110, 85); this.rbError.TabStop = true; this.rbError.TabIndex = 2; this.rbError.UseVisualStyleBackColor = true; this.rbError.Name = "rbError"; this.rbError.CheckedChanged += new EventHandler(this.rbCommon_CheckedChanged); // // gbLog // this.gbLog = new GroupBox(); this.gbLog.SuspendLayout(); this.gbLog.Controls.Add(this.rtbLog); this.gbLog.Controls.Add(this.btnClearLog); this.gbLog.Size = new Size(720, 220); this.gbLog.Location = new Point(201, 12); this.gbLog.TabStop = false; this.gbLog.TabIndex = 3; this.gbLog.Name = "gbLog"; this.gbLog.Text = "Протокол"; this.gbLog.ResumeLayout(false); this.gbLog.PerformLayout(); // // rtbLog // this.rtbLog = new RichTextBox(); this.rtbLog.Size = new Size(708, 169); this.rtbLog.Location = new Point(6, 15); this.rtbLog.ReadOnly = true; this.rtbLog.ScrollBars = RichTextBoxScrollBars.ForcedBoth; this.rtbLog.TabIndex = 1; this.rtbLog.Name = "rtbLog"; this.rtbLog.Text = String.Empty; // // numCount // this.numCount = new NumericUpDown(); this.numCount.BeginInit(); this.numCount.Minimum = 5; this.numCount.Maximum = 750; this.numCount.Increment = 5; this.numCount.Value = 50; this.numCount.Size = new Size(45, 20); this.numCount.Location = new Point(141, 49); this.numCount.ReadOnly = true; this.numCount.TabIndex = 3; this.numCount.TextAlign = HorizontalAlignment.Right; this.numCount.Name = "numCount"; this.numCount.ValueChanged += new EventHandler(this.numCommon_ValueChanged); this.numCount.EndInit(); // // rbCount // this.rbCount = new RadioButton(); this.rbCount.AutoSize = true; this.rbCount.Size = new Size(14, 13); this.rbCount.Location = new Point(110, 51); this.rbCount.TabIndex = 2; this.rbCount.UseVisualStyleBackColor = true; this.rbCount.Name = "rbCount"; // // lblCount // this.lblCount = new Label(); this.lblCount.AutoSize = true; this.lblCount.Size = new Size(71, 13); this.lblCount.Location = new Point(6, 51); this.lblCount.TabIndex = 10; this.lblCount.Name = "lblCount"; this.lblCount.Text = "Строк (тыс.):"; // // rbLists // this.rbLists = new RadioButton(); this.rbLists.Checked = true; this.rbLists.AutoSize = true; this.rbLists.Size = new Size(14, 13); this.rbLists.Location = new Point(110, 21); this.rbLists.TabStop = true; this.rbLists.TabIndex = 0; this.rbLists.UseVisualStyleBackColor = true; this.rbLists.Name = "rbLists"; this.rbLists.CheckedChanged += new EventHandler(this.rbCommon_CheckedChanged); // // cbAutoExec // this.cbAutoExec = new CheckBox(); this.cbAutoExec.AutoSize = true; this.cbAutoExec.Size = new Size(15, 14); this.cbAutoExec.Location = new Point(110, 81); this.cbAutoExec.TabIndex = 4; this.cbAutoExec.UseVisualStyleBackColor = true; this.cbAutoExec.Name = "cbAutoExec"; this.cbAutoExec.CheckedChanged += new EventHandler(this.cbAutoExec_CheckedChanged); // // numLists // this.numLists = new NumericUpDown(); this.numLists.BeginInit(); this.numLists.Minimum = 5; this.numLists.Maximum = 350; this.numLists.Increment = 5; this.numLists.Value = 75; this.numLists.Size = new Size(45, 20); this.numLists.Location = new Point(141, 19); this.numLists.ReadOnly = true; this.numLists.TabIndex = 1; this.numLists.TextAlign = HorizontalAlignment.Right; this.numLists.Name = "numLists"; this.numLists.ValueChanged += new EventHandler(this.numCommon_ValueChanged); this.numLists.EndInit(); // // numTimer // this.numTimer = new NumericUpDown(); this.numTimer.BeginInit(); this.numTimer.Minimum = 5; this.numTimer.Maximum = 300; this.numTimer.Increment = 5; this.numTimer.Value = 25; this.numTimer.Size = new Size(45, 20); this.numTimer.Location = new Point(141, 79); this.numTimer.ReadOnly = true; this.numTimer.TabIndex = 5; this.numTimer.TextAlign = HorizontalAlignment.Right; this.numTimer.Name = "numTimer"; this.numTimer.ValueChanged += new EventHandler(this.numCommon_ValueChanged); this.numTimer.EndInit(); // // btnSettings // this.btnSettings = new Button(); this.btnSettings.Size = new Size(286, 30); this.btnSettings.Location = new Point(626, 19); this.btnSettings.TabIndex = 2; this.btnSettings.UseVisualStyleBackColor = true; this.btnSettings.Name = "btnSettings"; this.btnSettings.Text = "Настройки"; this.btnSettings.Click += new EventHandler(this.btnSettings_Click); // // bgWorker // this.bgWorker = new BackgroundWorker(); this.bgWorker.WorkerReportsProgress = true; this.bgWorker.WorkerSupportsCancellation = true; this.bgWorker.DoWork += new DoWorkEventHandler(this.bgWorker_DoWork); this.bgWorker.ProgressChanged += new ProgressChangedEventHandler(this.bgWorker_ProgressChanged); this.bgWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(this.bgWorker_RunWorkerCompleted); // // dgvCheck // this.dgvCheck = new DataGridViewCheckBoxColumn(); this.dgvCheck.Resizable = DataGridViewTriState.True; this.dgvCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader; this.dgvCheck.Width = 68; this.dgvCheck.HeaderText = "Обработка"; this.dgvCheck.Name = "dgvCheck"; // // dgvLSTType // this.dgvLSTType = new DataGridViewTextBoxColumn(); this.dgvLSTType.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvLSTType.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvLSTType.HeaderText = "Тип списка"; this.dgvLSTType.DataPropertyName = "LSTType"; this.dgvLSTType.ReadOnly = true; this.dgvLSTType.Name = "dgvLSTType"; // // dgvCNTNew // this.dgvCNTNew = new DataGridViewTextBoxColumn(); this.dgvCNTNew.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvCNTNew.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvCNTNew.HeaderText = "Новые\n(списков / строк)"; this.dgvCNTNew.DataPropertyName = "CNTNew"; this.dgvCNTNew.ReadOnly = true; this.dgvCNTNew.Name = "dgvCNTNew"; // // dgvCNTPartial // this.dgvCNTPartial = new DataGridViewTextBoxColumn(); this.dgvCNTPartial.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvCNTPartial.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvCNTPartial.HeaderText = "Частичные\n(списков / строк)"; this.dgvCNTPartial.DataPropertyName = "CNTPartial"; this.dgvCNTPartial.ReadOnly = true; this.dgvCNTPartial.Name = "dgvCNTPartial"; // // dgvCNTProcess // this.dgvCNTProcess = new DataGridViewTextBoxColumn(); this.dgvCNTProcess.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvCNTProcess.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvCNTProcess.HeaderText = "Обрабатываются\n(списков / строк)"; this.dgvCNTProcess.DataPropertyName = "CNTProcess"; this.dgvCNTProcess.ReadOnly = true; this.dgvCNTProcess.Name = "dgvCNTProcess"; // // dgvCNTTerminate // this.dgvCNTTerminate = new DataGridViewTextBoxColumn(); this.dgvCNTTerminate.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvCNTTerminate.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvCNTTerminate.HeaderText = "Прерванные\n(списков / строк)"; this.dgvCNTTerminate.DataPropertyName = "CNTTerminate"; this.dgvCNTTerminate.ReadOnly = true; this.dgvCNTTerminate.Name = "dgvCNTTerminate"; // // dgvWRKNormal // this.dgvWRKNormal = new DataGridViewTextBoxColumn(); this.dgvWRKNormal.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvWRKNormal.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvWRKNormal.HeaderText = "В нормальную\n(списков / строк)"; this.dgvWRKNormal.DataPropertyName = "WRKNormal"; this.dgvWRKNormal.ReadOnly = true; this.dgvWRKNormal.Name = "dgvWRKNormal"; // // dgvWRKEnd // this.dgvWRKEnd = new DataGridViewTextBoxColumn(); this.dgvWRKEnd.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvWRKEnd.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvWRKEnd.HeaderText = "До конца\n(списков / строк)"; this.dgvWRKEnd.DataPropertyName = "WRKEnd"; this.dgvWRKEnd.ReadOnly = true; this.dgvWRKEnd.Name = "dgvWRKEnd"; // // dgvWRKError // this.dgvWRKError = new DataGridViewTextBoxColumn(); this.dgvWRKError.SortMode = DataGridViewColumnSortMode.NotSortable; this.dgvWRKError.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; this.dgvWRKError.HeaderText = "В ошибки\n(списков / строк)"; this.dgvWRKError.DataPropertyName = "WRKError"; this.dgvWRKError.ReadOnly = true; this.dgvWRKError.Name = "dgvWRKError"; // // gbLists // this.gbLists = new GroupBox(); this.gbLists.SuspendLayout(); this.gbLists.Size = new Size(918, 238); this.gbLists.Location = new Point(3, 238); this.gbLists.Controls.Add(this.dgvLists); this.gbLists.TabIndex = 7; this.gbLists.TabStop = false; this.gbLists.Name = "gbLists"; this.gbLists.Text = "Списки"; this.gbLists.ResumeLayout(false); this.gbLists.PerformLayout(); // // btnRefresh // this.btnRefresh = new Button(); this.btnRefresh.Size = new Size(285, 30); this.btnRefresh.Location = new Point(316, 19); this.btnRefresh.TabIndex = 1; this.btnRefresh.UseVisualStyleBackColor = true; this.btnRefresh.Name = "btnRefresh"; this.btnRefresh.Text = "Обновить"; this.btnRefresh.Click += new EventHandler(this.btnRefresh_Click); // // lblProgress // this.lblProgress = new ToolStripStatusLabel(); this.lblProgress.Size = new Size(63, 17); this.lblProgress.Name = "lblProgress"; this.lblProgress.Text = "Прогресс:"; // // pbProgress // this.pbProgress = new ToolStripProgressBar(); this.pbProgress.AutoSize = false; this.pbProgress.Size = new Size(475, 16); this.pbProgress.Name = "pbProgress"; // // lblStatus // this.lblStatus = new ToolStripStatusLabel(); this.lblStatus.Size = new Size(46, 17); this.lblStatus.Name = "lblStatus"; this.lblStatus.Text = "Статус:"; // // lblComment // this.lblComment = new ToolStripStatusLabel(); this.lblComment.Size = new Size(64, 17); this.lblComment.Name = "lblComment"; this.lblComment.Text = "Ожидание"; // // gbControl // this.gbControl = new GroupBox(); this.gbControl.SuspendLayout(); this.gbControl.Size = new Size(918, 53); this.gbControl.Location = new Point(3, 482); this.gbControl.Controls.Add(this.btnSettings); this.gbControl.Controls.Add(this.btnRefresh); this.gbControl.Controls.Add(this.btnExecute); this.gbControl.TabIndex = 2; this.gbControl.TabStop = false; this.gbControl.Name = "gbControl"; this.gbControl.Text = "Действия"; this.gbControl.ResumeLayout(false); this.gbControl.PerformLayout(); // // gbType // this.gbType = new GroupBox(); this.gbType.SuspendLayout(); this.gbType.Controls.Add(this.lblError); this.gbType.Controls.Add(this.lblEnd); this.gbType.Controls.Add(this.lblNormal); this.gbType.Controls.Add(this.rbNormal); this.gbType.Controls.Add(this.rbEnd); this.gbType.Controls.Add(this.rbError); this.gbType.Size = new Size(190, 110); this.gbType.Location = new Point(3, 12); this.gbType.TabStop = false; this.gbType.TabIndex = 0; this.gbType.Name = "gbType"; this.gbType.Text = "Режим"; this.gbType.ResumeLayout(false); this.gbType.PerformLayout(); // // gbSettings // this.gbSettings = new GroupBox(); this.gbSettings.SuspendLayout(); this.gbSettings.Size = new Size(190, 105); this.gbSettings.Location = new Point(3, 127); this.gbSettings.Controls.Add(this.rbCount); this.gbSettings.Controls.Add(this.rbLists); this.gbSettings.Controls.Add(this.cbAutoExec); this.gbSettings.Controls.Add(this.numCount); this.gbSettings.Controls.Add(this.numLists); this.gbSettings.Controls.Add(this.numTimer); this.gbSettings.Controls.Add(this.lblCount); this.gbSettings.Controls.Add(this.lblLists); this.gbSettings.Controls.Add(this.lblInterval); this.gbSettings.TabStop = false; this.gbSettings.TabIndex = 1; this.gbSettings.Name = "gbSettings"; this.gbSettings.Text = "Настройки"; this.gbSettings.ResumeLayout(false); this.gbSettings.PerformLayout(); // // ssStatus // this.ssStatus = new StatusStrip(); this.ssStatus.SuspendLayout(); this.ssStatus.Size = new Size(924, 22); this.ssStatus.Location = new Point(0, 538); this.ssStatus.Items.Add(this.lblProgress); this.ssStatus.Items.Add(this.lblProgress); this.ssStatus.Items.Add(this.lblStatus); this.ssStatus.Items.Add(this.lblComment); this.ssStatus.Items.Add(this.pbProgress); this.ssStatus.TabIndex = 8; this.ssStatus.Name = "ssStatus"; this.ssStatus.Text = "ssStatus"; this.ssStatus.ResumeLayout(false); this.ssStatus.PerformLayout(); // // dgvLists // this.dgvLists = new DataGridView(); this.dgvLists.AllowUserToAddRows = false; this.dgvLists.AllowUserToDeleteRows = false; this.dgvLists.AllowUserToResizeRows = false; this.dgvLists.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft Sans Serif", 8.25F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(204))); this.dgvLists.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; this.dgvLists.ColumnHeadersDefaultCellStyle.BackColor = SystemColors.Control; this.dgvLists.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.True; this.dgvLists.ColumnHeadersDefaultCellStyle.ForeColor = SystemColors.WindowText; this.dgvLists.ColumnHeadersDefaultCellStyle.SelectionBackColor = SystemColors.Highlight; this.dgvLists.ColumnHeadersDefaultCellStyle.SelectionForeColor = SystemColors.HighlightText; this.dgvLists.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dgvLists.Columns.Add(this.dgvCheck); this.dgvLists.Columns.Add(this.dgvLSTType); this.dgvLists.Columns.Add(this.dgvCNTNew); this.dgvLists.Columns.Add(this.dgvCNTPartial); this.dgvLists.Columns.Add(this.dgvCNTProcess); this.dgvLists.Columns.Add(this.dgvCNTTerminate); this.dgvLists.Columns.Add(this.dgvWRKNormal); this.dgvLists.Columns.Add(this.dgvWRKEnd); this.dgvLists.Columns.Add(this.dgvWRKError); this.dgvLists.EditMode = DataGridViewEditMode.EditOnKeystroke; this.dgvLists.Size = new Size(906, 213); this.dgvLists.Location = new Point(6, 19); this.dgvLists.ShowRowErrors = false; this.dgvLists.ShowCellErrors = false; this.dgvLists.ShowEditingIcon = false; this.dgvLists.ShowCellToolTips = false; this.dgvLists.RowHeadersVisible = false; this.dgvLists.TabIndex = 6; this.dgvLists.Name = "dgvLists"; this.dgvLists.CellContentClick += new DataGridViewCellEventHandler(this.dgvLists_CellContentClick); // // frmMain // this.frmMain = new Form(); this.frmMain.ClientSize = new Size(924, 560); this.frmMain.Controls.Add(this.gbControl); this.frmMain.Controls.Add(this.gbLists); this.frmMain.Controls.Add(this.gbType); this.frmMain.Controls.Add(this.gbLog); this.frmMain.Controls.Add(this.gbSettings); this.frmMain.Controls.Add(this.ssStatus); this.frmMain.MaximizeBox = false; this.frmMain.FormBorderStyle = FormBorderStyle.FixedSingle; this.frmMain.StartPosition = FormStartPosition.CenterScreen; this.frmMain.Name = "AutoRun"; this.frmMain.Text = "Автоматическая обработка реестров"; this.frmMain.Load += new EventHandler(this.AutoRun_Load); this.frmMain.Disposed += new EventHandler(this.AutoRun_Disposed); this.frmMain.ResumeLayout(false); this.frmMain.PerformLayout(); this.frmMain.SuspendLayout(); return; }
public void SetEditable(bool bEditable) { m_bIsEditable = bEditable; if (m_bIsEditable) { // 设定标题栏,默认有个隐藏列 this.Header = new string[] { CS_Delete, CS_StationID, CS_StationName, CS_TimeCollected, CS_WaterStage, CS_WaterFlow, CS_DataState, CS_TimeReceived, CS_ChannelType, CS_MsgType }; // this.HideColomns = new int[] { 8 }; //开启编辑模式,设置可编辑列 DataGridViewCheckBoxColumn deleteCol = new DataGridViewCheckBoxColumn(); base.SetColumnEditStyle(0, deleteCol); //// 设置采集时间编辑列 //CalendarColumn collectionCol = new CalendarColumn(); //base.SetColumnEditStyle(2, collectionCol); // 水位编辑列 DataGridViewNumericUpDownColumn waterStage = new DataGridViewNumericUpDownColumn() { Minimum = 0, Maximum = 65537, DecimalPlaces = 2 /*好像是设置小数点后面的位数*/ }; base.SetColumnEditStyle(4, waterStage); // 时段雨量编辑列 DataGridViewNumericUpDownColumn waterFlow = new DataGridViewNumericUpDownColumn() { Minimum = 0, Maximum = 65537, DecimalPlaces = 3 /*好像是设置小数点后面的位数*/ }; base.SetColumnEditStyle(5, waterFlow); // 数据状态,可编辑列 DataGridViewComboBoxColumn dataStateCol = new DataGridViewComboBoxColumn(); dataStateCol.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; dataStateCol.Items.AddRange(new object[] { CS_DataState_Normal, CS_DataState_AbNormal }); base.SetColumnEditStyle(6, dataStateCol); // 接收时间 CalendarColumn recvTime = new CalendarColumn(); base.SetColumnEditStyle(7, recvTime); // 通讯方式,不可编辑 // 报文类型,不可编辑 // 设置删除列的宽度 this.Columns[0].Width = 40; //删除列宽度为20 this.Columns[3].Width = 125; this.Columns[7].Width = 125; } else { this.Columns[2].Width = 125; this.Columns[5].Width = 125; } }
protected override void tworzKolumny() { DateTime wybranyMiesiacRok = (DateTime)listaDat.Cb_miesiace.SelectedValue; //this.close int miesiac = wybranyMiesiacRok.Month; int rok = -1; try { rok = wybranyMiesiacRok.Year; if (rok < 1000) { throw new Exception(); } } catch (Exception) { miesiac = -1; } //typDanych = ETypDanych.obecnosc; DataGridViewColumn newCol = new DataGridViewColumn(); DataGridViewCell cell = new DataGridViewTextBoxCell(); newCol.CellTemplate = cell; newCol.HeaderText = "ID"; newCol.Name = "ID"; newCol.Visible = false; dgv.Columns.Add(newCol); newCol = new DataGridViewColumn(); cell = new DataGridViewTextBoxCell(); newCol.CellTemplate = cell; newCol.HeaderText = "nazwa przedmiotu"; newCol.Name = "nazwa_przedmiotu"; newCol.Visible = true; newCol.ReadOnly = true; dgv.Columns.Add(newCol); if (miesiac <= 0) { for (int i = 0; i < listaDat.zbior.Count; i++) { if (typDanych == ETypDanych.ocena) { newCol = new DataGridViewColumn(); cell = new DataGridViewTextBoxCell(); newCol.ReadOnly = false; newCol.CellTemplate = cell; } else { newCol = new DataGridViewCheckBoxColumn(); DataGridViewCheckBoxCell c = new DataGridViewCheckBoxCell(); newCol.CellTemplate = c; } newCol.HeaderText = listaDat.zbior[i].Dzien.ToShortDateString(); newCol.Name = listaDat.zbior[i].Dzien.ToShortDateString(); newCol.Visible = true; dgv.Columns.Add(newCol); } } else { List <DateTime> ld = new List <DateTime>(); foreach (data d in listaDat.zbior) { ld.Add(d.Dzien); } List <DateTime> ldd = null; if (rok > 0) { ldd = ld.Select(d => new DateTime(d.Year, d.Month, d.Day)).Where(d => d.Month == wybranyMiesiacRok.Month && d.Year == rok).ToList(); } else { ldd = ld.Select(d => new DateTime(d.Year, d.Month, d.Day)).Where(d => d.Month == wybranyMiesiacRok.Month).ToList(); } foreach (DateTime d in ldd) { if (typDanych == ETypDanych.ocena) { newCol = new DataGridViewColumn(); cell = new DataGridViewTextBoxCell(); newCol.ReadOnly = false; newCol.CellTemplate = cell; } else { newCol = new DataGridViewCheckBoxColumn(); DataGridViewCheckBoxCell c = new DataGridViewCheckBoxCell(); newCol.CellTemplate = c; } newCol.HeaderText = d.ToShortDateString(); newCol.Name = d.ToShortDateString(); newCol.Visible = true; dgv.Columns.Add(newCol); } } newCol = new DataGridViewColumn(); cell = new DataGridViewTextBoxCell(); newCol.ReadOnly = false; newCol.CellTemplate = cell; newCol.HeaderText = newCol.Name = (typDanych == ETypDanych.ocena) ? "srednia" : "frekwencja"; newCol.Visible = true; newCol.ReadOnly = true; newCol.DefaultCellStyle.BackColor = Color.Beige; dgv.Columns.Add(newCol); }
private void GetCustomProperty() { try { dgvCustomProperty.Columns.Clear(); //设置读取XML文件起点 XmlNodeList xmlNodeListAttribute = xmlDocument.SelectNodes("/Properties/Attributes/Attribute"); foreach (XmlNode node in xmlNodeListAttribute) { DataGridViewColumn dataGridViewColumn; switch (node.Attributes["ShowType"].Value) { case "TextBox": dataGridViewColumn = new DataGridViewTextBoxColumn(); break; case "CheckBox": dataGridViewColumn = new DataGridViewCheckBoxColumn(); dataGridViewColumn.ValueType = System.Type.GetType("System.Boolean"); break; case "ComboBox": dataGridViewColumn = new DataGridViewComboBoxColumn(); if (Convert.ToBoolean(node.Attributes["DataBind"].Value) == true) { XmlNodeList xmlNodeListDataDict = xmlDocumentDataDict.SelectNodes("/DataDicts/DataDict"); foreach (XmlNode nodeDataDict in xmlNodeListDataDict) { if (node.Attributes["DataSource"].Value == nodeDataDict.Attributes["Name"].Value) { foreach (XmlNode nodeDataDictData in nodeDataDict.ChildNodes) { if ("Data" == nodeDataDictData.Name) { ((DataGridViewComboBoxColumn)dataGridViewColumn).Items.Add(nodeDataDictData.Attributes["Name"].Value); } } } } } break; default: dataGridViewColumn = new DataGridViewTextBoxColumn(); break; } dataGridViewColumn.Name = node.Attributes["Name"].Value; dataGridViewColumn.HeaderText = node.Attributes["Remark"].Value; dgvCustomProperty.Columns.Add(dataGridViewColumn); } XmlNodeList xmlNodeListProperty = xmlDocument.SelectNodes("/Properties/Property"); foreach (XmlNode node in xmlNodeListProperty) { object[] obj = new object[node.Attributes.Count]; int i = 0; foreach (XmlAttribute attribute in node.Attributes) { obj[i] = attribute.Value; i++; } dgvCustomProperty.Rows.Add(obj); } } catch (Exception) { throw; } }
private void frmWareHouseTransfers_Load(object sender, EventArgs e) { formloaded = false; Submit = true; core = new Util(); using (var context = new TTI2Entities()) { QueryParms = new CustomerServicesParameters(); cmboFrom.DataSource = context.TLADM_Departments.Where(x => x.Dep_IsCMT).ToList(); cmboFrom.ValueMember = "Dep_Id"; cmboFrom.DisplayMember = "Dep_Description"; cmboFrom.SelectedValue = -1; cmboTo.DataSource = context.TLADM_WhseStore.Where(x => x.WhStore_WhseOrStore).ToList(); cmboTo.ValueMember = "WhStore_Id"; cmboTo.DisplayMember = "WhStore_Description"; cmboTo.SelectedValue = -1; var Styles = context.TLADM_Styles.OrderBy(x => x.Sty_Description).ToList(); foreach (var Style in Styles) { cmboStyles.Items.Add(new CustomerServices.CheckComboBoxItem(Style.Sty_Id, Style.Sty_Description, false)); } var Colours = context.TLADM_Colours.Where(x => !(bool)x.Col_Discontinued).OrderBy(x => x.Col_Display).ToList(); foreach (var Colour in Colours) { cmboColours.Items.Add(new CustomerServices.CheckComboBoxItem(Colour.Col_Id, Colour.Col_Display, false)); } var Sizes = context.TLADM_Sizes.Where(x => !(bool)x.SI_Discontinued).OrderBy(x => x.SI_DisplayOrder).ToList(); foreach (var Size in Sizes) { cmboSizes.Items.Add(new CustomerServices.CheckComboBoxItem(Size.SI_id, Size.SI_Description, false)); } DGVResults.Visible = false; oTxtA = new DataGridViewTextBoxColumn(); oTxtA.Visible = false; oTxtA.ValueType = typeof(int); oTxtA.ReadOnly = true; DGVResults.Columns.Add(oTxtA); oChkA = new DataGridViewCheckBoxColumn(); oChkA.Visible = true; oChkA.ValueType = typeof(Boolean); oChkA.HeaderText = "Select"; DGVResults.Columns.Add(oChkA); oTxtB = new DataGridViewTextBoxColumn(); oTxtB.Visible = true; oTxtB.HeaderText = "Box Detail"; oTxtB.ReadOnly = true; oTxtB.ValueType = typeof(string); DGVResults.Columns.Add(oTxtB); oTxtC = new DataGridViewTextBoxColumn(); oTxtC.Visible = true; oTxtC.HeaderText = "Box Qty"; oTxtC.ReadOnly = true; oTxtC.ValueType = typeof(int); DGVResults.Columns.Add(oTxtC); oTxtD = new DataGridViewTextBoxColumn(); oTxtD.Visible = true; oTxtD.HeaderText = "Box Weight"; oTxtD.ReadOnly = true; oTxtD.ValueType = typeof(decimal); DGVResults.Columns.Add(oTxtD); oTxtE = new DataGridViewTextBoxColumn(); oTxtE.Visible = true; oTxtE.HeaderText = "Customer"; oTxtE.ReadOnly = true; oTxtE.ValueType = typeof(string); DGVResults.Columns.Add(oTxtE); oTxtF = new DataGridViewTextBoxColumn(); oTxtF.Visible = true; oTxtF.HeaderText = "Style"; oTxtF.ReadOnly = true; oTxtF.ValueType = typeof(string); DGVResults.Columns.Add(oTxtF); oTxtG = new DataGridViewTextBoxColumn(); oTxtG.Visible = true; oTxtG.HeaderText = "Colour"; oTxtG.ReadOnly = true; oTxtG.ValueType = typeof(string); DGVResults.Columns.Add(oTxtG); oTxtH = new DataGridViewTextBoxColumn(); oTxtH.Visible = true; oTxtH.HeaderText = "Size"; oTxtH.ReadOnly = true; oTxtH.ValueType = typeof(string); DGVResults.Columns.Add(oTxtH); DGVResults.AutoGenerateColumns = false; DGVResults.AllowUserToAddRows = false; formloaded = true; } }
private void PRM_PRF_002_Load(object sender, EventArgs e) // 메인 그리드뷰 { ((MainForm)this.MdiParent).MyUpdateEvent += new System.EventHandler(this.MyUpdateShow); //수정 이벤트 등록 ((MainForm)this.MdiParent).RefreshFormEvent += new System.EventHandler(this.RefreshFormShow); // 새로고침 dgvMainGrid.CellDoubleClick += DgvMainGrid_CellDoubleClick; //메인그리드뷰 더블클릭 dgvSubGrid.CellDoubleClick += DgvSubGrid_CellDoubleClick; //서브그리드뷰 더블클릭 dgvMainGrid.CellContentClick += dgvMainGrid_CellContentClick; //체크박스 dgvSubGrid.CellContentClick += dgvSubGrid_CellContentClick; //체크박스 #region 메인 그리드뷰 체크박스 DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn(); chk.HeaderText = ""; chk.Name = "chk"; chk.Width = 30; dgvMainGrid.Columns.Add(chk); Point headerLocation = dgvMainGrid.GetCellDisplayRectangle(0, -1, true).Location; headerCheckBox.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); headerCheckBox.BackColor = Color.White; headerCheckBox.Size = new Size(18, 18); headerCheckBox.Click += new EventHandler(headerCheckBox_Click); dgvMainGrid.Controls.Add(headerCheckBox); #endregion #region 서브 그리드뷰 체크박스 DataGridViewCheckBoxColumn chkSub = new DataGridViewCheckBoxColumn(); chkSub.HeaderText = ""; chkSub.Name = "Subchk"; chkSub.Width = 30; dgvSubGrid.Columns.Add(chkSub); Point headerLocationSub = dgvSubGrid.GetCellDisplayRectangle(0, -1, true).Location; headerCheckBox1.Location = new Point(headerLocationSub.X + 8, headerLocationSub.Y + 2); headerCheckBox1.BackColor = Color.White; headerCheckBox1.Size = new Size(18, 18); headerCheckBox1.Click += new EventHandler(SubheaderCheckBox_Click); dgvSubGrid.Controls.Add(headerCheckBox1); #endregion #region 메인그리드뷰 DatagridviewDesigns.SetDesign(dgvMainGrid); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "생산일자", "Prd_Date", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업지시상태", "Wo_Status", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업지시번호", "Workorderno", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "품목코드", "Item_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "품목명", "Item_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "작업장", "Wc_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "투입수량", "In_Qty_Main", true, 100, DataGridViewContentAlignment.MiddleRight, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "산출수량", "Out_Qty_Main", true, 100, DataGridViewContentAlignment.MiddleRight, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvMainGrid, "생산수량", "Prd_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, true); #endregion #region 서브그리드뷰 DatagridviewDesigns.SetDesign(dgvSubGrid); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "팔렛트번호", "Pallet_No", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급", "Grade_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급상세 코드", "Grade_Detail_Code", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "등급상세명", "Grade_Detail_Name", true, 100, DataGridViewContentAlignment.MiddleCenter, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "수량", "In_Qty", true, 100, DataGridViewContentAlignment.MiddleRight, true); DatagridviewDesigns.AddNewColumnToDataGridView_Autosize(dgvSubGrid, "팔렛트 마감 여부", "Use_YN", true, 100, DataGridViewContentAlignment.MiddleCenter, true); #endregion DataLoad(); // 그리드뷰 }
//--------------------------------------------------------------------------- // setupGridView //--------------------------------------------------------------------------- static public void setupGridView(DataGridView gridView, string dataType, string detailType, string groupType) { gridView.AutoGenerateColumns = false; gridView.Columns.Clear(); foreach (GridDefData dataDef in mGridDefData.mDatas) { if (dataDef.mType != dataType) { continue; } if (dataDef.mDisableAdd) { gridView.AllowUserToAddRows = false; } else { gridView.AllowUserToAddRows = true; } foreach (GridDefGroup groupDef in dataDef.mGroups) { if (groupDef.mGroupName != groupType) { continue; } List <GridDefColumn> columns = null; if (detailType != "") { foreach (GridDefDetail detail in groupDef.mDetails) { if (detail.mDataName == detailType) { columns = detail.mColumns; break; } } if (columns == null) { break; } } else { columns = groupDef.mColumns; } foreach (GridDefColumn colDef in columns) { DataGridViewColumn col = null; if (colDef.mColumnType == "Text") { col = new DataGridViewTextBoxColumn(); } else if (colDef.mColumnType == "Check") { col = new DataGridViewCheckBoxColumn(); } else if (colDef.mColumnType == "Combo") { DataGridViewComboBoxColumn comboCol = new DataGridViewComboBoxColumn(); Object dataSource = getDataSource(colDef.mDataSource); if (dataSource != null) { comboCol.DataSource = dataSource; comboCol.ValueMember = colDef.mValueMember; comboCol.DisplayMember = colDef.mDisplayMember; } else { foreach (string itemDef in colDef.mItems) { comboCol.Items.Add(itemDef); } } col = comboCol; } if (col != null) { col.DataPropertyName = colDef.mDataName; if (colDef.mValueType == "int") { col.ValueType = typeof(int); } else if (colDef.mValueType == "string") { col.ValueType = typeof(string); } else if (colDef.mValueType == "bool") { col.ValueType = typeof(bool); } else if (colDef.mValueType == "float") { col.ValueType = typeof(float); } if (colDef.mHeaderText.Length > 0) { col.HeaderText = colDef.mHeaderText; } col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; col.ReadOnly = colDef.mReadOnly; col.Frozen = colDef.mFrozen; gridView.Columns.Add(col); } } break; } break; } }
private void Header() { dgv_TransferAccount.Rows.Clear(); dgv_TransferAccount.Columns.Clear(); DataGridViewTextBoxColumn col; DataGridViewCheckBoxColumn check; check = new DataGridViewCheckBoxColumn(); check.Name = "入金"; check.Width = 30; check.ReadOnly = false; check.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; check.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgv_TransferAccount.Columns.Add(check); col = new DataGridViewTextBoxColumn(); col.Name = "契約ID"; col.Width = 50; col.ReadOnly = true; col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgv_TransferAccount.Columns.Add(col); col = new DataGridViewTextBoxColumn(); col.Name = "顧客名"; col.Width = 100; col.ReadOnly = true; col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgv_TransferAccount.Columns.Add(col); col = new DataGridViewTextBoxColumn(); col.Name = "口座名"; col.Width = 80; col.ReadOnly = true; col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgv_TransferAccount.Columns.Add(col); col = new DataGridViewTextBoxColumn(); col.Name = "口座番号"; col.Width = 80; col.ReadOnly = true; col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgv_TransferAccount.Columns.Add(col); col = new DataGridViewTextBoxColumn(); col.Name = "合計金額"; col.Width = 80; col.ReadOnly = true; col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dgv_TransferAccount.Columns.Add(col); //col = new DataGridViewTextBoxColumn(); //col.Name = "駐車場名"; //col.Width = 100; //col.ReadOnly = true; //col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //dgv_TransferAccount.Columns.Add(col); //col = new DataGridViewTextBoxColumn(); //col.Name = "区画名"; //col.Width = 100; //col.ReadOnly = true; //col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; //dgv_TransferAccount.Columns.Add(col); }
/// <summary> /// <para>종류 : Form Load 메서드</para> /// <para>기능 : 각종 초기세팅</para> /// <para>로직 : 1. 좌상단 텍스트에 현재시간 할당</para> /// <para> 2. Login으로 부터 받은 employee객체를 활용하여 우상단 텍스트에 이름 및 권한 할당</para> /// <para> 3. 매장테이블에서 매장 및 관리자 컬럼을 가져오는 query를 통해 Crud.ReadToGrid를 활용하여 dataset을 얻고 좌측 테이블에 tempFuncForWinform.setDataGridView 메서드를 통해 할당</para> /// <para> 4. 테이블에 checkBoxColumn추가, readonly 설정, cellSelection제거, </para> /// <para> 5. dateTimePicker 현재시간으로 초기화</para> /// <para> 6. textBox 가운데 정렬 및 폰트 설정</para> /// <para> 7. 주소검색, 직원검색 버튼 비활성화</para> /// <para> 8. 라벨 및 dateTimePicker폰트 설정</para> /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void StoreManage_Load(object sender, EventArgs e) { //1. 왼쪽 메뉴 버튼 동적 생성 후에 필요 //List<string> menuList = getMenuList(); //foreach (var m in menuList) //{ // makebutton(this, coord, dictButtonProperty); //} //2. Panel_Top_Left 현재시간 할당 labelCurrentDate.Text = DateTime.Now.ToString("yyyy - MM - dd : tt hh : mm"); //3. Panel_Top_Right 관리자 이름 할당 if (employee.st_emp_level != 1) { labelAdminName.Text = employee.st_emp_member + " (관리자)"; } else { labelAdminName.Text = employee.st_emp_member + " (비관리자)"; } //4. Panel_Left_Second datatable 할당 string queryReadStore = sqlQuery.select_From_("st_table", new string[] { "st_name", "st_manager" }); DataSet dataSetStore = crud.ReadToGrid_MySql(queryReadStore); //컬럼이름 할당 dataSetStore.Tables[0].Columns["st_name"].ColumnName = "매장명"; dataSetStore.Tables[0].Columns["st_manager"].ColumnName = "관리자"; tempFuncForWinform.setDataGridView(dataSetStore, dataGridViewStore); //check박스 컬럼 추가 DataGridViewCheckBoxColumn dgvCmb = new DataGridViewCheckBoxColumn(); dgvCmb.ValueType = typeof(bool); dgvCmb.Name = ""; dataGridViewStore.Columns.Insert(0, dgvCmb); dataGridViewStore.ClearSelection(); dataGridViewStore.Columns[0].Width = 30; dataGridViewStore.ReadOnly = false; dataGridViewStore.Columns[1].ReadOnly = true; dataGridViewStore.Columns[2].ReadOnly = true; // datepicker init dateTimePickerContractDate.Value = DateTime.Now; dateTimePickerContractDate2.Value = dateTimePickerContractDate.Value.AddYears(1); dateTimePickerManagementExpense.Value = DateTime.Now; dateTimePickerElectricityExpense.Value = DateTime.Now; dateTimePickerWaterExpense.Value = DateTime.Now; // 텍스트 가운데 정렬 textBoxSetting(); //로드시 readonly readonlyTextBoxAndDatetimePicker(true); //로드시 buttontogglle false buttonEnableToggle(false, buttonForCreateAndUpdateArray); //폰트설정 labelSetting(); //폰트설정 dateTimePickerSetting(); }
/// <summary> /// 外部调用可控制宽度,嘿嘿 /// </summary> /// <param name="bEnable"></param> public void SetEditMode(bool bEnable) { if (bEnable) { // 设定标题栏,默认有个隐藏列 this.Header = new string[] { CS_StationId, CS_BGTM, CS_PTNO, CS_ZR, CS_Q1, CS_Q2, CS_Q3, CS_Q4, CS_Q5, CS_Q6, CS_currQ }; //this.HideColomns = new int[] //{ // 12 /*CS_RecordId*/ //}; //开启编辑模式,设置可编辑列 DataGridViewCheckBoxColumn deleteCol = new DataGridViewCheckBoxColumn(); base.SetColumnEditStyle(0, deleteCol); ////// 设置站号编辑列 //DataGridViewNumericUpDownColumn stationIdCol = new DataGridViewNumericUpDownColumn(); //// stationId.Maximum = Decimal.MaxValue; //base.SetColumnEditStyle(1, stationIdCol); ////// 设置站号编辑列 //DataGridViewNumericUpDownColumn PTNOCol = new DataGridViewNumericUpDownColumn(); //// stationId.Maximum = Decimal.MaxValue; //base.SetColumnEditStyle(3, PTNOCol); // 设置水位编辑列 DataGridViewNumericUpDownColumn waterCol = new DataGridViewNumericUpDownColumn(); waterCol.Maximum = Decimal.MaxValue; waterCol.Minimum = Decimal.MinValue; waterCol.DecimalPlaces = 2; base.SetColumnEditStyle(4, waterCol); //// 设置流量1编辑列 DataGridViewNumericUpDownColumn Q1Col = new DataGridViewNumericUpDownColumn(); Q1Col.Maximum = Decimal.MaxValue; Q1Col.Minimum = Decimal.MinValue; Q1Col.DecimalPlaces = 3; base.SetColumnEditStyle(5, Q1Col); //// 设置流量2编辑列 DataGridViewNumericUpDownColumn Q2Col = new DataGridViewNumericUpDownColumn(); Q2Col.Maximum = Decimal.MaxValue; Q2Col.Minimum = Decimal.MinValue; Q2Col.DecimalPlaces = 3; base.SetColumnEditStyle(6, Q2Col); //// 设置流量3编辑列 DataGridViewNumericUpDownColumn Q3Col = new DataGridViewNumericUpDownColumn(); Q3Col.Maximum = Decimal.MaxValue; Q3Col.Minimum = Decimal.MinValue; Q3Col.DecimalPlaces = 3; base.SetColumnEditStyle(7, Q3Col); //// 设置流量4编辑列 DataGridViewNumericUpDownColumn Q4Col = new DataGridViewNumericUpDownColumn(); Q4Col.Maximum = Decimal.MaxValue; Q4Col.Minimum = Decimal.MinValue; Q4Col.DecimalPlaces = 3; base.SetColumnEditStyle(8, Q4Col); //// 设置流量5编辑列 DataGridViewNumericUpDownColumn Q5Col = new DataGridViewNumericUpDownColumn(); Q5Col.Maximum = Decimal.MaxValue; Q5Col.Minimum = Decimal.MinValue; Q5Col.DecimalPlaces = 3; base.SetColumnEditStyle(9, Q5Col); //// 设置流量6编辑列 DataGridViewNumericUpDownColumn Q6Col = new DataGridViewNumericUpDownColumn(); Q6Col.Maximum = Decimal.MaxValue; Q6Col.Minimum = Decimal.MinValue; Q6Col.DecimalPlaces = 3; base.SetColumnEditStyle(10, Q6Col); var cmb_currQ = new DataGridViewComboBoxColumn(); cmb_currQ.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; cmb_currQ.Items.Add("1"); cmb_currQ.Items.Add("2"); cmb_currQ.Items.Add("3"); cmb_currQ.Items.Add("4"); cmb_currQ.Items.Add("5"); cmb_currQ.Items.Add("6"); base.SetColumnEditStyle(11, cmb_currQ); // 设置删除列的宽度 this.Columns[0].Width = 15; //删除列宽度为20 this.Columns[2].Width = 25; //删除列宽度为25 this.Columns[11].Width = 25; //删除列宽度为25 } else { // 只读模式未编写 // 设定标题栏,默认有个隐藏列 this.Header = new string[] { CS_StationId, CS_BGTM, CS_PTNO, CS_ZR, CS_Q1, CS_Q2, CS_Q3, CS_Q4, CS_Q5, CS_Q6, CS_currQ }; //this.Columns[0].Width = 25; //删除列宽度为25 //this.Columns[1].Width = 120; //删除列宽度为25 //this.Columns[2].Width = 15; //删除列宽度为25 //this.Columns[3].Width = 15; //删除列宽度为25 //this.Columns[4].Width = 40; //删除列宽度为25 //this.Columns[5].Width = 40; //删除列宽度为25 //this.Columns[6].Width = 40; //删除列宽度为25 //this.Columns[7].Width = 40; //删除列宽度为25 //this.Columns[8].Width = 40; //删除列宽度为25 //this.Columns[9].Width = 40; //删除列宽度为25 //this.Columns[10].Width = 25; //删除列宽度为25 AutoSizeColumn(this); this.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; //this.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } }
public void LoadEditProdList() { int i; //getting first already included products in a transaction if (rent != null) { rent.GetProducts(); //productsSelected = new int[rent.DTable.Rows.Count]; DataRow rRow; for (i = 0; i < rent.DTable.Rows.Count; i++) { rRow = rent.DTable.Rows[i]; productsSelected[i] = Int32.Parse(rRow["ID"].ToString()); } } if (sales != null) { sales.GetProducts(); //productsSelected = new int[sales.DTable.Rows.Count]; DataRow sRow; for (i = 0; i < sales.DTable.Rows.Count; i++) { sRow = sales.DTable.Rows[i]; productsSelected[i] = Int32.Parse(sRow["ID"].ToString()); } } SelectList slist = new SelectList(); slist.GetAllProductsAvailable(); dtSelProdList.DataSource = slist.DTable; //inserting checkbox control DataGridViewCheckBoxColumn chkbox = new DataGridViewCheckBoxColumn() { Name = "Check", FalseValue = 0, TrueValue = 1, Visible = true }; dtSelProdList.Columns.Insert(0, chkbox); //initializing checkboxes be checked foreach (DataGridViewRow row in dtSelProdList.Rows) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; if (row.Cells["ID"].Value != null) { for (i = 0; i < productsSelected.Length; i++) { if (Int32.Parse(row.Cells[1].Value.ToString()) == productsSelected[i]) { chk.Value = chk.TrueValue; break; } else { chk.Value = chk.FalseValue; } } } } }
/// <summary> /// データグリッドビューの定義を行います /// </summary> /// <param name="tempDGV">データグリッドビューオブジェクト</param> public static void Setting(DataGridView tempDGV) { try { //フォームサイズ定義 // 列スタイルを変更する tempDGV.EnableHeadersVisualStyles = false; tempDGV.ColumnHeadersDefaultCellStyle.BackColor = Color.SteelBlue; tempDGV.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; // 列ヘッダー表示位置指定 tempDGV.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; // 列ヘッダーフォント指定 tempDGV.ColumnHeadersDefaultCellStyle.Font = new Font("Meiryo UI", 9, FontStyle.Regular); // データフォント指定 tempDGV.DefaultCellStyle.Font = new Font("Meiryo UI", (float)9, FontStyle.Regular); // 行の高さ tempDGV.ColumnHeadersHeight = 18; tempDGV.RowTemplate.Height = 18; // 全体の高さ tempDGV.Height = 470; // 奇数行の色 tempDGV.AlternatingRowsDefaultCellStyle.BackColor = Color.Lavender; // 各列幅指定 tempDGV.Columns.Add("col1", "番号"); tempDGV.Columns.Add("col2", "クライアント名"); tempDGV.Columns.Add("col13", "フリガナ"); tempDGV.Columns.Add("col3", "担当者"); tempDGV.Columns.Add("col4", "発行日"); tempDGV.Columns.Add("col5", "請求金額"); tempDGV.Columns.Add("col6", "入金予定日"); tempDGV.Columns.Add("col7", "入金日"); tempDGV.Columns.Add("col8", "入金額"); tempDGV.Columns.Add("col9", "入金残高"); DataGridViewCheckBoxColumn cbc = new DataGridViewCheckBoxColumn(); tempDGV.Columns.Add(cbc); tempDGV.Columns[10].HeaderText = "入金済"; tempDGV.Columns[10].Name = "col10"; tempDGV.Columns.Add("col11", "請求書ID"); tempDGV.Columns.Add("col12", "備考"); // 2015/07/22 //tempDGV.Columns[1].Frozen = true; // 2015/07/22 tempDGV.Columns[0].Width = 60; tempDGV.Columns[1].Width = 220; tempDGV.Columns[2].Width = 160; tempDGV.Columns[3].Width = 100; tempDGV.Columns[4].Width = 100; tempDGV.Columns[5].Width = 100; tempDGV.Columns[6].Width = 100; tempDGV.Columns[7].Width = 100; tempDGV.Columns[8].Width = 100; tempDGV.Columns[9].Width = 100; tempDGV.Columns[10].Width = 60; tempDGV.Columns[12].Width = 200; tempDGV.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; tempDGV.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; tempDGV.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; tempDGV.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; tempDGV.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; tempDGV.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; tempDGV.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; tempDGV.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; //tempDGV.Columns[3].DefaultCellStyle.Format = "yyyy/M/dd"; //tempDGV.Columns[4].DefaultCellStyle.Format = "#,##0"; //tempDGV.Columns[5].DefaultCellStyle.Format = "yyyy/M/dd"; //tempDGV.Columns[7].DefaultCellStyle.Format = "#,##0"; //tempDGV.Columns[8].DefaultCellStyle.Format = "#,##0"; //請求書IDを非表示とする tempDGV.Columns[11].Visible = false; // 行ヘッダを表示しない tempDGV.RowHeadersVisible = false; // 選択モード tempDGV.SelectionMode = DataGridViewSelectionMode.CellSelect; tempDGV.MultiSelect = false; // 編集不可とする tempDGV.ReadOnly = false; // 編集可・不可の指定 foreach (DataGridViewColumn d in tempDGV.Columns) { if (d.Name == "col10" || d.Name == "col12") { d.ReadOnly = false; } else { d.ReadOnly = true; } } // 追加行表示しない tempDGV.AllowUserToAddRows = false; // データグリッドビューから行削除を禁止する tempDGV.AllowUserToDeleteRows = false; // 手動による列移動の禁止 tempDGV.AllowUserToOrderColumns = false; // 列サイズ変更禁止 tempDGV.AllowUserToResizeColumns = false; // 行サイズ変更禁止 tempDGV.AllowUserToResizeRows = false; // 行ヘッダーの自動調節 //tempDGV.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders; // 罫線 tempDGV.BorderStyle = BorderStyle.Fixed3D; tempDGV.AdvancedColumnHeadersBorderStyle.All = DataGridViewAdvancedCellBorderStyle.None; tempDGV.CellBorderStyle = DataGridViewCellBorderStyle.None; } catch (Exception e) { MessageBox.Show(e.Message, "エラーメッセージ", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void refreshGamesDataSet() { //dataGridGames.AutoGenerateColumns = false; dataGridGames.Columns.Clear(); dataGridGames.AutoGenerateColumns = false; //Hook up the db.dsGames dataset to the table db.refreshGameDataset(platform_id); dataGridGames.DataSource = db.dsGames.Tables[0]; DataSet gameGenreDataSet = db.getDataSet("select genre_name, id from genres order by genre_name"); DataGridViewComboBoxColumn colGenre = new DataGridViewComboBoxColumn(); colGenre.HeaderText = "Genre"; colGenre.DataSource = gameGenreDataSet.Tables[0].DefaultView; colGenre.FlatStyle = FlatStyle.Flat; colGenre.DataPropertyName = "genre_id"; colGenre.DisplayMember = "genre_name"; colGenre.ValueMember = "id"; DataGridViewCheckBoxColumn colActive = new DataGridViewCheckBoxColumn(); colActive.HeaderText = "Active"; colActive.Name = "active"; colActive.DataPropertyName = "active"; colActive.SortMode = DataGridViewColumnSortMode.Automatic; dataGridGames.Columns.Add(colActive); DataGridViewCheckBoxColumn colFav = new DataGridViewCheckBoxColumn(); colFav.HeaderText = "Favourite"; colFav.Name = "favourite"; colFav.DataPropertyName = "favourite"; colFav.SortMode = DataGridViewColumnSortMode.Automatic; dataGridGames.Columns.Add(colFav); dataGridGames.Columns.Add("name", "Name"); dataGridGames.Columns["name"].DataPropertyName = "name"; dataGridGames.Columns.Add("file_name", "File Name"); dataGridGames.Columns["file_name"].DataPropertyName = "file_name"; dataGridGames.Columns.Add("gamedb_id", "GamesDB ID"); dataGridGames.Columns["gamedb_id"].DataPropertyName = "gamedb_id"; dataGridGames.Columns.Add("description", "Description"); dataGridGames.Columns["description"].DataPropertyName = "description"; dataGridGames.Columns.Add("release_year", "Release Year"); dataGridGames.Columns["release_year"].DataPropertyName = "release_year"; dataGridGames.Columns.Add("rating", "Rating"); dataGridGames.Columns["rating"].DataPropertyName = "rating"; dataGridGames.Columns.Add("players", "Players"); dataGridGames.Columns["players"].DataPropertyName = "players"; DataGridViewCheckBoxColumn colCo_op = new DataGridViewCheckBoxColumn(); colCo_op.HeaderText = "Co-op"; colCo_op.Name = "co_op"; colCo_op.DataPropertyName = "co_op"; colCo_op.SortMode = DataGridViewColumnSortMode.Automatic; dataGridGames.Columns.Add(colCo_op); dataGridGames.Columns.Add("publisher", "Publisher"); dataGridGames.Columns["publisher"].DataPropertyName = "publisher"; dataGridGames.Columns.Add("developer", "Developer"); dataGridGames.Columns["developer"].DataPropertyName = "developer"; dataGridGames.Columns.Add("gamedb_stars", "GamesDB Stars"); dataGridGames.Columns["gamedb_stars"].DataPropertyName = "gamedb_stars"; dataGridGames.Columns.Add(colGenre); }
///<summary> /// Constructs the <see cref="DataGridViewCheckBoxColumnVWG"/> which is a wrapper around the <see cref="DataGridViewCheckBoxColumn"/> ///</summary> ///<param name="dataGridViewColumn"></param> public DataGridViewCheckBoxColumnVWG(DataGridViewCheckBoxColumn dataGridViewColumn) : base(dataGridViewColumn) { _dataGridViewCheckBoxColumn = dataGridViewColumn; }
public frmCutView() { InitializeComponent(); oTxtBoxA = new DataGridViewTextBoxColumn(); oTxtBoxA.ValueType = typeof(int); oTxtBoxA.Visible = false; oTxtBoxB = new DataGridViewTextBoxColumn(); oTxtBoxB.HeaderText = "CutSheet Number"; oTxtBoxB.ValueType = typeof(string); oTxtBoxC = new DataGridViewTextBoxColumn(); oTxtBoxC.HeaderText = "DyeBatch Number"; oTxtBoxC.ValueType = typeof(string); oTxtBoxD = new DataGridViewTextBoxColumn(); oTxtBoxD.HeaderText = "DyeBatch Number"; oTxtBoxD.ValueType = typeof(DateTime); oTxtBoxE = new DataGridViewTextBoxColumn(); oTxtBoxE.HeaderText = "Quality"; oTxtBoxE.ValueType = typeof(string); oTxtBoxF = new DataGridViewTextBoxColumn(); oTxtBoxF.HeaderText = "Colour"; oTxtBoxF.ValueType = typeof(string); oTxtBoxG = new DataGridViewTextBoxColumn(); oTxtBoxG.HeaderText = "Size"; oTxtBoxG.ValueType = typeof(string); oTxtBoxH = new DataGridViewTextBoxColumn(); oTxtBoxH.HeaderText = "Style"; oTxtBoxH.ValueType = typeof(string); oTxtBoxJ = new DataGridViewTextBoxColumn(); oTxtBoxJ.HeaderText = "Customer"; oTxtBoxJ.ValueType = typeof(string); oChkA = new DataGridViewCheckBoxColumn(); oChkA.HeaderText = "Select"; oChkA.ValueType = typeof(bool); oChkB = new DataGridViewCheckBoxColumn(); oChkB.HeaderText = "Split"; oChkB.ValueType = typeof(bool); dataGridView1.Columns.Add(oTxtBoxA); dataGridView1.Columns.Add(oChkA); dataGridView1.Columns.Add(oChkB); dataGridView1.Columns.Add(oTxtBoxB); dataGridView1.Columns.Add(oTxtBoxC); dataGridView1.Columns.Add(oTxtBoxD); dataGridView1.Columns.Add(oTxtBoxE); dataGridView1.Columns.Add(oTxtBoxF); dataGridView1.Columns.Add(oTxtBoxG); dataGridView1.Columns.Add(oTxtBoxH); dataGridView1.Columns.Add(oTxtBoxJ); dataGridView1.AutoGenerateColumns = false; dataGridView1.AllowUserToAddRows = false; dataGridView1.AllowUserToOrderColumns = false; }