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; } }