/// <summary> /// 添加订单中的图书 /// </summary> /// <param name="order"></param> public static void AddOrderBook(OrderBook order) { string sql = "INSERT OrderBook (OrderID, BookID, Quantity,UnitPrice)" + " VALUES (@OrderID, @BookID, @Quantity,@UnitPrice)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@OrderID", order.Order.Id), new SqlParameter("@BookID", order.Book.Id), new SqlParameter("@Quantity", order.Quantity), new SqlParameter("@UnitPrice", order.UnitPrice) }; DBHelper.ExecuteCommand(sql, para); }
/// <summary> /// 通过id获取订单 /// </summary> /// <param name="id"></param> /// <returns></returns> public static IList<OrderBook> GetDetailOrderById(int id) { List<OrderBook> list = new List<OrderBook>(); string sql = "SELECT * FROM OrderBook WHERE OrderID = @OrderID"; DataTable table = DBHelper.GetDataSet(sql, new SqlParameter("@OrderID", id)); foreach (DataRow dr in table.Rows) { OrderBook book = new OrderBook(); book.Id = (int)dr["Id"]; book.Order =OrderService.GetOrderById((int)dr["OrderID"]) ; book.Quantity = (int)dr["Quantity"]; book.UnitPrice = (decimal)dr["UnitPrice"]; book.Book = BookService.GetBookById((int)dr["BookID"]); list.Add(book); } return list; }
/// <summary> /// 添加订单中的图书 /// </summary> /// <param name="order"></param> public static void AddOrderBook(OrderBook order) { OrderBookService.AddOrderBook(order); }