Visual C++项目开发案例精粹-光盘源码（1-10）

2010-02-03 15:37:55 gaoxin 开始登陆 2010-02-03 15:37:55 select * from AdminInfo where code='gaoxin' and pwd='1234' 2010-02-03 15:37:55 select * from AdminInfo where code='gaoxin' 2010-02-03 15:37:55 select * from AdminInfo where code='gaoxin' 2010-02-03 15:40:34 select * from CommodityType 2010-02-03 15:41:01 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:41:06 insert into CommodityInfo(barcode) values('') 2010-02-03 15:41:06 insert into StoreInfo(barcode) values('') 2010-02-03 15:41:06 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice,StoreInfo.bonus,StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:41:15 select * from CommodityType 2010-02-03 15:43:09 update CommodityInfo set typecode='yl001',barcode='001003',commoditycode='0005',memcode='mnd',spellcode='MND',name='每年达',standard='2升',unit='瓶',maxnum=50,minnum=2 where barcode='' 2010-02-03 15:43:09 update StoreInfo set barcode='001003',stockprice=4.000000,saleprice=4.000000,insiderprice=4.000000,bonus=4.000000,storenum=0 where barcode='' 2010-02-03 15:43:09 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:43:26 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:43:46 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode where CommodityInfo.barcode='mnd' or CommodityInfo.commoditycode='mnd' or CommodityInfo.memcode='mnd' or CommodityInfo.spellcode='mnd' 2010-02-03 15:43:50 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode where CommodityInfo.barcode='001003' 2010-02-03 15:44:25 update StoreInfo set stockprice=stockprice*1.000000,saleprice=saleprice*1.300000,insiderprice=insiderprice*1.100000,bonus=bonus*0.050000 where barcode='001003' 2010-02-03 15:44:53 select * from ProviderInfo 2010-02-03 15:44:58 select * from PosInfo 2010-02-03 15:45:17 insert into StockBill(stockcode,stockdate) values('20100203154517','2010-02-03') 2010-02-03 15:45:23 select code,name from AdminInfo 2010-02-03 15:45:33 select code,name from ProviderInfo 2010-02-03 15:45:47 SELECT CommodityInfo.barcode, CommodityInfo.name,CommodityInfo.maxnum, CommodityInfo.minnum,StoreInfo.stockprice,StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode where CommodityInfo.barcode='mnd' or CommodityInfo.commoditycode='mnd' or CommodityInfo.memcode='mnd' or CommodityInfo.spellcode='mnd' 2010-02-03 15:45:48 SELECT CommodityInfo.barcode, CommodityInfo.name,CommodityInfo.maxnum, CommodityInfo.minnum,StoreInfo.stockprice,StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode where CommodityInfo.barcode='001003' 2010-02-03 15:45:48 insert into StockCommodity(stockcode,barcode,stockprice,stocknum) values('20100203154517','001003',4.00,1) 2010-02-03 15:46:08 update StockBill set stockdate='2010-02-03',transactor='gaoxin',providercode='001',notes='' where stockcode='20100203154517' 2010-02-03 15:46:08 update StockCommodity set stockprice=4.00,stocknum=40.00 where stockcode='20100203154517' and barcode='001003' 2010-02-03 15:46:08 update StoreInfo set stockprice=4.00,storenum=0 where barcode='001003' 2010-02-03 15:46:14 update StoreInfo set stockprice=4.00,storenum=40.00 where barcode='001003' 2010-02-03 15:46:29 select * from StockCommodity 2010-02-03 15:46:35 select * from StockBill 2010-02-03 15:46:39 select * from StockBill where stockcode='20100203154517' 2010-02-03 15:46:41 select code,name from AdminInfo 2010-02-03 15:46:51 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:47:14 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:47:59 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:48:37 select CommodityInfo.*,StoreInfo.storenum from CommodityInfo,StoreInfo where CommodityInfo.barcode=StoreInfo.barcode and CommodityInfo.minnum>StoreInfo.storenum 2010-02-03 15:49:03 insert into SaleBill(salecode,saledate) values('20100203154903','2010-02-03') 2010-02-03 15:49:07 select code,pwd from AdminInfo 2010-02-03 15:49:10 select * from PosInfo 2010-02-03 15:49:26 SELECT CommodityInfo.barcode, CommodityInfo.name,CommodityInfo.maxnum, CommodityInfo.minnum,StoreInfo.stockprice,StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode where CommodityInfo.barcode='mnd' or CommodityInfo.commoditycode='mnd' or CommodityInfo.memcode='mnd' or CommodityInfo.spellcode='mnd' 2010-02-03 15:49:28 SELECT CommodityInfo.barcode, CommodityInfo.name,CommodityInfo.maxnum, CommodityInfo.minnum,StoreInfo.saleprice,StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode where CommodityInfo.barcode='001003' 2010-02-03 15:49:28 insert into SaleCommodity(salecode,barcode,saleprice,salenum) values('20100203154903','001003',5.20,1) 2010-02-03 15:49:39 update SaleBill set saledate='2010-02-03',transactor='gaoxin',poscode='P001',notes='' where salecode='20100203154903' 2010-02-03 15:49:39 update SaleCommodity set saleprice=5.20,salenum=5.00 where salecode='20100203154903' and barcode='001003' 2010-02-03 15:49:43 update StoreInfo set storenum=35.00 where barcode='001003' 2010-02-03 15:49:51 select * from SaleCommodity 2010-02-03 15:49:53 select * from SaleBill 2010-02-03 15:49:56 select * from SaleCommodity where salecode='20100203154903' 2010-02-03 15:50:19 select * from StockBill 2010-02-03 15:50:33 select * from StockCommodity 2010-02-03 15:50:58 select StockCommodity.* from StockCommodity,StockReturn where StockCommodity.stockcode not like StockReturn.stockcode 2010-02-03 15:51:05 select StockCommodity.* from StockCommodity,StockReturn where StockCommodity.stockcode not like StockReturn.stockcode and StockCommodity.stockcode like '201002%' 2010-02-03 15:51:23 SELECT CommodityInfo.*, StoreInfo.stockprice, StoreInfo.saleprice,StoreInfo.insiderprice, StoreInfo.bonus, StoreInfo.storenum FROM CommodityInfo INNER JOIN StoreInfo ON CommodityInfo.barcode = StoreInfo.barcode 2010-02-03 15:51:37 SELECT SaleBill.*, SaleCommodity.barcode, CommodityInfo.name,SaleCommodity.saleprice,StoreInfo.bonus,SaleCommodity.salenum from ((SaleBill INNER JOIN SaleCommodity ON SaleBill.salecode = SaleCommodity.salecode) INNER JO