΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
2000Vol.19No.4P.42-44



ڣ£ӺͣãӵĹڵϵͳ
ظ컪
ժ Ҫ һڣ£ӺͣãӵĹڵϵͳʵֹ̣漰ڶ༼ĽӦ꾡Ĳ
ؼʣ ףţ ڵϵͳ  ͻ
缼͹㷺ӦãԼΪͨŷʽ𽥱ܡϢĽѧ뵽֮СǸEmailйͨΪŴͳż޷ŵ㣬ʡʱʡǮʡȡ
EmailռҵѧУصȸ˲ż۵صĹ㷺ӦãϵƶȥĽһЩطӦµĹͨʽڵǶԴͳĹ͸ĽEmailıݣ͵䲻ֻǵϢռŸΪϢͨ뷴ܡ
ṩһʵüϵͳʵʩ˾ѧУֻҪԼľ1̨NTϿͨڵ䡣ǵҪṩǿżܺͷֹǷûϵĲǲBrowseServerClientServerϵķʽϵͳͼ1ʾ

ͼ1ϵͳĹ
ѿɹͬôѧѧԺԺ䡱Ϊϵͳʵֵľ岽裨ʵеضںĳУ
1
ѡMicrosoft˾ϵвƷΪϵͳĿƽ̨ΪΪļװWindowsNT Server 40NTԴIISInternet Information Server20Microsoft mailʾ־ͿΪWEBEmailȻװSQLServerΪݿڷϽ2Ŀ¼DwebDpostֱΪWEBļʾֵŵء
11WEB
ڷʼ˵ҵMicrosoft Internet ServerInternetк˫WWW롰WWWԡڣڡĿ¼ҳеӡ롰Ŀ¼ԡڣĿ¼дDwebѡȡĿ¼ѡѡִСصWWWԡںȷϡĬĵΪdefaulthtmʱھκ1̨URLַ롰httpIPַDwebĿ¼µdefaulthtmļվҳҪʾURLַҪNTеIPַӳھġ壯磯TCPIPԣDNSáġDNS˳ӱIPַ
12ݿ
ڷʼ˵СMicrosoft SQL ServerSQL Enterprise ManagerDatabase Device½һ豸SemdeviceȻDatabaseSemdeviceΪ豸һݿSEMMISݿ⽨úҪóԴڡ壯ODBCӡϵͳԴDSNData Source NameΪSemServerΪLocaloptionDatabase NameΪSEMMIS
13Email
Microsoft Mail1ʼϵͳҪշEmailҪ1ʾֲΪʾûȻΪÿû1ļָżͨ¼ĴŵءûѡôļռʱܿԼݡ
ڷ塱д򿪡Microsoft mailʾ֡ѡ񡰴µĹʾ֡²ʾ·ΪDpostעȽΪĿ¼ϵͳԶ´1Ϊwgpo0000Ŀ¼ָԱϢڡʾֹûûΪռˣ˱ʶ䡱ӦóʾַʼʱõҪ
Ϊռ䣨outlookпʾûżҪáļų̂շEmailҪ̨ΪļҪעͬһʾûڲͬϵļҪʹͬ1ļļpst͸ͨ¼ļpabļù£ڡ塱д򿪡ʼʾļӡMicrosoft Exchange Setup WizardڣѡMicrosoft MailûаװExchange ServerҲûInternetϵEmailʺţȡȻָ1ļԷϵDpostwgpo0000Ϊʾ·ûбѡȡ1ûȷΪָͨ¼͸ļļ·ƣ·ʹϵͳṩDExchangeܣƽʹÿʶļϵͳȱʡļΪmailboxΪûsasaboxpabsaboxpstԱͬ1̨϶ûĸͨ¼͸ļС
2ݿ⽨
PowerBuilderDB profile½1MSS MS SQL ServerļдݣConnectionҳProfile NameΪSemMisserverΪLoginIDΪsaϵͳĬûDatabaseΪSEMMISSystemҳPowerBuilderCatalog Table OwnerΪdboϵͳĬֵļɺ󵥻ConnectʱPBеDatabaseͽSEMMISݿ⡣½1Ϊmailıֶ£
ڣmaildate
ű⣺title
ݣsendcon
sendername
Emailַsenderadr
ݣanswercon
־λflag0ż1ż2ż3űż
3WEBվ㽨
Ժ䡱ΪԺվ2ҳṩ񣺣1뼰͸Ժż2żIISṩݿIDCʵݵĴݺҳĶ̬¡IDCʹöļηݿ⼰ιWEBҳ棬ЩļInternetݿļidcHTMLչļhtxݿļȰʵODBCԴִSQLϢҲHTMLչļƺλáHTMLչļHTMLĵģ壬HTMLĵIDCݿϢ֮󷵻WEBиļùϵݴϵͼ2ʾ

