data.sql

本系统具有以下功能:商品录入&#61618 收银业务OS登陆、退出、换班与操作锁定等权限验证保护,独立作业：有的断网收银即在网络服务器断开或网络不通的情况下

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','')