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,
VB+sql小型超市管理系统
需积分: 1 44 浏览量
2024-06-15
09:24:58
上传
评论
收藏 490KB RAR 举报
VB+sql小型超市管理系统 （116个子文件） 
modMD5.bas 14KB modMD5.bas 14KB modSQL.bas 2KB modMain.bas 2KB modLvTimer.bas 1KB Module1.bas 366B link.bas 233B modSQL.bas 30B 注册.bat 19B
登陆.bmp 1KB XPButton.ctl 117KB FTextBox.ctl 16KB XButton.ctl 16KB FatCombo.ctl 12KB XPButton.ctx 786B FatCombo.ctx 118B Thumbs.db 20KB Thumbs.db 9KB Thumbs.db 7KB drPlanStock.DCA 48KB drSale.DCA 48KB DataReport1.DCA 46KB DataEn1.DCA 4KB drPlanStock.Dsr 15KB drSale.Dsr 14KB DataReport1.Dsr 9KB DataEn1.Dsr 5KB drPlanStock.dsx 23B drSale.dsx 23B
数据新建.exe 10KB XPMenu.exp 975B frmMerch.frm 41KB frmSale.frm 31KB frmMain.frm 30KB frmStock.frm 26KB frmMember.frm 22KB frmMerchItem.frm 22KB frmFP.frm 21KB frmUser.frm 20KB frmPlanStock.frm 10KB Form8.frm 9KB frmToStock.frm 9KB frmLogin.frm 9KB frmServer.frm 9KB pay.frm 7KB quickinput.frm 7KB frmMain.frm 6KB Frmlog.frm 5KB frmWelcome.frm 2KB FrmFront.frm 449B frmWelcome.frx 389KB frmLogin.frx 70KB frmMain.frx 37KB frmMerch.frx 9KB frmUser.frx 7KB frmFP.frx 5KB frmStock.frx 4KB frmMember.frx 3KB frmPlanStock.frx 1KB frmServer.frx 12B frmSale.frx 12B frmToStock.frx 12B frmMerchItem.frx 12B frmMain.frx 12B 程序图标.ico 4KB 用户管理.ico 3KB 销售管理.ico 3KB 会员管理.ico 3KB 厂商,供应商.ico 3KB 库存管理.ico 3KB 进货管理.ico 3KB 大程序图标.ico 2KB ak.ico 2KB 1.ico 1KB 用户1.ico 1KB pp.ico 1KB 用户2.ico 1KB 会员2.ico 1KB 退出程序.ico 1KB 销售.ico 1KB 进货.ico 1KB 厂商.ico 1KB 供货商.ico 1KB 会员1.ico 1KB 退出.ico 1KB 登陆.ico 1KB 入库.ico 1KB 关于.ico 1KB 用户.ico 1KB 上一记录.ico 1KB 下一记录.ico 1KB 首记录.ico 1KB 尾记录.ico 1KB point3.ico 894B point1.ico 894B point4.ico 894B point2.ico 894B user.inf 72B sql.inf 46B XPMenu.lib 3KB共 116 条
- 1
- 2
资源评论
