//查询填空题
//课程编号
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;
}
}
