public bool Add(WeatherDetailData model)
{
string sql = "INSERT INTO WeatherDetailData Values(@CollectTime,@CityCode,@Humidity,@Temperature,@Notes)";
SqlParameterCollection ps = new SqlParameterCollection();
ps.Add("CollectTime", model.CollectTime, DbType.DateTime);
ps.Add("CityCode", model.CityCode, DbType.String);
ps.Add("Humidity", model.Humidity, DbType.Decimal);
ps.Add("Temperature", model.Temperature, DbType.Decimal);
ps.Add("Notes", model.Notes, DbType.String);
this.SqlHelper.ExecuteNonQuery(sql, ps);
return(true);
}
public void addWeatherDataDetail(WeatherDetailData data)
{
MsSqlHelper msSql = DbUtility.MsSqlHelper;
try
{
wdatadetail.SqlHelper = msSql;
}
finally
{
msSql.Dispose();
}
wdatadetail.Add(data);
}
// 存储实时数据
public void ProcessNow(Dictionary <string, object> boj_d, string citycode)
{
try
{
WeatherBLL bll = new WeatherBLL();
WeatherDetailData wdd = new WeatherDetailData();
wdd.CityCode = citycode;
wdd.CollectTime = DateTime.Now;
// 湿度
wdd.Humidity = decimal.Parse(boj_d["hum"].ToString());
// 温度
wdd.Temperature = decimal.Parse(boj_d["tmp"].ToString());
// 备注
wdd.Notes = "";
bll.addWeatherDataDetail(wdd);
}
catch (Exception err)
{
writestr(err.Message);
writestr(err.StackTrace);
}
}
