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();
}
