c#中odp.net 4.0利用odac操作oracle数据库学习(二)

c#中odp.net 4.0利用odac操作oracle数据库学习(二)

简介：讲述对tm_raw_image_metadata_infos表的实体封装，是适应单项查询,单项的添加，删除，修改以及批量的添加，删除，修改的操作需求

 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

RawImageMetaDataInfo实体类：

/********************************************************
    *文件所属:北京******公司
    *文件名称:原始影像数据的元数据信息管理
    *文件描述:对原始影像数据的元数据信息管理模块实体层代码支持
    *  创建人:PengZhen
    *创建时间:2013-11-26 10:37:25
 ********************************************************/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Types;
using System.Runtime.CompilerServices;

namespace BDSS.Model.DAL.Model
{
    /// <summary>
    /// 原始影像数据的元数据信息表
    /// </summary>
    public class RawImageMetaDataInfo
    {
        #region Model

        private string _id;
        private string _data_name;
        private decimal _dataid;
        private string _satellite_type_code;
        private string _sensor_type_code;
        private string _scene_id;
        private decimal _scene_path;
        private decimal _scene_row;
        private decimal _scene_shift;
        private decimal _scene_count;
        private decimal _satellite_path;
        private decimal _satellite_row;
        private string _image_format;
        private decimal _image_width;
        private decimal _image_height;
        private string _image_gds_code;
        private decimal _image_width_pixels;
        private decimal _image_height_pixels;
        private string _image_bands;
        private decimal _image_bands_count;
        private decimal _orbit_id;
        private string _cloudcover_code;
        private decimal _pixels_numbers;
        private decimal _valid_pixels_bits;
        private string _cs_code;
        private string _locator_unit;
        private string _projection_code;
        private string _projection_params;
        private string _zone_code;
        private string _zone_no;
        private string _elevation_code;
        private decimal _shoot_elevating_angle;
        private decimal _shoot_azimuth_angle;
        private decimal _rollviewing_angle;
        private decimal _pitchviewing_angle;
        private decimal _roll_satellite_angle;
        private decimal _pitch_satellite_angle;
        private decimal _yaw_satellite_angle;
        private decimal _satelliteazimuth;
        private decimal _satellitezenith;
        private string _decimalegrationlevel;
        private string _mtfcorrection;
        private string _relativecorrectiondata;
        private decimal _solar_zenith_angle;
        private decimal _sun_azimuth_angle;
        private decimal _gain_mode;
        private string _resample_method;
        private decimal _center_podecimal_lon;
        private decimal _center_podecimal_lat;
        private decimal _center_podecimal_ele;
        private decimal _tl_lon;
        private decimal _tl_lat;
        private decimal _tr_lon;
        private decimal _tr_lat;
        private decimal _br_lon;
        private decimal _br_lat;
        private decimal _bl_lon;
        private decimal _bl_lat;
        private decimal _tl_x;
        private decimal _tl_y;
        private decimal _tr_x;
        private decimal _tr_y;
        private decimal _br_x;
        private decimal _br_y;
        private decimal _bl_x;
        private decimal _bl_y;
        private string _product_name;
        private string _product_sn;
        private string _product_category_code;
        private string _product_ownership_unit;
        private string _product_production_unit;
        private string _product_class_grade_code;
        private string _product_quality_grade_code;
        private string _product_securitylevel_code;
        private string _product_format_code;
        private DateTime _product_collect_date;
        private DateTime _product_cure_date;
        private DateTime _product_archive_date;
        private decimal _product_size;
        private string _product_quality_report;
        private string _product_order_number;
        private string _product_ar_code;
        private string _product_storage_path;
        private byte[] _product_quickview;
        private byte[] _product_thumb;
        private string _create_userid;
        private DateTime _create_date;
        private decimal _used_count;
        private string _status;
        private string _remarks;
        private string _envelope;
        private DateTime _collect_date;
        private DateTime _collect_date_begin;
        private DateTime _collect_date_end;
        private string _product_size_measure;
        private string _is_compressed;
        private string _product_files_list;
        private string _product_use;
        /// <summary>
        /// 记录编号:0:0
        /// </summary>
        public string ID
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// 数据名称:1:0
        /// </summary>
        public string DATA_NAME
        {
            set { _data_name = value; }
            get { return _data_name; }
        }
        /// <summary>
        /// 导入数据的ID:1:0
        /// </summary>
        public decimal DATAID
        {
            set { _dataid = value; }
            get { return _dataid; }
        }
        /// <summary>
        /// 卫星类别代码:1:3
        /// </summary>
        public string SATELLITE_TYPE_CODE
        {
            set { _satellite_type_code = value; }
            get { return _satellite_type_code; }
        }
        /// <summary>
        /// 传感器类型代码:1:4
        /// </summary>
        public string SENSOR_TYPE_CODE
        {
            set { _sensor_type_code = value; }
            get { return _sensor_type_code; }
        }
        /// <summary>
        /// 景号:1:0
        /// </summary>
        public string SCENE_ID
        {
            set { _scene_id = value; }
            get { return _scene_id; }
        }
        /// <summary>
        /// 景Path:1:0
        /// </summary>
        public decimal SCENE_PATH
        {
            set { _scene_path = value; }
            get { return _scene_path; }
        }
        /// <summary>
        /// 景Row:1:0
        /// </summary>
        public decimal SCENE_ROW
        {
            set { _scene_row = value; }
            get { return _scene_row; }
        }
        /// <summary>
        /// 景漂移:1:0
        /// </summary>
        public decimal SCENE_SHIFT
        {
            set { _scene_shift = value; }
            get { return _scene_shift; }
        }
        /// <summary>
        /// 条带景数目:1:0
        /// </summary>
        public decimal SCENE_COUNT
        {
            set { _scene_count = value; }
            get { return _scene_count; }
        }
        /// <summary>
        /// 星下点Path:1:0
        /// </summary>
        public decimal SATELLITE_PATH
        {
            set { _satellite_path = value; }
            get { return _satellite_path; }
        }
        /// <summary>
        /// 星下点Row:1:0
        /// </summary>
        public decimal SATELLITE_ROW
        {
            set { _satellite_row = value; }
            get { return _satellite_row; }
        }
        /// <summary>
        /// 影像格式代码:1:7
        /// </summary>
        public string IMAGE_FORMAT
        {
            set { _image_format = value; }
            get { return _image_format; }
        }
        /// <summary>
        /// 影像宽度(单位：米):1:0
        /// </summary>
        public decimal IMAGE_WIDTH
        {
            set { _image_width = value; }
            get { return _image_width; }
        }
        /// <summary>
        /// 影像高度(单位：米):1:0
        /// </summary>
        public decimal IMAGE_HEIGHT
        {
            set { _image_height = value; }
            get { return _image_height; }
        }
        /// <summary>
        /// 影像分辨率:1:31
        /// </summary>
        public string IMAGE_GDS_CODE
        {
            set { _image_gds_code = value; }
            get { return _image_gds_code; }
        }
        /// <summary>
        /// 影像行像素个数:1:0
        /// </summary>
        public decimal IMAGE_WIDTH_PIXELS
        {
            set { _image_width_pixels = value; }
            get { return _image_width_pixels; }
        }
        /// <summary>
        /// 影像列像素个数:1:0
        /// </summary>
        public decimal IMAGE_HEIGHT_PIXELS
        {
            set { _image_height_pixels = value; }
            get { return _image_height_pixels; }
        }
        /// <summary>
        /// 成像波段范围:1:0
        /// </summary>
        public string IMAGE_BANDS
        {
            set { _image_bands = value; }
            get { return _image_bands; }
        }
        /// <summary>
        /// 影像波段数
        /// </summary>
        public decimal IMAGE_BANDS_COUNT
        {
            set { _image_bands_count = value; }
            get { return _image_bands_count; }
        }
        /// <summary>
        /// 轨道圈号:1:0
        /// </summary>
        public decimal ORBIT_ID
        {
            set { _orbit_id = value; }
            get { return _orbit_id; }
        }
        /// <summary>
        /// 云量代码:1:34
        /// </summary>
        public string CLOUDCOVER_CODE
        {
            set { _cloudcover_code = value; }
            get { return _cloudcover_code; }
        }
        /// <summary>
        /// 像素位数:1:0
        /// </summary>
        public decimal PIXELS_NUMBERS
        {
            set { _pixels_numbers = value; }
            get { return _pixels_numbers; }
        }
        /// <summary>
        /// 有效像素位数:1:0
        /// </summary>
        public decimal VALID_PIXELS_BITS
        {
            set { _valid_pixels_bits = value; }
            get { return _valid_pixels_bits; }
        }
        /// <summary>
        /// 坐标系统代码:1:26
        /// </summary>
        public string CS_CODE
        {
            set { _cs_code = value; }
            get { return _cs_code; }
        }
        /// <summary>
        /// 坐标单位代码:1:0
        /// </summary>
        public string LOCATOR_UNIT
        {
            set { _locator_unit = value; }
            get { return _locator_unit; }
        }
        /// <summary>
        /// 投影方式代码:1:27
        /// </summary>
        public string PROJECTION_CODE
        {
            set { _projection_code = value; }
            get { return _projection_code; }
        }
        /// <summary>
        /// 投影参数:1:0
        /// </summary>
        public string PROJECTION_PARAMS
        {
            set { _projection_params = value; }
            get { return _projection_params; }
        }
        /// <summary>
        /// 分带类型代码:1:40
        /// </summary>
        public string ZONE_CODE
        {
            set { _zone_code = value; }
            get { return _zone_code; }
        }
        /// <summary>
        /// 带号:1:0
        /// </summary>
        public string ZONE_NO
        {
            set { _zone_no = value; }
            get { return _zone_no; }
        }
        /// <summary>
        /// 高程分类代码:1:32
        /// </summary>
        public string ELEVATION_CODE
        {
            set { _elevation_code = value; }
            get { return _elevation_code; }
        }
        /// <summary>
        /// 拍摄高度角:1:0
        /// </summary>
        public decimal SHOOT_ELEVATING_ANGLE
        {
            set { _shoot_elevating_angle = value; }
            get { return _shoot_elevating_angle; }
        }
        /// <summary>
        /// 拍摄方位角:1:0
        /// </summary>
        public decimal SHOOT_AZIMUTH_ANGLE
        {
            set { _shoot_azimuth_angle = value; }
            get { return _shoot_azimuth_angle; }
        }
        /// <summary>
        /// 相机侧视角:1:0
        /// </summary>
        public decimal ROLLVIEWING_ANGLE
        {
            set { _rollviewing_angle = value; }
            get { return _rollviewing_angle; }
        }
        /// <summary>
        /// 相机前后视角:1:0
        /// </summary>
        public decimal PITCHVIEWING_ANGLE
        {
            set { _pitchviewing_angle = value; }
            get { return _pitchviewing_angle; }
        }
        /// <summary>
        /// 卫星滚动角:1:0
        /// </summary>
        public decimal ROLL_SATELLITE_ANGLE
        {
            set { _roll_satellite_angle = value; }
            get { return _roll_satellite_angle; }
        }
        /// <summary>
        /// 卫星平均俯仰角:1:0
        /// </summary>
        public decimal PITCH_SATELLITE_ANGLE
        {
            set { _pitch_satellite_angle = value; }
            get { return _pitch_satellite_angle; }
        }
        /// <summary>
        /// 卫星平均偏航角:1:0
        /// </summary>
        public decimal YAW_SATELLITE_ANGLE
        {
            set { _yaw_satellite_angle = value; }
            get { return _yaw_satellite_angle; }
        }
        /// <summary>
        /// 卫星方位角
        /// </summary>
        public decimal SATELLITEAZIMUTH
        {
            set { _satelliteazimuth = value; }
            get { return _satelliteazimuth; }
        }
        /// <summary>
        /// 卫星高度角
        /// </summary>
        public decimal SATELLITEZENITH
        {
            set { _satellitezenith = value; }
            get { return _satellitezenith; }
        }
        /// <summary>
        /// 积分级数
        /// </summary>
        public string INTEGRATIONLEVEL
        {
            set { _decimalegrationlevel = value; }
            get { return _decimalegrationlevel; }
        }
        /// <summary>
        /// MTF校正
        /// </summary>
        public string MTFCORRECTION
        {
            set { _mtfcorrection = value; }
            get { return _mtfcorrection; }
        }
        /// <summary>
        /// 相对校正
        /// </summary>
        public string RELATIVECORRECTIONDATA
        {
            set { _relativecorrectiondata = value; }
            get { return _relativecorrectiondata; }
        }
        /// <summary>
        /// 太阳高度角:1:0
        /// </summary>
        public decimal SOLAR_ZENITH_ANGLE
        {
            set { _solar_zenith_angle = value; }
            get { return _solar_zenith_angle; }
        }
        /// <summary>
        /// 太阳方位角:1:0
        /// </summary>
        public decimal SUN_AZIMUTH_ANGLE
        {
            set { _sun_azimuth_angle = value; }
            get { return _sun_azimuth_angle; }
        }
        /// <summary>
        /// 增益模式:1:0
        /// </summary>
        public decimal GAIN_MODE
        {
            set { _gain_mode = value; }
            get { return _gain_mode; }
        }
        /// <summary>
        /// 重采样方法代码:1:55
        /// </summary>
        public string RESAMPLE_METHOD
        {
            set { _resample_method = value; }
            get { return _resample_method; }
        }
        /// <summary>
        /// 中心点经度:1:0
        /// </summary>
        public decimal CENTER_POINT_LON
        {
            set { _center_podecimal_lon = value; }
            get { return _center_podecimal_lon; }
        }
        /// <summary>
        /// 中心点纬度:1:0
        /// </summary>
        public decimal CENTER_POINT_LAT
        {
            set { _center_podecimal_lat = value; }
            get { return _center_podecimal_lat; }
        }
        /// <summary>
        /// 中心点高程:1:0
        /// </summary>
        public decimal CENTER_POINT_ELE
        {
            set { _center_podecimal_ele = value; }
            get { return _center_podecimal_ele; }
        }
        /// <summary>
        /// 左上经度:1:0
        /// </summary>
        public decimal TL_LON
        {
            set { _tl_lon = value; }
            get { return _tl_lon; }
        }
        /// <summary>
        /// 左上纬度:1:0
        /// </summary>
        public decimal TL_LAT
        {
            set { _tl_lat = value; }
            get { return _tl_lat; }
        }
        /// <summary>
        /// 右上经度:1:0
        /// </summary>
        public decimal TR_LON
        {
            set { _tr_lon = value; }
            get { return _tr_lon; }
        }
        /// <summary>
        /// 右上纬度:1:0
        /// </summary>
        public decimal TR_LAT
        {
            set { _tr_lat = value; }
            get { return _tr_lat; }
        }
        /// <summary>
        /// 右下经度:1:0
        /// </summary>
        public decimal BR_LON
        {
            set { _br_lon = value; }
            get { return _br_lon; }
        }
        /// <summary>
        /// 右下纬度:1:0
        /// </summary>
        public decimal BR_LAT
        {
            set { _br_lat = value; }
            get { return _br_lat; }
        }
        /// <summary>
        /// 左下经度:1:0
        /// </summary>
        public decimal BL_LON
        {
            set { _bl_lon = value; }
            get { return _bl_lon; }
        }
        /// <summary>
        /// 左下纬度:1:0
        /// </summary>
        public decimal BL_LAT
        {
            set { _bl_lat = value; }
            get { return _bl_lat; }
        }
        /// <summary>
        /// 左上x坐标:1:0
        /// </summary>
        public decimal TL_X
        {
            set { _tl_x = value; }
            get { return _tl_x; }
        }
        /// <summary>
        /// 左上x坐标:1:0
        /// </summary>
        public decimal TL_Y
        {
            set { _tl_y = value; }
            get { return _tl_y; }
        }
        /// <summary>
        /// 右上x坐标:1:0
        /// </summary>
        public decimal TR_X
        {
            set { _tr_x = value; }
            get { return _tr_x; }
        }
        /// <summary>
        /// 右上y坐标:1:0
        /// </summary>
        public decimal TR_Y
        {
            set { _tr_y = value; }
            get { return _tr_y; }
        }
        /// <summary>
        /// 右下x坐标:1:0
        /// </summary>
        public decimal BR_X
        {
            set { _br_x = value; }
            get { return _br_x; }
        }
        /// <summary>
        /// 右下y坐标:1:0
        /// </summary>
        public decimal BR_Y
        {
            set { _br_y = value; }
            get { return _br_y; }
        }
        /// <summary>
        /// 左下x坐标:1:0
        /// </summary>
        public decimal BL_X
        {
            set { _bl_x = value; }
            get { return _bl_x; }
        }
        /// <summary>
        /// 左下y坐标:1:0
        /// </summary>
        public decimal BL_Y
        {
            set { _bl_y = value; }
            get { return _bl_y; }
        }
        /// <summary>
        /// 产品名称:1:0
        /// </summary>
        public string PRODUCT_NAME
        {
            set { _product_name = value; }
            get { return _product_name; }
        }
        /// <summary>
        /// 产品序列号:1:0
        /// </summary>
        public string PRODUCT_SN
        {
            set { _product_sn = value; }
            get { return _product_sn; }
        }
        /// <summary>
        /// 产品分类代码:1:0
        /// </summary>
        public string PRODUCT_CATEGORY_CODE
        {
            set { _product_category_code = value; }
            get { return _product_category_code; }
        }
        /// <summary>
        /// 产品所有权单位:1:0
        /// </summary>
        public string PRODUCT_OWNERSHIP_UNIT
        {
            set { _product_ownership_unit = value; }
            get { return _product_ownership_unit; }
        }
        /// <summary>
        /// 产品生产单位:1:0
        /// </summary>
        public string PRODUCT_PRODUCTION_UNIT
        {
            set { _product_production_unit = value; }
            get { return _product_production_unit; }
        }
        /// <summary>
        /// 产品等级代码:1:33
        /// </summary>
        public string PRODUCT_CLASS_GRADE_CODE
        {
            set { _product_class_grade_code = value; }
            get { return _product_class_grade_code; }
        }
        /// <summary>
        /// 产品质检等级代码:1:34
        /// </summary>
        public string PRODUCT_QUALITY_GRADE_CODE
        {
            set { _product_quality_grade_code = value; }
            get { return _product_quality_grade_code; }
        }
        /// <summary>
        /// 产品保密等级代码:1:35
        /// </summary>
        public string PRODUCT_SECURITYLEVEL_CODE
        {
            set { _product_securitylevel_code = value; }
            get { return _product_securitylevel_code; }
        }
        /// <summary>
        /// 产品格式代码:1:5
        /// </summary>
        public string PRODUCT_FORMAT_CODE
        {
            set { _product_format_code = value; }
            get { return _product_format_code; }
        }
        /// <summary>
        /// 产品接收日期:1:0
        /// </summary>
        public DateTime PRODUCT_COLLECT_DATE
        {
            set { _product_collect_date = value; }
            get { return _product_collect_date; }
        }
        /// <summary>
        /// 产品加工处理日期:1:0
        /// </summary>
        public DateTime PRODUCT_CURE_DATE
        {
            set { _product_cure_date = value; }
            get { return _product_cure_date; }
        }
        /// <summary>
        /// 产品归档日期:1:0
        /// </summary>
        public DateTime PRODUCT_ARCHIVE_DATE
        {
            set { _product_archive_date = value; }
            get { return _product_archive_date; }
        }
        /// <summary>
        /// 产品大小:1:0
        /// </summary>
        public decimal PRODUCT_SIZE
        {
            set { _product_size = value; }
            get { return _product_size; }
        }
        /// <summary>
        /// 产品质量报告:1:0
        /// </summary>
        public string PRODUCT_QUALITY_REPORT
        {
            set { _product_quality_report = value; }
            get { return _product_quality_report; }
        }
        /// <summary>
        /// 产品任务单编号:1:0
        /// </summary>
        public string PRODUCT_ORDER_NUMBER
        {
            set { _product_order_number = value; }
            get { return _product_order_number; }
        }
        /// <summary>
        /// 产品行政区代码:1:62
        /// </summary>
        public string PRODUCT_AR_CODE
        {
            set { _product_ar_code = value; }
            get { return _product_ar_code; }
        }
        /// <summary>
        /// 产品存储位置:1:0
        /// </summary>
        public string PRODUCT_STORAGE_PATH
        {
            set { _product_storage_path = value; }
            get { return _product_storage_path; }
        }
        /// <summary>
        /// 产品快视图:1:0
        /// </summary>
        public byte[] PRODUCT_QUICKVIEW
        {
            set { _product_quickview = value; }
            get { return _product_quickview; }
        }
        /// <summary>
        /// 产品拇指图:1:0
        /// </summary>
        public byte[] PRODUCT_THUMB
        {
            set { _product_thumb = value; }
            get { return _product_thumb; }
        }
        /// <summary>
        /// 记录创建人:1:0
        /// </summary>
        public string CREATE_USERID
        {
            set { _create_userid = value; }
            get { return _create_userid; }
        }
        /// <summary>
        /// 记录创建时间:1:0
        /// </summary>
        public DateTime CREATE_DATE
        {
            set { _create_date = value; }
            get { return _create_date; }
        }
        /// <summary>
        /// 使用次数:1:0
        /// </summary>
        public decimal USED_COUNT
        {
            set { _used_count = value; }
            get { return _used_count; }
        }
        /// <summary>
        /// 记录状态:1:0
        /// </summary>
        public string STATUS
        {
            set { _status = value; }
            get { return _status; }
        }
        /// <summary>
        /// 备注:1:0
        /// </summary>
        public string REMARKS
        {
            set { _remarks = value; }
            get { return _remarks; }
        }
        /// <summary>
        /// 数据范围:1:0
        /// </summary>
        public string ENVELOPE
        {
            set { _envelope = value; }
            get { return _envelope; }
        }
        /// <summary>
        /// 采集时间:1:0
        /// </summary>
        public DateTime COLLECT_DATE
        {
            set { _collect_date = value; }
            get { return _collect_date; }
        }
        /// <summary>
        /// 采集开始时间:1:0
        /// </summary>
        public DateTime COLLECT_DATE_BEGIN
        {
            set { _collect_date_begin = value; }
            get { return _collect_date_begin; }
        }
        /// <summary>
        /// 采集结束时间:1:0
        /// </summary>
        public DateTime COLLECT_DATE_END
        {
            set { _collect_date_end = value; }
            get { return _collect_date_end; }
        }
        /// <summary>
        /// 产品大小单位:1:39
        /// </summary>
        public string PRODUCT_SIZE_MEASURE
        {
            set { _product_size_measure = value; }
            get { return _product_size_measure; }
        }
        /// <summary>
        /// 是否压缩:1:0
        /// </summary>
        public string IS_COMPRESSED
        {
            set { _is_compressed = value; }
            get { return _is_compressed; }
        }
        /// <summary>
        /// 产品文件列表:1:0
        /// </summary>
        public string PRODUCT_FILES_LIST
        {
            set { _product_files_list = value; }
            get { return _product_files_list; }
        }
        /// <summary>
        /// 产品描述:1:0
        /// </summary>
        public string PRODUCT_USE
        {
            set { _product_use = value; }
            get { return _product_use; }
        }

        #endregion Model

        public RawImageMetaDataInfo()
        { }
    }
}

 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

做完了RawImageMetaDataInfo实体类的封装之后，我们就要利用odp底层进行对tm_raw_image_metadata_infos表

的操作封装了，在我的笔记学习(三)里面会讲述

对tm_raw_image_metadata_infos表的单项查询,单项的添加，删除，修改以及批量的添加，删除，修改...

详情请点击以下链接地址：

 c#中odp.net 4.0利用odac操作oracle数据库学习(三)