/// <summary>
/// 添加单选题
/// </summary>
/// <param name="title"></param>
/// <param name="trueSel"></param>
/// <param name="sel1"></param>
/// <param name="sel2"></param>
/// <param name="sel3"></param>
/// <param name="score"></param>
/// <param name="tagsId"></param>
/// <returns></returns>
public string AddSingle(string title, string trueSel, string sel1, string sel2, string sel3, int score, int[] tagsId)
{
int code;
string message;
ES_SelectQuestion single = new ES_SelectQuestion()
{
SQTitle = title,
SQTrueAns = trueSel,
SQAns1 = sel1,
SQAns2 = sel2,
SQAns3 = sel3,
SQScore = score
};
try
{
db.ES_SelectQuestion.Add(single);
if (db.SaveChanges() > 0)
{
var thisSingle = db.ES_SelectQuestion.OrderByDescending(sq => sq.SQId).FirstOrDefault();
if (thisSingle != null)
{
int esId = AddExercise("单选题", thisSingle.SQId);
if (tagsId == null || tagsId.Length == 0)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
if (esId != -1)
{
// 添加标签
foreach (int tagId in tagsId)
{
ES_Tag_Exercise te = new ES_Tag_Exercise()
{
TagId = tagId,
EsId = esId
};
db.ES_Tag_Exercise.Add(te);
}
if (db.SaveChanges() >= tagsId.Length)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
}
}
}
}
catch (Exception ex)
{
code = 1;
message = "服务器错误！" + ex.Message;
return(JsonConvert.SerializeObject(new { code, message }));
}
code = 1;
message = "服务器错误！题目添加失败";
return(JsonConvert.SerializeObject(new { code, message }));
}
/// <summary>
/// 添加判断题
/// </summary>
/// <param name="title"></param>
/// <param name="trueSel"></param>
/// <param name="falseSel"></param>
/// <param name="score"></param>
/// <param name="tagsId"></param>
/// <returns></returns>
public string AddJudgment(string title, string trueSel, string falseSel, int score, int[] tagsId)
{
int code;
string message;
ES_JudgeQuestion judge = new ES_JudgeQuestion()
{
JQTitle = title,
JQTrueAns = trueSel,
JQFalseAns = falseSel,
JQScore = score
};
try
{
db.ES_JudgeQuestion.Add(judge);
if (db.SaveChanges() > 0)
{
// 添加答案，将题目关联到总表
var question = db.ES_JudgeQuestion.OrderByDescending(jq => jq.JQId).FirstOrDefault();
int esId = AddExercise("判断题", question.JQId); // 获取对应在总表中的id
if (esId != -1)
{
if (tagsId == null || tagsId.Length == 0)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
// 添加标签
foreach (int tagId in tagsId)
{
ES_Tag_Exercise te = new ES_Tag_Exercise()
{
TagId = tagId,
EsId = esId
};
db.ES_Tag_Exercise.Add(te);
}
if (db.SaveChanges() >= tagsId.Length)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
}
}
}
catch (Exception ex)
{
code = 1;
message = "服务器错误！" + ex.Message;
return(JsonConvert.SerializeObject(new { code, message }));
}
code = 1;
message = "服务器错误！题目添加失败";
return(JsonConvert.SerializeObject(new { code, message }));
}
/// <summary>
/// 添加判断题
/// </summary>
/// <param name="title"></param>
/// <param name="score"></param>
/// <param name="answers"></param>
/// <param name="tagsId"></param>
/// <returns></returns>
public string AddFill(string title, int score, string[] answers, int[] tagsId)
{
int code;
string message;
ES_FillQuestion fill = new ES_FillQuestion()
{
FQTitle = title,
FQScore = score
};
try
{
db.ES_FillQuestion.Add(fill);
if (db.SaveChanges() > 0)
{
var question = db.ES_FillQuestion.OrderByDescending(fq => fq.FQId).FirstOrDefault();
foreach (string ans in answers)
{
ES_FillAnswer answer = new ES_FillAnswer()
{
FQId = question.FQId,
FAContent = ans
};
db.ES_FillAnswer.Add(answer);
}
int addRes = db.SaveChanges();
int esId = AddExercise("填空题", question.FQId); // 获取对应在总表中的id
if (addRes >= answers.Length && esId != -1)
{
if (tagsId == null || tagsId.Length == 0)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
// 添加标签
foreach (int tagId in tagsId)
{
ES_Tag_Exercise te = new ES_Tag_Exercise()
{
TagId = tagId,
EsId = esId
};
db.ES_Tag_Exercise.Add(te);
}
if (db.SaveChanges() >= tagsId.Length)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
}
}
}
catch (Exception ex)
{
code = 1;
message = "服务器错误！" + ex.Message;
return(JsonConvert.SerializeObject(new { code, message }));
}
code = 1;
message = "服务器错误！题目添加失败";
return(JsonConvert.SerializeObject(new { code, message }));
}
/// <summary>
/// 添加多选题
/// </summary>
/// <param name="title"></param>
/// <param name="answers"></param>
/// <param name="trueSels"></param>
/// <param name="score"></param>
/// <param name="tagsId"></param>
/// <returns></returns>
public string AddMultiple(string title, string[] answers, string[] trueSels, int score, int[] tagsId)
{
int code;
string message;
ES_MultipleQuestion multiple = new ES_MultipleQuestion()
{
MQTitle = title,
MQAns1 = answers[0],
MQAns2 = answers[1],
MQAns3 = answers[2],
MQAns4 = answers[3],
MQAns5 = answers[4] == "" ? null : answers[4],
MQAns6 = answers[5] == "" ? null : answers[5],
MQAns7 = answers[6] == "" ? null : answers[6],
MQScore = score
};
try
{
db.ES_MultipleQuestion.Add(multiple);
if (db.SaveChanges() > 0)
{
// 添加答案，将题目关联到总表
var question = db.ES_MultipleQuestion.OrderByDescending(mq => mq.MQId).FirstOrDefault();
foreach (string sel in trueSels)
{
ES_MultipleAnswer answer = new ES_MultipleAnswer()
{
MQId = question.MQId,
MAContent = sel
};
db.ES_MultipleAnswer.Add(answer);
}
int addRes = db.SaveChanges();
int esId = AddExercise("多选题", question.MQId); // 获取对应在总表中的id
if (addRes >= trueSels.Length && esId != -1)
{
if (tagsId == null || tagsId.Length == 0)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
// 添加标签
foreach (int tagId in tagsId)
{
ES_Tag_Exercise te = new ES_Tag_Exercise()
{
TagId = tagId,
EsId = esId
};
db.ES_Tag_Exercise.Add(te);
}
if (db.SaveChanges() >= tagsId.Length)
{
code = 0;
message = "添加成功";
return(JsonConvert.SerializeObject(new { code, message }));
}
}
}
}
catch (Exception ex)
{
code = 1;
message = "服务器错误！" + ex.Message;
return(JsonConvert.SerializeObject(new { code, message }));
}
code = 1;
message = "服务器错误！题目添加失败";
return(JsonConvert.SerializeObject(new { code, message }));
}
