This searches for Quantity Memos using the specified query filters. It provides functionality similar to that provided in the QBPOS UI “Search Quantity Memos” form. This form is displayed when the user clicks the button labelled “Find Quantity Memo” from various locations in the UI, such as Inventory->Quantity Adjustment History, or Inventory->Held Quantity Memos.
Request
Response
XMLOPS
VB.NET
C#
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 | <?xml version="1.0" encoding="utf-8"?> <?qbposxml version="4.0"?> <QBPOSXML> <QBPOSXMLMsgsRq onError="stopOnError"> <InventoryQtyAdjustmentQueryRq metaData="ENUMTYPE" iterator="ENUMTYPE" iteratorID="UUIDTYPE"> <MaxReturned >INTTYPE</MaxReturned> <!-- optional --> <OwnerID >GUIDTYPE</OwnerID> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- optional --> <!-- BEGIN OR --> <TimeCreatedFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required --> </TimeCreatedFilter> <!-- OR --> <TimeCreatedRangeFilter> <!-- optional --> <FromTimeCreated >DATETIMETYPE</FromTimeCreated> <!-- required --> <ToTimeCreated >DATETIMETYPE</ToTimeCreated> <!-- required --> </TimeCreatedRangeFilter> <!-- END OR --> <!-- BEGIN OR --> <TimeModifiedFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <TimeModified >DATETIMETYPE</TimeModified> <!-- required --> </TimeModifiedFilter> <!-- OR --> <TimeModifiedRangeFilter> <!-- optional --> <FromTimeModified >DATETIMETYPE</FromTimeModified> <!-- required --> <ToTimeModified >DATETIMETYPE</ToTimeModified> <!-- required --> </TimeModifiedRangeFilter> <!-- END OR --> <!-- BEGIN OR --> <AssociateFilter> <!-- optional --> <!-- MatchStringCriterion may have one of the following values: Equal, StartsWith, Contains, EndsWith --> <MatchStringCriterion >ENUMTYPE</MatchStringCriterion> <!-- required --> <Associate >STRTYPE</Associate> <!-- required --> </AssociateFilter> <!-- OR --> <AssociateRangeFilter> <!-- optional --> <FromAssociate >STRTYPE</FromAssociate> <!-- required --> <ToAssociate >STRTYPE</ToAssociate> <!-- required --> </AssociateRangeFilter> <!-- END OR --> <!-- BEGIN OR --> <CommentsFilter> <!-- optional --> <!-- MatchStringCriterion may have one of the following values: Equal, StartsWith, Contains, EndsWith --> <MatchStringCriterion >ENUMTYPE</MatchStringCriterion> <!-- required --> <Comments >STRTYPE</Comments> <!-- required --> </CommentsFilter> <!-- OR --> <CommentsRangeFilter> <!-- optional --> <FromComments >STRTYPE</FromComments> <!-- required --> <ToComments >STRTYPE</ToComments> <!-- required --> </CommentsRangeFilter> <!-- END OR --> <!-- HistoryDocStatus may have one of the following values: Regular, Reversed, Reversing --> <HistoryDocStatus >ENUMTYPE</HistoryDocStatus> <!-- optional --> <!-- BEGIN OR --> <InventoryAdjustmentNumberFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <InventoryAdjustmentNumber >INTTYPE</InventoryAdjustmentNumber> <!-- required --> </InventoryAdjustmentNumberFilter> <!-- OR --> <InventoryAdjustmentNumberRangeFilter> <!-- optional --> <FromInventoryAdjustmentNumber >INTTYPE</FromInventoryAdjustmentNumber> <!-- required --> <ToInventoryAdjustmentNumber >INTTYPE</ToInventoryAdjustmentNumber> <!-- required --> </InventoryAdjustmentNumberRangeFilter> <!-- END OR --> <!-- InventoryAdjustmentSource may have one of the following values: Manual, PhysicalInventory, Assembly --> <InventoryAdjustmentSource >ENUMTYPE</InventoryAdjustmentSource> <!-- optional --> <!-- BEGIN OR --> <ItemsCountFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <ItemsCount >INTTYPE</ItemsCount> <!-- required --> </ItemsCountFilter> <!-- OR --> <ItemsCountRangeFilter> <!-- optional --> <FromItemsCount >INTTYPE</FromItemsCount> <!-- required --> <ToItemsCount >INTTYPE</ToItemsCount> <!-- required --> </ItemsCountRangeFilter> <!-- END OR --> <!-- BEGIN OR --> <NewQuantityFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <NewQuantity >QUANTYPE</NewQuantity> <!-- required --> </NewQuantityFilter> <!-- OR --> <NewQuantityRangeFilter> <!-- optional --> <FromNewQuantity >QUANTYPE</FromNewQuantity> <!-- required --> <ToNewQuantity >QUANTYPE</ToNewQuantity> <!-- required --> </NewQuantityRangeFilter> <!-- END OR --> <!-- BEGIN OR --> <OldQuantityFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <OldQuantity >QUANTYPE</OldQuantity> <!-- required --> </OldQuantityFilter> <!-- OR --> <OldQuantityRangeFilter> <!-- optional --> <FromOldQuantity >QUANTYPE</FromOldQuantity> <!-- required --> <ToOldQuantity >QUANTYPE</ToOldQuantity> <!-- required --> </OldQuantityRangeFilter> <!-- END OR --> <!-- QuickBooksFlag may have one of the following values: NotPosted, Completed, Error, UnbilledPurchases --> <QuickBooksFlag >ENUMTYPE</QuickBooksFlag> <!-- optional --> <!-- BEGIN OR --> <ReasonFilter> <!-- optional --> <!-- MatchStringCriterion may have one of the following values: Equal, StartsWith, Contains, EndsWith --> <MatchStringCriterion >ENUMTYPE</MatchStringCriterion> <!-- required --> <Reason >STRTYPE</Reason> <!-- required --> </ReasonFilter> <!-- OR --> <ReasonRangeFilter> <!-- optional --> <FromReason >STRTYPE</FromReason> <!-- required --> <ToReason >STRTYPE</ToReason> <!-- required --> </ReasonRangeFilter> <!-- END OR --> <!-- StoreExchangeStatus may have one of the following values: Modified, Sent, Acknowledged --> <StoreExchangeStatus >ENUMTYPE</StoreExchangeStatus> <!-- optional --> <!-- BEGIN OR --> <StoreNumberFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <StoreNumber >INTTYPE</StoreNumber> <!-- required --> </StoreNumberFilter> <!-- OR --> <StoreNumberRangeFilter> <!-- optional --> <FromStoreNumber >INTTYPE</FromStoreNumber> <!-- required --> <ToStoreNumber >INTTYPE</ToStoreNumber> <!-- required --> </StoreNumberRangeFilter> <!-- END OR --> <!-- BEGIN OR --> <TxnDateFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <TxnDate >DATETYPE</TxnDate> <!-- required --> </TxnDateFilter> <!-- OR --> <TxnDateRangeFilter> <!-- optional --> <FromTxnDate >DATETYPE</FromTxnDate> <!-- required --> <ToTxnDate >DATETYPE</ToTxnDate> <!-- required --> </TxnDateRangeFilter> <!-- END OR --> <!-- TxnState may have one of the following values: Normal, Held --> <TxnState >ENUMTYPE</TxnState> <!-- optional --> <!-- BEGIN OR --> <WorkstationFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <Workstation >INTTYPE</Workstation> <!-- required --> </WorkstationFilter> <!-- OR --> <WorkstationRangeFilter> <!-- optional --> <FromWorkstation >INTTYPE</FromWorkstation> <!-- required --> <ToWorkstation >INTTYPE</ToWorkstation> <!-- required --> </WorkstationRangeFilter> <!-- END OR --> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> </InventoryQtyAdjustmentQueryRq> <InventoryQtyAdjustmentQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE"> <InventoryQtyAdjustmentRet> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- optional --> <TimeCreated >DATETIMETYPE</TimeCreated> <!-- optional --> <TimeModified >DATETIMETYPE</TimeModified> <!-- optional --> <Associate >STRTYPE</Associate> <!-- optional --> <Comments >STRTYPE</Comments> <!-- optional --> <CostDifference >AMTTYPE</CostDifference> <!-- optional --> <!-- HistoryDocStatus may have one of the following values: Regular, Reversed, Reversing --> <HistoryDocStatus >ENUMTYPE</HistoryDocStatus> <!-- optional --> <InventoryAdjustmentNumber >INTTYPE</InventoryAdjustmentNumber> <!-- optional --> <!-- InventoryAdjustmentSource may have one of the following values: Manual, PhysicalInventory, Assembly --> <InventoryAdjustmentSource >ENUMTYPE</InventoryAdjustmentSource> <!-- optional --> <ItemsCount >INTTYPE</ItemsCount> <!-- optional --> <NewQuantity >QUANTYPE</NewQuantity> <!-- optional --> <OldQuantity >QUANTYPE</OldQuantity> <!-- optional --> <QtyDifference >QUANTYPE</QtyDifference> <!-- optional --> <!-- QuickBooksFlag may have one of the following values: NotPosted, Completed, Error, UnbilledPurchases --> <QuickBooksFlag >ENUMTYPE</QuickBooksFlag> <!-- optional --> <Reason >STRTYPE</Reason> <!-- optional --> <!-- StoreExchangeStatus may have one of the following values: Modified, Sent, Acknowledged --> <StoreExchangeStatus >ENUMTYPE</StoreExchangeStatus> <!-- optional --> <StoreNumber >INTTYPE</StoreNumber> <!-- optional --> <TxnDate >DATETYPE</TxnDate> <!-- optional --> <!-- TxnState may have one of the following values: Normal, Held --> <TxnState >ENUMTYPE</TxnState> <!-- optional --> <Workstation >INTTYPE</Workstation> <!-- optional --> <InventoryQtyAdjustmentItemRet> <!-- optional, may repeat --> <ListID >IDTYPE</ListID> <!-- optional --> <NewQuantity >QUANTYPE</NewQuantity> <!-- optional --> <NumberOfBaseUnits >QUANTYPE</NumberOfBaseUnits> <!-- optional --> <OldQuantity >QUANTYPE</OldQuantity> <!-- optional --> <QtyDifference >QUANTYPE</QtyDifference> <!-- optional --> <SerialNumber >STRTYPE</SerialNumber> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> </InventoryQtyAdjustmentItemRet> <DataExtRet> <!-- optional, may repeat --> <OwnerID >GUIDTYPE</OwnerID> <!-- required --> <DataExtName >STRTYPE</DataExtName> <!-- required --> <!-- DataExtType may have one of the following values: INTTYPE, AMTTYPE, PRICETYPE, QUANTYPE, PERCENTTYPE, DATETIMETYPE, STR255TYPE, STR1024TYPE --> <DataExtType >ENUMTYPE</DataExtType> <!-- required --> <DataExtValue >STRTYPE</DataExtValue> <!-- required --> </DataExtRet> </InventoryQtyAdjustmentRet> </InventoryQtyAdjustmentQueryRs> </QBPOSXMLMsgsRq> </QBPOSXML> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 | 'The following sample code is generated as an illustration of
'Creating requests and parsing responses ONLY
'This code is NOT intended to show best practices or ideal code
'Use at your most careful discretion
imports System
imports System.Net
imports System.Drawing
imports System.Collections
imports System.ComponentModel
imports System.Windows.Forms
imports System.Data
imports System.IO
imports Interop.qbposfc4
Public Class SampleInventoryQtyAdjustmentQuery
Public Sub DoInventoryQtyAdjustmentQuery()
Dim sessionBegun as Boolean
sessionBegun = False
Dim connectionOpen as Boolean
connectionOpen = False
Dim sessionManager as QBPOSSessionManager
sessionManager = nothing
Try
'Create the session Manager object
sessionManager = new QBPOSSessionManager
'Create the message set request object to hold our request
Dim requestMsgSet as IMsgSetRequest
requestMsgSet = sessionManager.CreateMsgSetRequest(4,0)
requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue
BuildInventoryQtyAdjustmentQueryRq(requestMsgSet)
'Connect to QuickBooks and begin a session
sessionManager.OpenConnection("","Sample Code from OSR")
connectionOpen = True
sessionManager.BeginSession("")
sessionBegun = True
'Send the request and get the response from QuickBooks
Dim responseMsgSet as IMsgSetResponse
responseMsgSet = sessionManager.DoRequests(requestMsgSet)
'End the session and close the connection to QuickBooks
sessionManager.EndSession()
sessionBegun = False
sessionManager.CloseConnection()
connectionOpen = False
WalkInventoryQtyAdjustmentQueryRs(responseMsgSet)
Catch e as Exception
MessageBox.Show(e.Message, "Error")
if (sessionBegun) then
sessionManager.EndSession()
End If
if (connectionOpen) then
sessionManager.CloseConnection()
End If
End Try
End Sub
Public Sub BuildInventoryQtyAdjustmentQueryRq(requestMsgSet as IMsgSetRequest)
Dim InventoryQtyAdjustmentQueryRq as IInventoryQtyAdjustmentQuery
InventoryQtyAdjustmentQueryRq= requestMsgSet.AppendInventoryQtyAdjustmentQueryRq()
'Set field value for MaxReturned
InventoryQtyAdjustmentQueryRq.MaxReturned.SetValue(6)
'Set field value for OwnerIDList
'May create more than one of these if needed
InventoryQtyAdjustmentQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString())
'Set field value for TxnID
InventoryQtyAdjustmentQueryRq.TxnID.SetValue("200000-1011023419")
Dim ORTimeCreatedFiltersElementType1109 as String
ORTimeCreatedFiltersElementType1109 = "TimeCreatedFilter"
if (ORTimeCreatedFiltersElementType1109 = "TimeCreatedFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for TimeCreated
InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.TimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORTimeCreatedFiltersElementType1109 = "TimeCreatedRangeFilter") then
'Set field value for FromTimeCreated
InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.FromTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToTimeCreated
InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.ToTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
Dim ORTimeModifiedFiltersElementType1110 as String
ORTimeModifiedFiltersElementType1110 = "TimeModifiedFilter"
if (ORTimeModifiedFiltersElementType1110 = "TimeModifiedFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for TimeModified
InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.TimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORTimeModifiedFiltersElementType1110 = "TimeModifiedRangeFilter") then
'Set field value for FromTimeModified
InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.FromTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToTimeModified
InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.ToTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
Dim ORAssociateFiltersElementType1111 as String
ORAssociateFiltersElementType1111 = "AssociateFilter"
if (ORAssociateFiltersElementType1111 = "AssociateFilter") then
'Set field value for MatchStringCriterion
InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual)
'Set field value for Associate
InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.Associate.SetValue("ab")
End If
if (ORAssociateFiltersElementType1111 = "AssociateRangeFilter") then
'Set field value for FromAssociate
InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.FromAssociate.SetValue("ab")
'Set field value for ToAssociate
InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.ToAssociate.SetValue("ab")
End If
Dim ORCommentsFiltersElementType1112 as String
ORCommentsFiltersElementType1112 = "CommentsFilter"
if (ORCommentsFiltersElementType1112 = "CommentsFilter") then
'Set field value for MatchStringCriterion
InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual)
'Set field value for Comments
InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.Comments.SetValue("ab")
End If
if (ORCommentsFiltersElementType1112 = "CommentsRangeFilter") then
'Set field value for FromComments
InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.FromComments.SetValue("ab")
'Set field value for ToComments
InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.ToComments.SetValue("ab")
End If
'Set field value for HistoryDocStatus
InventoryQtyAdjustmentQueryRq.HistoryDocStatus.SetValue(ENHistoryDocStatus.hdsRegular)
Dim ORInventoryAdjustmentNumberFiltersElementType1113 as String
ORInventoryAdjustmentNumberFiltersElementType1113 = "InventoryAdjustmentNumberFilter"
if (ORInventoryAdjustmentNumberFiltersElementType1113 = "InventoryAdjustmentNumberFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for InventoryAdjustmentNumber
InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.InventoryAdjustmentNumber.SetValue(6)
End If
if (ORInventoryAdjustmentNumberFiltersElementType1113 = "InventoryAdjustmentNumberRangeFilter") then
'Set field value for FromInventoryAdjustmentNumber
InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.FromInventoryAdjustmentNumber.SetValue(6)
'Set field value for ToInventoryAdjustmentNumber
InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.ToInventoryAdjustmentNumber.SetValue(6)
End If
'Set field value for InventoryAdjustmentSource
InventoryQtyAdjustmentQueryRq.InventoryAdjustmentSource.SetValue(ENInventoryAdjustmentSource.iasManual)
Dim ORItemsCountFiltersElementType1114 as String
ORItemsCountFiltersElementType1114 = "ItemsCountFilter"
if (ORItemsCountFiltersElementType1114 = "ItemsCountFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for ItemsCount
InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.ItemsCount.SetValue(6)
End If
if (ORItemsCountFiltersElementType1114 = "ItemsCountRangeFilter") then
'Set field value for FromItemsCount
InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.FromItemsCount.SetValue(6)
'Set field value for ToItemsCount
InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.ToItemsCount.SetValue(6)
End If
Dim ORNewQuantityFiltersElementType1115 as String
ORNewQuantityFiltersElementType1115 = "NewQuantityFilter"
if (ORNewQuantityFiltersElementType1115 = "NewQuantityFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for NewQuantity
InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityFilter.NewQuantity.SetValue(2)
End If
if (ORNewQuantityFiltersElementType1115 = "NewQuantityRangeFilter") then
'Set field value for FromNewQuantity
InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityRangeFilter.FromNewQuantity.SetValue(2)
'Set field value for ToNewQuantity
InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityRangeFilter.ToNewQuantity.SetValue(2)
End If
Dim OROldQuantityFiltersElementType1116 as String
OROldQuantityFiltersElementType1116 = "OldQuantityFilter"
if (OROldQuantityFiltersElementType1116 = "OldQuantityFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for OldQuantity
InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityFilter.OldQuantity.SetValue(2)
End If
if (OROldQuantityFiltersElementType1116 = "OldQuantityRangeFilter") then
'Set field value for FromOldQuantity
InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityRangeFilter.FromOldQuantity.SetValue(2)
'Set field value for ToOldQuantity
InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityRangeFilter.ToOldQuantity.SetValue(2)
End If
'Set field value for QuickBooksFlag
InventoryQtyAdjustmentQueryRq.QuickBooksFlag.SetValue(ENQuickBooksFlag.qbfNotPosted)
Dim ORReasonFiltersElementType1117 as String
ORReasonFiltersElementType1117 = "ReasonFilter"
if (ORReasonFiltersElementType1117 = "ReasonFilter") then
'Set field value for MatchStringCriterion
InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual)
'Set field value for Reason
InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonFilter.Reason.SetValue("ab")
End If
if (ORReasonFiltersElementType1117 = "ReasonRangeFilter") then
'Set field value for FromReason
InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.FromReason.SetValue("ab")
'Set field value for ToReason
InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.ToReason.SetValue("ab")
End If
'Set field value for StoreExchangeStatus
InventoryQtyAdjustmentQueryRq.StoreExchangeStatus.SetValue(ENStoreExchangeStatus.sesModified)
Dim ORStoreNumberFiltersElementType1118 as String
ORStoreNumberFiltersElementType1118 = "StoreNumberFilter"
if (ORStoreNumberFiltersElementType1118 = "StoreNumberFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for StoreNumber
InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.StoreNumber.SetValue(6)
End If
if (ORStoreNumberFiltersElementType1118 = "StoreNumberRangeFilter") then
'Set field value for FromStoreNumber
InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.FromStoreNumber.SetValue(6)
'Set field value for ToStoreNumber
InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.ToStoreNumber.SetValue(6)
End If
Dim ORTxnDateFiltersElementType1119 as String
ORTxnDateFiltersElementType1119 = "TxnDateFilter"
if (ORTxnDateFiltersElementType1119 = "TxnDateFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for TxnDate
InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.TxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
if (ORTxnDateFiltersElementType1119 = "TxnDateRangeFilter") then
'Set field value for FromTxnDate
InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
'Set field value for ToTxnDate
InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
'Set field value for TxnState
InventoryQtyAdjustmentQueryRq.TxnState.SetValue(ENTxnState.tsNormal)
Dim ORWorkstationFiltersElementType1120 as String
ORWorkstationFiltersElementType1120 = "WorkstationFilter"
if (ORWorkstationFiltersElementType1120 = "WorkstationFilter") then
'Set field value for MatchNumericCriterion
InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for Workstation
InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.Workstation.SetValue(6)
End If
if (ORWorkstationFiltersElementType1120 = "WorkstationRangeFilter") then
'Set field value for FromWorkstation
InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.FromWorkstation.SetValue(6)
'Set field value for ToWorkstation
InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.ToWorkstation.SetValue(6)
End If
'Set field value for IncludeRetElementList
'May create more than one of these if needed
InventoryQtyAdjustmentQueryRq.IncludeRetElementList.Add("ab")
End Sub
Public Sub WalkInventoryQtyAdjustmentQueryRs( responseMsgSet as IMsgSetResponse)
if (responseMsgSet is nothing) then
Exit Sub
End If
Dim responseList as IResponseList
responseList = responseMsgSet.ResponseList
if (responseList is nothing) then
Exit Sub
End If
'if we sent only one request, there is only one response, we'll walk the list for this sample
for j=0 to responseList.Count-1
Dim response as IResponse
response = responseList.GetAt(j)
'check the status code of the response, 0=ok, >0 is warning
if (response.StatusCode >= 0) then
'the request-specific response is in the details, make sure we have some
if (not response.Detail is nothing) then
'make sure the response is the type we're expecting
Dim responseType as ENResponseType
responseType = CType(response.Type.GetValue(),ENResponseType)
if (responseType = ENResponseType.rtInventoryQtyAdjustmentQueryRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim InventoryQtyAdjustmentRet as IInventoryQtyAdjustmentRetList
InventoryQtyAdjustmentRet = CType(response.Detail,IInventoryQtyAdjustmentRetList)
for z=0 to InventoryQtyAdjustmentRet.Count-1
WalkInventoryQtyAdjustmentRet(InventoryQtyAdjustmentRet.GetAt(z))
Next z
End If
End If
End If
Next j
End Sub
Public Sub WalkInventoryQtyAdjustmentRet(InventoryQtyAdjustmentRet as IInventoryQtyAdjustmentRet)
if (InventoryQtyAdjustmentRet is nothing) then
Exit Sub
End If
'Go through all the elements of IInventoryQtyAdjustmentRetList
'Get value of TxnID
if ( not InventoryQtyAdjustmentRet.TxnID is nothing) then
Dim TxnID1121 as String
TxnID1121 = InventoryQtyAdjustmentRet.TxnID.GetValue()
End If
'Get value of TimeCreated
if ( not InventoryQtyAdjustmentRet.TimeCreated is nothing) then
Dim TimeCreated1122 as DateTime
TimeCreated1122 = InventoryQtyAdjustmentRet.TimeCreated.GetValue()
End If
'Get value of TimeModified
if ( not InventoryQtyAdjustmentRet.TimeModified is nothing) then
Dim TimeModified1123 as DateTime
TimeModified1123 = InventoryQtyAdjustmentRet.TimeModified.GetValue()
End If
'Get value of Associate
if ( not InventoryQtyAdjustmentRet.Associate is nothing) then
Dim Associate1124 as String
Associate1124 = InventoryQtyAdjustmentRet.Associate.GetValue()
End If
'Get value of Comments
if ( not InventoryQtyAdjustmentRet.Comments is nothing) then
Dim Comments1125 as String
Comments1125 = InventoryQtyAdjustmentRet.Comments.GetValue()
End If
'Get value of CostDifference
if ( not InventoryQtyAdjustmentRet.CostDifference is nothing) then
Dim CostDifference1126 as Double
CostDifference1126 = InventoryQtyAdjustmentRet.CostDifference.GetValue()
End If
'Get value of HistoryDocStatus
if ( not InventoryQtyAdjustmentRet.HistoryDocStatus is nothing) then
Dim HistoryDocStatus1127 as ENHistoryDocStatus
HistoryDocStatus1127 = InventoryQtyAdjustmentRet.HistoryDocStatus.GetValue()
End If
'Get value of InventoryAdjustmentNumber
if ( not InventoryQtyAdjustmentRet.InventoryAdjustmentNumber is nothing) then
Dim InventoryAdjustmentNumber1128 as Integer
InventoryAdjustmentNumber1128 = InventoryQtyAdjustmentRet.InventoryAdjustmentNumber.GetValue()
End If
'Get value of InventoryAdjustmentSource
if ( not InventoryQtyAdjustmentRet.InventoryAdjustmentSource is nothing) then
Dim InventoryAdjustmentSource1129 as ENInventoryAdjustmentSource
InventoryAdjustmentSource1129 = InventoryQtyAdjustmentRet.InventoryAdjustmentSource.GetValue()
End If
'Get value of ItemsCount
if ( not InventoryQtyAdjustmentRet.ItemsCount is nothing) then
Dim ItemsCount1130 as Integer
ItemsCount1130 = InventoryQtyAdjustmentRet.ItemsCount.GetValue()
End If
'Get value of NewQuantity
if ( not InventoryQtyAdjustmentRet.NewQuantity is nothing) then
Dim NewQuantity1131 as Double
NewQuantity1131 = InventoryQtyAdjustmentRet.NewQuantity.GetValue()
End If
'Get value of OldQuantity
if ( not InventoryQtyAdjustmentRet.OldQuantity is nothing) then
Dim OldQuantity1132 as Double
OldQuantity1132 = InventoryQtyAdjustmentRet.OldQuantity.GetValue()
End If
'Get value of QtyDifference
if ( not InventoryQtyAdjustmentRet.QtyDifference is nothing) then
Dim QtyDifference1133 as Double
QtyDifference1133 = InventoryQtyAdjustmentRet.QtyDifference.GetValue()
End If
'Get value of QuickBooksFlag
if ( not InventoryQtyAdjustmentRet.QuickBooksFlag is nothing) then
Dim QuickBooksFlag1134 as ENQuickBooksFlag
QuickBooksFlag1134 = InventoryQtyAdjustmentRet.QuickBooksFlag.GetValue()
End If
'Get value of Reason
if ( not InventoryQtyAdjustmentRet.Reason is nothing) then
Dim Reason1135 as String
Reason1135 = InventoryQtyAdjustmentRet.Reason.GetValue()
End If
'Get value of StoreExchangeStatus
if ( not InventoryQtyAdjustmentRet.StoreExchangeStatus is nothing) then
Dim StoreExchangeStatus1136 as ENStoreExchangeStatus
StoreExchangeStatus1136 = InventoryQtyAdjustmentRet.StoreExchangeStatus.GetValue()
End If
'Get value of StoreNumber
if ( not InventoryQtyAdjustmentRet.StoreNumber is nothing) then
Dim StoreNumber1137 as Integer
StoreNumber1137 = InventoryQtyAdjustmentRet.StoreNumber.GetValue()
End If
'Get value of TxnDate
if ( not InventoryQtyAdjustmentRet.TxnDate is nothing) then
Dim TxnDate1138 as DateTime
TxnDate1138 = InventoryQtyAdjustmentRet.TxnDate.GetValue()
End If
'Get value of TxnState
if ( not InventoryQtyAdjustmentRet.TxnState is nothing) then
Dim TxnState1139 as ENTxnState
TxnState1139 = InventoryQtyAdjustmentRet.TxnState.GetValue()
End If
'Get value of Workstation
if ( not InventoryQtyAdjustmentRet.Workstation is nothing) then
Dim Workstation1140 as Integer
Workstation1140 = InventoryQtyAdjustmentRet.Workstation.GetValue()
End If
if (not InventoryQtyAdjustmentRet.InventoryQtyAdjustmentItemRetList is nothing)
Dim i1141 as Integer
for i1141 = 0 to InventoryQtyAdjustmentRet.InventoryQtyAdjustmentItemRetList.Count - 1
Dim InventoryQtyAdjustmentItemRet as IInventoryQtyAdjustmentItemRet
InventoryQtyAdjustmentItemRet = InventoryQtyAdjustmentRet.InventoryQtyAdjustmentItemRetList.GetAt(i1141)
'Get value of ListID
if ( not InventoryQtyAdjustmentItemRet.ListID is nothing) then
Dim ListID1142 as String
ListID1142 = InventoryQtyAdjustmentItemRet.ListID.GetValue()
End If
'Get value of NewQuantity
if ( not InventoryQtyAdjustmentItemRet.NewQuantity is nothing) then
Dim NewQuantity1143 as Double
NewQuantity1143 = InventoryQtyAdjustmentItemRet.NewQuantity.GetValue()
End If
'Get value of NumberOfBaseUnits
if ( not InventoryQtyAdjustmentItemRet.NumberOfBaseUnits is nothing) then
Dim NumberOfBaseUnits1144 as Double
NumberOfBaseUnits1144 = InventoryQtyAdjustmentItemRet.NumberOfBaseUnits.GetValue()
End If
'Get value of OldQuantity
if ( not InventoryQtyAdjustmentItemRet.OldQuantity is nothing) then
Dim OldQuantity1145 as Double
OldQuantity1145 = InventoryQtyAdjustmentItemRet.OldQuantity.GetValue()
End If
'Get value of QtyDifference
if ( not InventoryQtyAdjustmentItemRet.QtyDifference is nothing) then
Dim QtyDifference1146 as Double
QtyDifference1146 = InventoryQtyAdjustmentItemRet.QtyDifference.GetValue()
End If
'Get value of SerialNumber
if ( not InventoryQtyAdjustmentItemRet.SerialNumber is nothing) then
Dim SerialNumber1147 as String
SerialNumber1147 = InventoryQtyAdjustmentItemRet.SerialNumber.GetValue()
End If
'Get value of UnitOfMeasure
if ( not InventoryQtyAdjustmentItemRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure1148 as String
UnitOfMeasure1148 = InventoryQtyAdjustmentItemRet.UnitOfMeasure.GetValue()
End If
Next i1141
End If
if (not InventoryQtyAdjustmentRet.DataExtRetList is nothing)
Dim i1149 as Integer
for i1149 = 0 to InventoryQtyAdjustmentRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = InventoryQtyAdjustmentRet.DataExtRetList.GetAt(i1149)
'Get value of OwnerID
Dim OwnerID1150 as String
OwnerID1150 = DataExtRet.OwnerID.GetValue()
'Get value of DataExtName
Dim DataExtName1151 as String
DataExtName1151 = DataExtRet.DataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType1152 as ENDataExtType
DataExtType1152 = DataExtRet.DataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue1153 as String
DataExtValue1153 = DataExtRet.DataExtValue.GetValue()
Next i1149
End If
End Sub
End Class
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 | //The following sample code is generated as an illustration of //Creating requests and parsing responses ONLY //This code is NOT intended to show best practices or ideal code //Use at your most careful discretion using System; using System.Net; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.IO; using Interop.qbposfc4; namespace com.intuit.idn.samples { public class SampleInventoryQtyAdjustmentQuery { public void DoInventoryQtyAdjustmentQuery() { bool sessionBegun = false; bool connectionOpen = false; QBPOSSessionManager sessionManager = null; try { //Create the session Manager object sessionManager = new QBPOSSessionManager(); //Create the message set request object to hold our request IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest(4,0); requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue; BuildInventoryQtyAdjustmentQueryRq(requestMsgSet); //Connect to QuickBooks and begin a session sessionManager.OpenConnection("","Sample Code from OSR"); connectionOpen = true; sessionManager.BeginSession(""); sessionBegun = true; //Send the request and get the response from QuickBooks IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet); //End the session and close the connection to QuickBooks sessionManager.EndSession(); sessionBegun = false; sessionManager.CloseConnection(); connectionOpen = false; WalkInventoryQtyAdjustmentQueryRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildInventoryQtyAdjustmentQueryRq(IMsgSetRequest requestMsgSet) { IInventoryQtyAdjustmentQuery InventoryQtyAdjustmentQueryRq= requestMsgSet.AppendInventoryQtyAdjustmentQueryRq(); //Set attributes //Set field value for metaData InventoryQtyAdjustmentQueryRq.metaData.SetValue(ENmetaData.mdMetaDataAndResponseData); //Set field value for iterator InventoryQtyAdjustmentQueryRq.iterator.SetValue(ENiterator.itStart); //Set field value for iteratorID InventoryQtyAdjustmentQueryRq.iteratorID.SetValue("{D7355385-A17B-4f5d-B34D-F34C79C3E6FC}"); //Set field value for MaxReturned InventoryQtyAdjustmentQueryRq.MaxReturned.SetValue(6); //Set field value for OwnerIDList //May create more than one of these if needed InventoryQtyAdjustmentQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString()); //Set field value for TxnID InventoryQtyAdjustmentQueryRq.TxnID.SetValue("200000-1011023419"); string ORTimeCreatedFiltersElementType1154 = "TimeCreatedFilter"; if (ORTimeCreatedFiltersElementType1154 == "TimeCreatedFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for TimeCreated InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.TimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORTimeCreatedFiltersElementType1154 == "TimeCreatedRangeFilter") { //Set field value for FromTimeCreated InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.FromTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToTimeCreated InventoryQtyAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.ToTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } string ORTimeModifiedFiltersElementType1155 = "TimeModifiedFilter"; if (ORTimeModifiedFiltersElementType1155 == "TimeModifiedFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for TimeModified InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.TimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORTimeModifiedFiltersElementType1155 == "TimeModifiedRangeFilter") { //Set field value for FromTimeModified InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.FromTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToTimeModified InventoryQtyAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.ToTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } string ORAssociateFiltersElementType1156 = "AssociateFilter"; if (ORAssociateFiltersElementType1156 == "AssociateFilter") { //Set field value for MatchStringCriterion InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual); //Set field value for Associate InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.Associate.SetValue("ab"); } if (ORAssociateFiltersElementType1156 == "AssociateRangeFilter") { //Set field value for FromAssociate InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.FromAssociate.SetValue("ab"); //Set field value for ToAssociate InventoryQtyAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.ToAssociate.SetValue("ab"); } string ORCommentsFiltersElementType1157 = "CommentsFilter"; if (ORCommentsFiltersElementType1157 == "CommentsFilter") { //Set field value for MatchStringCriterion InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual); //Set field value for Comments InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.Comments.SetValue("ab"); } if (ORCommentsFiltersElementType1157 == "CommentsRangeFilter") { //Set field value for FromComments InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.FromComments.SetValue("ab"); //Set field value for ToComments InventoryQtyAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.ToComments.SetValue("ab"); } //Set field value for HistoryDocStatus InventoryQtyAdjustmentQueryRq.HistoryDocStatus.SetValue(ENHistoryDocStatus.hdsRegular); string ORInventoryAdjustmentNumberFiltersElementType1158 = "InventoryAdjustmentNumberFilter"; if (ORInventoryAdjustmentNumberFiltersElementType1158 == "InventoryAdjustmentNumberFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for InventoryAdjustmentNumber InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.InventoryAdjustmentNumber.SetValue(6); } if (ORInventoryAdjustmentNumberFiltersElementType1158 == "InventoryAdjustmentNumberRangeFilter") { //Set field value for FromInventoryAdjustmentNumber InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.FromInventoryAdjustmentNumber.SetValue(6); //Set field value for ToInventoryAdjustmentNumber InventoryQtyAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.ToInventoryAdjustmentNumber.SetValue(6); } //Set field value for InventoryAdjustmentSource InventoryQtyAdjustmentQueryRq.InventoryAdjustmentSource.SetValue(ENInventoryAdjustmentSource.iasManual); string ORItemsCountFiltersElementType1159 = "ItemsCountFilter"; if (ORItemsCountFiltersElementType1159 == "ItemsCountFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for ItemsCount InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.ItemsCount.SetValue(6); } if (ORItemsCountFiltersElementType1159 == "ItemsCountRangeFilter") { //Set field value for FromItemsCount InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.FromItemsCount.SetValue(6); //Set field value for ToItemsCount InventoryQtyAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.ToItemsCount.SetValue(6); } string ORNewQuantityFiltersElementType1160 = "NewQuantityFilter"; if (ORNewQuantityFiltersElementType1160 == "NewQuantityFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for NewQuantity InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityFilter.NewQuantity.SetValue(2); } if (ORNewQuantityFiltersElementType1160 == "NewQuantityRangeFilter") { //Set field value for FromNewQuantity InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityRangeFilter.FromNewQuantity.SetValue(2); //Set field value for ToNewQuantity InventoryQtyAdjustmentQueryRq.ORNewQuantityFilters.NewQuantityRangeFilter.ToNewQuantity.SetValue(2); } string OROldQuantityFiltersElementType1161 = "OldQuantityFilter"; if (OROldQuantityFiltersElementType1161 == "OldQuantityFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for OldQuantity InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityFilter.OldQuantity.SetValue(2); } if (OROldQuantityFiltersElementType1161 == "OldQuantityRangeFilter") { //Set field value for FromOldQuantity InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityRangeFilter.FromOldQuantity.SetValue(2); //Set field value for ToOldQuantity InventoryQtyAdjustmentQueryRq.OROldQuantityFilters.OldQuantityRangeFilter.ToOldQuantity.SetValue(2); } //Set field value for QuickBooksFlag InventoryQtyAdjustmentQueryRq.QuickBooksFlag.SetValue(ENQuickBooksFlag.qbfNotPosted); string ORReasonFiltersElementType1162 = "ReasonFilter"; if (ORReasonFiltersElementType1162 == "ReasonFilter") { //Set field value for MatchStringCriterion InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual); //Set field value for Reason InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonFilter.Reason.SetValue("ab"); } if (ORReasonFiltersElementType1162 == "ReasonRangeFilter") { //Set field value for FromReason InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.FromReason.SetValue("ab"); //Set field value for ToReason InventoryQtyAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.ToReason.SetValue("ab"); } //Set field value for StoreExchangeStatus InventoryQtyAdjustmentQueryRq.StoreExchangeStatus.SetValue(ENStoreExchangeStatus.sesModified); string ORStoreNumberFiltersElementType1163 = "StoreNumberFilter"; if (ORStoreNumberFiltersElementType1163 == "StoreNumberFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for StoreNumber InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.StoreNumber.SetValue(6); } if (ORStoreNumberFiltersElementType1163 == "StoreNumberRangeFilter") { //Set field value for FromStoreNumber InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.FromStoreNumber.SetValue(6); //Set field value for ToStoreNumber InventoryQtyAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.ToStoreNumber.SetValue(6); } string ORTxnDateFiltersElementType1164 = "TxnDateFilter"; if (ORTxnDateFiltersElementType1164 == "TxnDateFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for TxnDate InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.TxnDate.SetValue(DateTime.Parse("12/15/2007")); } if (ORTxnDateFiltersElementType1164 == "TxnDateRangeFilter") { //Set field value for FromTxnDate InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for ToTxnDate InventoryQtyAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")); } //Set field value for TxnState InventoryQtyAdjustmentQueryRq.TxnState.SetValue(ENTxnState.tsNormal); string ORWorkstationFiltersElementType1165 = "WorkstationFilter"; if (ORWorkstationFiltersElementType1165 == "WorkstationFilter") { //Set field value for MatchNumericCriterion InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for Workstation InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.Workstation.SetValue(6); } if (ORWorkstationFiltersElementType1165 == "WorkstationRangeFilter") { //Set field value for FromWorkstation InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.FromWorkstation.SetValue(6); //Set field value for ToWorkstation InventoryQtyAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.ToWorkstation.SetValue(6); } //Set field value for IncludeRetElementList //May create more than one of these if needed InventoryQtyAdjustmentQueryRq.IncludeRetElementList.Add("ab"); } void WalkInventoryQtyAdjustmentQueryRs(IMsgSetResponse responseMsgSet) { if (responseMsgSet == null) return; IResponseList responseList = responseMsgSet.ResponseList; if (responseList == null) return; //if we sent only one request, there is only one response, we'll walk the list for this sample for(int i=0; i < responseList.Count; i++) { IResponse response = responseList.GetAt(i); //check the status code of the response, 0=ok, >0 is warning if (response.StatusCode >= 0) { //the request-specific response is in the details, make sure we have some if (response.Detail != null) { //make sure the response is the type we're expecting ENResponseType responseType = (ENResponseType)response.Type.GetValue(); if (responseType == ENResponseType.rtInventoryQtyAdjustmentQueryRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IInventoryQtyAdjustmentRetList InventoryQtyAdjustmentRet = (IInventoryQtyAdjustmentRetList)response.Detail; for(int z=0; z < InventoryQtyAdjustmentRet.Count; z++) { WalkInventoryQtyAdjustmentRet(InventoryQtyAdjustmentRet.GetAt(z)); } } } } } } void WalkInventoryQtyAdjustmentRet(IInventoryQtyAdjustmentRet InventoryQtyAdjustmentRet) { if (InventoryQtyAdjustmentRet == null) return; //Go through all the elements of IInventoryQtyAdjustmentRetList //Get value of TxnID if (InventoryQtyAdjustmentRet.TxnID != null) { string TxnID1166 = (string)InventoryQtyAdjustmentRet.TxnID.GetValue(); } //Get value of TimeCreated if (InventoryQtyAdjustmentRet.TimeCreated != null) { DateTime TimeCreated1167 = (DateTime)InventoryQtyAdjustmentRet.TimeCreated.GetValue(); } //Get value of TimeModified if (InventoryQtyAdjustmentRet.TimeModified != null) { DateTime TimeModified1168 = (DateTime)InventoryQtyAdjustmentRet.TimeModified.GetValue(); } //Get value of Associate if (InventoryQtyAdjustmentRet.Associate != null) { string Associate1169 = (string)InventoryQtyAdjustmentRet.Associate.GetValue(); } //Get value of Comments if (InventoryQtyAdjustmentRet.Comments != null) { string Comments1170 = (string)InventoryQtyAdjustmentRet.Comments.GetValue(); } //Get value of CostDifference if (InventoryQtyAdjustmentRet.CostDifference != null) { double CostDifference1171 = (double)InventoryQtyAdjustmentRet.CostDifference.GetValue(); } //Get value of HistoryDocStatus if (InventoryQtyAdjustmentRet.HistoryDocStatus != null) { ENHistoryDocStatus HistoryDocStatus1172 = (ENHistoryDocStatus)InventoryQtyAdjustmentRet.HistoryDocStatus.GetValue(); } //Get value of InventoryAdjustmentNumber if (InventoryQtyAdjustmentRet.InventoryAdjustmentNumber != null) { int InventoryAdjustmentNumber1173 = (int)InventoryQtyAdjustmentRet.InventoryAdjustmentNumber.GetValue(); } //Get value of InventoryAdjustmentSource if (InventoryQtyAdjustmentRet.InventoryAdjustmentSource != null) { ENInventoryAdjustmentSource InventoryAdjustmentSource1174 = (ENInventoryAdjustmentSource)InventoryQtyAdjustmentRet.InventoryAdjustmentSource.GetValue(); } //Get value of ItemsCount if (InventoryQtyAdjustmentRet.ItemsCount != null) { int ItemsCount1175 = (int)InventoryQtyAdjustmentRet.ItemsCount.GetValue(); } //Get value of NewQuantity if (InventoryQtyAdjustmentRet.NewQuantity != null) { int NewQuantity1176 = (int)InventoryQtyAdjustmentRet.NewQuantity.GetValue(); } //Get value of OldQuantity if (InventoryQtyAdjustmentRet.OldQuantity != null) { int OldQuantity1177 = (int)InventoryQtyAdjustmentRet.OldQuantity.GetValue(); } //Get value of QtyDifference if (InventoryQtyAdjustmentRet.QtyDifference != null) { int QtyDifference1178 = (int)InventoryQtyAdjustmentRet.QtyDifference.GetValue(); } //Get value of QuickBooksFlag if (InventoryQtyAdjustmentRet.QuickBooksFlag != null) { ENQuickBooksFlag QuickBooksFlag1179 = (ENQuickBooksFlag)InventoryQtyAdjustmentRet.QuickBooksFlag.GetValue(); } //Get value of Reason if (InventoryQtyAdjustmentRet.Reason != null) { string Reason1180 = (string)InventoryQtyAdjustmentRet.Reason.GetValue(); } //Get value of StoreExchangeStatus if (InventoryQtyAdjustmentRet.StoreExchangeStatus != null) { ENStoreExchangeStatus StoreExchangeStatus1181 = (ENStoreExchangeStatus)InventoryQtyAdjustmentRet.StoreExchangeStatus.GetValue(); } //Get value of StoreNumber if (InventoryQtyAdjustmentRet.StoreNumber != null) { int StoreNumber1182 = (int)InventoryQtyAdjustmentRet.StoreNumber.GetValue(); } //Get value of TxnDate if (InventoryQtyAdjustmentRet.TxnDate != null) { DateTime TxnDate1183 = (DateTime)InventoryQtyAdjustmentRet.TxnDate.GetValue(); } //Get value of TxnState if (InventoryQtyAdjustmentRet.TxnState != null) { ENTxnState TxnState1184 = (ENTxnState)InventoryQtyAdjustmentRet.TxnState.GetValue(); } //Get value of Workstation if (InventoryQtyAdjustmentRet.Workstation != null) { int Workstation1185 = (int)InventoryQtyAdjustmentRet.Workstation.GetValue(); } if (InventoryQtyAdjustmentRet.InventoryQtyAdjustmentItemRetList != null) { for (int i1186 = 0; i1186 < InventoryQtyAdjustmentRet.InventoryQtyAdjustmentItemRetList.Count; i1186++) { IInventoryQtyAdjustmentItemRet InventoryQtyAdjustmentItemRet = InventoryQtyAdjustmentRet.InventoryQtyAdjustmentItemRetList.GetAt(i1186); //Get value of ListID if (InventoryQtyAdjustmentItemRet.ListID != null) { string ListID1187 = (string)InventoryQtyAdjustmentItemRet.ListID.GetValue(); } //Get value of NewQuantity if (InventoryQtyAdjustmentItemRet.NewQuantity != null) { int NewQuantity1188 = (int)InventoryQtyAdjustmentItemRet.NewQuantity.GetValue(); } //Get value of NumberOfBaseUnits if (InventoryQtyAdjustmentItemRet.NumberOfBaseUnits != null) { int NumberOfBaseUnits1189 = (int)InventoryQtyAdjustmentItemRet.NumberOfBaseUnits.GetValue(); } //Get value of OldQuantity if (InventoryQtyAdjustmentItemRet.OldQuantity != null) { int OldQuantity1190 = (int)InventoryQtyAdjustmentItemRet.OldQuantity.GetValue(); } //Get value of QtyDifference if (InventoryQtyAdjustmentItemRet.QtyDifference != null) { int QtyDifference1191 = (int)InventoryQtyAdjustmentItemRet.QtyDifference.GetValue(); } //Get value of SerialNumber if (InventoryQtyAdjustmentItemRet.SerialNumber != null) { string SerialNumber1192 = (string)InventoryQtyAdjustmentItemRet.SerialNumber.GetValue(); } //Get value of UnitOfMeasure if (InventoryQtyAdjustmentItemRet.UnitOfMeasure != null) { string UnitOfMeasure1193 = (string)InventoryQtyAdjustmentItemRet.UnitOfMeasure.GetValue(); } } } if (InventoryQtyAdjustmentRet.DataExtRetList != null) { for (int i1194 = 0; i1194 < InventoryQtyAdjustmentRet.DataExtRetList.Count; i1194++) { IDataExtRet DataExtRet = InventoryQtyAdjustmentRet.DataExtRetList.GetAt(i1194); //Get value of OwnerID string OwnerID1195 = (string)DataExtRet.OwnerID.GetValue(); //Get value of DataExtName string DataExtName1196 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType1197 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue1198 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } |