//获取手牌绑定的项目
public CMenu get_seat_menu(string text)
{
CMenu menu = null;
SqlConnection sqlCn = null;
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
string cmd_str = "select * from [Menu] where id=(select menuId from [seattype] where id=(select typeId from [seat] where text='"+text + "'))";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
menu = new CMenu();
menu.id = (int)dr["id"];
menu.name = dr["name"].ToString();
menu.catgoryId = (int)dr["catgoryId"];
menu.unit = dr["unit"].ToString();
menu.price = (double)dr["price"];
menu.technician = (bool)dr["technician"];
menu.waiter = ToBool(dr["waiter"]);
break;
}
}
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return menu;
}
public List<CMenu> get_Menus(string state_str)
{
var menus = new List<CMenu>();
SqlConnection sqlCn = null;
string cmd_str = "";
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
cmd_str = "Select * from [Menu]";
if (state_str != null && state_str != "")
cmd_str += " where (" + state_str + ")";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
var menu = new CMenu();
menu.id = (int)dr["id"];
menu.name = dr["name"].ToString();
menu.catgoryId = (int)dr["catgoryId"];
menu.unit = dr["unit"].ToString();
menu.price = (double)dr["price"];
menu.technician = (bool)dr["technician"];
menu.waiter = ToBool(dr["waiter"]);
menus.Add(menu);
}
}
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return menus;
}
public List<CMenu> get_Menus(List<string> key, List<string> key_val, string logic)
{
var menus = new List<CMenu>();
SqlConnection sqlCn = null;
string cmd_str = "";
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
cmd_str = "Select * from [Menu] where (";
int count = key.Count;
for (int i = 0; i < count; i++)
{
cmd_str += key[i] + "='" + key_val[i] + "'";
if (i != count - 1)
cmd_str += " " + logic + " ";
}
cmd_str += ")";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
var menu = new CMenu();
menu.id = (int)dr["id"];
menu.name = dr["name"].ToString();
menu.catgoryId = (int)dr["catgoryId"];
menu.unit = dr["unit"].ToString();
menu.price = (double)dr["price"];
menu.technician = (bool)dr["technician"];
menu.waiter = ToBool(dr["waiter"]);
menus.Add(menu);
}
}
}
catch (System.Exception e)
{
//BathClass.printErrorMsg(cmd_str);
IOUtil.insert_file(e.Message);
IOUtil.insert_file("time=" + DateTime.Now.ToString() + ",cmd_str=" + cmd_str);
IOUtil.insert_file("\n");
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return menus;
}
public CMenu get_Menu(string key, object key_val)
{
CMenu menu = null;
SqlConnection sqlCn = null;
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
string cmd_str = "Select * from [Menu] where " + key + "='" + key_val.ToString() + "'";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
menu = new CMenu();
menu.id = (int)dr["id"];
menu.name = dr["name"].ToString();
menu.catgoryId = (int)dr["catgoryId"];
menu.unit = dr["unit"].ToString();
menu.price = (double)dr["price"];
menu.technician = (bool)dr["technician"];
menu.waiter = ToBool(dr["waiter"]);
menu.addAutomatic = (bool)dr["addAutomatic"];
menu.addType = dr["addType"].ToString();
menu.addMoney = ToDouble(dr["addMoney"]);
menu.ResourceExpense = ToString(dr["ResourceExpense"]);
}
}
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return menu;
}
private void order_menu(CMenu menu)
{
string pars = "menu,text,systemId,number,money,inputTime,paid";
string vals = "'" + menu.name + "','" + m_Seat.text + "','" + m_Seat.systemId + "',1," + menu.price + ",getdate(),'False'";
if (inputBillId)
{
var form = new InputNumberStr("输入单据编号");
if (form.ShowDialog() != DialogResult.OK)
{
BathClass.printErrorMsg("需要输入单据编号");
return;
}
pars += ",billId";
vals += ",'" + form.str + "'";
}
if (menu.technician)
{
pars += ",technician";
if (!m_has_user)
{
InputEmployee techForm = new InputEmployee("请输入技师号...");
if (techForm.ShowDialog() != DialogResult.OK)
{
BathClass.printErrorMsg("需要选择技师!");
return;
}
vals += ",'" + techForm.employee.id + "'";
}
else
vals += ",'" + m_user.id + "'";
//是否需要输入点钟轮钟
if (inputTechType)
{
var form = new DianLunForm();
if (form.ShowDialog() != DialogResult.OK)
{
BathClass.printErrorMsg("需要输入上钟类型!");
return;
}
pars += ",techType";
vals += ",'" + form.tech_type + "'";
}
}
if (!m_has_user && MConvert<bool>.ToTypeOrDefault(menu.waiter, false))
{
InputEmployee techForm = new InputEmployee("请输入服务员工号...");
if (techForm.ShowDialog() != DialogResult.OK)
{
BathClass.printErrorMsg("需要输入录单员!");
return;
}
pars += ",inputEmployee";
vals += ",'" + techForm.employee.id + "'";
}
else
{
pars += ",inputEmployee";
vals += ",'" + m_user.id + "'";
}
string cmd_str = @"insert into [Orders](" + pars + ") values(" + vals + ")";
if (!dao.execute_command(cmd_str))
{
BathClass.printErrorMsg("录单失败，请重试！");
return;
}
//BathClass.find_combo_duplicated(m_con_str, m_Seat.systemId, m_Seat.text);
BathClass.find_combo(m_con_str, m_Seat.systemId, m_Seat.text);
dgvExpense_show();
Thread td = new Thread(delegate() { print_kitchen(menu); });
td.Start();
}
private void print_kitchen(CMenu menu)
{
var cat = dao.get_Catgory("id=" + menu.catgoryId.ToString());
//var cat = db.Catgory.FirstOrDefault(x => x.id == menu.catgoryId);
if (cat != null && cat.kitchPrinterName != null && cat.kitchPrinterName != "")
{
PrintKitchen.Print_DataGridView(m_Seat.text, menu.name, cat.kitchPrinterName, m_user.name, "1",
DateTime.Now.ToString("MM-dd HH:mm"), "");
}
}