private void SaveHanziTextLinesToDB() { var filePath = @"F:\OneDrive\WorkArea\工作项\汉字\汉字列表New.txt"; var hanziLines = File.ReadAllLines(filePath); var hanziDataList = hanziLines.Where(i => !string.IsNullOrWhiteSpace(i)).ToList(); int rowIndex = 1; var searchedContent = new List <HanziInfo>(); var hanziSqlliteHelper = new HanziSqlliteHelper(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Hanzi.db3")); var allHanziInfos = hanziSqlliteHelper.GetAllHanziInfos(); foreach (var hanziData in hanziDataList) { var hanziDataTemp = hanziData; var hanzi = hanziDataTemp.Substring(0, hanziDataTemp.IndexOf("|")); hanziDataTemp = hanziDataTemp.Substring(hanzi.Length + 1, hanziDataTemp.Length - hanzi.Length - 1); var pinyin = hanziDataTemp.Substring(0, hanziDataTemp.IndexOf("|")); hanziDataTemp = hanziDataTemp.Substring(pinyin.Length + 1, hanziDataTemp.Length - pinyin.Length - 1); var radical = hanziDataTemp.Substring(0, hanziDataTemp.IndexOf("|")); hanziDataTemp = hanziDataTemp.Substring(radical.Length + 1, hanziDataTemp.Length - radical.Length - 1); var biHua = hanziDataTemp.Substring(0, hanziDataTemp.IndexOf("|")); hanziDataTemp = hanziDataTemp.Substring(biHua.Length + 1, hanziDataTemp.Length - biHua.Length - 1); var wubi = hanziDataTemp.Substring(0, hanziDataTemp.IndexOf("|")); hanziDataTemp = hanziDataTemp.Substring(wubi.Length + 1, hanziDataTemp.Length - wubi.Length - 1); var biHuaCode = hanziDataTemp; //姁|xǔ|女|8|vqkg|53135251y?)〕神态和悦娇媚,如“姣服极丽,姁姁致态。” Match match = Regex.Match(biHuaCode, "\\d+"); var tryParse = int.TryParse(match.Value, out int biHuaCodeConvertResult); //var aaa = new HanziInfo() //{ // ID = rowIndex, // Hanzi = hanzi, // Pinyin = pinyin, // Radical = radical == "难检字" ? string.Empty : radical, // StrokeCount = Convert.ToInt32(biHua), // WuBi = wubi, // StrokeCode = biHuaCodeConvertResult.ToString(), //}; //hanziSqlliteHelper.SaveHanzi(aaa); if (allHanziInfos.Any(i => i.Hanzi == hanzi && string.IsNullOrWhiteSpace(i.StrokeCode))) { var hanziInfo = allHanziInfos.First(i => i.Hanzi == hanzi); hanziInfo.StrokeCode = biHuaCodeConvertResult == 0 ? string.Empty : biHuaCodeConvertResult.ToString(); hanziSqlliteHelper.UpdateHanziInfo(hanziInfo); } rowIndex++; } }