public void ParsedResultTest()
{
var obj = new CourseTableViewModel();
obj.LoadCourses(testSource);
Assert.AreEqual("东北大学2016-2017学年第二学期学生课表", obj.Term);
Assert.AreEqual("院系:计算机科学与工程学院 专业:计算机科学与技术 班级:计算机1403 学号:20141874 姓名:黄文睿", obj.StudentInfo);
}
public CourseTableViewModel GetCourseList(int pageSize, int pageIndex, string courseName)
{
var tempTable = new CourseTableViewModel();
var totalCount = context.Courses.Where(m => m.CouName.Contains(courseName)).ToList().Count;
tempTable.PageCount = totalCount / pageSize;
if (totalCount < pageSize)
{
tempTable.PageCount = 1;
}
if (totalCount % pageSize != 0 && totalCount > pageSize)
{
tempTable.PageCount += 1;
}
SqlParameter[] param =
{
new SqlParameter("@courseName", "%" + courseName + "%")
};
var convertList = new List <Course>();
convertList = context.Database.SqlQuery <Course>("select * from Course where CouName like @courseName order by CreateTime desc", param).ToList().Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
tempTable.ModelList = convertList;
return(tempTable);
}
