public List <Courseinfo> GetCourseinfos() { List <Courseinfo> courseinfos = new List <Courseinfo>(); string sql = "select * from Course_Info"; SqlDataReader sdr = SqlHelper.GetAllResult(sql); while (sdr.Read()) { Courseinfo courseinfo = new Courseinfo() { ID = (int)sdr["ID"], coursename = (string)sdr["Course Title"], coursenumber = (string)sdr["Course Number"], courescategory = (string)sdr["Course Category"], kcfs = (string)sdr["Way Of Investigation"], hours = (string)sdr["Hours Of Studing"] }; courseinfos.Add(courseinfo); } sdr.Close(); return(courseinfos); }
/// <summary> /// 使用课程编号查找 /// </summary> /// <param name="courseNumber"></param> /// <returns></returns> public List <Courseinfo> GetCourseinfoByCourseNumber(string courseNumber) { List <Courseinfo> courseinfos = new List <Courseinfo>(); string sql = $"select * from course_info where class_num={courseNumber}"; SqlDataReader sdr = SqlHelper.GetAllResult(sql); while (sdr.Read()) { Courseinfo courseinfo = new Courseinfo() { ID = (int)sdr["ID"], coursename = (string)sdr["course_name"], coursenumber = (string)sdr["course_number"], courescategory = (string)sdr["course_category"], kcfs = (string)sdr["course_kcfs"], hours = (int)sdr["course_hours"] }; courseinfos.Add(courseinfo); } sdr.Close(); return(courseinfos); }