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