예제 #1
0
 //查询所用试卷
 //不需要参数
 public DataSet QueryAllPaper()
 {
     DataBase DB = new DataBase();
     string strsql = "SELECT *,CASE Papermr.PaperState WHEN 1 THEN '可用'  ELSE  '不可用'  END AS state FROM Papermr,Coursemr where Papermr.CourseID=Coursemr.ID";
     return DB.GetStrDataSet(strsql);
 }
예제 #2
0
 //查询所有用户考试的试卷
 public DataSet QueryUserPaperList()
 {
     DataBase DB = new DataBase();
     string strsql = "SELECT distinct Usersmr.UserID,Usersmr.UserName,Usersmr.DepartmentId, Departmentmr.DepartmentId,Departmentmr.DepartmentName,UserAnswermr.UserID,UserAnswermr.PaperID,UserAnswermr.ExamTime,UserAnswermr.state,Papermr.PaperName FROM Usersmr,Departmentmr,UserAnswermr,Papermr where Usersmr.DepartmentId=Departmentmr.DepartmentId and Usersmr.UserID=UserAnswermr.UserID and UserAnswermr.PaperID=Papermr.PaperID order by UserAnswermr.ExamTime desc";
     return DB.GetStrDataSet(strsql);
 }
예제 #3
0
 //查询所用考试科目
 //不需要带参数
 public DataSet QueryCourse()
 {
     DataBase DB = new DataBase();
     string strsql = "select * from Coursemr";
     return DB.GetStrDataSet(strsql);
 }
예제 #4
0
 //查询用户
 //查询所用用户
 //不需要参数
 public DataSet QueryUsers()
 {
     DataBase DB = new DataBase();
     string strsql = "SELECT Usersmr.UserID,	Usersmr.UserName,Departmentmr.DepartmentName,Rolemr.RoleName FROM Usersmr,Departmentmr,Rolemr WHERE Usersmr.DepartmentId=Departmentmr.DepartmentId AND Usersmr.RoleId=Rolemr.RoleId";
     //return DB.GetDataSet("Proc_UsersList");
     return DB.GetStrDataSet(strsql);
 }
예제 #5
0
 //查询所用成绩
 //不需要参数
 public DataSet QueryScore()
 {
     DataBase DB = new DataBase();
     string strsql = "SELECT Usersmr.UserID,	Usersmr.UserName,Scoremr.ID,Scoremr.Score,Scoremr.ExamTime,Scoremr.JudgeTime, Papermr.PaperID,Papermr.PaperName FROM Usersmr,Scoremr,Papermr where Usersmr.UserID=Scoremr.UserID and Scoremr.PaperID=Papermr.PaperID";
     //return DB.GetDataSet("Proc_ScoreList");
     return DB.GetStrDataSet(strsql);
 }
예제 #6
0
 public DataSet QueryDepartment()
 {
     DataBase DB = new DataBase();
     string sqlstr = "SELECT DepartmentId,DepartmentName FROM Departmentmr";
     return DB.GetStrDataSet(sqlstr);
 }
예제 #7
0
 //��ѯ���н�ɫ
 //����Ҫ����
 public DataSet QueryRole()
 {
     DataBase DB = new DataBase();
     string sqlstr = "SELECT Rolemr.RoleId,Rolemr.RoleName FROM Rolemr";
     return DB.GetStrDataSet(sqlstr);
 }