/// <summary>
/// 获取用户答题答案信息
/// </summary>
/// <returns>DataSet类型，返回用户答题答案信息数据集</returns>
public DataSet FillDs()
{
string str = "select distinct RANK()over(order by UserName) as ID,UserName,examTime,PaperID from UserAnswer inner join UserInfo on UserInfo.UserID=UserAnswer.userID";
SH.SqlCom(str, CommandType.Text);
return(SH.SqlFillDs());
}
/// <summary>
/// 获取角色授权信息数据集
/// </summary>
/// <param name="RoleID">角色编号</param>
/// <returns>DataSet类型，表示角色授权信息数据集</returns>
public DataSet FillDs(string RoleID)
{
string str = "select RoleID,RoleName,HasDuty_userManage,HasDuty_courseManage,HasDuty_paperSetup,HasDuty_userPaperList,HasDuty_Role,HasDuty_paperLists,HasDuty_userScore,HasDuty_QuestionManage from Role where RoleID=@RoleID";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@RoleID", RoleID);
return(SH.SqlFillDs());
}
/// <summary>
/// 获取用户成绩信息
/// </summary>
/// <param name="PaperID">试卷编号</param>
/// <returns>DataSet类型，返回用户成绩信息数据集</returns>
public DataSet FillDs(string PaperID)
{
string str = "select UserInfo.UserID,UserName,PaperID,Score,examTime,JudgeTime from UserInfo right join score on UserInfo.UserID=score.userID where 1=1";
if (PaperID != "")
{
str += (" and PaperID=" + PaperID);
}
SH.SqlCom(str, CommandType.Text);
return(SH.SqlFillDs());
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <returns>DateSet类型，返回用户信息数据集</returns>
public DataSet UserFill()
{
SH = new SqlHelp();
string str = "select UserID,UserName,RoleId from UserInfo";
SH.SqlCom(str, CommandType.Text);
return SH.SqlFillDs();
}
/// <summary>
/// 获取试卷信息数据集
/// </summary>
/// <returns>DataSet类型，表示试卷信息数据集</returns>
public DataSet FillDs()
{
string str = "select PaperID,PaperName from Paper select courseName,PaperName,PaperState from Paper left join Course on Paper.courseID=Course.courseID";
SH.SqlCom(str, CommandType.Text);
return(SH.SqlFillDs());
}
/// <summary>
/// 获取题库信息
/// </summary>
/// <returns>DataSet类型，返回单选题，多选题，判断题，填空题，简答题的数据集</returns>
public DataSet FillDs()
{
string str = "select*from singleProblem select*from multiProblem select*from judgeProblem select*from fillBlankProblem select*from questionProblem";
SH.SqlCom(str, CommandType.Text);
return(SH.SqlFillDs());
}
/// <summary>
/// 获取科目信息
/// </summary>
/// <returns>DataSet类型，返回科目信息数据集</returns>
public DataSet FillDs()
{
string str = "select *from Course";
SH.SqlCom(str, CommandType.Text);
return(SH.SqlFillDs());
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <returns>DateSet类型，返回用户信息数据集</returns>
public DataSet UserFill()
{
SH = new SqlHelp();
string str = "select UserID,UserName,RoleId from UserInfo";
SH.SqlCom(str, CommandType.Text);
return(SH.SqlFillDs());
}
/// <summary>
/// 获取试卷临时详细信息
/// </summary>
/// <param name="Type">试题类型</param>
/// <returns>DataSet类型，返回试卷临时详细信息数据集</returns>
public DataSet FillDs(List <PaperDetail> pd, string Type)
{
string str = "if exists (select name from sysobjects where type='u' and name='a')drop table a create table a(type varchar(50),titleID int,Mark int,WriteTime int)";
SH.SqlCom(str, CommandType.Text);
SH.SqlENQ();
foreach (PaperDetail a in pd)
{
str = "insert a values(@type,@titleID,@Mark,@WriteTime)";
string[] str0 = { "@type", "@titleID", "@Mark", "@WriteTime" };
string[] str1 = { a.Type, a.TitleID.ToString(), a.Mark.ToString(), a.WriteTime.ToString() };
SH.SqlCom(str, CommandType.Text);
SH.SqlPar(str0, str1);
SH.SqlES();
}
string strsql = "";
switch (Type)
{
case "singleProblem":
strsql = "select a.*,courseID,title,answerA,answerB,answerC,answerD,answer from a left join singleProblem on a.TitleID=singleProblem.ID where Type=@type";
break;
case "multiProblem":
strsql = "select a.*,courseID,title,answerA,answerB,answerC,answerD,answer from a left join multiProblem on a.TitleID=multiProblem.ID where Type=@type";
break;
case "judgeProblem":
strsql = "select a.*,courseID,title,answer from a left join judgeProblem on a.TitleID=judgeProblem.ID where Type=@type";
break;
case "fillBlankProblem":
strsql = "select a.*,courseID,FrontTitle,backTitle,answer from a left join fillBlankProblem on a.TitleID=fillBlankProblem.ID where Type=@type";
break;
case "questionProblem":
strsql = "select a.*,courseID,Title,answer from a left join questionProblem on a.TitleID=questionProblem.ID where Type=@type";
break;
default:
break;
}
SH.SqlCom(strsql, CommandType.Text);
SH.SqlPar("@type", Type);
return(SH.SqlFillDs());
}
/// <summary>
/// 读取用户信息
/// </summary>
/// <param name="UserID">用户编号</param>
/// <returns>UserInfo类型，存储用户信息实体</returns>
public UserInfo UserRead(string UserID)
{
SH = new SqlHelp();
string str = "select UserID,UserPwd,UserName,RoleId from UserInfo where UserID=@UserID";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserID", UserID);
DataSet ds = SH.SqlFillDs();
UserInfo user = new UserInfo(ds.Tables[0].Rows[0].ItemArray[0].ToString(), ds.Tables[0].Rows[0].ItemArray[1].ToString(), ds.Tables[0].Rows[0].ItemArray[2].ToString(), (int)ds.Tables[0].Rows[0].ItemArray[3]);
return(user);
}
/// <summary>
/// 读取用户信息
/// </summary>
/// <param name="UserID">用户编号</param>
/// <returns>UserInfo类型，存储用户信息实体</returns>
public UserInfo UserRead(string UserID)
{
SH = new SqlHelp();
string str = "select UserID,UserPwd,UserName,RoleId from UserInfo where UserID=@UserID";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserID", UserID);
DataSet ds= SH.SqlFillDs();
UserInfo user =new UserInfo( ds.Tables[0].Rows[0].ItemArray[0].ToString(), ds.Tables[0].Rows[0].ItemArray[1].ToString(), ds.Tables[0].Rows[0].ItemArray[2].ToString(), (int)ds.Tables[0].Rows[0].ItemArray[3] );
return user;
}