} //备注
/// <summary>
/// 返回管理员的信息
/// </summary>
/// <param name="adminNum">管理员的账号</param>
/// <returns></returns>
public static AdminInfo GetAdminInfo(string adminNum)
{
AdminInfo a1 = new AdminInfo();
try
{
string sql = "Select * from AdminInfo where adminNum = @adminNum";
SqlParameter[] param =
{
new SqlParameter("@adminNum", adminNum)
};
DataTable dt = SqlHelper.ExecuteTable(sql, param);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
a1 = RowToEntity(dr);
}
return(a1);
}
catch
{
return(a1);
}
}
/// <summary>
/// 根据条件获取管理员信息列表
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="param">参数</param>
public static List <AdminInfo> GetAllAdminInfo(string sql, params SqlParameter[] param)
{
DataTable dt = SqlHelper.ExecuteTable(sql, param);
List <AdminInfo> list = new List <AdminInfo>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
AdminInfo a1 = RowToEntity(dr);
list.Add(a1);
}
}
return(list);
}
/// <summary>
/// 行记录转换成一个实体
/// </summary>
/// <param name="dr">一行记录</param>
/// <returns></returns>
public static AdminInfo RowToEntity(DataRow dr)
{
AdminInfo a1 = new AdminInfo();
#region 数据填充
//管理员编号
if (dr["AdminNum"] is DBNull)
{
a1.AdminNum = "";
}
else
{
a1.AdminNum = dr["AdminNum"].ToString();
}
//管理员姓名
if (dr["AdminName"] is DBNull)
{
a1.AdminName = "";
}
else
{
a1.AdminName = dr["AdminName"].ToString();
}
//性别
if (dr["Sex"] is DBNull)
{
a1.Sex = "";
}
else
{
a1.Sex = dr["Sex"].ToString();
}
//邮箱
if (dr["Email"] is DBNull)
{
a1.Email = "";
}
else
{
a1.Email = dr["Email"].ToString();
}
//联系电话
if (dr["Phone"] is DBNull)
{
a1.Phone = "";
}
else
{
a1.Phone = dr["Phone"].ToString();
}
//级别
if (dr["Level"] is DBNull)
{
a1.Level = "";
}
else
{
a1.Level = dr["Level"].ToString();
}
//状态
if (dr["State"] is DBNull)
{
a1.State = "";
}
else
{
a1.State = dr["State"].ToString();
}
//注册时间
if (dr["SubDate"] is DBNull)
{
a1.SubDate = DateTime.Now;
}
else
{
a1.SubDate = Convert.ToDateTime(dr["SubDate"].ToString());
}
//备注
if (dr["Remark"] is DBNull)
{
a1.Remark = "";
}
else
{
a1.Remark = dr["Remark"].ToString();
}
#endregion
return(a1);
}
} //角色
/// <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);
}
/// <summary>
/// 【通过】注册用户
/// </summary>
/// <param name="userNum">用户账号</param>
/// <param name="role">角色</param>
/// <returns>成功与否的字符串</returns>
public static string PassRegisterUser(string userNum, string role)
{
if (!string.IsNullOrEmpty(role) && !string.IsNullOrEmpty(userNum))
{
if (role == "学生")
{
#region 执行删除学生
string sql = "Update StuInfo set State = @State where StuNum = @StuNum";
SqlParameter[] param =
{
new SqlParameter("@StuNum", userNum),
new SqlParameter("@State", "正常")
};
if (StuInfo.DeleteStuInfo(sql, param) > 0)
{
return("Success");
}
else
{
return("Error");
}
#endregion
}
else if (role == "教师")
{
#region 执行删除教师
string sql = "Update TeacherInfo set State = @State where TeacherNum = @TeacherNum";
SqlParameter[] param =
{
new SqlParameter("@TeacherNum", userNum),
new SqlParameter("@State", "正常")
};
if (TeacherInfo.DeleteTeacherInfo(sql, param) > 0)
{
return("Success");
}
else
{
return("Error");
}
#endregion
}
else if (role == "管理员")
{
#region 执行删除管理员
string sql = "Update AdminInfo set State = @State where AdminNum = @AdminNum";
SqlParameter[] param =
{
new SqlParameter("@AdminNum", userNum),
new SqlParameter("@State", "正常")
};
if (AdminInfo.DeleteAdminInfo(sql, param) > 0)
{
return("Success");
}
else
{
return("Error");
}
#endregion
}
else
{
return("Error");//【Role】的值不明确
}
}
else
{
return("Error");//【Role】或者【userNum】的值为空或者是null
}
}
