΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000Vol.19No.6P.45-47




ߵϵͳʵ

ժҪӦݿPowerBuilderߵϵͳ˼ʵַ
ؼʣ ʵ塪ϵģ ݴ
ҵĲƷûȫ˽ҵƷҪ;żķչӦõռҵƷز㼯ɲᣬԵʽṩûѳΪһʱС
ڻеӹӲʺϽתλƬһֹ㷺ʹõľнϸ߾ЧĵߡûݲͬӦóϡͬʹͬļӹԼԹӹȵĲͬҪҪӸʽĵƬʽѡߡ൶ƬиӵάͽṹͬĲвͬ÷Χ뵶ƬйصĲȽ϶࣬ݹϵҲϸӡӲʺϽתλƬϵлƷΪƳһֵߵϵͳ̽˿һЩƻڡ
1  ϵͳҪ
1.1 ѡ
ϵͳPowerBuilder(¼PB)ơPBPowersoft˾ƳĻڿͻϵṹĿӻٽʽߡPBֳ֧ĸݿ⣬ֱSybaseSQL ServerOracleȴݿϵͳͨݿ⻥(ODBC)xBaseAccessExcelСݿϵͳPBVBCԻıԡPowerscriptܽƵֶ֧ķװ̳Уһּһµķʽݸݿ⣬ӶڽӦóһݿֲһݿ⡣PBصݴڼ൱޸ġ¡롢ɾҳӡ11ļʽеκһַʽݡΪһҪݿǰ˿ĹߣPBļ͸Чص㡣
1.2 ģ
ģͷӳ˿͹ʵʵ֮ĸڲϵⲿϵʵʵ֮ĹϵɳΪ111MMNӳϵڶ͹缰ϵģУȽϼˡʹ÷Чʵ塪ϵģ(ֳERģ)ʵ塪ϵģͼԳαʾʵ壬Բʾʵԣαʾʵ֮ϵʵ塪ϵģ͵ĹؼȷʵԺʵĹϵ
ڽûĻϣߵϵͳʵ塪ϵģͼ1ʾ

ͼ1  ߵϵͳʵ塪ϵģ
1.3 ݿṹ
ʵ塪ϵģΪмģʹõģһ㻹뽫תΪݿϵͳ(DBMS)ֵ֧ģ͡ǽΪϤݱʾʽϵģݿһṹ򵥡߼ܵĶάƽ̻ʵĹϵҪ󿪷ԱϾ淶ƹϵģʽùϵģ͵ŵڣ
(1)ݽṹ򵥣ûвλ״ģд۸ӵָ룻
(2)ֱӴMNĹϵ
(3)ܹһṩ1Ԫ鼯ϣ
(4)кܸߵݶԡ
ڽ߼ϵֶ֯ɱĹУע¶㣺
(1)ӦƵϢ1űУʹеֵֶ
(2)Ӧܼ
1Ϊߵϵͳеļӹϱṹ
1  ӹϱṹ
ֶݿȿɷΪ
NULLע
ӹϴ4
ӹ3
ַ10
ӹַ20ɡ

