Retrieves the cost adjustment transactions specified in the query filtering.
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 | <?xml version="1.0" encoding="utf-8"?> <?qbposxml version="4.0"?> <QBPOSXML> <QBPOSXMLMsgsRq onError="stopOnError"> <InventoryCostAdjustmentQueryRq 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 --> <NewCostFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <NewCost >AMTTYPE</NewCost> <!-- required --> </NewCostFilter> <!-- OR --> <NewCostRangeFilter> <!-- optional --> <FromNewCost >AMTTYPE</FromNewCost> <!-- required --> <ToNewCost >AMTTYPE</ToNewCost> <!-- required --> </NewCostRangeFilter> <!-- END OR --> <!-- BEGIN OR --> <OldCostFilter> <!-- optional --> <!-- MatchNumericCriterion may have one of the following values: LessThan, LessThanEqual, Equal, GreaterThan, GreaterThanEqual --> <MatchNumericCriterion >ENUMTYPE</MatchNumericCriterion> <!-- required --> <OldCost >AMTTYPE</OldCost> <!-- required --> </OldCostFilter> <!-- OR --> <OldCostRangeFilter> <!-- optional --> <FromOldCost >AMTTYPE</FromOldCost> <!-- required --> <ToOldCost >AMTTYPE</ToOldCost> <!-- required --> </OldCostRangeFilter> <!-- 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 --> </InventoryCostAdjustmentQueryRq> <InventoryCostAdjustmentQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE"> <InventoryCostAdjustmentRet> <!-- 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 --> <NewCost >AMTTYPE</NewCost> <!-- optional --> <OldCost >AMTTYPE</OldCost> <!-- 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 --> <InventoryCostAdjustmentItemRet> <!-- optional, may repeat --> <ListID >IDTYPE</ListID> <!-- optional --> <CostDifference >AMTTYPE</CostDifference> <!-- optional --> <NewCost >AMTTYPE</NewCost> <!-- optional --> <NumberOfBaseUnits >QUANTYPE</NumberOfBaseUnits> <!-- optional --> <OldCost >AMTTYPE</OldCost> <!-- optional --> <UnitOfMeasure >STRTYPE</UnitOfMeasure> <!-- optional --> </InventoryCostAdjustmentItemRet> <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> </InventoryCostAdjustmentRet> </InventoryCostAdjustmentQueryRs> </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 | '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 SampleInventoryCostAdjustmentQuery
Public Sub DoInventoryCostAdjustmentQuery()
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
BuildInventoryCostAdjustmentQueryRq(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
WalkInventoryCostAdjustmentQueryRs(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 BuildInventoryCostAdjustmentQueryRq(requestMsgSet as IMsgSetRequest)
Dim InventoryCostAdjustmentQueryRq as IInventoryCostAdjustmentQuery
InventoryCostAdjustmentQueryRq= requestMsgSet.AppendInventoryCostAdjustmentQueryRq()
'Set field value for MaxReturned
InventoryCostAdjustmentQueryRq.MaxReturned.SetValue(6)
'Set field value for OwnerIDList
'May create more than one of these if needed
InventoryCostAdjustmentQueryRq.OwnerIDList.Add(System.Guid.NewGuid().ToString())
'Set field value for TxnID
InventoryCostAdjustmentQueryRq.TxnID.SetValue("200000-1011023419")
Dim ORTimeCreatedFiltersElementType955 as String
ORTimeCreatedFiltersElementType955 = "TimeCreatedFilter"
if (ORTimeCreatedFiltersElementType955 = "TimeCreatedFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for TimeCreated
InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.TimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORTimeCreatedFiltersElementType955 = "TimeCreatedRangeFilter") then
'Set field value for FromTimeCreated
InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.FromTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToTimeCreated
InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.ToTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
Dim ORTimeModifiedFiltersElementType956 as String
ORTimeModifiedFiltersElementType956 = "TimeModifiedFilter"
if (ORTimeModifiedFiltersElementType956 = "TimeModifiedFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for TimeModified
InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.TimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORTimeModifiedFiltersElementType956 = "TimeModifiedRangeFilter") then
'Set field value for FromTimeModified
InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.FromTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToTimeModified
InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.ToTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
Dim ORAssociateFiltersElementType957 as String
ORAssociateFiltersElementType957 = "AssociateFilter"
if (ORAssociateFiltersElementType957 = "AssociateFilter") then
'Set field value for MatchStringCriterion
InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual)
'Set field value for Associate
InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.Associate.SetValue("ab")
End If
if (ORAssociateFiltersElementType957 = "AssociateRangeFilter") then
'Set field value for FromAssociate
InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.FromAssociate.SetValue("ab")
'Set field value for ToAssociate
InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.ToAssociate.SetValue("ab")
End If
Dim ORCommentsFiltersElementType958 as String
ORCommentsFiltersElementType958 = "CommentsFilter"
if (ORCommentsFiltersElementType958 = "CommentsFilter") then
'Set field value for MatchStringCriterion
InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual)
'Set field value for Comments
InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.Comments.SetValue("ab")
End If
if (ORCommentsFiltersElementType958 = "CommentsRangeFilter") then
'Set field value for FromComments
InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.FromComments.SetValue("ab")
'Set field value for ToComments
InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.ToComments.SetValue("ab")
End If
'Set field value for HistoryDocStatus
InventoryCostAdjustmentQueryRq.HistoryDocStatus.SetValue(ENHistoryDocStatus.hdsRegular)
Dim ORInventoryAdjustmentNumberFiltersElementType959 as String
ORInventoryAdjustmentNumberFiltersElementType959 = "InventoryAdjustmentNumberFilter"
if (ORInventoryAdjustmentNumberFiltersElementType959 = "InventoryAdjustmentNumberFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for InventoryAdjustmentNumber
InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.InventoryAdjustmentNumber.SetValue(6)
End If
if (ORInventoryAdjustmentNumberFiltersElementType959 = "InventoryAdjustmentNumberRangeFilter") then
'Set field value for FromInventoryAdjustmentNumber
InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.FromInventoryAdjustmentNumber.SetValue(6)
'Set field value for ToInventoryAdjustmentNumber
InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.ToInventoryAdjustmentNumber.SetValue(6)
End If
'Set field value for InventoryAdjustmentSource
InventoryCostAdjustmentQueryRq.InventoryAdjustmentSource.SetValue(ENInventoryAdjustmentSource.iasManual)
Dim ORItemsCountFiltersElementType960 as String
ORItemsCountFiltersElementType960 = "ItemsCountFilter"
if (ORItemsCountFiltersElementType960 = "ItemsCountFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for ItemsCount
InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.ItemsCount.SetValue(6)
End If
if (ORItemsCountFiltersElementType960 = "ItemsCountRangeFilter") then
'Set field value for FromItemsCount
InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.FromItemsCount.SetValue(6)
'Set field value for ToItemsCount
InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.ToItemsCount.SetValue(6)
End If
Dim ORNewCostFiltersElementType961 as String
ORNewCostFiltersElementType961 = "NewCostFilter"
if (ORNewCostFiltersElementType961 = "NewCostFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for NewCost
InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostFilter.NewCost.SetValue(10.01)
End If
if (ORNewCostFiltersElementType961 = "NewCostRangeFilter") then
'Set field value for FromNewCost
InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostRangeFilter.FromNewCost.SetValue(10.01)
'Set field value for ToNewCost
InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostRangeFilter.ToNewCost.SetValue(10.01)
End If
Dim OROldCostFiltersElementType962 as String
OROldCostFiltersElementType962 = "OldCostFilter"
if (OROldCostFiltersElementType962 = "OldCostFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for OldCost
InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostFilter.OldCost.SetValue(10.01)
End If
if (OROldCostFiltersElementType962 = "OldCostRangeFilter") then
'Set field value for FromOldCost
InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostRangeFilter.FromOldCost.SetValue(10.01)
'Set field value for ToOldCost
InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostRangeFilter.ToOldCost.SetValue(10.01)
End If
'Set field value for QuickBooksFlag
InventoryCostAdjustmentQueryRq.QuickBooksFlag.SetValue(ENQuickBooksFlag.qbfNotPosted)
Dim ORReasonFiltersElementType963 as String
ORReasonFiltersElementType963 = "ReasonFilter"
if (ORReasonFiltersElementType963 = "ReasonFilter") then
'Set field value for MatchStringCriterion
InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual)
'Set field value for Reason
InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonFilter.Reason.SetValue("ab")
End If
if (ORReasonFiltersElementType963 = "ReasonRangeFilter") then
'Set field value for FromReason
InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.FromReason.SetValue("ab")
'Set field value for ToReason
InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.ToReason.SetValue("ab")
End If
'Set field value for StoreExchangeStatus
InventoryCostAdjustmentQueryRq.StoreExchangeStatus.SetValue(ENStoreExchangeStatus.sesModified)
Dim ORStoreNumberFiltersElementType964 as String
ORStoreNumberFiltersElementType964 = "StoreNumberFilter"
if (ORStoreNumberFiltersElementType964 = "StoreNumberFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for StoreNumber
InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.StoreNumber.SetValue(6)
End If
if (ORStoreNumberFiltersElementType964 = "StoreNumberRangeFilter") then
'Set field value for FromStoreNumber
InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.FromStoreNumber.SetValue(6)
'Set field value for ToStoreNumber
InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.ToStoreNumber.SetValue(6)
End If
Dim ORTxnDateFiltersElementType965 as String
ORTxnDateFiltersElementType965 = "TxnDateFilter"
if (ORTxnDateFiltersElementType965 = "TxnDateFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for TxnDate
InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.TxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
if (ORTxnDateFiltersElementType965 = "TxnDateRangeFilter") then
'Set field value for FromTxnDate
InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
'Set field value for ToTxnDate
InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
'Set field value for TxnState
InventoryCostAdjustmentQueryRq.TxnState.SetValue(ENTxnState.tsNormal)
Dim ORWorkstationFiltersElementType966 as String
ORWorkstationFiltersElementType966 = "WorkstationFilter"
if (ORWorkstationFiltersElementType966 = "WorkstationFilter") then
'Set field value for MatchNumericCriterion
InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan)
'Set field value for Workstation
InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.Workstation.SetValue(6)
End If
if (ORWorkstationFiltersElementType966 = "WorkstationRangeFilter") then
'Set field value for FromWorkstation
InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.FromWorkstation.SetValue(6)
'Set field value for ToWorkstation
InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.ToWorkstation.SetValue(6)
End If
'Set field value for IncludeRetElementList
'May create more than one of these if needed
InventoryCostAdjustmentQueryRq.IncludeRetElementList.Add("ab")
End Sub
Public Sub WalkInventoryCostAdjustmentQueryRs( 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.rtInventoryCostAdjustmentQueryRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim InventoryCostAdjustmentRet as IInventoryCostAdjustmentRetList
InventoryCostAdjustmentRet = CType(response.Detail,IInventoryCostAdjustmentRetList)
for z=0 to InventoryCostAdjustmentRet.Count-1
WalkInventoryCostAdjustmentRet(InventoryCostAdjustmentRet.GetAt(z))
Next z
End If
End If
End If
Next j
End Sub
Public Sub WalkInventoryCostAdjustmentRet(InventoryCostAdjustmentRet as IInventoryCostAdjustmentRet)
if (InventoryCostAdjustmentRet is nothing) then
Exit Sub
End If
'Go through all the elements of IInventoryCostAdjustmentRetList
'Get value of TxnID
if ( not InventoryCostAdjustmentRet.TxnID is nothing) then
Dim TxnID967 as String
TxnID967 = InventoryCostAdjustmentRet.TxnID.GetValue()
End If
'Get value of TimeCreated
if ( not InventoryCostAdjustmentRet.TimeCreated is nothing) then
Dim TimeCreated968 as DateTime
TimeCreated968 = InventoryCostAdjustmentRet.TimeCreated.GetValue()
End If
'Get value of TimeModified
if ( not InventoryCostAdjustmentRet.TimeModified is nothing) then
Dim TimeModified969 as DateTime
TimeModified969 = InventoryCostAdjustmentRet.TimeModified.GetValue()
End If
'Get value of Associate
if ( not InventoryCostAdjustmentRet.Associate is nothing) then
Dim Associate970 as String
Associate970 = InventoryCostAdjustmentRet.Associate.GetValue()
End If
'Get value of Comments
if ( not InventoryCostAdjustmentRet.Comments is nothing) then
Dim Comments971 as String
Comments971 = InventoryCostAdjustmentRet.Comments.GetValue()
End If
'Get value of CostDifference
if ( not InventoryCostAdjustmentRet.CostDifference is nothing) then
Dim CostDifference972 as Double
CostDifference972 = InventoryCostAdjustmentRet.CostDifference.GetValue()
End If
'Get value of HistoryDocStatus
if ( not InventoryCostAdjustmentRet.HistoryDocStatus is nothing) then
Dim HistoryDocStatus973 as ENHistoryDocStatus
HistoryDocStatus973 = InventoryCostAdjustmentRet.HistoryDocStatus.GetValue()
End If
'Get value of InventoryAdjustmentNumber
if ( not InventoryCostAdjustmentRet.InventoryAdjustmentNumber is nothing) then
Dim InventoryAdjustmentNumber974 as Integer
InventoryAdjustmentNumber974 = InventoryCostAdjustmentRet.InventoryAdjustmentNumber.GetValue()
End If
'Get value of InventoryAdjustmentSource
if ( not InventoryCostAdjustmentRet.InventoryAdjustmentSource is nothing) then
Dim InventoryAdjustmentSource975 as ENInventoryAdjustmentSource
InventoryAdjustmentSource975 = InventoryCostAdjustmentRet.InventoryAdjustmentSource.GetValue()
End If
'Get value of ItemsCount
if ( not InventoryCostAdjustmentRet.ItemsCount is nothing) then
Dim ItemsCount976 as Integer
ItemsCount976 = InventoryCostAdjustmentRet.ItemsCount.GetValue()
End If
'Get value of NewCost
if ( not InventoryCostAdjustmentRet.NewCost is nothing) then
Dim NewCost977 as Double
NewCost977 = InventoryCostAdjustmentRet.NewCost.GetValue()
End If
'Get value of OldCost
if ( not InventoryCostAdjustmentRet.OldCost is nothing) then
Dim OldCost978 as Double
OldCost978 = InventoryCostAdjustmentRet.OldCost.GetValue()
End If
'Get value of QuickBooksFlag
if ( not InventoryCostAdjustmentRet.QuickBooksFlag is nothing) then
Dim QuickBooksFlag979 as ENQuickBooksFlag
QuickBooksFlag979 = InventoryCostAdjustmentRet.QuickBooksFlag.GetValue()
End If
'Get value of Reason
if ( not InventoryCostAdjustmentRet.Reason is nothing) then
Dim Reason980 as String
Reason980 = InventoryCostAdjustmentRet.Reason.GetValue()
End If
'Get value of StoreExchangeStatus
if ( not InventoryCostAdjustmentRet.StoreExchangeStatus is nothing) then
Dim StoreExchangeStatus981 as ENStoreExchangeStatus
StoreExchangeStatus981 = InventoryCostAdjustmentRet.StoreExchangeStatus.GetValue()
End If
'Get value of StoreNumber
if ( not InventoryCostAdjustmentRet.StoreNumber is nothing) then
Dim StoreNumber982 as Integer
StoreNumber982 = InventoryCostAdjustmentRet.StoreNumber.GetValue()
End If
'Get value of TxnDate
if ( not InventoryCostAdjustmentRet.TxnDate is nothing) then
Dim TxnDate983 as DateTime
TxnDate983 = InventoryCostAdjustmentRet.TxnDate.GetValue()
End If
'Get value of TxnState
if ( not InventoryCostAdjustmentRet.TxnState is nothing) then
Dim TxnState984 as ENTxnState
TxnState984 = InventoryCostAdjustmentRet.TxnState.GetValue()
End If
'Get value of Workstation
if ( not InventoryCostAdjustmentRet.Workstation is nothing) then
Dim Workstation985 as Integer
Workstation985 = InventoryCostAdjustmentRet.Workstation.GetValue()
End If
if (not InventoryCostAdjustmentRet.InventoryCostAdjustmentItemRetList is nothing)
Dim i986 as Integer
for i986 = 0 to InventoryCostAdjustmentRet.InventoryCostAdjustmentItemRetList.Count - 1
Dim InventoryCostAdjustmentItemRet as IInventoryCostAdjustmentItemRet
InventoryCostAdjustmentItemRet = InventoryCostAdjustmentRet.InventoryCostAdjustmentItemRetList.GetAt(i986)
'Get value of ListID
if ( not InventoryCostAdjustmentItemRet.ListID is nothing) then
Dim ListID987 as String
ListID987 = InventoryCostAdjustmentItemRet.ListID.GetValue()
End If
'Get value of CostDifference
if ( not InventoryCostAdjustmentItemRet.CostDifference is nothing) then
Dim CostDifference988 as Double
CostDifference988 = InventoryCostAdjustmentItemRet.CostDifference.GetValue()
End If
'Get value of NewCost
if ( not InventoryCostAdjustmentItemRet.NewCost is nothing) then
Dim NewCost989 as Double
NewCost989 = InventoryCostAdjustmentItemRet.NewCost.GetValue()
End If
'Get value of NumberOfBaseUnits
if ( not InventoryCostAdjustmentItemRet.NumberOfBaseUnits is nothing) then
Dim NumberOfBaseUnits990 as Double
NumberOfBaseUnits990 = InventoryCostAdjustmentItemRet.NumberOfBaseUnits.GetValue()
End If
'Get value of OldCost
if ( not InventoryCostAdjustmentItemRet.OldCost is nothing) then
Dim OldCost991 as Double
OldCost991 = InventoryCostAdjustmentItemRet.OldCost.GetValue()
End If
'Get value of UnitOfMeasure
if ( not InventoryCostAdjustmentItemRet.UnitOfMeasure is nothing) then
Dim UnitOfMeasure992 as String
UnitOfMeasure992 = InventoryCostAdjustmentItemRet.UnitOfMeasure.GetValue()
End If
Next i986
End If
if (not InventoryCostAdjustmentRet.DataExtRetList is nothing)
Dim i993 as Integer
for i993 = 0 to InventoryCostAdjustmentRet.DataExtRetList.Count - 1
Dim DataExtRet as IDataExtRet
DataExtRet = InventoryCostAdjustmentRet.DataExtRetList.GetAt(i993)
'Get value of OwnerID
Dim OwnerID994 as String
OwnerID994 = DataExtRet.OwnerID.GetValue()
'Get value of DataExtName
Dim DataExtName995 as String
DataExtName995 = DataExtRet.DataExtName.GetValue()
'Get value of DataExtType
Dim DataExtType996 as ENDataExtType
DataExtType996 = DataExtRet.DataExtType.GetValue()
'Get value of DataExtValue
Dim DataExtValue997 as String
DataExtValue997 = DataExtRet.DataExtValue.GetValue()
Next i993
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 | //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 SampleInventoryCostAdjustmentQuery { public void DoInventoryCostAdjustmentQuery() { 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; BuildInventoryCostAdjustmentQueryRq(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; WalkInventoryCostAdjustmentQueryRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildInventoryCostAdjustmentQueryRq(IMsgSetRequest requestMsgSet) { IInventoryCostAdjustmentQuery InventoryCostAdjustmentQueryRq= requestMsgSet.AppendInventoryCostAdjustmentQueryRq(); //Set attributes //Set field value for metaData InventoryCostAdjustmentQueryRq.metaData.SetValue(ENmetaData.mdMetaDataAndResponseData); //Set field value for iterator InventoryCostAdjustmentQueryRq.iterator.SetValue(ENiterator.itStart); //Set field value for iteratorID InventoryCostAdjustmentQueryRq.iteratorID.SetValue("{D7355385-A17B-4f5d-B34D-F34C79C3E6FC}"); //Set field value for MaxReturned InventoryCostAdjustmentQueryRq.MaxReturned.SetValue(6); //Set field value for OwnerIDList //May create more than one of these if needed InventoryCostAdjustmentQueryRq.OwnerIDList.Add(Guid.NewGuid().ToString()); //Set field value for TxnID InventoryCostAdjustmentQueryRq.TxnID.SetValue("200000-1011023419"); string ORTimeCreatedFiltersElementType998 = "TimeCreatedFilter"; if (ORTimeCreatedFiltersElementType998 == "TimeCreatedFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for TimeCreated InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedFilter.TimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORTimeCreatedFiltersElementType998 == "TimeCreatedRangeFilter") { //Set field value for FromTimeCreated InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.FromTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToTimeCreated InventoryCostAdjustmentQueryRq.ORTimeCreatedFilters.TimeCreatedRangeFilter.ToTimeCreated.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } string ORTimeModifiedFiltersElementType999 = "TimeModifiedFilter"; if (ORTimeModifiedFiltersElementType999 == "TimeModifiedFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for TimeModified InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedFilter.TimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORTimeModifiedFiltersElementType999 == "TimeModifiedRangeFilter") { //Set field value for FromTimeModified InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.FromTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToTimeModified InventoryCostAdjustmentQueryRq.ORTimeModifiedFilters.TimeModifiedRangeFilter.ToTimeModified.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } string ORAssociateFiltersElementType1000 = "AssociateFilter"; if (ORAssociateFiltersElementType1000 == "AssociateFilter") { //Set field value for MatchStringCriterion InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual); //Set field value for Associate InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateFilter.Associate.SetValue("ab"); } if (ORAssociateFiltersElementType1000 == "AssociateRangeFilter") { //Set field value for FromAssociate InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.FromAssociate.SetValue("ab"); //Set field value for ToAssociate InventoryCostAdjustmentQueryRq.ORAssociateFilters.AssociateRangeFilter.ToAssociate.SetValue("ab"); } string ORCommentsFiltersElementType1001 = "CommentsFilter"; if (ORCommentsFiltersElementType1001 == "CommentsFilter") { //Set field value for MatchStringCriterion InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual); //Set field value for Comments InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsFilter.Comments.SetValue("ab"); } if (ORCommentsFiltersElementType1001 == "CommentsRangeFilter") { //Set field value for FromComments InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.FromComments.SetValue("ab"); //Set field value for ToComments InventoryCostAdjustmentQueryRq.ORCommentsFilters.CommentsRangeFilter.ToComments.SetValue("ab"); } //Set field value for HistoryDocStatus InventoryCostAdjustmentQueryRq.HistoryDocStatus.SetValue(ENHistoryDocStatus.hdsRegular); string ORInventoryAdjustmentNumberFiltersElementType1002 = "InventoryAdjustmentNumberFilter"; if (ORInventoryAdjustmentNumberFiltersElementType1002 == "InventoryAdjustmentNumberFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for InventoryAdjustmentNumber InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberFilter.InventoryAdjustmentNumber.SetValue(6); } if (ORInventoryAdjustmentNumberFiltersElementType1002 == "InventoryAdjustmentNumberRangeFilter") { //Set field value for FromInventoryAdjustmentNumber InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.FromInventoryAdjustmentNumber.SetValue(6); //Set field value for ToInventoryAdjustmentNumber InventoryCostAdjustmentQueryRq.ORInventoryAdjustmentNumberFilters.InventoryAdjustmentNumberRangeFilter.ToInventoryAdjustmentNumber.SetValue(6); } //Set field value for InventoryAdjustmentSource InventoryCostAdjustmentQueryRq.InventoryAdjustmentSource.SetValue(ENInventoryAdjustmentSource.iasManual); string ORItemsCountFiltersElementType1003 = "ItemsCountFilter"; if (ORItemsCountFiltersElementType1003 == "ItemsCountFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for ItemsCount InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountFilter.ItemsCount.SetValue(6); } if (ORItemsCountFiltersElementType1003 == "ItemsCountRangeFilter") { //Set field value for FromItemsCount InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.FromItemsCount.SetValue(6); //Set field value for ToItemsCount InventoryCostAdjustmentQueryRq.ORItemsCountFilters.ItemsCountRangeFilter.ToItemsCount.SetValue(6); } string ORNewCostFiltersElementType1004 = "NewCostFilter"; if (ORNewCostFiltersElementType1004 == "NewCostFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for NewCost InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostFilter.NewCost.SetValue(10.01); } if (ORNewCostFiltersElementType1004 == "NewCostRangeFilter") { //Set field value for FromNewCost InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostRangeFilter.FromNewCost.SetValue(10.01); //Set field value for ToNewCost InventoryCostAdjustmentQueryRq.ORNewCostFilters.NewCostRangeFilter.ToNewCost.SetValue(10.01); } string OROldCostFiltersElementType1005 = "OldCostFilter"; if (OROldCostFiltersElementType1005 == "OldCostFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for OldCost InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostFilter.OldCost.SetValue(10.01); } if (OROldCostFiltersElementType1005 == "OldCostRangeFilter") { //Set field value for FromOldCost InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostRangeFilter.FromOldCost.SetValue(10.01); //Set field value for ToOldCost InventoryCostAdjustmentQueryRq.OROldCostFilters.OldCostRangeFilter.ToOldCost.SetValue(10.01); } //Set field value for QuickBooksFlag InventoryCostAdjustmentQueryRq.QuickBooksFlag.SetValue(ENQuickBooksFlag.qbfNotPosted); string ORReasonFiltersElementType1006 = "ReasonFilter"; if (ORReasonFiltersElementType1006 == "ReasonFilter") { //Set field value for MatchStringCriterion InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonFilter.MatchStringCriterion.SetValue(ENMatchStringCriterion.mscEqual); //Set field value for Reason InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonFilter.Reason.SetValue("ab"); } if (ORReasonFiltersElementType1006 == "ReasonRangeFilter") { //Set field value for FromReason InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.FromReason.SetValue("ab"); //Set field value for ToReason InventoryCostAdjustmentQueryRq.ORReasonFilters.ReasonRangeFilter.ToReason.SetValue("ab"); } //Set field value for StoreExchangeStatus InventoryCostAdjustmentQueryRq.StoreExchangeStatus.SetValue(ENStoreExchangeStatus.sesModified); string ORStoreNumberFiltersElementType1007 = "StoreNumberFilter"; if (ORStoreNumberFiltersElementType1007 == "StoreNumberFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for StoreNumber InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberFilter.StoreNumber.SetValue(6); } if (ORStoreNumberFiltersElementType1007 == "StoreNumberRangeFilter") { //Set field value for FromStoreNumber InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.FromStoreNumber.SetValue(6); //Set field value for ToStoreNumber InventoryCostAdjustmentQueryRq.ORStoreNumberFilters.StoreNumberRangeFilter.ToStoreNumber.SetValue(6); } string ORTxnDateFiltersElementType1008 = "TxnDateFilter"; if (ORTxnDateFiltersElementType1008 == "TxnDateFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for TxnDate InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateFilter.TxnDate.SetValue(DateTime.Parse("12/15/2007")); } if (ORTxnDateFiltersElementType1008 == "TxnDateRangeFilter") { //Set field value for FromTxnDate InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for ToTxnDate InventoryCostAdjustmentQueryRq.ORTxnDateFilters.TxnDateRangeFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")); } //Set field value for TxnState InventoryCostAdjustmentQueryRq.TxnState.SetValue(ENTxnState.tsNormal); string ORWorkstationFiltersElementType1009 = "WorkstationFilter"; if (ORWorkstationFiltersElementType1009 == "WorkstationFilter") { //Set field value for MatchNumericCriterion InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.MatchNumericCriterion.SetValue(ENMatchNumericCriterion.mncLessThan); //Set field value for Workstation InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationFilter.Workstation.SetValue(6); } if (ORWorkstationFiltersElementType1009 == "WorkstationRangeFilter") { //Set field value for FromWorkstation InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.FromWorkstation.SetValue(6); //Set field value for ToWorkstation InventoryCostAdjustmentQueryRq.ORWorkstationFilters.WorkstationRangeFilter.ToWorkstation.SetValue(6); } //Set field value for IncludeRetElementList //May create more than one of these if needed InventoryCostAdjustmentQueryRq.IncludeRetElementList.Add("ab"); } void WalkInventoryCostAdjustmentQueryRs(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.rtInventoryCostAdjustmentQueryRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IInventoryCostAdjustmentRetList InventoryCostAdjustmentRet = (IInventoryCostAdjustmentRetList)response.Detail; for(int z=0; z < InventoryCostAdjustmentRet.Count; z++) { WalkInventoryCostAdjustmentRet(InventoryCostAdjustmentRet.GetAt(z)); } } } } } } void WalkInventoryCostAdjustmentRet(IInventoryCostAdjustmentRet InventoryCostAdjustmentRet) { if (InventoryCostAdjustmentRet == null) return; //Go through all the elements of IInventoryCostAdjustmentRetList //Get value of TxnID if (InventoryCostAdjustmentRet.TxnID != null) { string TxnID1010 = (string)InventoryCostAdjustmentRet.TxnID.GetValue(); } //Get value of TimeCreated if (InventoryCostAdjustmentRet.TimeCreated != null) { DateTime TimeCreated1011 = (DateTime)InventoryCostAdjustmentRet.TimeCreated.GetValue(); } //Get value of TimeModified if (InventoryCostAdjustmentRet.TimeModified != null) { DateTime TimeModified1012 = (DateTime)InventoryCostAdjustmentRet.TimeModified.GetValue(); } //Get value of Associate if (InventoryCostAdjustmentRet.Associate != null) { string Associate1013 = (string)InventoryCostAdjustmentRet.Associate.GetValue(); } //Get value of Comments if (InventoryCostAdjustmentRet.Comments != null) { string Comments1014 = (string)InventoryCostAdjustmentRet.Comments.GetValue(); } //Get value of CostDifference if (InventoryCostAdjustmentRet.CostDifference != null) { double CostDifference1015 = (double)InventoryCostAdjustmentRet.CostDifference.GetValue(); } //Get value of HistoryDocStatus if (InventoryCostAdjustmentRet.HistoryDocStatus != null) { ENHistoryDocStatus HistoryDocStatus1016 = (ENHistoryDocStatus)InventoryCostAdjustmentRet.HistoryDocStatus.GetValue(); } //Get value of InventoryAdjustmentNumber if (InventoryCostAdjustmentRet.InventoryAdjustmentNumber != null) { int InventoryAdjustmentNumber1017 = (int)InventoryCostAdjustmentRet.InventoryAdjustmentNumber.GetValue(); } //Get value of InventoryAdjustmentSource if (InventoryCostAdjustmentRet.InventoryAdjustmentSource != null) { ENInventoryAdjustmentSource InventoryAdjustmentSource1018 = (ENInventoryAdjustmentSource)InventoryCostAdjustmentRet.InventoryAdjustmentSource.GetValue(); } //Get value of ItemsCount if (InventoryCostAdjustmentRet.ItemsCount != null) { int ItemsCount1019 = (int)InventoryCostAdjustmentRet.ItemsCount.GetValue(); } //Get value of NewCost if (InventoryCostAdjustmentRet.NewCost != null) { double NewCost1020 = (double)InventoryCostAdjustmentRet.NewCost.GetValue(); } //Get value of OldCost if (InventoryCostAdjustmentRet.OldCost != null) { double OldCost1021 = (double)InventoryCostAdjustmentRet.OldCost.GetValue(); } //Get value of QuickBooksFlag if (InventoryCostAdjustmentRet.QuickBooksFlag != null) { ENQuickBooksFlag QuickBooksFlag1022 = (ENQuickBooksFlag)InventoryCostAdjustmentRet.QuickBooksFlag.GetValue(); } //Get value of Reason if (InventoryCostAdjustmentRet.Reason != null) { string Reason1023 = (string)InventoryCostAdjustmentRet.Reason.GetValue(); } //Get value of StoreExchangeStatus if (InventoryCostAdjustmentRet.StoreExchangeStatus != null) { ENStoreExchangeStatus StoreExchangeStatus1024 = (ENStoreExchangeStatus)InventoryCostAdjustmentRet.StoreExchangeStatus.GetValue(); } //Get value of StoreNumber if (InventoryCostAdjustmentRet.StoreNumber != null) { int StoreNumber1025 = (int)InventoryCostAdjustmentRet.StoreNumber.GetValue(); } //Get value of TxnDate if (InventoryCostAdjustmentRet.TxnDate != null) { DateTime TxnDate1026 = (DateTime)InventoryCostAdjustmentRet.TxnDate.GetValue(); } //Get value of TxnState if (InventoryCostAdjustmentRet.TxnState != null) { ENTxnState TxnState1027 = (ENTxnState)InventoryCostAdjustmentRet.TxnState.GetValue(); } //Get value of Workstation if (InventoryCostAdjustmentRet.Workstation != null) { int Workstation1028 = (int)InventoryCostAdjustmentRet.Workstation.GetValue(); } if (InventoryCostAdjustmentRet.InventoryCostAdjustmentItemRetList != null) { for (int i1029 = 0; i1029 < InventoryCostAdjustmentRet.InventoryCostAdjustmentItemRetList.Count; i1029++) { IInventoryCostAdjustmentItemRet InventoryCostAdjustmentItemRet = InventoryCostAdjustmentRet.InventoryCostAdjustmentItemRetList.GetAt(i1029); //Get value of ListID if (InventoryCostAdjustmentItemRet.ListID != null) { string ListID1030 = (string)InventoryCostAdjustmentItemRet.ListID.GetValue(); } //Get value of CostDifference if (InventoryCostAdjustmentItemRet.CostDifference != null) { double CostDifference1031 = (double)InventoryCostAdjustmentItemRet.CostDifference.GetValue(); } //Get value of NewCost if (InventoryCostAdjustmentItemRet.NewCost != null) { double NewCost1032 = (double)InventoryCostAdjustmentItemRet.NewCost.GetValue(); } //Get value of NumberOfBaseUnits if (InventoryCostAdjustmentItemRet.NumberOfBaseUnits != null) { int NumberOfBaseUnits1033 = (int)InventoryCostAdjustmentItemRet.NumberOfBaseUnits.GetValue(); } //Get value of OldCost if (InventoryCostAdjustmentItemRet.OldCost != null) { double OldCost1034 = (double)InventoryCostAdjustmentItemRet.OldCost.GetValue(); } //Get value of UnitOfMeasure if (InventoryCostAdjustmentItemRet.UnitOfMeasure != null) { string UnitOfMeasure1035 = (string)InventoryCostAdjustmentItemRet.UnitOfMeasure.GetValue(); } } } if (InventoryCostAdjustmentRet.DataExtRetList != null) { for (int i1036 = 0; i1036 < InventoryCostAdjustmentRet.DataExtRetList.Count; i1036++) { IDataExtRet DataExtRet = InventoryCostAdjustmentRet.DataExtRetList.GetAt(i1036); //Get value of OwnerID string OwnerID1037 = (string)DataExtRet.OwnerID.GetValue(); //Get value of DataExtName string DataExtName1038 = (string)DataExtRet.DataExtName.GetValue(); //Get value of DataExtType ENDataExtType DataExtType1039 = (ENDataExtType)DataExtRet.DataExtType.GetValue(); //Get value of DataExtValue string DataExtValue1040 = (string)DataExtRet.DataExtValue.GetValue(); } } } } } |