/// <summary>
/// 管理员登陆
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public SqlDataReader AdminLogin(AdminInfoModel model)
{
string sql = "select * from AdminInfo where Admin_Name=@0 and Admin_Password=@1";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Admin_Name, model.Admin_Password);
return(dr);
}
/// <summary>
/// 检测学院是否存在的数据访问方法
/// </summary>
/// <param name="model">学院的实体对象</param>
/// <returns>是或否</returns>
public bool SeleCollege(CollegesModel model)
{
string sql = "select College_ID 学院编号,College_Name 学院名称 from Colleges where College_ID=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.College_ID);
bool b = dr.Read();
dr.Close();
return(b);
}
/// <summary>
/// 检查学生编号
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CheckStudent(StudentsModel model)
{
string sql = "select * from Students where StudentNum=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.StudentNum);
bool b = dr.Read();
dr.Close();
return(b);
}
/// <summary>
/// 检查管理员权限
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CheckAdminInfo(AdminInfoModel model)
{
string sql = "select * from AdminInfo where Admin_Name=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Admin_Name);
bool b = dr.Read();
dr.Close();
return(b);
}
/// <summary>
/// 检查旧密码
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool CheckOldPass(AdminInfoModel model)
{
string sql = "select * from AdminInfo where Admin_ID=@0 and Admin_Password=@1";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Admin_ID, model.Admin_Password);
bool bo = dr.Read();
dr.Close();
return(bo);
}
/// <summary>
/// 检测班级编号
/// </summary>
/// <param name="model">班级的实体对象</param>
/// <returns>是否</returns>
public bool SeleClasses(ClassesModel model)
{
string sql = "select * from Classes where Classes_ID=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Classes_ID);
bool b = dr.Read();
dr.Close();
return(b);
}
/// <summary>
/// 检测专业编号
/// </summary>
/// <param name="model">专业实体对象</param>
/// <returns>是 否</returns>
public bool SeleSpeciality(SpecialityModel model)
{
string sql = "select * from Speciality where Speciality_ID=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Speciality_ID);
bool b = dr.Read();
dr.Close();
return(b);
}
public bool SeleSepc_Subjects(Sepc_SubjectsModel model)
{
string sql = "select * from Sepc_Subjects where Sepc_ID=@0 and Subjects_ID=@1";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Sepc_ID, model.Subjects_ID);
bool b = dr.Read();
dr.Close();
return(b);
}
