public LocFileEditorControl() : base(LocCodec.Instance) { int[] numArray = new int[3]; numArray [2] = 1; this.columnTypes = numArray; this.columnWidths = new int[] { 200, 400, 20 }; this.components = null; this.InitializeComponent(); for (int i = 0; i < this.columnNames.Length; i++) { DataGridViewColumn column; int num2 = this.columnTypes [i]; if (num2 == 1) { column = new DataGridViewCheckBoxColumn(); } else { column = new DataGridViewAutoFilterTextBoxColumn(); } column.DataPropertyName = this.columnNames [i]; column.HeaderText = this.columnHeaders [i]; column.Width = this.columnWidths [i]; this.dataGridView.Columns.Add(column); } new GridViewCopyPaste(dataGridView); }
public void RemoveFilter() { // Confirm that the data source is a BindingSource that supports filtering. if ((bindingSource.DataSource != null) && bindingSource.SupportsFiltering) { DataGridViewAutoFilterTextBoxColumn.RemoveFilter(dataGridView); } foreach (DataGridViewRow row in dataGridView.Rows) { row.Visible = true; } RefreshStatusStrip(); }
DataGridViewColumn CreateColumn(int columnIndex) { FieldInfo fieldInfo = EditedFile.CurrentType.Fields[columnIndex]; DataGridViewColumn column = null; if (Settings.Default.UseComboboxCells) { try { ICollection <string> items = DBReferenceMap.Instance.ResolveReference(fieldInfo.ForeignReference); if (items != null) { column = new DataGridViewComboBoxColumn(); var cbItems = (column as DataGridViewComboBoxColumn).Items; cbItems.Add(string.Empty); foreach (string item in items) { cbItems.Add(item); } } } catch { MessageBox.Show("A table reference could not be resolved.\nDisabling combo cells."); Settings.Default.UseComboboxCells = false; useComboBoxCells.CheckedChanged -= useComboBoxCells_CheckedChanged; useComboBoxCells.CheckState = CheckState.Unchecked; useComboBoxCells.CheckedChanged += useComboBoxCells_CheckedChanged; } } if (column == null) { column = new DataGridViewAutoFilterTextBoxColumn(); } column.Name = fieldInfo.Name; column.SortMode = DataGridViewColumnSortMode.Programmatic; column.HeaderText = fieldInfo.Name + (Settings.Default.IsColumnIgnored(CurrentPackedFile.FullPath, fieldInfo.Name) ? "*" : ""); column.Tag = fieldInfo; column.DataPropertyName = fieldInfo.Name; //columnIndex.ToString(); column.Visible = !Settings.Default.IsColumnIgnored(CurrentPackedFile.FullPath, fieldInfo.Name); column.DefaultCellStyle.BackColor = ReadOnly ? Color.LightGray : Color.White; if (column.Visible) { int visibleColumnCount = Math.Min(EditedFile.CurrentType.Fields.Count, 10); int columnWidth = Width / visibleColumnCount; column.Width = columnWidth; } return(column); }
private void showAllLabel_Click(object sender, EventArgs e) { DataGridViewAutoFilterTextBoxColumn.RemoveFilter(dataGridView1); }
public Form1() { InitializeComponent(); // ---------------------------------------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------------------------------- // ---------------------------------------------------------------------------------------------------------------------- DialogResult dialogResult = MessageBox.Show("By opening you will lost current results!", "WARNING!", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { //do something OpenFileDialog fdlg = new OpenFileDialog(); fdlg.Title = "Select file"; fdlg.InitialDirectory = Path.Combine(Application.StartupPath, @"Data\XML"); //fdlg.FileName = txtFileName.Text; fdlg.Filter = "Excel Sheet(*.xml)|*.xml|All Files(*.*)|*.*"; fdlg.FilterIndex = 1; fdlg.RestoreDirectory = true; if (fdlg.ShowDialog() == DialogResult.OK) { dataGridView1.DataSource = null; dataGridView1.Refresh(); dataGridView1.Columns.Add("", " "); dataGridView1.Rows.Clear(); dataGridView1.Columns.Clear(); dataGridView1.Refresh(); // txtFileName.Text = fdlg.FileName; XmlReader xmlFile = XmlReader.Create(fdlg.FileName, new XmlReaderSettings()); DataSet dataSet = new DataSet(); dataSet.ReadXml(xmlFile); //LOADS!!! YAY, but only the headers with no data... check save? dataGridView1.DataSource = dataSet.Tables[0]; // filterDataGridView1.DataSource = dataSet.Tables[0]; xmlFile.Close(); Application.DoEvents(); } } else if (dialogResult == DialogResult.No) { return; } // return; /* * // create sequence * Item[] items = new Item[] { new Book{Id = 1, Price = 13.50, Genre = "Comedy", Author = "Jim Bob"}, * new Book{Id = 2, Price = 8.50, Genre = "Drama", Author = "John Fox"}, * new Movie{Id = 1, Price = 22.99, Genre = "Comedy", Director = "Phil Funk"}, * new Movie{Id = 1, Price = 13.40, Genre = "Action", Director = "Eddie Jones"}}; * */ DataTable table = new DataTable(); //dataGridView1.DataSource = table; for (int i = 0; i < dataGridView1.ColumnCount; ++i) { table.Columns.Add(new DataColumn(dataGridView1.Columns[i].Name)); //dataGridView1.Columns[i].DataPropertyName = dataGridView1.Columns[i].Name; } BindingSource source = new BindingSource(); //source.DataSource = dataGridView1.DataSource; source.DataSource = table; foreach (DataColumn col in table.Columns) { DataGridViewAutoFilterTextBoxColumn commonColumn = new DataGridViewAutoFilterTextBoxColumn(); commonColumn.DataPropertyName = col.ColumnName; commonColumn.HeaderText = col.ColumnName; commonColumn.Resizable = DataGridViewTriState.True; this.dataGridView1.Columns.Add(commonColumn); } this.dataGridView1.DataSource = source; }
private void FormPrearrange_Load(object sender, EventArgs e) { //CAppOption.WindowStyleMan.SetStyle(this, CAppOption.iFormStyle); dgvMain.AutoGenerateColumns = false; DataGridViewTextBoxColumn ColumnPrearrangeID = new DataGridViewTextBoxColumn(); ColumnPrearrangeID.DataPropertyName = "PrearrangeID"; ColumnPrearrangeID.Name = "ColumnPrearrangeID"; ColumnPrearrangeID.HeaderText = "GoodsID"; ColumnPrearrangeID.Visible = false; ColumnPrearrangeID.Width = 30; ColumnPrearrangeID.FillWeight = 40F; ColumnPrearrangeID.ReadOnly = true; ColumnPrearrangeID.DisplayIndex = 0; dgvMain.Columns.Add(ColumnPrearrangeID); DataGridViewTextBoxColumn ColumnClientName = new DataGridViewTextBoxColumn(); ColumnClientName.DataPropertyName = "ClientName"; ColumnClientName.Name = "ColumnClientName"; ColumnClientName.HeaderText = "客户"; ColumnClientName.Width = 70; ColumnClientName.DisplayIndex = 1; dgvMain.Columns.Add(ColumnClientName); DataGridViewTextBoxColumn ColumnClientNumber = new DataGridViewTextBoxColumn(); ColumnClientNumber.DataPropertyName = "ClientNumber"; ColumnClientNumber.Name = "ColumnClientNumber"; ColumnClientNumber.HeaderText = "人数"; ColumnClientNumber.Width = 70; ColumnClientNumber.DisplayIndex = 2; dgvMain.Columns.Add(ColumnClientNumber); DataGridViewAutoFilterTextBoxColumn ColumnPhone = new DataGridViewAutoFilterTextBoxColumn(); ColumnPhone.DataPropertyName = "Phone"; ColumnPhone.Name = "ColumnPhone"; ColumnPhone.HeaderText = "电话"; ColumnPhone.Width = 70; ColumnPhone.DisplayIndex = 3; dgvMain.Columns.Add(ColumnPhone); DataGridViewTextBoxColumn ColumnRemark = new DataGridViewTextBoxColumn(); ColumnRemark.DataPropertyName = "Remark"; ColumnRemark.Name = "ColumnRemark"; ColumnRemark.HeaderText = "备注"; ColumnRemark.Width = 70; ColumnRemark.DisplayIndex = 4; dgvMain.Columns.Add(ColumnRemark); DataGridViewTextBoxColumn ColumnOrderTime = new DataGridViewTextBoxColumn(); ColumnOrderTime.DataPropertyName = "OrderTime"; ColumnOrderTime.Name = "ColumnOrderTime"; ColumnOrderTime.HeaderText = "预定时间"; ColumnOrderTime.Width = 120; ColumnOrderTime.DisplayIndex = 5; dgvMain.Columns.Add(ColumnOrderTime); DataGridViewAutoFilterTextBoxColumn ColumnTableNO = new DataGridViewAutoFilterTextBoxColumn(); ColumnTableNO.DataPropertyName = "TableNO"; ColumnTableNO.Name = "ColumnTableNO"; ColumnTableNO.HeaderText = "台号"; ColumnTableNO.Width = 120; ColumnTableNO.DisplayIndex = 6; dgvMain.Columns.Add(ColumnTableNO); DataGridViewAutoFilterTextBoxColumn ColumnTableName = new DataGridViewAutoFilterTextBoxColumn(); ColumnTableName.DataPropertyName = "TableName"; ColumnTableName.Name = "ColumnTableName"; ColumnTableName.HeaderText = "台名"; ColumnTableName.Width = 120; ColumnTableName.DisplayIndex = 7; dgvMain.Columns.Add(ColumnTableName); DataGridViewAutoFilterTextBoxColumn ColumnEmployeeNO = new DataGridViewAutoFilterTextBoxColumn(); ColumnEmployeeNO.DataPropertyName = "EmployeeNO"; ColumnEmployeeNO.Name = "ColumnEmployeeNO"; ColumnEmployeeNO.HeaderText = "责任员工"; ColumnEmployeeNO.Width = 120; ColumnEmployeeNO.DisplayIndex = 8; dgvMain.Columns.Add(ColumnEmployeeNO); DataGridViewComboBoxColumn ColumnState = new DataGridViewComboBoxColumn(); ColumnState.DataPropertyName = "State"; ColumnState.Name = "ColumnState"; ColumnState.HeaderText = "状态"; ColumnState.Width = 60; ColumnState.DisplayIndex = 9; ColumnState.Visible = false; dgvMain.Columns.Add(ColumnState); DataGridViewTextBoxColumn ColumnRecordTime = new DataGridViewTextBoxColumn(); ColumnRecordTime.DataPropertyName = "RecordTime"; ColumnRecordTime.Name = "ColumnRecordTime"; ColumnRecordTime.HeaderText = "记录时间"; ColumnRecordTime.Width = 120; ColumnRecordTime.DisplayIndex = 10; ColumnRecordTime.Visible = false; dgvMain.Columns.Add(ColumnRecordTime); ColumnState.DataSource = CGlobalInstance.Instance.DbAdaHelper.GetPrearrangeState(); ColumnState.DisplayMember = "ItemName"; ColumnState.ValueMember = "ItemValue"; bs = new BindingSource(); ShowPrearrange(); groupBox1.Enabled = false; }
void InitOrderdishesList() { dgvMain.AutoGenerateColumns = false; DataGridViewTextBoxColumn ColumnBillListID = new DataGridViewTextBoxColumn(); ColumnBillListID.DataPropertyName = "BillListID"; ColumnBillListID.Name = "ColumnBillListID"; ColumnBillListID.HeaderText = "BillListID"; ColumnBillListID.Visible = false; ColumnBillListID.Width = 30; ColumnBillListID.FillWeight = 40F; ColumnBillListID.ReadOnly = true; ColumnBillListID.DisplayIndex = 0; dgvMain.Columns.Add(ColumnBillListID); DataGridViewTextBoxColumn ColumnGoodsID2 = new DataGridViewTextBoxColumn(); ColumnGoodsID2.DataPropertyName = "GoodsID"; ColumnGoodsID2.Name = "ColumnGoodsID2"; ColumnGoodsID2.HeaderText = "GoodsID"; ColumnGoodsID2.Visible = false; ColumnGoodsID2.Width = 30; ColumnGoodsID2.FillWeight = 40F; ColumnGoodsID2.ReadOnly = true; ColumnGoodsID2.DisplayIndex = 1; dgvMain.Columns.Add(ColumnGoodsID2); DataGridViewTextBoxColumn ColumnBillID = new DataGridViewTextBoxColumn(); ColumnBillID.DataPropertyName = "BillID"; ColumnBillID.Name = "ColumnBillID"; ColumnBillID.HeaderText = "BillID"; ColumnBillID.Width = 70; ColumnBillID.DisplayIndex = 2; ColumnBillID.Visible = false; dgvMain.Columns.Add(ColumnBillID); DataGridViewTextBoxColumn ColumnLongGoodsNO2 = new DataGridViewTextBoxColumn(); ColumnLongGoodsNO2.DataPropertyName = "LongGoodsNO"; ColumnLongGoodsNO2.Name = "ColumnLongGoodsNO2"; ColumnLongGoodsNO2.HeaderText = "长编码"; ColumnLongGoodsNO2.Width = 80; ColumnLongGoodsNO2.DisplayIndex = 3; dgvMain.Columns.Add(ColumnLongGoodsNO2); DataGridViewYyFilterTextBoxColumn ColumnGoodsName = new DataGridViewYyFilterTextBoxColumn(); ColumnGoodsName.DataSource = CGlobalInstance.Instance.DbAdaHelper.GetDataTable("SELECT DISTINCT GoodsName FROM tBillList where (RecordTime > DATEADD(Day, - 1, GETDATE())) or State<3"); ColumnGoodsName.UpdateFilterEvent += OnUpdateFilter; ColumnGoodsName.DataPropertyName = "GoodsName"; ColumnGoodsName.Name = "ColumnGoodsName"; ColumnGoodsName.HeaderText = "消费项目"; ColumnGoodsName.Width = 120; ColumnGoodsName.DisplayIndex = 4; dgvMain.Columns.Add(ColumnGoodsName); DataGridViewTextBoxColumn ColumnGoodsNumber = new DataGridViewTextBoxColumn(); ColumnGoodsNumber.DataPropertyName = "GoodsNumber"; ColumnGoodsNumber.Name = "ColumnGoodsNumber"; ColumnGoodsNumber.HeaderText = "数量"; ColumnGoodsNumber.Width = 30; ColumnGoodsNumber.DisplayIndex = 5; dgvMain.Columns.Add(ColumnGoodsNumber); DataGridViewTextBoxColumn ColumnUnit = new DataGridViewTextBoxColumn(); ColumnUnit.DataPropertyName = "Unit"; ColumnUnit.Name = "ColumnUnit"; ColumnUnit.HeaderText = "单位"; ColumnUnit.Width = 50; ColumnUnit.DisplayIndex = 6; dgvMain.Columns.Add(ColumnUnit); DataGridViewTextBoxColumn ColumnOrderTime = new DataGridViewTextBoxColumn(); ColumnOrderTime.DataPropertyName = "OrderTime"; ColumnOrderTime.Name = "ColumnOrderTime"; ColumnOrderTime.HeaderText = "送厨时间"; ColumnOrderTime.Width = 120; ColumnOrderTime.DisplayIndex = 7; ColumnOrderTime.ReadOnly = true; dgvMain.Columns.Add(ColumnOrderTime); DataGridViewTextBoxColumn ColumnRecordTime = new DataGridViewTextBoxColumn(); ColumnRecordTime.DataPropertyName = "RecordTime"; ColumnRecordTime.Name = "ColumnRecordTime"; ColumnRecordTime.HeaderText = "下单时间"; ColumnRecordTime.Width = 120; ColumnRecordTime.DisplayIndex = 8; ColumnRecordTime.ReadOnly = true; dgvMain.Columns.Add(ColumnRecordTime); DataGridViewTextBoxColumn ColumnServingTime = new DataGridViewTextBoxColumn(); ColumnServingTime.DataPropertyName = "ServingTime"; ColumnServingTime.Name = "ColumnServingTime"; ColumnServingTime.HeaderText = "出厨时间"; ColumnServingTime.Width = 120; ColumnServingTime.DisplayIndex = 9; ColumnServingTime.ReadOnly = true; dgvMain.Columns.Add(ColumnServingTime); DataGridViewTextBoxColumn ColumnUnitPrice2 = new DataGridViewTextBoxColumn(); ColumnUnitPrice2.DataPropertyName = "UnitPrice"; ColumnUnitPrice2.Name = "ColumnUnitPrice2"; ColumnUnitPrice2.HeaderText = "单价"; ColumnUnitPrice2.Width = 80; ColumnUnitPrice2.DefaultCellStyle.Format = "0.00"; ColumnUnitPrice2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; ColumnUnitPrice2.Visible = false; ColumnUnitPrice2.DisplayIndex = 10; dgvMain.Columns.Add(ColumnUnitPrice2); DataGridViewCheckBoxColumn ColumnIsCurrentPrice2 = new DataGridViewCheckBoxColumn(); ColumnIsCurrentPrice2.DataPropertyName = "IsCurrentPrice"; ColumnIsCurrentPrice2.Name = "ColumnIsCurrentPrice2"; ColumnIsCurrentPrice2.HeaderText = "时价"; ColumnIsCurrentPrice2.TrueValue = "1"; ColumnIsCurrentPrice2.FalseValue = "0"; ColumnIsCurrentPrice2.Visible = false; ColumnIsCurrentPrice2.ReadOnly = true; ColumnIsCurrentPrice2.Width = 50; ColumnIsCurrentPrice2.DisplayIndex = 11; dgvMain.Columns.Add(ColumnIsCurrentPrice2); DataGridViewYyFilterTextBoxColumn ColumnGoodsClassifyName = new DataGridViewYyFilterTextBoxColumn(); ColumnGoodsClassifyName.DataSource = CGlobalInstance.Instance.DbAdaHelper.GetDataTable("SELECT GoodsClassifyName FROM tGoodsClassify"); ColumnGoodsClassifyName.UpdateFilterEvent += OnUpdateFilter; ColumnGoodsClassifyName.DataPropertyName = "GoodsClassifyName"; ColumnGoodsClassifyName.Name = "ColumnGoodsClassifyName"; ColumnGoodsClassifyName.HeaderText = "大类"; ColumnGoodsClassifyName.Width = 70; ColumnGoodsClassifyName.DisplayIndex = 12; dgvMain.Columns.Add(ColumnGoodsClassifyName); DataGridViewTextBoxColumn ColumnRemark = new DataGridViewTextBoxColumn(); ColumnRemark.DataPropertyName = "Remark"; ColumnRemark.Name = "ColumnRemark"; ColumnRemark.HeaderText = "备注"; ColumnRemark.Width = 80; ColumnRemark.DisplayIndex = 13; dgvMain.Columns.Add(ColumnRemark); DataGridViewComboBoxColumn ColumnType = new DataGridViewComboBoxColumn(); ColumnType.DataPropertyName = "Type";// ColumnType.DisplayMember = "Name"; ColumnType.ValueMember = "Value"; ColumnType.DataSource = CGlobalInstance.Instance.dtBillType; ColumnType.Name = "ColumnType"; ColumnType.HeaderText = "类型";//点单,退单,赠单,退赠 ColumnType.Width = 80; ColumnType.DisplayIndex = 14; dgvMain.Columns.Add(ColumnType); DataGridViewComboBoxColumn ColumnState = new DataGridViewComboBoxColumn(); ColumnState.DataPropertyName = "State"; ColumnState.Name = "ColumnState"; ColumnState.DisplayMember = "Name"; ColumnState.ValueMember = "Value"; ColumnState.DataSource = CGlobalInstance.Instance.dtBillState; ColumnState.HeaderText = "状态";//0落单,1排队中,3已上菜 ColumnState.Width = 80; ColumnState.DisplayIndex = 15; dgvMain.Columns.Add(ColumnState); DataGridViewTextBoxColumn ColumnDeductEmployeeNO = new DataGridViewTextBoxColumn(); ColumnDeductEmployeeNO.DataPropertyName = "DeductEmployeeNO"; ColumnDeductEmployeeNO.Name = "ColumnDeductEmployeeNO"; ColumnDeductEmployeeNO.HeaderText = "提成员工"; ColumnDeductEmployeeNO.Width = 80; ColumnDeductEmployeeNO.DisplayIndex = 16; dgvMain.Columns.Add(ColumnDeductEmployeeNO); DataGridViewYyFilterTextBoxColumn ColumnDeptName = new DataGridViewYyFilterTextBoxColumn(); ColumnDeptName.DataSource = CGlobalInstance.Instance.DbAdaHelper.GetDataTable("SELECT DISTINCT DeptName FROM tDiningDept "); ColumnDeptName.UpdateFilterEvent += OnUpdateFilter; ColumnDeptName.DataPropertyName = "DeptName"; ColumnDeptName.Name = "ColumnDeptName"; ColumnDeptName.HeaderText = "部门";//0落单,1排队中,3已上菜 ColumnDeptName.Width = 80; ColumnDeptName.DisplayIndex = 17; dgvMain.Columns.Add(ColumnDeptName); DataGridViewTextBoxColumn ColumnBillTime = new DataGridViewTextBoxColumn(); ColumnBillTime.DataPropertyName = "BillTime"; ColumnBillTime.Name = "ColumnBillTime"; ColumnBillTime.HeaderText = "开台时间";//0落单,1排队中,3已上菜 ColumnBillTime.Width = 80; ColumnBillTime.DisplayIndex = 18; dgvMain.Columns.Add(ColumnBillTime); DataGridViewAutoFilterTextBoxColumn ColumnTableNO = new DataGridViewAutoFilterTextBoxColumn(); ColumnTableNO.DataPropertyName = "TableNO"; ColumnTableNO.Name = "ColumnTableNO"; ColumnTableNO.HeaderText = "台号"; ColumnTableNO.Width = 120; ColumnTableNO.DisplayIndex = 19; dgvMain.Columns.Add(ColumnTableNO); DataGridViewAutoFilterTextBoxColumn ColumnTableName = new DataGridViewAutoFilterTextBoxColumn(); ColumnTableName.DataPropertyName = "TableName"; ColumnTableName.Name = "ColumnTableName"; ColumnTableName.HeaderText = "台名"; ColumnTableName.Width = 120; ColumnTableName.DisplayIndex = 20; dgvMain.Columns.Add(ColumnTableName); }
void InitView() { dgvMain.AutoGenerateColumns = false; DataGridViewTextBoxColumn ColumnGoodsMaterialID = new DataGridViewTextBoxColumn(); ColumnGoodsMaterialID.DataPropertyName = "GoodsMaterialID"; ColumnGoodsMaterialID.Name = "ColumnGoodsMaterialID"; ColumnGoodsMaterialID.HeaderText = "GoodsMaterialID"; ColumnGoodsMaterialID.Visible = false; ColumnGoodsMaterialID.Width = 30; ColumnGoodsMaterialID.FillWeight = 40F; ColumnGoodsMaterialID.ReadOnly = true; ColumnGoodsMaterialID.DisplayIndex = 2; dgvMain.Columns.Add(ColumnGoodsMaterialID); DataGridViewTextBoxColumn ColumnGoodsClassify = new DataGridViewTextBoxColumn(); ColumnGoodsClassify.DataPropertyName = "GoodsClassify"; ColumnGoodsClassify.Name = "ColumnGoodsClassify"; ColumnGoodsClassify.HeaderText = "大类码"; ColumnGoodsClassify.Width = 70; ColumnGoodsClassify.DisplayIndex = 3; ColumnGoodsClassify.Visible = false; dgvMain.Columns.Add(ColumnGoodsClassify); DataGridViewTextBoxColumn ColumnGoodsSubClassify = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassify.DataPropertyName = "GoodsSubClassify"; ColumnGoodsSubClassify.Name = "ColumnGoodsSubClassify"; ColumnGoodsSubClassify.HeaderText = "小类码"; ColumnGoodsSubClassify.Width = 70; ColumnGoodsSubClassify.DisplayIndex = 4; ColumnGoodsSubClassify.Visible = false; dgvMain.Columns.Add(ColumnGoodsSubClassify); DataGridViewTextBoxColumn ColumnMaterialNO = new DataGridViewTextBoxColumn(); ColumnMaterialNO.DataPropertyName = "MaterialNO"; ColumnMaterialNO.Name = "ColumnMaterialNO"; ColumnMaterialNO.HeaderText = "短编码"; ColumnMaterialNO.Width = 70; ColumnMaterialNO.DisplayIndex = 5; ColumnMaterialNO.Visible = false; dgvMain.Columns.Add(ColumnMaterialNO); DataGridViewTextBoxColumn ColumnLongMaterialNO = new DataGridViewTextBoxColumn(); ColumnLongMaterialNO.DataPropertyName = "LongMaterialNO"; ColumnLongMaterialNO.Name = "ColumnLongMaterialNO"; ColumnLongMaterialNO.HeaderText = "长编码"; ColumnLongMaterialNO.Width = 80; ColumnLongMaterialNO.DisplayIndex = 6; dgvMain.Columns.Add(ColumnLongMaterialNO); DataGridViewTextBoxColumn ColumnMaterialName = new DataGridViewTextBoxColumn(); ColumnMaterialName.DataPropertyName = "MaterialName"; ColumnMaterialName.Name = "ColumnMaterialName"; ColumnMaterialName.HeaderText = "名称"; ColumnMaterialName.Width = 80; ColumnMaterialName.DisplayIndex = 7; dgvMain.Columns.Add(ColumnMaterialName); DataGridViewTextBoxColumn ColumnGoodsSubClassifyID = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassifyID.DataPropertyName = "GoodsSubClassifyID"; ColumnGoodsSubClassifyID.Name = "ColumnGoodsSubClassifyID"; ColumnGoodsSubClassifyID.HeaderText = "分类"; ColumnGoodsSubClassifyID.Width = 70; ColumnGoodsSubClassifyID.DisplayIndex = 8; ColumnGoodsSubClassifyID.Visible = false; dgvMain.Columns.Add(ColumnGoodsSubClassifyID); DataGridViewAutoFilterTextBoxColumn ColumnGoodsSubClassifyName = new DataGridViewAutoFilterTextBoxColumn(); //DataGridViewTextBoxColumn ColumnGoodsSubClassifyName = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassifyName.DataPropertyName = "GoodsSubClassifyName"; ColumnGoodsSubClassifyName.Name = "ColumnGoodsSubClassifyName"; ColumnGoodsSubClassifyName.HeaderText = "小类"; ColumnGoodsSubClassifyName.Width = 70; ColumnGoodsSubClassifyName.DisplayIndex = 9; dgvMain.Columns.Add(ColumnGoodsSubClassifyName); DataGridViewAutoFilterTextBoxColumn ColumnGoodsClassifyName = new DataGridViewAutoFilterTextBoxColumn(); //DataGridViewTextBoxColumn ColumnGoodsClassifyName = new DataGridViewTextBoxColumn(); ColumnGoodsClassifyName.DataPropertyName = "GoodsClassifyName"; ColumnGoodsClassifyName.Name = "ColumnGoodsClassifyName"; ColumnGoodsClassifyName.HeaderText = "大类"; ColumnGoodsClassifyName.Width = 70; ColumnGoodsClassifyName.DisplayIndex = 10; dgvMain.Columns.Add(ColumnGoodsClassifyName); /* * DataGridViewTextBoxColumn ColumnNumber = new DataGridViewTextBoxColumn(); * ColumnNumber.DataPropertyName = "Number"; * ColumnNumber.Name = "ColumnNumber"; * ColumnNumber.HeaderText = "数量"; * ColumnNumber.Width = 50; * ColumnNumber.DisplayIndex = 11; * dgvMain.Columns.Add(ColumnNumber); * */ DataGridViewTextBoxColumn ColumnUnit = new DataGridViewTextBoxColumn(); ColumnUnit.DataPropertyName = "Unit"; ColumnUnit.Name = "ColumnUnit"; ColumnUnit.HeaderText = "单位"; ColumnUnit.Width = 50; ColumnUnit.DisplayIndex = 12; dgvMain.Columns.Add(ColumnUnit); DataGridViewTextBoxColumn ColumnCost = new DataGridViewTextBoxColumn(); ColumnCost.DataPropertyName = "Cost"; ColumnCost.Name = "ColumnCost"; ColumnCost.HeaderText = "单位成本"; ColumnCost.Width = 80; ColumnCost.DisplayIndex = 13; dgvMain.Columns.Add(ColumnCost); DataGridViewTextBoxColumn ColumnPinYin = new DataGridViewTextBoxColumn(); ColumnPinYin.DataPropertyName = "PinYin"; ColumnPinYin.Name = "ColumnPinYin"; ColumnPinYin.HeaderText = "拼音简码"; ColumnPinYin.Width = 90; ColumnPinYin.DisplayIndex = 14; dgvMain.Columns.Add(ColumnPinYin); }
private void FormGoodsSet_Load(object sender, EventArgs e) { CAppOption.WindowStyleMan.SetStyle(this, CAppOption.iFormStyle); dgvMain.AutoGenerateColumns = false; DataGridViewTextBoxColumn ColumnGoodsID = new DataGridViewTextBoxColumn(); ColumnGoodsID.DataPropertyName = "GoodsID"; ColumnGoodsID.Name = "ColumnGoodsID"; ColumnGoodsID.HeaderText = "GoodsID"; ColumnGoodsID.Visible = false; ColumnGoodsID.Width = 30; ColumnGoodsID.FillWeight = 40F; ColumnGoodsID.ReadOnly = true; ColumnGoodsID.DisplayIndex = 0; dgvMain.Columns.Add(ColumnGoodsID); DataGridViewTextBoxColumn ColumnGoodsClassify = new DataGridViewTextBoxColumn(); ColumnGoodsClassify.DataPropertyName = "GoodsClassify"; ColumnGoodsClassify.Name = "ColumnGoodsClassify"; ColumnGoodsClassify.HeaderText = "大类码"; ColumnGoodsClassify.Width = 70; ColumnGoodsClassify.DisplayIndex = 1; ColumnGoodsClassify.Visible = false; dgvMain.Columns.Add(ColumnGoodsClassify); DataGridViewTextBoxColumn ColumnGoodsSubClassify = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassify.DataPropertyName = "GoodsSubClassify"; ColumnGoodsSubClassify.Name = "ColumnGoodsSubClassify"; ColumnGoodsSubClassify.HeaderText = "小类码"; ColumnGoodsSubClassify.Width = 70; ColumnGoodsSubClassify.DisplayIndex = 2; ColumnGoodsSubClassify.Visible = false; dgvMain.Columns.Add(ColumnGoodsSubClassify); DataGridViewTextBoxColumn ColumnGoodsNO = new DataGridViewTextBoxColumn(); ColumnGoodsNO.DataPropertyName = "GoodsNO"; ColumnGoodsNO.Name = "ColumnGoodsNO"; ColumnGoodsNO.HeaderText = "短编码"; ColumnGoodsNO.Width = 70; ColumnGoodsNO.DisplayIndex = 3; ColumnGoodsNO.Visible = false; dgvMain.Columns.Add(ColumnGoodsNO); DataGridViewTextBoxColumn ColumnLongGoodsNO = new DataGridViewTextBoxColumn(); ColumnLongGoodsNO.DataPropertyName = "LongGoodsNO"; ColumnLongGoodsNO.Name = "ColumnLongGoodsNO"; ColumnLongGoodsNO.HeaderText = "长编码"; ColumnLongGoodsNO.Width = 80; ColumnLongGoodsNO.DisplayIndex = 4; dgvMain.Columns.Add(ColumnLongGoodsNO); DataGridViewTextBoxColumn ColumnGoodsName = new DataGridViewTextBoxColumn(); ColumnGoodsName.DataPropertyName = "GoodsName"; ColumnGoodsName.Name = "ColumnGoodsName"; ColumnGoodsName.HeaderText = "名称"; ColumnGoodsName.Width = 80; ColumnGoodsName.DisplayIndex = 5; dgvMain.Columns.Add(ColumnGoodsName); DataGridViewTextBoxColumn ColumnGoodsSubClassifyID = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassifyID.DataPropertyName = "GoodsSubClassifyID"; ColumnGoodsSubClassifyID.Name = "ColumnGoodsSubClassifyID"; ColumnGoodsSubClassifyID.HeaderText = "分类"; ColumnGoodsSubClassifyID.Width = 70; ColumnGoodsSubClassifyID.DisplayIndex = 6; ColumnGoodsSubClassifyID.Visible = false; dgvMain.Columns.Add(ColumnGoodsSubClassifyID); DataGridViewAutoFilterTextBoxColumn ColumnGoodsSubClassifyName = new DataGridViewAutoFilterTextBoxColumn(); //DataGridViewTextBoxColumn ColumnGoodsSubClassifyName = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassifyName.DataPropertyName = "GoodsSubClassifyName"; ColumnGoodsSubClassifyName.Name = "ColumnGoodsSubClassifyName"; ColumnGoodsSubClassifyName.HeaderText = "小类"; ColumnGoodsSubClassifyName.Width = 70; ColumnGoodsSubClassifyName.DisplayIndex = 7; dgvMain.Columns.Add(ColumnGoodsSubClassifyName); DataGridViewAutoFilterTextBoxColumn ColumnGoodsClassifyName = new DataGridViewAutoFilterTextBoxColumn(); //DataGridViewTextBoxColumn ColumnGoodsClassifyName = new DataGridViewTextBoxColumn(); ColumnGoodsClassifyName.DataPropertyName = "GoodsClassifyName"; ColumnGoodsClassifyName.Name = "ColumnGoodsClassifyName"; ColumnGoodsClassifyName.HeaderText = "大类"; ColumnGoodsClassifyName.Width = 70; ColumnGoodsClassifyName.DisplayIndex = 8; dgvMain.Columns.Add(ColumnGoodsClassifyName); DataGridViewTextBoxColumn ColumnUnit = new DataGridViewTextBoxColumn(); ColumnUnit.DataPropertyName = "Unit"; ColumnUnit.Name = "ColumnUnit"; ColumnUnit.HeaderText = "单位"; ColumnUnit.Width = 50; ColumnUnit.DisplayIndex = 9; dgvMain.Columns.Add(ColumnUnit); DataGridViewTextBoxColumn ColumnUnitPrice = new DataGridViewTextBoxColumn(); ColumnUnitPrice.DataPropertyName = "UnitPrice"; ColumnUnitPrice.Name = "ColumnUnitPrice"; ColumnUnitPrice.HeaderText = "单价"; ColumnUnitPrice.Width = 80; ColumnUnitPrice.DisplayIndex = 10; dgvMain.Columns.Add(ColumnUnitPrice); DataGridViewCheckBoxColumn ColumnIsCurrentPrice = new DataGridViewCheckBoxColumn(); ColumnIsCurrentPrice.DataPropertyName = "IsCurrentPrice"; ColumnIsCurrentPrice.Name = "ColumnIsCurrentPrice"; ColumnIsCurrentPrice.HeaderText = "时价"; ColumnIsCurrentPrice.TrueValue = "1"; ColumnIsCurrentPrice.FalseValue = "0"; ColumnIsCurrentPrice.Visible = true; ColumnIsCurrentPrice.ReadOnly = true; ColumnIsCurrentPrice.Width = 50; ColumnIsCurrentPrice.DisplayIndex = 11; dgvMain.Columns.Add(ColumnIsCurrentPrice); DataGridViewTextBoxColumn ColumnPinYin = new DataGridViewTextBoxColumn(); ColumnPinYin.DataPropertyName = "PinYin"; ColumnPinYin.Name = "ColumnPinYin"; ColumnPinYin.HeaderText = "拼音简码"; ColumnPinYin.Width = 90; ColumnPinYin.DisplayIndex = 12; dgvMain.Columns.Add(ColumnPinYin); DataGridViewTextBoxColumn ColumnGoodsCode = new DataGridViewTextBoxColumn(); ColumnGoodsCode.DataPropertyName = "GoodsCode"; ColumnGoodsCode.Name = "ColumnGoodsCode"; ColumnGoodsCode.HeaderText = "商品条码"; ColumnGoodsCode.Width = 90; ColumnGoodsCode.DisplayIndex = 13; dgvMain.Columns.Add(ColumnGoodsCode); DataGridViewTextBoxColumn ColumnCost = new DataGridViewTextBoxColumn(); ColumnCost.DataPropertyName = "Cost"; ColumnCost.Name = "ColumnCost"; ColumnCost.HeaderText = "成本"; ColumnCost.Width = 80; ColumnCost.DisplayIndex = 14; dgvMain.Columns.Add(ColumnCost); DataGridViewTextBoxColumn ColumnIntegral = new DataGridViewTextBoxColumn(); ColumnIntegral.DataPropertyName = "Integral"; ColumnIntegral.Name = "ColumnIntegral"; ColumnIntegral.HeaderText = "积分"; ColumnIntegral.Width = 50; ColumnIntegral.DisplayIndex = 15; dgvMain.Columns.Add(ColumnIntegral); DataGridViewTextBoxColumn ColumnDeduct = new DataGridViewTextBoxColumn(); ColumnDeduct.DataPropertyName = "Deduct"; ColumnDeduct.Name = "ColumnDeduct"; ColumnDeduct.HeaderText = "提成"; ColumnDeduct.Width = 70; ColumnDeduct.DisplayIndex = 16; dgvMain.Columns.Add(ColumnDeduct); MixFunc.DataGridViewHelper.LoadStyle(dgvMain, "酒菜设置"); bs = new BindingSource(); ShowGoods(); }
void InitGoods() { dgvGoods.AutoGenerateColumns = false; DataGridViewTextBoxColumn ColumnGoodsID = new DataGridViewTextBoxColumn(); ColumnGoodsID.DataPropertyName = "GoodsID"; ColumnGoodsID.Name = "ColumnGoodsID"; ColumnGoodsID.HeaderText = "GoodsID"; ColumnGoodsID.Visible = false; ColumnGoodsID.Width = 30; ColumnGoodsID.FillWeight = 40F; ColumnGoodsID.ReadOnly = true; ColumnGoodsID.DisplayIndex = 0; dgvGoods.Columns.Add(ColumnGoodsID); DataGridViewTextBoxColumn ColumnGoodsClassify = new DataGridViewTextBoxColumn(); ColumnGoodsClassify.DataPropertyName = "GoodsClassify"; ColumnGoodsClassify.Name = "ColumnGoodsClassify"; ColumnGoodsClassify.HeaderText = "大类码"; ColumnGoodsClassify.Width = 70; ColumnGoodsClassify.DisplayIndex = 1; ColumnGoodsClassify.Visible = false; dgvGoods.Columns.Add(ColumnGoodsClassify); DataGridViewTextBoxColumn ColumnGoodsSubClassify = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassify.DataPropertyName = "GoodsSubClassify"; ColumnGoodsSubClassify.Name = "ColumnGoodsSubClassify"; ColumnGoodsSubClassify.HeaderText = "小类码"; ColumnGoodsSubClassify.Width = 70; ColumnGoodsSubClassify.DisplayIndex = 2; ColumnGoodsSubClassify.Visible = false; dgvGoods.Columns.Add(ColumnGoodsSubClassify); DataGridViewTextBoxColumn ColumnGoodsNO = new DataGridViewTextBoxColumn(); ColumnGoodsNO.DataPropertyName = "GoodsNO"; ColumnGoodsNO.Name = "ColumnGoodsNO"; ColumnGoodsNO.HeaderText = "短编码"; ColumnGoodsNO.Width = 70; ColumnGoodsNO.DisplayIndex = 3; ColumnGoodsNO.Visible = false; dgvGoods.Columns.Add(ColumnGoodsNO); DataGridViewTextBoxColumn ColumnLongGoodsNO = new DataGridViewTextBoxColumn(); ColumnLongGoodsNO.DataPropertyName = "LongGoodsNO"; ColumnLongGoodsNO.Name = "ColumnLongGoodsNO"; ColumnLongGoodsNO.HeaderText = "长编码"; ColumnLongGoodsNO.Width = 80; ColumnLongGoodsNO.DisplayIndex = 4; dgvGoods.Columns.Add(ColumnLongGoodsNO); DataGridViewTextBoxColumn ColumnGoodsName = new DataGridViewTextBoxColumn(); ColumnGoodsName.DataPropertyName = "GoodsName"; ColumnGoodsName.Name = "ColumnGoodsName"; ColumnGoodsName.HeaderText = "名称"; ColumnGoodsName.Width = 80; ColumnGoodsName.DisplayIndex = 5; dgvGoods.Columns.Add(ColumnGoodsName); DataGridViewTextBoxColumn ColumnGoodsSubClassifyID = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassifyID.DataPropertyName = "GoodsSubClassifyID"; ColumnGoodsSubClassifyID.Name = "ColumnGoodsSubClassifyID"; ColumnGoodsSubClassifyID.HeaderText = "分类"; ColumnGoodsSubClassifyID.Width = 70; ColumnGoodsSubClassifyID.DisplayIndex = 6; ColumnGoodsSubClassifyID.Visible = false; dgvGoods.Columns.Add(ColumnGoodsSubClassifyID); DataGridViewAutoFilterTextBoxColumn ColumnGoodsSubClassifyName = new DataGridViewAutoFilterTextBoxColumn(); //DataGridViewTextBoxColumn ColumnGoodsSubClassifyName = new DataGridViewTextBoxColumn(); ColumnGoodsSubClassifyName.DataPropertyName = "GoodsSubClassifyName"; ColumnGoodsSubClassifyName.Name = "ColumnGoodsSubClassifyName"; ColumnGoodsSubClassifyName.HeaderText = "小类"; ColumnGoodsSubClassifyName.Width = 70; ColumnGoodsSubClassifyName.DisplayIndex = 7; dgvGoods.Columns.Add(ColumnGoodsSubClassifyName); DataGridViewAutoFilterTextBoxColumn ColumnGoodsClassifyName = new DataGridViewAutoFilterTextBoxColumn(); //DataGridViewTextBoxColumn ColumnGoodsClassifyName = new DataGridViewTextBoxColumn(); ColumnGoodsClassifyName.DataPropertyName = "GoodsClassifyName"; ColumnGoodsClassifyName.Name = "ColumnGoodsClassifyName"; ColumnGoodsClassifyName.HeaderText = "大类"; ColumnGoodsClassifyName.Width = 70; ColumnGoodsClassifyName.DisplayIndex = 8; dgvGoods.Columns.Add(ColumnGoodsClassifyName); DataGridViewTextBoxColumn ColumnUnit = new DataGridViewTextBoxColumn(); ColumnUnit.DataPropertyName = "Unit"; ColumnUnit.Name = "ColumnUnit"; ColumnUnit.HeaderText = "单位"; ColumnUnit.Width = 50; ColumnUnit.DisplayIndex = 9; dgvGoods.Columns.Add(ColumnUnit); DataGridViewTextBoxColumn ColumnUnitPrice = new DataGridViewTextBoxColumn(); ColumnUnitPrice.DataPropertyName = "UnitPrice"; ColumnUnitPrice.Name = "ColumnUnitPrice"; ColumnUnitPrice.HeaderText = "单价"; ColumnUnitPrice.Width = 80; ColumnUnitPrice.DisplayIndex = 10; dgvGoods.Columns.Add(ColumnUnitPrice); DataGridViewCheckBoxColumn ColumnIsCurrentPrice = new DataGridViewCheckBoxColumn(); ColumnIsCurrentPrice.DataPropertyName = "IsCurrentPrice"; ColumnIsCurrentPrice.Name = "ColumnIsCurrentPrice"; ColumnIsCurrentPrice.HeaderText = "时价"; ColumnIsCurrentPrice.TrueValue = "1"; ColumnIsCurrentPrice.FalseValue = "0"; ColumnIsCurrentPrice.Visible = true; ColumnIsCurrentPrice.ReadOnly = true; ColumnIsCurrentPrice.Width = 50; ColumnIsCurrentPrice.DisplayIndex = 11; dgvGoods.Columns.Add(ColumnIsCurrentPrice); DataGridViewTextBoxColumn ColumnPinYin = new DataGridViewTextBoxColumn(); ColumnPinYin.DataPropertyName = "PinYin"; ColumnPinYin.Name = "ColumnPinYin"; ColumnPinYin.HeaderText = "拼音简码"; ColumnPinYin.Width = 90; ColumnPinYin.DisplayIndex = 12; dgvGoods.Columns.Add(ColumnPinYin); DataGridViewTextBoxColumn ColumnGoodsCode = new DataGridViewTextBoxColumn(); ColumnGoodsCode.DataPropertyName = "GoodsCode"; ColumnGoodsCode.Name = "ColumnGoodsCode"; ColumnGoodsCode.HeaderText = "商品条码"; ColumnGoodsCode.Width = 90; ColumnGoodsCode.DisplayIndex = 13; dgvGoods.Columns.Add(ColumnGoodsCode); DataGridViewTextBoxColumn ColumnCost = new DataGridViewTextBoxColumn(); ColumnCost.DataPropertyName = "Cost"; ColumnCost.Name = "ColumnCost"; ColumnCost.HeaderText = "成本"; ColumnCost.Width = 80; ColumnCost.DisplayIndex = 14; ColumnCost.Visible = false; dgvGoods.Columns.Add(ColumnCost); DataGridViewTextBoxColumn ColumnIntegral = new DataGridViewTextBoxColumn(); ColumnIntegral.DataPropertyName = "Integral"; ColumnIntegral.Name = "ColumnIntegral"; ColumnIntegral.HeaderText = "积分"; ColumnIntegral.Width = 50; ColumnIntegral.DisplayIndex = 15; ColumnIntegral.Visible = false; dgvGoods.Columns.Add(ColumnIntegral); DataGridViewTextBoxColumn ColumnDeduct = new DataGridViewTextBoxColumn(); ColumnDeduct.DataPropertyName = "Deduct"; ColumnDeduct.Name = "ColumnDeduct"; ColumnDeduct.HeaderText = "提成"; ColumnDeduct.Width = 70; ColumnDeduct.DisplayIndex = 16; ColumnDeduct.Visible = false; dgvGoods.Columns.Add(ColumnDeduct); }
private void biFiltros_Click(object sender, EventArgs e) { DataGridViewAutoFilterTextBoxColumn.RemoveFilter(dgvPrestamos); }
private void FormBill_Load(object sender, EventArgs e) { tbBillNO.Text = m_Bill.BillNO; tbTableNO.Text = m_Bill.TableNO.ToString(); tbTableName.Text = m_Bill.TableName; dgvMain.AutoGenerateColumns = false; DataGridViewTextBoxColumn ColumnPrearrangeID = new DataGridViewTextBoxColumn(); ColumnPrearrangeID.DataPropertyName = "PrearrangeID"; ColumnPrearrangeID.Name = "ColumnPrearrangeID"; ColumnPrearrangeID.HeaderText = "预定编号"; //ColumnPrearrangeID.Visible = false; ColumnPrearrangeID.Width = 30; ColumnPrearrangeID.FillWeight = 40F; ColumnPrearrangeID.ReadOnly = true; ColumnPrearrangeID.DisplayIndex = 0; dgvMain.Columns.Add(ColumnPrearrangeID); DataGridViewTextBoxColumn ColumnClientName = new DataGridViewTextBoxColumn(); ColumnClientName.DataPropertyName = "ClientName"; ColumnClientName.Name = "ColumnClientName"; ColumnClientName.HeaderText = "客户"; ColumnClientName.Width = 70; ColumnClientName.DisplayIndex = 1; dgvMain.Columns.Add(ColumnClientName); DataGridViewTextBoxColumn ColumnClientNumber = new DataGridViewTextBoxColumn(); ColumnClientNumber.DataPropertyName = "ClientNumber"; ColumnClientNumber.Name = "ColumnClientNumber"; ColumnClientNumber.HeaderText = "人数"; ColumnClientNumber.Width = 70; ColumnClientNumber.DisplayIndex = 2; dgvMain.Columns.Add(ColumnClientNumber); DataGridViewAutoFilterTextBoxColumn ColumnPhone = new DataGridViewAutoFilterTextBoxColumn(); ColumnPhone.DataPropertyName = "Phone"; ColumnPhone.Name = "ColumnPhone"; ColumnPhone.HeaderText = "电话"; ColumnPhone.Width = 70; ColumnPhone.DisplayIndex = 3; dgvMain.Columns.Add(ColumnPhone); DataGridViewTextBoxColumn ColumnRemark = new DataGridViewTextBoxColumn(); ColumnRemark.DataPropertyName = "Remark"; ColumnRemark.Name = "ColumnRemark"; ColumnRemark.HeaderText = "备注"; ColumnRemark.Width = 70; ColumnRemark.DisplayIndex = 4; dgvMain.Columns.Add(ColumnRemark); DataGridViewTextBoxColumn ColumnOrderTime = new DataGridViewTextBoxColumn(); ColumnOrderTime.DataPropertyName = "OrderTime"; ColumnOrderTime.Name = "ColumnOrderTime"; ColumnOrderTime.HeaderText = "预定时间"; ColumnOrderTime.Width = 120; ColumnOrderTime.DisplayIndex = 5; dgvMain.Columns.Add(ColumnOrderTime); DataGridViewAutoFilterTextBoxColumn ColumnTableNO = new DataGridViewAutoFilterTextBoxColumn(); ColumnTableNO.DataPropertyName = "TableNO"; ColumnTableNO.Name = "ColumnTableNO"; ColumnTableNO.HeaderText = "台号"; ColumnTableNO.Width = 120; ColumnTableNO.DisplayIndex = 6; dgvMain.Columns.Add(ColumnTableNO); DataGridViewAutoFilterTextBoxColumn ColumnTableName = new DataGridViewAutoFilterTextBoxColumn(); ColumnTableName.DataPropertyName = "TableName"; ColumnTableName.Name = "ColumnTableName"; ColumnTableName.HeaderText = "台号"; ColumnTableName.Width = 120; ColumnTableName.DisplayIndex = 7; dgvMain.Columns.Add(ColumnTableName); DataGridViewAutoFilterTextBoxColumn ColumnEmployeeNO = new DataGridViewAutoFilterTextBoxColumn(); ColumnEmployeeNO.DataPropertyName = "EmployeeNO"; ColumnEmployeeNO.Name = "ColumnEmployeeNO"; ColumnEmployeeNO.HeaderText = "责任员工"; ColumnEmployeeNO.Width = 120; ColumnEmployeeNO.DisplayIndex = 8; dgvMain.Columns.Add(ColumnEmployeeNO); DataGridViewComboBoxColumn ColumnState = new DataGridViewComboBoxColumn(); ColumnState.DataPropertyName = "State"; ColumnState.Name = "ColumnState"; ColumnState.HeaderText = "状态"; ColumnState.Width = 60; ColumnState.DisplayIndex = 9; ColumnState.Visible = false; dgvMain.Columns.Add(ColumnState); DataGridViewTextBoxColumn ColumnRecordTime = new DataGridViewTextBoxColumn(); ColumnRecordTime.DataPropertyName = "RecordTime"; ColumnRecordTime.Name = "ColumnRecordTime"; ColumnRecordTime.HeaderText = "记录时间"; ColumnRecordTime.Width = 120; ColumnRecordTime.DisplayIndex = 10; dgvMain.Columns.Add(ColumnRecordTime); DataGridViewTextBoxColumn ColumnDiningTableID = new DataGridViewTextBoxColumn(); ColumnDiningTableID.DataPropertyName = "DiningTableID"; ColumnDiningTableID.Name = "ColumnDiningTableID"; ColumnDiningTableID.HeaderText = "台ID"; ColumnDiningTableID.Width = 120; ColumnDiningTableID.DisplayIndex = 11; ColumnDiningTableID.Visible = false; dgvMain.Columns.Add(ColumnDiningTableID); ColumnState.DataSource = CGlobalInstance.Instance.DbAdaHelper.GetPrearrangeState(); ColumnState.DisplayMember = "ItemName"; ColumnState.ValueMember = "ItemValue"; timer1.Enabled = true; bs = new BindingSource(); ShowPrearrange(); }