/// <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);
}