摘要:
Public Class WebServiceHelper#Region "InvokeWebService" '动态调用web服务 Public Shared Function InvokeWebService(ByVal url As String, ByVal methodname As String, ByVal args As Object()) As Object Return WebServiceHelper.InvokeWebService(url, Nothing, methodname, args) End Function Publi... 阅读全文
摘要:
举个例子~UPDATE e SET e.money = e.money + d.amountFROM employee e INNER JOIN (SELECT empid,amount=sum(amount) FROM deleted WHERE rechargeable=1 GROUP BY empid) d ON d.empid=e.id 阅读全文
摘要:
Public Sub BuildExcel() '写入内容到Excel Dim hssfworkbook As HSSFWorkbook = WriteExcel() Dim destFileName As String = "D:\test.xls" Dim msfile As New MemoryStream() hssfworkbook.Write(msfile) System.IO.File.WriteAllBytes(destFileName, msfile.ToArray()) En... 阅读全文