数据更新

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(PMS_WELL model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update PMS_WELL set ");
            strSql.Append("W_NAME=:W_NAME,");
            strSql.Append("W_LOCAL_NAME=:W_LOCAL_NAME,");
            strSql.Append("W_LOCAL_CODE=:W_LOCAL_CODE,");
            strSql.Append("W_SITE_TAG=:W_SITE_TAG,");
            strSql.Append("W_AREA_ID=:W_AREA_ID,");
            strSql.Append("W_ROAD_NAME=:W_ROAD_NAME,");
            strSql.Append("W_STATION_ID=:W_STATION_ID,");
            strSql.Append("W_HOUSE_NUMBER=:W_HOUSE_NUMBER,");
            strSql.Append("W_ROAD_MARGINS=:W_ROAD_MARGINS,");
            strSql.Append("W_ADDRESS=:W_ADDRESS,");
            strSql.Append("W_CATEGORIES_ID=:W_CATEGORIES_ID,");
            strSql.Append("W_TYPE_ID=:W_TYPE_ID,");
            strSql.Append("W_SHAPE_ID=:W_SHAPE_ID,");
            strSql.Append("W_MODEL_ID=:W_MODEL_ID,");
            strSql.Append("W_POSITION_ANGLE=:W_POSITION_ANGLE,");
            strSql.Append("W_COVER_NUMBER=:W_COVER_NUMBER,");
            strSql.Append("W_COVER_SIZE_ID=:W_COVER_SIZE_ID,");
            strSql.Append("W_COVER_MATERIAL_ID=:W_COVER_MATERIAL_ID,");
            strSql.Append("W_COVER_HEIGHT=:W_COVER_HEIGHT,");
            strSql.Append("W_COVER_SHAPE_ID=:W_COVER_SHAPE_ID,");
            strSql.Append("W_COVER_PASSWORD=:W_COVER_PASSWORD,");
            strSql.Append("W_COVER_THICKNESS=:W_COVER_THICKNESS,");
            strSql.Append("W_COVER_LOCKED=:W_COVER_LOCKED,");
            strSql.Append("W_BOUNDARY=:W_BOUNDARY,");
            strSql.Append("W_VIRTUAL_FACILITY=:W_VIRTUAL_FACILITY,");
            strSql.Append("W_PUT_OUT=:W_PUT_OUT,");
            strSql.Append("W_ELEVATION=:W_ELEVATION,");
            strSql.Append("W_BOTTOM_WIDTH=:W_BOTTOM_WIDTH,");
            strSql.Append("W_HEIGHT=:W_HEIGHT,");
            strSql.Append("W_BOTTOM_LENGTH=:W_BOTTOM_LENGTH,");
            strSql.Append("W_STATE_ID=:W_STATE_ID,");
            strSql.Append("W_BOTTOM_DEEP=:W_BOTTOM_DEEP,");
            strSql.Append("W_AEGIS_MODE_ID=:W_AEGIS_MODE_ID,");
            strSql.Append("W_ASSET_CODE=:W_ASSET_CODE,");
            strSql.Append("W_AGENT_COMPANY_ID=:W_AGENT_COMPANY_ID,");
            strSql.Append("W_EQUITY_NATURE_ID=:W_EQUITY_NATURE_ID,");
            strSql.Append("W_RESOURCES_OWNER_ID=:W_RESOURCES_OWNER_ID,");
            strSql.Append("W_COMPANY=:W_COMPANY,");
            strSql.Append("W_CHECK_LEADER=:W_CHECK_LEADER,");
            strSql.Append("W_COMPLETION_DATE=:W_COMPLETION_DATE,");
            strSql.Append("W_GATHERING_DATE=:W_GATHERING_DATE,");
            strSql.Append("W_GATHERING_PERSON=:W_GATHERING_PERSON,");
            strSql.Append("W_GATHERING_COMPANY=:W_GATHERING_COMPANY,");
            strSql.Append("W_ORIGINAL_PROJECT_ID=:W_ORIGINAL_PROJECT_ID,");
            strSql.Append("W_ORIGINAL_PROJECT_NAME=:W_ORIGINAL_PROJECT_NAME,");
            strSql.Append("W_PROJECT_ID=:W_PROJECT_ID,");
            strSql.Append("W_RESOURCES_PROJECT_NAME=:W_RESOURCES_PROJECT_NAME,");
            strSql.Append("W_BARCODE=:W_BARCODE,");
            strSql.Append("W_LINK_CROSS=:W_LINK_CROSS,");
            strSql.Append("W_CHECK_STATE_ID=:W_CHECK_STATE_ID,");
            strSql.Append("W_NOTES=:W_NOTES,");
            strSql.Append("W_X=:W_X,");
            strSql.Append("W_Y=:W_Y,");
            strSql.Append("W_H=:W_H,");
            strSql.Append("W_PICTURE_STATUS=:W_PICTURE_STATUS,");
            strSql.Append("W_USAGE_ID=:W_USAGE_ID,");
            strSql.Append("BELONG_PIPE_NAME=:BELONG_PIPE_NAME,");
            strSql.Append("DESIGN_COMPANY_ID=:DESIGN_COMPANY_ID,");
            strSql.Append("CONSTRUCTION_ID=:CONSTRUCTION_ID,");
            strSql.Append("NE_ID=:NE_ID,");
            strSql.Append("W_PIPESEGMENT_TYPE=:W_PIPESEGMENT_TYPE,");
            strSql.Append("W_HAVELIGHTCONNBOX=:W_HAVELIGHTCONNBOX,");
            strSql.Append("W_EN_X=:W_EN_X,");
            strSql.Append("W_EN_Y=:W_EN_Y,");
            strSql.Append("W_SOILTYPE_ID=:W_SOILTYPE_ID,");
            strSql.Append("W_BACKFILL_ID=:W_BACKFILL_ID,");
            strSql.Append("W_ROADTYPE_ID=:W_ROADTYPE_ID,");
            strSql.Append("OPRT_C_USER=:OPRT_C_USER,");
            strSql.Append("OPRT_U_USER=:OPRT_U_USER,");
            strSql.Append("OPRT_D_USER=:OPRT_D_USER,");
            strSql.Append("OPRT_TYPE=:OPRT_TYPE,");
            strSql.Append("OPRT_C_TIME=:OPRT_C_TIME,");
            strSql.Append("OPRT_U_TIME=:OPRT_U_TIME,");
            strSql.Append("OPRT_D_TIME=:OPRT_D_TIME,");
            strSql.Append("IS_CS_JS=:IS_CS_JS,");
            strSql.Append("IS_CS_LS=:IS_CS_LS,");
            strSql.Append("IS_DRAWWATER=:IS_DRAWWATER,");
            strSql.Append("DRAWWATER_TYPE=:DRAWWATER_TYPE,");
            strSql.Append("IS_POLINGBOARD=:IS_POLINGBOARD,");
            strSql.Append("GATHERSTATE=:GATHERSTATE,");
            strSql.Append("OPEN_NUM=:OPEN_NUM,");
            strSql.Append("IS_REMOVE=:IS_REMOVE,");
            strSql.Append("GATHERING_DATE=:GATHERING_DATE,");
            strSql.Append("DEL=:DEL,");
            strSql.Append("FANGSHUI_TYPE=:FANGSHUI_TYPE,");
            strSql.Append("FANGSHUI_S=:FANGSHUI_S");
            strSql.Append(" where GUID=:GUID ");
            OracleParameter[] parameters = {
     new OracleParameter(":W_NAME", OracleDbType.Varchar2,256),
     new OracleParameter(":W_LOCAL_NAME", OracleDbType.Varchar2,256),
     new OracleParameter(":W_LOCAL_CODE", OracleDbType.Varchar2,256),
     new OracleParameter(":W_SITE_TAG", OracleDbType.Varchar2,256),
     new OracleParameter(":W_AREA_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_ROAD_NAME", OracleDbType.Varchar2,256),
     new OracleParameter(":W_STATION_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_HOUSE_NUMBER", OracleDbType.Varchar2,1024),
     new OracleParameter(":W_ROAD_MARGINS", OracleDbType.Int32,8),
     new OracleParameter(":W_ADDRESS", OracleDbType.Varchar2,1024),
     new OracleParameter(":W_CATEGORIES_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_TYPE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_SHAPE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_MODEL_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_POSITION_ANGLE", OracleDbType.Int32,6),
     new OracleParameter(":W_COVER_NUMBER", OracleDbType.Int32,3),
     new OracleParameter(":W_COVER_SIZE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_COVER_MATERIAL_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_COVER_HEIGHT", OracleDbType.Int32,3),
     new OracleParameter(":W_COVER_SHAPE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_COVER_PASSWORD", OracleDbType.Varchar2,256),
     new OracleParameter(":W_COVER_THICKNESS", OracleDbType.Int32,3),
     new OracleParameter(":W_COVER_LOCKED", OracleDbType.Int32,1),
     new OracleParameter(":W_BOUNDARY", OracleDbType.Int32,1),
     new OracleParameter(":W_VIRTUAL_FACILITY", OracleDbType.Int32,1),
     new OracleParameter(":W_PUT_OUT", OracleDbType.Int32,1),
     new OracleParameter(":W_ELEVATION", OracleDbType.Int32,6),
     new OracleParameter(":W_BOTTOM_WIDTH", OracleDbType.Int32,6),
     new OracleParameter(":W_HEIGHT", OracleDbType.Int32,6),
     new OracleParameter(":W_BOTTOM_LENGTH", OracleDbType.Int32,6),
     new OracleParameter(":W_STATE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_BOTTOM_DEEP", OracleDbType.Int32,6),
     new OracleParameter(":W_AEGIS_MODE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_ASSET_CODE", OracleDbType.Int32,10),
     new OracleParameter(":W_AGENT_COMPANY_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_EQUITY_NATURE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_RESOURCES_OWNER_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_COMPANY", OracleDbType.Varchar2,1024),
     new OracleParameter(":W_CHECK_LEADER", OracleDbType.Varchar2,256),
     new OracleParameter(":W_COMPLETION_DATE", OracleDbType.Date),
     new OracleParameter(":W_GATHERING_DATE", OracleDbType.Date),
     new OracleParameter(":W_GATHERING_PERSON", OracleDbType.Varchar2,256),
     new OracleParameter(":W_GATHERING_COMPANY", OracleDbType.Varchar2,1024),
     new OracleParameter(":W_ORIGINAL_PROJECT_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_ORIGINAL_PROJECT_NAME", OracleDbType.Varchar2,256),
     new OracleParameter(":W_PROJECT_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_RESOURCES_PROJECT_NAME", OracleDbType.Varchar2,256),
     new OracleParameter(":W_BARCODE", OracleDbType.Varchar2,256),
     new OracleParameter(":W_LINK_CROSS", OracleDbType.Int32,1),
     new OracleParameter(":W_CHECK_STATE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_NOTES", OracleDbType.Varchar2,1024),
     new OracleParameter(":W_X", OracleDbType.Decimal,16),
     new OracleParameter(":W_Y", OracleDbType.Decimal,16),
     new OracleParameter(":W_H", OracleDbType.Decimal,16),
     new OracleParameter(":W_PICTURE_STATUS", OracleDbType.Char,1),
     new OracleParameter(":W_USAGE_ID", OracleDbType.Int32,3),
     new OracleParameter(":BELONG_PIPE_NAME", OracleDbType.Varchar2,1024),
     new OracleParameter(":DESIGN_COMPANY_ID", OracleDbType.Int32,10),
     new OracleParameter(":CONSTRUCTION_ID", OracleDbType.Int32,10),
     new OracleParameter(":NE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_PIPESEGMENT_TYPE", OracleDbType.Int32,10),
     new OracleParameter(":W_HAVELIGHTCONNBOX", OracleDbType.Int32,1),
     new OracleParameter(":W_EN_X", OracleDbType.Decimal,16),
     new OracleParameter(":W_EN_Y", OracleDbType.Decimal,16),
     new OracleParameter(":W_SOILTYPE_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_BACKFILL_ID", OracleDbType.Int32,10),
     new OracleParameter(":W_ROADTYPE_ID", OracleDbType.Int32,10),
     new OracleParameter(":OPRT_C_USER", OracleDbType.Varchar2,64),
     new OracleParameter(":OPRT_U_USER", OracleDbType.Varchar2,64),
     new OracleParameter(":OPRT_D_USER", OracleDbType.Varchar2,64),
     new OracleParameter(":OPRT_TYPE", OracleDbType.Int32,10),
     new OracleParameter(":OPRT_C_TIME", OracleDbType.Date),
     new OracleParameter(":OPRT_U_TIME", OracleDbType.Date),
     new OracleParameter(":OPRT_D_TIME", OracleDbType.Date),
     new OracleParameter(":IS_CS_JS", OracleDbType.Int32,2),
     new OracleParameter(":IS_CS_LS", OracleDbType.Int32,2),
     new OracleParameter(":IS_DRAWWATER", OracleDbType.Int32,1),
     new OracleParameter(":DRAWWATER_TYPE", OracleDbType.Int32,1),
     new OracleParameter(":IS_POLINGBOARD", OracleDbType.Int32,1),
     new OracleParameter(":GATHERSTATE", OracleDbType.Int32,1),
     new OracleParameter(":OPEN_NUM", OracleDbType.Int32,1),
     new OracleParameter(":IS_REMOVE", OracleDbType.Int32,1),
     new OracleParameter(":GATHERING_DATE", OracleDbType.Date),
     new OracleParameter(":DEL", OracleDbType.Int32,1),
              new OracleParameter(":FANGSHUI_TYPE", OracleDbType.Int32,2),
     new OracleParameter(":FANGSHUI_S", OracleDbType.Int32,10),
     new OracleParameter(":GUID", OracleDbType.Varchar2,32)};
            int i = 0;
            parameters[i++].Value = model.W_NAME;
            parameters[i++].Value = model.W_LOCAL_NAME;
            parameters[i++].Value = model.W_LOCAL_CODE;
            parameters[i++].Value = model.W_SITE_TAG;
            parameters[i++].Value = model.W_AREA_ID;
            parameters[i++].Value = model.W_ROAD_NAME;
            parameters[i++].Value = model.W_STATION_ID;
            parameters[i++].Value = model.W_HOUSE_NUMBER;
            parameters[i++].Value = model.W_ROAD_MARGINS;
            parameters[i++].Value = model.W_ADDRESS;
            parameters[i++].Value = model.W_CATEGORIES_ID;
            parameters[i++].Value = model.W_TYPE_ID;
            parameters[i++].Value = model.W_SHAPE_ID;
            parameters[i++].Value = model.W_MODEL_ID;
            parameters[i++].Value = model.W_POSITION_ANGLE;
            parameters[i++].Value = model.W_COVER_NUMBER;
            parameters[i++].Value = model.W_COVER_SIZE_ID;
            parameters[i++].Value = model.W_COVER_MATERIAL_ID;
            parameters[i++].Value = model.W_COVER_HEIGHT;
            parameters[i++].Value = model.W_COVER_SHAPE_ID;
            parameters[i++].Value = model.W_COVER_PASSWORD;
            parameters[i++].Value = model.W_COVER_THICKNESS;
            parameters[i++].Value = model.W_COVER_LOCKED;
            parameters[i++].Value = model.W_BOUNDARY;
            parameters[i++].Value = model.W_VIRTUAL_FACILITY;
            parameters[i++].Value = model.W_PUT_OUT;
            parameters[i++].Value = model.W_ELEVATION;
            parameters[i++].Value = model.W_BOTTOM_WIDTH;
            parameters[i++].Value = model.W_HEIGHT;
            parameters[i++].Value = model.W_BOTTOM_LENGTH;
            parameters[i++].Value = model.W_STATE_ID;
            parameters[i++].Value = model.W_BOTTOM_DEEP;
            parameters[i++].Value = model.W_AEGIS_MODE_ID;
            parameters[i++].Value = model.W_ASSET_CODE;
            parameters[i++].Value = model.W_AGENT_COMPANY_ID;
            parameters[i++].Value = model.W_EQUITY_NATURE_ID;
            parameters[i++].Value = model.W_RESOURCES_OWNER_ID;
            parameters[i++].Value = model.W_COMPANY;
            parameters[i++].Value = model.W_CHECK_LEADER;
            parameters[i++].Value = model.W_COMPLETION_DATE;
            parameters[i++].Value = model.W_GATHERING_DATE;
            parameters[i++].Value = model.W_GATHERING_PERSON;
            parameters[i++].Value = model.W_GATHERING_COMPANY;
            parameters[i++].Value = model.W_ORIGINAL_PROJECT_ID;
            parameters[i++].Value = model.W_ORIGINAL_PROJECT_NAME;
            parameters[i++].Value = model.W_PROJECT_ID;
            parameters[i++].Value = model.W_RESOURCES_PROJECT_NAME;
            parameters[i++].Value = model.W_BARCODE;
            parameters[i++].Value = model.W_LINK_CROSS;
            parameters[i++].Value = model.W_CHECK_STATE_ID;
            parameters[i++].Value = model.W_NOTES;
            parameters[i++].Value = model.W_X;
            parameters[i++].Value = model.W_Y;
            parameters[i++].Value = model.W_H;
            parameters[i++].Value = model.W_PICTURE_STATUS;
            parameters[i++].Value = model.W_USAGE_ID;
            parameters[i++].Value = model.BELONG_PIPE_NAME;
            parameters[i++].Value = model.DESIGN_COMPANY_ID;
            parameters[i++].Value = model.CONSTRUCTION_ID;
            parameters[i++].Value = model.NE_ID;
            parameters[i++].Value = model.W_PIPESEGMENT_TYPE;
            parameters[i++].Value = model.W_HAVELIGHTCONNBOX;
            parameters[i++].Value = model.W_EN_X;
            parameters[i++].Value = model.W_EN_Y;
            parameters[i++].Value = model.W_SOILTYPE_ID;
            parameters[i++].Value = model.W_BACKFILL_ID;
            parameters[i++].Value = model.W_ROADTYPE_ID;
            parameters[i++].Value = model.OPRT_C_USER;
            parameters[i++].Value = model.OPRT_U_USER;
            parameters[i++].Value = model.OPRT_D_USER;
            parameters[i++].Value = model.OPRT_TYPE;
            parameters[i++].Value = model.OPRT_C_TIME;
            parameters[i++].Value = model.OPRT_U_TIME;
            parameters[i++].Value = model.OPRT_D_TIME;
            parameters[i++].Value = model.IS_CS_JS;
            parameters[i++].Value = model.IS_CS_LS;
            parameters[i++].Value = model.IS_DRAWWATER;
            parameters[i++].Value = model.DRAWWATER_TYPE;
            parameters[i++].Value = model.IS_POLINGBOARD;
            parameters[i++].Value = model.GATHERSTATE;
            parameters[i++].Value = model.OPEN_NUM;
            parameters[i++].Value = model.IS_REMOVE;
            parameters[i++].Value = model.GATHERING_DATE;
            parameters[i++].Value = model.DEL;
            parameters[i++].Value = model.FANGSHUI_TYPE;
            parameters[i++].Value = model.FANGSHUI_S;
            parameters[i++].Value = model.GUID;

            int rows = DbHelperDb.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        Oracle数据更新,小警示

数据更新时,sql脚本中的参数, 参数定义, 参数赋值, 先后顺序非常关键, 必须一致, 否则容易出错.