ERP系统研究及在医药连锁机构中的应用

TP3111018319805002Title:ERPsystemresearchandit'sapplyinchaindrugstore731620015312001612keywords:ERPMRPMRPSQL—ERP………………………………………………1.1ERP…………………………………………1.2ERP………………………………………..1.3ERP………………………………………..ERP…………2.1…………………………………………2.2…………………………………2.3……………………………………………3.1………………………………………………3.2………………………………………3.3………………………………………………………………4.1…………….……………………………4.2……………………….……………………4.2………………………………….………………………………5.1………….……………………………5.2….…………….…………………………..…5.3………….………………………………5.4….…………….…………………………..5.5…………………….……………………………………………………………………………………………………………………………….…………………………………………………………..……ERPEnterpriseResourcesPlanningERPERPERPERP:ERPERPERPERPERPERP1981MRPMRP/ERP[9]1MRPMRP219901996MRP/ERPMRP/ERPMRPMRP/ERPMRP/ERP31997ERPERPMRPERPERPERPInternetMRPERPERPMRP/ERPMRP/ERPMRP/ERP80MRP/ERP10%20%MRP/ERPMRP/ERPERP40%1ERP2ERP3ERPERP[10]MRP/ERPERPMRP/ERP10%20%MRP/ERPMRP/ERPERPERPERPERPERP1ERPERPERPERPERPERP2ERPERPERPERPERPERPERPERPERPERPERPERPERPERPERPERPERPERPERP3ERPERPERPERPERP4ERPERP1.1ERPERP11.2234ERP/()81MicrosoftVisualBasic6.0InternetMicrosoftWindowsNTServer4.0MicrosoftIIS4.0MicrosoftSQLServer7.0MicrosoftAccess97MicrosoftWindows98WindowsNTServer4.0SQLServer7.0NTPack4IIS4.0ASPSQLServer7.0,/OLEDBODBCMicrosoftAccessMicrosoftAccess97IEWindows98APEXTrueDBGridVB6.0DataGridADOOLEDBComboBoxGridHTMLIE4.04VisualBasicActiveXADO(ActiveXDataObjects)RDO(RemoteDataObjects)DAO(DataAccessObjects)ADOMicrosoftMicrosoftADO/WebADO(2.0)CommandPropertyRecordsetRecordsetRecordsetRecordsetUpdateAddNewUpdateUpdateBatchAddNewUpdateDeleteUpdateBatchStatusVB6.0IntelPCIntel32TD88CN-II10Base-T100Base-TX100Base-TXIntelInBusiness8-port10/100Switch10Base-T10MbpsD-Link16Windows98533ERP41SQL000114select,fromwhere=0001select…from…where…SQL2TrueDBGridPOSPOS1POS2-3++POSPOSP58614EPSONPOSRJ-45LEDCCD2POS1POSPOS2POS314=56POS789POS103POSPOS1POSVB24+8+43123SQL12345.1.2MicrosoftWordVB6.0OLEWordOLEObjectLinkingObjectEmbeddingWindows[15]OLEWordVBOLEOLEWord97WordOLEWord.3.4.1.2.3LoadClickASPASPActiveServerPagesASPIIS3.04.0ASPHTMLASPActiveXWeb1ASP12Windows3(BrowserIndependence)HTMLASP(VBscript/Jscript)4(Object_Orient)5ActiveX6ASP2ASP1Request2Response3Server4Applicatin5SessionASP.aspWebASPHTML.aspWebWWWASP.aspASPVBScriptJScriptVBsrciptVBsrciptVBASPASPADOActiveXDataObjectWebASPASPSQLServerVBsrciptSQLASP.aspASPERP