发布时间 : 星期二 文章物资信息管理系统所有报告更新完毕开始阅读84ac411455270722192ef7a8
? 查看物资余额信息
CREATE PROCEDURE [yelist] AS SELECT *
FROM [dbo].[余额详单] GO
? 查询某个物资的余额信息
CREATE PROCEDURE [yelookup] (@id [bigint])
AS
SELECT *
FROM [dbo].[余额详单] WHERE
( [物资编号] = @id) GO
? 查看入库记录
CREATE PROCEDURE [outlist] AS SELECT *
FROM [dbo].[出库记录] GO
? 查看出库记录
CREATE PROCEDURE [inlist] AS SELECT *
FROM [dbo].[入库记录] GO
? 查看存放规则信息
CREATE PROCEDURE [gzlist] AS
SELECT [dbo].[物资基本信息].[物资编号], [dbo].[物资基本信息].[物资名称],
[dbo].[物资基本信息].[规格型号], [dbo].[物资基本信息].[计量单位],
[dbo].[物资基本信息].[最大库存量], [dbo].[物资基本信息].[最小库存量] FROM [dbo].[物资基本信息] GO
? 修改存放规则
CREATE PROCEDURE [gzmodify] (@ID [int], @MAX [int],
@MIN [int])
AS UPDATE [物资管理].[dbo].[物资基本信息] SET [最大库存量] = @MAX, [最小库存量] = @MIN WHERE ( [物资编号] = @ID) GO
? 添加仓库信息
CREATE PROCEDURE [ckadd]
(@WID [int],
@WName [varchar](20), @WArea [float],
@WAddress [varchar](50))
AS INSERT INTO [物资管理].[dbo].[仓库]
([仓库号], [名称], [面积], [地址]) ( @WID, @WName, @WArea, @WAddress)
VALUES
GO
? 删除仓库信息
CREATE PROCEDURE [ckdelete] (@WID [int])
AS delete [物资管理].[dbo].[仓库] WHERE ( [仓库号] GO
? 查询仓库信息
CREATE PROCEDURE [ckList] AS SELECT [dbo].[仓库].[仓库号],
[dbo].[仓库].[名称], [dbo].[仓库].[面积],
= @WID)
[dbo].[仓库].[地址] FROM [dbo].[仓库]
GO
? 修改仓库信息
CREATE PROCEDURE [ckmodify]
(@WID [int],
@WName [varchar](20),
@WArea [int], @WAddress [varchar](50)) AS UPDATE [物资管理].[dbo].[仓库] SET [名称] = @WName,
[面积] = @WArea, [地址] = @WAddress
= @WID)
WHERE ( [仓库号] GO
4.1.3视图
? 余额详单
create view 余额详单
as
select a.物资编号,a.物资名称,a.规格型号, b.名称,c.库存量 from 物资基本信息 a,仓库 b,库存 c
where a.物资编号=c.物资编号 and b.仓库号=c.仓库号 ? 需求详单
CREATE view 需求详单
as
select a.物资编号,a.物资名称,a.规格型号,a.计量单位,a.单价,(a.最大库存量-a.最小库存量)/2-b.库存量 as 需求数量,(1-(b.库存量-a.最小库存量)/(a.最大库存量-a.最小库存量)*1.0)*100.0 as 紧急度
from 物资基本信息 a,库存 b
where a.物资编号=b.物资编号 and b.库存量<(a.最大库存量-a.最小库存量)/2
4.2安全保密设计
在管理员的信息中，设置了权限标志。不同的访问级别对应不同的的访问内容。具体由应用程序物资管理系统进行控制。
详细设计
1．引言 ......................................................................................................................... 37
1.1编写目的 .......................................................................................................... 37 1.2项目背景 .......................................................................................................... 37 1.3定义 ................................................................................................................. 37 1.4参考资料 .......................................................................................................... 37 2．总体设计 .................................................................................................................. 38
2.1需求概述 .......................................................................................................... 38 2.2实现功能 .......................................................................................................... 38 3．主要界面设计 ........................................................................................................... 39
3.1物资管理系统首页 ............................................................................................ 39
3.2物资信息维护页面 ............................................................................................ 39 3.3添加物资基本信息页面 ..................................................................................... 40 3.4仓库信息维护页面 ............................................................................................ 40 3.5物资信息修改页面 ............................................................................................ 40 3.6存放规则维护页面 ............................................................................................ 41 3.7修改密码页面 ................................................................................................... 41 3.8人员信息维护页面 ............................................................................................ 42 3.9修改员工信息页面 ............................................................................................ 42 3.10余额查询页面.................................................................................................. 43 3.11添加仓库信息页面........................................................................................... 43 3.12添加员工信息页面........................................................................................... 44 3.13物资进出记录页面........................................................................................... 44 4．功能模块设计与代码实现分析 ................................................................................... 45
4.1物资管理系统首页 ............................................................................................ 45 4.2物资信息维护页面 ............................................................................................ 46 4.3添加物资基本信息页面 ..................................................................................... 47 4.4仓库信息维护页面 ............................................................................................ 48 4.5物资信息修改页面 ............................................................................................ 50 4.6存放规则维护页面 ............................................................................................ 52 4.7修改密码页面 ................................................................................................... 54 4.8人员信息维护页面 ............................................................................................ 55 4.9修改员工信息页面 ............................................................................................ 55 4.10余额查询页面.................................................................................................. 57 4.11添加仓库信息页面........................................................................................... 58 4.12添加员工信息页面........................................................................................... 59 4.13物资进出记录页面........................................................................................... 60