private string ProcessFirstField(UPCRMLink link)
{
var sourceValue = this.offlineStationNumber > 0 &&
link.RecordId.StartsWith("new") &&
link.RecordId.Length == 15
? this.offlineStationNumber.ToString()
: link?.RecordId.StatNoFromRecordIdString();
return(sourceValue);
}
private string ProcessDefaultField(
UPCRMLink link,
int index,
ref bool sourceResultInitialized,
ref List <string> sourceResult)
{
if (!sourceResultInitialized)
{
sourceResult = this.SourceFieldResultRowForLink(link);
sourceResultInitialized = true;
}
var sourceValue = sourceResult != null && sourceResult.Count > index
? sourceResult[index]
: string.Empty;
return(sourceValue);
}
private string ProcessSecondField(UPCRMLink link)
{
string sourceValue;
if (this.offlineStationNumber > 0 && link.RecordId.StartsWith("new") &&
link.RecordId.Length == 15)
{
var highPart = Convert.ToInt64(link.RecordId.Substring(3, 8), 16) << 16;
var lowPart = Convert.ToInt64(link.RecordId.Substring(11, 4), 16);
var valueNumber = highPart + lowPart;
sourceValue = valueNumber.ToString();
}
else
{
sourceValue = link.RecordId.RecordNoFromRecordIdString();
}
return(sourceValue);
}
private UPCRMFieldInfo CreateFieldInfo(
UPCRMLinkInfoField linkInfoField,
UPCRMLink link,
ref bool linkInitialized,
ref int firstField,
ref int secondField)
{
var fieldInfo = this.tableInfo.FieldInfoForFieldId(linkInfoField.FieldId);
if (!linkInitialized)
{
var targetTableInfo = this.dataStore.TableInfoForInfoArea(link.InfoAreaId);
var targetIdentLink = targetTableInfo.IdentLink;
firstField = targetIdentLink?.FirstField.TargetFieldId ?? -1;
secondField = targetIdentLink?.SecondField.TargetFieldId ?? -1;
linkInitialized = true;
}
return(fieldInfo);
}
/// <summary>
/// Sources the field result row for link.
/// </summary>
/// <param name="link">The link.</param>
/// <returns></returns>
List <string> SourceFieldResultRowForLink(UPCRMLink link)
{
UPCRMTableInfo sourceTableInfo = this.dataStore.TableInfoForInfoArea(link.InfoAreaId);
UPCRMLinkInfo linkInfo = this.tableInfo.LinkInfoForTargetInfoAreaIdLinkId(link.InfoAreaId, link.LinkId);
bool noFields = true;
if (sourceTableInfo == null || linkInfo?.LinkFieldArray == null)
{
return(null);
}
List <UPCRMFieldSetterField> fieldMap = new List <UPCRMFieldSetterField>(linkInfo.LinkFieldArray.Count);
foreach (UPCRMLinkInfoField field in linkInfo.LinkFieldArray)
{
UPCRMFieldInfo fieldInfo = sourceTableInfo.FieldInfoForFieldId(field.TargetFieldId);
if (fieldInfo != null)
{
fieldMap.Add(new UPCRMFieldSetterSourceField(field.TargetFieldId));
noFields = false;
}
else
{
UPCRMFieldSetterSourceLink sourceLink = null;
List <UPCRMLinkInfo> allLinks = sourceTableInfo.LinksWithField();
foreach (UPCRMLinkInfo currentLinkInfo in allLinks)
{
foreach (UPCRMLinkInfoField linkInfoField in currentLinkInfo.LinkFieldArray)
{
if (linkInfoField.FieldId == field.TargetFieldId)
{
UPCRMTableInfo parentTableInfo = this.dataStore.TableInfoForInfoArea(currentLinkInfo.TargetInfoAreaId);
UPCRMLinkInfo parentIdentLink = parentTableInfo.IdentLink;
if (parentIdentLink != null)
{
if (parentIdentLink.FirstField.TargetFieldId == linkInfoField.TargetFieldId)
{
sourceLink = new UPCRMFieldSetterSourceLink(currentLinkInfo.TargetInfoAreaId, currentLinkInfo.LinkId, 0);
break;
}
if (parentIdentLink.SecondField.TargetFieldId == linkInfoField.TargetFieldId)
{
sourceLink = new UPCRMFieldSetterSourceLink(currentLinkInfo.TargetInfoAreaId, currentLinkInfo.LinkId, 1);
break;
}
}
}
}
if (sourceLink != null)
{
break;
}
}
if (sourceLink != null)
{
fieldMap.Add(sourceLink);
noFields = false;
}
else
{
fieldMap.Add(new UPCRMFieldSetterField());
}
}
}
if (noFields)
{
return(null);
}
List <UPCRMField> queryFields = new List <UPCRMField>();
int resultPosition = 0;
foreach (UPCRMFieldSetterField fieldSetterField in fieldMap)
{
if (fieldSetterField.IsField)
{
queryFields.Add(fieldSetterField.FieldWithInfoAreaId(link.InfoAreaId));
fieldSetterField.ResultPosition = resultPosition++;
}
}
foreach (UPCRMFieldSetterField fieldSetterField in fieldMap)
{
if (fieldSetterField.IsLink)
{
queryFields.Add(fieldSetterField.FieldWithInfoAreaId(link.InfoAreaId));
fieldSetterField.ResultPosition = resultPosition++;
}
}
UPContainerMetaInfo crmQuery = new UPContainerMetaInfo(queryFields, linkInfo.TargetInfoAreaId);
UPCRMResult result = crmQuery.ReadRecord(link.RecordIdentification);
if (result != null && result.RowCount == 1)
{
UPCRMResultRow row = (UPCRMResultRow)result.ResultRowAtIndex(0);
List <string> resultArray = new List <string>(fieldMap.Count);
foreach (UPCRMFieldSetterField field in fieldMap)
{
if (field.IsField)
{
resultArray.Add(row.RawValueAtIndex(field.ResultPosition));
}
else if (field.IsLink)
{
string recordId = row.RawValueAtIndex(field.ResultPosition);
if (string.IsNullOrEmpty(recordId))
{
resultArray.Add(string.Empty);
}
else if (recordId.StartsWith("new") && recordId.Length == 15)
{
long offlineLnr = (Convert.ToInt64(recordId.Substring(3, 8), 16) << 16) + Convert.ToInt64(recordId.Substring(11, 4), 16);
if (this.offlineStationNumber > 0 && offlineLnr > 0)
{
if (((UPCRMFieldSetterSourceLink)field).FieldIndex == 0)
{
resultArray.Add(this.offlineStationNumber.ToString());
}
else
{
resultArray.Add(offlineLnr.ToString());
}
}
}
else if (((UPCRMFieldSetterSourceLink)field).FieldIndex == 0)
{
resultArray.Add(recordId.StatNoFromRecordIdString());
}
else
{
resultArray.Add(recordId.RecordNoFromRecordIdString());
}
}
else
{
resultArray.Add(string.Empty);
}
}
return(resultArray);
}
return(null);
}