出入库管理系统设计文档软件学院数据库课程设计—进出库管理系统082软件学院数据库课程设计—进出库管理系统1、设计和实现库存管理系统2、撰写设计文档按照管理信息系统的原理和方法，采用成熟、先进的信息技术和手段，支持仓库进出库管理工作的全过程，保证仓库货品的有序正常的流通。

1、概念结构设计，绘出库存管理的E-R图。

2、逻辑结构设计，根据关系数据库设计原理，设计出库存管理的关系模型。

3、物理结构设计，给出库存管理数据库在SQL Server 2005中的定义。

4、数据库实现，在SQL Server 2005中建立库存管理数据库。

1：出入库信息操作、查询库存信息、产品分类管理、添加删除人员、查看系统事件。

：查询库内信息、修改本用户密码。

21、进、出库管理。

对进、出库信息进行记录。

2、查询功能。

仓库管理对查询要求高，通过主菜单记录当前操作用户的用户编号，保证了对进、出库信息录入负责人的确认。

3、库存管理，根据外界对库存的要求，企业订购的特点，预测，计划和执行一种补充库存的行为，并对这种行为进行控制，重点在于确定如何订货，订购多少，何时定货。

4、部门资料管理与库存报表生成软件学院数据库课程设计—进出库管理系统5、界面简单、易于操作根据系统的业务流程和用户的需求分析可以得出，本系统应该包含产品基本信息管理、入出库管理、库存管理、查询统计、系统日志管理几大功能， 1）基本信息管理：货品信息、供应商信息、客户信息、员工信息，分别实现相应信息添加、删除、查找、修改2）入库信息管理：入货信息录入3）出库信息管理：入货信息录入4）库存信息管理：查询库存信息5）查询统计：货品查询、供应商查询、客户查询、入库查询、出库查询、员工查询按日期：查询某个时间段的出入库信息按人员：供应商、客户、员工信息查询按物品：查询某种商品的出入库信息和余料打印报表6)系统日志信息管理：记录相应操作信息每个关系中都至少要有一个主键，关系与关系之间通过主外键关联。

定义属性上的约束条件，定义触发器。

