service.cs

来自「水晶报表详细资料水晶报表详细资料水晶报表详细资料」· CS 代码 · 共 45 行

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
    public Service () {

        //如果使用设计的组件，请取消注释以下行 
        //InitializeComponent(); 
    }

    [WebMethod]
    public string HelloWorld() {
        return "Hello World";
    }

    [WebMethod(Description = "该方法用来验证用户名及密码是否正确，正确返回true，否则返回false")]
    public bool Login(string UserName,string PassWord)
    {
        SqlConnection conn = new SqlConnection("server=MRLFL\\MRLFL;uid=sa;pwd=;database=db_26");
        conn.Open();
        SqlCommand cmd = new SqlCommand("select * from tb_User where UserName='" + UserName + "' and PassWord='" + PassWord + "'", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        bool Message =false;
        if (dr.Read())
        {
            Message = true;
        }
        else
        {
            Message = false;
        }
        cmd.Dispose();
        dr.Dispose();
        conn.Dispose();
        return Message;  //返回用户名及密码是否输入正确
    }

}