物流管理系统源代码讲课教案.docx

物流管理系统源代码

精品文档
create database Myth
use Myth
go
--1
create table Branches
(
BranchID int primary key not null,
ChineseName varchar(200) not null,
EnglishName varchar(200) not null,
City varchar(200) not null,
RegisteredCapital nvarchar(20) not null,
CompanyDirector varchar(200) not null,
ChineseAddress varchar(200) not null,
EnglishAddress varchar(200) not null,
TheFrontDeskPhone nvarchar(20) not null,
LegalRepresentative varchar(20) not null,
Remarks nvarchar(200)
)

insert Branches values
(1,'神话北京分公司','Myth Beijing branch','Beijing',1000000,'Jacky','北京市朝阳区东三环中路34号','Beijing City, Chaoyang District No. 34 East Third Ring Road',010-52076666,'Jacky'),
(2,'神话上海分公司','Myth Shanghai branch','Shanghai',2000000,'perdo','徐汇区老沪闵路714号（近石龙路）','Xuhui District old humin Road No. 714 (near the Shilong Road)',021-67286888,'Petro'),
(3,'神话青岛分公司','Myth Qingdao branch','Qingdao',3000000,'Rocky',' 青岛市市南区区太平角三路二号甲 ','Taiping City District of Qingdao City, three road No. two',0532-86120011,'Rocky'),
(4,'神话大连分公司','Myth Dalian branch','Dalian',4000000,'Lee','沙河口区中山路596号','Shahekou Zhongshan Road District No. 596',0411-84331888,'Lee'),
(5,'神话宁波分公司','Myth Ningbo branch','Ningbo',4000000,'Tom','宁波市海曙区柳汀街316弄18号(妇儿医院正大门对面)','Haishu District, Ningbo City, Liu Ting Street Lane 316, No. 18 (opposite the hospital front door)',0574-87165778,'Tom'),
(6,'神话北海分公司','Myth Beihai branch','Beihai',3000000,'Ann','广西北海市海城区 长青北路9号（环卫路）','Guangxi Beihai city Haicheng District Evergreen Road No. 9 (sanitation Road)',0779-2231888,'Ann'),
(7,'神话连云港分公司','Myth Lianyungang branch','Lianyungang',2000000,'Loki','连云港市新浦区人民路19号','The people of Lianyungang City Road Sinpo District No. 19',0518-85688877,'Loki'),
(8,'神话南昌分公司','Myth Nanchang branch','Nanchang',2000000,'Peter','南昌北京东路41号(北京宾馆右侧)','Nanchang Beijing East Road No. 41 (Beijing Hotel on the right side)',0791-88139333,'Peter'),
(9,'神话长沙分公司','Myth Changsha branch','Changsha',1000000,'Mary','湖南省长沙市芙蓉区人民西路170号','Furong district Hunan Province, Changsha City, No. 170',0731-85952777,'Mary'),
(10,'神话温州分公司','Myth Wenzhou branch','Wenzhou',1000000,'Lina','温州市瓯海区六虹桥路1207号（2号美食坊对面，森马集团旁边）','Six Hongqiao Road, Ouhai District, Wenzhou City, No. 1207 (2 Food square opposite side, Semir group)',0577-86189999,'Lina')
--2
create table Department
(
DepartmentID int primary key not null,
DepartmentName varchar(20) not null,
departmentManager varchar(20) not null
)
insert Department values
(1,'Export Department','Alma'),
(2,'Import Department','Amanda'),
(3,'Financial department','Amelia'),
(4,'Human Resources Department','Anastasia'),
(5,'The marketing department','Alexia')
--3
create table Designation
(
PositionID int primary key not null,
PositionName varchar(20) not null,
Assessmentperiod varchar(20) not null,
JobResponsibilityDescription varchar(200)
)
insert Designation values
(1,'Operation','Alma'),
(2,'Line length','Amanda'),
(3,'Agent','Amelia'),
(4,'The section chief','Anastasia'),
(5,'Sale','Alexia'),
(6,'Company director','Andrea')
--4
create table Employee
(
EmployeeID int primary key not null,
EmployeeChineseName varchar(20) not null,
EmployeeEnglishName varchar(20) not null,
Department varchar(200) not null,
Position varchar(200) not null,
BossID int not null,
sex varchar(20) not null,
DateOfBirth nvarchar(20) not null,
PhoneNumber nvarchar(20) not null,
Mailbox nvarchar(20) not null,
Address varchar(200) not null,
JoinDate nvarchar(20) not null
)
insert Employee values
(1,'安娜','Anna','Operation','Staff member',123,'F','1983-01-09',13728679810,'Anna@','No. 1 Nanjing road in the creative Plaza (near Hongling overpass)','2010-09-08'),
(2,'艾谱莉','April','Line length','Staff member',456,'F','1980-03-02',18677899018,'Anna@','No. 124 Nanjing road in the creative Plaza (near Hongling overpass)','2011-01-03'),
(3,'艾琳娜','Arlene','Agent','Staff member',789,'F','1985-01-24',15988765781,'Anna@','No. 167 Nanjing road in the creative Plaza (near Hongling overpass)','2000-04-02'),
(4,'奥德莉','Audrey','Sale','Staff member',258,'F','1982-05-09',15678909872,'Anna@','No. 345 Nanjing road in the creative Plaza (near Hongling overpass)','2012-09-03')
--5
create table EmployeeHistory
(
EmployeeID int not null,
EmployeeChineseName varchar(20) not null,
EmployeeEnglishName varchar(20) not null,
Department varchar(200) not null,
Position varchar(200) not null,
BossID int not null,
sex varchar(20) not null,
DateOfBirth nvarchar(20) not null,
PhoneNumber nvarchar(20) not null,
Mailbox nvarchar(20) not null,
Address varchar(200) not null,
JoinDate nvarchar(20) not null,
TurnoverDime nvarchar(20) not null,
ReasonForLeaving varchar(200) not null
)
insert EmployeeHistory values
(4,'奥德莉','Audrey','Sale','Staff member',258,'F','1982-05-09',15678909872,'Anna@','No. 345 Nanjing road in the creative Plaza (near Hongling overpass)','2012-09-03','2013-08-09','The accident'),
(4,'奥德莉','Audrey','Sale','Staff member',258,'F','1982-05-09',15678909872,'Anna@','No. 345 Nanjing road in the creative Plaza (near Hongling overpass)','2012-09-03','2014-09-09','Section')
--6
create table ExporterImporters
(
CustomerID int primary key not null,
CompanyChineseName varchar(20) not null,
CompanyEnglishName varchar(20) not null,
CompanyChineseAddress varchar(200) not null,
CompanyEnglishAddress varchar(200) not null,
ContacTelephoneNumber nvarchar(20) not null,
Fax nvarchar(20) not null,
TheMainProducts varchar(200) not null,
Description_1 varchar(200) not null,
TheBusinessLicense varchar(200) not null
)
insert ExporterImporters values
(1,'Wing','羽翼','青岛市市南区天津路15号','Qingdao City, Tianjin Road No. 15',13764578890,63380800,'Electronics','All kinds of electronic products','C:\Program Files\duowan\20040520213036.png'),
(2,'Belinda','贝琳达','青岛市市南区天津路14号','Qingdao City, Tianjin Road No. 15',18877365789,63380899,'A leather bag','All kinds of bags','C:\Program Files\duowan\20000520213036.png'),
(3,'Belle','贝拉','青岛市市南区天津路18号','Qingdao City, Tianjin Road No. 15',18625346758,63384500,'Aquatic products','All kinds of aquatic','C:\Program Files\duowan\20110220213036.png'),
(4,'Bertha','柏莎','青岛市市南区天津路11号','Qingdao City, Tianjin Road No. 15',13364589908,63360800,'Fruits','All kinds of fruits','C:\Program Files\duowan\20140220213036.png')
--7
create table BookingAgents
(
CustomerID int primary key not null,
CompanyChineseName varchar(20) not null,
CompanyEnglishName varchar(20) not null,
CompanyChineseAddress varchar(200) not null,
CompanyEnglishAddress varchar(200) not null,
ContacTelephoneNumber nvarchar(20) not null,
Fax nvarchar(20) not null,
Remarks nvarchar(200)
)
insert BookingAgents values
(1,'Wing','羽翼','青岛市市南区天津路15号','Qingdao City, Tianjin Road No. 15',13764578890,63380800),
(2,'Belinda','贝琳达','青岛市市南区天津路14号','Qingdao City, Tianjin Road No. 15',18877365789,63380899),
(3,'Belle','贝拉','青岛市市南区天津路18号','Qingdao City, Tianjin Road No. 15',18625346758,63384500),
(4,'Bertha','柏莎','青岛市市南区天津路11号','Qingdao City, Tianjin Road No. 15',13364589908,63360800)
--8
create table DomesticPatners
(
PartnersID int primary key not null,
Nature varchar(20) not null,
CompanyName varchar(20) not null,
Address_1 varchar(200) not null,
ContactInformation varchar(200) not null
)
insert DomesticPatners values
(1,'Declare at customs','Loong','Shandong Qingdao City Lanshan Road No. 24','Mr. Gao 0532-80912111'),
(2,'Transport','Safety','Shandong Qingdao City Lanshan Road No. 47','Mr. Li 0532-80942171'),
(3,'Trade agent','Make a fortune','Shandong Qingdao City Lanshan Road No. 57','Mr. Zhao 0582-60912111'),
(4,'Express','Take the world','Shandong Qingdao City Lanshan Road No. 88','Mr. Wang 0536-80912461')
--9
create table CountryRegister
(
TelephoneCode int primary key not null,
TheNationalChineseName varchar(20) not null,
TheNationalEnglishName varchar(20) not null,
InternationalDomainNameAbbreviation varchar(20) not null
)
insert CountryRegister values
(93,'阿富汗','Afghanistan','AF'),
(267,'博茨瓦纳','Botswana','BW'),
(55,'巴西','Brazil','BR'),
(49,'德国','Germany','DE')
--10
create table OverseasAgents
(
TheNumberOfForeign int primary key not null,
TheCompanyEnglishName varchar(20) not null,
TheCompanyEnglishAddress varchar(20) not null,
CompanyPhone nvarchar(20) not null,
CompanyFax nvarchar(20)not null,
Contacts varchar(200) not null
)
insert OverseasAgents values
(1,'zhuque','No. 16 Yunnan Road',13678967763,61448488,'Ms. Tian 0532-82358088'),
(2,'xuanwu','No. 56 Yunnan Road',15782349760,67488488,'Ms. Qian 0532-82812088'),
(3,'qinglong','No. 97 Yunnan Road',18634790872,55488488,'Ms. Li 0532-82818798'),
(4,'baihu','No. 345 Yunnan Road',15792310087,43488488,'Ms. Zhang 0532-82568088')
--11
create table MBLs
(
Exit_Imported varchar(20) not null,
TheMainNumber nvarchar(20) not null,
SHIPPER varchar(20) not null,
CNEE varchar(20) not null,
Notify varchar(20) not null,
PortOfShipment varchar(200) not null,
ThePortOfDestination varchar(200) not null,
DateOfShipment nvarchar(20) not null,
TheNameOfTheShipVoyage varchar(200) not null,
BoxType nvarchar(20) not null,
TheNumberOfBoxes nvarchar(20) not null,
ShippingMark varchar(200) not null,
Number int not null,
unit varchar(20) not null,
Weight_1 double not null,
CMB double not null,
TheOperator varchar(20) not null
)
insert MBLs values
('Exit',7758521,'xurishu','maoriji','jiaomujiao','qingdao','dalian','2013-09-08','feiyu_1','20GP',2000,'',400,'吨','200','40','biyuewu'),
('Imported',7348521,'kangjinlong','kuimulang','niujinniu','qingdao','dalian','2014-09-08','feiyu_3','20GP',2100,'',300,'吨','260','50','weiyueyan')
--12
create table MBLCharges
(
TheMainNumber int not null,
TheCostOfTheProject varchar(20) not null,
AmountPayable varchar(20) not null,
DealWithCompanyName varchar(20) not null,
AmountReceivable varchar(20) not null,
ShouldTheCompanyName varchar(20) not null,
)
insert MBLCharges values
(7758521,'Maintain','7895','Wing','7895','Myth branch'),
(7348521,'Maintain','4566','Belinda','4566','Myth branch')
--13
create table EmployeeSalary
(
StaffID int not null,
ParticularYear double not null,
Month_1 double not null,
TheBasicWage double not null,
MealSupplement double not null,
TrafficSubsidy double not null,
TheDeductionOfPersonalInsurance double not null,
DeductIndividualProvidentFund double not null,
OvertimePay double not null,
MonthlySalary double not null
)
insert EmployeeSalary values
(1,2013,7,3456,90,45,34,35,46,65456),
(2,2013,8,12345,788,54,67,54,57,6444),
(3,2013,9,4567,654,78,89,67,89,999)
--14
create table DeliveyNotice
(
TheMainNumber int not null,
CargoEntryDeadline nvarchar(20) not null,
EnterGoodsPlace varchar(200) not null,
TheGoods varchar(200) not null,
Contacts varchar(200) not null,
ContactTelephoneNumber nvarchar(20) not null
)
insert Delivey Notice values
(7758521,'2013-09-06','qingdao','qing_1','jingmuhan','15786356677'),
(7348521,'2014-02-18','qingdao','qing_2','guijinyang','18366773897'),

--15
create table HBLs
(
DivisionNo int primary key not null,
TheMainNumberAssociation int not null,
SHIPPER varchar(20) not null,
CNEE varchar(20) not null,
Notify varchar(20) not null
)
insert HBLs values
(1,7758521,'xurishu','maoriji','jiaomujiao'),
(2,7348521,'kangjinlong','kuimulang','niujinniu')

收集于网络，如有侵权请联系管理员删除