//查询填空题 //课程编号 public DataSet QueryFillBlankProblem(int TCourseID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT FillBlankProblemmr.ID, FillBlankProblemmr.FrontTitle,FillBlankProblemmr.BackTitle FROM FillBlankProblemmr where CourseID=@CourseID"; Params[0] = DB.MakeInParam("@CourseID", SqlDbType.Int, 4, TCourseID); //题目编号 return DB.GetStrDataSetSql(strsql, Params); }
//查询所用可用试卷 //不需要参数 public DataSet QueryPaper() { DataBase DB = new DataBase(); string strsql = "SELECT Papermr.PaperID,Papermr.PaperName FROM Papermr where PaperState=@paperState"; SqlParameter[] Params = new SqlParameter[1]; Params[0] = DB.MakeInParam("@PaperState", SqlDbType.Bit,1, "true"); //题目编号 //return DB.GetDataSet("Proc_PaperUseList",Params); return DB.GetStrDataSetSql(strsql, Params); }
//��ѯ�ʴ��� //�γ̱�� public DataSet QueryQuestionProblem(int TCourseID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT QuestionProblemmr.ID,QuestionProblemmr.Title FROM QuestionProblemmr where CourseID=@CourseID"; Params[0] = DB.MakeInParam("@CourseID", SqlDbType.Int, 4, TCourseID); //��Ŀ��� return DB.GetStrDataSetSql(strsql, Params); }
//根据题目ID 初始化题目 //输入: // TID - 题目编号; //输出: // 如果考试题目存在:返回True; // 如果考试题目不在:返回False; public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT * FROM FillBlankProblemmr where ID=@ID"; Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //用户编号 DataSet ds = DB.GetStrDataSetSql(strsql, Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //科目编号 this._FrontTitle = GetSafeData.ValidateDataRow_S(DR, "FrontTitle"); //题目前部分 this._BackTitle = GetSafeData.ValidateDataRow_S(DR, "BackTitle"); //题目后部分 this._Answer = GetSafeData.ValidateDataRow_S(DR, "Answer"); //答案 return true; } else { return false; } }
//������ĿID ��ʼ����Ŀ //���룺 // TID - ��Ŀ��ţ� //����� // ���������Ŀ���ڣ�����True�� // ���������Ŀ���ڣ�����False�� public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT * FROM QuestionProblemmr where ID=@ID"; Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //�û���� DataSet ds = DB.GetStrDataSetSql(strsql, Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._CourseID = GetSafeData.ValidateDataRow_N(DR, "CourseID"); //��Ŀ��� this._Title = GetSafeData.ValidateDataRow_S(DR, "Title"); //��Ŀ this._Answer = GetSafeData.ValidateDataRow_S(DR, "Answer"); //�� return true; } else { return false; } }
//根据用户 UserID 初始化该用户 //输入: // XUserID - 用户编号; //输出: // 用户存在:返回True; // 用户不在:返回False; public bool LoadData(string XUserID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID); //用户编号 string strsql = "SELECT * FROM Usersmr,Departmentmr,Rolemr WHERE UserID=@UserID AND Usersmr.DepartmentId = Departmentmr.DepartmentId And Usersmr.RoleId = Rolemr.RoleId"; DataSet ds = DB.GetStrDataSetSql(strsql, Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR= ds.Tables[0].Rows[0]; this._userID = GetSafeData.ValidateDataRow_S(DR, "UserID"); //用户编号 this._userName = GetSafeData.ValidateDataRow_S(DR, "UserName"); //用户姓名 this._userPwd = GetSafeData.ValidateDataRow_S(DR, "UserPwd"); //用户密码 this._department = GetSafeData.ValidateDataRow_N(DR, "DepartmentId"); //所在部门 this._roleid = GetSafeData.ValidateDataRow_N(DR, "RoleId"); //用户权限 this._rolename = GetSafeData.ValidateDataRow_S(DR, "RoleName"); //用户权限 //获取权限集合 string colName = ""; for (int i = 0; i < DR.ItemArray.Length; i++) { colName = DR.Table.Columns[i].ColumnName; if (colName.StartsWith("HasDuty_") && GetSafeData.ValidateDataRow_N(DR, colName) == 1) { this._duties.Add(DR.Table.Columns[i].ColumnName.Substring(8)); //去掉前缀“HasDuty_” } } return true; } else { return false; } }
//查询某个用户成绩 public DataSet QueryUserScore(string XUserID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT Usersmr.UserID,Usersmr.UserName,Scoremr.ID,Scoremr.Score,Scoremr.ExamTime,Scoremr.JudgeTime,Scoremr.PingYu,Papermr.PaperID,Papermr.PaperName FROM Usersmr,Scoremr,Papermr WHERE Usersmr.UserID=Scoremr.UserID and Scoremr.PaperID=Papermr.PaperID and Usersmr.UserID=@UserID order by Scoremr.ExamTime"; Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20,XUserID); return DB.GetStrDataSetSql(strsql, Params); }
//查询判断题 //课程编号 public DataSet QueryJudgeProblem(int TCourseID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT JudgeProblemmr.ID, JudgeProblemmr.Title FROM JudgeProblemmr where [CourseID]=@CourseID"; Params[0] = DB.MakeInParam("@CourseID", SqlDbType.Int, 4, TCourseID); //题目编号 return DB.GetStrDataSetSql(strsql, Params); }
/// <summary> /// ���ݲ���departmentId����ȡ��ʦϵ����ϸ��Ϣ /// </summary> /// <param name="topicID">ϵ��ID</param> public bool LoadData(int DepartmentId) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string sqlstr = " SELECT * FROM Departmentmr WHERE DepartmentId =@DepartmentId"; Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId); //�û���� DataSet ds = DB.GetStrDataSetSql(sqlstr, Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._departmentId = GetSafeData.ValidateDataRow_N(DR, "DepartmentId"); this._departmentName = GetSafeData.ValidateDataRow_S(DR, "DepartmentName"); return true; } else { return false; } }