private string GetSqlStatement()
{
DishTableStatus status = m_mainInfo.GetCheckedStatus();
frmMainScreenControl mainScreenControl = new frmMainScreenControl();
frmMainScreenControl.Status = status;
return(mainScreenControl.GetExeSql(CurrentAreaId, (CurrentSystemInfo.CurrentSysInfo[typeof(SalesPoint).FullName].FirstOrDefault() as SalesPoint).Id, m_mainInfo.txtSearchTable.Text));
}
private void RefreshDishTable()
{
frmMainScreenControl.Status = GetCheckedStatus();
string sql = mainScreenControl.GetExeSql(frmMain.CurrentAreaId, CurrentSystemInfo.SalesPoint.Id, txtSearchTable.Text);
//frmMain = new WinForms.frmMain();
CurrentUIForms.mainForm.FillDishTableData();
//mainScreenControl.DishTableDataTable = mainScreenControl.GetDishTableInfo(sql);
//frmMainScreenControl.DishTableDataTableClone = mainScreenControl.DishTableDataTable;
//frmMain main = new frmMain();
//main.MainScreenControl = mainScreenControl;
//main.FillDishTable();
}
public void FillDishTableData(string sql)
{
if (mainScreenControl.DishTableDataTable != null)
{
mainScreenControl.DishTableDataTable = null;
}
sql = mainScreenControl.GetExeSql(CurrentAreaId, CurrentSystemInfo.SalesPoint.Id, m_mainInfo.txtSearchTable.Text);
mainScreenControl.DishTableDataTable = mainScreenControl.GetDishTableInfo(sql);
frmMainScreenControl.DishTableDataTableClone = mainScreenControl.DishTableDataTable;
if (mainScreenControl.DishTableDataTable.Rows.Count > 0)
{
this._mMaxDishTablePage = Convert.ToInt32(mainScreenControl.DishTableDataTable.Rows.Count / CurrentUIForms.custDishTables.Length) + 1;
}
if (this._mCurrDishTablePage < 1)
{
this._mCurrDishTablePage = 1;
}
if (_mMaxDishTablePage > 0)
{
if (this._mCurrDishTablePage > this._mMaxDishTablePage)
{
this._mCurrDishTablePage = _mMaxDishTablePage;
}
}
for (int i = 0; i < CurrentUIForms.custDishTables.Length; i++)
{
if ((this._mCurrDishTablePage - 1) * CurrentUIForms.custDishTables.Length + i < mainScreenControl.DishTableDataTable.DefaultView.Count)
{
CurrentUIForms.custDishTables[i].TableId = Convert.ToInt32(mainScreenControl.DishTableDataTable.DefaultView[(this._mCurrDishTablePage - 1) * CurrentUIForms.custDishTables.Length + i]["Id"]);
CurrentUIForms.custDishTables[i].GuestCount = Convert.ToInt32(mainScreenControl.DishTableDataTable.DefaultView[(this._mCurrDishTablePage - 1) * CurrentUIForms.custDishTables.Length + i]["GuestCount"]);
CurrentUIForms.custDishTables[i].Status = Convert.ToInt32(mainScreenControl.DishTableDataTable.DefaultView[(this._mCurrDishTablePage - 1) * CurrentUIForms.custDishTables.Length + i]["Status"]);
CurrentUIForms.custDishTables[i].TableName = Convert.ToString(mainScreenControl.DishTableDataTable.DefaultView[(this._mCurrDishTablePage - 1) * CurrentUIForms.custDishTables.Length + i]["Name"]);
//this.custDishTables[i].Style = Convert.ToString(mainScreenControl.DishTableDataTable.DefaultView[(this.m_currDishTablePage - 1) * this.custDishTables.Length + i]["Style"]);
CurrentUIForms.custDishTables[i].Visible = true;
this.ccButtonGrid1.SetBtnVisual(i, true);
}
else
{
ccButtonGrid1.SetBtnVisual(i, false);
}
ccButtonGrid1.SetBtnId(i, CurrentUIForms.custDishTables[i].TableId);
ccButtonGrid1.SetBtnText(i, CurrentUIForms.custDishTables[i].GetTableCaption());
//Color color = this.custDishTables[i].GetBtnBackColor();
Color color = Color.White;
this.ccButtonGrid1.SetBtnColr(i, color);
switch (CurrentUIForms.custDishTables[i].Status)
{
case 1:
this.ccButtonGrid1.SetBtnImage(i, @"E:\51CTO下载-C# 餐饮管理系统 详细源代码\MrCy\Backup\MrCy\Image\a_1.gif");
break;
case 2:
this.ccButtonGrid1.SetBtnImage(i, @"E:\51CTO下载-C# 餐饮管理系统 详细源代码\MrCy\Backup\MrCy\Image\a_2.gif");
break;
case 3:
this.ccButtonGrid1.SetBtnImage(i, @"E:\51CTO下载-C# 餐饮管理系统 详细源代码\MrCy\Backup\MrCy\Image\a_3.jpg");
break;
case 4:
this.ccButtonGrid1.SetBtnImage(i, @"E:\51CTO下载-C# 餐饮管理系统 详细源代码\MrCy\Backup\MrCy\Image\a_4.jpg");
break;
default:
break;
}
this.ccButtonGrid1.SetBtnText(CurrentUIForms.custDishTables.Length, "翻 页");
this.ccButtonGrid1.SetBtnColr(CurrentUIForms.custDishTables.Length, Color.PeachPuff);
this.ccButtonGrid1.SetBtnImage(CurrentUIForms.custDishTables.Length, @"e:\RMS\RMS\WinForms\bin\Debug\Task1.ico");
if (mainScreenControl.DishTableDataTable.Rows.Count < CurrentUIForms.custDishTables.GetUpperBound(0))
{
this.ccButtonGrid1.SetBtnVisual(CurrentUIForms.custDishTables.Length, false);
}
else
{
this.ccButtonGrid1.SetBtnVisual(CurrentUIForms.custDishTables.Length, true);
}
if (this._mCurrDishTableId == CurrentUIForms.custDishTables[i].TableId)
{
this.ccButtonGrid1.SetBtnText(i, "√" + CurrentUIForms.custDishTables[i].TableName);
}
}
//frmMainInfo mainInfo = new frmMainInfo();
//mainInfo.BindDishTableInfo();
//BindDishTableInfo();
isRefreshing = false;
}