AS select ID from AllUsers where LoginID = @loginid if (@@RowCount<1) begin ----1 set @reason ='没有该用户' set @empid=0 end------1 else begin ----2
SELECT ID FROM AllUsers WHERE (LoginID = @loginid) AND (Password = @password ) if (@@RowCount<1) begin -----3 set @reason ='密码错' set @empid=0 end-------3 else begin ------4 SELECT @empid=ID FROM AllUsers WHERE (LoginID = @loginid) AND (Password = @password and AllowLogin=1) if (@@RowCount<1) begin ---------6 set @reason ='停用' set @empid=0 end------------6 else begin -----7 set @reason ='成功' end ----------7 end -----4 end------2 RETURN
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter(sql,conn);
DataSet ds=new DataSet();
da.Fill(ds);
if(ds.Talbes.Rows.count>0)
{
//提示有
}
else
{
//注册
}
在我输入不存在的用户时 程序应进入else,怎么还是提示用户名存在???
@loginid varchar(50),
@password varchar(50),
@empid int output,
@reason varchar(50) output
AS
select ID from AllUsers where LoginID = @loginid
if (@@RowCount<1)
begin ----1
set @reason ='没有该用户'
set @empid=0
end------1
else
begin ----2
SELECT ID
FROM AllUsers
WHERE (LoginID = @loginid) AND (Password = @password )
if (@@RowCount<1)
begin -----3
set @reason ='密码错'
set @empid=0
end-------3
else
begin ------4
SELECT @empid=ID
FROM AllUsers
WHERE (LoginID = @loginid) AND (Password = @password and AllowLogin=1)
if (@@RowCount<1)
begin ---------6
set @reason ='停用'
set @empid=0
end------------6
else
begin -----7
set @reason ='成功'
end ----------7
end -----4
end------2
RETURN