public async Task SaveWeatherMsg(List <IWeatherMsg> msglist, string name)
{
List <string> sqllist = new List <string>();
int id = db.GetAreaIDByName(name);
if (id == 0)
{
MessageBox.Show("该地区暂无天气信息");
return;
}
for (int i = 0; i < msglist.Count; i++)
{
string sql;
if (msglist[i].flag == 1)//小时
{
WeatherHoursMsg hoursMsg = msglist[i] as WeatherHoursMsg;
sql =
String.Format(
"INSERT INTO HoursRainInfo ([day],[time],[temperature],[rains],[wind],[windL],[humidity],[AreaID]) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
hoursMsg.day, hoursMsg.time, hoursMsg.temperature, hoursMsg.rains, hoursMsg.wind, hoursMsg.windL,
hoursMsg.humidity, id);
}
else
{
WeatherDayMsg dayMsg = msglist[i] as WeatherDayMsg;
sql =
String.Format(
"INSERT INTO DayRainInfo ([time],[maxTemp],[minTemp],[wind],[windL],[alarmmsg],[weatherStatus],[AreaID]) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
dayMsg.time, dayMsg.maxTemp, dayMsg.minTemp, dayMsg.wind, dayMsg.windL, dayMsg.alarmmsg,
dayMsg.weatherStatus, id);
}
sqllist.Add(sql);
}
db.insertToAccessByBatch(sqllist);
}
/// <summary>
/// 获取并存储省信息
/// </summary>
public static void GetAndSaveProvince()
{
List <string> sqlList = new List <string>();
string url = AppDomain.CurrentDomain.BaseDirectory.Replace("bin\\Debug\\", "temp\\province.html");
HtmlWeb web = new HtmlWeb();
HtmlDocument doc = web.Load(url);
var htmls = doc.DocumentNode.SelectNodes("//select[@id='provinceSel']");
do
{
doc = web.Load(url);
htmls = doc.DocumentNode.SelectNodes("//select[@id='provinceSel']");
} while (htmls == null);
var option = htmls.First().ChildNodes;
for (int i = 0; i < option.Count / 2; i++)
{
string sql = String.Format("INSERT INTO Province ([ProvinceCode],[ProvinceName]) VALUES ('{0}','{1}')",
option[2 * i].Attributes["value"].Value, option[2 * i + 1].InnerHtml.Trim());
sqlList.Add(sql);
}
db.insertToAccessByBatch(sqlList);
}
public async Task SaveEarthquakrMsgs(List <EarthquakeMsg> list)
{
List <string> sqllist = new List <string>();
for (int i = 0; i < list.Count; i++)
{
string sql =
String.Format(
"INSERT INTO EarthquakeInfo ([level],[time],[longitude],[latitude],[depth],[position]) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')",
list[i].level, list[i].time, list[i].longitude, list[i].latitude, list[i].depth,
list[i].position);
sqllist.Add(sql);
}
db.insertToAccessByBatch(sqllist);
}
