public async void SaveCityToDB(List <City> cityList) { await Task.Run(() => { ShowStatusText($"开始保存城市数据"); using (SQLiteUtil sqlite = new SQLiteUtil(dbPath)) { var sql = "Delete From City"; sqlite.ExecuteNonQuery(sql); foreach (var item in cityList) { sql = "Insert Into City (ProvinceID,CityID,CityName,CityPinYin) Values (@ProvinceID,@CityID,@CityName,@CityPinYin)"; System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[] { new System.Data.SQLite.SQLiteParameter("@ProvinceID", item.ProvinceID), new System.Data.SQLite.SQLiteParameter("@CityID", item.CityID), new System.Data.SQLite.SQLiteParameter("@CityName", item.CityName), new System.Data.SQLite.SQLiteParameter("@CityPinYin", item.CityPinYinName) }; sqlite.ExecuteNonQuery(sql, parameters); ShowStatusText($"保存{item.CityName}数据完成"); Task.Delay(5); } } ShowStatusText($"保存城市数据完成"); }); }
private void ClearRecord() { using (SQLiteUtil sqlite = new SQLiteUtil(dbPath)) { var sql = "Delete From Result"; sqlite.ExecuteNonQuery(sql); } }
public async void SaveProvinceToDB(List <Province> provinceList) { await Task.Run(() => { ShowStatusText($"开始保存省份信息"); using (SQLiteUtil sqlite = new SQLiteUtil(dbPath)) { var sql = "Delete From Province"; sqlite.ExecuteNonQuery(sql); foreach (var item in provinceList) { sql = "Insert Into Province (ProvinceID,ProvinceName) Values (@ProvinceID,@ProvinceName)"; System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[] { new System.Data.SQLite.SQLiteParameter("@ProvinceID", item.ProvinceID), new System.Data.SQLite.SQLiteParameter("@ProvinceName", item.ProvinceName) }; sqlite.ExecuteNonQuery(sql, parameters); } } ShowStatusText($"保存省份信息完成"); }); }
private async Task SaveResult(Result result) { await Task.Run(() => { using (SQLiteUtil sqlite = new SQLiteUtil(dbPath)) { var sql = "Insert Into Result (CityID,Html,RestaurentName,AverageSpend,Keyword) values (@CityID,@Html,@RestaurentName,@AverageSpend,@Keyword)"; System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[] { new System.Data.SQLite.SQLiteParameter("@CityID", result.CityID), new System.Data.SQLite.SQLiteParameter("@Html", result.Html), new System.Data.SQLite.SQLiteParameter("@RestaurentName", result.RestaurentName), new System.Data.SQLite.SQLiteParameter("@AverageSpend", result.AverageSpend), new System.Data.SQLite.SQLiteParameter("@Keyword", result.Keyword) }; sqlite.ExecuteNonQuery(sql, parameters); } }); }