/// <summary>
/// 根据传感器波段编号获得一个对象实体
/// </summary>
/// <param name="SensorID"></param>
/// <returns></returns>
public Model.Sensor_Band_Mode GetModel(string platformid, string sensorid, string bandid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Select * from SENSOR_BAND_MODE ");
strSql.Append(" Where PLATFORM_ID=" + platformid);
strSql.Append(" and SensorID=" + sensorid);
strSql.Append(" and BandID=" + bandid);
Model.Sensor_Band_Mode 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>
/// 传感器波段添加函数,添加删除和管理的数据库连接还存在问题
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.Sensor_Band_Mode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Insert into SENSOR_BAND_MODE(");
strSql.Append("BandID,BAND_MODE_NAME,BandType,SensorID,SensorName,");
strSql.Append("PLATFORM_ID,PLATFORM_NAME,SwathWidth,BandWidth,BandCenter,");
strSql.Append("SpectralRangeMin,SpectralRangeMax,PolarizationMode,SNRRatio,");
strSql.Append("PixelPerLine)");
strSql.Append(" Values(");
strSql.Append("@in_BandID,@in_BAND_MODE_NAME,@in_BandType,@in_SensorID,@in_SensorName,@in_PLATFORM_ID,@in_PLATFORM_NAME,@in_SwathWidth,@in_BandWidth,@in_BandCenter,");
strSql.Append("@in_SpectralRangeMin,@in_SpectralRangeMax,@in_PolarizationMode,@in_SNRRatio,@in_PixelPerLine)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_BandID", SqlDbType.Decimal),
new SqlParameter("@in_BAND_MODE_NAME", SqlDbType.NVarChar),
new SqlParameter("@in_BandType", SqlDbType.NVarChar),
new SqlParameter("@in_SensorID", SqlDbType.Decimal),
new SqlParameter("@in_SensorName", SqlDbType.NVarChar),
new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal),
new SqlParameter("@in_PLATFORM_NAME", SqlDbType.NVarChar),
new SqlParameter("@in_SwathWidth", SqlDbType.Decimal),
new SqlParameter("@in_BandWidth", SqlDbType.Decimal),
new SqlParameter("@in_BandCenter", SqlDbType.Decimal),
new SqlParameter("@in_SpectralRangeMin", SqlDbType.Decimal),
new SqlParameter("@in_SpectralRangeMax", SqlDbType.Decimal),
new SqlParameter("@in_PolarizationMode", SqlDbType.NVarChar),
new SqlParameter("@in_SNRRatio", SqlDbType.Decimal),
new SqlParameter("@in_PixelPerLine", SqlDbType.Decimal)
};
cmdParms[0].Value = model.BandID;
cmdParms[1].Value = model.BAND_MODE_NAME;
cmdParms[2].Value = model.BandType;
cmdParms[3].Value = model.SensorID;
cmdParms[4].Value = model.SensorName;
cmdParms[5].Value = model.PLATFORM_ID;
cmdParms[6].Value = model.PLATFORM_NAME;
cmdParms[7].Value = model.SwathWidth;
cmdParms[8].Value = model.BandWidth;
cmdParms[9].Value = model.BandCenter;
cmdParms[10].Value = model.SpectralRangeMin;
cmdParms[11].Value = model.SpectralRangeMax;
cmdParms[12].Value = model.PolarizationMode;
cmdParms[13].Value = model.SNRRatio;
cmdParms[14].Value = model.PixelPerLine;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));//执行SQL语句，还需修改数据库连接的问题
}
/// <summary>
/// 根据波段ID修改数据库中的一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.Sensor_Band_Mode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update SENSOR_BAND_MODE SET ");
strSql.Append("BAND_MODE_NAME=@in_BAND_MODE_NAME,");
strSql.Append("BandType=@in_BandType,");
strSql.Append("SensorID=@in_SensorID,");
strSql.Append("SensorName=@in_SensorName,");
strSql.Append("PLATFORM_ID=@in_PLATFORM_ID,");
strSql.Append("PLATFORM_NAME=@in_PLATFORM_NAME,");
strSql.Append("SwathWidth=@in_SwathWidth,");
strSql.Append("BandWidth=@in_BandWidth,");
strSql.Append("BandCenter=@in_BandCenter,");
strSql.Append("SpectralRangeMin=@in_SpectralRangeMin,");
strSql.Append("SpectralRangeMax=@in_SpectralRangeMax,");
strSql.Append("PolarizationMode=@in_PolarizationMode,");
strSql.Append("SNRRatio=@in_SNRRatio,");
strSql.Append("PixelPerLine=@in_PixelPerLine");
strSql.Append(" where BandID=@in_BandID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_BandID", SqlDbType.Decimal),
new SqlParameter("@in_BAND_MODE_NAME", SqlDbType.NVarChar),
new SqlParameter("@in_BandType", SqlDbType.NVarChar),
new SqlParameter("@in_SensorID", SqlDbType.Decimal),
new SqlParameter("@in_SensorName", SqlDbType.NVarChar),
new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal),
new SqlParameter("@in_PLATFORM_NAME", SqlDbType.NVarChar),
new SqlParameter("@in_SwathWidth", SqlDbType.Decimal),
new SqlParameter("@in_BandWidth", SqlDbType.Decimal),
new SqlParameter("@in_BandCenter", SqlDbType.Decimal),
new SqlParameter("@in_SpectralRangeMin", SqlDbType.Decimal),
new SqlParameter("@in_SpectralRangeMax", SqlDbType.Decimal),
new SqlParameter("@in_PolarizationMode", SqlDbType.NVarChar),
new SqlParameter("@in_SNRRatio", SqlDbType.Decimal),
new SqlParameter("@in_PixelPerLine", SqlDbType.Decimal)
};
cmdParms[0].Value = model.BandID;
cmdParms[1].Value = model.BAND_MODE_NAME;
cmdParms[2].Value = model.BandType;
cmdParms[3].Value = model.SensorID;
cmdParms[4].Value = model.SensorName;
cmdParms[5].Value = model.PLATFORM_ID;
cmdParms[6].Value = model.PLATFORM_NAME;
cmdParms[7].Value = model.SwathWidth;
cmdParms[8].Value = model.BandWidth;
cmdParms[9].Value = model.BandCenter;
cmdParms[10].Value = model.SpectralRangeMin;
cmdParms[11].Value = model.SpectralRangeMax;
cmdParms[12].Value = model.PolarizationMode;
cmdParms[13].Value = model.SNRRatio;
cmdParms[14].Value = model.PixelPerLine;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
