public Boolean InsertOrder(systemDataSet.ordersDataTable Orders,DataRow[] order_list)
{
try
{
systemDataSetTableAdapters.ordersTableAdapter orders = new systemDataSetTableAdapters.ordersTableAdapter();
DataRow orders_Row = Orders.Select().First();
systemDataSetTableAdapters.order_infoTableAdapter orderInfo = new systemDataSetTableAdapters.order_infoTableAdapter();
systemDataSet.order_infoDataTable infoDt = new systemDataSet.order_infoDataTable();
foreach (DataRow row in order_list)
{
DataRow InfoRow = infoDt.NewRow();
InfoRow["order_id"] = (Int64)orders_Row["order_num"];
InfoRow["dish_id"] = (int)row["Dish_id"];
InfoRow["dish_num"] = (int)row["Dish_num"];
InfoRow["dish_price"] = (int)row["Dish_price"];
InfoRow["dish_name"] = (string)row["Dish_name"];
infoDt.Rows.Add(InfoRow);
}
orders.Update(Orders);
orderInfo.Update(infoDt);
return true;
}
catch (Exception ex)
{
return false;
}
}
public Int64 TableToOrder_num(int table_id)
{
systemDataSetTableAdapters.ordersTableAdapter orders = new systemDataSetTableAdapters.ordersTableAdapter();
DataTable dt = orders.GetDataByTable(table_id);
DataRow orderRow = dt.Select().First() ;
Int64 orderNum = (Int64)orderRow["order_num"];
return orderNum;
}
public void TurnTable(DataRowView firstTable, DataRowView secTable)
{
systemDataSetTableAdapters.tablesTableAdapter tables = new systemDataSetTableAdapters.tablesTableAdapter();
firstTable["type_id"] = 1;
secTable["type_id"] = 2;
tables.Update(firstTable.Row);
tables.Update(secTable.Row);
systemDataSetTableAdapters.ordersTableAdapter orders = new systemDataSetTableAdapters.ordersTableAdapter();
int FirTable_id = (int)firstTable["id"];
int SecTable_id = (int)secTable["id"];
systemDataSet.ordersDataTable ordersDt = orders.GetDataByTable(FirTable_id);
DataRow OrderRow = ordersDt.Select().First();
OrderRow["table_id"] = SecTable_id;
orders.Update(OrderRow);
}
public DataTable SelectAll()
{
systemDataSetTableAdapters.ordersTableAdapter orders = new systemDataSetTableAdapters.ordersTableAdapter();
DataTable dt = orders.GetData();
return dt;
}
