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" } })); }