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信息格式错误");
}
}
