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