public void TestRegister()
{
string sid = "123", name = "aaa", password = "******";
StudentEntity student = new StudentEntity() { sid=sid,name=name,password=password};
model.register(student);
Assert.AreEqual( model.login(sid, password) ,2);
}
public int register(StudentEntity student)
{
OdbcCommand command = new OdbcCommand("insert into student(sid,name,password) values(?,?,?)",connection);
command.Parameters.Add(new OdbcParameter("sid", OdbcType.VarChar)).Value = student.sid ;
command.Parameters.Add(new OdbcParameter("name", OdbcType.VarChar)).Value = student.name;
command.Parameters.Add(new OdbcParameter("password", OdbcType.VarChar)).Value = student.password;
return command.ExecuteNonQuery();
}
public List<StudentEntity> getAllStudents()
{
List<StudentEntity> list = new List<StudentEntity>();
var cmd = buildCommand("select * from student order by sid");
var reader = cmd.ExecuteReader();
while (reader.Read())
{
StudentEntity student = new StudentEntity();
student.id = reader.GetInt32(0);
student.sid = reader.GetString(1);
student.name = reader.GetString(2);
student.password = reader.GetString(3);
list.Add(student);
}
return list;
}
public ActionResult Register()
{
StudentModel studentModel = new StudentModel();
LimitUserModel limituserModel = new LimitUserModel();
try
{
var name = Request.Form["name"];
var sid = Request.Form["sid"];
var password = Request.Form["password"];
if (name == "" || sid == "" || password == "")
{
ViewBag.err = "请完整填写信息";
return View("~/Views/Index/Register.cshtml");
}
if (!limituserModel.isAllowed(sid))
{
ViewBag.err = "学号被禁止注册";
return View("~/Views/Index/Register.cshtml");
}
var student = new StudentEntity() {sid=sid,name=name,password=password };
var res = studentModel.register(student);
if (res != 1)
{
ViewBag.err = "注册失败，请检查所填信息";
return View("~/Views/Index/Register.cshtml");
}
else
{
return View("~/Views/Index/Index.cshtml");
}
}
catch (Exception e)
{
ViewBag.err = "注册失败，请检查所填信息";
return View("~/Views/Index/Register.cshtml");
}
}
