/// <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); }