采用sql编写的小型超市零售管理系统设计说明书

上传者: mei5051766 | 上传时间: 2019-12-28 17:22:38 | 文件大小: 679KB | 文件类型: rar
小型超市零售管理系统 1、 系统功能的基本要求: 前台POS销售系统(基本功能): 1. 商品录入:根据超巿业务特点制定相关功能,可以通过输入唯一编号、扫描条形码、商品名称等来实现精确或模糊的商品扫描录入。该扫描录入方法可以充分保证各种电脑操作水平层次的人员均能准确快速地进行商品扫描录入。 2. 收银业务:通过扫描条形码或者直接输入商品名称(对于同类多件商品采用一次录入加数量的方式)自动计算本次交易的总金额。在顾客付款后,自动计算找零,同时打印交易清单(包括交易的流水账号、每类商品的商品名、数量、该类商品的总金额、交易的时间、负责本次收银的员工号)。如果顾客是本店会员并持有本人会员卡,则在交易前先扫描会员卡,并对所购物品全部实行95折优惠,并将所购物品的总金额累计到该会员的总消费金额中。 会员卡的有效期限为一年,满一年未续卡者,该会员卡将被注销。 3. 安全性。POS登陆、退出、换班与操作锁定等权限验证保护;断电自动保护最大限度防止意外及恶意非法操作。 4. 独立作业。特有的断网收银即在网络服务器断开或网络不通的情况下,收银机仍能正常作业。 ● 后台管理系统(基本功能): 1. 进货管理: 根据销售情况及库存情况,自动制定进货计划(亦可手工制定修改),可以避免盲目进货造成商品积压。 按计划单有选择性地进行自动入库登记。 综合查询打印计划进货与入库记录及金额。 2. 销售管理: 商品正常销售、促销与限量、限期及禁止销售控制。 综合查询各种销售明细记录、各地收银员收银记录以及交结账情况等。 按多种方式统计生成销售排行榜,灵活察看和打印商品销售日、月、年报表。 3. 库存管理: 综合查询库存明细记录。 库存状态自动告警提示。如库存过剩、少货、缺货等。软件为您预警,避免库存商品积压损失和缺货。 库存自动盘点计算。 4. 人员管理: 员工、会员、供货商、厂商等基本信息登记管理。 员工操作权限管理。 客户销售权限管理。

文件下载

资源详情

