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 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);
}