//提取所有学生的信息
public List <StdInfoModel> GetAllInformation()
{
string cmd = "SELECT [StdNum], [Name], [Sex], [Nation], [E_Mail], [PhoneNumber] FROM [T_StdInfo]";
DataTable dt = SQLCommand.ExecuteQuery(cmd);
return(DateToList(dt));
}
//查询管理员账户信息的方法
public List <AdminInfoModel> GetAdminInfo()
{
string cmd = "SELECT [AdminName], [Password] FROM [T_Admin]";
DataTable dt = SQLCommand.ExecuteQuery(cmd);
return(DateToList(dt));
}