Description: Blue sky production management system, ERP source code
通过vb的shell方法，调用外部命令。如sqlserver的osql实用工具，但是这样的话，osql执行的sql脚本可能需要花费很长的时间，如何才能保证osql执行完所有的sql之后，才继续执行vb的下一步处理呢？
1.声明2个API,用来检测进程是否在运行。
Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long
Declare Function CloseHandle Lib "kernel32" (ByVal hObject As Long) As Long
＇************************************************************************
＇【名称】：判断进程是否在运行
＇【描述】：
＇【备注】：
＇************************************************************************
Function IsRunning(ByVal ProgramID) As Boolean ＇传入进程标识ID
To Search:
File list (Check if you may need any files):
碧海蓝天生产管理系统ERP源代码\3.31发货.doc
.............................\4.1发货.doc
.............................\4.21发货.doc
.............................\4.6发货.doc
.............................\4.8发货.doc
.............................\4.9发货.doc
.............................\BaseCard\Base.bas
.............................\........\BaseCard.vbp
.............................\........\BaseCard.vbw
.............................\........\CardInterface.cls
.............................\........\EMPTY.bmp
.............................\........\frmBOMVersion.frm
.............................\........\frmCustomer.frm
.............................\........\frmCustomer.frx
.............................\........\frmCustomerClass.frm
.............................\........\frmDepartment.frm
.............................\........\frmDepartment.frx
.............................\........\frmDocument.frm
.............................\........\frmDocument.frx
.............................\........\frmDocumentClass.frm
.............................\........\frmEmployee.frm
.............................\........\frmEmployee.frx
.............................\........\frmInventory.frm
.............................\........\frmInventory.frx
.............................\........\frmInventoryBOM.frm
.............................\........\frmInventoryBOM.frx
.............................\........\frmInventoryClass.frm
.............................\........\frmInventoryNature.frm
.............................\........\frmInventoryProcess.frm
.............................\........\frmOperator.frm
.............................\........\frmOperator.frx
.............................\........\frmPopedom.frm
.............................\........\frmPopedom.frx
.............................\........\frmPosition.frm
.............................\........\frmUnitGroup.frm
.............................\........\FULL.bmp
.............................\........\HALF.bmp
.............................\........\HALFY.bmp
.............................\........\mssccprj.scc
.............................\........\PublicApi.bas
.............................\........\vssver.scc
.............................\.eBillTemplate\Base.bas
.............................\..............\BeBillTemplate.vbp
.............................\..............\BeBillTemplate.vbw
.............................\..............\BillInterface.cls
.............................\..............\BillTemplate.cls
.............................\..............\BillTemplateBO.cls
.............................\..............\BillTemplateFacade.cls
.............................\..............\BillTemplateField.cls
.............................\..............\BillTemplateFormat.cls
.............................\..............\BillTemplateView.cls
.............................\..............\frmBillTemplate.frm
.............................\..............\frmBillTemplate.frx
.............................\..............\GeneralBillBO.cls
.............................\..............\GeneralBillFacade.cls
.............................\..............\IBaseBillBO.cls
.............................\..............\IBaseBillFacade.cls
.............................\..............\ReceiptType.cls
.............................\..Print\Base.bas
.............................\.......\BePrint.vbp
.............................\.......\BePrint.vbw
.............................\.......\clsPrintGrid.cls
.............................\.......\frmPrintView.frm
.............................\.......\frmPrintView.log
.............................\.......\MSSCCPRJ.SCC
.............................\.......\PrintBillBO.cls
.............................\.......\PrintInterface.cls
.............................\.......\PrintTemplate.cls
.............................\.......\PrintTemplateField.cls
.............................\.......View\BePrintView.vbp
.............................\...........\BePrintView.vbw
.............................\...........\MSSCCPRJ.SCC
.............................\...........\PhysicalPrinter.cls
.......
Download