userlogin.cs

来自「asp.net连带c++技术开发」· CS 代码 · 共 46 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;

namespace Server
{
    public  class UserLogin
    {
        public static bool Login(string strConn,string userId,string userPwd,string userType)
        {
            SqlConnection conn = new SqlConnection(strConn);
            SqlCommand cmd = new SqlCommand("userLogin",conn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@userID", SqlDbType.BigInt).Value = Convert.ToInt32(userId);
            cmd.Parameters.Add("@userPwd", SqlDbType.VarChar).Value = userPwd;
            cmd.Parameters.Add("@userType", SqlDbType.VarChar).Value = userType;

            SqlParameter output = new SqlParameter("@anwer",SqlDbType.Int);
            output.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(output);

            try
            {
                conn.Open();
                cmd.ExecuteNonQuery();
                return Convert.ToBoolean(output.Value);
            }
            catch
            {
                return false;
            }
            finally 
            {
                conn.Close();
            }
        }
    }
}