數(shù)據(jù)庫實用技術(shù)課程設(shè)計--倉庫管理系統(tǒng)(編輯修改稿)
2025-07-09 14:06 本頁面
【文章內(nèi)容簡介】 10)NOT NULL, cangku_type varchar(10)NOT NULL, staff_no varchar(10)NOT NULL, foreign key(staff_no) references staff(staff_no), ) Go 庫存表 create table cunhuo ( cangku_no varchar(10), material_no varchar(10), qty bigint, primary key(cangku_no,material_no), foreign key(cangku_no) references cangku(cangku_no), foreign key(material_no) references material(material_no), ) GO 供應(yīng)商表 create table supplier ( supplier_no varchar(10), material_no varchar(10), supplier_name varchar(10)NOT NULL, supplier_phone char(15)NOT NULL, supplier_address varchar(50)NOT NULL, primary key(supplier_no,material_no), foreign key(material_no) references material(material_no), ) GO 進(jìn)倉表 create table material_in ( rudan_no int NOT NULL, supplier_no varchar(10) NOT NULL, material_no varchar(10) NOT NULL, in_data datetime NOT NULL, ru_qty bigint NOT NULL, supp_pay bigint NOT NULL, staff_no varchar(10) NOT NULL, foreign key(supplier_no,material_no) references supplier(supplier_no,material_no), foreign key(staff_no) references staff(staff_no), ) GO 客戶表 create table kehu ( kehu_no varchar(10) primary key NOT NULL, kehu_name varchar(10)NOT NULL, kehu_password varchar(10)NULL, kehu_phone char(15)NULL, kehu_address varchar(50), ) GO 出倉表 create table material_out ( chudan_no int NOT NULL, kehu_no varchar(10) NOT NULL, material_no varchar(10) NOT NULL, out_data datetime NOT NULL, chu_qty bigint NOT NULL, kehu_pay bigint NOT NULL, staff_no varchar(10) NOT NULL, foreign key(kehu_no) references kehu(kehu_no), foreign key(material_no) references material(material_no), foreign key(staff_no) references staff(staff_no), ) GO 盤庫表 create table panku ( panku_no varchar(10) NOT NULL, staff_no varchar(10) NOT NULL, panku_date datetime, material_no varchar(10)NOT NULL, panku_qty bigint, foreign key(material_no) references material(material_no), foreign key(staff_no) references staff(staff_no), ) Go 建立進(jìn)出倉的存儲過程 入倉 : create procedure material_in_pro @rudan_no int, @supplier_no varchar(10), @material_no varchar(10), @in_data datetime, @ru_qty bigint, @supp_pay bigint, @staff_no varchar(10), @out varchar(20)=39。039。 output as DECLARE @n1 int select @n1=count(material_no) from material where material_no=@material_no if (@n1=0) begin select @out=39。此物料不存在，如果要進(jìn)倉，請先登記新物料信息?。?39。 return end else begin insert into material_in val
畢業(yè)設(shè)計相關(guān)推薦
鄂ICP備17016276號-1