//判断用户是否为管理员
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);
}
