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