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