Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000Vol.17No.5P.90-92



ʳӹҵϵͳĿ
ŷŷ
ժ  Ҫ  ˿ʳӹҵϵͳĹؼ⣬˻ڿͻ/ṹЩ˼롢
ؼ  ϵͳ  ͻ/  ݿ   ݴ
0  
ҹгõγɺƣгҡʺܵ͵ĴʳӹҵҪϿгڲ֮أ˼ǿҵڲɱ֮⣬ǿۺ۹ˣӦ۹ϵͳԵΪҪһʵ۹Ϣִʹź쵼ܹʱ׼ȷ˽ҵһԼʱ׼ȷ۹иڵľг仯Ϊż쵼߽оṩʱ׼ȷϢݡһЧضžٵƱӶϢĲ׼ȷʱɵʧ
1  ϵͳ
ͨϷ()ɷ޹˾͹۳ʵҵ̵ȫ桢롢ϸо󣬵óʵҵͼ1ʾ

ͼ1ֹҵҵͼ
УؼĴǷƱĴƱҪճ()ƱƱעͳ֡
ҵ۹пķƱͨƱֵ˰ƱڷƱͨ͡ƱΪ˰Ͳ˰֡Ƿ˰Ʊ޶ΪԪֵ˰Ʊ޶ԪʮԪͰԪ֡һַƱƱܽܳӦ޶
(1)  Ʊ
һǸݿͻҪ󿪾ӦķƱڴ㣬ڵΪ俪ҪķƱĿͻҪƱдԼ֣Ҫ󣬵԰㡣
õһͻȿᵥȿ֤Ժٸݿᵥ֤ͻҪ󲹿Ʊ
رأݿͻҵʡƷ֡Լڵı仯¿̶ܲͬȵŻݡ
ͬһͻڲͬʱ乺ͬƷֵĻ
ͬһͻͬʱ乺ͬƷֵĻ
ͬĿͻͬʱ乺ͬƷֵĻ
ͬĿͻڲͬʱ乺ͬƷֵĻ
ˣΪ˱պ˽гҪͻϢ磺ơСʺšϵҵϢ¼ԷʹúͲѯͬʱӦҵй쵼۲Ÿ˻йҵԱǩ(ȷ)ߵĿͻŻݷ¼Աڸͻ߷ƱʱܹܵӦŻݷ
(2)  Ʊע
ߵĻֽʱнۡ(ͬĻ򻻲ͬĻ)˻(˻ȫ˻)ִг˽еĲлͬĻ治ӳ⣬Ҫ淴ӳ
еĽ۴취ǣδעԭƱؿ 
еȫﴦ취ǣȫ壻δˣע
е˲ֻͻͬĻ취ǣˣȫ壻δˣעؿ
ƱעʱڷƱϼӸɫĴСעĴעķƱڼʱԡʱúֳ֡
ͨƱԳҲȫ塣ֵ˰Ʊܳֻȫ塣Ҫȳֵ˰Ʊٿһֵ˰Ʊʣֵ˰ƱȻȫֵ˰Ʊ
ᵥֵ֤ҲƵĴҪϵͳͼ2ʾ

