Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000Vol.17No.2P.82-83



SQL SERVERPOSϵͳĿʵ
Ρ䡡軪ŷ
ժ Ҫ һPOSϵͳȽPOSն˵ƣȻ˷ƣԸϵͳõĴ洢̡OPOSȹؼۡ
ؼ ݿ POS 洢 
1 ϵͳſ
żӲķչPOS(Point of sale)۹ϵͳҲϷչԱꡢʳƷС̵ҪǲݿٿVisual Basic 5.0˻WINDOWS NT WORKSTATION/ SERVERSQL SERVER 6.5OPOS(OLE POS)POSϵͳPOSϵͳPOSնˡӡֳɨֳնˡҳʽӡ豸ӡԴӡ̵ԼõƷ룬ֳɨڷ˽Ʒɨ¼룬ֳնڽʱƷտϢ룬ҳʽӡڴӡֱPOS˵ҵյ괦ͨۡ۶ֽֽۡȣ˵ҵյҵ۹˿͹տԼϵͳϵͳĽṹͼ1ʾ

ͼ1POSϵͳ
2 POSն˵
POSն˵ĹҪ²֣
1)괦
ӪҵԱӪҵڡ׼ǮϢӪҵԱϢȷϵȡ
2)ҵ
ҵԽۣͨܽƷϢ룬Ķȡ롢Ʒ¼롢ƷŴ¼ȣ˿ͽ㼰ﵥĴӡҵ񻹿Խпķ۵Ķ˻ȡ⣬POSնˣԽиִۡ
3)ͳƽҵ
POSĸ۱ӪҵԱʵŵ۱桢Ʒ۱ȡɽֽ㣬ֽȱ١
4)յ괦
ԵݽдҪı
5)ϵͳҵ
Խ۵ϰʱ̵趨ӪҵԱıǮȡ
3 Ĺ
1)յҵ
ÿӪҵʼʱҪȿ뵱Ӫҵڡڱյ괦ʱԵݡݡݡݽдӦĽݣҪѡӦı¶ȽʱҪԶ¶Ƚ㣬õ¶ȵۡݽΪλݴ뵽ݿУµҵ¶ȱʹãѡӡƷࡢŵ¶۵ȱ档
2)۹ҵ
Ӫҵʱ϶POSն˴SQL SERVERĴʵʱмݡԿٵز鿴۱ʵʿ棬Դٱյ괦ʱ䡣յ괦ݺδյ괦ݷֱڽṹͬͬıУΪʷݡʱݣյ괦ʱֻʱݽдȫתʷݡ
ڴƷɨڷϽۣۡԺڷۣӦǼǹ˿͵ϢҪй˿͹ڽй˿͵տ
Ҫչҵ񣬻ֳնˣ˿ʹۡصݴ䵽ݿԱй
3)͹ҵ
ҵõ곤ƷĿԼԤƷĶ顢ƷĶһƷֵȱ
ҵԶԤĻнԶûжƷнʱһڽҪʱ¿Ϣ
4)ҵ
Ҫ򹩻̸ݵ¼͸õӦ򹩻̸ļ㣬Ҫ֧һ֧ԤϢȱ
5)漰̵ҵ
𻵻ҪƷҪԸƷĿݣȷض򹺽̵Ʒ̵ʱƷʵݿУʵʿ档
6)˿͹ҵ
˿͹Ҫй˿Ϣĵ¼Żݿȡ
7)տҵ
տҪʹĹ˿ͽտտݣԹ˿ΪλϢݿ鼰һտһȡ
8)ϵͳ
Ϊ˱ڶƷйƷҪšȽзűࡣҪƷĲšݡΪ˶Ҫ빩̵ݣ趨ÿ̵Ľպ͸ʽ趨ӪҵԱݡ
4 ؼо
1)ʹ
νǴ洢ݿеĴ洢̣󶨵һָݱϣڶԸñеݽָԶܹĲǲ롢ɾݸ֡
ڱϵͳУΪܶPOSն˴ݽʵʱSQLSERVER 6.5Ĵÿݼ¼Ĳ룬¹ݿ޸ƷͳݣɸƷͳݣһ¼У¡öƷÿ춼ɼ¼ݿݽʵʱ˱յ괦ʱ䡣
POSնˣڸݣҲ˴ݽʵʱͳƴ
ôʵʱС̵ҵѾ㹻ˣһ̨Դ8̨POSնˡǣڷϽƷ¼ҵʱݿбռʱҪܵض̣ҪӰʵʱӶʹǰ̨ݴֹͣǵĲУûзַ֤ǿеġԭϣĴʱҪܵض̣Ҫ̫Ĺ
2)洢̵ʹ
洢һЩSQLͿɵķװḶ́ѱͨҴ洢ݿУԺִܿСݿһ㶼ṩָЧĲѯ洢̿Էذ״̬ڵĶ
ΪPOSն˺ͷյ괦ٶȣڲҪ˻Ĵ֣ǲSQL SERVERĴ洢̣طSQL䡣ڴ洢УǻʱʱݣȻͳݡΪλĽ㴦УеĴ˴洢̡
ڱУΪʽҪٶȣҲ˴洢̡ʱݿУô洢ɱʱȻͨؼ
3)RDOʹ
Visual Basic 5.0УSQL SERVERݿкܶ෽ʽDataؼRemote DataؼODBC APIݷʶDAOԶݶRDOVBSQLȡDataؼRemoteDataؼܷ㵫ODBC APIݿ̲㡣VB SQLSQL SERVERΪVisual BasicṩķݿǿķʹߣǱҲܷ㣬ֻڰװнӦóݿʱʹáRDODAOֶݿⶼܷRDOݿٶȺܿ죬ڱϵͳУǲRDORDOͨSQLԺܷضݿеļ¼в롢¡ѯɾRDO˿ͨSQLȡҪĽ⻹ִд洢̡
ڱϵͳУPOSնˡͨRDOݿ⡣POSնˡ֮ҲRDOݿͨš
4)ֱ
POSϵͳУǳҪںֱֹ̨̣ʱΪҪǲˮCrystal ReportsFormula OneFirst ImpressionȿؼˮVisual Basic 5.0Դġˮ̼򵥵ı΢ӵıô洢̣ʱݣȻˮFormula OneFirst ImpressionɿPowerBuilderSybase˾ActiveXؼFormula OneFirst ImpressionɹVisual BasicVisual C++Power BuilderʹáFormula OneEXCELкܴǿFormula OneԺܷĻϺʹӡ临ӵıɱҪĻҳܡFirst ImpressionĻϺʹӡ൱ӵͼα
5)OPOS
΢˾ΪҵҪԸҵƳһϵнı׼磬ҵPOSΧ豸OLEӿڣPOSΧ豸̺POSϵͳ߲οʹá̵ͬPOSΧ豸Ի޸POSӦó򣬼ӦϵͳĿάԡĿǰOPOS豸׼ѾPOSӡɨPOS̡Կ˿ʾǮȳõ豸
POSϵͳ߶ԣʹOPOS豸ͬʹActiveXؼһǳ㡣
5 
ĿǰϵͳͶгڸûҪйܵǿʵ֤õƽ̨ȷĺзչǰ;ġ
ϵͳĿǰֻõ̵꣬ԼӸ죬ܵĹ̵꣬ͬҪͬӦϵͳĿ̻򹩻ϵͳԶά
ΣѧеϵCADо  116024
䣨ѧеϵCADо  116024
軪ѧеϵCADо  116024
ŷѧеϵCADо  116024
ο
1Transact-SQL Reference. Microsoft
2Database Developer's Companion. Microsoft
3Visual Basic Books Online. Microsoft
4OLE for Retail POS-Application Programmer's Guide, Microsoft
5ʯ, ֣. ϵݿ. : 廪ѧ, 1993
ոڣ1999920
