public JudgeItemDTO(JudgeItem judgeItem)
{
this.ID = judgeItem.ID;
this.ChapterID = judgeItem.ChapterID;
this.Title = judgeItem.Title;
this.Image = judgeItem.Image;
this.Answer = judgeItem.Answer;
this.Annotation = judgeItem.Annotation;
this.Difficulty = judgeItem.Difficulty;
this.AddPerson = judgeItem.AddPerson;
this.AddTime = judgeItem.AddTime;
}
/// <summary>
/// 添加实体信息,返回添加成功后的主键ID
/// </summary>
public int Insert(JudgeItem judge)
{
int id = 0;
const string sql = @"INSERT INTO JudgeItem(ChapterID, Title, Image, Answer, Annotation, Difficulty, AddPerson)
VALUES (@ChapterID, @Title, @Image, @Answer, @Annotation, @Difficulty, @AddPerson);
SELECT LAST_INSERT_ID();";
using (DbConnection connection = ConnectionManager.OpenConnection)
{
id = connection.Query<int>(sql, judge).SingleOrDefault<int>();
}
return id;
}
public ActionResult AddJudge()
{
log.Debug(Constant.DEBUG_START);
string chapterIDString = ApiQueryUtil.QueryArgByPost("chapter_id");
string title = ApiQueryUtil.QueryArgByPost("title");
HttpPostedFileBase imageFile = Request.Files["image"];
string answerString = ApiQueryUtil.QueryArgByPost("answer");
string annotation = ApiQueryUtil.QueryArgByPost("annotation");
string difficultyString = ApiQueryUtil.QueryArgByPost("difficulty");
ServiceInvokeDTO result = null;
try
{
JudgeItem judge = new JudgeItem();
judge.ChapterID = Convert.ToInt32(chapterIDString);
judge.Title = title;
judge.Answer = Convert.ToInt32(answerString);
judge.Annotation = annotation;
judge.Difficulty = Convert.ToInt32(difficultyString);
judge.AddPerson = (Session[Constant.SESSION_KEY_ADMIN] as Teacher).ChineseName;
if (imageFile != null)
{
byte[] imageBytes = null;
using (Stream inputStream = imageFile.InputStream)
{
MemoryStream memoryStream = inputStream as MemoryStream;
if (memoryStream == null)
{
memoryStream = new MemoryStream();
inputStream.CopyTo(memoryStream);
}
imageBytes = memoryStream.ToArray();
}
judge.Image = imageBytes;
}
result = itemDataService.AddJudge(judge);
}
catch (Exception ex)
{
log.Error(ex);
result = new ServiceInvokeDTO(InvokeCode.SYS_INNER_ERROR);
}
string json = JsonConvert.SerializeObject(result, Formatting.Indented, Constant.TIME_CONVERTER);
log.Debug(Constant.DEBUG_END);
return Content(json, Constant.JSON_MIME_TYPE);
}
/// <summary>
/// 更新判断题
/// </summary>
public ServiceInvokeDTO UpdateJudge(JudgeItem judge)
{
log.Debug(Constant.DEBUG_START);
ServiceInvokeDTO result = null;
try
{
judgeDAL.Update(judge);
result = new ServiceInvokeDTO(InvokeCode.SYS_INVOKE_SUCCESS);
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
log.Debug(Constant.DEBUG_END);
return result;
}
/// <summary>
/// 更新实体信息
/// </summary>
public void Update(JudgeItem judge)
{
const string sql = @"UPDATE JudgeItem SET ChapterID = @ChapterID,Title= @Title,
Image = @Image, Answer = @Answer, Annotation = @Annotation, Difficulty = @Difficulty
WHERE IsDeleted = 0 AND ID = @ID";
using (DbConnection connection = ConnectionManager.OpenConnection)
{
connection.Execute(sql, judge);
}
}
/// <summary>
/// 读取判断题题库模板数据
/// </summary>
/// <param name="teacher">老师对象</param>
/// <param name="courseID">课程主键ID</param>
/// <param name="fileName">Excel文件路径名称</param>
/// <param name="isFirstRowTitle">第一行是否为标题</param>
public static List<JudgeItem> ReadJudgeTemplate(Teacher teacher, int courseID, string fileName, bool isFirstRowTitle)
{
List<JudgeItem> judges = new List<JudgeItem>();
// 获取所有章节
ServiceInvokeDTO<List<Chapter>> chaptersResult = ServiceFactory.Instance.ItemDataService.GetAgencyChapters(courseID);
if (chaptersResult.Code == InvokeCode.SYS_INVOKE_SUCCESS && chaptersResult.Data != null && chaptersResult.Data.Count > 0)
{
List<Chapter> chapters = chaptersResult.Data;
using (FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read))
{
// 默认读取第一张表
IWorkbook workBook = WorkbookFactory.Create(fs);
ISheet sheet = workBook.GetSheetAt(0);
int startRowIndex = 0;
if (isFirstRowTitle && sheet.LastRowNum >= 1)
{
startRowIndex = 1;
}
for (int index = startRowIndex; index <= sheet.LastRowNum; index++)
{
IRow row = sheet.GetRow(index);
if (row != null)
{
// 所属章节
ICell chapterCell = row.GetCell(1); if (chapterCell == null) { throw new ArgumentException(TEXT_EMPTY_ERROR); }
string chapterName = chapterCell.ToString().Trim();
int chapterID = 0;
foreach (var chapter in chapters)
{
if (chapterName.Equals(chapter.Name))
{
chapterID = chapter.ID;
break;
}
}
if (chapterID == 0)
{
throw new ArgumentException(CHAPTER_ID_ERROR);
}
ICell titleCell = row.GetCell(2); if (titleCell == null) { throw new ArgumentException(TEXT_EMPTY_ERROR); }
// 答案
ICell amswerCell = row.GetCell(3); if (amswerCell == null) { throw new ArgumentException(TEXT_EMPTY_ERROR); }
string answerString = amswerCell.ToString().Trim().ToUpper();
if (!answerString.Equals(ANSWER_CORRECT) && !answerString.Equals(ANSWER_ERROR))
{
throw new ArgumentException(ANSWER_ARG_ERROR);
}
// 试题难易度
ICell difficltyCell = row.GetCell(5); if (difficltyCell == null) { throw new ArgumentException(TEXT_EMPTY_ERROR); }
string difficltyString = difficltyCell.ToString().Trim();
int difficulty = 0;
if (int.TryParse(difficltyString, out difficulty))
{
if (difficulty < DIFFICULTY_MIN || difficulty > DIFFICULTY_MAX)
{
throw new ArgumentException(DIFFICULTY_ARG_ERROR);
}
}
else
{
throw new ArgumentException(DIFFICULTY_ARG_ERROR);
}
JudgeItem judge = new JudgeItem();
judge.ChapterID = chapterID;
judge.Title = titleCell.ToString();
judge.Answer = answerString.Equals(ANSWER_CORRECT) ? 1 : 0;
judge.Annotation = row.GetCell(4) == null ? string.Empty : row.GetCell(4).ToString();
judge.Difficulty = difficulty;
judge.AddPerson = teacher.ChineseName;
judges.Add(judge);
}
}
}
}
else
{
throw new ArgumentException(CHAPTER_ID_ERROR);
}
return judges;
}
