/// <summary>
/// Processes Row information for answers that have two parameters to determine their value
/// </summary>
/// <param name="responseQuestion"></param>
/// <param name="aInfo"></param>
/// <returns></returns>
private string ProcessRow(QuestionInfo responseQuestion, AnswerInfo aInfo)
{
AnswerInfo qRow = new AnswerInfo();
QuestionSubtypeEnum qaSubtype = responseQuestion.QuestionType.Subtype;
// Demographic QuestionFamily types have extra spaces and newlines in front and back of their answer text
if (qaSubtype == QuestionSubtypeEnum.International)
{
qRow = responseQuestion.QuestionAnswerList.Where(e => e.AnswerID == aInfo.Row).FirstOrDefault <AnswerInfo>();
return(qRow.Text.Trim('\n').Trim());
}
else
{
qRow = responseQuestion.QuestionAnswerList.Where(e => e.AnswerID == aInfo.Row).FirstOrDefault <AnswerInfo>();
}
// for optional comments in Matrices
if (qRow != null)
{
return(qRow.Text);
}
else
{
return(responseQuestion.QuestionAnswerList[0].Text);
}
}
/// <summary>
/// Processes Answer information for answers that only have one parameter to determine their value
/// </summary>
/// <param name="responseQuestion"></param>
/// <param name="aInfo"></param>
/// <returns></returns>
private string ProcessAnswer(QuestionInfo responseQuestion, AnswerInfo aInfo)
{
AnswerInfo qi = new AnswerInfo();
QuestionSubtypeEnum qaSubtype = responseQuestion.QuestionType.Subtype;
if (qaSubtype == QuestionSubtypeEnum.Menu || qaSubtype == QuestionSubtypeEnum.Vertical || qaSubtype == QuestionSubtypeEnum.Horizontal)
{
qi = responseQuestion.QuestionAnswerList.Where(e => e.AnswerID == aInfo.Row).FirstOrDefault <AnswerInfo>();
}
if (qaSubtype == QuestionSubtypeEnum.Ranking || qaSubtype == QuestionSubtypeEnum.Rating)
{
qi = responseQuestion.QuestionAnswerList.Where(e => e.AnswerID == aInfo.Column).FirstOrDefault <AnswerInfo>();
}
// for optional comments in Matrices
if (qi != null)
{
return(qi.Text);
}
else
{
return(aInfo.Text);
}
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组
/// </summary>
/// <remarks></remarks>
protected IDbDataParameter[] ValueParas(QuestionInfo Model)
{
SqlParameter[] par =
{
new SqlParameter("@QuestionId", SqlDbType.Int),
new SqlParameter("@CateId", SqlDbType.Int),
new SqlParameter("@Style", SqlDbType.VarChar),
new SqlParameter("@Score", SqlDbType.Decimal),
new SqlParameter("@Question", SqlDbType.VarChar),
new SqlParameter("@A", SqlDbType.VarChar),
new SqlParameter("@B", SqlDbType.VarChar),
new SqlParameter("@C", SqlDbType.VarChar),
new SqlParameter("@D", SqlDbType.VarChar),
new SqlParameter("@Answer", SqlDbType.VarChar),
new SqlParameter("@Remarks", SqlDbType.VarChar),
new SqlParameter("@Checked", SqlDbType.Int),
new SqlParameter("@CompanyId", SqlDbType.Int)
};
par[0].Value = Model.QuestionId;
par[1].Value = Model.CateId;
par[2].Value = Model.Style;
par[3].Value = Model.Score;
par[4].Value = Model.Question;
par[5].Value = Model.A;
par[6].Value = Model.B;
par[7].Value = Model.C;
par[8].Value = Model.D;
par[9].Value = Model.Answer;
par[10].Value = Model.Remarks;
par[11].Value = Model.Checked;
par[12].Value = Model.CompanyId;
return(par);
}
public HttpResponseMessage Get(int id)
{
try
{
Question question = _questionRepository.GetById(id);
if (question != null)
{
QuestionInfo questionInfo = new QuestionInfo()
{
QuestionId = question.QuestionId,
QuestionTime = question.QuestionTime,
QuestionTitle = question.QuestionTitle,
CategoryId = question.Category.CategoryId,
CategoryName = question.Category.CategoryName,
UserName = question.ApplicationUser.UserName
};
return(Request.CreateResponse(HttpStatusCode.OK, questionInfo));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Bulunamadı"));
}
}catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
}
}
public List <QuestionInfo> GetAll()
{
using (var con = GetConnection())
{
var cmd = con.CreateCommand();
cmd.CommandText = "Get_Questions";
cmd.CommandType = CommandType.StoredProcedure;
using (var reader = cmd.ExecuteReader())
{
var questions = new List <QuestionInfo>();
while (reader.Read())
{
var questionInfo = new QuestionInfo
{
Id = (int)reader["id"],
Name = (string)reader["name"],
Question = (string)reader["question"]
};
questions.Add(questionInfo);
}
return(questions);
}
}
}
private async Task <GameInfo> HandleStateChangedResult(GameInfo gameInfo, GameResult gameResult,
bool isRoundFinish)
{
if (gameResult != null)
{
gameInfo.GameResult = gameResult;
return(gameInfo);
}
if (isRoundFinish)
{
QuestionInfo questionInfo = await gameQuestionService.GetNextQuestionInfo(gameInfo);
gameInfo.GameQuestionInfo.QuestionInfoList.Add(questionInfo);
foreach (GameUserInfo gameUserInfo in gameInfo.GameUserInfoByUserIdDictionary.Values)
{
var gameUserQuestionInfo = new GameUserQuestionInfo
{
GameUserQuestionState = GameUserQuestionState.NotStart,
};
if (gameUserInfo.GameUserState == GameUserState.Failed)
{
gameUserQuestionInfo.GameUserQuestionState = GameUserQuestionState.UnApply;
}
gameUserInfo.GameUserQuestionInfoList.Add(gameUserQuestionInfo);
}
}
return(gameInfo);
}
public async Task <Response <IQuestion> > ChangeQusetion(QuestionInfo questionInfo)
{
var response = new Response <IQuestion>();
try
{
var question = await _context.Questions
.Where(p => p.Id == questionInfo.QuestionId)
.FirstOrDefaultAsync();
if (question == null)
{
response.Error = new Error(404, "Question not found!");
return(response);
}
question.Name = questionInfo.Name;
question.Description = questionInfo.Description;
await _context.SaveChangesAsync();
response.Data = question;
return(response);
}
catch (Exception e)
{
response.Error = new Error(500, "Can`t create question: " + e);
}
return(response);
}
/// <summary>
/// Returns a set question
/// </summary>
/// <param name="questionID">The location of the question to get</param>
/// <returns>A question</returns>
private QuestionInfo GetQuestion(int questionID)
{
QuestionInfo question = questionsList[questionID];
questionsList.RemoveAt(questionID);
return(question);
}
public List <QuestionInfo> EstimatePersonLocation()
{
List <Question> unaskedQuestions = LoadQuestions();
double theta = GetInitialTheta();
List <QuestionInfo> questionHistory = new List <QuestionInfo>();
for (int i = 0; i < _catParameters.MaximumNumberOfQuestions && unaskedQuestions.Count != 0; i++)
{
QuestionInfo questionInfo = GetNextQuestion(theta, unaskedQuestions, i);
unaskedQuestions.Remove(questionInfo.Question);
AskQuestion(questionInfo.Question.QuestionLabel);
questionInfo.Score = ScoreItem(questionInfo.Question.QuestionLabel);
questionHistory.Add(questionInfo);
theta = GetNewLocationEstimate(questionHistory, theta);
questionHistory.Last().ThetaEstimate = theta;
double seOfEstimate = GetSEE(questionHistory, theta);
questionHistory.Last().SEE = seOfEstimate;
if (TerminationConditionsSatisfied(seOfEstimate, questionInfo.Information, i + 1))
{
return(questionHistory);
}
}
return(questionHistory);
}
public static bool SaveOrUpdateQuestionInfo(QuestionInfo qi)
{
bool result = false;
try
{
using (MainDataContext db = new MainDataContext())
{
QuestionInfo Info = db.QuestionInfos.FirstOrDefault(p => p.QuestionID == qi.QuestionID);
if (Info == null)
{
db.QuestionInfos.InsertOnSubmit(qi);
}
else
{
Info = qi;
}
db.SubmitChanges();
result = true;
}
}
catch (Exception ex)
{
}
return(result);
}
public ActionResult TestDetailed(Guid Question_Id)
{
EODB eodb = new EODB();
QuestionInfo questioninfo = eodb.questioninfo.Find(Question_Id);
return(Json(questioninfo));
}
private static Parameters GetParameters(QuestionInfo info)
{
Parameters parameters = new Parameters();
parameters.AddInParameter("@ID", DbType.Int32, info.Id);
parameters.AddInParameter("@ProductVersion", DbType.String, info.ProductVersion);
parameters.AddInParameter("@ProductDBType", DbType.String, info.ProductDBType);
parameters.AddInParameter("@SystemType", DbType.String, info.SystemType);
parameters.AddInParameter("@TypeId", DbType.Int32, info.TypeId);
parameters.AddInParameter("@TypeName", DbType.String, info.TypeName);
parameters.AddInParameter("@QuestionTitle", DbType.String, info.QuestionTitle);
parameters.AddInParameter("@QuestionContent", DbType.String, info.QuestionContent);
parameters.AddInParameter("@QuestionCreateTime", DbType.DateTime, info.QuestionCreateTime);
parameters.AddInParameter("@QuestionCreator", DbType.String, info.QuestionCreator);
parameters.AddInParameter("@AntiVirus", DbType.String, info.AntiVirus);
parameters.AddInParameter("@FireWall", DbType.String, info.FireWall);
parameters.AddInParameter("@ErrorCode", DbType.String, info.ErrorCode);
parameters.AddInParameter("@ErrorText", DbType.String, info.ErrorText);
parameters.AddInParameter("@IP", DbType.String, info.IP);
parameters.AddInParameter("@ReplyCreator", DbType.String, info.ReplyCreator);
parameters.AddInParameter("@ReplyTime", DbType.DateTime, info.ReplyTime);
parameters.AddInParameter("@Url", DbType.String, info.Url);
parameters.AddInParameter("@Score", DbType.Int32, info.Score);
parameters.AddInParameter("@IsSolved", DbType.Boolean, info.IsSolved);
parameters.AddInParameter("@IsPublic", DbType.Boolean, info.IsPublic);
parameters.AddInParameter("@IsReply", DbType.Boolean, info.IsReply);
parameters.AddInParameter("@LastUpdateTime", DbType.DateTime, info.LastUpdateTime);
return(parameters);
}
private void ButtonSave_Click(object sender, RoutedEventArgs e)
{
if (!CheckText())
{
return;
}
QuestionInfo question = Question;
if (!QuestionValidator.IsValid(question))
{
CtrlError.ShowError(QuestionValidator.Error);
return;
}
if (questionId != null)
{
manager.TestEditControl.EditQuestion(Question);
}
else
{
manager.TestEditControl.AddQuestion(Question);
}
manager.TestEditControl.Back();
}
public IActionResult QuestionEdit(int id, [FromForm] CreateQuestionInfo questionInfo)
{
if (ModelState.IsValid)
{
try
{
QuestionInfo editInfo = new QuestionInfo();
editInfo.Id = id;
editInfo.Name = questionInfo.Name;
editInfo.QuestionType = questionInfo.QuestionType;
editInfo.QuestionScore = questionInfo.QuestionScore;
List <SolutionInfo> solutions = new List <SolutionInfo>();
for (int i = 0; i < questionInfo.SolutionNames.Count(); i++)
{
SolutionInfo solution = new SolutionInfo();
solution.Name = questionInfo.SolutionNames.ElementAt(i);
solution.Score = questionInfo.SolutionScore.ElementAt(i);
solution.IsCorrect = solution.Score > 0;
solutions.Add(solution);
}
editInfo.Solutions = solutions;
_questionApp.Save(editInfo);
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)
{
ModelState.AddModelError("ExecuteError", ex.Message);
}
}
ViewBag.QuestionType = questionInfo.QuestionType;
return(View(questionInfo));
}
public ActionResult NewQuestion(QuestionInfo info)
{
var service = new QuestionServiceClient();
service.AddQuestion(info);
return(RedirectToAction("Greeting", "FirstExample"));
}
public QuestionInfo GetEncryptedInfo()
{
QuestionInfo info = GetInfo();
info.Answers = Answers.Select(a => a.GetEncryptedInfo()).ToList();
return(info);
}
public void ParseSubjects()
{
TextAsset[] subjects = Resources.LoadAll <TextAsset>("Subjects");
for (int i = 0; i < subjects.Length; i++)
{
JsonData data = JsonMapper.ToObject(subjects[i].text);
SubjectInfo sb = new SubjectInfo();
sb.id = (uint)data["id"];
sb.title = (string)data["title"];
sb.msg = (string)data["msg"];
sb.type = (string)data["type"];
sb.descript = (string)data["descript"];
for (int j = 0; j < data["body"].Count; j++)
{
JsonData qes = data["body"][j];
QuestionInfo qesInfo = new QuestionInfo();
qesInfo.question = (string)qes["question"];
for (int k = 0; k < qes["options"].Count; k++)
{
qesInfo.options.Add((string)qes["options"][k]);
}
for (int k = 0; k < qes["scores"].Count; k++)
{
qesInfo.scores.Add((int)qes["scores"][k]);
}
sb.questionInfos.Add(qesInfo);
}
JsonData r = data["result"];
for (int j = 0; j < r.Count; j++)
{
JsonData result = r[j];
SubjectResult sr = new SubjectResult();
sr.id = (int)result["id"];
sr.name = (string)result["name"];
for (int k = 0; k < result["level"].Count; k++)
{
SubjectLevelInfo levelInfo = new SubjectLevelInfo();
var level = result["level"][k];
levelInfo.condition = (int)level["condition"];
levelInfo.mark = (string)level["mark"];
levelInfo.comment = (string)level["comment"];
levelInfo.advice = (string)level["advice"];
sr.levelInfoLists.Add(levelInfo);
}
try {
sr.ids.Clear();
JsonData ids = result["idx"];
for (int k = 0; k < ids.Count; k++)
{
sr.ids.Add((uint)ids[k]);
}
} catch {
sr.ids = new List <uint>();
}
sb.questionResults.Add(sr);
}
subjectDict.Add(sb.id, sb);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(QuestionInfo model)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@question", SqlDbType.NVarChar, 150),
new SqlParameter("@release", SqlDbType.Bit, 1),
new SqlParameter("@sort", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.question;
parameters[2].Value = model.release;
parameters[3].Value = model.sort;
DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_question_ADD", parameters);
ClearCache();
return((int)parameters[0].Value);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(QuestionInfo model)
{
try
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@question", SqlDbType.NVarChar, 150),
new SqlParameter("@release", SqlDbType.Bit, 1),
new SqlParameter("@sort", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.question;
parameters[2].Value = model.release;
parameters[3].Value = model.sort;
rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_question_Update", parameters);
if (rowsAffected > 0)
{
ClearCache();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(false);
}
}
//添加填空题确认事件
protected void btFillConfirm_Click(object sender, EventArgs e)
{
QuestionsManagement questionsManagement = new QuestionsManagement();
QuestionInfo newQuestion = new QuestionInfo();
int QuestionTypeID = Convert.ToInt32(this.ddlQuestionType.SelectedItem.Value);
int SectionId = Convert.ToInt32(this.ddlSectionNO.SelectedItem.Value);
if (QuestionTypeID != 0 && SectionId != 0)
{
//设置添加的填空题题目信息
newQuestion.IQuestionTypeID = Convert.ToInt32(this.ddlQuestionType.SelectedItem.Value);
newQuestion.ISectionId = Convert.ToInt32(this.ddlSectionNO.SelectedItem.Value);
newQuestion.StrQuestionBody = this.txbFill.Text;
newQuestion.StrAnswer = this.txbFillAnswer.Text;
//将该题目添加到数据库
if (questionsManagement.AddQuestion(newQuestion))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('添加成功！')</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('添加失败！')</script>");
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('章节或题目类型为空！')</script>");
}
}
public IActionResult Edit(int id, [FromForm] EditExamPaperInfo paperInfo)
{
ModelState.Remove("QuestionIds");
if (paperInfo.Questions == null)
{
paperInfo.Questions = new List <QuestionInfo>();
}
paperInfo.Questions.Clear();
for (int i = 0; i < paperInfo.QuestionIds.Count; i++)
{
QuestionInfo question = _questionApp.Load(paperInfo.QuestionIds.ElementAt(i));
paperInfo.Questions.Add(question);
}
if (ModelState.IsValid)
{
try
{
if (paperInfo.Questions.Count <= 0)
{
throw new NotSupportedException("试卷不允许一道题目都没有哦");
}
_examPaperApp.Save(paperInfo);
return(RedirectToAction(nameof(Index)));
}
catch (Exception ex)
{
ModelState.AddModelError("ExcuteError", ex.Message);
_log.LogError(ex, ex.Message);
}
}
ModelState.AddModelError("ExcuteError", "保存失败！请刷新页面后再试！");
return(View(paperInfo));
}
public IActionResult QuestionEdit(int id)
{
QuestionInfo questionInfo = _questionApp.Load(id);
if (questionInfo == null)
{
return(NotFound());
}
CreateQuestionInfo editInfo = new CreateQuestionInfo();
editInfo.Name = questionInfo.Name;
editInfo.QuestionType = questionInfo.QuestionType;
editInfo.QuestionScore = questionInfo.QuestionScore;
List <string> solutionNames = new List <string>();
List <double> solutionScore = new List <double>();
foreach (SolutionInfo solution in questionInfo.Solutions)
{
solutionNames.Add(solution.Name);
solutionScore.Add(solution.Score);
}
editInfo.SolutionNames = solutionNames;
editInfo.SolutionScore = solutionScore;
ViewBag.QuestionType = editInfo.QuestionType;
return(View(editInfo));
}
public async Task <GameInfo> Create(IList <string> userIds)
{
if (userIds.Count <= 0)
{
throw new ArgumentOutOfRangeException(nameof(userIds));
}
var gameInfo = new GameInfo();
QuestionInfo questionInfo = await gameQuestionService.GetNextQuestionInfo(gameInfo);
gameInfo.GameQuestionInfo.QuestionInfoList.Add(questionInfo);
foreach (string userId in userIds)
{
var gameUserInfo = new GameUserInfo
{
UserId = userId,
GameUserState = GameUserState.Continue
};
var gameUserQuestionInfo = new GameUserQuestionInfo
{
GameUserQuestionState = GameUserQuestionState.NotStart,
};
gameUserInfo.GameUserQuestionInfoList.Add(gameUserQuestionInfo);
gameInfo.GameUserInfoByUserIdDictionary[userId] = gameUserInfo;
}
gameInfo.GameState = GameState.Continue;
GameInfo savedGameInfo = await gameInfoRepository.Save(gameInfo);
await SendEntityChangedMessage(new GameInfoChangedMessage(savedGameInfo, OperationType.Save));
return(savedGameInfo);
}
private QuestionInfo UpdateQuestion(QuestionInfo questionInfo)
{
//先加载出来数据库当前这个问题的数据
//保存原有的答案
//对比现在的答案得到已删除的答案
//更新问题数据
DbModel.QuestionInfo question = InternalLoad(questionInfo.Id);
question.QuestionName = questionInfo.Name;
question.QuestionScore = questionInfo.QuestionScore;
question.QuestionType = (DbModel.QuestionType)questionInfo.QuestionType;
question = _repository.Save(question);
//保存问题答案
if (questionInfo.Solutions != null && questionInfo.Solutions.Count() > 0)
{
IEnumerable <SolutionInfo> oldSolutions = QuerySolutions(questionInfo.Id);
List <SolutionInfo> deleteSolutions = new List <SolutionInfo>();
foreach (SolutionInfo item in oldSolutions)
{
SolutionInfo solution = questionInfo.Solutions.FirstOrDefault(p => p.Name.Equals(item.Name));
if (solution == null)
{
deleteSolutions.Add(item);
}
else
{
solution.Id = item.Id;
solution.RelationId = item.RelationId;
}
}
SaveRelation(questionInfo);
RemoveRelation(questionInfo, deleteSolutions);
}
return(questionInfo);
}
private static QuestionInfo GetInfoByReader(NullableDataReader rdr, bool getAll)
{
QuestionInfo info = new QuestionInfo();
info.Id = rdr.GetInt32("ID");
info.TypeId = rdr.GetInt32("TypeID");
info.TypeName = rdr.GetString("TypeName");
info.QuestionTitle = rdr.GetString("QuestionTitle");
info.QuestionCreateTime = rdr.GetDateTime("QuestionCreateTime");
info.QuestionCreator = rdr.GetString("QuestionCreator");
info.ReplyCreator = rdr.GetString("ReplyCreator");
info.ReplyTime = rdr.GetNullableDateTime("ReplyTime");
info.Score = rdr.GetInt32("Score");
info.IsPublic = rdr.GetBoolean("IsPublic");
info.IsReply = rdr.GetBoolean("IsReply");
info.IsSolved = rdr.GetBoolean("IsSolved");
if (getAll)
{
info.AntiVirus = rdr.GetString("AntiVirus");
info.ErrorCode = rdr.GetString("ErrorCode");
info.ErrorText = rdr.GetString("ErrorText");
info.FireWall = rdr.GetString("FireWall");
info.IP = rdr.GetString("IP");
info.ProductDBType = rdr.GetString("ProductDBType");
info.ProductVersion = rdr.GetString("ProductVersion");
info.QuestionContent = rdr.GetString("QuestionContent");
info.SystemType = rdr.GetString("SystemType");
info.Url = rdr.GetString("Url");
info.LastUpdateTime = rdr.GetDateTime("LastUpdateTime");
}
return(info);
}
public void StartQuiz()
{
uiManager.ShowQuiz();
questionsAsked = 0;
currentQuestion = NextQuestion();
uiManager.UpdateQuiz(currentQuestion);
}
protected void CreateTestQuestionDialog_OkButtonClicked(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (this.TestId > 0)
{
QuestionInfo entity = new QuestionInfo();
entity.TestId = this.TestId;
entity.Question = QuestionDescriptionTextBox.Value;
bool result = TestController.InsertQuestion(ref entity);
if (result)
{
CreateTestQuestionDialog.Reset();
DataBind();
OnTestQuestionCreated(EventArgs.Empty);
entity = null;
}
}
}
else
{
ValidationHelper.SetFocusToFirstError(this.Page, "create_testquestion");
}
}
public QuestionInfo NextQuestion()
{
QuestionInfo question = GetRandomQuestion();
uiManager.UpdateQuiz(question);
return(question);
}
public static bool DeleteQuestionInfo(QuestionInfo qi)
{
bool result = false;
try
{
if (qi != null)
{
using (MainDataContext db = new MainDataContext())
{
QuestionInfo Info = db.QuestionInfos.FirstOrDefault(p => p.QuestionID == qi.QuestionID);
if (Info != null)
{
db.QuestionInfos.DeleteOnSubmit(Info);
}
db.SubmitChanges();
result = true;
}
}
}
catch (Exception ex)
{
}
return(result);
}
public void QuestionSetup(bool isCorrect)
{
if (isCorrect)
{
gameManager.score += quizPoints;
if (playerManager.timesRevived < playerManager.maxRevives)
{
uiManager.EndQuiz();
playerManager.Revive();
}
}
else
{
playerManager.timesRevived = playerManager.maxRevives;
}
++questionsAsked;
if (questionsAsked < maxQuestions)
{
currentQuestion = NextQuestion();
}
else
{
gameManager.EndGame();
}
}
public ActionResult Explain(Guid Question_Id)
{
EODB eodb = new EODB();
QuestionInfo qi = eodb.questioninfo.Find(Question_Id);
if (qi.Question_Title.Length > 20)
{
ViewBag.Title = qi.Question_Title.Substring(0, 20).Replace("<p>", string.Empty).Replace("</p>", string.Empty);
}
else
{
ViewBag.Title = qi.Question_Title.Replace("<p>", string.Empty).Replace("</p>", string.Empty);
}
ViewBag.QuestionInfo = qi;
qi.Question_Click++;
eodb.SaveChanges();
PaperInfo Related = eodb.paperinfo.Where(i => i.Paper_Grade == qi.Question_Grade && i.Paper_Subject == qi.Question_Subject).FirstOrDefault();
if (Related == null)
{
ViewBag.Related = new PaperInfo
{
Paper_Id = Guid.NewGuid(),
Paper_Name = "无",
Paper_Path = "#"
};
}
else
{
ViewBag.Related = Related;
}
return(View());
}
public static void GenerateQuestionarieUI(QuestionInfo questionInfo)
{
if (GetIstance(out var gameUtilities))
{
gameUtilities.GenerateQuestionarieUIInternal(questionInfo);
}
}
private void QuestionTag_Load(object sender, EventArgs e)
{
List<string> questiones = GetQuestionStyle("Corpus_Question_Style.txt");
for (int i = 0; i < questiones.Count; i++)
{
QuestionInfo questionInfo = new QuestionInfo();
questionInfo.Location = new Point(10, 70 * i);
questionInfo.SetQuestion((i + 1), questiones[i]);
this.Controls.Add(questionInfo);
}
}
public bool GetQuestionInfo (string question, out QuestionInfo questionInfo)
{
foreach (QuestionInfo q in questions)
{
if (q.active && q.ouijaString == question)
{
questionInfo = q;
return true;
}
}
questionInfo = new QuestionInfo(); // FIXME: UGH. Maybe you are using 'out' incorrectly?
return false;
}
//添加是非题确认事件
protected void btJudgeConfirm_Click(object sender, EventArgs e)
{
QuestionsManagement questionsManagement = new QuestionsManagement();
QuestionInfo newQuestion = new QuestionInfo();
string answer = null;
//获得是非题答案
if (RadioButton1.Checked)
{
answer = "是";
}
if(RadioButton2.Checked)
{
answer = "非";
}
int QuestionTypeID = Convert.ToInt32(this.ddlQuestionType.SelectedItem.Value);
int SectionId = Convert.ToInt32(this.ddlSectionNO.SelectedItem.Value);
if (QuestionTypeID != 0 && SectionId != 0 && answer != null)
{
//设置添加的是非题题目信息
newQuestion.IQuestionTypeID = QuestionTypeID;
newQuestion.ISectionId = SectionId;
newQuestion.StrQuestionBody = this.txbJudge.Text;
newQuestion.StrAnswer = answer;
//将该题目添加到数据库
if (questionsManagement.AddQuestion(newQuestion))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('添加成功！')</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('添加失败！')</script>");
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('章节,题目类型或题目答案为空！')</script>");
}
}
public UserControlNewQuestion(string Connection, int current, int all, QuestionInfo question, IEnumerable<AnswerInfo> answers)
{
InitializeComponent();
listView.ItemsSource = ans;
Connect = Connection;
if (question == null) return;
ID = question.ID;
textBoxLevel.Text = question.Level;
textBoxTopic.Text = question.Topic;
textBoxInfo.Text = question.Info;
textBoxQuestion.Text = question.Question;
labelID.Content = "№ " + question.ID;
labelCurrent.Content = string.Format(@"{0}/{1}", (current + 1), all);
foreach (var item in answers)
ans.Add(item);
}
//编辑是非题确认事件
protected void btEJudgeConfirm_Click(object sender, EventArgs e)
{
QuestionsManagement questionsManagement = new QuestionsManagement();
QuestionInfo newQuestion = new QuestionInfo();
string answer = null;
//获得是非题答案
if (RadioButton1.Checked)
{
answer = "是";
}
if(RadioButton2.Checked)
{
answer = "非";
}
if (answer != null)
{
//设置编辑后的是非题信息
newQuestion.IQuestionId = Convert.ToInt32(Session["Questionid"].ToString());
newQuestion.ISectionId = Convert.ToInt32(Session["Sectionid"].ToString());
newQuestion.StrQuestionBody = this.txbJudge.Text;
newQuestion.StrAnswer = answer;
//保存结果到数据库
if (questionsManagement.EditQuestion(newQuestion))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('修改成功！')</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('修改失败！')</script>");
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('题目答案为空，请选择答案！')</script>");
}
}
public UserControlQuestion(QuestionInfo question, IEnumerable<AnswerInfo> answers, bool isCheck=false)
{
InitializeComponent();
id_question = question.ID;
labelTopic.Text = question.Topic;
labelQuestion.Text = question.Question;
labeInfo.Text = question.Info;
IsCheck = isCheck;
foreach (AnswerInfo answer in answers)
{
if (!IsCheck)
{
CheckBox ch = new CheckBox();
ch.Margin = new Thickness(10);
ch.Content = answer.Text;
ch.FontSize = 16;
ch.FontFamily = new FontFamily("Times New Roman");
StackAnswer.Children.Add(ch);
Answers.Add(answer.ID, answer.Text);///????????????????????????
}
else
{
Label ch = new Label();
ch.Margin = new Thickness(10);
ch.Content = answer.Text;
ch.FontSize = 16;
ch.FontFamily = new FontFamily("Times New Roman");
if (answer.IsTrue)
ch.Background = Brushes.GreenYellow;
else
ch.Background = Brushes.Red;
StackAnswer.Children.Add(ch);
}
}
}
//编辑填空题确认事件
protected void btEFillConfirm_Click(object sender, EventArgs e)
{
QuestionsManagement questionsManagement = new QuestionsManagement();
QuestionInfo newQuestion = new QuestionInfo();
//设置修改后的填空题信息
newQuestion.IQuestionId = Convert.ToInt32(Session["Questionid"].ToString());
newQuestion.ISectionId = Convert.ToInt32(Session["Sectionid"].ToString());
newQuestion.StrQuestionBody = this.txbFill.Text;
newQuestion.StrAnswer = this.txbFillAnswer.Text;
//保存结果到数据库
if (questionsManagement.EditQuestion(newQuestion))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('修改成功！')</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('修改失败！')</script>");
}
}
/// <summary>
/// RepeaterJudge_Item数据绑定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RepeaterJudge_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
UserControl_QuesJudge quesJudge = (UserControl_QuesJudge)e.Item.FindControl("QuesJudge1");
QuestionInfo ques = new QuestionInfo();
ques.IQuestionId = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ID"));
ques.IQuestionTypeID = 2;
ques.ISectionId = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "sectionID"));
ques.StrAnswer = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "answer"));
ques.StrQuestionBody = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "quesBody"));
quesJudge.QuesJudge = ques;
quesJudge.IndexJudge = index2++;
}
/// <summary>
/// 删除问卷
/// </summary>
/// <param name="q"></param>
/// <returns></returns>
public static JsMessage Del_WJ(QuestionInfo q)
{
JsMessage js = new JsMessage();
string SqlStr = "DELETE FROM [dbo].[WJ] WHERE [wj_ID]=" + q.wj_ID + " ; DELETE FROM [dbo].[WT] WHERE [wt_WJID]=" + q.wj_ID + "; DELETE FROM [dbo].[AnswerUserInfo] WHERE [au_wjID]=" + q.wj_ID;
//SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@wt_ID", ID) };
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, null);
js.IsSuccess = true;
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改问卷
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Modify_Question(QuestionInfo Q)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WJ]
SET [wj_ProjectSource]= @wj_ProjectSource,
[wj_Number] = @wj_Number,
[wj_Sponsor] = @wj_Sponsor,
[wj_Time] = @wj_Time,
[wj_Title] = @wj_Title,
[wj_BeginPic] = @wj_BeginPic,
[wj_BeginBody] = @wj_BeginBody,
[wj_EndBody] = @wj_EndBody,
[wj_PageSize] = @wj_PageSize,
[wj_PublishTime] = @wj_PublishTime,
[wj_Status] = @wj_Status,
[wj_ValidStart] = @wj_ValidStart,
[wj_ValidEnd] = @wj_ValidEnd
WHERE [wj_ID]=@wj_ID ";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_ProjectSource",SqlDbType.NVarChar,100){Value=Q.wj_ProjectSource},
new SqlParameter("@wj_Number",Q.wj_Number),
new SqlParameter("@wj_Sponsor",Q.wj_Sponsor),
new SqlParameter("@wj_Time",Q.wj_Time),
new SqlParameter("@wj_Title",Q.wj_Title),
new SqlParameter("@wj_BeginPic",SqlDbType.VarChar,100){Value=Q.wj_BeginPic},
new SqlParameter("@wj_BeginBody",SqlDbType.NVarChar,8000){Value=Q.wj_BeginBody},
new SqlParameter("@wj_EndBody",SqlDbType.NVarChar,2000){Value=Q.wj_EndBody},
new SqlParameter("@wj_PageSize",Q.wj_PageSize),
new SqlParameter("@wj_PublishTime",Q.wj_PublishTime),
new SqlParameter("@wj_Status",Q.wj_Status),
new SqlParameter("@wj_ValidStart",Q.wj_ValidStart),
new SqlParameter("@wj_ValidEnd",Q.wj_ValidEnd),
new SqlParameter("@wj_ID",Q.wj_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// 修改问卷
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Modify_Question_BaseInfo(QuestionInfo Q)
{
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WJ]
SET [wj_BaseInfo] = @wj_BaseInfo ,[wj_PageSize]=@wj_PageSize WHERE [wj_ID]=@wj_ID "; //pagesize 字段没有使用暂时作为姓名字段来使用 存储是否必须值
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_BaseInfo",SqlDbType.NVarChar,8000){Value=Q.wj_BaseInfo},
new SqlParameter("@wj_PageSize",Q.wj_PageSize),
new SqlParameter("@wj_ID",Q.wj_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
public static JsMessage PublishWJ(QuestionInfo Q)
{
Q.wj_PublishTime = Q.wj_Status == "y" ? DateTime.Now.ToString() : "";
JsMessage js = new JsMessage();
string SqlStr = @" UPDATE [dbo].[WJ] SET [wj_Status] = @wj_Status ,[wj_PublishTime]=@wj_PublishTime WHERE [wj_ID]=@wj_ID";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_Status",Q.wj_Status),
new SqlParameter("@wj_PublishTime",Q.wj_PublishTime),
new SqlParameter("@wj_ID",Q.wj_ID)
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = false;
js.ErrorMsg = ex.ToString();
}
return js;
}
//编辑选择题确认事件
protected void btEMultipleConfirm_Click(object sender, EventArgs e)
{
QuestionsManagement questionsManagement = new QuestionsManagement();
QuestionInfo newQuestion = new QuestionInfo();
string answer = null;
//获得选择题答案
if (CheckBoxA.Checked)
{
answer += "A";
}
if (CheckBoxB.Checked)
{
answer += "B";
}
if (CheckBoxC.Checked)
{
answer += "C";
}
if (CheckBoxD.Checked)
{
answer += "D";
}
if (answer != null)
{
//设置编辑后的选择题信息
newQuestion.IQuestionId = Convert.ToInt32(Session["Questionid"].ToString());
newQuestion.ISectionId = Convert.ToInt32(Session["Sectionid"].ToString());
newQuestion.StrQuestionBody = this.txbMultiple.Text;
newQuestion.StrAnswer = answer;
//保存结果到数据库
if (questionsManagement.EditQuestion(newQuestion))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('修改成功！')</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('修改失败！')</script>");
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert",
"<script>alert('答案为空，请选择答案！')</script>");
}
}
/// <summary>
/// RepeaterFilling_Item数据绑定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RepeaterFilling_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
UserControl_QuesFilling quesFilling = (UserControl_QuesFilling)e.Item.FindControl("QuesFilling1");
QuestionInfo ques = new QuestionInfo();
ques.IQuestionId = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ID"));
ques.IQuestionTypeID = 3;
ques.ISectionId = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "sectionID"));
ques.StrAnswer = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "answer"));
ques.StrQuestionBody = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "quesBody"));
quesFilling.QuesFilling = ques;
quesFilling.IndexFilling = index3++;
}
/// <summary>
/// 添加问卷
/// </summary>
/// <param name="Q"></param>
/// <returns></returns>
public static JsMessage Add_Question(QuestionInfo Q)
{
JsMessage js = new JsMessage();
string SqlStr = @" INSERT INTO [dbo].[WJ] (
[wj_ProjectSource]
,[wj_Number]
,[wj_Sponsor]
,[wj_Time]
,[wj_Title]
,[wj_BeginPic]
,[wj_BeginBody]
,[wj_EndBody]
,[wj_PageSize]
,[wj_PublishTime]
,[wj_Status]
,[wj_ValidStart]
,[wj_ValidEnd])
VALUES
( @wj_ProjectSource
,@wj_Number
,@wj_Sponsor
,@wj_Time
,@wj_Title
,@wj_BeginPic
,@wj_BeginBody
,@wj_EndBody
,@wj_PageSize
,@wj_PublishTime
,@wj_Status
,@wj_ValidStart
,@wj_ValidEnd );SELECT @wj_ID=SCOPE_IDENTITY();";
SqlParameter[] commandParameters = new SqlParameter[]{
new SqlParameter("@wj_ProjectSource",SqlDbType.NVarChar,100){Value=Q.wj_ProjectSource},
new SqlParameter("@wj_Number",Q.wj_Number),
new SqlParameter("@wj_Sponsor",Q.wj_Sponsor),
new SqlParameter("@wj_Time",Q.wj_Time),
new SqlParameter("@wj_Title",Q.wj_Title),
new SqlParameter("@wj_BeginPic",SqlDbType.VarChar,100){Value=Q.wj_BeginPic},
new SqlParameter("@wj_BeginBody",SqlDbType.NVarChar,8000){Value=Q.wj_BeginBody},
new SqlParameter("@wj_EndBody",SqlDbType.NVarChar,2000){Value=Q.wj_EndBody},
new SqlParameter("@wj_PageSize",Q.wj_PageSize),
new SqlParameter("@wj_PublishTime",Q.wj_PublishTime),
new SqlParameter("@wj_Status",Q.wj_Status),
new SqlParameter("@wj_ValidStart",Q.wj_ValidStart),
new SqlParameter("@wj_ValidEnd",Q.wj_ValidEnd),
new SqlParameter("@wj_ID",SqlDbType.Int){Direction = ParameterDirection.Output}
};
try
{
int flg = SqlHelper.ExecteNonQueryText(SqlStr, commandParameters);
if (flg == 1)
{
js.IsSuccess = true;
js.ReturnADD_ID = int.Parse(commandParameters[13].Value.ToString());
}
else
{
js.IsSuccess = false;
}
}
catch (SqlException ex)
{
js.IsSuccess = true;
js.ErrorMsg = ex.ToString();
}
return js;
}
/// <summary>
/// RepeaterQuery_Item数据绑定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RepeaterQuery_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
UserControl_QuesQuery quesQuery = (UserControl_QuesQuery)e.Item.FindControl("QuesQuery1");
QuestionInfo ques = new QuestionInfo();
ques.IQuestionId = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ID"));
ques.IQuestionTypeID = 4;
ques.ISectionId = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "sectionID"));
ques.StrAnswer = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "answer"));
ques.StrQuestionBody = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "quesBody"));
quesQuery.QuesQuery = ques;
quesQuery.IndexQuery = index4++;
}
public ActionResult QuesTwoStep(int ID)
{
DataTable dt = SqlStr_Process.GetWJByID_Answer(ID);
QuestionInfo Quest = new QuestionInfo();
if (dt != null)
{
Session["V_Code"] = dt.Rows[0]["wj_Number"].ToString();
Session.Timeout = 120;
Quest.wj_ID = int.Parse(dt.Rows[0]["wj_ID"].ToString());
Quest.wj_Title = dt.Rows[0]["wj_Title"].ToString();
Quest.wj_BeginBody = dt.Rows[0]["wj_BeginBody"].ToString().Replace(" ", " ").Replace("\n", "<br/>");
}
else
{
return Content("问卷不存在！");
}
return View(Quest);
}