public object get(string id)
{
Attendance att = null;
string selectSql = "SELECT * FROM t_attendance WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", id) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
att = new Attendance();
att.Id = ds.Tables[0].Rows[0][0].ToString();
att.Status = ds.Tables[0].Rows[0][1].ToString();
att.Remark = ds.Tables[0].Rows[0][2].ToString();
att.Recorder = ds.Tables[0].Rows[0][3].ToString();
att.RecorderID = ds.Tables[0].Rows[0][4].ToString();
att.StudID = ds.Tables[0].Rows[0][5].ToString();
att.CourTableID = ds.Tables[0].Rows[0][6].ToString();
}
return(att);
}
public object get(string id)
{
Class clazz = null;
string selectSql = "SELECT * FROM t_class WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", id) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
clazz = new Class();
clazz.Id = ds.Tables[0].Rows[0][0].ToString();
clazz.Depart = ds.Tables[0].Rows[0][1].ToString();
clazz.Grade = ds.Tables[0].Rows[0][2].ToString();
clazz.Name = ds.Tables[0].Rows[0][3].ToString();
clazz.StudCount = ds.Tables[0].Rows[0][4].ToString();
clazz.MonitorID = ds.Tables[0].Rows[0][5].ToString();
clazz.TeacherID = ds.Tables[0].Rows[0][6].ToString();
}
return(clazz);
}
public object getByUserId(string userId)
{
Student stu = null;
string selectSql = "SELECT * FROM t_student WHERE userID=@userID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@userID", userId) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
stu = new Student();
stu.Id = ds.Tables[0].Rows[0][0].ToString();
stu.StuId = ds.Tables[0].Rows[0][1].ToString();
stu.Name = ds.Tables[0].Rows[0][2].ToString();
stu.Gender = ds.Tables[0].Rows[0][3].ToString();
stu.Birth = ds.Tables[0].Rows[0][4].ToString();
stu.Phone = ds.Tables[0].Rows[0][5].ToString();
stu.Address = ds.Tables[0].Rows[0][6].ToString();
stu.ClassID = ds.Tables[0].Rows[0][7].ToString();
stu.UserID = ds.Tables[0].Rows[0][8].ToString();
}
return(stu);
}
public object getByUserId(string userId)
{
Staff staff = null;
string selectSql = "SELECT * FROM t_staff WHERE userID=@userID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@userID", userId) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
staff = new Staff();
staff.Id = ds.Tables[0].Rows[0][0].ToString();
staff.Name = ds.Tables[0].Rows[0][1].ToString();
staff.Gender = ds.Tables[0].Rows[0][2].ToString();
staff.Birth = ds.Tables[0].Rows[0][3].ToString();
staff.Phone = ds.Tables[0].Rows[0][4].ToString();
staff.Type = ds.Tables[0].Rows[0][5].ToString();
staff.UserId = ds.Tables[0].Rows[0][6].ToString();
}
return(staff);
}
public object get(string id)
{
CourseTable courTable = null;
string selectSql = "SELECT * FROM t_courseTable WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", id) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
courTable = new CourseTable();
courTable.Id = ds.Tables[0].Rows[0][0].ToString();
courTable.Semester = ds.Tables[0].Rows[0][1].ToString();
courTable.Week = ds.Tables[0].Rows[0][2].ToString();
courTable.WeekDay = ds.Tables[0].Rows[0][3].ToString();
courTable.Place = ds.Tables[0].Rows[0][4].ToString();
courTable.CourseTime = ds.Tables[0].Rows[0][5].ToString();
courTable.TeachID = ds.Tables[0].Rows[0][6].ToString();
courTable.ClassID = ds.Tables[0].Rows[0][7].ToString();
courTable.CourId = ds.Tables[0].Rows[0][8].ToString();
}
return(courTable);
}
public object get(string id)
{
Teacher teacher = null;
string selectSql = "SELECT * FROM t_teacher WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", id) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
teacher = new Teacher();
teacher.Id = ds.Tables[0].Rows[0][0].ToString();
teacher.TeacherId = ds.Tables[0].Rows[0][1].ToString();
teacher.Name = ds.Tables[0].Rows[0][2].ToString();
teacher.Gender = ds.Tables[0].Rows[0][3].ToString();
teacher.Birth = ds.Tables[0].Rows[0][4].ToString();
teacher.Title = ds.Tables[0].Rows[0][5].ToString();
teacher.Phone = ds.Tables[0].Rows[0][6].ToString();
teacher.Email = ds.Tables[0].Rows[0][7].ToString();
teacher.UserID = ds.Tables[0].Rows[0][8].ToString();
}
return(teacher);
}
public DataSet getByTeacherId(string teachId)
{
string selectSql = "SELECT * FROM t_class WHERE teacherID=@teacherID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@teacherID", teachId) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getByClassId(string classId)
{
string selectSql = "SELECT * FROM t_student where classID=@classID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@classID", classId) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getAboutMonitor()
{
string selectSql = "SELECT * FROM t_attendance WHERE recorder='班长' AND courTableID in (SELECT ID FROM t_courseTable WHERE semester=@semester)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", GlobalVars.SEMESTER) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getAboutTeacher(string week)
{
string selectSql = "SELECT * FROM t_attendance WHERE recorder='教师' AND courTableID in (SELECT ID FROM t_courseTable WHERE semester=@semester AND week=@week)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", GlobalVars.SEMESTER),
new SqlParameter("@week", week) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getByClassIdAboutTeacher(string classId)
{
string selectSql = "SELECT * FROM t_attendance WHERE recorder='教师' AND studID in (SELECT ID FROM t_student WHERE classID=@classID) AND courTableID in (SELECT ID FROM t_courseTable WHERE semester=@semester)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@classId", classId),
new SqlParameter("@semester", GlobalVars.SEMESTER) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getByClassId(string classId)
{
string selectSql = "SELECT * FROM t_course WHERE ID in (SELECT distinct courId FROM t_courseTable WHERE classID=@classID AND semester=@semester)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@classID", classId),
new SqlParameter("@semester", GlobalVars.SEMESTER) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getByRecordId(string recordId)
{
string selectSql = "SELECT * FROM t_attendance WHERE recorderID=@recordID AND courTableID in (SELECT ID FROM t_courseTable WHERE semester=@semester)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", GlobalVars.SEMESTER),
new SqlParameter("@recordID", recordId) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getByParas(string semester, string teacherID)
{
string selectSql = "SELECT * FROM t_courseTable WHERE semester=@semester and teachID=@teachID ORDER BY courseTime";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", semester),
new SqlParameter("@teachID", teacherID) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getByTCC(string semester, string teacherID, string classID, string courID)
{
string selectSql = "SELECT * FROM t_courseTable WHERE semester=@semester and teachID=@teachID and classID=@classID and courId=@courID ORDER BY week";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", semester),
new SqlParameter("@teachID", teacherID),
new SqlParameter("@classID", classID),
new SqlParameter("@courID", courID) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public DataSet getByParas(string semester, string week, string weekDay, string classID)
{
string selectSql = "SELECT * FROM t_courseTable WHERE semester=@semester and week=@week and weekDay=@weekDay and classID=@classID ORDER BY courseTime";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", semester),
new SqlParameter("@week", week),
new SqlParameter("@weekDay", weekDay),
new SqlParameter("@classID", classID) };
return(SQLServerDBUtil.query(selectSql, sqlParas));
}
public object getByUsername(string username)
{
User user = null;
string selectSql = "SELECT * FROM t_user WHERE username=@username";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@username", username) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
user = new User();
user.Id = ds.Tables[0].Rows[0][0].ToString();
user.UserName = ds.Tables[0].Rows[0][1].ToString();
user.Password = ds.Tables[0].Rows[0][2].ToString();
user.Type = ds.Tables[0].Rows[0][3].ToString();
}
return(user);
}
public object get(string id)
{
Course course = null;
string selectSql = "SELECT * FROM t_course WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", id) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
course = new Course();
course.Id = ds.Tables[0].Rows[0][0].ToString();
course.Name = ds.Tables[0].Rows[0][1].ToString();
course.Credit = ds.Tables[0].Rows[0][2].ToString();
course.SchoolHour = ds.Tables[0].Rows[0][3].ToString();
}
return(course);
}
public DataSet getAll()
{
string selectSql = "SELECT * FROM t_user";
return(SQLServerDBUtil.query(selectSql, null));
}
public System.Data.DataSet getAll()
{
string selectSql = "SELECT * FROM t_class";
return(SQLServerDBUtil.query(selectSql, null));
}
public DataSet getTeachers()
{
string selectSql = "SELECT * FROM t_teacher WHERE title!='辅导员'";
return(SQLServerDBUtil.query(selectSql, null));
}
