NetSuite 使用 Web 服务在 C# 中的 SelectCustomFieldRef 的自定义列表中选择一个值

经过多次尝试和磨难，我们提出了一个有效的解决方案。 很多方法已经提取到其他函数中，但我会尝试在这里为你提供它的基本框架。

该代码的重点是尝试尽可能少地调用NetSuite。 这假设您将在多个事务中重用大部分数据。

    // NetSuite Session
    // _service is constructed elsewhere in code.
    // Global Values
    Dictionary<string, CustomizationRef> _Dictionary_CustomListRef = new Dictionary<string, CustomizationRef>();
    Dictionary<string, CustomList> _Dictionary_CustomList = new Dictionary<string, CustomList>();
    Dictionary<string, TransactionBodyCustomField> _Dictionary_TransactionBodyCustomField = new Dictionary<string, TransactionBodyCustomField>();
    private CustomFieldRef NetSuite_CreateSelectCustomFieldRef(string sName, string sValue)
    {
        //List or Record Type reference
        SelectCustomFieldRef custbody_field = new SelectCustomFieldRef();
        custbody_field.internalId = sName;
        custbody_field.value = new ListOrRecordRef();
        // Get the Targeted List that we point to in NetSuite
        custbody_field.value.typeId = NetSuite_getTransactionBodyCustomFieldListInternalId(sName);
        // Get ID of List Value from our targeted list in NetSuite
        custbody_field.value.internalId = NetSuite_getCustomListValueID(custbody_field.value.typeId, sValue);
        return custbody_field;
    }
    private string NetSuite_getTransactionBodyCustomFieldListInternalId(string sID)
    {
        string sReturnValue = string.Empty;
        TransactionBodyCustomField tbCustomField = NetSuite_getTransactionBodyCustomField(sID);
        if (tbCustomField != null)
        {
            sReturnValue = tbCustomField.selectRecordType.internalId;
        }
        return sReturnValue;
    }
    private TransactionBodyCustomField NetSuite_getTransactionBodyCustomField(string sID)
    {
        TransactionBodyCustomField tbCustomField = null;
        if (!_Dictionary_TransactionBodyCustomField.TryGetValue(sID, out tbCustomField))
        {
            // Gets a specific custom body object
            CustomizationRef cref = new CustomizationRef();
            cref.internalId = sID;
            cref.scriptId = sID;
            cref.type = RecordType.transactionBodyCustomField;
            cref.typeSpecified = true;
            ReadResponse res = _service.get(cref);
            if (res.status.isSuccess)
                tbCustomField = res.record as TransactionBodyCustomField;
            _Dictionary_TransactionBodyCustomField.Add(sID, tbCustomField);
        }
        return tbCustomField;
    }
    private bool NetSuite_TryGetCustomList(string sCustomListInternalID, out CustomList custList)
    {
        custList = null;
        bool bSuccess = false;
        if (!_Dictionary_CustomList.TryGetValue(sCustomListInternalID, out custList))
        {
            if (_Dictionary_CustomListRef.Count == 0)
                initializeCustomListDictionary();
            CustomizationRef crCustomList = null;
            if (_Dictionary_CustomListRef.TryGetValue(sCustomListInternalID, out crCustomList))
            {
                RecordRef recRef = new RecordRef();
                recRef.internalId = crCustomList.internalId;
                recRef.type = RecordType.customList;
                recRef.typeSpecified = true;
                ReadResponse readResp = _service.get(recRef);
                if (readResp.status.isSuccess)
                    custList = readResp.record as CustomList;
                _Dictionary_CustomList.Add(sCustomListInternalID, custList);
            }
        }
        if (custList == null)
            bSuccess = false;
        else
            bSuccess = true;
        return bSuccess;
    }
    private string NetSuite_getCustomListScriptID(string sCustomListInternalID)
    {
        string sReturnValue = string.Empty;
        CustomList custList;
        if (NetSuite_TryGetCustomList(sCustomListInternalID, out custList))
            sReturnValue = custList.scriptId;
        return sReturnValue;
    }
    private string NetSuite_getCustomListValueID(string sCustomListInternalID, string sValue)
    {
        string sReturnValue = string.Empty;
        CustomList custList;
        if (NetSuite_TryGetCustomList(sCustomListInternalID, out custList))
        {
            CustomListCustomValue[] clValueList = custList.customValueList.customValue;
            foreach(CustomListCustomValue clValue in custList.customValueList.customValue)
            {
                if (clValue.value.ToUpper() == sValue.ToUpper())
                {
                    sReturnValue = clValue.valueId.ToString();
                    break;
                }
            }
        }
        return sReturnValue;
    }
    private void initializeCustomListDictionary()
    {
        _Dictionary_CustomListRef.Clear();
        // Gets all of the custom lists
        CustomizationType ct = new CustomizationType();
        ct.getCustomizationType = GetCustomizationType.customList;
        ct.getCustomizationTypeSpecified = true;
        GetCustomizationIdResult res = _service.getCustomizationId(ct, true);
        foreach (CustomizationRef cref in res.customizationRefList)
            _Dictionary_CustomListRef.Add(cref.internalId, cref);
    }

我希望这个代码片段对您有所帮助，并祝您好运。

~编辑~

此外，当以另一种方式返回（提取值）时，这里是如何将 ID 转换回所选值文本的方法。 customField 对象是从事务的"选项"字段（它是 CustomFieldRefs 的数组）获得的 CustomFieldRef。

    SelectCustomFieldRef selectCustFieldRef = customField as SelectCustomFieldRef;
    sCustFieldRefId = selectCustFieldRef.internalId;
    sCustFieldRefValue = NetSuite_getCustomListValueFromID(selectCustFieldRef.value.typeId, long.Parse(selectCustFieldRef.value.internalId));
    private string NetSuite_getCustomListValueFromID(string sCustomListInternalID, long lValue)
    {
        string sReturnValue = string.Empty;
        CustomList custList;
        if (NetSuite_TryGetCustomList(sCustomListInternalID, out custList))
        {
            CustomListCustomValue[] clValueList = custList.customValueList.customValue;
            foreach (CustomListCustomValue clValue in custList.customValueList.customValue)
            {
                if (clValue.valueId == lValue)
                {
                    sReturnValue = clValue.value;
                    break;
                }
            }
        }
        return sReturnValue;
    }

可以使用 getCustomizationId 按指定的自定义类型返回自定义项的元数据。

在自定义项

数组中，您可以找到所需的特定自定义项以及与之关联的所有元数据，包括自定义列表。您应该找到所需的所有信息。

通过在自定义列表中执行 get，可以检索所有值和 ID。