//加载主界面信息
void LoadHallInfo()
{
HallInfoBll bll = new HallInfoBll();
var halllist = bll.GetList();
foreach (var hall in halllist)
{
//根据包间名创建标签页
TabPage tp = new TabPage(hall.HTitle);
//创建显示列表
ListView lvtableinfo = new ListView();
//给显示列表绑定图片表
lvtableinfo.LargeImageList = imageList1;
//给显示列表绑定双击事件
lvtableinfo.DoubleClick += lvtableinfo_DoubleClick;
//获得当前包间内所有的餐桌对象
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("thallid", hall.HId.ToString());
TableInfoBll tbll = new TableInfoBll();
var tables = tbll.GetList(dic);
//向显示列表中添加餐桌对象
foreach (var table in tables)
{
ListViewItem item = new ListViewItem(table.TTitle, table.TIsFree?0:1);
item.Tag = table.TId;//绑定餐桌号码
lvtableinfo.Items.Add(item);
}
//将显示列表加入当前标签页中
tp.Controls.Add(lvtableinfo);
//将当前标签页加入tabtable中
tcHallInfo.Controls.Add(tp);
}
}
private void tabHall_SelectedIndexChanged(object sender, EventArgs e)
{
var tabPage = tabHall.SelectedTab;
var hid = Convert.ToInt32(tabPage.Tag);
var tiBll = new TableInfoBll();
//创建搜索table数据
var tiSearch = new TableInfo();
tiSearch.THallId = hid;
tiSearch.IsFreeSearch = -1;
//tableList
var listTableInfo = tiBll.GetList(tiSearch);
//listview 设置图片 风格 双击事件 单击事件
var listView = new ListView();
listView.MultiSelect = false;
listView.LargeImageList = imageList1;
listView.DoubleClick += ListView_DoubleClick;
listView.Dock = DockStyle.Fill;
listView.Click += ListView_Click;
//listview 添加到 tabPage
foreach (var tableInfo in listTableInfo)
{
//图片索引 0为空闲 1位不空闲
var item = new ListViewItem(tableInfo.TTitle, tableInfo.TIsFree ? 0 : 1);
item.Tag = tableInfo.TId;
listView.Items.Add(item);
}
tabPage.Controls.Add(listView);
}
private void LoadHallInfo()
{
HallInfoBll hiBll = new HallInfoBll();
var listHi = hiBll.GetList();
TableInfoBll tiBll = new TableInfoBll();
tabHallInfo.TabPages.Clear();
foreach (var hi in listHi)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("THallId", hi.HId.ToString());
var listTi = tiBll.GetList(dic);
TabPage tp = new TabPage(hi.HTitle);
ListView lv = new ListView();
lv.LargeImageList = ilTableInfo;
foreach (var ti in listTi)
{
ListViewItem lvi = new ListViewItem(ti.TTitle, ti.TIsFree ? 0 : 1);
lvi.Tag = ti.TId;
lv.Items.Add(lvi);
}
lv.Dock = DockStyle.Fill;
lv.DoubleClick += Lv_DoubleClick;
tp.Controls.Add(lv);
tabHallInfo.TabPages.Add(tp);
}
}
private int tableId; //桌子编号
private void OrderInfoList_Load(object sender, EventArgs e)
{
//获取从主窗体传递过来的餐桌编号
tableId = Convert.ToInt32(Tag);
//根据餐桌编号获取餐桌名称和餐桌所属厅包的名称,在窗体上面进行结账提示！
TableInfoBll tiBll = new TableInfoBll();
TableInfo ti = new TableInfo();
ti.TId = tableId;
List <TableInfo> list = new List <TableInfo>();
list = tiBll.GetList(ti);
string tableTitleById = list[0].TTitle;
string hallTypeById = list[0].HallType;
this.Text = "您正在为【" + hallTypeById + "】的【" + tableTitleById + "】号餐桌进行点菜操作！";
//根据餐桌编号，查询订单编号！（去Dal层封装一个方法）
orderId = oiBll.GetOidByTid(tableId);
//在菜单容器里面加载数据,封装一个方法
//加载所有菜品信息
LoadDishInfo();
LoadDishTypeInfo();
//加载所有已点菜品信息
LoadOrderList();
}
private void OrderDishList_Load(object sender, EventArgs e)
{
//根据餐桌编号获取餐桌名称和餐桌所属厅包的名称,在窗体上面进行提示！
TableInfoBll tiBll = new TableInfoBll();
TableInfo ti = new TableInfo();
ti.TId = Convert.ToInt32(this.Tag);
List <TableInfo> list = new List <TableInfo>();
list = tiBll.GetList(ti);
string tableTitleById = list[0].TTitle;
string hallTypeById = list[0].HallType;
lblOrderDish.Text = "正在查看【" + hallTypeById + "】【" + tableTitleById + "】号的点菜详情！";
this.Text = "【" + hallTypeById + "】【" + tableTitleById + "】";
//加载所有已点菜品，包含未下单的
OrderInfoBll oiBll = new OrderInfoBll();
//根据餐桌id获取订单id
int orderId = oiBll.GetOidByTid(Convert.ToInt32(this.Tag));
gvOrderDishInfo.AutoGenerateColumns = false;
gvOrderDishInfo.DataSource = oiBll.GetOrderDetail(orderId);
//计算点菜总金额
GetOrderMoney();
}
//批量生成->本地（持久化操作）
private void btnBatchSaveLocal_Click(object sender, EventArgs e)
{
try
{
string nameSpace = tbxNameSpace.Text.Trim(); //命名空间
enumTableType tableType = (enumTableType)Enum.Parse(typeof(enumTableType), cbxTable.SelectedItem.ToString()); //当前选中的类型值
//获取当前库中的所有表(当前只做基础表，稍后将该选项抛给前端选择。)
TableInfoBll tableInfoBll = new TableInfoBll();
ColumnInfoBll columnInfoBll = new ColumnInfoBll();
List <TableInfo> listTables = tableInfoBll.FindTableInfoByTableType(tableType);
foreach (var item in listTables)
{
//Model持久化
//获取生成的内容
string generateContent = columnInfoBll.DynamicGenerateModel(item.TableName, nameSpace);
//缓存内容持久化（保存）到本地
string pathModel = string.Format("{0}/Model", AppDomain.CurrentDomain.BaseDirectory); //模型管理目录
string pathModelFile = string.Format("{0}/Model/{1}.cs", AppDomain.CurrentDomain.BaseDirectory, item.TableName); //模型文件
if (!Directory.Exists(pathModel))
{
//不存在
Directory.CreateDirectory(pathModel);
}
File.WriteAllText(pathModelFile, generateContent, Encoding.UTF8);//写入操作
}
MessageBox.Show("数据持久化成功，请前往应用程序所在的目录下查看！");
}
catch (Exception)
{
MessageBox.Show("数据持久化失败！");
}
}
private void LoadHallInfo()
{
HallInfoBll hiBll = new HallInfoBll();
var list = hiBll.GetList();
tcHallInfo.TabPages.Clear();
TableInfoBll tiBll = new TableInfoBll();
foreach (var hi in list)
{
TabPage tp = new TabPage(hi.HTitle);
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("thallid", hi.HId.ToString());
var listTableInfo = tiBll.GetList(dic);
ListView lvTableInfo = new ListView();
lvTableInfo.LargeImageList = imageList1;
lvTableInfo.DoubleClick += LvTableInfo_DoubleClick;
lvTableInfo.Dock = DockStyle.Fill;
tp.Controls.Add(lvTableInfo);
foreach (var ti in listTableInfo)
{
var lvi = new ListViewItem(ti.TTitle, ti.TIsFree ? 0 : 1);
lvi.Tag = ti.TId;
lvTableInfo.Items.Add(lvi);
}
tcHallInfo.TabPages.Add(tp);
}
}
//表类型 更改事件
private void cbxTable_SelectedIndexChanged(object sender, EventArgs e)
{
//当前选中的值
enumTableType tableType = (enumTableType)Enum.Parse(typeof(enumTableType), cbxTable.SelectedItem.ToString());
//获取当前类型的表 信息列表
TableInfoBll tableInfoBll = new TableInfoBll();
List <TableInfo> listTableInfo = tableInfoBll.FindTableInfoByTableType(tableType);
//要操作的类型下的表 列表
string contentTableInfo = string.Join(Environment.NewLine, listTableInfo.Select(p => p.TableName).ToArray());
tbxContent.Text = contentTableInfo;
}
private void ListViewTest_Load(object sender, EventArgs e)
{
//获取餐桌信息
TableInfoBll tiBll = new TableInfoBll();
var list = tiBll.GetList(new Dictionary <string, string>());
//遍历集合，添加餐桌
foreach (var ti in list)
{
lvTableInfo.Items.Add(ti.TTitle, 0);
}
}
private void LoadHallInfo()
{
//2.1 Get all the area object
HallInfoBll hiBll = new HallInfoBll();
var list = hiBll.GetList();
//Clear previous tab pages
//2.2 Go through the set, add info to tag pages.
tcHallInfo.TabPages.Clear();
TableInfoBll tiBll = new TableInfoBll();
foreach (var hi in list)
{
//Create a tab each area.
TabPage tp = new TabPage(hi.HTitle);
//3.1 Create a ListView for each area tap
ListView lvTableInfo = new ListView();
//Double click to create a new order
lvTableInfo.DoubleClick += lvTableInfo_DoubleClick;
//3.2 Combine the imageList to listview
lvTableInfo.LargeImageList = imageList1;
lvTableInfo.Dock = DockStyle.Fill;
tp.Controls.Add(lvTableInfo);
//4.1 Get the tables of the area
//Set query condition
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("thallid", hi.HId.ToString());
var listTableInfo = tiBll.GetList(dic);
//Double click the ListView, add a creating new order event
lvTableInfo.DoubleClick += LvTableInfo_DoubleClick_New_Order;
//4.2 Add table info to the list
foreach (var ti in listTableInfo)
{
var lvi = new ListViewItem(ti.TTitle, ti.TIsFree ? 0 : 1);
//Keep the table number in lvi.Tag, which could be used when creating a new order
lvi.Tag = ti.TId;
lvTableInfo.Items.Add(lvi);
}
//2.3 Add tab page into a tab container
tcHallInfo.TabPages.Add(tp);
//tcHallInfo.TabPages.Add(new TabPage(hi.HTitle));
}
}
private void LoadHallInfo()
{
//获取所有的HallInfo厅包对象
HallInfoBll hiBll = new HallInfoBll();
List <HallInfo> list = hiBll.GetList();
//遍历集合,向标签页中添加信息.遍历以前先清理一下TabPage集合
tcHallInfo.TabPages.Clear();
TableInfoBll tiBll = new TableInfoBll();
foreach (var hi in list)
{
//根据厅包对象创建标签页
TabPage tp = new TabPage(hi.HTitle);
//获取到当前厅包的餐桌
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("THallId", hi.HId.ToString());
List <TableInfo> tableInfoList = tiBll.GetList(dic);
//动态创建元素(列表)添加到容器(标签页)上
ListView lvTableInfo = new ListView();
//添加listview双击事件,完成开单功能
lvTableInfo.DoubleClick += LvTableInfo_DoubleClick;
//设置imagelist,让列表使用图片
lvTableInfo.LargeImageList = imageList1;
lvTableInfo.Dock = DockStyle.Fill;
tp.Controls.Add(lvTableInfo);
foreach (var ti in tableInfoList)
{
var lvi = new ListViewItem(ti.TTitle, ti.TIsFree ? 0 : 1);
//后续操作需要用到餐桌编号,所以在这里存一下
lvi.Tag = ti.TId;
lvTableInfo.Items.Add(lvi);
}
//将标签页加入到标签容器
tcHallInfo.TabPages.Add(tp);
}
}
//厅包选择改变之后，加载当前厅包下的所有餐桌
private void tabHall_SelectedIndexChanged(object sender, EventArgs e)
{
//操作过程：选择一个Tabpage，然后根据当前选中的tabpage存储的厅包编号，查找里面的餐桌，然后创建ListView，
//加入所有的餐桌，再将ListView加到当前选中的TagPage
//1、获取选中的tabpage
var tabpage = tabHall.SelectedTab; //获取当前选定的选项卡页，tabHall就是一个控件，tabpage表示当前选定的选项卡
int hallId = Convert.ToInt32(tabpage.Tag); //这里不懂看上面，这通过tag把厅包编号传过来
//2、查询餐桌
TableInfoBll tiBll = new TableInfoBll();//构造业务逻辑层对象，根据条件查询
//构造搜索条件
int hid = hallId;
TableInfo tiSearch = new TableInfo();
tiSearch.THallId = hid; //厅包的条件
tiSearch.IsFreeSearch = -1; //显示所有餐桌
//根据上面的查询条件，这里获得的是当前厅包下面的所有餐桌信息的集合
var listTableInfo = tiBll.GetList(tiSearch);
//3、创建ListView，加入项
ListView listview = new ListView();
listview.LargeImageList = imageList1; //设置大图标
listview.Dock = DockStyle.Fill; //图标自己自动整齐排列，大概就是这个意思，图片停靠
//
//为ListView绑定双击事件，以获得被双击的项，从而完成点菜。
listview.DoubleClick += listview_DoubleClick;//写完+=之后，直接按两下tab键
//为ListView绑定单击事件，用来获得被选中的餐桌编号，用于结账
listview.Click += listview_Click;
//给查询到的当前厅包下面的所有餐桌信息，进行遍历
foreach (var tableInfo in listTableInfo)
{
//这里把餐桌的名称，空闲状态，和餐桌编号给item，进行遍历
ListViewItem item = new ListViewItem(tableInfo.TTitle, tableInfo.TIsFree?0:1); //第一个参数是显示名称，第二个参数是根据空闲状态选择图片
//得到tableid，得到餐桌的编号，方便后面的开单操作
item.Tag = tableInfo.TId; //这里把餐桌编号给了tag，所以在下面可以使用tag传递餐桌编号结账，也使用tag进行开单点菜加菜
listview.Items.Add(item); //加入到显示前面定义的选项卡中
}
//4、将ListView加入当前选中的tabPag
tabpage.Controls.Add(listview);
}
/// <summary>
/// 动态加载厅包
/// </summary>
private void LoadHallInfo()
{
//清空对象
tcHallInfo.TabPages.Clear();
//获取所有厅包对象
HallInfoBll hiBll = new HallInfoBll();
TableInfoBll tiBll = new TableInfoBll();
var list = hiBll.GetList();
//遍历集合,向标签页中添加信息
foreach (var hallInfo in list)
{
//根据厅包对象创建标签页对象
TabPage tp = new TabPage(hallInfo.HTitle);
//获取当前厅包的所有餐桌
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("THallId", hallInfo.HId.ToString());
var listT = tiBll.GetList(dic);
//动态创建元素添加到标签页上
ListView lvTableInfo = new ListView();
lvTableInfo.DoubleClick += lvTableInfo_DoubleClick;
tp.Controls.Add(lvTableInfo);
lvTableInfo.ShowItemToolTips = true;
//控件充满容器
lvTableInfo.Dock = DockStyle.Fill;
//让列表使用图片
lvTableInfo.LargeImageList = imageList1;
//添加餐桌信息
foreach (var ti in listT)
{
ListViewItem lvi = new ListViewItem(ti.TTitle, ti.TIsFree == 1 ? 0 : 1);
//存一下餐桌编号,后续要用到
lvi.Tag = ti.TId;
//设置提示信息
lvi.ToolTipText = lvi.Tag.ToString() + "号桌 " + (lvi.ImageIndex == 0 ? "空闲" : "使用中");
lvTableInfo.Items.Add(lvi);
}
//将标签页加入标签容器
tcHallInfo.TabPages.Add(tp);
}
}
private void ListViewTest_Load(object sender, EventArgs e)
{
//构造查询条件
TableInfo tiSearch = new TableInfo();
tiSearch.THallId = 0;
tiSearch.IsFreeSearch = -1;
//查询餐桌数据
TableInfoBll tiBll = new TableInfoBll();
var list = tiBll.GetList(tiSearch);
//遍历数据，构造列表项，并加入列表中
foreach (var ti in list)
{
//在创建列表项时，根据使用状态设置图片
ListViewItem item = new ListViewItem(ti.TTitle, ti.TIsFree ? 1 : 0);
listView1.Items.Add(item);
}
}
private void LoadHallInfo()
{
//2.1、获取所有的厅包对象
HallInfoBll hiBll = new HallInfoBll();
var list = hiBll.GetList();
//2.2、遍历集合，向标签页中添加信息
tabControl1.TabPages.Clear();
TableInfoBll tiBll = new TableInfoBll();
foreach (var hi in list)
{
//根据厅包对象创建标签页对象
TabPage tp = new TabPage(hi.HTitle);
//3.1、动态创建列表添加到标签页上
ListView lvTableInfo = new ListView();
//添加双击事件，完成开单功能
lvTableInfo.DoubleClick += lvTableInfo_DoubleClick;
//3.2、让列表使用图片
lvTableInfo.LargeImageList = imageList1;
lvTableInfo.Dock = DockStyle.Fill;
//3.3、将listview添加到标签页中
tp.Controls.Add(lvTableInfo);
//4.1、获取当前厅包对象的所有餐桌
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("thallid", hi.HId.ToString());
var listTableInfo = tiBll.GetList(dic);
//4.2、向列表中添加餐桌信息
foreach (var ti in listTableInfo)
{
var lvi = new ListViewItem(ti.TTitle, ti.TIsFree ? 0 : 1);
//后续操作需要用到餐桌编号，所以在这里存一下
lvi.Tag = ti.TId;
lvTableInfo.Items.Add(lvi);
}
//2.3、将标签页加入标签容器
tabControl1.TabPages.Add(tp);
}
}
private void LoadHallInfo()//在主页面加载厅包信息
{
//获取所有的厅包对象
HallInfoBll hiBll = new HallInfoBll();
var list = hiBll.GetList();
//清空，避免修改后反复添加
tcHallInfo.TabPages.Clear();
//遍历集合，向标签页中添加信息
TableInfoBll tiBll = new TableInfoBll();
foreach (var hi in list)
{
//根据厅包对象，创建标签页对象
TabPage tp = new TabPage(hi.HTitle);
//获取当前厅包对象的所有餐桌
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("thallid", hi.HId.ToString());
var listTableInfo = tiBll.GetList(dic);
//动态创建列表，添加到标签页上
ListView lvTableInfo = new ListView();
//添加双击事件，完成开单功能，+=之后双击Tab键，获得双击事件的方法
lvTableInfo.DoubleClick += LvTableInfo_DoubleClick1;
lvTableInfo.LargeImageList = imageList1;
lvTableInfo.Dock = DockStyle.Fill;
tp.Controls.Add(lvTableInfo);
//向列表中添加餐桌信息
foreach (var ti in listTableInfo)
{
var lvi = new ListViewItem(ti.TTitle, ti.TIsFree ? 0 : 1);
//后续开单操作需要用到餐桌编号，所以在这里存一下
lvi.Tag = ti.TId;
lvTableInfo.Items.Add(lvi);
}
//将标签页加入标签容器
tcHallInfo.TabPages.Add(tp);
}
}
private decimal payShouldOmoney = 0;//这里需要存储客户打折后应该付的的金额
private void OrderPay_Load(object sender, EventArgs e)
{
gbMember.Enabled = false;
//根据餐桌编号获取餐桌名称和餐桌所属厅包的名称,在窗体上面进行提示！
TableInfoBll tiBll = new TableInfoBll();
TableInfo ti = new TableInfo();
ti.TId = Convert.ToInt32(this.Tag);
tableId = ti.TId;
List <TableInfo> list = new List <TableInfo>();
list = tiBll.GetList(ti);
string tableTitleById = list[0].TTitle;
string hallTypeById = list[0].HallType;
this.Text = "【" + hallTypeById + "】【" + tableTitleById + "】号结账！";
//查询消费金额,这里一定要注意，点菜之后要点击下单，否则结账的时候是无法查到消费金额
lblConsumeMoney.Text = oiBll.GetMoneyByTid(ti.TId).ToString();
//默认实际付款就是消费金额
lblShouldMoney.Text = lblConsumeMoney.Text;
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
//操作过程：选择一个tabPage，然后根据当前选中的TabPage存储的厅包编号，查找里面的餐桌
//然后创建ListView，加入所有的餐桌，再讲ListView加到当前选中的TabPage中
//1/获取选中的tabPage
var tabPage = tabControl1.SelectedTab;
int hallId = Convert.ToInt32(tabPage.Tag);
//2、查询餐桌
TableInfo tiSearch = new TableInfo();
tiSearch.THallId = hallId; //厅包的条件
tiSearch.IsFreeSearch = -1; //空闲状态的要求，-1表示全部
TableInfoBll tiBll = new TableInfoBll();
var listTableInfo = tiBll.GetList(tiSearch);
//3、创建ListView，加入项
ListView listView = new ListView();
listView.LargeImageList = imageList1;
listView.Dock = DockStyle.Fill;
listView.MultiSelect = false;
//为ListView绑定双击事件，以获得被双击的项，从而完成点菜
listView.DoubleClick += listview_DoubleClick;
//为ListView绑定单击事件，以获得被选中的餐桌，用于结账
listView.Click += ListView_Click;
foreach (var tableInfo in listTableInfo)
{
ListViewItem item = new ListViewItem(tableInfo.TTitle, tableInfo.TIsFree ? 0 : 1);
item.Tag = tableInfo.TId;
listView.Items.Add(item);
}
//4、将ListView加入当前选中的TabPage
tabPage.Controls.Add(listView);
}
private void tabHall_SelectedIndexChanged(object sender, EventArgs e)
{
TabPage tabPage = tabHall.SelectedTab;
ListView listView = new ListView();
listView.Dock = DockStyle.Fill;
listView.LargeImageList = imageList1;
listView.DoubleClick += ListView_DoubleClick;
listView.Click += ListView_Click;
TableInfo tableInfo = new TableInfo();
tableInfo.THallId = Convert.ToInt32(tabPage.Tag);
tableInfo.HState = -1;
List <TableInfo> tiList = new TableInfoBll().GetList(tableInfo);
foreach (TableInfo item in tiList)
{
ListViewItem listViewItem = new ListViewItem(item.TTitle, item.TIsFree ? 0 : 1);
listViewItem.Tag = item.TId;
listView.Items.Add(listViewItem);
}
tabPage.Controls.Add(listView);
}
private FrmTableInfo()
{
InitializeComponent();
tiBll = new TableInfoBll();
}