private void tabControlList_SelectedIndexChanged(object sender, EventArgs e)
{
iCurPageIndex = 0;
if (bindingSource1 != null)
{
bindingSource1.Filter = ""; //这个是为了界面过滤 Lgahero Xie
}
int State = -1;
State = GetCurrentState();
if (State != -1)
{
PaginationQuery.Filter = string.Format("State={0}", State);
}
else
{
PaginationQuery.Filter = "";
}
string ClassifyName = "";
if (tabControlList.SelectedTab != null)
{
ClassifyName = tabControlList.SelectedTab.Text;
}
SetShowStyle(ClassifyName);
PaginationQuery.RePaginationQuery();
DataRefresh();
ShowPageInfo();
DataGridViewYyFilterTextBoxColumn tmpColumnGoodsName = dgvMain.Columns["ColumnGoodsName"] as DataGridViewYyFilterTextBoxColumn;
if (tmpColumnGoodsName != null)
{
((DataGridViewYyFilterColumnHeaderCell)tmpColumnGoodsName.HeaderCell).ResetDropDown();
}
DataGridViewYyFilterTextBoxColumn tmpColumnGoodsClassifyName = dgvMain.Columns["ColumnGoodsClassifyName"] as DataGridViewYyFilterTextBoxColumn;
if (tmpColumnGoodsClassifyName != null)
{
((DataGridViewYyFilterColumnHeaderCell)tmpColumnGoodsClassifyName.HeaderCell).ResetDropDown();
}
}
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);
}
