public bool Update(Model.StudentAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [student_account] set ");
strSql.Append("password=@Password");
strSql.Append(" where stuno=@StuNo ");
SqlParameter[] parameters =
{
new SqlParameter("@Password", SqlDbType.VarChar, 50),
new SqlParameter("@StuNo", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.Password;
parameters[1].Value = model.StuNo;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool Add(Model.Student student, string password, out string message)
{
message = "";
if (student.StuNo.Trim() == "")
{
message = "学号不可为空白";
return(false);
}
if (student.StuName.Trim() == "")
{
message = "姓名不可为空白";
return(false);
}
if (!Check.CheckYear(student.Grade.Trim()))
{
message = "请选择正确的年级";
return(false);
}
if (student.Subject.Trim() == "")
{
message = "专业不可为空白";
return(false);
}
if (student.College.Trim() == "")
{
message = "学院不可为空白";
return(false);
}
if (!Check.CheckMobilePhone(student.Phone))
{
message = "请选择正确的手机号";
return(false);
}
if (student.Living.Trim() == "")
{
message = "居住地不可为空白";
return(false);
}
if (password.Trim() == "")
{
message = "默认密码不可空白";
return(false);
}
DAL.Student model = new DAL.Student();
if (model.CheckExist(student.StuNo.Trim()))
{
message = "该学生已被录入！！！";
return(false);
}
message = "导入成功";
model.Add(student);
Model.StudentAccount account = new Model.StudentAccount();
account.StuNo = student.StuNo;
account.Password = Encode.GenerateMD5(password);
return(new DAL.StudentAccount().Add(account));
}
public bool Add(Model.StudentAccount model)
{
string strSql = "insert into [student_account] values(@StuNo,@Password)";
SqlParameter[] parameters =
{
new SqlParameter("@StuNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.StuNo;
parameters[1].Value = model.Password;
int n = SqlDbHelper.ExecuteNonQuery(strSql, CommandType.Text, parameters);
if (n == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool Login(Model.StudentAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from [student_account]");
strSql.Append(" where stuno=@StuNo and password=@Password");
SqlParameter[] parameters =
{
new SqlParameter("@StuNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.StuNo;
parameters[1].Value = model.Password;
int n = Convert.ToInt32(SqlDbHelper.ExecuteScalar(strSql.ToString(), CommandType.Text, parameters));
if (n == 1)
{
return(true);
}
else
{
return(false);
}
}
