data.sql

VB 编写的"华成POS管理系统",代码全,没有进行测试,数据库全,有兴趣的朋友可以测试.

insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('百事','add1','06124')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('长虹','add2','32564')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('青岛啤酒','add3','54876')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('蒙牛','add4','69875')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('徐福记','add5','23456')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('a','add1','06124')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('b','add2','32564')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('c','add3','54876')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('d牛','add4','69875')
insert Factory(FactoryName,FactoryAddress,FactoryPhone) values('e','add5','23456')

insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('A1','address1','72531')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('A2','address2','75643')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('B1','address3','73689')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('B2','address4','78132')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('C1','address5','71359')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('D1','address55','725531')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('E2','address6','756343')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('F1','address7','731689')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('G2','address8','781632')
insert Provide(ProvideName,ProvideAddress,ProvidePhone) values('H1','address9','713529')

insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch1',2,'1359','100',20,'1000001',1,'2005.3.10','2005.4.10','0','1','7','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch2',4,'280','40',20,'1000002',3,'2005.2.15','2005.3.15','0','1','8','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch3',150,'90','10',20,'1000003',105,'2005.5.10','2005.7.10','0','1','4','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch4',3500,'200','20',20,'1000004',2888,'2005.3.01','2005.5.31','0','1','8','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch6',12000,'80','10',20,'1000006',10000,'2005.7.01','2005.8.31','0','1','8','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch8',5,'2000','100',20,'1000008','0','1','7','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch9',50,'690','50',20,'1000009',38,'2005.3.10','2005.4.20','0','1','9','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch10',8,'2800','100',20,'1000010',6.5,'2005.5.10','2005.7.10','0','1','3','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch11',12,'15','50',20,'1000011','0','1','7','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch12',6,'1800','100',20,'1000012',4.5,'2005.5.10','2005.7.10','0','1','6','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch13',5,'2000','100',20,'1000013','0','0','9','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch15',8888,'300','50',20,'1000015',6999,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch16',60,'700','50',20,'1000016',55,'2005.6.01','2005.8.31','1','1','9','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch18',50,'900','100',20,'1000018',45,'2005.3.10','2005.5.30','1','1','7','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch19',8,'2000','150',20,'1000019','1','1','7','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch20',22,'500','100',20,'1000020',18,'2005.7.10','2005.8.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch21',2500,35,50,20,'1000021','1','1','8','2')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch22',55,'500','80',20,'1000022',50,'2005.6.10','2005.7.31','1','1','9','1')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch23',30,'1000','100',20,'1000023',26,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch24',9,'1500','100',20,'1000024',6,'2005.8.10','2005.9.30','1','1','8','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch25',6,'2000','150',20,'1000025',5,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch26',400,'500','50',20,'1000026','1','1','8','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch27',80,'300','50',20,'1000027',70,'2005.4.10','2005.5.15','1','1','7','4')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch28',280,'500','100',20,'1000028',260,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch29',48,'800','50',20,'1000029',40,'2005.6.10','2005.7.31','1','1','10','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch30',6888,'300','50',20,'1000030',5999,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch31',68,'800','100',20,'1000031',59,'2005.7.10','2005.8.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch32',9,'1300','100',20,'1000032',7,'2005.4.10','2005.7.31','1','1','9','3')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch33',80,'900','50',20,'1000033',68,'2005.6.10','2005.7.31','1','1','8','5')
insert MerchInfo(MerchName,MerchPrice,MerchNum,CautionNum,PlanNum,BarCode,SalesProPrice,SalesProDateS,SalesProDateE,AllowAbate,AllowSale,FactoryID,ProvideID) values('Merch35',2888,'300','50',20,'1000035',2000,'2005.6.10','2005.7.31','1','1','8','5')

insert Member(MemberCard,TotalCost,RegDate) values('2003007',2000,'2003.5.30')
insert Member(MemberCard,TotalCost,RegDate) values('2004007',1000,'2004.6.01')
insert Member(MemberCard,TotalCost,RegDate) values('2005135',5000,'2005.2.15')
insert Member(MemberCard,TotalCost,RegDate) values('2005246',1500,'2005.3.10')
insert Member(MemberCard,TotalCost,RegDate) values('2005357',6888,'2005.6.20')

insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.3.20','200',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('6','2005.3.25','1',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('8','2005.3.26','280',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('9','2005.3.22','50',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.20','68',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('16','2005.4.25','20',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.28','55',1.5)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.4.30','35',2)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values('27','2005.5.15','20',20)
insert Sale(MerChID,SaleDate,SaleNum,SalePrice) values(1,'2005.6.20','10',2)

insert [User] values('Admin','21232F297A57A5A743894A0E4A801FC3',4)
insert [User] values('赖秋林','9D607A663F3E9B0A90C3C8D4426640DC',2)
insert [User] values('阿年','894F782A148B33AF1E39A0EFED952D69',3)
insert [User] values('凌聪','8A8BB7CD343AA2AD99B7D762030857A2',1)
insert [User] values('翁炎泉','693A9FDD4C2FD0700968FBA0D07FF3C0',1)

insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(200,'2003-3-20','2003007','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(12000,'2003-3-25','','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(40,'2004-3-26','2005135','')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(150,'2004-3-22','','凌聪')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(60,'2005-4-20','2005246','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(300,'2005-4-25','','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(200,'2005-4-28','2004007','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(90,'2005-8-15','2003007','')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(240,'2005-9-2','2005135','翁炎泉')
insert Dealing(DealingPrice,DealingDate,MemberCard,UserName) values(160,'2005-9-7','2003007','')