ͼ2ļúݴ
ļ˵Ͳִ롣
ļCI2001htmԺҳûҪż͵CI2002idcûҪԺдžCI2003htm
ļCI2002idcݿжɹżflagΪ2HTMLչļCI2002htxϲWWW񷵻ظû£
datasourceSem ODBCõԴ
templateci2002htx ݷʹõHTMLģ
usernamesa ݿ¼ʹϵͳĬϵûID
SQLStatementselect titlesendconanswercon
from SemMisDBOmail ݿߣ
where flag like 2
ļCI2002htxǺӱ־HTMLĵidcļôʽ̬ӵĵִ£
begindetail htxʽؼ
֮佫涨ݸʽӵ11
ѭʾļ¼
title ż
sendcon 
answercon 
enddetail htxʽؼ
ļCI2003htm1ĳıļıΪ
input typetext namesendername塭
input typetext namesenderadr塭
input typetext nametitle塭
textarea rows10 namesendcon cols72塭
ļCI2004idcCI2003htmҳֶдݿ⣬CI2004htxΪżջִҳģ塣£
datasourceSem
usernamesa
templateci2004htx
sqlstatement
insert into SemMisDBOmailmaildateflag
sendernamesenderadrtitlesendcon
ݿ1¼
valuesgetdate0䣬䣥sendername䣬䣥senderadr䣬䣥title䣬䣥sendcon䣩
ȡϵͳʱڣԡ0ʾ˼¼Ϊ£
ãCI2003htmļname
ݵûݡ
ļCI2004htx֪ͨûѱգеĶ̬ϢǽIDCļдݵıHTMLıʽʾ磺ãidcsendernameCI2004idcеģsendernameCI2003htmnameΪsendernameֵ
4Ӧóд
PowerBuilder 60Կٿ1ż򡣱ǽ鿴żͷദһ𣬽ŷΪ4״̬flagֵʶÿ1״̬ṩӦĴܡû漰˵ͼ3ʾ

ͼ3û˵
1ţ鿴ϷżӲͬݴ棨תд״̬šɾ
2дǰյûмʱû꣩żͣתű״̬šɾ
3űѻظżת빫״̬дɾ
4Կżתű״̬дɾ
лźд1ŴڣṩѯתżݵĹܡƺʵЩżܿɰͲ׸ˡؽһPowerBuilder 60ṩmailʼķ͡
ԺMicrosoft mailʾֵûϢΪԺ䣨master루semmasterĳкռˣɳеıָгַΪԺʼӦó򡰷͡ťclicked¼м´룺
 
mailSession mSes Ự
mailMessage mMsg ʼݽṹ
 
mSesCREATE mailSession1Ự
mRetmSesmailLogonmaster壬semmaster壬mailNewSessionԺġ䡱͡롱¼
IF mRet mailReturnSuccessTHEN
MessageBoxʼ壬¼ʧܣ䣩
RETURN
END IF
mMsgSubjectż
mMsgnotetextż
mMsgRecipient1ݣNameռ  
һſ1ʾռ˵ַϢģݽṹ1Nameֵ
mRetmSesmailAddressmMsgռ˵ַ
Ч
IF mRetmailReturnSuccessTHEN
MessageBoxʼ壬ʼַЧ䣩
RETURN
END IF
mRetmSesmailSendmMsgʼ
IF mRet mailReturnSuccessTHEN
MessageBoxʼ壬䷢ʼʧܣ䣩
RETURN
END IF
mSesmailLogoff
DESTROY mSes
 
ڵϵͳȻ漰ּ缰Ӧüǰձṩĸܷٵʵһϵͳ缼ѷչԳĽ׶Σλ׷׽ԼIntranetҪʹIntranetҵڲͨϢãҪӸڵһܺõӦáڴܽԺ䡢䡢г䣬ͨͨ
ϺͬôѧѧԺ200092
ظϺͬôѧѧԺ200092
컪ϺͬôѧѧԺ200092
ոڣ
