public bool CheckExist(string UserID, int PaperID)
{
SqlParameter[] Params = new SqlParameter[2];
DataBase DB = new DataBase();
string strsql = " SELECT * FROM TempExam WHERE UserID =@UserID and PaperID= @PaperID";
Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, UserID);
Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, PaperID);
SqlDataReader DR = DB.RunStrGetReader(strsql, Params);
if (!DR.HasRows)//DR.Read())
{
return false;
}
else
{
return true;
}
}
/// <summary>
/// 检测课程名是否已经存在
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public bool IsCourseNameExist(string Name)
{
SqlParameter[] Params = new SqlParameter[1];
DataBase DB = new DataBase();
string strsql = "SELECT * FROM Course WHERE Name=@Name";
Params[0] = DB.MakeInParam("@Name", SqlDbType.VarChar, 200, Name);
SqlDataReader DR = DB.RunStrGetReader(strsql, Params);
if (!DR.Read())
{
return false;
}
else
{
return true;
}
}
//判断是否已经考试
public bool IsTest(string UserID, int PaperID)
{
SqlParameter[] Params = new SqlParameter[2];
DataBase DB = new DataBase();
string strsql = "SELECT * FROM UserAnswertb WHERE UserID=@UserID AND PaperID=@PaperID";
Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, UserID);
Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, PaperID);
SqlDataReader DR = DB.RunStrGetReader(strsql, Params);
if (!DR.Read())
{
return false;
}
else
{
return true;
}
}
public bool GetBeginTime(string UserID, int PaperID)
{
SqlParameter[] Params = new SqlParameter[2];
DataBase DB = new DataBase();
string strsql = "SELECT BeginTime FROM TempExam WHERE PaperID=@PaperID and UserID=@UserID";
Params[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, PaperID);
Params[1] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, UserID);
SqlDataReader DR = DB.RunStrGetReader(strsql, Params);
if (!DR.Read())
{
return false;
}
else
{
this.BeginTime = (DateTime)DR[0];//获取考试开始的时间
return true;
}
}
/// <summary>
/// 获取考试需要的时间
/// </summary>
/// <param name="PaperID"></param>
/// <returns></returns>
public bool GetNeedTime(int PaperID)
{
SqlParameter[] Params = new SqlParameter[1];
DataBase DB = new DataBase();
string strsql = "SELECT NeedTime FROM paper WHERE PaperID=@PaperID";
Params[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, PaperID);
SqlDataReader DR = DB.RunStrGetReader(strsql, Params);
if (!DR.Read())
{
return false;
}
else
{
this.needtime = (int)DR[0];//获取考试需要的时间
return true;
}
}
