/// <summary> /// 平台状态添加函数,添加、删除和管理的数据库连接还存在问题 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Model.STATE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO STATE("); strSql.Append("PLATFORM_ID,TimeReference,SpaceReference,Longitude,Latitude,Elevation,SlewAngle,PLATFORM_TIME,CloudCover,WeatherModelName,"); strSql.Append("PrecipitationRate,WindSpeed,AmbientTemperature,MisDisOfRoad,MTBF,ObservingTime,UsingState,"); strSql.Append("FalutState,ResourceConsuming,CurrentMemory)"); strSql.Append(" Values("); strSql.Append("@in_PLATFORM_ID,@in_TimeReference,@in_SpaceReference,@in_Longitude,@in_Latitude,@in_Elevation,@in_SlewAngle,@in_PLATFORM_TIME,@in_CloudCover,@in_WeatherModelName,"); strSql.Append("@in_PrecipitationRate,@in_WindSpeed,@in_AmbientTemperature,@in_MisDisOfRoad,@in_MTBF,@in_ObservingTime,"); strSql.Append("@in_UsingState,@in_FalutState,@in_ResourceConsuming,@in_CurrentMemory)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal), new SqlParameter("@in_TimeReference", SqlDbType.NVarChar), new SqlParameter("@in_SpaceReference", SqlDbType.NVarChar), new SqlParameter("@in_Longitude", SqlDbType.Decimal), new SqlParameter("@in_Latitude", SqlDbType.Decimal), new SqlParameter("@in_Elevation", SqlDbType.Decimal), new SqlParameter("@in_SlewAngle", SqlDbType.Decimal), new SqlParameter("@in_PLATFORM_TIME", SqlDbType.Decimal), new SqlParameter("@in_CloudCover", SqlDbType.Decimal), new SqlParameter("@in_WeatherModelName", SqlDbType.Decimal), new SqlParameter("@in_PrecipitationRate", SqlDbType.NVarChar), new SqlParameter("@in_WindSpeed", SqlDbType.Decimal), new SqlParameter("@in_AmbientTemperature", SqlDbType.Decimal), new SqlParameter("@in_MisDisOfRoad", SqlDbType.Decimal), new SqlParameter("@in_MTBF", SqlDbType.Decimal), new SqlParameter("@in_ObservingTime", SqlDbType.Decimal), new SqlParameter("@in_UsingState", SqlDbType.Decimal), new SqlParameter("@in_FalutState", SqlDbType.Decimal), new SqlParameter("@in_ResourceConsuming", SqlDbType.Decimal), new SqlParameter("@in_CurrentMemory", SqlDbType.Decimal) }; cmdParms[0].Value = model.PLATFORM_ID; cmdParms[1].Value = model.TimeReference; cmdParms[2].Value = model.SpaceReference; cmdParms[3].Value = model.Longitude; cmdParms[4].Value = model.Latitude; cmdParms[5].Value = model.Elevation; cmdParms[6].Value = model.SlewAngle; cmdParms[7].Value = model.PLATFORM_TIME; cmdParms[8].Value = model.CloudCover; cmdParms[9].Value = model.WeatherModelName; cmdParms[10].Value = model.PrecipitationRate; cmdParms[11].Value = model.WindSpeed; cmdParms[12].Value = model.AmbientTemperature; cmdParms[13].Value = model.MisDisOfRoad; cmdParms[14].Value = model.MTBF; cmdParms[15].Value = model.ObservingTime; cmdParms[16].Value = model.UsingState; cmdParms[17].Value = model.FalutState; cmdParms[18].Value = model.ResourceConsuming; cmdParms[19].Value = model.CurrentMemory; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));//执行SQL语句,还需修改数据库连接的问题 }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="SensorID"></param> /// <returns></returns> public Model.STATE GetModel(decimal PLATFORM_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("Select * from STATE "); strSql.Append(" Where PLATFORM_ID=" + PLATFORM_ID); Model.STATE model = null; //数据库连接 SqlConnection connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(strSql.ToString(), connection); connection.Open(); SqlDataReader myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); using (DbDataReader dr = myReader) { while (dr.Read()) { model = GetModel(dr);//本类中的重载函数 } return(model); } }
/// <summary> /// 根据平台ID修改数据库中的一条记录 /// </summary> /// <param name="model"></param>观测平台状态实体类的实例 /// <returns></returns>返回值为修改的记录数 public int Update(Model.STATE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update STATE set "); strSql.Append("SpaceReference=@in_SpaceReference,"); strSql.Append("Longitude=@in_Longitude,"); strSql.Append("Latitude=@in_Latitude,"); strSql.Append("Elevation=@in_Elevation,"); strSql.Append("SlewAngle=@in_SlewAngle,"); strSql.Append("PLATFORM_TIME=@in_PLATFORM_TIME,"); strSql.Append("CloudCover=@in_CloudCover,"); strSql.Append("WeatherModelName=@in_WeatherModelName,"); strSql.Append("PrecipitationRate=@in_PrecipitationRate,"); strSql.Append("WindSpeed=@in_WindSpeed,"); strSql.Append("AmbientTemperature=@in_AmbientTemperature,"); strSql.Append("MisDisOfRoad=@in_MisDisOfRoad,"); strSql.Append("MTBF=@in_MTBF,"); strSql.Append("ObservingTime=@in_ObservingTime,"); strSql.Append("UsingState=@in_UsingState,"); strSql.Append("FalutState=@in_FalutState,"); strSql.Append("ResourceConsuming=@in_ResourceConsuming,"); strSql.Append("CurrentMemory=@in_CurrentMemory,"); strSql.Append(" where PLATFORM_ID=@in_PLATFORM_ID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal), new SqlParameter("@in_TimeReference", SqlDbType.NVarChar), new SqlParameter("@in_SpaceReference", SqlDbType.NVarChar), new SqlParameter("@in_Longitude", SqlDbType.Decimal), new SqlParameter("@in_Latitude", SqlDbType.Decimal), new SqlParameter("@in_Elevation", SqlDbType.Decimal), new SqlParameter("@in_SlewAngle", SqlDbType.Decimal), new SqlParameter("@in_PLATFORM_TIME", SqlDbType.DateTime), new SqlParameter("@in_CloudCover", SqlDbType.Decimal), new SqlParameter("@in_WeatherModelName", SqlDbType.NVarChar), new SqlParameter("@in_PrecipitationRate", SqlDbType.Decimal), new SqlParameter("@in_WindSpeed", SqlDbType.Decimal), new SqlParameter("@in_AmbientTemperature", SqlDbType.Decimal), new SqlParameter("@in_MisDisOfRoad", SqlDbType.Decimal), new SqlParameter("@in_MTBF", SqlDbType.Decimal), new SqlParameter("@in_ObservingTime", SqlDbType.Decimal), new SqlParameter("@in_UsingState", SqlDbType.Bit), new SqlParameter("@in_FalutState", SqlDbType.Bit), new SqlParameter("@in_ResourceConsuming", SqlDbType.Decimal), new SqlParameter("@in_CurrentMemory", SqlDbType.Decimal) }; cmdParms[0].Value = model.PLATFORM_ID; cmdParms[1].Value = model.TimeReference; cmdParms[2].Value = model.SpaceReference; cmdParms[3].Value = model.Longitude; cmdParms[4].Value = model.Latitude; cmdParms[5].Value = model.Elevation; cmdParms[6].Value = model.SlewAngle; cmdParms[7].Value = model.PLATFORM_TIME; cmdParms[8].Value = model.CloudCover; cmdParms[9].Value = model.WeatherModelName; cmdParms[10].Value = model.PrecipitationRate; cmdParms[11].Value = model.WindSpeed; cmdParms[12].Value = model.AmbientTemperature; cmdParms[13].Value = model.MisDisOfRoad; cmdParms[14].Value = model.MTBF; cmdParms[15].Value = model.ObservingTime; cmdParms[16].Value = model.UsingState; cmdParms[17].Value = model.FalutState; cmdParms[18].Value = model.ResourceConsuming; cmdParms[19].Value = model.CurrentMemory; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }