public Boolean LoadValueMappings(AttributeMappingData theAMap)
{
OleDbCommand theCMD;
OleDbDataReader theReader;
ValueData theS, theD;
String theSQL = "";
int vCount;
String srcV, destV;
ValueMappingData theMap;
try
{
theSQL = "SELECT [sourceValue], [destinationValue], [valueCount] FROM [ValueMappings] WHERE [serialNumber] = " + theAMap.serialNumber + " AND [srcFieldName] = '" + theAMap.srcAtt + "' AND [destFieldName] = '" + theAMap.destAtt + "'";
theCMD = new OleDbCommand(theSQL, theConn);
checkOpen();
theReader = theCMD.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (theReader.Read())
{
srcV = theReader.GetString(0);
destV = theReader.GetString(1);
vCount = 0;
theS = new ValueData(theAMap.srcFC, srcV, theAMap.srcEnum);
theD = new ValueData(theAMap.destFC, destV, theAMap.destEnum);
theMap = new ValueMappingData(theAMap, theS, theD);
theAMap.AddValueConversion(theMap);
}
return true;
}
catch (Exception ex) { return false; }
}
internal ValueMappingData(AttributeMappingData aMap, ValueData sourceV, ValueData destV)
{
this.serialNumber = aMap.serialNumber;
this.srcFC = aMap.srcFC;
this.destFC = aMap.destFC;
this.srcAtt = aMap.srcAtt;
this.srcEnum = aMap.srcEnum;
this.destEnum = aMap.destEnum;
this.destAtt = aMap.destAtt;
this.srcV = sourceV.value;
this.destV = destV.value;
}
