“虛擬商店”之倉(cāng)庫(kù)管理系統(tǒng)-免費(fèi)閱讀
【正文】 在此向幫助和指導(dǎo)過(guò)我的各位老師表示最中心的感謝！感謝這篇論文所涉及到的各位學(xué)者、作者。在今后的學(xué)習(xí)中，我將利用更多的時(shí)間去上機(jī)，去嘗試，相信不久后我的編程水平會(huì)有很大的提高。因?yàn)楣δ鼙容^單一，而一個(gè)“虛擬商店”管理系統(tǒng)的成功運(yùn)營(yíng)是多方面系統(tǒng)共同協(xié)作的結(jié)果，后期我準(zhǔn)備給系統(tǒng)加入這些功能。 while(()) {% 第一行：%=(1)% //第二行：%=(2)% %}% //%(查詢完畢)。 String url=jdbc:microsoft:sqlserver://:1433。,1,4)Insert into ExportInfo(goodsid,exportamount,exportdate,storemanid,customerid) values(2,3, 39。,1,1)Insert into EntryInfo(goodsid,entryamount,entrydate,storemanid,customerid) values(2,5, 39。,2)e) 添加貨品入倉(cāng)記錄Insert into EntryInfo(goodsid,entryamount,entrydate,storemanid,customerid) values(1,10, 39。, 39。)Insert into Goods(goodsname,measureid,describe) values(39。)c) 將貨品信息加入Goods表Insert into Goods(goodsname,measureid,describe) values(39。)b) 將計(jì)量信息加入Measure表Insert into Measure(measurename,describe) values(39。)Insert into Customer(customertype,customername,address,contact,contactphone) Values(3,39。)Insert into Customer(customertype,customername,address,contact,contactphone) Values(2,39。)Insert into Customer(customertype,customername,address,contact,contactphone) Values(1,39。, SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )GOb) 客戶信息表建立CREATE TABLE Customer( CustomerId int IDENTITY(1,1) NOT NULL PRIMARY KEY, CustomerType tinyint NOT NULL DEFAULT(1), CustomerName varchar(60) NOT NULL, Address varchar(180) NOT NULL, Contact varchar(20) NOT NULL, ContactPhone varchar(60) NOT NULL, Memo varchar(800) NULL)c) 計(jì)量單位信息表建立CREATE TABLE Measure(MeasureId int IDENTITY(1,1) NOT NULL PRIMARY KEY,MeasureName varchar(20) NOT NULL,Describe varchar(180) NULL)d) 貨品信息表建立CREATE TABLE Goods(GoodsId int IDENTITY(1,1) NOT NULL PRIMARY KEY,GoodsName varchar(60) NOT NULL,MeasureId int NOT NULL,Describe varchar(180) NULL,Memo varchar(800) NULL,FOREIGN KEY (MeasureId) REFERENCES Measure (MeasureId))e) 庫(kù)管人員信息表設(shè)計(jì)CREATE TABLE Storeman (StoremanId int IDENTITY(1,1) NOT NULL PRIMARY KEY,LoginName varchar(16) NOT NULL,LoginPassword varchar(8) NOT NULL,Name varchar(20) NOT NULL,UserType tinyint NOT NULL DEFAULT(1),Memo varchar(800) NULL)f) 貨品入倉(cāng)信息表建立CREATE TABLE EntryInfo (EntryId int IDENTITY(1,1) NOT NULL PRIMARY KEY,GoodsId int NOT NULL,EntryAmount int NOT NULL,EntryDate datetime NOT NULL DEFAULT(getdate()),StoremanId int NOT NULL,CustomerId int NOT NULL,FOREIGN KEY (GoodsId) REFERENCES Goods (GoodsId),FOREIGN KEY (StoremanId) REFERENCES Storeman (StoremanId),FOREIGN KEY (CustomerId) REFERENCES Customer (CustomerId))g) 品出倉(cāng)信息表建立CREATE TABLE ExportInfo (ExportId int IDENTITY(1,1) NOT NULL PRIMARY KEY,GoodsId int NOT NULL,ExportAmount int NOT NULL,ExportDate datetime NOT NULL DEFAULT(getdate()),StoremanId int NOT NULL,CustomerId int NOT NULL,FOREIGN KEY (GoodsId) REFERENCES Goods (GoodsId),FOREIGN KEY (StoremanId) REFERENCES Storeman (StoremanId),FOREIGN KEY (CustomerId) REFERENCES Customer (CustomerId))h) 貨品盤點(diǎn)信息表建立CREATE TABLE CheckInfo (CheckId int IDENTITY(1,1) NOT NULL PRIMARY KEY,GoodsId int NOT NULL,CheckAmount int NOT NULL,CheckDate datetime NOT NULL DEFAULT(getdate()),StoremanId int NOT NULL,CustomerId int NOT NULL,FOREIGN KEY (GoodsId) REFERENCES Goods (GoodsId),FOREIGN KEY (StoremanId) REFERENCES Storeman (StoremanId),FOREIGN KEY (CustomerId) REFERENCES Customer (CustomerId))i) 庫(kù)存上下限信息表建立CREATE TABLE StorehouseAlert (GoodsId int NOT NULL PRIMARY KEY,UpAlert int NOT NULL,DownAlert int NOT NULL,FOREIGN KEY (GoodsId) REFERENCES Goods (GoodsId))j) 供貨客戶視圖建立CREATE VIEW View_SupplyCustomer ASSe
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1