private void addTabcontrol7(Trail trail) { Learning learning = new Learning(); Judgment judgment = new Judgment(); Match match = new Match(); Choice choice = new Choice(); Puzzle puzzle = new Puzzle(); if (!this.tabcontrol7learnQuestionType.Text.Equals("不存在")) { learning.ExciseName = this.tabcontrol7LearnExciseName.Text; learning.QuestionType = this.tabcontrol7learnQuestionType.Text; learning.Question = new ImageItem(); learning.Question.Image = this.tabcontrol7LearnImage.Text; learning.Speech = this.tabcontrol0learnSound.Text; learning.Question.SpeechText = this.tabcontr0LearnKeyText.Text; learning.Question.Text = this.tabcontr0LearnKeyText.Text; learning.PinYing = this.tabcontrol7LearnPy.Text; trail.Questions.Add(learning); // MessageBox.Show(strSerializeJSON); } else if (!this.tabcontrol7JudgeQuestionType.Text.Equals("不存在")) { judgment.ExciseName = this.tabcontrol7JudgeExciseName.Text; judgment.Speech = this.tabcontrol7JudgeSound.Text; judgment.QuestionType = this.tabcontrol7JudgeQuestionType.Text; judgment.Question = new ImageItem(); judgment.Question.Image = this.tabcontrol7JudgeRightImage.Text; judgment.Distractor = new ImageItem(); judgment.Distractor.Image = this.tabcontrol7JudgeWrongImage.Text; trail.Questions.Add(judgment); // MessageBox.Show(judgeSerializeJSON); } else if (!this.tabcontrol7MatchQuestionType.Text.Equals("不存在")) { match.ExciseName = this.tabcontrol7MatchExciseName.Text; match.QuestionType = this.tabcontrol7MatchQuestionType.Text; match.Speech = this.tabcontrol7MatchSound.Text; match.Question = new ImageItem(); match.Question.Image = this.tabcontrol7MatchQuestionImage.Text; match.Answer = new ImageItem(); match.Answer.Image = this.tabcontrol7MatchAnswerImage.Text; match.Distractor = new ImageItem(); match.Distractor.Image = this.tabcontrol7MatchDistraImage.Text; trail.Questions.Add(match); // MessageBox.Show(matchSerializeJSON); } else if (!this.tabcontrol7ChoiceQuestionType.Text.Equals("不存在")) { choice.ExciseName = this.tabcontrol7ChoiceExciseName.Text; choice.QuestionType = this.tabcontrol7ChoiceQuestionType.Text; choice.Speech = this.tabcontrol7ChoiceSound.Text; choice.Answer = new ImageItem(); choice.Answer.Image = this.tabcontrol7ChoiceRightImage.Text; choice.Answer.SpeechText = this.tabcontrol7ChoiceRightText.Text; choice.Distractor = new ImageItem(); choice.Distractor.Image = this.tabcontrol7ChoiceDistraImage.Text; choice.Distractor.SpeechText = this.tabcontrol7ChoiceDistraText.Text; trail.Questions.Add(choice); } else if (!this.tabcontrol7PuzzleQuestionType.Text.Equals("不存在")) { puzzle.ExciseName = this.tabcontrol7PuzzleExciseName.Text; puzzle.Speech = this.tabcontrol7PuzzleSound.Text; puzzle.QuestionType = this.tabcontrol7PuzzleQuestionType.Text; puzzle.PuzzleImage = new ImageItem(); puzzle.PuzzleImage.Image = this.tabcontrol7PuzzleRightImage.Text; puzzle.Distractor = new ImageItem(); puzzle.Distractor.Image = this.tabcontrol7PuzzleDistraImage.Text; trail.Questions.Add(puzzle); // MessageBox.Show(puzzleSerializeJSON); } }
private void save() { Trail trail = new Trail(); addTabcontrol0(trail); addTabcontrol1(trail); addTabcontrol2(trail); addTabcontrol3(trail); addTabcontrol4(trail); addTabcontrol5(trail); addTabcontrol6(trail); addTabcontrol7(trail); addTabcontrol8(trail); addTabcontrol9(trail); addTabcontrol10(trail); addTabcontrol11(trail); addTabcontrol12(trail); addTabcontrol13(trail); string lessonname = this.lessonName.Text; string trailChineseName = this.trailChineseName.Text; string trailSerializeJSON = JsonConvert.SerializeObject(trail); //Console.WriteLine(trailSerializeJSON); int count = dbhelper.GetLessonTrailCount(lessonname, trailChineseName); if (count > 0) { MessageBox.Show("已存在该课程的训练!"); return; } else { string sql = "insert into lessontrail (lessonName, trialName,chineseName,jsondata) values ('" + lessonname + "','" + "" + "','" + trailChineseName + "'," + "'" + trailSerializeJSON + "'" + ")"; dbhelper.RunSQL(sql); } }