物流管理系统源代码

1、create database Mythuse Mythgo-1create 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,En

2、glishAddress 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,Jacky,北京市朝阳区东三环中路34号,Beijing City, Chaoyang District No. 34 East Third Ring Road,010-,Jacky),(2,神话上海分公

3、司,Myth Shanghai branch,Shanghai,perdo,徐汇区老沪闵路714号（近石龙路）,Xuhui District old humin Road No. 714 (near the Shilong Road),021-,Petro),(3,神话青岛分公司,Myth Qingdao branch,Qingdao,Rocky,青岛市市南区区太平角三路二号甲 ,Taiping City District of Qingdao City, three road No. two,0532-,Rocky),(4,神话大连分公司,Myth Dalian branch,Dalian,

4、Lee,沙河口区中山路596号,Shahekou Zhongshan Road District No. 596,0411-,Lee),(5,神话宁波分公司,Myth Ningbo branch,Ningbo,Tom,宁波市海曙区柳汀街316弄18号(妇儿医院正大门对面),Haishu District, Ningbo City, Liu Ting Street Lane 316, No. 18 (opposite the hospital front door),0574-,Tom),(6,神话北海分公司,Myth Beihai branch,Beihai,Ann,广西北海市海城区 长青北路

5、9号（环卫路）,Guangxi Beihai city Haicheng District Evergreen Road No. 9 (sanitation Road),0779-,Ann),(7,神话连云港分公司,Myth Lianyungang branch,Lianyungang,Loki,连云港市新浦区人民路19号,The people of Lianyungang City Road Sinpo District No. 19,0518-,Loki),(8,神话南昌分公司,Myth Nanchang branch,Nanchang,Peter,南昌北京东路41号(北京宾馆右侧),Na

6、nchang Beijing East Road No. 41 (Beijing Hotel on the right side),0791-,Peter),(9,神话长沙分公司,Myth Changsha branch,Changsha,Mary,湖南省长沙市芙蓉区人民西路170号,Furong district Hunan Province, Changsha City, No. 170,0731-,Mary),(10,神话温州分公司,Myth Wenzhou branch,Wenzhou,Lina,温州市瓯海区六虹桥路1207号（2号美食坊对面，森马集团旁边）,Six Hongqiao

7、Road, Ouhai District, Wenzhou City, No. 1207 (2 Food square opposite side, Semir group),0577-,Lina)-2create 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 D

8、epartment,Amanda),(3,Financial department,Amelia),(4,Human Resources Department,Anastasia),(5,The marketing department,Alexia)-3create table Designation(PositionID int primary key not null,PositionName varchar(20) not null,Assessmentperiod varchar(20) not null,JobResponsibilityDescription varchar(20

9、0)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)-4create table Employee(EmployeeID int primary key not null,EmployeeChineseName varchar(20) not null,EmployeeEnglishName varchar(20) not nu

10、ll,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,安

11、娜,Anna,Operation,Staff member,123,F,1983-01-09,A,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,A,No. 124 Nanjing road in the creative Plaza (near Hongling overpass),2011-01-03),(3,艾琳娜,Arlene,Ag

12、ent,Staff member,789,F,1985-01-24,A,No. 167 Nanjing road in the creative Plaza (near Hongling overpass),2000-04-02),(4,奥德莉,Audrey,Sale,Staff member,258,F,1982-05-09,A,No. 345 Nanjing road in the creative Plaza (near Hongling overpass),2012-09-03)-5create table EmployeeHistory(Emp

13、loyeeID 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

14、) 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,A,No. 345 Nanjing road in the creative Plaza (near Hongling ov

15、erpass),2012-09-03,2013-08-09,The accident),(4,奥德莉,Audrey,Sale,Staff member,258,F,1982-05-09,A,No. 345 Nanjing road in the creative Plaza (near Hongling overpass),2012-09-03,2014-09-09,Section)-6create table ExporterImporters(CustomerID int primary key not null,CompanyChineseName varchar(2

16、0) 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,TheBusinessLicen

17、se varchar(200) not null)insert ExporterImporters values(1,Wing,羽翼,青岛市市南区天津路15号,Qingdao City, Tianjin Road No. 15,Electronics,All kinds of electronic products,C:Program Filesduowan036.png),(2,Belinda,贝琳达,青岛市市南区天津路14号,Qingdao City, Tianjin Road No. 15,A leather bag,All kinds of bags,C:Program Filesdu

18、owan036.png),(3,Belle,贝拉,青岛市市南区天津路18号,Qingdao City, Tianjin Road No. 15,Aquatic products,All kinds of aquatic,C:Program Filesduowan036.png),(4,Bertha,柏莎,青岛市市南区天津路11号,Qingdao City, Tianjin Road No. 15,Fruits,All kinds of fruits,C:Program Filesduowan036.png)-7create table BookingAgents(CustomerID int

19、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

20、 values(1,Wing,羽翼,青岛市市南区天津路15号,Qingdao City, Tianjin Road No. 15,),(2,Belinda,贝琳达,青岛市市南区天津路14号,Qingdao City, Tianjin Road No. 15,),(3,Belle,贝拉,青岛市市南区天津路18号,Qingdao City, Tianjin Road No. 15,),(4,Bertha,柏莎,青岛市市南区天津路11号,Qingdao City, Tianjin Road No. 15,)-8create table DomesticPatners(PartnersID int p

21、rimary 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-),(2,Transport,Safety,Shandong Qin

22、gdao City Lanshan Road No. 47,Mr. Li 0532-),(3,Trade agent,Make a fortune,Shandong Qingdao City Lanshan Road No. 57,Mr. Zhao 0582-),(4,Express,Take the world,Shandong Qingdao City Lanshan Road No. 88,Mr. Wang 0536-)-9create table CountryRegister(TelephoneCode int primary key not null,TheNationalChin

23、eseName 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)-10create table OverseasAgents(TheNumberOfForeign int prim

24、ary 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,Ms. Tian 0532-),(2,xuanwu,No. 56 Yunnan

25、 Road,Ms. Qian 0532-),(3,qinglong,No. 97 Yunnan Road,Ms. Li 0532-),(4,baihu,No. 345 Yunnan Road,Ms. Zhang 0532-)-11create 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,PortOfShipmen

26、t 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,W

27、eight_1 double not null,CMB double not null,TheOperator varchar(20) not null)insert MBLs values(Exit,xurishu,maoriji,jiaomujiao,qingdao,dalian,2013-09-08,feiyu_1,20GP,2000,400,吨,200,40,biyuewu),(Imported,kangjinlong,kuimulang,niujinniu,qingdao,dalian,2014-09-08,feiyu_3,20GP,2100,300,吨,260,50,weiyuey

28、an)-12create 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(,Maintain,7895,Wing,7895,Myth branch),(,Maintain,4566,Belinda,4566,Myth branch)-13create table EmployeeSalary(StaffID int not null,ParticularYear double not null,Month_1 double not null,TheBasicWage double not null,MealSupple