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

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

文件下载

资源详情

[{"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,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明