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