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