物资信息管理系统所有报告

? 查看物资余额信息

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