protected void Log_Click(object sender, EventArgs e)
{
string username = TuserName.Text;
string pwd = ClassMd5.Md5Hash32(TpassWord.Text);
string sql = string.Format("select username,pwd from tblstudentsforexercise where username='******' and pwd='{1}'", username, pwd);
SQLHelper sh1 = new SQLHelper();
SqlDataReader sdr;
string result = string.Empty;
try
{
sh1.RunSQL(sql, out sdr);
if (sdr.Read())
{
SQLHelper sh = new SQLHelper();
try
{
StringBuilder updateSql = new StringBuilder("update tblStudentsForExercise set ");
updateSql.Append("lastLoginTime=getdate(),");
updateSql.Append("logintimes=logintimes+1");
updateSql.Append(string.Format(" where username='******'", username));
sh.RunSQL(updateSql.ToString());
}
catch (Exception ex)
{
Response.Write("更新发生异常，原因：" + ex.Message);
}
finally
{
sh.Close();
}
result = "登录成功！";
}
else
{
result = "登录失败！";
}
sdr.Close();
}
catch (Exception ex)
{
result = ex.Message;
}
finally
{
Response.Write(result);
sh1.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string username = txtUsername.Text;
string pwd = txtPwd.Text;
List <Student> student = table.Where(p => p.Field <string>("username") == username && p.Field <string>("pwd") == ClassMd5.Md5Hash32(pwd)).Select
(
p => new Student
(
username, ClassMd5.Md5Hash32(pwd), p.Field <string>("truename")
)
).ToList();
if (student.Count != 1)
{
Response.Write("请输入正确的账号密码");
}
else
{
Session["username"] = username;
Session["truename"] = student[0].truename;
Response.Redirect("homework.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string msg = string.Empty;
string username = userName.Text;
string pwd = passWord.Text;
string conpwd = ConpassWord.Text;
string truename = Truename.Text;
DateTime birthday = DateTime.Parse(Calendar1.SelectedDate.ToString("yyyy-MM-dd"));
SQLHelper sh = new SQLHelper();
try
{
string colList = "birthday,logintimes,username,truename,pwd,gender,lastLoginTime";
int logintimes = 0;
int gender = 0;
if (this.Gender.Items[0].Selected == true)
{
gender = 1;
}
DateTime lastLoginTime = DateTime.Now;
//判断是否已经注册过
bool flag1 = false;
string sql = string.Format("select username from tblStudentsForExercise where username='******'", username);
SQLHelper sh1 = new SQLHelper();
SqlDataReader sdr;
string result = string.Empty;
try
{
sh1.RunSQL(sql, out sdr);
if (!sdr.Read())
{
flag1 = true;
}
sdr.Close();
}
catch (Exception ex)
{
result = ex.Message;
}
finally
{
Response.Write(result);
sh1.Close();
}
//开始注册
if (flag1 == true)
{
if (pwd == conpwd)
{
//判断密码是否含有字母和数字
int strengthLevel = 0;
int letter = 0;
int number = 0;
foreach (char i in pwd)
{
if ((i >= 'a' && i <= 'z') || (i >= 'A' && i <= 'Z'))
{
letter++;
}
if (i >= '0' && i <= '9')
{
number++;
}
}
if (letter > 0 && number > 0)
{
strengthLevel++;
}
//开始注册
if (pwd.Length < 6)
{
msg += "密码强度不够，不得少于6位！";
}
else if (strengthLevel == 0)
{
msg += "密码必须同时包含字母和数字！";
}
else
{
string npwd = ClassMd5.Md5Hash32(pwd);
StringBuilder insertSql = new StringBuilder(string.Format("insert into tblStudentsForExercise ({0})", colList));
insertSql.Append("values(");
insertSql.Append(string.Format("'{0}',", birthday));
insertSql.Append(string.Format("{0},", logintimes));
insertSql.Append(string.Format("'{0}',", username));
insertSql.Append(string.Format("'{0}',", truename));
insertSql.Append(string.Format("'{0}',", npwd));
insertSql.Append(string.Format("{0},", gender));
insertSql.Append(string.Format("'{0}'", lastLoginTime));
insertSql.Append(")");
sh.RunSQL(insertSql.ToString());
Response.Redirect("login.aspx");
}
}
else
{
msg += "密码和确认密码不一致！";
}
}
else
{
msg += "该用户名已注册！";
}
}
catch (Exception ex)
{
msg = "数据库插入发生异常，原因： " + ex.Message;
}
finally
{
sh.Close();
}
Response.Write(msg);
}
