//判断用户是否为管理员 public SqlDataReader CheckAdmin() { string strSql = "select level from UserInfo where [userName] = @userName and [level] = '1'"; SqlCommon sqlcomm = new SqlCommon(); return(sqlcomm.ExecuteReader(strSql, new SqlParameter("@userName", _userName))); }
public static SqlDataReader CheckStatus(string userName) { string strSql = "select * from UserInfo where [userName] = @userName and status = '1'"; SqlCommon sqlcomm = new SqlCommon(); return(sqlcomm.ExecuteReader(strSql, new SqlParameter("@userName", userName))); }
public static SqlDataReader CheckByUserNameAndPwd(string userName, string password) { string strSql = "select userName from UserInfo where [userName] = @userName and [password] = @password"; SqlCommon sqlcomm = new SqlCommon(); return(sqlcomm.ExecuteReader(strSql, new SqlParameter("@userName", userName), new SqlParameter("@password", password))); }
public static SqlDataReader GetReaderByUserName(string userName) { string strSql = "select * from UserInfo where [UserName] = @userName"; SqlCommon sqlcomm = new SqlCommon(); return(sqlcomm.ExecuteReader(strSql, new SqlParameter("@userName", userName))); }
//通过科目名称返回一条记录,以判断科目是否存在 public static SqlDataReader GetReaderBySubjectName(string subjectName) { string strSql = "select SubjectName from Subject where [SubjectName] = @subjectName"; SqlCommon sqlcomm = new SqlCommon(); return(sqlcomm.ExecuteReader(strSql, new SqlParameter("@subjectName", subjectName))); }
//检查是否有班 public static SqlDataReader IsClassExists() { string strSql = "select * from Class "; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, null); return(reader); }
//判断学号是否已存在 public static SqlDataReader CheckExist(int studentNo) { string strSql = "select * from Student where [StudentNo] = @studentNo"; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@studentNo", studentNo)); return(reader); }
//检查是否有班 public SqlDataReader IsStudentExists() { string strSql = "select * from Class where [ClassName] = @className and [CurrentCount] > 0 "; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@className", _className)); return(reader); }
//检查班级名是否已存在 public static SqlDataReader CheckExists(string className) { string strSql = "select * from Class where [className] = @className"; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@className", className)); return(reader); }
//判断教师是否已存在 public static SqlDataReader GetReaderByTeacherName(string teacherName) { string strSql = "select TeacherName from Teacher where [TeacherName] = @teacherName"; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@teacherName", teacherName)); return(reader); }
//判断该班是否已存在相应课程 public SqlDataReader GetDataReaderBySubjectName(string subjectName) { string strSql = "select * from Course where [ClassName] = @className and [SubjectName] = @subjectName "; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@className", _className), new SqlParameter("@subjectName", subjectName)); return(reader); }
//判断该学生是否已存在相应课程成绩 public static SqlDataReader GetReader(int studentNo, int courseID) { string strSql = "select * from Score where [StudentNo] = @studentNo and [CourseID] = @courseID"; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@studentNo", studentNo), new SqlParameter("@courseID", courseID)); return(reader); }
//通过课程名及班级名称得到CourseID public int GetCourseID() { string strSql = "select CourseID from Course where [ClassName] = @className and [SubjectName] = @subjectName"; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@className", _className), new SqlParameter("@subjectName", _subjectName)); reader.Read(); return(Int32.Parse(reader["CourseID"].ToString())); }
//通过姓名及班级名称得到StudentNo public static int GetStudentNo(string className, string studentName) { string strSql = "select StudentNo from Student where [ClassName] = @className and [StudentName] = @studentName"; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@className", className), new SqlParameter("@studentName", studentName)); reader.Read(); return(Int32.Parse(reader["StudentNo"].ToString())); }
public static Course CreateInstance(string className, string subjectName) { string strSql = "select * from Course where [ClassName] = @className and [SubjectName]= @subjectName"; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@className", className), new SqlParameter("@subjectName", subjectName)); Course objCourse = new Course(className, subjectName); reader.Read(); objCourse.Teacher = reader["Teacher"].ToString(); objCourse.BeginDate = DateTime.Parse(reader["BeginDate"].ToString()); objCourse.FinishDate = DateTime.Parse(reader["FinishDate"].ToString()); objCourse.Remark = reader["Remark"].ToString(); return(objCourse); }
public static Subject CreateInstance(string subjectName) { Subject objSubject = null; string strSql = "select * from Subject where [SubjectName] = @subjectName "; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@subjectName", subjectName)); if (reader.Read()) { objSubject = new Subject(subjectName); objSubject._period = Int32.Parse(reader["Period"].ToString()); objSubject._remark = reader["Remark"].ToString(); } reader.Close(); return(objSubject); }
public static Classes CreateInstance(string className) { Classes c = null; string strSql = "select * from Class where [ClassName] = @className "; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@className", className)); if (reader.Read()) { c = new Classes(className); c._director = reader["Director"].ToString(); c._currentCount = (Int32.Parse(reader["CurrentCount"].ToString())); c._entranceDate = (DateTime)reader["EntranceDate"]; c._remark = reader["Remark"].ToString(); } reader.Close(); return(c); }
public static Student CreateInstance(int studentNo) { Student s = null; string strSql = "select * from Student where [StudentNo] = @studentNo "; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@studentNo", studentNo)); if (reader.Read()) { s = new Student(studentNo); s._studentName = reader["StudentName"].ToString(); s._gender = reader["Gender"].ToString(); s._birthday = DateTime.Parse(reader["Birthday"].ToString()); s._className = reader["ClassName"].ToString(); s._picture = reader["Picture"].ToString(); s._remark = reader["Remark"].ToString(); } reader.Close(); return(s); }
public static Teacher CreateInstance(string teacherName) { DataAccess.Teacher objTeacher = null; string strSql = "select * from Teacher where [TeacherName] = @teacherName "; SqlCommon sqlcomm = new SqlCommon(); SqlDataReader reader = sqlcomm.ExecuteReader(strSql, new SqlParameter("@teacherName", teacherName)); if (reader.Read()) { objTeacher = new DataAccess.Teacher(teacherName); objTeacher.Gender = reader["Gender"].ToString(); objTeacher.Birthday = DateTime.Parse(reader["Birthday"].ToString()); objTeacher.IDCard = reader["IDCard"].ToString(); objTeacher.University = reader["University"].ToString(); objTeacher.Diploma = reader["Diploma"].ToString(); objTeacher.Picture = reader["Picture"].ToString(); objTeacher.Remark = reader["Remark"].ToString(); } reader.Close(); return(objTeacher); }