<WebMethod()> _
Function GetFlowCode()Function GetFlowCode(ByVal bl As String) As String
'bl 变量
Dim myds As DataSet = New DataSet
Dim tt As String = "%" + bl.Trim + "%"
mysql = "SELECT DeptID, FlowKind, OrderID, CheckID FROM Flow "
mysql &= "WHERE (1=1) AND ((DeptID LIKE @DeptID) OR (FlowKind LIKE @FlowKind)) ORDER BY DeptID,FlowKind, OrderID"
mycomm = New SqlCommand(mysql, myconn1)
mycomm.Parameters.Add("@FlowKind", tt.Trim) '流程别
mycomm.Parameters.Add("@DeptID", tt.Trim) '部门ID
Dim myda As SqlDataAdapter = New SqlDataAdapter(mycomm)
Try
myconn1.Open()
myda.Fill(myds)
myconn1.Close()
Catch ex As Exception
If myconn1.State = ConnectionState.Open Then
myconn1.Close()
End If
End Try
Return myds.GetXml
End Function
'调用Web服务 得到流程表
Dim ws As WebSign.WebSignServiceClass = New WebSign.WebSignServiceClass
Dim str_result As String = ws.GetFlowCode(Me.TextBox1.Text.Trim) '接收返回的XML文本
'将XML文本导入已实例化的Dataset
Dim myds As DataSet = New DataSet
Dim stringreadr As System.IO.StringReader = New System.IO.StringReader(str_result)
Dim xmltextrder As System.Xml.XmlTextReader = New System.Xml.XmlTextReader(stringreadr)
myds.ReadXml(xmltextrder)