/// <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="pd">试卷详细信息实体集的泛型集合</param>
public void Add(List <PaperDetail> pd)
{
foreach (PaperDetail a in pd)
{
string str = "select count(*) from PaperDetail";
SH.SqlCom(str, CommandType.Text);
string ID = ((int)SH.SqlES() + 1).ToString();
str = "insert PaperDetail values(@ID,@PaperID,@type,@titleID,@Mark,@WriteTime)";
string[] str0 = { "@ID", "@PaperID", "@type", "@titleID", "@Mark", "@WriteTime" };
string[] str1 = { ID, a.PaperID.ToString(), a.Type, a.TitleID.ToString(), a.Mark.ToString(), a.WriteTime.ToString() };
SH.SqlCom(str, CommandType.Text);
SH.SqlPar(str0, str1);
SH.SqlENQ();
}
}
/// <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>
/// 获取Command和Parmeter
/// </summary>
/// <param name="str">Command语句</param>
/// <param name="User">用户信息实体</param>
void UserNCP(string str, UserInfo User, CommandType ct)
{
SH = new SqlHelp();
SH.SqlCom(str, ct);
SH.SqlPar("@userID", User.UserID);
SH.SqlPar("@userPwd", User.UserPwd);
}
/// <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="UserID">用户编号</param>
/// <returns>string类型，返回字符串类型用户姓名</returns>
public string GetUserName(string UserID)
{
SH = new SqlHelp();
string str = "select UserName from UserInfo where UserID=@UserID";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserID", UserID);
return SH.SqlES().ToString();
}
/// <summary>
/// 获取用户编号
/// </summary>
/// <param name="userName">用户姓名</param>
/// <returns>string类型，返回字符串类型用户编号</returns>
public string GetUserID(string userName)
{
SH = new SqlHelp();
string str = "select UserID from UserInfo where UserName=@UserName";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserName", userName);
return SH.SqlES().ToString();
}
/// <summary>
/// 获取用户编号
/// </summary>
/// <param name="userName">用户姓名</param>
/// <returns>string类型，返回字符串类型用户编号</returns>
public string GetUserID(string userName)
{
SH = new SqlHelp();
string str = "select UserID from UserInfo where UserName=@UserName";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserName", userName);
return(SH.SqlES().ToString());
}
/// <summary>
/// 获取用户姓名
/// </summary>
/// <param name="UserID">用户编号</param>
/// <returns>string类型，返回字符串类型用户姓名</returns>
public string GetUserName(string UserID)
{
SH = new SqlHelp();
string str = "select UserName from UserInfo where UserID=@UserID";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserID", UserID);
return(SH.SqlES().ToString());
}
/// <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>
/// <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>
/// <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 Course";
SH.SqlCom(str, CommandType.Text);
return(SH.SqlFillDs());
}
/// <summary>
/// 判断是否存在用户
/// </summary>
/// <param name="UserID">用户编号</param>
/// <returns>bool类型，不存在返回true，存在返回false值</returns>
public bool GetUser(string UserID)
{
string str = "select count(*) from UserInfo where UserID=@UserID";
SH.SqlCom(str, CommandType.Text);
SH.SqlPar("@UserID", UserID);
if ((int)SH.SqlES() == 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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 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="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>
/// 获取Command和Parmeter
/// </summary>
/// <param name="str">Command语句</param>
/// <param name="User">用户信息实体</param>
void UserNCP(string str,UserInfo User,CommandType ct)
{
SH = new SqlHelp();
SH.SqlCom(str, ct);
SH.SqlPar("@userID", User.UserID);
SH.SqlPar("@userPwd", User.UserPwd);
}
