软件分前台收银和收台管理两大部分:







前台可对不同会员卡产生不同的折扣率,前台涉及三张数据库表的操作:



商品表—用来查找相应的商品信息



销售表—用来记录每次销售的商品信息



库存表.—每次销售的商品要从库存中减去相应的商品数量







后台涉及商品的查询及管理,主要功能有:



商品分类查询及单个商品的查询



商品销售统计,可根据不同的时间段,不同的商品编码,进行相应的统计



商品进/出货



商品出/入库



商品采购



商品付款单



新增商品---------用于录入超市原来没有的商品



会员卡的增,删,改,查



会员记录表中我只写了三条记录,详细信息看数据库表

-The software sub-front cash register and acquire Taiwan managed two major parts:



　



Front may be on different membership cards have different discount rates, future operations involving three database tables:



Product Table- used to find the corresponding commodity information



Sales Table- used to record information on each sale of goods



Stock Chart .- for each stock of goods sold is subtracted from the corresponding number of commodities



　



Background inquiries and management involved in the commodities, the main features are:



Category inquiries and queries for individual commodities



Merchandise sales statistics, according to different time periods, different commodity code and make the appropriate statistical



Goods Import/Shipping



Goods in/out storage



Merchandizing



Commodity payment orders



New Product--------- for the entry of goods to the supermarket is not the original



Membership card of the increase, delete, change, check