protected void lbtnSubmit_Click(object sender, EventArgs e)
{
String loginName = txtLoginName.Text.Trim();
String userPwd = txtUserPwd.Text.Trim();
//MD5
userPwd = Util.MyUtil.MD5(userPwd);
String strSql = "select id from tbUser where loginname=@loginname and userpwd=@userpwd";
bool b= DbHelperSQL.Exists(strSql,new SqlParameter("@loginname",loginName),new SqlParameter("@userpwd",userPwd));
if (b)
{
//登陆成功
int id = (int)DbHelperSQL.GetSingle(strSql, new SqlParameter("@loginname", loginName), new SqlParameter("@userpwd", userPwd));
tbUser user = new tbUserDAL().GetModel(id);
Session[Constant.User] = user;
Server.Transfer("~/Menu.aspx");
}
else
{
lblTip.Text = "用户名或者密码错误";
lblTip.Visible = true;
}
}
/// <summary>
/// 导入到数据库
/// </summary>
/// <param name="dt"></param>
/// <returns>返回插入不成功的学号</returns>
public static List<String> ExportToDB(DataTable dt)
{
List<String> list = new List<string>();
tbUserDAL userDAL = new tbUserDAL();
for (int i = 0; i < dt.Rows.Count; i++)
{
tbUser user = new tbUser();
String loginname = dt.Rows[i][0].ToString();
String realname = dt.Rows[i][1].ToString();
String userpwd = dt.Rows[i][2].ToString();
String classname = dt.Rows[i][3].ToString();
String usertype = dt.Rows[i][4].ToString();
user.loginname = loginname;//登陆名
user.realname = realname;//真实名
if (usertype.Trim() == "学生")
{
if (IsNum(loginname))
{
//班级
try
{
int classid = (int)DbHelperSQL.GetSingle("select top 1 id from tbClass where classname=@classname", new SqlParameter("@classname", classname));
user.classid = classid;
}
catch (Exception)
{
list.Add("行" + (i + 2) + "的班级不存在！");
continue;
}
}
else
{
list.Add("行" + (i + 2) + "的学号格式不正确！");
continue;
}
user.usertype = 3;
}
else
if (usertype.Trim() == "教师")
{
user.usertype = 2;
}
else
{
list.Add("行" + (i + 2) + "的身份格式不正确！");
continue;
}
//密码
try
{
user.userpwd = MyUtil.MD5(GetPwdByCard(userpwd));
}
catch (Exception)
{
list.Add("行" + (i + 2) + "的密码格式不正确！");
continue;
}
//判断登陆名是否存在
if (DbHelperSQL.Exists("select * from tbUser where loginname=@loginname", new SqlParameter("@loginname", loginname)))
{
list.Add("行" + (i + 2) + "的登陆名已经存在！");
continue;
}
userDAL.Add(user);
}
return list;
}