物流管理系统源代码

createdatabaseMythuseMythgo--1createtableBranches(BranchIDintprimarykeynotnull,ChineseNamevarchar(200)notnull,EnglishNamevarchar(200)notnull,Cityvarchar(200)notnull,RegisteredCapitalnvarchar(20)notnull,CompanyDirectorvarchar(200)notnull,ChineseAddressvarchar(200)notnull,EnglishAddressvarchar(200)notnull,TheFrontDeskPhonenvarchar(20)notnull,LegalRepresentativevarchar(20)notnull,Remarksnvarchar(200))insertBranchesvalues(1,'神话北京分公司','MythBeijingbranch','Beijing',1000000,'Jacky','北京市朝阳区东三环中路34号','BeijingCity,ChaoyangDistrictNo.34EastThirdRingRoad',010-52076666,'Jacky'),(2,'神话上海分公司','MythShanghaibranch','Shanghai',2000000,'perdo','徐汇区老沪闵路714号（近石龙路）','XuhuiDistrictoldhuminRoadNo.714(neartheShilongRoad)',021-67286888,'Petro'),(3,'神话青岛分公司','MythQingdaobranch','Qingdao',3000000,'Rocky','青岛市市南区区太平角三路二号甲','TaipingCityDistrictofQingdaoCity,threeroadNo.two',0532-86120011,'Rocky'),(4,'神话大连分公司','MythDalianbranch','Dalian',4000000,'Lee','沙河口区中山路596号','ShahekouZhongshanRoadDistrictNo.596',0411-84331888,'Lee'),(5,'神话宁波分公司','MythNingbobranch','Ningbo',4000000,'Tom','宁波市海曙区柳汀街316弄18号(妇儿医院正大门对面)','HaishuDistrict,NingboCity,LiuTingStreetLane316,No.18(oppositethehospitalfrontdoor)',0574-87165778,'Tom'),(6,'神话北海分公司','MythBeihaibranch','Beihai',3000000,'Ann','广西北海市海城区长青北路9号（环卫路）','GuangxiBeihaicityHaichengDistrictEvergreenRoadNo.9(sanitationRoad)',0779-2231888,'Ann'),(7,'神话连云港分公司','MythLianyungangbranch','Lianyungang',2000000,'Loki','连云港市新浦区人民路19号','ThepeopleofLianyungangCityRoadSinpoDistrictNo.19',0518-85688877,'Loki'),(8,'神话南昌分公司','MythNanchangbranch','Nanchang',2000000,'Peter','南昌北京东路41号(北京宾馆右侧)','NanchangBeijingEastRoadNo.41(BeijingHotelontherightside)',0791-88139333,'Peter'),(9,'神话长沙分公司','MythChangshabranch','Changsha',1000000,'Mary','湖南省长沙市芙蓉区人民西路170号','FurongdistrictHunanProvince,ChangshaCity,No.170',0731-85952777,'Mary'),(10,'神话温州分公司','MythWenzhoubranch','Wenzhou',1000000,'Lina','温州市瓯海区六虹桥路1207号（2号美食坊对面，森马集团旁边）','SixHongqiaoRoad,OuhaiDistrict,WenzhouCity,No.1207(2Foodsquareoppositeside,Semirgroup)',0577-86189999,'Lina')--2createtableDepartment(DepartmentIDintprimarykeynotnull,DepartmentNamevarchar(20)notnull,departmentManagervarchar(20)notnull)insertDepartmentvalues(1,'ExportDepartment','Alma'),(2,'ImportDepartment','Amanda'),(3,'Financialdepartment','Amelia'),(4,'HumanResourcesDepartment','Anastasia'),(5,'Themarketingdepartment','Alexia')--3createtableDesignation(PositionIDintprimarykeynotnull,PositionNamevarchar(20)notnull,Assessmentperiodvarchar(20)notnull,JobResponsibilityDescriptionvarchar(200))insertDesignationvalues(1,'Operation','Alma'),(2,'Linelength','Amanda'),(3,'Agent','Amelia'),(4,'Thesectionchief','Anastasia'),(5,'Sale','Alexia'),(6,'Companydirector','Andrea')--4createtableEmployee(EmployeeIDintprimarykeynotnull,EmployeeChineseNamevarchar(20)notnull,EmployeeEnglishNamevarchar(20)notnull,Departmentvarchar(200)notnull,Positionvarchar(200)notnull,BossIDintnotnull,sexvarchar(20)notnull,DateOfBirthnvarchar(20)notnull,PhoneNumbernvarchar(20)notnull,Mailboxnvarchar(20)notnull,Addressvarchar(200)notnull,JoinDatenvarchar(20)notnull)insertEmployeevalues(1,'安娜','Anna','Operation','Staffmember',123,'F','1983-01-09',13728679810,'[e-mail]','No.1NanjingroadinthecreativePlaza(nearHonglingoverpass)','2010-09-08'),(2,'艾谱莉','April','Linelength','Staffmember',456,'F','1980-03-02',18677899018,'[e-mail]','No.124NanjingroadinthecreativePlaza(nearHonglingoverpass)','2011-01-03'),(3,'艾琳娜','Arlene','Agent','Staffmember',789,'F','1985-01-24',15988765781,'[e-mail]','No.167NanjingroadinthecreativePlaza(nearHonglingoverpass)','2000-04-02'),(4,'奥德莉','Audrey','Sale','Staffmember',258,'F','1982-05-09',15678909872,'[e-mail]','No.345NanjingroadinthecreativePlaza(nearHonglingoverpass)','2012-09-03')--5createtableEmployeeHistory(EmployeeIDintnotnull,EmployeeChineseNamevarchar(20)notnull,EmployeeEnglishNamevarchar(20)notnull,Departmentvarchar(200)notnull,Positionvarchar(200)notnull,BossIDintnotnull,sexvarchar(20)notnull,DateOfBirthnvarchar(20)notnull,PhoneNumbernvarchar(20)notnull,Mailboxnvarchar(20)notnull,Addressvarchar(200)notnull,JoinDatenvarchar(20)notnull,TurnoverDimenvarchar(20)notnull,ReasonForLeavingvarchar(200)notnull)insertEmployeeHistoryvalues(4,'奥德莉','Audrey','Sale','Staffmember',258,'F','1982-05-09',15678909872,'[e-mail]','No.345NanjingroadinthecreativePlaza(nearHonglingoverpass)','2012-09-03','2013-08-09','Theaccident'),(4,'奥德莉','Audrey','Sale','Staffmember',258,'F','1982-05-09',15678909872,'[e-mail]','No.345NanjingroadinthecreativePlaza(nearHonglingoverpass)','2012-09-03','2014-09-09','Section')--6createtableExporterImporters(CustomerIDintprimarykeynotnull,CompanyChineseNamevarchar(20)notnull,CompanyEnglishNamevarchar(20)notnull,CompanyChineseAddressvarchar(200)notnull,CompanyEnglishAddressvarchar(200)notnull,ContacTelephoneNumbernvarchar(20)notnull,Faxnvarchar(20)notnull,TheMainProductsvarchar(200)notnull,Description_1varchar(200)notnull,TheBusinessLicensevarchar(200)notnull)insertExporterImportersvalues(1,