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 DataTable Order_numToOrder_info(Int64 OrderNum)
{
systemDataSetTableAdapters.order_infoTableAdapter order_info = new systemDataSetTableAdapters.order_infoTableAdapter();
DataTable dt = order_info.GetDataByOrder_num(OrderNum);
return dt;
}
public DataTable GetByOrderid(Int64 order_id)
{
systemDataSetTableAdapters.order_infoTableAdapter infoAp = new systemDataSetTableAdapters.order_infoTableAdapter();
DataTable dt = infoAp.GetDataByOrder_num(order_id);
return dt;
}
