出入库管理系统设计文档

成功是失败之母，一切都是努力的结果出入库管理系统设计文档软件学院数据库课程设计—进出库管理系统082软件学院数据库课程设计—进出库管理系统1、设计和实现库存管理系统2、撰写设计文档按照管理信息系统的原理和方法，采用成熟、先进的信息技术和手段，支持仓库进出库管理工作的全过程，保证仓库货品的有序正常的流通。1、概念结构设计，绘出库存管理的E-R图。2、逻辑结构设计，根据关系数据库设计原理，设计出库存管理的关系模型。3、物理结构设计，给出库存管理数据库在SQLServer2005中的定义。4、数据库实现，在SQLServer2005中建立库存管理数据库。1：出入库信息操作、查询库存信息、产品分类管理、添加删除人员、查看系统事件。：查询库内信息、修改本用户密码。21、进、出库管理。对进、出库信息进行记录。2、查询功能。仓库管理对查询要求高，通过主菜单记录当前操作用户的用户编号，保证了对进、出库信息录入负责人的确认。1页脚内容成功是失败之母，一切都是努力的结果3、库存管理，根据外界对库存的要求，企业订购的特点，预测，计划和执行一种补充库存的行为，并对这种行为进行控制，重点在于确定如何订货，订购多少，何时定货。4、部门资料管理与库存报表生成软件学院数据库课程设计—进出库管理系统5、界面简单、易于操作根据系统的业务流程和用户的需求分析可以得出，本系统应该包含产品基本信息管理、入出库管理、库存管理、查询统计、系统日志管理几大功能，1）基本信息管理：货品信息、供应商信息、客户信息、员工信息，分别实现相应信息添加、删除、查找、修改2）入库信息管理：入货信息录入3）出库信息管理：入货信息录入4）库存信息管理：查询库存信息5）查询统计：货品查询、供应商查询、客户查询、入库查询、出库查询、员工查询按日期：查询某个时间段的出入库信息按人员：供应商、客户、员工信息查询按物品：查询某种商品的出入库信息和余料打印报表6)系统日志信息管理：记录相应操作信息每个关系中都至少要有一个主键，关系与关系之上的约束条件，定义触发器。当外界非正常因素导致系统关闭时可自动保存间通过主外键关联。定义属性2页脚内容成功是失败之母，一切都是努力的结果系统操作日志是不允许改动的对于非仓库管理员是不允许进行增、删、改相应的操作，只可查看相关信息记录合格订单总帐订单查看订单入库打印信息明细帐不合格订单（入库）查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查软件学院数据库课程设计—进出库管理系统（出库）查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查（功能模块图）E-R：1软件学院数据库课程设计—进出库管理系统员工编号姓名性别职位3页脚内容成功是失败之母，一切都是努力的结果员工信息固定电话手机通讯地址邮政编码备注2)：查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查3)：类别编号类别名称计量单位货物类别4)：查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查5)：软件学院数据库课程设计—进出库管理系统查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查7供应商编供应商名供应商地联系人联系电话号称址供应商8客户编号客户名称联系人联系电话客户地址客户4页脚内容成功是失败之母，一切都是努力的结果9仓库编号仓库名称联系人id仓库地址仓库信息10现有存储仓库编号货品编号最高限量最低限量量库存信息v11)：软件学院数据库课程设计—进出库管理系统查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查11查查查查查查查查查查N查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查M查查查查查查查查查N1MN查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查查1查查查查查查查查查查查查查查查查查查查查查查查11查查查查查查查查查查查查查查查查查查查查NN查查查查查查查查查查查查查查查查查查查查查查查查11查查查查查查查查查查查查查查用户管理、员工信息、业务关系人员信息、银行账户信息、仓库信息、货物基本信息、货物5页脚内容成功是失败之母，一切都是努力的结果类别、报损信息、调拨信息、货物入库信息、货物出库信息、库存总账信息、系统日志信息1.初始大增长大文件文件名称最大文件大小小小数据库不受限制StockManagement_Data.mdf32日志不受限制StockManagement_Log.log112.软件学院数据库课程设计—进出库管理系统Staff序属性名称属性描述数据类型空否默认值备注号1Staff_id员工编号int否主键2Staff_name姓名varchar(50)否3Staff_sex性别bit4Staff_Security权限Int否5Staff_tel固定电话varchar(50)6Staff_mobile手机varchar(50)7Staff_address通讯地址varchar(50)8Staff_postalcode邮政编码varchar(50)9Staff_remark备注Varchar(100)Goods序空默认属性名称属性描述数据类型备注号否值2Goods_id编号int否主键3Goods_name名称varchar(50)否4Goods_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否6页脚内容成功是失败之母，一切都是努力的结果Goods_remark备注Varchar(100)GoodsSort序默认属性名称属性描述数据类型空否备注号值1GoodsSort_id类别编号int否主键2GoodsSort_name名称varchar(50)否3GoodsSort_unit计量单位varchar(4)否Instock序空默认属性名称属性描述数据类型备注号否值自动增长1Instock_serial入库序号int否（1，1）3Instock_Googs_id货品编号int否主键软件学院数据库课程设计—进出库管理系统4Instock_amount数量int否5Instock_date入库时间smalldatatime否经手人编Instock_Staff_idint否外键号入货单编Instock_In_idint否自动生成号Instock_stock_id仓库idInt否外键Instock_ExtraMoney额外费用moneyInstock_remark备注Varchar(50)Outstock序空默认属性名称属性描述数据类型备注号否值自动增长1Outstock_serial出库序号int否（1，1）3Outstock_Goods_id货品编号int否主键4Outstock_amouny实发数量int否5Outstock_Sale_price实际售价money否Outstock_延保年限int否Extend_warranty经手人编Outstock_Staff_idint否外键号出货单编Outstock_Out_idint否自动生成号7页脚内容成功是失败之母，一切都是努力的结果Outstock_Stock_id仓库编号int否外键Outstock_date出库日期smalldatatime否Outstock_ExtraMoney额外费用moneyOutstock_remark备注Varchar(100)Supplier序默认属性名称属性描述数据类型空否备注号值1Supplier_id供应商编号int否主键2Supplier_top供应商名称int否3Supplier_name联系人varchar(50)否4Supplier_tel联系电话varchar(50)否Supplier_address供应商地址varchar(50)否Customs软件学院数据库课程设计—进出库管理系统序默认属性名称属性描述数据类型空否备注号值1Customs_id客户编号int否主键2Customs_top客户名称varchar(50)否3Customs_name联系人varchar(50)否4Customs_tel联系电话varchar(50)否Customs_adddress客户地址varchar(50)否Stock序属性名称属性描述数据类型空否默认值备注号1Stock_id仓库idint否主键2Stock_name仓库名称varchar(50)否3Stock_Staff_id员工编号int否外键4Stock_address仓库地址varchar(50)否StockRemain序属性描空默认属性名称数据类型备注号述否值StockRemain_goods_id货物idint否主键StockRemain_stock_id仓库idint否外键8页脚内容成功是失败之母，一切都是努力的结果最低限StockRemain_Min_amountint否量最高限StockRemain_Max_amountint否量现有库StockRemain_amountint否存量SystemLog序属性描空默认属性名称数据类型备注号述否值主键操作序1SystemLog_Serialint否自动增长（1，号1）操作人2SystemLog_Staff_idint否外键编号操作内3SystemLog_mattervarchar(100)否容软件学院数据库课程设计—进出库管理系统操作时4SystemLog_datesmalldatatime否间createdatabaseStockManagementonprimary(name=StockManagement_mdf,filename='D:\StockManagement_mdf.mdf',size=3MB,maxsize=unlimited,filegrowth=3%)logon(name=StockManagement_log,filename='D:\StockManagement_log.log',size=1MB,maxsize=unlimited,filegrowth=3%9页脚内容成功是失败之母，一切都是努力的结果)gouseStockManagementgocreatetablestaff--员工基本信息(staff_idintnotnullprimarykey,staff_namevarchar(50)notnull,staff_passwordvarchar(50)notnull,staff_securityintnotnull,staff_sexbit,staff_telvarchar(50),staff_mobilevarchar(50),staff_addressvarchar(50),staff_remarkvarchar(100))useStockManagementgocreatetablegoods--货物基本信息软件学院数据库课程设计—进出库管理系统(goods_idintnotnullprimarykey,goods_namevarchar(50)notnull,goods_typevarchar(50)notnull,goods_warrantyintnotnull,goods_sort_idintnotnull,goods_supplier_idintnotnull,goods_remarkvarchar(100))10页脚内容成功是失败之母，一切都是努力的结果useStockManagementgocreatetablegoodsSort--货物种类信息(goodsSort_idintnotnullprimarykey,goodsSort_namevarchar(50)notnull,goodsSort_unitvarchar(50)notnull,)useStockManagementgocreatetableinStock--入库信息(inStock_serialintidentity(1,1)notnull,inStock_goods_idintnotnullprimarykey,inStock_amountintnotnull,inStock_in_pricemoneynotnull,inStock_datesmalldatetimenotnull,inStock_staff_idintnotnull,inStock_in_idintnotnull,inStock_stock_idintnotnull,inStock_extraMoneymoney,inStock_remarkvarchar(100))useStockManagementgocreatetableoutStock--出库信息(outStock_serialintidentity(1,1)notnull,outStock_goods_idintnotnullprimarykey,outStock_amountintnotnull,11页脚内容成功是失败之母，一切都是努力的结果outStock_sale_pricemoneynotnull,软件学院数据库课程设计—进出库管理系统outStock_extend_warrantyintnotnull,outStock_staff_idintnotnull,outStock_out_idintnotnull,outStock_stock_idintnotnull,outStock_datesmalldatetimenotnull,outStock_extraMoneymoney,outStock_remarkvarchar(100))gouseStockManagementgocreatetablesupplier--供应商信息(supplier_idintnotnullprimarykey,supplier_topvarchar(50)notnull,supplier_namevarchar(50)notnull,supplier_telvarchar(50)notnull,supplier_addressvarchar(50)notnull)gouseStockManagementgocreatetablecustoms--客户信息(customs_idintnotnullprimarykey,customs_topvarchar(50)notnull,customs_namevarchar(50)notnull,customs_telvarchar(50)notnull,customs_addressvarchar(50)notnull)gouseStockManagementgo12页脚内容成功是失败之母，一切都是努力的结果createtablestock--仓库信息(stock_idintnotnullprimarykey,stock_namevarchar(50)notnull,stock_staff_idintnotnull,stock_addressvarchar(50)notnull)useStockManagement软件学院数据库课程设计—进出库管理系统gocreatetablestockRemain--库存信息(stockRemain_goods_idintnotnullprimarykey,stockRemain_min_amountintnotnull,stockRemain_max_amountintnotnull,stockRemain_amountintnotnull)gouseStockManagementgocreatetablesystemLog--系统日志信息(systemLog_serialintidentity(1,1)notnullprimarykey,systemLog_staff_idintnotnull,systemLog_mattervarchar(100)notnull,systemLog_datesmalldatetimenotnull)13页脚内容成功是失败之母，一切都是努力的结果--查看日志信息useStockManagement软件学院数据库课程设计—进出库管理系统gocreateviewselectSysLogasselect*fromsystemLog*/*******************************************************************表名：staff******************************************************************/--------------------------------------用途：是否已经存在该员工------------------------------------CREATEPROCEDUREstaff_Exists@staff_idintASDECLARE@TempIDintSELECT@TempID=count(1)FROMstaffWHEREstaff_id=@staff_id14页脚内容成功是失败之母，一切都是努力的结果IF@TempID=0RETURN0ELSERETURN1GO--------------------------------------用途：增加一条员工记录------------------------------------CREATEPROCEDUREstaff_ADD@staff_idint,@staff_namevarchar(50),@staff_passwordvarchar(50),@staff_securityint,@staff_sexbit,@staff_telvarchar(50),@staff_mobilevarchar(50),@staff_addressvarchar(50),@staff_remarkvarchar(100)ASINSERTINTOstaff(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)GO15页脚内容成功是失败之母，一切都是努力的结果--------------------------------------用途：修改一条员工记录------------------------------------CREATEPROCEDUREstaff_Update@staff_idint,@staff_namevarchar(50),@staff_passwordvarchar(50),@staff_securityint,@staff_sexbit,@staff_telvarchar(50),@staff_mobilevarchar(50),@staff_addressvarchar(50),@staff_remarkvarchar(100)ASUPDATEstaffSETstaff_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_remarkWHEREstaff_id=@staff_idGO--------------------------------------用途：删除一条员工记录16页脚内容成功是失败之母，一切都是努力的结果------------------------------------CREATEPROCEDUREstaff_Delete@staff_idintASDELETE[staff]WHEREstaff_id=@staff_idGO软件学院数据库课程设计—进出库管理系统--------------------------------------用途：根据员工ID得到员工详细信息------------------------------------CREATEPROCEDUREstaff_GetModel@staff_idintASSELECTstaff_id,staff_name,staff_password,staff_security,staff_sex,staff_tel,staff_mobile,staff_address,staff_remarkFROMstaffWHEREstaff_id=@staff_idGO--------------------------------------用途：查询所有记录信息------------------------------------CREATEPROCEDUREstaff_GetList17页脚内容成功是失败之母，一切都是努力的结果ASSELECTstaff_id,staff_name,staff_password,staff_security,staff_sex,staff_tel,staff_mobile,staff_address,staff_remarkFROMstaffGO/*******************************************************************表名：stock******************************************************************/--------------------------------------用途：是否已经存在该仓库记录------------------------------------CREATEPROCEDUREstock_Exists@stock_idintASDECLARE@TempIDintSELECT@TempID=count(1)FROMstockWHEREstock_id=@stock_idIF@TempID=0RETURN0ELSERETURN1软件学院数据库课程设计—进出库管理系统GO--------------------------------------用途：增加一条仓库记录------------------------------------18页脚内容成功是失败之母，一切都是努力的结果CREATEPROCEDUREstock_ADD@stock_idint,@stock_namevarchar(50),@stock_staff_idint,@stock_addressvarchar(50)ASINSERTINTOstock(stock_id,stock_name,stock_staff_id,stock_address)VALUES(@stock_id,@stock_name,@stock_staff_id,@stock_address)GO--------------------------------------用途：更新一条仓库记录------------------------------------CREATEPROCEDUREstock_Update@stock_idint,@stock_namevarchar(50),@stock_staff_idint,@stock_addressvarchar(50)ASUPDATEstockSETstock_name=@stock_name,stock_staff_id=@stock_staff_id,stock_address=@stock_addressWHEREstock_id=@stock_idGO------------------------------------19页脚内容成功是失败之母，一切都是努力的结果--用途：删除一条仓库记录------------------------------------CREATEPROCEDUREstock_Delete@stock_idintASDELETEstock软件学院数据库课程设计WHEREstock_id=@stock_idGO—进出库管理系统--------------------------------------用途：根据仓库Id得到仓库详细信息------------------------------------CREATEPROCEDUREstock_GetModel@stock_idintASSELECTstock_id,stock_name,stock_staff_id,stock_addressFROMstockWHEREstock_id=@stock_idGO--------------------------------------用途：查询所有仓库记录信息------------------------------------CREATEPROCEDUREstock_GetListASSELECT20页脚内容成功是失败之母，一切都是努力的结果stock_id,stock_name,stock_staff_id,stock_addressFROMstockGO/*******************************************************************表名：stockRemain******************************************************************/--------------------------------------用途：根据货物id得到库存详细信息------------------------------------CREATEPROCEDUREstockRemain_GetModel@stockRemain_goods_idintASSELECTstockRemain_goods_id,stockRemain_min_amount,stockRemain_max_amount,stockRemain_amount软件学院数据库课程设计—进出库管理系统FROMstockRemainWHEREstockRemain_goods_id=@stockRemain_goods_idGO--------------------------------------用途：查询所有库存记录信息------------------------------------CREATEPROCEDUREstockRemain_GetListASSELECT21页脚内容成功是失败之母，一切都是努力的结果stockRemain_goods_id,stockRemain_min_amount,stockRemain_max_amount,stockRemain_amountFROMstockRemainGO/*******************************************************************表名：supplier******************************************************************/--------------------------------------用途：是否已经存在该供应商------------------------------------CREATEPROCEDUREsupplier_Exists@supplier_idintASDECLARE@TempIDintSELECT@TempID=count(1)FROMsupplierWHEREsupplier_id=@supplier_idIF@TempID=0RETURN0ELSERETURN1GO--------------------------------------用途：增加一条供应商记录------------------------------------CREATEPROCEDUREsupplier_ADD@supplier_idint,22页脚内容成功是失败之母，一切都是努力的结果@supplier_topvarchar(50),软件学院数据库课程设计—进出库管理系统@supplier_namevarchar(50),@supplier_telvarchar(50),@supplier_addressvarchar(50)ASINSERTINTOsupplier(supplier_id,supplier_top,supplier_name,supplier_tel,supplier_address)VALUES(@supplier_id,@supplier_top,@supplier_name,@supplier_tel,@supplier_address)GO--------------------------------------用途：更新一条供应商记录------------------------------------CREATEPROCEDUREsupplier_Update@supplier_idint,@supplier_topvarchar(50),@supplier_namevarchar(50),@supplier_telvarchar(50),@supplier_addressvarchar(50)ASUPDATEsupplierSETsupplier_top=@supplier_top,supplier_name=@supplier_name,supplier_tel=@supplier_tel,supplier_address=23页脚内容成功是失败之母，一切都是努力的结果@supplier_addressWHEREsupplier_id=@supplier_idGO--------------------------------------用途：删除一条供应商记录------------------------------------CREATEPROCEDUREsupplier_Delete@supplier_idintASDELETEsupplierWHEREsupplier_id=@supplier_id软件学院数据库课程设计—进出库管理系统GO--------------------------------------用途：根据供应商ID得到供应商详细信息------------------------------------CREATEPROCEDUREsupplier_GetModel@supplier_idintASSELECTsupplier_id,supplier_top,supplier_name,supplier_tel,supplier_addressFROMsupplierWHEREsupplier_id=@supplier_id24页脚内容成功是失败之母，一切都是努力的结果GO--------------------------------------用途：查询所有供应商记录信息------------------------------------CREATEPROCEDUREsupplier_GetListASSELECTsupplier_id,supplier_top,supplier_name,supplier_tel,supplier_addressFROMsupplierGO/*******************************************************************表名：customs******************************************************************/--------------------------------------用途：是否已经存在该客户------------------------------------CREATEPROCEDUREcustoms_Exists@customs_idintASDECLARE@TempIDintSELECT@TempID=count(1)FROMcustomsWHEREcustoms_id=@customs_idIF@TempID=0RETURN0ELSE软件学院数据库课程设计—进出库管理系统25页脚内容成功是失败之母，一切都是努力的结果RETURN1GO--------------------------------------用途：增加一条客户记录------------------------------------CREATEPROCEDUREcustoms_ADD@customs_idint,@customs_topvarchar(50),@customs_namevarchar(50),@customs_telvarchar(50),@customs_addressvarchar(50)ASINSERTINTOcustoms(customs_id,customs_top,customs_name,customs_tel,customs_address)VALUES(@customs_id,@customs_top,@customs_name,@customs_tel,@customs_address)GO--------------------------------------用途：修改一条客户记录------------------------------------CREATEPROCEDUREcustoms_Update@customs_idint,@customs_topvarchar(50),@customs_namevarchar(50),@customs_telvarchar(50),@customs_addressvarchar(50)26页脚内容成功是失败之母，一切都是努力的结果ASUPDATEcustomsSETcustoms_top=@customs_top,customs_name=@customs_name,customs_tel=@customs_tel,customs_address=@customs_addressWHEREcustoms_id=@customs_idGO--------------------------------------用途：删除一条客户记录软件学院数据库课程设计—进出库管理系统------------------------------------CREATEPROCEDUREcustoms_Delete@customs_idintASDELETEcustomsWHEREcustoms_id=@customs_idGO--------------------------------------用途：根据客户ID得到客户详细信息------------------------------------CREATEPROCEDUREcustoms_GetModel@customs_idintASSELECTcustoms_id,customs_top,customs_name,customs_tel,customs_address27页脚内容成功是失败之母，一切都是努力的结果FROMcustomsWHEREcustoms_id=@customs_idGO--------------------------------------用途：查询所有客户记录信息------------------------------------CREATEPROCEDUREcustoms_GetListASSELECTcustoms_id,customs_top,customs_name,customs_tel,customs_addressFROMcustomsGO/*******************************************************************表名：goods******************************************************************/--------------------------------------用途：是否已经存在该货物------------------------------------CREATEPROCEDUREgoods_Exists@goods_idintAS软件学院数据库课程设计—进出库管理系统DECLARE@TempIDintSELECT@TempID=count(1)FROMgoodsWHEREgoods_id=@goods_idIF@TempID=0RETURN028页脚内容成功是失败之母，一切都是努力的结果ELSERETURN1GO--------------------------------------用途：增加一条货物记录------------------------------------CREATEPROCEDUREgoods_ADD@goods_idint,@goods_namevarchar(50),@goods_typevarchar(50),@goods_warrantyint,@goods_sort_idint,@goods_supplier_idint,@goods_remarkvarchar(100)ASINSERTINTOgoods(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--------------------------------------用途：修改一条货物记录------------------------------------CREATEPROCEDUREgoods_Update@goods_idint,29页脚内容成功是失败之母，一切都是努力的结果@goods_namevarchar(50),@goods_typevarchar(50),@goods_warrantyint,@goods_sort_idint,@goods_supplier_idint,@goods_remarkvarchar(100)ASUPDATEgoods]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_remarkWHEREgoods_id=@goods_idGO--------------------------------------用途：删除一条货物记录------------------------------------CREATEPROCEDUREgoods_Delete@goods_idintASDELETEgoodsWHEREgoods_id=@goods_idGO--------------------------------------用途：根据货物Id得到货物详细信息------------------------------------CREATEPROCEDUREgoods_GetModel30页脚内容成功是失败之母，一切都是努力的结果@goods_idintASSELECTgoods_id,goods_name,goods_type,goods_warranty,goods_sort_id,goods_supplier_id,goods_remarkFROMgoodsWHEREgoods_id=@goods_idGO--------------------------------------用途：查询所有货物记录信息------------------------------------CREATEPROCEDUREgoods_GetListASSELECTgoods_id,goods_name,goods_type,goods_warranty,goods_sort_id,goods_supplier_id,goods_remarkFROMgoodsGO软件学院数据库课程设计—进出库管理系统/*******************************************************************表名：goodsSort******************************************************************/--------------------------------------用途：是否已经存在该货物种类------------------------------------31页脚内容成功是失败之母，一切都是努力的结果CREATEPROCEDUREgoodsSort_Exists@goodsSort_idintASDECLARE@TempIDintSELECT@TempID=count(1)FROMgoodsSortWHEREgoodsSort_id=@goodsSort_idIF@TempID=0RETURN0ELSERETURN1GO--------------------------------------用途：增加一条货物种类记录------------------------------------CREATEPROCEDUREgoodsSort_ADD@goodsSort_idint,@goodsSort_namevarchar(50),@goodsSort_unitvarchar(50)ASINSERTINTOgoodsSort(goodsSort_id,goodsSort_name,goodsSort_unit)VALUES(@goodsSort_id,@goodsSort_name,@goodsSort_unit)GO------------------------------------32页脚内容成功是失败之母，一切都是努力的结果--用途：修改一条货物种类记录------------------------------------CREATEPROCEDUREgoodsSort_Update@goodsSort_idint,软件学院数据库课程设计—进出库管理系统@goodsSort_namevarchar(50),@goodsSort_unitvarchar(50)ASUPDATEgoodsSortSETgoodsSort_name=@goodsSort_name,goodsSort_unit=@goodsSort_unitWHEREgoodsSort_id=@goodsSort_idGO--------------------------------------用途：删除一条货物种类记录------------------------------------CREATEPROCEDUREgoodsSort_Delete@goodsSort_idintASDELETEgoodsSortWHEREgoodsSort_id=@goodsSort_idGO--------------------------------------用途：根据货物种类Id得到种类详细信息------------------------------------CREATEPROCEDUREgoodsSort_GetModel@goodsSort_idintAS33页脚内容成功是失败之母，一切都是努力的结果SELECTgoodsSort_id,goodsSort_name,goodsSort_unitFROMgoodsSortWHEREgoodsSort_id=@goodsSort_idGO--------------------------------------用途：查询种类记录信息------------------------------------CREATEPROCEDUREgoodsSort_GetListASSELECTgoodsSort_id,goodsSort_name,goodsSort_unitFROMgoodsSortGO软件学院数据库课程设计—进出库管理系统/*******************************************************************表名：inStock******************************************************************/--------------------------------------用途：是否已经存在进库记录------------------------------------CREATEPROCEDUREinStock_Exists@inStock_goods_idint,@inStock_serialintAS34页脚内容成功是失败之母，一切都是努力的结果DECLARE@TempIDintSELECT@TempID=count(1)FROMinStockWHEREinStock_goods_id=@inStock_goods_idandinStock_serial=@inStock_serialIF@TempID=0RETURN0ELSERETURN1GO--------------------------------------用途：增加一条进库记录------------------------------------CREATEPROCEDUREinStock_ADD@inStock_serialintoutput,@inStock_goods_idint,@inStock_amountint,@inStock_in_pricemoney,@inStock_datesmalldatetime,@inStock_staff_idint,@inStock_in_idint,@inStock_stock_idint,@inStock_extraMoneymoney,@inStock_remarkvarchar(100)ASINSERTINTOinStock(inStock_goods_id,inStock_amount,inStock_in_price,inStock_date,inS35页脚内容成功是失败之母，一切都是努力的结果tock_staff_id,inStock_in_id,inStock_stock_id,inStock_extraMoney,inStock_remark)VALUES(软件学院数据库课程设计—进出库管理系统@inStock_goods_id,@inStock_amount,@inStock_in_price,@inStock_date,@inStock_staff_id,@inStock_in_id,@inStock_stock_id,@inStock_extraMoney,@inStock_remark)SET@inStock_serial=@@IDENTITYGO--------------------------------------用途：修改一条进库记录------------------------------------CREATEPROCEDUREinStock_Update@inStock_serialint,@inStock_goods_idint,@inStock_amountint,@inStock_in_pricemoney,@inStock_datesmalldatetime,@inStock_staff_idint,@inStock_in_idint,@inStock_stock_idint,@inStock_extraMoneymoney,36页脚内容成功是失败之母，一切都是努力的结果@inStock_remarkvarchar(100)ASUPDATEinStockSETinStock_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_remarkWHEREinStock_goods_id=@inStock_goods_idandinStock_serial=@inStock_serialGO--------------------------------------用途：删除一条进库记录------------------------------------CREATEPROCEDUREinStock_Delete@inStock_goods_idint,@inStock_serialintASDELETEinStockWHEREinStock_goods_id=@inStock_goods_idand软件学院数据库课程设计—进出库管理系统inStock_serial=@inStock_serialGO------------------------------------37页脚内容成功是失败之母，一切都是努力的结果--用途：根据货物id得到进库详细信息------------------------------------CREATEPROCEDUREinStock_GetModel@inStock_goods_idint,@inStock_serialintASSELECTinStock_serial,inStock_goods_id,inStock_amount,inStock_in_price,inStock_date,inStock_staff_id,inStock_in_id,inStock_stock_id,inStock_extraMoney,inStock_remarkFROMinStockWHEREinStock_goods_id=@inStock_goods_idandinStock_serial=@inStock_serialGO--------------------------------------用途：查询所有进库记录信息------------------------------------CREATEPROCEDUREinStock_GetListASSELECTinStock_serial,inStock_goods_id,inStock_amount,inStock_in_price,inStock_date,inStock_staff_id,inStock_in_id,inStock_stock_id,inStock_extraMoney,inStock_remark38页脚内容成功是失败之母，一切都是努力的结果FROMinStockGO/*******************************************************************表名：outStock******************************************************************/--------------------------------------用途：是否已经存在该出库记录------------------------------------CREATEPROCEDUREoutStock_Exists@outStock_goods_idint,@outStock_serialint软件学院数据库课程设计—进出库管理系统ASDECLARE@TempIDintSELECT@TempID=count(1)FROMoutStockWHEREoutStock_goods_id=@outStock_goods_idandoutStock_serial=@outStock_serialIF@TempID=0RETURN0ELSERETURN1GO--------------------------------------用途：增加一条出库记录------------------------------------39页脚内容成功是失败之母，一切都是努力的结果CREATEPROCEDUREoutStock_ADD@outStock_serialintoutput,@outStock_goods_idint,@outStock_amountint,@outStock_sale_pricemoney,@outStock_extend_warrantyint,@outStock_staff_idint,@outStock_out_idint,@outStock_stock_idint,@outStock_datesmalldatetime,@outStock_extraMoneymoney,@outStock_remarkvarchar(100)ASINSERTINTOoutStock(outStock_goods_id,outStock_amount,outStock_sale_price,outStock_extend_warranty,outStock_staff_id,outStock_out_id,outStock_stock_id,outStock_date,outStock_extraMoney,outStock_remark)VALUES(@outStock_goods_id,@outStock_amount,@outStock_sale_price,@outStock_extend_warranty,@outStock_staff_id,@outStock_out_id,@outStock_stock_id,@outStock_date,@outStock_extraMoney,@outStock_remark)40页脚内容成功是失败之母，一切都是努力的结果SET@outStock_serial=@@IDENTITYGO--------------------------------------用途：修改一条出库记录软件学院数据库课程设计—进出库管理系统------------------------------------CREATEPROCEDUREoutStock_Update@outStock_serialint,@outStock_goods_idint,@outStock_amountint,@outStock_sale_pricemoney,@outStock_extend_warrantyint,@outStock_staff_idint,@outStock_out_idint,@outStock_stock_idint,@outStock_datesmalldatetime,@outStock_extraMoneymoney,@outStock_remarkvarchar(100)ASUPDATEoutStockSEToutStock_amount=@outStock_amount,outStock_sale_price=@outStock_sale_price,outStock_extend_warranty=@outStock_extend_warranty,outStock_staff_id=41页脚内容成功是失败之母，一切都是努力的结果@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_remarkWHEREoutStock_goods_id=@outSto