/// <summary>
/// 判断用户登入 1:正确 2:已屏蔽用户 0:密码错误 -1:账户名不存在
/// </summary>
/// <param name="_userName">用户名</param>
/// <param name="_pwd">密码</param>
/// <returns></returns>
public int UserLogin(string _userName, string _pwd)
{
DbParameter[] cmdParms ={
WebHelper.CreateInDbParameter("@userName",DbType.String,_userName),
WebHelper.CreateInDbParameter("@pwd",DbType.String,_pwd),
WebHelper.CreateOutDbParameter("@returnValue",DbType.Int32),
};
WebHelper.ExecuteNonQuery(CommandType.StoredProcedure, "up_UserProve", cmdParms);
return int.Parse(cmdParms[2].Value.ToString());
}
存储过程
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
----------------------------------------------------------
--Author: wanghuaide
--Create Time: 2011-1-25 11:39
--Update Time:
--memo:判断用户登入 1:正确 2:已屏蔽用户 0:密码错误 -1:账户名不存在
-----------------------------------------------------------
ALTER PROCEDURE [dbo].[up_UserProve]
(
@userName varchar(50),
@pwd varchar(32),
@returnValue int=-1 output
)
AS
--
IF not EXISTS (SELECT 1 FROM tbUserDb WHERE UserName=@userName)
begin
set @returnValue=-1 ---- 账户不存在
end
ELSE
if not EXISTS (SELECT 1 FROM tbUserDb WHERE UserName=@userName AND Pwd=@pwd)
set @returnValue=0 --密码错误
else
IF EXISTS (SELECT 1 FROM tbUserDb WHERE UserName=@userName AND Pwd=@pwd and STATUS=0)
set @returnValue=1--正确,验证通过
ELSE
set @returnValue=2 -- 已屏蔽用户