/// <summary> /// 增加一条数据 /// </summary> public long Add(Model.EsMin model) { int rowsAffected; IDataParameter[] parameters = { new SqlParameter("@Id", SqlDbType.BigInt, 8), new SqlParameter("@StatId", SqlDbType.Int, 4), new SqlParameter("StatCode", SqlDbType.Int, 4), new SqlParameter("@TP", SqlDbType.Float, 8), new SqlParameter("@DB", SqlDbType.Float, 8), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@WindSpeed", SqlDbType.Float, 8), new SqlParameter("@Rain", SqlDbType.Float, 8), new SqlParameter("@WindDirection", SqlDbType.Float, 8), new SqlParameter("@Temperature", SqlDbType.Float, 8), new SqlParameter("@Humidity", SqlDbType.Float, 8), new SqlParameter("@Airpressure", SqlDbType.Float, 8), new SqlParameter("@DataStatus", SqlDbType.Char, 1), new SqlParameter("@DevId", SqlDbType.Int, 4), new SqlParameter("@Country", SqlDbType.VarChar, 20), new SqlParameter("@Pm25", SqlDbType.Float, 8), new SqlParameter("@Pm100", SqlDbType.Float, 8) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.StatId; parameters[2].Value = model.StatCodeUp; parameters[3].Value = model.Tp; parameters[4].Value = model.Db; parameters[5].Value = model.UpdateTime; parameters[6].Value = model.WindSpeed; parameters[7].Value = model.Rain; parameters[8].Value = model.WindDirection; parameters[9].Value = model.Temperature; parameters[10].Value = model.Humidity; parameters[11].Value = model.Airpressure; parameters[12].Value = model.DataStatus; parameters[13].Value = model.DevId; parameters[14].Value = model.Country; parameters[15].Value = model.Pm25; parameters[16].Value = model.Pm100; DbHelperSql.RunProcedure("T_ESMin_ADD", parameters, out rowsAffected); return((long)parameters[0].Value); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.EsMin model) { return(_dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(Model.EsMin model) { return(_dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.EsMin DataRowToModel(DataRow row) { var model = new Model.EsMin(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = long.Parse(row["Id"].ToString()); } if (row["StatId"] != null && row["StatId"].ToString() != "") { model.StatId = int.Parse(row["StatId"].ToString()); } if (row["TP"] != null && row["TP"].ToString() != "") { model.Tp = double.Parse(row["TP"].ToString()); } if (row["DB"] != null && row["DB"].ToString() != "") { model.Db = double.Parse(row["DB"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } if (row["WindSpeed"] != null && row["WindSpeed"].ToString() != "") { model.WindSpeed = double.Parse(row["WindSpeed"].ToString()); } if (row["Rain"] != null && row["Rain"].ToString() != "") { model.Rain = double.Parse(row["Rain"].ToString()); } if (row["WindDirection"] != null && row["WindDirection"].ToString() != "") { model.WindDirection = double.Parse(row["WindDirection"].ToString()); } if (row["Temperature"] != null && row["Temperature"].ToString() != "") { model.Temperature = double.Parse(row["Temperature"].ToString()); } if (row["Humidity"] != null && row["Humidity"].ToString() != "") { model.Humidity = double.Parse(row["Humidity"].ToString()); } if (row["Airpressure"] != null && row["Airpressure"].ToString() != "") { model.Airpressure = double.Parse(row["Airpressure"].ToString()); } if (row["DataStatus"] != null) { model.DataStatus = row["DataStatus"].ToString(); } if (row["DevId"] != null && row["DevId"].ToString() != "") { model.DevId = int.Parse(row["DevId"].ToString()); } if (row["Country"] != null) { model.Country = row["Country"].ToString(); } if (row["Pm25"] != null) { model.Pm25 = double.Parse(row["Pm25"].ToString()); } if (row["PM100"] != null) { model.Pm100 = double.Parse(row["PM100"].ToString()); } } return(model); }