public static ArrayList GetItemId(string strProductId)
{
ArrayList arrItem = new ArrayList();
try
{
strProductId = strProductId.Trim();
ItemSearchBasic objItemSearchBasic = new ItemSearchBasic();
objItemSearchBasic.vendorName = new SearchStringField();
if (strProductId.StartsWith("QB0"))
{
strProductId = GetPackedBunch(strProductId);
objItemSearchBasic.vendorName.@operator = SearchStringFieldOperator.@is;
if (string.IsNullOrEmpty(strProductId))
{
return arrItem;
}
}
else
{
objItemSearchBasic.vendorName.@operator = SearchStringFieldOperator.startsWith;
}
objItemSearchBasic.vendorName.searchValue = strProductId;// "CST34434A_B";
objItemSearchBasic.vendorName.operatorSpecified = true;
objItemSearchBasic.isInactive = new SearchBooleanField();
objItemSearchBasic.isInactive.searchValue = false;
objItemSearchBasic.isInactive.searchValueSpecified = true;
ItemSearch objItemSearch = new ItemSearch();
objItemSearch.basic = objItemSearchBasic;
SearchResult objSearchResult = _service.search(objItemSearch);
if (objSearchResult.recordList != null && objSearchResult.recordList.Length > 0)
{
for (int i = 0; i < objSearchResult.recordList.Length; i++)
{
if (objSearchResult.recordList[i] is NonInventoryResaleItem)
{
NonInventoryResaleItem objItem = (NonInventoryResaleItem)objSearchResult.recordList[i];
arrItem.Add(new string[] { objItem.internalId, objItem.internalId + " " + objItem.vendorName + ": " + objItem.salesDescription });
}
if (objSearchResult.recordList[i] is LotNumberedAssemblyItem)
{
LotNumberedAssemblyItem objItem = (LotNumberedAssemblyItem)objSearchResult.recordList[i];
arrItem.Add(new string[] { objItem.internalId, objItem.internalId + " " + objItem.vendorName + ": " + objItem.displayName });
}
}
}
}
catch (Exception)
{
}
return arrItem;
}
public static NonInventoryResaleItem GetItem(string strProductId)
{
NonInventoryResaleItem objItem = new NonInventoryResaleItem();
try
{
ItemSearchBasic objItemSearchBasic = new ItemSearchBasic();
objItemSearchBasic.vendorCode = new SearchStringField();
objItemSearchBasic.vendorCode.@operator = SearchStringFieldOperator.startsWith;
objItemSearchBasic.vendorCode.searchValue = strProductId;// "CST34434A_B";
objItemSearchBasic.vendorCode.operatorSpecified = true;
objItemSearchBasic.isInactive = new SearchBooleanField();
objItemSearchBasic.isInactive.searchValue = false;
objItemSearchBasic.isInactive.searchValueSpecified = false;
ItemSearch objItemSearch = new ItemSearch();
objItemSearch.basic = objItemSearchBasic;
SearchResult objSearchResult = _service.search(objItemSearch);
if (objSearchResult.recordList != null && objSearchResult.recordList.Length == 1)
{
if (objSearchResult.recordList[0] is NonInventoryResaleItem)
{
objItem = (NonInventoryResaleItem)objSearchResult.recordList[0];
//RecordRef objRecord = new RecordRef();
//objRecord.internalId = objItem.internalId;
//objRecord.type = RecordType.nonInventoryResaleItem;
//objRecord.typeSpecified = true;
//ReadResponse objResponse = _service.get(objRecord);
//objItem = (NonInventoryResaleItem)objResponse.record;
}
}
}
catch (Exception)
{
}
return objItem;
}
public static ArrayList GetItemByItemNumber(string strProductId)
{
ArrayList arrItem = new ArrayList();
try
{
strProductId = strProductId.Trim();
SearchStringCustomField objItemNumber = new SearchStringCustomField();
objItemNumber.@operator = SearchStringFieldOperator.@is;
objItemNumber.operatorSpecified = true;
objItemNumber.searchValue = strProductId;
objItemNumber.internalId = "custitemcst_itemnumber";
ItemSearchBasic objItemSearchBasic = new ItemSearchBasic();
objItemSearchBasic.customFieldList = new SearchCustomField[] { objItemNumber };
objItemSearchBasic.isInactive = new SearchBooleanField();
objItemSearchBasic.isInactive.searchValue = false;
objItemSearchBasic.isInactive.searchValueSpecified = true;
ItemSearch objItemSearch = new ItemSearch();
objItemSearch.basic = objItemSearchBasic;
SearchResult objSearchResult = _service.search(objItemSearch);
if (objSearchResult.recordList != null && objSearchResult.recordList.Length > 0)
{
for (int i = 0; i < objSearchResult.recordList.Length; i++)
{
if (objSearchResult.recordList[i] is NonInventoryResaleItem)
{
NonInventoryResaleItem objItem = (NonInventoryResaleItem)objSearchResult.recordList[i];
arrItem.Add(new string[] { objItem.internalId, objItem.internalId + " " + objItem.vendorName + ": " + objItem.salesDescription });
}
if (objSearchResult.recordList[i] is LotNumberedAssemblyItem)
{
LotNumberedAssemblyItem objItem = (LotNumberedAssemblyItem)objSearchResult.recordList[i];
arrItem.Add(new string[] { objItem.internalId, objItem.internalId + " " + objItem.vendorName + ": " + objItem.displayName });
}
}
}
}
catch (Exception)
{
}
return arrItem;
}
public Dictionary<string, double> getBins(string SKU)
{
NetSuiteService objService = new NetSuiteService();
objService.CookieContainer = new CookieContainer();
Passport passport = new Passport();
passport.account = "3451682";
passport.email = "*****@*****.**";
RecordRef role = new RecordRef();
role.internalId = "1026";
passport.role = role;
passport.password = "******";
Passport objPassport = passport;
Status objStatus = objService.login(objPassport).status;
ItemSearchAdvanced isa = new ItemSearchAdvanced();
isa.savedSearchId = "141"; //substitute your own saved search internal ID
ItemSearch iS = new ItemSearch();
ItemSearchBasic isb = new ItemSearchBasic();
SearchStringField itemSKU = new SearchStringField();
itemSKU.searchValue = SKU;
itemSKU.@operator = SearchStringFieldOperator.contains;
itemSKU.operatorSpecified = true;
isb.itemId = itemSKU;
iS.basic = isb;
isa.criteria = iS;
SearchResult sr = new SearchResult();
sr = objService.search(isa);
if (sr.status.isSuccess != true) throw new Exception("Cannot find item.");
Dictionary<string, double> binNumberList = new Dictionary<string, double>();
foreach (ItemSearchRow irow in sr.searchRowList)
{
if (irow.basic.itemId[0].searchValue == SKU)
{
binNumberList.Add(irow.basic.binNumber[0].searchValue, irow.basic.binOnHandAvail[0].searchValue);
}
}
return binNumberList;
}
