string str = "select manage_name,manage_pwd from manage where manage_name=@name and manage_pwd=@pwd";
添加参数
if(dr.read())
{
if(dropdownlist1.selectedItems.text == "所在部门")
跳转页面
}大概是这样的!
添加参数
if(dr.read())
{
if(dropdownlist1.selectedItems.text == "所在部门")
跳转页面
}大概是这样的!
解决方案 »
- 制作WEB安装项目,安装后报错:安装程序在安装此软件包时遇到一个错误。这可能表示此软件包有错。错误代码是2717
- 密码都加密了,那如果用户要找回密码的话,怎么办?
- 求救!!如何得到模态窗体的返回值!!!
- AspNetPager镶嵌在GridView的PagerTemplate中分页问题
- vs2005的程序部署在WIN2000上没有问题,部署在WIN2003上真麻烦,帮我看看...
- DorpDownList绑定时出错,急!!! 从没遇到过的问题!
- imageButton有onmouseover属性吗?怎样才能实现?
- 大家帮帮我吧!!
- 页面不刷新问题
- asp.net做的Web Service client端(实现查询功能)client端的代码有问题,请各位高手进来帮我看看!
- 为什么我在web.config中加入<deny users="?" />后,验证码就显示不出来了
- 请问谁有旅游网站的需求分析
我写的个例子 你看一下 ~~
Static n As Integer
Session("dropdownlist1value") = Trim(Request.Form("dropdownlist1"))
Session("Name") = Trim(Replace(Request.Form("username"), "'", "''"))
Session("PW") = Trim(Request.Form("userpwd"))
Dim conn As SqlConnection = New SqlConnection()
conn.ConnectionString = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
conn.Open()
Dim sqlstr As String = "select * from 管理员表 where 管理员名 = '" + Session("Name") + "' and 密码 = '" + Session("PW") + "'and 权限级别 = '" + Session("dropdownlist1value") + "' "
sqlcmd = New SqlCommand(sqlstr, conn)
dr = sqlcmd.ExecuteReader()
Select Case DropDownList1.SelectedValue
Case "学生"
If dr.Read = False Then
If n > 3 Then
label1.Text = sss & "你无权使用本网站的部分功能!"
Else
n += 1
label1.Visible = True
label1.Text = sss & "输入的用户名或密码有误!"
'Response.Redirect("login.aspx")
Exit Sub
End If
ElseIf String.Compare(Session("Code").ToString(), text1.Text, True) <> 0 Then
label1.Visible = True
label1.Text = sss & "验证码有误,请输入正确的验证码!"
Exit Sub
Else
Response.Redirect("main.aspx")
End Ifcase "系负责人"
代码同红色字体case“管理员"
代码同红色字体
end select
if (this.TextBoxLoginName.Text.Trim().Equals(""))
{
ClientScript.RegisterStartupScript(GetType(), "loginNameNull", "<script>alert('用户名不能为空!');</script>");
}
else if (this.TextBoxPwd.Text.Trim().Equals(""))
{
ClientScript.RegisterStartupScript(GetType(), "pwdNull", "<script>alert('密码不能为空!');</script>");
}
else if (("").Equals(Convert.ToString(this.DropDownListDepartmentId.SelectedItem)))
{
ClientScript.RegisterStartupScript(GetType(), "DepartmentNull", "<script>alert('部门不能为空!');</script>");
}
else
{
Manager manager = new Manager();
manager.manager_name = this.TextBoxLoginName.Text.Trim();
manager.manager_pwd = this.TextBoxPwd.Text.Trim();
manager.department_id = Convert.ToInt32(this.DropDownListDepartmentId.SelectedValue.ToString()); string sql = string.Format("select * from Manager where manager_name='{0}' and manager_pwd='{1}' and department_id='{2}'", manager.manager_name, manager.manager_pwd, manager.department_id); SqlConnection conn = new SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand(sql, conn); try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Response.Redirect("/FinanceManagerSystemUI/main/Index.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "nameOrPwdError", "alert('用户名或密码错误!');", true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
}
}瞎写的,没验证过
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
string stt = "select manager_name,manager_pwd,department_id from manager where manager_name='" + TextBox1.Text + "' and manager_pwd='" + TextBox2.Text + "' and department_id='"+DropDownList1.SelectedValue+"'";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["aaaaaaConnectionString"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand(stt,conn);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
Response.Redirect("default.aspx");
}
else
{
Response.Redirect("login.aspx");
}
sdr.Close();
conn.Close();
}
if (user != null && user.Password == passWord.Text)
{
Session["Username"] = userName.Text;
if (String.Compare(Request.Cookies["CheckCode"].Value.ToLower(), txtCheckCode.Text.ToLower(), true) != 0)
{
Response.Write("<script>alert('验证码不正确,请重新输入')</script>");
return;
} Response.Redirect("top1.aspx");
}
else
{ Response.Write("<script>alert('密码输入错误')</script>");
}
添加参数
if(dr.read())
{
if(dropdownlist1.selectedItems.text == "所在部门 ")
跳转页面
} 大概是这样的!
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class adminManage_login : System.Web.UI.Page
{
AdminDAL adminDal = new AdminDAL();
DataTable dt = new DataTable(); protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
tbdDate.Value = DateTime.Now.ToShortDateString();
}
}
protected void IbtnEnter_ServerClick(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
string username = TxtUserName.Value.Trim();
string password = TxtPassword.Value.Trim();
string dDate = tbdDate.Value.Trim();
if (username == "" || password == "" || dDate == "")
{
ClientScript.RegisterStartupScript(GetType(), "startup", "alert('请输入用户名、密码和操作日期!');", true);
return;
} /*
string verifyCode = TxtValidateCode.Value.Trim();
if (Request.Cookies["myCheckCode"] == null)
{
Response.Write("<script language='javascript'> alert('Cookies被禁用!必须设置浏览器允许使用Cookies才能登录本系统');</script>");
return;
} if (String.Compare(Request.Cookies["myCheckCode"].Value, verifyCode, true) != 0)
{
//Response.Write("<script language='javascript'> alert('验证码错误,请输入正确的验证码');</script>");
ClientScript.RegisterStartupScript(GetType(), "startup", "alert('验证码错误,请输入正确的验证码!');", true);
return;
}
*/ dt = adminDal.AdminLogin(username, password);
if (dt.Rows.Count > 0)
{
Session["admin"] = dt.Rows[0]["username"].ToString().Trim();
//Session["adminStatus"] = dt.Rows[0]["adminStatus"].ToString().Trim();
//Session["realname"] = dt.Rows[0]["realname"].ToString().Trim(); Session["emp_id"] = dt.Rows[0]["emp_id"].ToString().Trim();
adminDal.LoginUpdateTime(Session["admin"].ToString().Trim());
//FormsAuthentication.SetAuthCookie(Constant.Admin, false);
if (dt.Rows[0]["adminStatus"].ToString().Trim() == "0")//系统管理员
{
Response.Redirect("admin/AdminUserList.aspx");
}
else//普通用户
{
Response.Redirect("main.htm");
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "startup", "alert('用户名或密码错误!');", true);
}
}
}
}
这女人啥时候胸大了?
string pwd = TxtPassword.Text.Trim();
Models.UserInfo userInfo = BLL.Userinfo.GetAllUserInfoByuserId(name);
if (userInfo.UserId != name)
{
Common.Message.Show("您输入的用户名不存在,请注册!", this);
return;
}
//要给密码加密
if (userInfo.PassWord != pwd)
{
Common.Message.Show("密码不正确!", this);
return;
}
//userInfo.UserId = name; //获取角色
FormsAuthentication.SetAuthCookie(name, true);
//读取
HttpCookie cookie = FormsAuthentication.GetAuthCookie(name, true);
//解密cookie.
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(cookie.Value);
//重写票据信息,添加角色信息
FormsAuthenticationTicket newTicket = new FormsAuthenticationTicket(ticket.Version, ticket.Name, ticket.IssueDate, ticket.Expiration, ticket.IsPersistent, userInfo.RoleName);
//加密票据,并赋值给cookie
cookie.Value = FormsAuthentication.Encrypt(newTicket);
//写入cookie
Response.Cookies.Add(cookie); Session["UserId"] = userInfo.UserId; //跳转
if (userInfo.UserRoleId == 3 || userInfo.UserRoleId == 2)
{
//Response.Redirect(FormsAuthentication.GetRedirectUrl(name,true));
Dispaly(userInfo);
}
else
{
if (userInfo.UserRoleId == 4)
{
Message.Show("您尚未经过审核,暂时不能登录!", this);
return;
}
string managerRegex = ConfigurationManager.AppSettings["SystemRoles"];
//string customerRegex = ConfigurationManager.AppSettings["CustomerRoles"];
if (Regex.IsMatch(userInfo.RoleName, managerRegex))
{
Response.Redirect("~/Admin/Manager/AdminHome.aspx");
}
//else if (Regex.IsMatch(userInfo.RoleName, customerRegex))
//{
// Response.Redirect("~/Admin/MemberRemit/MySpace.aspx");
//}
}
userInfo.LastIp = Request.UserHostAddress;
userInfo.LastTime = DateTime.Now;
BLL.Userinfo.UpdateUser(userInfo);
msn:[email protected][上班时间都在线]
Email:[email protected]
小妹在此谢谢了O(∩_∩)O~
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
txtUserName.Focus();
if (!IsPostBack)
{
if (Request.UrlReferrer!=null)
{
ViewState["ReferrerUrl"] = Request.UrlReferrer.ToString();
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
lblMessage.Text = string.Empty; if (Request.Cookies["CheckCode"] == null)
{
lblMessage.Text = "您的浏览器设置已被禁用Cookies,请设置浏览器允许使用Cookies后使用本系统";
return;
} if (string.Compare(Request.Cookies["CheckCode"].Value.ToLower(), txtCheckCode.Text.ToLower()) != 0)
{
lblMessage.Text = "验证码错误,请输入正确的验证码";
return;
} string strSource = "server=(local);database=xtgj;uid=sa;pwd=sa"; SqlConnection conn = new SqlConnection(strSource);
SqlCommand cmd = new SqlCommand("validatelogin", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = txtUserName.Text.Trim();
cmd.Parameters.Add("@cryptpassword", SqlDbType.VarChar).Value = txtPassword.Text.Trim(); String userid = "";
try
{
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
userid = dr["userid"].ToString();
}
}
catch (Exception)
{
lblMessage.Text = "服务器错误,请稍后再试!";
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
} if ((userid != null) && (userid!=""))
{
Session["UserName"] = txtUserName.Text.Trim();
if (ViewState["ReferrerUrl"] != null)
{
Response.Redirect(ViewState["ReferrerUrl"].ToString());
}
else
{
Response.Redirect("default.aspx");
}
}
else
{
lblMessage.Text = "用户名或密码错误!";
}
}
}