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