?Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols

<WebService(Namespace:="com.MobileMis")> _
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Public Class UserLogin
    Inherits System.Web.Services.WebService

    <WebMethod()> _
    Public Function Login(ByVal id As String, ByVal passwd As String) As String
        Dim sReturn As String = "1" '0，驗證通過；1，驗證未通過
        Dim conn As System.Data.SqlClient.SqlConnection
        Dim cmd As System.Data.SqlClient.SqlCommand
        Dim rdr As System.Data.SqlClient.SqlDataReader

        conn = New System.Data.SqlClient.SqlConnection("Data Source=(local);Initial Catalog=pubs;User Id=sa;Password=ibmt42;")
        conn.Open()
        cmd = New System.Data.SqlClient.SqlCommand("SELECT staff_name FROM staff WHERE staff_id = '" + id + "' AND passwd = '" + passwd + "'", conn)
        rdr = cmd.ExecuteReader()
        If rdr.Read() Then
            sReturn = rdr.GetString(0).Trim()
            'sReturn = "0"
        End If
        'sReturn = "用戶名：" + id + ", 密碼：" + passwd
        Return sReturn
    End Function

End Class