public int UpdateExercisesTitle(ExercisesTitle info)
{
string strSql = "update ExercisesTitle set TitleInfoId=@TitleInfoId,ExercisesTestId=@ExercisesTestId,ExercisesTitleIndex=@ExercisesTitleIndex,UpdateDateTime=@UpdateDateTime where ExercisesTitleId=@ExercisesTitleId";
return(DBFactory.GetDB(DBType.SQLITE, m_strConn).ExecuteNonQuery(strSql, new DbParameter[] {
new SQLiteParameter()
{
Value = info.TitleInfoId, ParameterName = "@TitleInfoId"
},
new SQLiteParameter()
{
Value = info.ExercisesTestId, ParameterName = "@ExercisesTestId"
},
new SQLiteParameter()
{
Value = info.ExercisesTitleIndex, ParameterName = "@ExercisesTitleIndex"
},
new SQLiteParameter()
{
Value = info.ExercisesTitleId, ParameterName = "@ExercisesTitleId"
},
new SQLiteParameter()
{
Value = info.UpdateDateTime, ParameterName = "@UpdateDateTime"
}
}));
}
///// <summary>
///// 获取某场考试下的所有题目
///// </summary>
///// <param name="ExercisesTestId"></param>
///// <returns></returns>
//public List<ExercisesTitle> GetExercisesTest(int ExercisesTestId)
//{
// string strSql = "select * from ExercisesTitle where ExercisesTestId=@ExercisesTestId";
// return DataTableToList(DBFactory.GetDB(DBType.SQLITE, m_strConn).ExecuteStrSql(strSql, new DbParameter[]{
// new SQLiteParameter(){ Value=ExercisesTestId, ParameterName="@ExercisesTestId"}}));
//}
private List <ExercisesTitle> DataTableToList(DataTable dt)
{
List <ExercisesTitle> listInfo = new List <ExercisesTitle>();
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
ExercisesTitle info = new ExercisesTitle();
info.ExercisesTestId = dr["ExercisesTestId"] == DBNull.Value ? -100 : Convert.ToInt32(dr["ExercisesTestId"]);
info.ExercisesTitleId = dr["ExercisesTitleId"] == DBNull.Value ? -100 : Convert.ToInt32(dr["ExercisesTitleId"]);
info.TitleInfoId = dr["TitleInfoId"] == DBNull.Value ? -100 : Convert.ToInt32(dr["TitleInfoId"]);
info.ExercisesTitleIndex = dr["ExercisesTitleIndex"] == DBNull.Value ? -100 : Convert.ToInt32(dr["ExercisesTitleIndex"]);
info.CorrectAnswer = dr["CorrectAnswer"] == DBNull.Value ? -100 : Convert.ToInt32(dr["CorrectAnswer"]);
info.Score = dr["Score"] == DBNull.Value ? -100 : Convert.ToInt32(dr["Score"]);
info.TitleConent = dr["TitleConent"] == DBNull.Value ? "" : dr["TitleConent"].ToString();
if (dr["UpdateDateTime"] != DBNull.Value)
{
DateTime datetime;
DateTime.TryParse(dr["UpdateDateTime"].ToString(), out datetime);
info.UpdateDateTime = datetime;
}
listInfo.Add(info);
}
}
return(listInfo);
}
public ActionResult AddExercisesTitle(ExercisesTitle info)
{
int result = ExercisesTitlebll.AddExercisesTitle(info);
var res = new ConfigurableJsonResult();
res.Data = result;
HttpContext.Response.AppendHeader("Access-Control-Allow-Origin", "*");
return(res);
}
/// <summary>
/// 判断 考试中是否存在某题目
/// </summary>
/// <param name="info">只取考试ID与题目ID</param>
/// <returns></returns>
public ActionResult IsExistExercisesTitle(ExercisesTitle info)
{
bool result = ExercisesTitlebll.IsExistExercisesTitle(info.ExercisesTestId, info.TitleInfoId);
var res = new ConfigurableJsonResult();
res.Data = result == true ? 1 : 0;
HttpContext.Response.AppendHeader("Access-Control-Allow-Origin", "*");
return(res);
}
/// <summary>
/// 增加考试与题目的对应关系
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int AddExercisesTitle(ExercisesTitle info)
{
string strSql = "insert into ExercisesTitle (TitleInfoId,ExercisesTestId,ExercisesTitleIndex,UpdateDateTime) values (@TitleInfoId,@ExercisesTestId,@ExercisesTitleIndex,@UpdateDateTime)";
return(DBFactory.GetDB(DBType.SQLITE, m_strConn).ExecuteNonQuery(strSql, new DbParameter[] {
new SQLiteParameter()
{
Value = info.TitleInfoId, ParameterName = "@TitleInfoId"
},
new SQLiteParameter()
{
Value = info.ExercisesTestId, ParameterName = "@ExercisesTestId"
},
new SQLiteParameter()
{
Value = info.ExercisesTitleIndex, ParameterName = "@ExercisesTitleIndex"
},
new SQLiteParameter()
{
Value = info.UpdateDateTime, ParameterName = "@UpdateDateTime"
}
}));
}
