public List <StudentInfoStruct> GetStudents(string IncludeClass) { try { List <StudentInfoStruct> res = new List <StudentInfoStruct>(); CONN.Open(); var StringArray_Class = IncludeClass.Split(','); if (StringArray_Class.Length == 0) { return(null); } foreach (var ClassString in StringArray_Class) { string ClassName; string Major; var temp = ClassString.Split('.'); Major = temp[0].Trim(); ClassName = temp[1].Trim(); string SQL_SELECT_STUDENTS = string.Format(@"SELECT * FROM StudentInfo WHERE [Major] = '{0}' AND [Class] = '{1}'", Major, ClassName); SQLiteCommand cmd = new SQLiteCommand(SQL_SELECT_STUDENTS, CONN); SQLiteDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { StudentInfoStruct si = new StudentInfoStruct(); si.Name = sdr["Name"].ToString(); si.Gender = sdr["Gender"].ToString(); si.Class = sdr["Class"].ToString(); si.Major = sdr["Major"].ToString(); si.PoliticalStatus = sdr["PoliticalStatus"].ToString(); si.Nation = sdr["Nation"].ToString(); si.Post = sdr["Post"].ToString(); si.Address = sdr["Address"].ToString(); si.Dorm = sdr["Dorm"].ToString(); si.DormMember = sdr["DormMember"].ToString(); si.Economic = sdr["Economic"].ToString(); si.BonusAndPenalty = sdr["BonusAndPenalty"].ToString(); si.Study = sdr["Study"].ToString(); si.Habby = sdr["Habby"].ToString(); si.PhotoPath = sdr["PhotoPath"].ToString(); si.ID = sdr["ID"].ToString(); si.Job = sdr["Job"].ToString(); si.Number = sdr["Number"].ToString(); if (!File.Exists(si.PhotoPath)) { continue; } res.Add(si); } sdr.Close(); } CONN.Close(); return(res); } catch { return(new List <StudentInfoStruct>()); } }
/// <summary> /// 根据学生ID获取学生信息 /// </summary> /// <param name="ID"></param> /// <returns></returns> public StudentInfoStruct GetStudentInfo(string ID) { try { StudentInfoStruct res = new StudentInfoStruct(); CONN.Open(); string SQL_SELECT = string.Format(@"SELECT * FROM StudentInfo WHERE [ID] = {0}", int.Parse(ID)); var cmd = new SQLiteCommand(SQL_SELECT, CONN); var sdr = cmd.ExecuteReader(); while (sdr.Read()) { res.Name = sdr["Name"].ToString(); res.Gender = sdr["Gender"].ToString(); res.Class = sdr["Class"].ToString(); res.Major = sdr["Major"].ToString(); res.PoliticalStatus = sdr["PoliticalStatus"].ToString(); res.Nation = sdr["Nation"].ToString(); res.Post = sdr["Post"].ToString(); res.Address = sdr["Address"].ToString(); res.Dorm = sdr["Dorm"].ToString(); res.DormMember = sdr["DormMember"].ToString(); res.Economic = sdr["Economic"].ToString(); res.BonusAndPenalty = sdr["BonusAndPenalty"].ToString(); res.Study = sdr["Study"].ToString(); res.Habby = sdr["Habby"].ToString(); res.PhotoPath = sdr["PhotoPath"].ToString(); res.ID = sdr["ID"].ToString(); res.Job = sdr["Job"].ToString(); res.Number = sdr["Number"].ToString(); } sdr.Close(); CONN.Close(); return(res); } catch { return(new StudentInfoStruct()); } }
/// <summary> /// 获取教师信息表 /// </summary> /// <returns></returns> public List <TeacherInfoStruct> GetTeacherInfoList() { string TeacherMajor = string.Empty; string IncludeClass = string.Empty; string TeacherName = string.Empty; try { List <TeacherInfoStruct> resList = new List <TeacherInfoStruct>(); CONN.Open(); string SQL_GetAllTeacherInfoList = @"SELECT * FROM TeacherInfo"; SQLiteCommand cmd = new SQLiteCommand(SQL_GetAllTeacherInfoList, CONN); var sdr = cmd.ExecuteReader(); while (sdr.Read()) { TeacherInfoStruct TeacherTemp = new TeacherInfoStruct(); //读取一个老师的信息 TeacherTemp.Name = sdr["Name"].ToString(); TeacherName = TeacherTemp.Name; TeacherTemp.Major = sdr["Major"].ToString(); TeacherMajor = TeacherTemp.Major; TeacherTemp.IncludeClass = sdr["IncludeClass"].ToString(); IncludeClass = TeacherTemp.IncludeClass; //if (string.IsNullOrEmpty(TeacherTemp.IncludeClass)) // continue; #region { string Major = string.Empty; string ClassName = string.Empty; List <StudentInfoStruct> resStudentList = new List <StudentInfoStruct>(); var StringArray_Class = TeacherTemp.IncludeClass.Split(','); if (StringArray_Class.Length == 0) { return(null); } foreach (var ClassString in StringArray_Class) { var temp = ClassString.Split('.'); Major = temp[0].Trim(); ClassName = temp[1].Trim(); string SQL_SELECT_STUDENTS = string.Format(@"SELECT * FROM StudentInfo WHERE [Major] = '{0}' AND [Class] = '{1}'", Major, ClassName); SQLiteCommand cmdStudent = new SQLiteCommand(SQL_SELECT_STUDENTS, CONN); SQLiteDataReader sdrStudent = cmdStudent.ExecuteReader();// while (sdrStudent.Read()) { StudentInfoStruct si = new StudentInfoStruct(); si.Name = sdrStudent["Name"].ToString(); si.Gender = sdrStudent["Gender"].ToString(); si.Class = sdrStudent["Class"].ToString(); si.Major = sdrStudent["Major"].ToString(); si.PoliticalStatus = sdrStudent["PoliticalStatus"].ToString(); si.Nation = sdrStudent["Nation"].ToString(); si.Post = sdrStudent["Post"].ToString(); si.Address = sdrStudent["Address"].ToString(); si.Dorm = sdrStudent["Dorm"].ToString(); si.DormMember = sdrStudent["DormMember"].ToString(); si.Economic = sdrStudent["Economic"].ToString(); si.BonusAndPenalty = sdrStudent["BonusAndPenalty"].ToString(); si.Study = sdrStudent["Study"].ToString(); si.Habby = sdrStudent["Habby"].ToString(); si.PhotoPath = sdrStudent["PhotoPath"].ToString(); si.ID = sdrStudent["ID"].ToString(); si.Job = sdrStudent["Job"].ToString(); si.Number = sdrStudent["Number"].ToString(); if (File.Exists(si.PhotoPath) || File.Exists(si.PhotoPath + ".jpg") || File.Exists(si.PhotoPath + ".png") || File.Exists(si.PhotoPath + ".jpg.jpg")) { resStudentList.Add(si); } } sdrStudent.Close(); } TeacherTemp.StudentList = resStudentList; resList.Add(TeacherTemp); } #endregion } sdr.Close(); CONN.Close(); return(resList); } catch (Exception e) { //throw e; throw new Exception(TeacherMajor + " - " + TeacherName + "\n\n" + IncludeClass + "\n\n信息格式错误"); } }