注意,订购项是通过一个单独的游标来检索的。
Note that the order lines are retrieved through a separate cursor.
检索每个订购项的发货日期、数量、总价和发货仓库。
The delivery date, quantity, total price and delivering warehouse are retrieved for each order line.
通过设置送货日期,将订购项标记为已发货。
Each order line is marked as delivered by setting the delivery day.
如果有任何订购项没有得到满足,过程将回滚该订单条目。
If any ordered item cannot be fulfilled, the procedure rolls back the order entry.
例如,所有未涉及订购项的步骤都被封装到一个sql表函数中。
For example, all the steps not involving the order lines have been unified into one SQL table function.
现实应用中存在很多一对多的情况,如一项订单中存在一个或多个订购项。
In reality, there are many one to many situations, such as one or more items in an order.
该函数为一个订购项(orderline)检索产品信息,并执行必要的库存更新。
The function retrieves the item information for an order line and performs the necessary stock updates.
通过更新order_lines中的delivery列,从各个订购项计算订单总值被合在一起。
Computing the total value of the order from the individual order lines has been folded together with the update of the delivery column in ORDER_LINES.
对于订单中的每一项,过程将检查库存数量是否满足订购数量。
For each item in the order, the procedure checks if the quantity in stock can fulfill the quantity ordered.
销售部门只需抽取出书名、它的项标识以及订购数量;因为这些信息是它可以保留的无需安全的不敏感信息。
The sales department will need to extract only the name of the book, its item ID and the quantity ordered; because this is insensitive information it can remain insecure.
考虑一个场景:一个顾客购物订单被存储在两个表中:ORDER和ORDER_ITEMS, ORDER中包含订购的总数,而ORDER_ITEMS中则包含订购的每一项商品的列表。
Consider a scenario where a customer purchase order is stored in two tables: order with the order summary and ORDER_ITEMS with the list of items for each order.
除基本合同,还有两项可选项,分别订购一部航空器。
比如,在图5中,DataFormatConversion是一项任务,负责将订购单消息转换为验证服务消息。
For example, in Figure 5, Data Format Conversion is a task with the responsibility of converting purchase order messages to validation service messages.
美国加利福尼亚州的一家基因储备和克隆公司推出了一项宠物克隆的服务,九个星期大的小尼奇成了世界上第一只被订购的克隆猫。
The first cloned-to-order pet sold in the United States is named Little Nicky, a 9-week-old kitten delivered to a Texas woman saddened by the loss of a cat she had owned for 17 years.
为重新加快增速,沃尔玛正在加州圣何塞试点推出一项新的服务,允许消费者在网上订购杂货,店家送货上门。
To speed it up again, Wal-Mart (WMT) is rolling out a new service, which it is now testing in San Jose, California, that allows customers to order groceries online for delivery. [Financial Times]
从下拉框选择一项主要产品,当该产品被订购,您所选定的促销产品(群)将会被推荐给客户。
Select the Parent product from the drop down box. When this product is selected for an order, the Offer product (s) that you define will be suggested to the customer.
请选择出你最喜欢的订购食物方法?(可以选择多于一项。)
Please choose your most favorable ways to make the delivery order? (you may choose more than one option.)
用二项式网格方法求解该模型,即可求得各阶段的最优订购策略。
The optimal strategies can be obtained by solve the model with binomial lattice method.
因为图书馆是一个从事大量图书订购与治理事变,以是治理图书馆是一项非常重要的事变。
Because the library is engaged in a large number of books purchase and management, so the management of library is a very important work.
因为图书馆是一个从事大量图书订购与治理事变,以是治理图书馆是一项非常重要的事变。
Because the library is engaged in a large number of books purchase and management, so the management of library is a very important work.
应用推荐