第五章说明了纺织品出口销售查询系统的实现过程。
The fifth chapter introduces the developing course of textile export sales inquire system.
实现图书的入库查询、入库退货查询、图书销售查询等信息查询。
Realize the books warehouse queries, warehousing return query, book sales query information query, etc.
而这些是要在你开始处理技术支持,销售查询,点击收费搜索引擎,广告等等之前就要做的。
And that's before you start dealing with the technical support, sales enquiries, CPC search engines, advertising and so on.
例如,如果构建一个用于销售录像带的应用程序,您可能预期用户会查询标题中包含某个关键字并且由某个导演执导的所有视频。
For example, if you build an application to sell video tapes, you might expect a user to query for all the videos that have a certain keyword in the title and that were directed by a given person.
经理们希望找到的上一个查询的一个变体是查看在城市圣何塞中销售的产品。
One variation of the above query the executives are interested in finding is the total sales of products in the city of San Francisco.
本章中的很多查询都依赖于聚合的销售总额。
Many of the queries in this chapter rely on aggregated sales totals.
销售事实查询主题的事实数据一旦加入报表,连接关系就会对销售事实表而不是伪事实起作用,就会返回需要的数据。
As soon as fact data from the sales fact query subject is added to the report, the join relationship goes through the sales fact table rather than the fake fact, and the data returns as expected.
例如,从一个PowerCube中提取可用于销售度量指标查询的Producttypekey可能会按以下语法来使用一个QueryCalculation。
For example, extracting Product type key from a PowerCube for use in a sales measure query would use a query Calculation with the following syntax.
按城市计算总销售的查询可以写成
The query to compute aggregate sales by city can be written as
这个查询会执行一个外连接操作,以便比较从 1 月份至 11 月份的10 个特殊商店的销售信息。
This query performs an outer join to compare the sales information for 10 particular stores for January and November.
因为预先缓存了来自[HistoricSales]数据集的查询结果,所以整个时间段的销售数据执行的查询性能得到了改善。
Because query results from the [HistoricSales] cube are pre-cached, the performance for queries that are run against the sales data of the entire time period is improved.
购买和下订单 :查询类似“折扣代码(折扣券)“、”折扣券代号“、”大减价“等等的关健词是很常见的,特别是对那些直接通过网站销售产品的公司和个人。
Purchase: Queries like "discount code" "coupon code" "special offers" etc. are common, particularly for anyone selling directly over the web.
清单6创建了一个列表查询,该查询以列表提要的形式返回工作表中销售额超过某个限值的所有行。
Listing 6 creates a list query that returns all rows in the worksheet with sales units above a particular limit as a list feed.
考虑如下示例查询,该查询用于发现所有同时在美国和欧洲销售的美容产品的总销售量。
Consider an example query that finds the aggregate sales of all the beauty products sold in the US that are also sold in Europe.
清单7以isbn键作为公分母组合前面两个查询,以便产生包含图书标题、作者、图像、价格以及销售队伍的复合结果。
Listing 7 combines the two preceding queries, using the ISBN key as the common denominator, to produce a composite result containing book titles, authors, images, prices, and sales ranks.
销售状况的查询及统计,这是销售管理系统的基本功能。
Sales condition with inquiry and statistics, this is the basic function for sells management system.
一旦MQT 已经创建并填充好,当用户提交一个查询以找到总销售数据或变体信息时,就会通过使用 aggregate_sales MQT 来满足该查询。
Once the MQT is created and populated, when a user submits a query to find aggregate sales or its variant information, it may be satisfied by using the aggregate_sales MQT.
由于sales表存储每日销售总额,因此数据库设计应包括用于回答这些查询的聚合表。
Because the Sales table stores daily totals, your database design might include aggregate tables to answer these queries.
由于[CurrentMonthSales]数据集更小,所以当前月份或整个时间段的销售数据的查询性能得到了改善。
Because of the smaller size of the [CurrentMonthSales] cube, the performance for queries that are run against the sales data of the current month or the entire time period is improved.
协助销售助理处理更复杂的查询或投诉。
Handle more complex inquiries or complaints which cannot be resolved by Sales Assistants.
本系统可以记录汽车零部件的进货入库和销售出库,可以对库存情况进行简单查询、汇总操作。
The system can record the purchase of auto parts warehousing and sales, and you can check the information of the auto parts easily, and make the summary of operation.
LookupItem通常将用于需要在销售前在库存系统中查询商品的零售方案中。
Lookup item would typically be used in a retail scenario where an item would need to be looked up in an inventory system before it could be sold.
但这种方法例如如果我展示销售报告(从一个存储过程),我必须与所有查询中的列在客户端和服务器端创建一个类。
But with this method if for example I'm showing a sales report (from a stored procedure), I have to create a class with all the columns in the query in the client and the server side.
加油机IC卡收费软件系统是与硬件系统紧密配合的、集实时收费,综合查询和配套销售管理为一体的综合管理系统。
The IC card charging software system of refueler is cooperated with the hardware. It's a combination of real charging, multiple query, sail management.
本系统分为五个模块:用户管理、基本信息管理、入库管理、出库管理、销售管理和综合查询等模块。
This system divided into 5 modules: user management, basic information management, in-storage and out - storage management, sale management and general query.
该系统主要有用户管理、采购管理、入库管理、销售管理、收付款查询和基本信息管理六个基本模块。
The main users of the system management, procurement management, storage management, sales management, payments, and basic information management inquiry six basic modules.
本系统的主要功能模块包括用户的登录和注册模块,收货管理模块,销售管理模块,发货管理模块,数据录入模块,记录查询模块。
The system function modules include user login and registration module, Receiving management module, sales management module, management module of shipments, data entry module and inquiry module.
本系统的主要功能模块包括用户的登录和注册模块,收货管理模块,销售管理模块,发货管理模块,数据录入模块,记录查询模块。
The system function modules include user login and registration module, Receiving management module, sales management module, management module of shipments, data entry module and inquiry module.
应用推荐