/// <summary>
/// 添加试题信息
/// </summary>
/// <param name="b"></param>
/// <returns></returns>
public int Add()
{
BackQuestionBank b = new BackQuestionBank();
b.Question = Request["Question"];
b.QuestionType = Convert.ToInt32(Request["QuestionType"]);
b.UnitId = Convert.ToInt32(Request["UnitId"]);
b.A = Request["A"];
b.B = Request["B"];
b.C = Request["C"];
b.D = Request["D"];
b.ChoiceAnswer = Request["ChoiceAnswer"];
b.JudgeAnswer = Request["JudgeAnswer"];
var result = question.Add(b);
Users us = (Users)Session["User"];
if (result > 0)
{
logs.Add(us.ID, "添加试题", 1);
}
else
{
logs.Add(us.ID, "添加试题", 0);
}
return(result);
}
/// <summary>
/// 添加试题信息
/// </summary>
/// <param name="b"></param>
/// <returns></returns>
public int Add(BackQuestionBank b)
{
using (IDbConnection conn = new MySqlConnection(mysqlConnectionStr))
{
string sql = string.Format("insert into backquestionbank(Question,QuestionType,UnitId,A,B,C,D,ChoiceAnswer,JudgeAnswer) values('{0}',{1},{2},'{3}','{4}','{5}','{6}','{7}','{8}')", b.Question, b.QuestionType, b.UnitId, b.A, b.B, b.C, b.D, b.ChoiceAnswer, b.JudgeAnswer);
return(conn.Execute(sql));
}
}
/// <summary>
/// 修改试题
/// </summary>
/// <param name="q"></param>
/// <returns></returns>
public int Update(BackQuestionBank q)
{
using (IDbConnection conn = new MySqlConnection(mysqlConnectionStr))
{
string sql = string.Format("update BackQuestionBank set Question='{0}',QuestionType={1},A='{2}',B='{3}',C='{4}',D='{5}',ChoiceAnswer='{6}',JudgeAnswer='{7}' where Id={8}", q.Question, q.QuestionType, q.A, q.B, q.C, q.D, q.ChoiceAnswer, q.JudgeAnswer, q.Id);
return(conn.Execute(sql));
}
}
/// <summary>
/// 修改试题
/// </summary>
/// <param name="ques"></param>
/// <returns></returns>
public int Update(BackQuestionBank ques)
{
var result = question.Update(ques);
Users us = (Users)Session["User"];
if (result > 0)
{
logs.Add(us.ID, "修改试题", 1);
}
else
{
logs.Add(us.ID, "修改试题", 0);
}
return(result);
}