üӹΪӹϵϢ淶ͼϢ洢
2  ϵͳʵ
ûѺó̶ȶڵƹʹҪPBûӿڽ漰ʵӦܷʮֳɫԱԲ÷ḻĿؼ塢ԶԻȣдѸٹӦó档PBݴдSQL伴ܲϵݿݡֹͨǿݴڣԶÿݿıвѯ롢ɾ£Ϊָ༭ʽʾ񣬲ӸֶƱĸϢͳͼԼɱȡ
ߵϵͳҪʵܣ
(1)ֵƬϢ
ڳֵƬϢ棬Ҫ̳дͳӡˢģʽҪӦʾݵķʽ뵶ƬĳһйصϢӦе1Уþ̬ıϿб񲿼ΪõĿؼ磬ߵļνǶȣͼƬʾ⣬ɽеĽǶȲԵӱʽгԱڶԱȡ⣬ƼѡͼǶһͼ۵İťڽУӦֻڣӦżصԭ򣬸ʵݸʽýϺõݱַʽ
(2)ѯ
ûѡƬʱѯǸȤĲ˽õƬȫϢPBýṹѯSQLݵķʡ롢޸ġ塣ϵͳûм򵥲ѯȷѯģѯѯȡ
磺ҪѯӲʺϽٶ100200 mminԲƬ(ӹʹΪ10)ʵִΪ
SELECT ChipCode FROM
CompanyTableCuttingConditionTable
CuttingCaseTable
WHERE
CompanyTable.ChipCode
CuttingConditionTable.ChipCodeAND
CompanyTable.ChipCode
CuttingCaseTable.ChipCodeAND
CompanyTable.CompanyName
ӲʺϽ𳧡AND
CuttingConditionTable.CuttingSpeed100AND
CuttingConditionTable.CuttingSpeed200AND
CuttingCaseTable.ManuClassCode10
ORDER BY ChipCode
(3)ӡ
ûͨõƬľ⣬ϵͳṩӡܣ߼ϵԱʽӡҪڴйݴڶʱ豨ĸʽݴڡɽݷֳɵ飬ݽм֯ԶʽͼƬȡΪͬʱӡݴڶʵִ룺
int PrintJob
PrintJobPrintOpen(Chip Reports)
If PrintJob1  Then
MessageBox(ӡʧܡ壬岻ܽбӡ)
Return
Endif
Print DataWindow(PrintJobdwCompany)
Print DataWindow(PrintJobdwCuttingCondition)
Print DataWindow(PrintJobdwCuttingCase)
PrintClose(PrintJob)
(4)
õûϤıҪ֤WindowsµİļĴһ²裺
ٴļԴļļҪRTFʽ棻
ðļ༭Ŀ¼ļԷűʽŸҳϵ
۴ĿļйRTFļBMPļAVIļӵĿļУȻɰļ(hlpļ)Ŀ¼ļ(cntļ)
ӦóӦ¼еShowhelp()WindowsϵͳWinhelp򣬴Ӧļ̡
ӦָܴļĹ̲ӣļ֯ȴ̫סϵͳȫʵ֮ȥдļɰӦϲܵԣʵϵͳĳֲܵʱӦͬǰļ֯׫д
3  ϵͳķкά
йضĶ塢ĴԪصüƺ͵Եȹ󣬵ߵϵͳкͷ׶ΣɿִļPowerBuilderĿСӦóϴ(2MB)Ӧóĳֶɿǲö̬ļ(PBDļ)ӶɼٿִļĴСЧʣҲڳά͹Ӧóжָ̬ԴݴڶӦӦԴļ嵥(PBRļ)Щļл֯󣬾ɿִļսûļҪУ
(1)ִļ(EXEļ)
(2)漰Ķ̬ļ(PBDļ)
(3)δԴļ嵥еԴļ(λͼļͼļļ)
(4)Ӧóļ(INIļ)
(5)ļ(HLPļCNTļ)
(6)PowerBuilderӦóĶ̬ӿļ(DLLļ)
(7)ʹõݿϵͳ
ЩļӦװɰװʽṩû
һӦϵͳܵӡЧʵĸߵҪûоӦϵͳйУûһЩµͽ顣бҪûı仯ʱԵӦϵͳһ޸ģʹһõƺߡͬʱ²ƷʱҪǰһԡԡ
1Ӧǰ൱ݿӦĳֽظıûѡƷķʽǿInternetΪҵṩµ۷ʽĲPowerBuilderߵϵͳһ㷽ͻ裬ŵоؽżݿ⼼ķչȥ
人ѧеѧ빤ѧԺ430074
ࣨ人ѧеѧ빤ѧԺ430074
ο
1ʦӣɺݿϵͳۣߵȽ磬1991
2ţݿϵͳ人ѧ磬1993
3Hatfield BPowerBuilder 5Ӧó򿪷ָϣ ѧ磬1997
4ֵùңPowerBuilder 60Ӧÿָϣ ʵ磬1998
ոڣ19991226
