AS select EmpID from mrBaseInf where LoginID = @loginid if (@@RowCount<1) begin ----1 set @reason ='noEmp' set @empid=0 end------1 else begin ----2
SELECT EmpID FROM mrBaseInf WHERE (LoginID = @loginid) AND (Password = @password ) if (@@RowCount<1) begin -----3 set @reason ='pError' set @empid=0 end-------3 else begin ------4 SELECT @empid=EmpID FROM mrBaseInf WHERE (LoginID = @loginid) AND (Password = @password and AllowLogin=1) if (@@RowCount<1) begin ---------6 set @reason ='unAllow' set @empid=0 end------------6 else begin -----7 set @reason ='access' end ----------7 end -----4 end------2 RETURNGO
先出现A窗体,提交登录,连数据库,返回数据,登录成功,跳转B窗体,
或者A,B放在同一页面,控制显示不显示就行了
静态的
然后在你的登陆窗体中
如果用户名密码正确 就把Program.cs中的那个静态变量的值为TRUE
static class Program
{ bool isShowForm=false;
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
if(isShowForm)
{
Application.Run(new 你要显示的窗体)
}
}
}
如:public bool IsLogin;在“登陆后显示的窗体”的loadForm的事件中写入LoginForm LF = new LoginForm();
LF.SHow();
if (LF.IsLogin != true)
{
this.close();
}
注销的时候,隐藏主窗体,实例登陆子窗体。
这样就OK了
login.aspx:登录窗体
username:___________(用.net里的校验控件配合正则一起使用也很简单)
userpwd:____________(用.net里的校验控件配合正则一起使用也很简单)
Login(button)
登录的这个窗体可以在后台写个存储过程返回个out参数看是不是有记录,有就跳转到登录成功的页面如:Main.aspx,无的话弹个alert("")信息出来!这个不难的!
CREATE PROCEDURE sysEmpLogin
@loginid varchar(50),
@password varchar(50),
@empid int output,
@reason varchar(50) output
AS
select EmpID from mrBaseInf where LoginID = @loginid
if (@@RowCount<1)
begin ----1
set @reason ='noEmp'
set @empid=0
end------1
else
begin ----2
SELECT EmpID
FROM mrBaseInf
WHERE (LoginID = @loginid) AND (Password = @password )
if (@@RowCount<1)
begin -----3
set @reason ='pError'
set @empid=0
end-------3
else
begin ------4
SELECT @empid=EmpID
FROM mrBaseInf
WHERE (LoginID = @loginid) AND (Password = @password and AllowLogin=1)
if (@@RowCount<1)
begin ---------6
set @reason ='unAllow'
set @empid=0
end------------6
else
begin -----7
set @reason ='access'
end ----------7
end -----4
end------2
RETURNGO