深入FDO----資料維護

FdoPtr<FdoDataValue> sampleDataValue =

FdoDataValue::Create(100.0, FdoDataType_Decimal);

FdoPtr<FdoPropertyValue> sampleDataPropertyValue =

FdoPropertyValue::Create("Area", value);

或

FdoPtr<FdoDataValue> sampleDataValue = FdoDecimalValue::Create(100.0);

FdoPtr<FdoPropertyValue> sampleDataPropertyValue =

FdoPropertyValue::Create("Area", value);

FdoPtr<FdoGeometryValue> sampleGeometryValue = FdoGeometryValue::Create();

// 建立一個用來建立幾何物件的幾何工廠

FdoPtr<FdoFgfGeometryFactory> sampleGeometryFactory =

FdoFgfGeometryFactory::GetInstance();

// 定義多邊形的外部邊界

FdoInt32 numOrdinates = 10;

double ordinates[] =

{52.0, 18.0, 66.0, 23.0, 73.0, 9.0, 48.0, 6.0, 52.0, 18.0};

FdoPtr<FdoILinearRing> exteriorRing =

sampleGeometryFactory->CreateLinearRing(FdoDimensionality_XY,

numOrdinates, ordinates);

// 建立多邊形

FdoPtr<FdoIPolygon> polygon =

sampleGeometryFactory->CreatePolygon(exteriorRing, NULL);

// 將多邊形轉換成位元組陣列，然後設定幾何型別的值

FdoPtr<FdoByteArray> geometryByteArray = sampleGeometryFactory->GetAgf(polygon);

sampleGeometryValue->SetGeometry(geometryByteArray);

// 將FdoGeometryValue型別的新增到幾何屬性中

FdoPtr<FdoPropertyValue> sampleGeometryPropertyValue =

FdoPropertyValue::Create(L"SampleGeometryProperty", sampleGeometryValue);

// 建立插入命令

FdoPtr<FdoIInsert> sampleInsert = (FdoIInsert *)

connection->CreateCommand(FdoCommandType_Insert);

// 插入操作返回的索引值

FdoInt32 valueCollectionIndex = 0;

// 為插入命令指定目標要素類

// 傳入一個完整的要素類名，其格式為“<schemaName>:<className>”

sampleInsert-> SetFeatureClassName(L"SampleFeatureSchema:SampleFeatureClass");

// 得到屬性值集合，新建的屬性將插入到該集合中

FdoPtr<FdoPropertyValueCollection> samplePropertyValues =

sampleInsert->GetPropertyValues();

// 為主鍵屬性建立一個FdoDataValue型別的值

FdoPtr<FdoDataValue> sampleIdentityDataValue = FdoDataValue::Create(101);

// 將FdoDataValue新增到主鍵屬性中

FdoPtr<FdoPropertyValue> sampleIdentityPropertyValue =

FdoPropertyValue::Create(L"SampleIdentityDataProperty", sampleIdentityDataValue);

// 將主鍵屬性值新增到屬性值集合

valueCollectionIndex = samplePropertyValues->Add(sampleIdentityPropertyValue);

// 為屬性“name”建立一個FdoDataValue型別的值

FdoPtr<FdoDataValue> sampleNameDataValue = FdoDataValue::Create(L"Blue Lake");

// 將FdoDataValue型別的值新增到name屬性

FdoPtr<FdoPropertyValue> sampleNamePropertyValue =

FdoPropertyValue::Create(L"SampleNameDataProperty", sampleNameDataValue);

// 將“name”屬性值新增到屬性值集合

valueCollectionIndex = samplePropertyValues->Add(sampleNamePropertyValue);

// 為幾何屬性建立一個FdoGeometryValue型別的值

// 該多邊形描繪了一個帶有一個小島的湖

// 湖的外邊界是用Linear Ring來描述的，湖的外邊界也是多邊形的外邊界

// 島的邊界也是用Linear Ring來描述的，島的外邊界是多邊形的內部邊界

FdoPtr<FdoGeometryValue> sampleGeometryValue = FdoGeometryValue::Create();

// 建立一個用來建立幾何物件的幾何工廠

FdoPtr<FdoFgfGeometryFactory> sampleGeometryFactory =

FdoFgfGeometryFactory::GetInstance();

// 定義多邊形的外部邊界，也就是“Blue Lake”的外邊界

FdoInt32 numBlueLakeShorelineOrdinates = 10;

double blueLakeExteriorRingOrdinates[] =

