public static string GetPackedBunch(string strQuoteName)
{
string strPackedBunchId = null;
try
{
string strQuoteID = int.Parse(strQuoteName.Replace("QB", "")).ToString();
CustomRecordSearch objSearch = new CustomRecordSearch();
objSearch.basic = new CustomRecordSearchBasic();
objSearch.basic.recType = new RecordRef();
objSearch.basic.recType.internalId = "524";
objSearch.basic.isInactive = new SearchBooleanField();
objSearch.basic.isInactive.searchValue = false;
objSearch.basic.isInactive.searchValueSpecified = true;
SearchMultiSelectCustomField objQuoteId = new SearchMultiSelectCustomField();
objQuoteId.internalId = "custrecord_vf_qd_quote";
objQuoteId.@operator = SearchMultiSelectFieldOperator.anyOf;
objQuoteId.operatorSpecified = true;
objQuoteId.searchValue = new ListOrRecordRef[1];
objQuoteId.searchValue[0] = new ListOrRecordRef();
objQuoteId.searchValue[0].internalId = strQuoteID;
/*SearchStringCustomField objBatchName = new SearchStringCustomField();
objBatchName.internalId = "custrecordfb_batchname";
objBatchName.@operator = SearchStringFieldOperator.@is;
objBatchName.operatorSpecified = true;
objBatchName.searchValue = "CM1309MP007";*/
objSearch.basic.customFieldList = new SearchCustomField[] { objQuoteId };
CustomRecordSearchAdvanced objSearchAdv = new CustomRecordSearchAdvanced();
objSearchAdv.savedSearchScriptId = "customsearch_spm_quotedetail_export";
objSearchAdv.criteria = objSearch;
SearchResult objSearchResult = _service.search(objSearch);
if (objSearchResult.recordList != null && objSearchResult.recordList.Length > 0)
{
for (int j = 0; j < objSearchResult.recordList.Length; j++)
{
if (objSearchResult.recordList[j] is CustomRecord)
{
CustomRecord objRecord = (CustomRecord)objSearchResult.recordList[j];
strPackedBunchId = GetValue("custrecord_vf_qd_packedbunch", objRecord.customFieldList).ToString();
strPackedBunchId = "PB" + strPackedBunchId.PadLeft(8, '0');
}
}
}
}
catch (Exception)
{
}
return strPackedBunchId;
}
public static string GetOrderId(string strPONumber, string strReseller)
{
string strOrderId = "";
try
{
TransactionSearch xactionSearch = new TransactionSearch();
SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField();
searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
searchSalesOrderField.operatorSpecified = true;
System.String[] soStringArray = new System.String[1];
soStringArray[0] = "_salesOrder";
searchSalesOrderField.searchValue = soStringArray;
TransactionSearchBasic xactionBasic = new TransactionSearchBasic();
xactionBasic.type = searchSalesOrderField;
xactionBasic.otherRefNum = new SearchTextNumberField();
xactionBasic.otherRefNum.@operator = SearchTextNumberFieldOperator.equalTo;
xactionBasic.otherRefNum.operatorSpecified = true;
xactionBasic.otherRefNum.searchValue = strPONumber;
SearchMultiSelectCustomField objReseller = new SearchMultiSelectCustomField();
objReseller.internalId = "custbodytbfcustomerid";
objReseller.@operator = SearchMultiSelectFieldOperator.anyOf;
objReseller.operatorSpecified = true;
objReseller.searchValue = new ListOrRecordRef[1];
objReseller.searchValue[0] = new ListOrRecordRef();
objReseller.searchValue[0].internalId = strReseller;
xactionBasic.customFieldList = new SearchCustomField[] { objReseller };
xactionSearch.basic = xactionBasic;
SearchResult objSearchResult = _service.search(xactionSearch);
if (objSearchResult.recordList != null)
{
Record[] recordList;
for (int i = 1; i <= objSearchResult.totalPages; i++)
{
recordList = objSearchResult.recordList;
for (int j = 0; j < recordList.Length; j++)
{
if (recordList[j] is SalesOrder)
{
SalesOrder so = (SalesOrder)(recordList[j]);
strOrderId = so.internalId;
}
}
}
}
}
catch (Exception)
{
}
return strOrderId;
}
