} //角色
/// <summary>
/// 【管理员】获取所有注册待验证的用户
/// </summary>
/// <param name="level">管理员级别</param>
/// <returns></returns>
public static List <AllUserInfo> GetAllRegisterUserInfo(string level)
{
List <AllUserInfo> allList = new List <AllUserInfo>();
int k = 1;
//①加载学生信息列表
//①--------1读取信息
string sql1 = "Select s.*,a.InstituteName from StuInfo s, InstituteInfo a where s.InstituteNum = a.InstituteNum and s.State = @State and s.DelFlag = 0";
SqlParameter[] p1 = { new SqlParameter("@State", "待检验") };
List <StuInfo> stuList = StuInfo.GetAllStuInfo(sql1, p1);
//①--------2添加
foreach (StuInfo stu in stuList)
{
AllUserInfo all = new AllUserInfo();
all.ListID = k;
all.UserNum = stu.StuNum;
all.UserName = stu.StuName;
all.Sex = stu.Sex;
all.IdentityCard = stu.IdentityCard;
all.Role = "学生";
allList.Add(all);
k++;
}
//②加载教师信息列表
//②-----------1读取信息
string sql2 = "Select t.*, a.InstituteName from TeacherInfo t, InstituteInfo a where t.State = @State and t.DelFlag = 0 and t.InstituteNum = a.InstituteNum";
SqlParameter p2 = new SqlParameter("@State", "待检验");
List <TeacherInfo> teaList = TeacherInfo.GetAllTeacherInfo(sql2, p2);
//②------------2添加
foreach (TeacherInfo teacher in teaList)
{
AllUserInfo all = new AllUserInfo();
all.ListID = k;
all.UserNum = teacher.TeacherNum;
all.UserName = teacher.TeacherName;
all.Sex = teacher.Sex;
all.IdentityCard = teacher.IdentityCard;
all.Role = "教师";
allList.Add(all);
k++;
}
//③加载管理员信息列表
if (level == "0")
{
//③-------------1读取信息
string sql3 = "Select * from AdminInfo where State = @State and DelFlag = 0";
SqlParameter p3 = new SqlParameter("@State", "待检验");
List <AdminInfo> adminList = new List <AdminInfo>();
adminList = AdminInfo.GetAllAdminInfo(sql3, p3);
//③-------------2添加
foreach (AdminInfo a in adminList)
{
AllUserInfo all = new AllUserInfo();
all.ListID = k;
all.UserNum = a.AdminNum;
all.UserName = a.AdminName;
all.Sex = a.Sex;
all.IdentityCard = "";
all.Role = "管理员";
allList.Add(all);
k++;
}
}
return(allList);
}
