/// <summary>
/// 订桌
/// </summary>
/// <param name="table"></param>
/// <param name="AmountofCustomer"></param>
/// <returns></returns>
public int CreateOrder(string table, int AmountofCustomer)
{
int i = 0;
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@table", table);
para[1] = new SqlParameter("@AmountofCustomer", AmountofCustomer);
return(i = SQLHelper.GetScalar("createorder", para));
}
/// <summary>
/// 结算
/// </summary>
/// <param name="tableid"></param>
/// <returns></returns>
public int submit(string tableid)
{
SqlParameter[] parameters =
{
new SqlParameter("@tableid", tableid)
};
int i = SQLHelper.GetScalar("proc_submit", parameters);
return(i);
}
/// <summary>
/// 所消费菜品的总价格
/// </summary>
/// <param name="tableid"></param>
/// <returns></returns>
public float total(string tableid)
{
SqlParameter[] parameters =
{
new SqlParameter("@tableid", tableid)
};
float sum = Convert.ToSingle(SQLHelper.GetScalar("proc_total", parameters));
return(sum);
}
/// <summary>
/// 加菜
/// </summary>
/// <param name="tableid"></param>
/// <param name="menu_name"></param>
/// <returns></returns>
public int AddDish(string tableid, string menu_name)
{
SqlParameter[] parameters =
{
new SqlParameter("@tableid", tableid),
new SqlParameter("@menu_name", menu_name)
};
int i = SQLHelper.GetScalar("proc_AddDish", parameters);
return(i);
}
/// <summary>
/// 换桌
/// </summary>
/// <param name="oldone"></param>
/// <param name="newone"></param>
/// <returns></returns>
public int changeTable(string oldone, string newone)
{
SqlParameter[] parameters =
{
new SqlParameter("@firstid", oldone),
new SqlParameter("@lastid", newone)
};
int i = SQLHelper.GetScalar("proc_changeTable", parameters);
return(i);
}
/// <summary>
/// 向菜单详细表中插入数据
/// </summary>
/// <param name="tableid"></param>
/// <param name="menu_name"></param>
/// <returns></returns>
public int CreateOrderDetails(string tableid, string menu_name)
{
SqlParameter[] parameters =
{
new SqlParameter("@tableid", tableid),
new SqlParameter("@menu_name", menu_name)
};
int i = SQLHelper.GetScalar("proc_OrderDetail", parameters);
return(i);
}
