/// <summary>
/// 修改题目
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static int UpdateQustion(QusetionView entity)
{
DataCommand cmd = new DataCommand("MockTest.UpdateQustion");
cmd.SetParameter(entity);
int result = cmd.ExecuteNonQuery();
return(result);
}
/// <summary>
/// 新增题目
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static int InsertQustion(QusetionView entity)
{
DataCommand cmd = new DataCommand("MockTest.InsertQustion");
cmd.SetParameter(entity);
int result = cmd.ExecuteScalar <int>();
return(result);
}
public void ImportQusetion(DataTable data, List <DocumentValid> documentList, List <DocumentValid> userTagList, string userid)
{
List <QusetionView> list = new List <QusetionView>();
foreach (System.Data.DataRow item in data.Rows)
{
var row = item.ItemArray;
//查询关联文档 判断关联文档与序号是否存在
QusetionView qusetion = new QusetionView
{
//关联文档标题
document_name = row[1] + "",
//题目序号
order_num = int.Parse(row[2] + ""),
//题目文本内容
content = row[3] + ""
};
//文档id
qusetion.document_id = documentList.Where(_ => _.name.Equals(qusetion.document_name)).FirstOrDefault().id;
var usertagname = row[0] + "";
var userTagid = userTagList.Where(_ => _.name.Equals(usertagname)).FirstOrDefault().user_tag;
qusetion.user_tag = userTagid;
//题型
switch (int.Parse(row[4] + ""))
{
case 1:
qusetion.mode = Question_Mode.Single;
break;
case 2:
qusetion.mode = Question_Mode.Multiple;
break;
case 3:
qusetion.mode = Question_Mode.Judge;
break;
default:
break;
}
qusetion.answer_analysis = string.IsNullOrEmpty(row[5] + "") ? "" :row[5] + "";
//IP限制
qusetion.is_ip_restrict = string.IsNullOrEmpty(row[6] + "") ? 0 : int.Parse(row[6] + "");
//用户限制
qusetion.is_user_restrict = string.IsNullOrEmpty(row[7] + "") ? 0 : int.Parse(row[7] + "");
//正确答案
string is_rightStr = row[8] + "";
List <AnswerView> answerList = new List <AnswerView>();
AddAnswer(row, answerList, is_rightStr);
qusetion.AnswerList = answerList;
list.Add(qusetion);
}
InsertQusetion(list, userid);
}
/// <summary>
/// 修改题目
/// </summary>
/// <param name="entity"></param>
public string UpdateQustion(QusetionView entity)
{
if (entity.id > 0)
{
entity.update_time = DateTime.Now;
List <DocumentValid> document = new List <DocumentValid>();
var msg = DocumentValidMsg(entity.document_name, entity.order_num + "", document);
if (!string.IsNullOrEmpty(msg) && (document.Count == 0 || document.FirstOrDefault().QuestionId != entity.qusetionId))
{
return(msg);
}
entity.document_id = document.FirstOrDefault().id;
MockTestDA.UpdateQustion(entity);
foreach (var item in entity.AnswerList)
{
MockTestDA.UpdateAnswer(item);
}
}
return(string.Empty);
}
public ActionResult SaveQusetion(QusetionView data)
{
data.update_user = CurrUser.UserID;
data.id = data.qusetionId;
var result = MockTestBasisService.UpdateQustion(data);
if (string.IsNullOrEmpty(result))
{
return(Json(new AjaxResult()
{
Data = data, Success = true, Message = "保存成功!"
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new AjaxResult()
{
Data = data, Success = false, Message = result
}, JsonRequestBehavior.AllowGet));
}
}