当外界非正常因素导致系统关闭时可自动保存系统操作日志是不允许改动的对于非仓库管理员是不允许进行增、删、改相应的操作，只可查看相关信息记录合格订单总帐订单查看订单入库打印信息明细帐不合格订单（入库）查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查软件学院数据库课程设计—进出库管理系统（出库）查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查（功能模块图）E-R：1软件学院数据库课程设计—进出库管理系统员工编号姓名性别职位员工信息固定电话手机通讯地址邮政编码备注2) ：查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查3) ：类别编号类别名称计量单位货物类别4) ：查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查5) ：软件学院数据库课程设计—进出库管理系统查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查7供应商编供应商名供应商地联系人联系电话号称址供应商8客户编号客户名称联系人联系电话客户地址客户9仓库编号仓库名称联系人id仓库地址仓库信息10现有存储仓库编号货品编号最高限量最低限量量库存信息v 11) ：软件学院数据库课程设计—进出库管理系统查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查11查查查查查查查查查查N查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查M查查查查查查查查查N1MN查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查1查查查查查查查查查查查查查查查查查查查查查查查11查查查查查查查查查查查查查查查查查查查查NN查查查查查查查查查查查查查查查查查查查查查查查查11查查查查查查查查查查查查查查用户管理、员工信息、业务关系人员信息、银行账户信息、仓库信息、货物基本信息、货物类别、报损信息、调拨信息、货物入库信息、货物出库信息、库存总账信息、系统日志信息1.初始大增长大文件文件名称最大文件大小小小数据库不受限制 StockManagement_Data.mdf 3 2日志不受限制 StockManagement_Log.log 1 1 2.软件学院数据库课程设计—进出库管理系统Staff序属性名称属性描述数据类型空否默认值备注号1 Staff_id 员工编号 int 否主键2 Staff_name 姓名 varchar(50) 否3 Staff_sex 性别 bit4 Staff_Security 权限 Int 否5 Staff_tel 固定电话varchar(50)6 Staff_mobile 手机 varchar(50)7 Staff_address 通讯地址varchar(50)8 Staff_postalcode 邮政编码 varchar(50)9 Staff_remark 备注Varchar(100)Goods序空默认属性名称属性描述数据类型备注号否值 2 Goods_id 编号 int 否主键 3 Goods_name 名称 varchar(50) 否 4 Goods_type 规格型号varchar(50) 否Goods_ warranty 保修期 int 否Goods_sort_id 货品类别 int 否外键Goods_area 产地 varchar(50) 否Goods_Entry_price 入库单价 money 否Goods_Sale_price 销售单价 money 否Goods_Supplier_id 供应商 int 否Goods_remark 备注 Varchar(100)GoodsSort序默认属性名称属性描述数据类型空否备注号值 1 GoodsSort_id 类别编号 int 否主键 2 GoodsSort_name 名称 varchar(50) 否 3 GoodsSort_unit 计量单位 varchar(4) 否Instock序空默认属性名称属性描述数据类型备注号否值自动增长1 Instock_serial 入库序号 int 否（1，1） 3 Instock_Googs_id 货品编号 int 否主键软件学院数据库课程设计—进出库管理系统 4 Instock_amount 数量 int 否5 Instock_date 入库时间 smalldatatime 否经手人编 Instock_Staff_id int 否外键号入货单编 Instock_In_id int 否自动生成号Instock_stock_id 仓库id Int 否外键Instock_ExtraMoney 额外费用 moneyInstock_remark 备注 Varchar(50)Outstock序空默认属性名称属性描述数据类型备注号否值自动增长1 Outstock_serial 出库序号 int 否（1，1） 3Outstock_Goods_id 货品编号 int 否主键 4 Outstock_amouny 实发数量 int 否5 Outstock_Sale_price 实际售价 money 否Outstock_ 延保年限 int 否 Extend_warranty经手人编 Outstock_Staff_id int 否外键号出货单编 Outstock_Out_id int 否自动生成号Outstock_Stock_id 仓库编号 int 否外键Outstock_date 出库日期 smalldatatime 否Outstock_ExtraMoney 额外费用 moneyOutstock_remark 备注 Varchar(100)Supplier序默认属性名称属性描述数据类型空否备注号值 1 Supplier_id 供应商编号 int 否主键 2 Supplier_top 供应商名称 int 否 3 Supplier_name 联系人 varchar(50) 否 4 Supplier_tel 联系电话 varchar(50) 否Supplier_address 供应商地址 varchar(50) 否Customs软件学院数据库课程设计—进出库管理系统序默认属性名称属性描述数据类型空否备注号值 1 Customs_id 客户编号 int 否主键 2 Customs_top 客户名称 varchar(50) 否 3 Customs_name 联系人 varchar(50) 否 4 Customs_tel 联系电话 varchar(50) 否Customs_adddress 客户地址 varchar(50) 否Stock序属性名称属性描述数据类型空否默认值备注号1 Stock_id 仓库id int 否主键2 Stock_name 仓库名称 varchar(50) 否3 Stock_Staff_id 员工编号 int 否外键4 Stock_address 仓库地址 varchar(50) 否StockRemain序属性描空默认属性名称数据类型备注号述否值StockRemain_goods_id 货物id int 否主键StockRemain_stock_id 仓库id int 否外键最低限 StockRemain_Min_amount int 否量最高限 StockRemain_Max_amount int 否量现有库 StockRemain_amount int 否存量SystemLog序属性描空默认属性名称数据类型备注号述否值主键操作序1 SystemLog_Serial int 否自动增长（1，号 1）操作人2 SystemLog_Staff_id int 否外键编号操作内3 SystemLog _matter varchar(100) 否容软件学院数据库课程设计—进出库管理系统操作时4 SystemLog _date smalldatatime 否间create database StockManagementon primary(name=StockManagement_mdf,filename='D:\StockManagement_mdf.mdf', size=3MB, maxsize=unlimited,filegrowth=3%)log on(name=StockManagement_log,filename='D:\StockManagement_log.log', size=1MB, maxsize=unlimited,filegrowth=3%)gouse StockManagementgocreate table staff --员工基本信息 (staff_id int not null primary key, staff_name varchar(50) not null, staff_password varchar(50) not null, staff_security int not null, staff_sex bit,staff_tel varchar(50),staff_mobile varchar(50),staff_address varchar(50),staff_remark varchar(100))use StockManagementgocreate table goods --货物基本信息软件学院数据库课程设计—进出库管理系统(goods_id int not null primary key, goods_name varchar(50) not null, goods_type varchar(50) not null, goods_warranty int not null, goods_sort_id int not null,goods_supplier_id int not null,goods_remark varchar(100))use StockManagementgocreate table goodsSort --货物种类信息 (goodsSort_id int not null primary key, goodsSort_name varchar(50)not null, goodsSort_unit varchar(50) not null, )use StockManagementgocreate table inStock --入库信息 (inStock_serial int identity(1,1) not null, inStock_goods_id int not null primary key,inStock_amount int not null,inStock_in_price money not null, inStock_date smalldatetime not null, inStock_staff_id int not null,inStock_in_id int not null,inStock_stock_id int not null,inStock_extraMoney money,inStock_remark varchar(100))use StockManagementgocreate table outStock --出库信息 (outStock_serial int identity(1,1) not null, outStock_goods_id intnot null primary key,outStock_amount int not null,outStock_sale_price money not null,软件学院数据库课程设计—进出库管理系统outStock_extend_warranty int not null, outStock_staff_id int notnull, outStock_out_id int not null,outStock_stock_id int not null, outStock_date smalldatetime not null, outStock_extraMoney money ,outStock_remark varchar(100) )gouse StockManagementgocreate table supplier --供应商信息 (supplier_id int not null primary key, supplier_top varchar(50) not null, supplier_name varchar(50) not null, supplier_tel varchar(50) not null, supplier_address varchar(50) not null )gouse StockManagementgocreate table customs --客户信息 (customs_id int not null primary key, customs_top varchar(50) notnull, customs_name varchar(50) not null, customs_tel varchar(50) not null, customs_address varchar(50) not null )gouse StockManagementgocreate table stock --仓库信息 (stock_id int not null primary key, stock_name varchar(50) not null, stock_staff_id int not null,stock_address varchar(50) not null)use StockManagement软件学院数据库课程设计—进出库管理系统gocreate table stockRemain --库存信息 (stockRemain_goods_id int not null primary key,stockRemain_min_amount int not null, stockRemain_max_amount int not null, stockRemain_amount int not null)gouse StockManagementgocreate table systemLog --系统日志信息 (systemLog_serial int identity(1,1) not null primary key,systemLog_staff_id int not null,systemLog_matter varchar(100) not null, systemLog_date smalldatetime not null)--查看日志信息use StockManagement软件学院数据库课程设计—进出库管理系统gocreate view selectSysLogasselect * from systemLog*/****************************************************************** * 表名：staff******************************************************************/ --------------------------------------用途：是否已经存在该员工 ------------------------------------ CREATE PROCEDURE staff_Exists@staff_id intASDECLARE @TempID intSELECT @TempID = count(1) FROM staff WHERE staff_id=@staff_idIF @TempID = 0RETURN 0ELSERETURN 1GO--------------------------------------用途：增加一条员工记录 ------------------------------------ CREATE PROCEDURE staff_ADD@staff_id int,@staff_name varchar(50), @staff_password varchar(50),@staff_security int,@staff_sex bit,@staff_tel varchar(50), @staff_mobile varchar(50), @staff_address varchar(50), @staff_remark varchar(100)ASINSERT INTO staff(staff_id,staff_name,staff_password,staff_security,staff_sex,staff 软件学院数据库课程设计—进出库管理系统_tel,staff_mobile,staff_address,staff_remark)VALUES(@staff_id,@staff_name,@staff_password,@staff_security,@staff_sex, @staff_tel,@staff_mobile,@staff_address,@staff_remark)GO--------------------------------------用途：修改一条员工记录------------------------------------CREATE PROCEDURE staff_Update@staff_id int,@staff_name varchar(50),@staff_password varchar(50),@staff_security int,@staff_sex bit,@staff_tel varchar(50),@staff_mobile varchar(50),@staff_address varchar(50),@staff_remark varchar(100)ASUPDATE staff SETstaff_name = @staff_name,staff_password =@staff_password,staff_security = @staff_security,staff_sex = @staff_sex,staff_tel = @staff_tel,staff_mobile =@staff_mobile,staff_address = @staff_address,staff_remark = @staff_remarkWHERE staff_id=@staff_idGO--------------------------------------用途：删除一条员工记录------------------------------------CREATE PROCEDURE staff_Delete@staff_id intASDELETE [staff]WHERE staff_id=@staff_idGO软件学院数据库课程设计—进出库管理系统--------------------------------------用途：根据员工ID得到员工详细信息 ------------------------------------CREATE PROCEDURE staff_GetModel@staff_id intASSELECTstaff_id,staff_name,staff_password,staff_security,staff_sex,staff _tel,staff_mobile,staff_address,staff_remarkFROM staffWHERE staff_id=@staff_idGO--------------------------------------用途：查询所有记录信息------------------------------------CREATE PROCEDURE staff_GetListASSELECTstaff_id,staff_name,staff_password,staff_security,staff_sex,staff_tel,staff_mobile,staff_address,staff_remarkFROM staffGO/****************************************************************** * 表名：stock******************************************************************/ --------------------------------------用途：是否已经存在该仓库记录 ------------------------------------ CREATE PROCEDURE stock_Exists@stock_id intASDECLARE @TempID intSELECT @TempID = count(1) FROM stock WHERE stock_id=@stock_idIF @TempID = 0RETURN 0ELSERETURN 1软件学院数据库课程设计—进出库管理系统GO--------------------------------------用途：增加一条仓库记录 ------------------------------------CREATE PROCEDURE stock_ADD@stock_id int,@stock_name varchar(50), @stock_staff_id int,@stock_address varchar(50)ASINSERT INTO stock(stock_id,stock_name,stock_staff_id,stock_address)VALUES(@stock_id,@stock_name,@stock_staff_id,@stock_address)GO--------------------------------------用途：更新一条仓库记录 ------------------------------------ CREATE PROCEDURE stock_Update@stock_id int,@stock_name varchar(50), @stock_staff_id int,@stock_address varchar(50)ASUPDATE stock SETstock_name = @stock_name,stock_staff_id =@stock_staff_id,stock_address = @stock_addressWHERE stock_id=@stock_idGO--------------------------------------用途：删除一条仓库记录 ------------------------------------CREATE PROCEDURE stock_Delete@stock_id intASDELETE stock软件学院数据库课程设计—进出库管理系统WHERE stock_id=@stock_idGO--------------------------------------用途：根据仓库Id得到仓库详细信息 ------------------------------------CREATE PROCEDURE stock_GetModel@stock_id intASSELECTstock_id,stock_name,stock_staff_id,stock_addressFROM stockWHERE stock_id=@stock_idGO--------------------------------------用途：查询所有仓库记录信息 ------------------------------------ CREATE PROCEDURE stock_GetListASSELECTstock_id,stock_name,stock_staff_id,stock_addressFROM stockGO/****************************************************************** * 表名：stockRemain******************************************************************/ --------------------------------------用途：根据货物id得到库存详细信息 ------------------------------------CREATE PROCEDURE stockRemain_GetModel@stockRemain_goods_id intASSELECTstockRemain_goods_id,stockRemain_min_amount,stockRemain_max_amoun t,stockRemain_amount软件学院数据库课程设计—进出库管理系统FROM stockRemainWHERE stockRemain_goods_id=@stockRemain_goods_idGO--------------------------------------用途：查询所有库存记录信息 ------------------------------------ CREATE PROCEDURE stockRemain_GetListASSELECTstockRemain_goods_id,stockRemain_min_amount,stockRemain_max_amount,stockRemain_amountFROM stockRemainGO/****************************************************************** * 表名：supplier******************************************************************/ --------------------------------------用途：是否已经存在该供应商 ------------------------------------ CREATE PROCEDURE supplier_Exists@supplier_id intASDECLARE @TempID intSELECT @TempID = count(1) FROM supplier WHEREsupplier_id=@supplier_idIF @TempID = 0RETURN 0ELSERETURN 1GO--------------------------------------用途：增加一条供应商记录 ------------------------------------ CREATE PROCEDURE supplier_ADD@supplier_id int,@supplier_top varchar(50),软件学院数据库课程设计—进出库管理系统@supplier_name varchar(50), @supplier_tel varchar(50),@supplier_address varchar(50)ASINSERT INTO supplier(supplier_id,supplier_top,supplier_name,supplier_tel,supplier_addr ess)VALUES(@supplier_id,@supplier_top,@supplier_name,@supplier_tel,@supplier _address)GO--------------------------------------用途：更新一条供应商记录------------------------------------CREATE PROCEDURE supplier_Update@supplier_id int,@supplier_top varchar(50), @supplier_name varchar(50), @supplier_tel varchar(50), @supplier_address varchar(50)ASUPDATE supplier SETsupplier_top = @supplier_top,supplier_name =@supplier_name,supplier_tel = @supplier_tel,supplier_address =@supplier_addressWHERE supplier_id=@supplier_idGO--------------------------------------用途：删除一条供应商记录------------------------------------CREATE PROCEDURE supplier_Delete@supplier_id intASDELETE supplierWHERE supplier_id=@supplier_id软件学院数据库课程设计—进出库管理系统GO--------------------------------------用途：根据供应商ID得到供应商详细信息------------------------------------CREATE PROCEDURE supplier_GetModel@supplier_id intASSELECTsupplier_id,supplier_top,supplier_name,supplier_tel,supplier_addr essFROM supplierWHERE supplier_id=@supplier_idGO--------------------------------------用途：查询所有供应商记录信息 ------------------------------------ CREATE PROCEDURE supplier_GetListASSELECTsupplier_id,supplier_top,supplier_name,supplier_tel,supplier_addr essFROM supplierGO/****************************************************************** * 表名：customs******************************************************************/ --------------------------------------用途：是否已经存在该客户 ------------------------------------ CREATE PROCEDURE customs_Exists@customs_id intASDECLARE @TempID intSELECT @TempID = count(1) FROM customs WHERE customs_id=@customs_id IF @TempID = 0RETURN 0ELSE软件学院数据库课程设计—进出库管理系统RETURN 1GO--------------------------------------用途：增加一条客户记录------------------------------------CREATE PROCEDURE customs_ADD@customs_id int,@customs_top varchar(50), @customs_name varchar(50), @customs_tel varchar(50), @customs_address varchar(50)ASINSERT INTO customs(customs_id,customs_top,customs_name,customs_tel,customs_address )VALUES(@customs_id,@customs_top,@customs_name,@customs_tel,@customs_addr ess)GO--------------------------------------用途：修改一条客户记录------------------------------------CREATE PROCEDURE customs_Update@customs_id int,@customs_top varchar(50), @customs_name varchar(50), @customs_tel varchar(50), @customs_address varchar(50)ASUPDATE customs SETcustoms_top = @customs_top,customs_name = @customs_name,customs_tel = @customs_tel,customs_address= @customs_addressWHERE customs_id=@customs_idGO--------------------------------------用途：删除一条客户记录软件学院数据库课程设计—进出库管理系统------------------------------------CREATE PROCEDURE customs_Delete@customs_id intASDELETE customsWHERE customs_id=@customs_idGO--------------------------------------用途：根据客户ID得到客户详细信息------------------------------------CREATE PROCEDURE customs_GetModel@customs_id intASSELECTcustoms_id,customs_top,customs_name,customs_tel,customs_addressFROM customsWHERE customs_id=@customs_idGO--------------------------------------用途：查询所有客户记录信息 ------------------------------------ CREATE PROCEDURE customs_GetListASSELECTcustoms_id,customs_top,customs_name,customs_tel,customs_address FROM customsGO/****************************************************************** * 表名：goods******************************************************************/ --------------------------------------用途：是否已经存在该货物 ------------------------------------ CREATE PROCEDURE goods_Exists@goods_id intAS软件学院数据库课程设计—进出库管理系统DECLARE @TempID intSELECT @TempID = count(1) FROM goods WHERE goods_id=@goods_idIF @TempID = 0RETURN 0ELSERETURN 1GO--------------------------------------用途：增加一条货物记录 ------------------------------------ CREATE PROCEDURE goods_ADD@goods_id int,@goods_name varchar(50), @goods_type varchar(50), @goods_warranty int, @goods_sort_id int, @goods_supplier_id int, @goods_remark varchar(100)ASINSERT INTO goods(goods_id,goods_name,goods_type,goods_warranty,goods_sort_id,goods _supplier_id,goods_remark)VALUES(@goods_id,@goods_name,@goods_type,@goods_warranty,@goods_sort_id, @goods_supplier_id,@goods_remark)GO--------------------------------------用途：修改一条货物记录 ------------------------------------ CREATE PROCEDURE goods_Update@goods_id int,@goods_name varchar(50), @goods_type varchar(50), @goods_warranty int, @goods_sort_id int, @goods_supplier_id int, @goods_remarkvarchar(100)ASUPDATE goods] SET软件学院数据库课程设计—进出库管理系统goods_name = @goods_name,goods_type = @goods_type,goods_warranty = @goods_warranty,goods_sort_id = @goods_sort_id,goods_supplier_id = @goods_supplier_id,goods_remark = @goods_remarkWHERE goods_id=@goods_idGO--------------------------------------用途：删除一条货物记录------------------------------------CREATE PROCEDURE goods_Delete@goods_id intASDELETE goodsWHERE goods_id=@goods_idGO--------------------------------------用途：根据货物Id得到货物详细信息 ------------------------------------CREATE PROCEDURE goods_GetModel@goods_id intASSELECTgoods_id,goods_name,goods_type,goods_warranty,goods_sort_id,goods_supplier_id,goods_remarkFROM goodsWHERE goods_id=@goods_idGO--------------------------------------用途：查询所有货物记录信息------------------------------------CREATE PROCEDURE goods_GetListASSELECTgoods_id,goods_name,goods_type,goods_warranty,goods_sort_id,goods_supplier_id,goods_remarkFROM goodsGO软件学院数据库课程设计—进出库管理系统/****************************************************************** * 表名：goodsSort******************************************************************/ --------------------------------------用途：是否已经存在该货物种类 ------------------------------------CREATE PROCEDURE goodsSort_Exists@goodsSort_id intASDECLARE @TempID intSELECT @TempID = count(1) FROM goodsSort WHEREgoodsSort_id=@goodsSort_idIF @TempID = 0RETURN 0ELSERETURN 1GO--------------------------------------用途：增加一条货物种类记录 ------------------------------------ CREATE PROCEDURE goodsSort_ADD@goodsSort_id int,@goodsSort_name varchar(50), @goodsSort_unit varchar(50)ASINSERT INTO goodsSort(goodsSort_id,goodsSort_name,goodsSort_unit)VALUES(@goodsSort_id,@goodsSort_name,@goodsSort_unit)GO--------------------------------------用途：修改一条货物种类记录 ------------------------------------ CREATE PROCEDURE goodsSort_Update@goodsSort_id int,软件学院数据库课程设计—进出库管理系统@goodsSort_name varchar(50), @goodsSort_unit varchar(50)ASUPDATE goodsSort SETgoodsSort_name = @goodsSort_name,goodsSort_unit = @goodsSort_unit WHERE goodsSort_id=@goodsSort_idGO--------------------------------------用途：删除一条货物种类记录 ------------------------------------ CREATE PROCEDURE goodsSort_Delete@goodsSort_id intASDELETE goodsSortWHERE goodsSort_id=@goodsSort_idGO--------------------------------------用途：根据货物种类Id得到种类详细信息------------------------------------CREATE PROCEDURE goodsSort_GetModel@goodsSort_id intASSELECTgoodsSort_id,goodsSort_name,goodsSort_unitFROM goodsSortWHERE goodsSort_id=@goodsSort_idGO--------------------------------------用途：查询种类记录信息------------------------------------CREATE PROCEDURE goodsSort_GetListASSELECTgoodsSort_id,goodsSort_name,goodsSort_unitFROM goodsSortGO软件学院数据库课程设计—进出库管理系统/****************************************************************** * 表名：inStock******************************************************************/ --------------------------------------用途：是否已经存在进库记录 ------------------------------------ CREATE PROCEDURE inStock_Exists@inStock_goods_id int,@inStock_serial intASDECLARE @TempID intSELECT @TempID = count(1) FROM inStock WHEREinStock_goods_id=@inStock_goods_id andinStock_serial=@inStock_serialIF @TempID = 0RETURN 0ELSERETURN 1GO--------------------------------------用途：增加一条进库记录------------------------------------CREATE PROCEDURE inStock_ADD@inStock_serial int output, @inStock_goods_id int,@inStock_amount int,@inStock_in_price money, @inStock_date smalldatetime,@inStock_staff_id int,@inStock_in_id int,@inStock_stock_id int,@inStock_extraMoney money, @inStock_remark varchar(100)ASINSERT INTO inStock(inStock_goods_id,inStock_amount,inStock_in_price,inStock_date,inStock_staff_id,inStock_in_id,inStock_stock_id,inStock_extraMoney,inSt ock_remark)VALUES(软件学院数据库课程设计—进出库管理系统@inStock_goods_id,@inStock_amount,@inStock_in_price,@inStock_date,@i nStock_staff_id,@inStock_in_id,@inStock_stock_id,@inStock_extraMoney,@in Stock_remark)SET @inStock_serial = @@IDENTITYGO--------------------------------------用途：修改一条进库记录------------------------------------CREATE PROCEDURE inStock_Update@inStock_serial int,@inStock_goods_id int,@inStock_amount int,@inStock_in_price money,@inStock_date smalldatetime,@inStock_staff_id int,@inStock_in_id int,@inStock_stock_id int,@inStock_extraMoney money,@inStock_remark varchar(100)ASUPDATE inStock SETinStock_amount = @inStock_amount,inStock_in_price =@inStock_in_price,inStock_date = @inStock_date,inStock_staff_id = @inStock_staff_id,inStock_in_id = @inStock_in_id,inStock_stock_id = @inStock_stock_id,inStock_extraMoney =@inStock_extraMoney,inStock_remark = @inStock_remarkWHERE inStock_goods_id=@inStock_goods_id andinStock_serial=@inStock_serialGO--------------------------------------用途：删除一条进库记录------------------------------------CREATE PROCEDURE inStock_Delete@inStock_goods_id int,@inStock_serial intASDELETE inStockWHERE inStock_goods_id=@inStock_goods_id and软件学院数据库课程设计—进出库管理系统inStock_serial=@inStock_serialGO--------------------------------------用途：根据货物id得到进库详细信息 ------------------------------------CREATE PROCEDURE inStock_GetModel@inStock_goods_id int,@inStock_serial intASSELECTinStock_serial,inStock_goods_id,inStock_amount,inStock_in_price,i nStock_date,inStock_staff_id,inStock_in_id,inStock_stock_id,inStock_ extraMoney,inStock_remarkFROM inStockWHERE inStock_goods_id=@inStock_goods_id andinStock_serial=@inStock_serialGO--------------------------------------用途：查询所有进库记录信息 ------------------------------------ CREATE PROCEDURE inStock_GetListASSELECTinStock_serial,inStock_goods_id,inStock_amount,inStock_in_price,i nStock_date,inStock_staff_id,inStock_in_id,inStock_stock_id,inStock_ extraMoney,inStock_remarkFROM inStockGO/****************************************************************** * 表名：outStock******************************************************************/ --------------------------------------用途：是否已经存在该出库记录 ------------------------------------ CREATE PROCEDURE outStock_Exists@outStock_goods_id int,@outStock_serial int软件学院数据库课程设计—进出库管理系统ASDECLARE @TempID intSELECT @TempID = count(1) FROM outStock WHEREoutStock_goods_id=@outStock_goods_id andoutStock_serial=@outStock_serialIF @TempID = 0RETURN 0ELSERETURN 1GO--------------------------------------用途：增加一条出库记录------------------------------------CREATE PROCEDURE outStock_ADD@outStock_serial int output,@outStock_goods_id int,@outStock_amount int,@outStock_sale_price money,@outStock_extend_warranty int,@outStock_staff_id int,@outStock_out_id int,@outStock_stock_id int,@outStock_date smalldatetime,@outStock_extraMoney money,@outStock_remark varchar(100)ASINSERT INTO outStock(outStock_goods_id,outStock_amount,outStock_sale_price,outStock_ex tend_warranty,outStock_staff_id,outStock_out_id,outStock_stock_id,ou tStock_date,outStock_extraMoney,outStock_remark)VALUES(@outStock_goods_id,@outStock_amount,@outStock_sale_price,@outStoc k_extend_warranty,@outStock_staff_id,@outStock_out_id,@outStock_stoc k_id,@outStock_date,@outStock_extraMoney,@outStock_remark)SET @outStock_serial = @@IDENTITYGO--------------------------------------用途：修改一条出库记录软件学院数据库课程设计—进出库管理系统------------------------------------CREATE PROCEDURE outStock_Update@outStock_serial int,@outStock_goods_id int,@outStock_amount int,@outStock_sale_price money,@outStock_extend_warranty int,@outStock_staff_id int,@outStock_out_id int,@outStock_stock_id int,@outStock_date smalldatetime,@outStock_extraMoney money,@outStock_remark varchar(100)ASUPDATE outStock SEToutStock_amount = @outStock_amount,outStock_sale_price = @outStock_sale_price,outStock_extend_warranty =@outStock_extend_warranty,outStock_staff_id =@outStock_staff_id,outStock_out_id = @outStock_out_id,outStock_stock_id = @outStock_stock_id,outStock_date= @outStock_date,outStock_extraMoney =@outStock_extraMoney,outStock_remark = @outStock_remarkWHERE outStock_goods_id=@outStock_goods_id andoutStock_serial=@outStock_serialGO--------------------------------------用途：删除一条出库记录------------------------------------CREATE PROCEDURE outStock_Delete@outStock_goods_id int,@outStock_serial intASDELETE outStockWHERE outStock_goods_id=@outStock_goods_id andoutStock_serial=@outStock_serialGO--------------------------------------用途：根据货物ID得到出库记录详细信息------------------------------------CREATE PROCEDURE outStock_GetModel软件学院数据库课程设计—进出库管理系统@outStock_goods_id int,。