public static void SaveWord(EnglishWordSqliteHelper englishWordDbHleper, EnglishWordTranslationData wordData) { if (string.IsNullOrEmpty(wordData.Word)) { return; } var previousWord = englishWordDbHleper.GetWord(wordData.Word); WordInfo newWord = new WordInfo(); newWord.Word = wordData.Word; var sentenceSaveInfos = GetSentenceSaveInfos(wordData); var newSemanticList = GetSemanticSaveInfos(wordData); var phraseSaveInfos = GetPhraseSaveInfos(wordData); var synonymSaveInfos = GetSynonymInfos(wordData); var cognateSaveInfos = GetCognateInfos(wordData); if (previousWord != null) { var pronounceFileName = previousWord.PronounceFileName; SetWordPronounceInfo(wordData, ref pronounceFileName, out string pronounce); newWord.Pronounce = pronounce; newWord.PronounceFileName = pronounceFileName; newWord.Semantic = string.IsNullOrEmpty(previousWord.Semantic) ? newSemanticList.Count > 0 ? JsonConvert.SerializeObject(newSemanticList) : string.Empty : previousWord.Semantic; newWord.Phrase = string.IsNullOrEmpty(previousWord.Phrase) ? phraseSaveInfos.Count > 0 ? JsonConvert.SerializeObject(phraseSaveInfos) : string.Empty : previousWord.Phrase; newWord.Sentence = string.IsNullOrEmpty(previousWord.Sentence) ? sentenceSaveInfos.Count > 0 ? JsonConvert.SerializeObject(sentenceSaveInfos) : string.Empty : previousWord.Sentence; newWord.Synonym = string.IsNullOrEmpty(previousWord.Synonym) ? synonymSaveInfos.Count > 0 ? JsonConvert.SerializeObject(synonymSaveInfos) : string.Empty : previousWord.Synonym; newWord.Cognate = string.IsNullOrEmpty(previousWord.Cognate) ? cognateSaveInfos.Count > 0 ? JsonConvert.SerializeObject(cognateSaveInfos) : string.Empty : previousWord.Cognate; englishWordDbHleper.UpdateWordInfo(newWord); } else { var pronounceFileName = string.Empty; SetWordPronounceInfo(wordData, ref pronounceFileName, out string pronounce); newWord.Pronounce = pronounce; newWord.PronounceFileName = pronounceFileName; newWord.Semantic = newSemanticList.Count > 0 ? JsonConvert.SerializeObject(newSemanticList) : string.Empty; newWord.Phrase = phraseSaveInfos.Count > 0 ? JsonConvert.SerializeObject(phraseSaveInfos) : string.Empty; newWord.Sentence = sentenceSaveInfos.Count > 0 ? JsonConvert.SerializeObject(sentenceSaveInfos) : string.Empty; newWord.Synonym = synonymSaveInfos.Count > 0 ? JsonConvert.SerializeObject(synonymSaveInfos) : string.Empty; newWord.Cognate = cognateSaveInfos.Count > 0 ? JsonConvert.SerializeObject(cognateSaveInfos) : string.Empty; englishWordDbHleper.SaveWord(newWord); } }
//private EnglishWordSqliteHelper _englishWordOutput; public MainWindow() { InitializeComponent(); _englishWordSource = new EnglishWordSqliteHelper(CustomPathUtil.DbSourcePath); //_englishWordOutput = new EnglishWordSqliteHelper(CustomPathUtil.DbOuputPath); }