|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
缺点:安全性不是太差了,还行,只要你充分利用系统自带的工具;唯一缺点就是执行效率慢,如何进行网站优化以后,效果会比较好。First,welldiscusstheeasypart.Youllhavetocreateafewforms-onefortheuserstoregister(thatis,getthemselvesintoourAuctionUserstable),andoneforsellerstoposttheirinfo.Theseformsshouldbeeasytocreateifyouknowhowtohandleforms(checkoutthisWDVLarticleformoreinformation).Basically,youshouldcollectalltheinformationfromtheformsandupdatetheappropriatetables:
Setvariablesandcreateobject
strConnectionString="DSN=MyAuction;UID=username;PWD=password;Database=MyAuctionDB"
setrst=Server.CreateObject("ADODB.Recordset")
Insertinfointoauctiontable
strSQL="INSERTINTOtblAuctions(StartDate,EndDate,SellerID)
VALUES("&Request.Form("StartDate")&","&Request.Form("EndDate")
&","&SellerID&")"
rst.openstrSQL,strConnectionString
GettheIDoftheauctionwejustentered
strSQL="SELECTmax(AID)asAIDFROMtblAuctions"
rst.openstrSQL,strConnectionString
intAID=rst(0)
rst.close
Insertiteminfo
strSQL="INSERTINTOtblAuctionItems(AID,Name,Description,"&_
"MinPrice,Increment,Available)"&_
"VALUES("&intAID&","&Request.Form("ItemName")&_
","&Request.Form("ItemDescription")&","&_
Request.Form("MinPrice")&","&Request.Form("Increment")
&_
","&Request.Form("Available")&")"
rst.openstrSQL,strConnectionString
Cleanup
setrst=nothing
Thebidsareabithardertomanage.Letslookattheseinmoredetail.
当然了,现在国内CRM厂商的产品与其说是CRM,但从至少从我的角度分析上来看,充其量只是一个大型的进销存而已了,了解尚浅,不够胆详评,这里只提技术问题 |
|