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; }
}
public Boolean WriteValueMapping(int Serial, ValueMappingData theV)
{
OleDbCommand theCMD;
String theSQL = "";
try
{
checkOpen();
theSQL = "INSERT INTO [ValueMappings] ([serialNumber], [srcFieldName], [destFieldName], [srcEnumName], [destEnumName], [sourceValue], [destinationValue]) VALUES (" + Serial + ", '" + theV.srcAtt + "', '" + theV.destAtt + "', '" + theV.srcEnum + "', '" + theV.destEnum + "', '" + theV.srcV + "', '" + theV.destV + "')";
theCMD = new OleDbCommand(theSQL, theConn);
theCMD.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
return false;
}
}
public void AddValueConversion(ValueMappingData theVMap)
{
if (theConversions == null)
{
System.Array.Resize(ref this.theConversions, 1);
this.theConversions[0] = theVMap;
}
else
{
System.Array.Resize(ref this.theConversions, this.theConversions.Length + 1);
this.theConversions[this.theConversions.Length - 1] = theVMap;
}
}
