/// <summary> /// 录入数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InsertData_Click(object sender, RoutedEventArgs e) { sqliteTool = new SqliteTool(); var insertDataTime = DateTime.Parse(insertDataTimeDatePicker.Text); var insertDataCount = int.Parse(insertDataCountTextBox.Text); //按年份分库 var dbName = $"HistoricalDataManageDb_{insertDataTime.ToString("yyyy")}"; sqliteTool.CreateNewDatabase(filePath, dbName); sqliteTool.ConnectToDatabase(filePath, dbName); //按天分表 var suffix = GetSuffix(insertDataTime); CreateTable(suffix); InsertData(insertDataCount, suffix, insertDataTime); }