本帖最后由 1021361407 于 2015-4-14 00:05 编辑
- protected void OK_Click(object sender, EventArgs e)
- {
-
- string user = txtUsername.Text.Trim();
- string pwd = txtPwd.Text.Trim();
- if (user.IndexOf("'") > -1 || user.IndexOf(' ') > -1 || user.IndexOf('"') > -1
- || pwd.IndexOf("'") > -1 || pwd.IndexOf(' ') > -1 || pwd.IndexOf('"') > -1)
- {
- Response.Write("<script>alert('用户名或密码包含有非法字符!');</script>");
- return;
- }
- string sql = "select * from admin where adminName='" + user + "'and adminPwd='" + pwd + "'";
- SqlDataReader dr = DbHelperSQL.ExecuteReader(sql);
- if (dr.Read() == true)
- {
- Session["admin"] = dr["adminName"].ToString();//管理员
- DbHelperSQL.ExecuteReader(" update admin set lastlogintime='" + DateTime.Now + "'where adminName='" + user + "';");
- Response.Redirect("Admin/ztDefault.aspx");
- }
- else
- {
- Response.Write("<script>alert('登录失败,无此用户名或密码不正确!');</script>");
- }
- //最后关闭阅读器
- DbHelperSQL.ExecuteReader(" update admin set lastlogintime='" + DateTime.Now + "'where adminName='" + user + "';");
- dr.Close();
-
- }
- }
复制代码
不是故意发这个地方的,我找不到关于c#的论坛,所以来这看看。
需求是在登录管理员账户的时候,每次都会刷写lastlogintime,真心着急,望大神们帮我看看,是哪里出错了呀
|
|