{52.0, 18.0, 66.0, 23.0, 73.0, 9.0, 48.0, 6.0, 52.0, 18.0};

FdoPtr<FdoILinearRing> exteriorRingBlueLake =

sampleGeometryFactory->CreateLinearRing(FdoDimensionality_XY, umBlueLakeShorelineOrdinates, blueLakeExteriorRingOrdinates);

// 定義“Blue Lake”內部小島“Goose”的邊界

FdoInt32 numGooseIslandShorelineOrdinates = 10;

double gooseIslandLinearRingOrdinates[] =

{59.0, 18.0, 67.0, 18.0, 67.0, 13.0, 59.0, 13.0, 59.0, 18.0};

FdoPtr<FdoILinearRing> linearRingGooseIsland =

sampleGeometryFactory->CreateLinearRing(FdoDimensionality_XY, umGooseIslandShorelineOrdinates, gooseIslandLinearRingOrdinates);

// 將“Goose”島的邊界加入到內部邊界集合中

FdoPtr<FdoLinearRingCollection> interiorRingsBlueLake =

FdoLinearRingCollection::Create();

interiorRingsBlueLake->Add(linearRingGooseIsland);

// 建立“Blue Lake”多邊形

FdoPtr<FdoIPolygon> blueLake =

sampleGeometryFactory->CreatePolygon(exteriorRingBlueLake, interiorRingsBlueLake);

// 將“Blue Lake”多邊形轉換成位元組陣列，然後設定幾何型別的值

FdoPtr<FdoByteArray> geometryByteArray = sampleGeometryFactory->GetAgf(blueLake);

sampleGeometryValue->SetGeometry(geometryByteArray);

// 將FdoGeometryValue型別的“Blue Lake”新增到幾何屬性中

FdoPtr<FdoPropertyValue> sampleGeometryPropertyValue =

FdoPropertyValue::Create(L"SampleGeometryProperty", sampleGeometryValue);

// 將幾何屬性值新增到屬性值集合中

valueCollectionIndex = samplePropertyValues->Add(sampleGeometryPropertyValue);

// 執行插入操作，插入命令返回一個FdoIFeatureReader

FdoPtr<FdoIFeatureReader sampleFeatureReader = sampleInsert->Execute();

// 建立更新命令

FdoPtr<FdoIUpdate> sampleUpdate =

(FdoIUpdate *)connection->CreateCommand(FdoCommandType_Update);

// 為更新命令指定目標要素類

// 傳入一個完整的要素類名，其格式為“<schemaName>:<className>”

sampleUpdate-> SetFeatureClassName(L"SampleFeatureSchema:SampleFeatureClass");

// 設定過濾條件來鎖定目標集合

sampleUpdate->SetFilter(L"( SampleIdentityDataProperty = 101 )");

// 得到屬性集合，用以向更新命令中新增屬性

// 這裡我們將重用插入操作裡用到的samplePropertyValues物件

samplePropertyValues = sampleUpdate->GetPropertyValues();

// 為name屬性建立一個FdoDataValue型別的物件

FdoPtr<FdoDataValue> sampleNameDataValue = FdoDataValue::Create(L"Green Lake");

// 設定屬性名以及對應的值

sampleNamePropertyValue->SetName(L"SampleNameDataProperty");

sampleNamePropertyValue->SetValue(sampleNameDataValue);

// 新增name屬性物件到更新命令的屬性集合中

samplePropertyValues->Add(sampleNamePropertyValue);

// 執行命令，返回值為更新命令所更新的要素總數

FdoInt32 numUpdated = sampleUpdate->Execute();

// 建立刪除命令

FdoPtr<FdoIDelete> sampleDelete =

(FdoIDelete *)connection->CreateCommand(FdoCommandType_Delete);

// 為刪除命令指定目標要素類

// 傳入一個完整的要素類名，其格式為“<schemaName>:<className>”

sampleDelete->SetFeatureClassName(L"SampleFeatureSchema:SampleFeatureClass");

// 設定過濾條件來鎖定目標集合

sampleDelete->SetFilter(L"( SampleIdentityDataProperty = 101 )");

// 執行命令，返回值為刪除命令所刪除的要素總數

FdoInt32 numDeleted = sampleDelete->Execute();

FdoPtr<FdoTransaction> transaction;

FdoPtr<FdoICommand> command;

try {

// 啟動事務

    transaction = connection->BeginTransaction();

    ......

    command->SetTransaction(transaction);

    ......

    transaction->Commit();

}

catch (FdoException* e) {

    e->Release();

    transaction->Rollback();

}