( 142 个子文件 679KB ) 采用sql编写的小型超市零售管理系统设计说明书
modMD5.bas 13.78KB
modMD5.bas 13.78KB
modSQL.bas 1.72KB
modMain.bas 1.55KB
modLvTimer.bas 616B
Module1.bas 366B
link.bas 233B
modSQL.bas 30B
注册.bat 19B
登陆.bmp 1.30KB
XPButton.ctl 116.15KB
FTextBox.ctl 15.97KB
XButton.ctl 15.74KB
FatCombo.ctl 11.40KB
XPButton.ctx 786B
FatCombo.ctx 118B
drPlanStock.DCA 47.72KB
drSale.DCA 47.65KB
DataReport1.DCA 45.61KB
DataEn1.DCA 4.45KB
需求说明书.doc 282.50KB
详细设计5.doc 54.00KB
详细设计1.doc 45.50KB
详细设计4.doc 44.00KB
详细设计3.doc 43.00KB
详细设计2.doc 40.50KB
详细设计(总).doc 36.00KB
★题目和要求.doc 31.00KB
drPlanStock.Dsr 14.31KB
drSale.Dsr 13.11KB
DataReport1.Dsr 9.16KB
DataEn1.Dsr 4.81KB
drPlanStock.dsx 23B
drSale.dsx 23B
数据新建.exe 10.00KB
XPMenu.exp 975B
frmMerch.frm 40.29KB
frmSale.frm 30.73KB
frmMain.frm 29.69KB
frmStock.frm 25.47KB
frmMember.frm 21.93KB
frmMerchItem.frm 21.71KB
frmFP.frm 20.73KB
frmUser.frm 19.74KB
frmPlanStock.frm 9.47KB
Form8.frm 9.28KB
frmToStock.frm 8.73KB
frmLogin.frm 8.34KB
frmServer.frm 8.15KB
pay.frm 7.43KB
quickinput.frm 7.16KB
frmMain.frm 6.16KB
Frmlog.frm 5.04KB
frmWelcome.frm 1.10KB
FrmFront.frm 449B
frmWelcome.frx 389.14KB
frmLogin.frx 70.41KB
frmMain.frx 37.26KB
frmMerch.frx 9.21KB
frmUser.frx 6.99KB
frmFP.frx 4.61KB
frmStock.frx 4.21KB
frmMember.frx 2.81KB
frmPlanStock.frx 1.41KB
frmSale.frx 12B
frmServer.frx 12B
frmToStock.frx 12B
frmMerchItem.frx 12B
frmMain.frx 12B
程序图标.ico 3.55KB
销售管理.ico 3.19KB
进货管理.ico 3.19KB
会员管理.ico 3.19KB
用户管理.ico 3.19KB
厂商,供应商.ico 3.19KB
库存管理.ico 3.19KB
大程序图标.ico 2.19KB
ak.ico 1.84KB
登陆.ico 1.37KB
入库.ico 1.37KB
下一记录.ico 1.37KB
销售.ico 1.37KB
用户1.ico 1.37KB
用户2.ico 1.37KB
用户.ico 1.37KB
首记录.ico 1.37KB
进货.ico 1.37KB
会员2.ico 1.37KB
上一记录.ico 1.37KB
会员1.ico 1.37KB
1.ico 1.37KB
退出程序.ico 1.37KB
供货商.ico 1.37KB
尾记录.ico 1.37KB
厂商.ico 1.37KB
pp.ico 1.37KB
关于.ico 1.37KB
退出.ico 1.37KB
point1.ico 894B
point3.ico 894B
......
文件过多,未全部展示
[{"title":"( 142 个子文件 679KB ) 采用sql编写的小型超市零售管理系统设计说明书","children":[{"title":"modMD5.bas <span style='color:#111;'> 13.78KB </span>","children":null,"spread":false},{"title":"modMD5.bas <span style='color:#111;'> 13.78KB </span>","children":null,"spread":false},{"title":"modSQL.bas <span style='color:#111;'> 1.72KB </span>","children":null,"spread":false},{"title":"modMain.bas <span style='color:#111;'> 1.55KB </span>","children":null,"spread":false},{"title":"modLvTimer.bas <span style='color:#111;'> 616B </span>","children":null,"spread":false},{"title":"Module1.bas <span style='color:#111;'> 366B </span>","children":null,"spread":false},{"title":"link.bas <span style='color:#111;'> 233B </span>","children":null,"spread":false},{"title":"modSQL.bas <span style='color:#111;'> 30B </span>","children":null,"spread":false},{"title":"注册.bat <span style='color:#111;'> 19B </span>","children":null,"spread":false},{"title":"登陆.bmp <span style='color:#111;'> 1.30KB </span>","children":null,"spread":false},{"title":"XPButton.ctl <span style='color:#111;'> 116.15KB </span>","children":null,"spread":false},{"title":"FTextBox.ctl <span style='color:#111;'> 15.97KB </span>","children":null,"spread":false},{"title":"XButton.ctl <span style='color:#111;'> 15.74KB </span>","children":null,"spread":false},{"title":"FatCombo.ctl <span style='color:#111;'> 11.40KB </span>","children":null,"spread":false},{"title":"XPButton.ctx <span style='color:#111;'> 786B </span>","children":null,"spread":false},{"title":"FatCombo.ctx <span style='color:#111;'> 118B </span>","children":null,"spread":false},{"title":"drPlanStock.DCA <span style='color:#111;'> 47.72KB </span>","children":null,"spread":false},{"title":"drSale.DCA <span style='color:#111;'> 47.65KB </span>","children":null,"spread":false},{"title":"DataReport1.DCA <span style='color:#111;'> 45.61KB </span>","children":null,"spread":false},{"title":"DataEn1.DCA <span style='color:#111;'> 4.45KB </span>","children":null,"spread":false},{"title":"需求说明书.doc <span style='color:#111;'> 282.50KB </span>","children":null,"spread":false},{"title":"详细设计5.doc <span style='color:#111;'> 54.00KB </span>","children":null,"spread":false},{"title":"详细设计1.doc <span style='color:#111;'> 45.50KB </span>","children":null,"spread":false},{"title":"详细设计4.doc <span style='color:#111;'> 44.00KB </span>","children":null,"spread":false},{"title":"详细设计3.doc <span style='color:#111;'> 43.00KB </span>","children":null,"spread":false},{"title":"详细设计2.doc <span style='color:#111;'> 40.50KB </span>","children":null,"spread":false},{"title":"详细设计(总).doc <span style='color:#111;'> 36.00KB </span>","children":null,"spread":false},{"title":"★题目和要求.doc <span style='color:#111;'> 31.00KB </span>","children":null,"spread":false},{"title":"drPlanStock.Dsr <span style='color:#111;'> 14.31KB </span>","children":null,"spread":false},{"title":"drSale.Dsr <span style='color:#111;'> 13.11KB </span>","children":null,"spread":false},{"title":"DataReport1.Dsr <span style='color:#111;'> 9.16KB </span>","children":null,"spread":false},{"title":"DataEn1.Dsr <span style='color:#111;'> 4.81KB </span>","children":null,"spread":false},{"title":"drPlanStock.dsx <span style='color:#111;'> 23B </span>","children":null,"spread":false},{"title":"drSale.dsx <span style='color:#111;'> 23B </span>","children":null,"spread":false},{"title":"数据新建.exe <span style='color:#111;'> 10.00KB </span>","children":null,"spread":false},{"title":"XPMenu.exp <span style='color:#111;'> 975B </span>","children":null,"spread":false},{"title":"frmMerch.frm <span style='color:#111;'> 40.29KB </span>","children":null,"spread":false},{"title":"frmSale.frm <span style='color:#111;'> 30.73KB </span>","children":null,"spread":false},{"title":"frmMain.frm <span style='color:#111;'> 29.69KB </span>","children":null,"spread":false},{"title":"frmStock.frm <span style='color:#111;'> 25.47KB </span>","children":null,"spread":false},{"title":"frmMember.frm <span style='color:#111;'> 21.93KB </span>","children":null,"spread":false},{"title":"frmMerchItem.frm <span style='color:#111;'> 21.71KB </span>","children":null,"spread":false},{"title":"frmFP.frm <span style='color:#111;'> 20.73KB </span>","children":null,"spread":false},{"title":"frmUser.frm <span style='color:#111;'> 19.74KB </span>","children":null,"spread":false},{"title":"frmPlanStock.frm <span style='color:#111;'> 9.47KB </span>","children":null,"spread":false},{"title":"Form8.frm <span style='color:#111;'> 9.28KB </span>","children":null,"spread":false},{"title":"frmToStock.frm <span style='color:#111;'> 8.73KB </span>","children":null,"spread":false},{"title":"frmLogin.frm <span style='color:#111;'> 8.34KB </span>","children":null,"spread":false},{"title":"frmServer.frm <span style='color:#111;'> 8.15KB </span>","children":null,"spread":false},{"title":"pay.frm <span style='color:#111;'> 7.43KB </span>","children":null,"spread":false},{"title":"quickinput.frm <span style='color:#111;'> 7.16KB </span>","children":null,"spread":false},{"title":"frmMain.frm <span style='color:#111;'> 6.16KB </span>","children":null,"spread":false},{"title":"Frmlog.frm <span style='color:#111;'> 5.04KB </span>","children":null,"spread":false},{"title":"frmWelcome.frm <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false},{"title":"FrmFront.frm <span style='color:#111;'> 449B </span>","children":null,"spread":false},{"title":"frmWelcome.frx <span style='color:#111;'> 389.14KB </span>","children":null,"spread":false},{"title":"frmLogin.frx <span style='color:#111;'> 70.41KB </span>","children":null,"spread":false},{"title":"frmMain.frx <span style='color:#111;'> 37.26KB </span>","children":null,"spread":false},{"title":"frmMerch.frx <span style='color:#111;'> 9.21KB </span>","children":null,"spread":false},{"title":"frmUser.frx <span style='color:#111;'> 6.99KB </span>","children":null,"spread":false},{"title":"frmFP.frx <span style='color:#111;'> 4.61KB </span>","children":null,"spread":false},{"title":"frmStock.frx <span style='color:#111;'> 4.21KB </span>","children":null,"spread":false},{"title":"frmMember.frx <span style='color:#111;'> 2.81KB </span>","children":null,"spread":false},{"title":"frmPlanStock.frx <span style='color:#111;'> 1.41KB </span>","children":null,"spread":false},{"title":"frmSale.frx <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"frmServer.frx <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"frmToStock.frx <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"frmMerchItem.frx <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"frmMain.frx <span style='color:#111;'> 12B </span>","children":null,"spread":false},{"title":"程序图标.ico <span style='color:#111;'> 3.55KB </span>","children":null,"spread":false},{"title":"销售管理.ico <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"进货管理.ico <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"会员管理.ico <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"用户管理.ico <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"厂商,供应商.ico <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"库存管理.ico <span style='color:#111;'> 3.19KB </span>","children":null,"spread":false},{"title":"大程序图标.ico <span style='color:#111;'> 2.19KB </span>","children":null,"spread":false},{"title":"ak.ico <span style='color:#111;'> 1.84KB </span>","children":null,"spread":false},{"title":"登陆.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"入库.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"下一记录.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"销售.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"用户1.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"用户2.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"用户.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"首记录.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"进货.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"会员2.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"上一记录.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"会员1.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"1.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"退出程序.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"供货商.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"尾记录.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"厂商.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"pp.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"关于.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"退出.ico <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"point1.ico <span style='color:#111;'> 894B </span>","children":null,"spread":false},{"title":"point3.ico <span style='color:#111;'> 894B </span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":"<span style='color:steelblue;'>文件过多,未全部展示</span>","children":null,"spread":false}],"spread":true}]

评论信息

  • f1ower_ :
    连接不了SQL
    2013-06-16
  • 回到未来v :
    内容详细,可以参考其中的设计
    2013-06-15
  • zxj13579yeahnet :
    做的比较详细,考虑也较为全面,具有一定的参考价值。
    2011-12-13

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
服务器状态检查中...