<html>
<head>
<title>仓库管理系统说明</title>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb_2312-80">
<meta NAME="GENERATOR" CONTENT="Microsoft FrontPage 3.0">
<link rel="stylesheet" type="text/css" href="forum.css">
</head>
<body topmargin="0">
<b>
<p ALIGN="CENTER"><a name="top"></a><br>
<big><big>仓库管理系统说明</big></big></p>
</b>
<p ALIGN="CENTER">[ <a href="#序言">序言</a> | <a href="#库结构说明">库结构说明</a>
| <a href="#模块及操作说明">模块操作说明</a> | <a href="#权限说明">权限说明</a>
| <a href="#报表说明">报表说明</a> | <a href="" onclick=history.go(-1)>返回</a> ]</p>
<p ALIGN="JUSTIFY"><b><a name="序言">序言</a>:<br>
</b>计算机信息管理系统越来越受到企业重视。库存管理系统是一个企事业单位不可缺少的一部分,它的内容对于企业的决策者和管理者来说都是至关重要的,因此,库存管理系统应该能够为用户提供充足的信息和快捷的查询手段。特别是随着企业规模的不断扩大,产品数量的急剧增加,所生产产品的种类也会不断地更新,有关产品的各种信息量也会成倍增长。面对庞大的产品信息量,如何有效地管理库存产品,及时反馈库存管理的相关信息,是确保企业正常运行的必要手段,也是企业物流管理中不可或缺的一部分。<br>
作为计算机应用的一部分,使用计算机对产品库存信息进行管理,具有人工管理无法比拟的优点,因此,开发一个库存管理系统是很有必要的,具有其特有的技术意义和管理意义!<b></p>
</b>
<p ALIGN="right">lxl 于 2007年6月5日下午</p>
<p ALIGN="RIGHT">[ <a href="#top">TOP</a> ] </p>
<b>
<p ALIGN="JUSTIFY"><a name="库结构说明">库结构说明</a>:</p>
</b>
<p ALIGN="JUSTIFY">目前整个数据库data.mdb中共有8个表,按拼音顺序分别介绍如下:</p>
<p ALIGN="JUSTIFY"><strong>Detail<br>
</strong>此表为一个明细表,记录着所有各个仓库的入库、出库的记录</p>
<table BORDER="1" CELLSPACING="0" CELLPADDING="7" WIDTH="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF">
<tr>
<td WIDTH="16%" VALIGN="MIDDLE" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">字段名称</font></td>
<td WIDTH="13%" VALIGN="MIDDLE" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">数据类型</font></td>
<td WIDTH="71%" VALIGN="MIDDLE" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">说明</font></td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">自动编号</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">编号,用来区别每一个记录</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">rq</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">日期/时间</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">记录日期,即记录哪天发生的入库、出库日期</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">zl</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">种类</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">hs</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">号数</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">zy</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">摘要,描述入库、出库等的说明</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">in_num</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">收入数量,入库的物品数量</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">in_price</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">收入单价,入库的物品单价</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">in_sum</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">收入金额,入库的物品金额(数量*单价)</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">out_num</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">发出数量,出库的物品数量</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">out_price</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">发出单价,出库的物品单价</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">out_sum</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">发出金额,出库的物品金额(数量*单价)</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">now_num</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">结存数量,此时结余的物品数量</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">now_price</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">结存单价,此时结余的物品单价</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">now_sum</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">结存金额,此时结余的物品金额(数量*单价)</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">name_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">品名编号,用来识别此记录应该归属哪个物品</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">Storage_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">仓库编号,用来识别此记录应该归除哪个仓库</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">Provider_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">供应商编号,用来识别此记录在入库时由哪个供应商提供</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">uses_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">接应者(用户)编号,用来识别此记录出库时用于哪个地方</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">left_num</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">剩余数量,用来计算某天入库的数量在此刻还有多少剩余</td>
</tr>
<tr>
<td WIDTH="16%" VALIGN="TOP"><p ALIGN="JUSTIFY">jz_log</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">记帐记录标志,用来标记最后一个操作</td>
</tr>
</table>
<p ALIGN="RIGHT">[ <a href="#top">TOP</a> ] </p>
<p ALIGN="JUSTIFY"><strong>Provider<br>
</strong>此表记录所有供应商的信息,在此只提供一个名称,以后可以扩展其他信息。</p>
<table BORDER="1" CELLSPACING="0" CELLPADDING="7" WIDTH="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF">
<tr>
<td WIDTH="17%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">字段名称</font></td>
<td WIDTH="13%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">数据类型</font></td>
<td WIDTH="71%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">说明</font></td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">provider_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">自动编号</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">供应商编号,使供应商唯一性</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">provider_name</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="7
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
本系统采用B/S结构,使用ASP程序设计语言及Access数据库进行设计与开发;主要分析了库存管理系统的一些基本功能和组成情况,包括系统的需求分析、系统结构、功能模块划分以及数据库模式分析等;重点对应用程序的实际开发及实现作了较详细的介绍;主要实现了以下功能:库存管理(入库、出库的登记与修改;查询、浏览库存等)、报表的生成与打印、用户的管理等功能。
资源推荐
资源详情
资源评论
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![txt](https://img-home.csdnimg.cn/images/20210720083642.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/JPG.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/JPG.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/JPG.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/ZIP.png)
共 45 条
- 1
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/default.jpg!1)
python资深爱好者
- 粉丝: 468
- 资源: 165
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)