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++;
}
}