ͼ2ϵͳνṹͼ
2  ϵͳʵ
ǰĹؼĴϵͳƺʵֹУûWindows NTĿͻ/ṹӷͿͻԽ
2.1  ϵͳӦû
ͨʵҵķۺϷáķԡϢİȫԺϵͳչԵأϵͳĿӦûûWindows NTĿͻ/ṹеĿݼд洢ڷУӶʵֶݵĶάͱԼݵԡͰȫԷṩϸļпơվӦóݲѯ²󣬷ܲ󲢰Ѵ͸վ
ѡMicrosoft SQL Server 6.5ȣǻWindows NTʹõWin32ϵͳ̶߳ģݿںе̣߳ӵWin32̵߳Զ̴߳ǿֱ֧֡ӲʺͶԲ̵ͬ߳ڴ汣Ӷʹüʹе߳ëҲִSQL Server 6.5ܹ߳ҼִСΣSQL Server 6.5֧Windows NTֵ֧Э飬Ӷּ֧κĿͻSQL Server 6.5ķñĴ͹ϵݿƷҪ͵ö࣬ױܡ
ͻ˿ѡPowerBuilder 6.0һĿͻ/ߣWindowsϵСMacintoshSun Solarisȿƽ̨С⣬зļɿرṩĹǿݴ(DataWindow)ͨʹݴڼ佻ܣԱԷݴ棬ʵֶݿĸֲݼ롢ɾԼҪĸʽʾݡӶԴٳд͵Թ߿Чʣ̿ڡ
2.2  ƵĹؼ
ڷ˵ƺʵУҪؼľݿơݿƵĻͺݿбĶ塣ĺûӰ쵽ݿĶ壬Ӱ쵽ϵͳܺˣֽζñԲ
ݿĶԷõͼֵΪԸṹõE-RͼΪݽеģӦǹ淶ġǣʵӦϵͳıɹ淶ıھϵͳĹܺҪƣȱݺͲ㡣ЩȱݺͲҪڣ
ڹ淶ıҪϢӶϵһ𡣶ҪI/O
淶ıʱҪCPUԴִ߼άݺԣ˻CPU
淶ıûժҪݣΪժҪݴΥ˹淶ǶϢԼûж塣Ϊ˴ժҪݣҪоۺϴӶCPUI/Oʡ
ڹ淶ıУԷӳϵͳԱݵضҪ
Ϊ˽淶ڵȱݺͲ㣬ϵͳڱĶʱһΥ淶Ҫɷǹ淶ġķǹ淶Ļ࣬ķУ
ʵӱھҪʹáԱ仯СĳЩʵԳⶨһЩЩݱӵıСڱϵͳнĻšơ񡢼λⶨɻĿ¼һڸֵݴʱ漰ʱԵʽṩߣ¼ٶԼݵԴһЧر֤ݵԺͱϵͳԱݵά
ķֽ⡣Ϊ˷㴦ͼٴI/OʵʹеıݵʹƵȺ;ĴҪֽɼ籾ϵͳķƱһŷƱԿһֻֻҿɼνˣʵʵһŷƱڶʱֽinvoice_table(Ʊ)invoice_volue(Ʊݱ)invoice_charge(Ʊ)invoice_no(Ʊ)invoice_table
ΪСΪаΪؼСʶкַʽ
ͻϵͳΪ(serial_no)ΪؼֲԴ˽ڱ¼ʱɴ봦ɶɲİ취Ψһ⡣
ʶΪ˷ӳϵͳԱݵضӵС籾ϵͳΪ˱ʶעͳִӦݵע(discard _or)ͳ(against_or)Աʶinvoice_volue(write_or)(write_out)ʶƱеĳֻǷᵥǷꡣһأʶжbinary͡
Ϊ˱⴦ʱظI/OCPUӵС緢ƱܽڸֲѯͳʱҪƵʣݿͨinvoice_noinvoice_volueõݹ淶ҪӦȥġʵʿʱinvoice_tableЩУ뱣浽ݿʱһβڱУԺÿμѯͳʱͲҪͨӼöֱӵõ
2.3  ͻƵĹؼ
PowerBuilder 6.0ͻӦóʱӦóPowerBuilder 6.0ݴڼ佻ܡڿеĹؼһݴݿύʱ֤ͬȶԱĸҪô£ҪôһҲ¡ԿƱΪ˵˼Ͱ취
忪Ʊݴd_invoiceͶӦݴڿؼdw_invoiced_invoiceԴΪinvoice_tableinvoice_voluegoods_count_table(ʴ)ѡȫinvoice_tableжѡСڴݴڶʱinvoice_tableΪ޸ĵģΪ޸ĵġ
ڸ¸ʱȸinvoice_table ȻModifyθıѸ±еupdateΪNO趨Ҫµı޸ıеupdateΪYESеı³ɹCOMMITύɶӦĸ¡&quot;ύ&quot;ťClicked¼еĴ£
integer  update_num
//޸invoice_table,޸ݴڶʱΪ޸
update_num=dw_invoice.update(TRUE,FALSE)
if  update_num=1  then 
dw_invoice.Modify(invoice_table.invoice_no.update=NO)
dw_invoice.Modify(invoice_table.invoice_date.update=NO)
//Ƶʽرinvoice_tableеupdate
dw_invoice.Modify(DataWindow.table.updateTable=
invoice_volue)
//ʹinvoice_volueɸҴ򿪱еupdate
dw_invoice.Modify(invoice_volue.invoice_no.update=YES)
dw_invoice.Modify(invoice_volue.serial_no.update=YES)
  
//invoice_volue
update_num=dw_invoice.update( )
if  update_num=1  then
dw_invoice.Modify(invoice_volue.invoice_no.update=NO)
dw_invoice.Modify(invoice_volue.serial_no.update=NO)
//Ƶʽرinvoice_volueеupdate
dw_invoice.Modify(DataWindow.table.updateTable=
goods_count_table)
//ʹgoods_count_tableɸҴ򿪱еupdate
dw_invoice.Modify(goods_count_table.goods_no.update=YES)
dw_invoice.Modify(goods_count_table.goods_name.update=YES)
  
//goods_count_table
update_num=dw_invoice.update( )
if  update_num=1  then
COMMIT USING SQLCA;  //б޸ĳɹύ
dw_invoice.Modify(goods_count_table.goods_no.update=NO)
dw_invoice.Modify(goods_count_table.goods_name.update=NO)
//Ƶʽرgoods_count_tableе
//update
dw_invoice.Modify(DataWindow.table.updateTable=
invoice_table)
//ʹinvoice_tableɸһָеupdate 
dw_invoice.Modify(invoice_table.invoice_no.update=YES)
dw_invoice.Modify(invoice_table.invoice_date.update=YES)
  
cb_continue.enabled=true//ťЧ 
Else
ROLLBACK USING SQLCA;//޸Ĳɹе޸
End if
Else
ROLLBACK USING SQLCA;
End if
Else
ROLLBACK USING SQLCA;
End if
ŷ(֣ʳѧԺѧϵ  ֣ 450052)
ŷ(۳   541003)
ο
1ʦ,   ɺ. ݿϵͳ(ڶ). : ߵȽ, 1997
2D.Solomon, R.Rankins, ܹϲ,   , ѧ. SQL SERVER 6.5ָ(ڶ). : 廪ѧ, 1998
3. PowerBuilder 6.0Ӧ뿪. : 廪ѧ, 1998
4ų,   , 櫱. PowerBuilder 6.0ûοֲ. ϣԹ˾, 1998
5Simon Gallagher, Simon Herbert. . PowerBuilder 6.0ƴȫ. :еҵ, 1998
ոڣ1999-11-18
