// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( myDataReader["ItemId"].ToString() , MainClass.ToDate(TableName, myDataReader["EffectTime"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerIssue"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerUnitOrder"])); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( MainClass.ToInt(TableName, myDataReader["PriceIid"]) , myDataReader["ItemID"].ToString() , myDataReader["CostCenter"].ToString() , MainClass.ToDecimal(TableName, myDataReader["SellPrice"]) , MainClass.ToInt(TableName, myDataReader["IsDefault"]) , MainClass.ToInt(TableName, myDataReader["CDM"])); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( MainClass.ToDate(TableName, myDataReader["DayOfMonth"]) , myDataReader["DeviceName"].ToString() , MainClass.ToInt(TableName, myDataReader["BtnBoardNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnPocketNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnColumnNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnDoorNbr"]) , MainClass.ToInt(TableName, myDataReader["ChassisSeqNbr"]) , MainClass.ToInt(TableName, myDataReader["SubDrawer"]) , MainClass.ToInt(TableName, myDataReader["PktIid"]) , myDataReader["PktDescriptor"].ToString() , MainClass.ToInt(TableName, myDataReader["PktParQty"]) , MainClass.ToInt(TableName, myDataReader["PktRefillPoint"]) , MainClass.ToInt(TableName, myDataReader["PktCritLow"]) , MainClass.ToInt(TableName, myDataReader["PktCurQty"]) , myDataReader["ItemId"].ToString() , myDataReader["ItemName"].ToString() , myDataReader["ItemAltId"].ToString() , myDataReader["ItemAltId2"].ToString() , MainClass.ToInt(TableName, myDataReader["UOIperUOR"]) , MainClass.ToInt(TableName, myDataReader["UOIperUOO"]) , MainClass.ToInt(TableName, myDataReader["NetUseQty"]) , MainClass.ToInt(TableName, myDataReader["StillLoaded"]) , MainClass.ToDate(TableName, myDataReader["LoadDate"]) , MainClass.ToInt(TableName, myDataReader["UsedToday"]) , MainClass.ToInt(TableName, myDataReader["StockOutCounter"]) , MainClass.ToInt(TableName, myDataReader["CritLowCounter"]) , MainClass.ToInt(TableName, myDataReader["RefillCounter"]) , MainClass.ToInt(TableName, myDataReader["RefillTotalQty"]) , MainClass.ToInt(TableName, myDataReader["VendCounter"]) , MainClass.ToInt(TableName, myDataReader["VendTotalQty"]) , MainClass.ToInt(TableName, myDataReader["ReturnCounter"]) , MainClass.ToInt(TableName, myDataReader["ReturnTotalQty"]) , MainClass.ToInt(TableName, myDataReader["ExpireItemCounter"]) , MainClass.ToInt(TableName, myDataReader["ExpireItemTotalQty"]) , MainClass.ToInt(TableName, myDataReader["DiscrepCounter"]) , MainClass.ToInt(TableName, myDataReader["DiscrepOverQty"]) , MainClass.ToInt(TableName, myDataReader["DiscrepShortQty"]) , MainClass.ToInt(TableName, myDataReader["RemRetDiscCounter"]) , MainClass.ToInt(TableName, myDataReader["RemRetDiscQty"]) , MainClass.ToInt(TableName, myDataReader["TransferCounter"]) , MainClass.ToInt(TableName, myDataReader["TransferTotalQty"]) , MainClass.ToInt(TableName, myDataReader["NullTrxCounter"]) , MainClass.ToInt(TableName, myDataReader["InventoryCounter"]) , MainClass.ToInt(TableName, myDataReader["CancelTrxCounter"]) , MainClass.ToInt(TableName, myDataReader["AddedToMonthly"]) , MainClass.ToDecimal(TableName, myDataReader["TxTotalCost"]) , MainClass.ToDecimal(TableName, myDataReader["SellPrice"]) , MainClass.ToInt(TableName, myDataReader["CDM"])); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( MainClass.ToDate(TableName, myDataReader["TxTime"]) , MainClass.ToInt(TableName, myDataReader["NSequenceNum"]) , MainClass.ToInt(TableName, myDataReader["TxType"]) , MainClass.ToInt(TableName, myDataReader["NRetryCount"]) , MainClass.ToInt(TableName, myDataReader["NAddress"]) , MainClass.ToInt(TableName, myDataReader["NBin"]) , MainClass.ToInt(TableName, myDataReader["NAmount"]) , MainClass.ToInt(TableName, myDataReader["NPktFinal"]) , MainClass.ToInt(TableName, myDataReader["NPktBegin"]) , MainClass.ToInt(TableName, myDataReader["NPktEdit"]) , MainClass.ToInt(TableName, myDataReader["NPktIid"]) , MainClass.ToInt(TableName, myDataReader["NPatientIid"]) , MainClass.ToInt(TableName, myDataReader["NItemIid"]) , MainClass.ToInt(TableName, myDataReader["NStationIid"]) , MainClass.ToInt(TableName, myDataReader["NStationAreaIid"]) , MainClass.ToInt(TableName, myDataReader["TempUser"]) , MainClass.ToInt(TableName, myDataReader["NStationTotal"]) , myDataReader["Descriptor"].ToString() , myDataReader["StrSerial"].ToString() , myDataReader["StrLot"].ToString() , myDataReader["UserName"].ToString() , myDataReader["UserId"].ToString() , MainClass.ToDecimal(TableName, myDataReader["TxCost"]) , MainClass.ToDate(TableName, myDataReader["PostDate"]) , MainClass.ToInt(TableName, myDataReader["LProcedureIid"]) , MainClass.ToInt(TableName, myDataReader["LServiceIid"]) , MainClass.ToInt(TableName, myDataReader["LPhysicianIid"]) , MainClass.ToInt(TableName, myDataReader["BProcedureMgmt"]) , MainClass.ToInt(TableName, myDataReader["NewLotSerial"]) , MainClass.ToInt(TableName, myDataReader["BVendforCase"]) , MainClass.ToInt(TableName, myDataReader["NKitIid"]) , MainClass.ToInt(TableName, myDataReader["BForeignVend"]) , MainClass.ToInt(TableName, myDataReader["DoorNo"]) , MainClass.ToInt(TableName, myDataReader["DevNo"]) , MainClass.ToInt(TableName, myDataReader["ChassisId"]) , MainClass.ToInt(TableName, myDataReader["Column"]) , MainClass.ToInt(TableName, myDataReader["PocketIid"]) , myDataReader["ItemID"].ToString() , myDataReader["ForeignStationName"].ToString() , MainClass.ToInt(TableName, myDataReader["RefillOrderedQty"]) , MainClass.ToInt(TableName, myDataReader["RefillShippedQty"]) , MainClass.ToInt(TableName, myDataReader["NMessageType"]) , myDataReader["RefillId"].ToString() , myDataReader["StrReason"].ToString()); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( MainClass.ToInt(TableName, myDataReader["PickTicketIid"]) , myDataReader["OrderNum"].ToString() , myDataReader["PatientId"].ToString() , myDataReader["CaseId"].ToString() , myDataReader["ProcedureCode"].ToString() , myDataReader["itemId"].ToString() , myDataReader["itemName"].ToString() , MainClass.ToInt(TableName, myDataReader["trxQty"]) , myDataReader["itemUnitOfIssue"].ToString() , MainClass.ToDecimal(TableName, myDataReader["costPerIssue"]) , MainClass.ToDate(TableName, myDataReader["trxTime"]) , MainClass.ToInt(TableName, myDataReader["filledQty"])); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( MainClass.ToInt(TableName, myDataReader["itemIid"]) , myDataReader["itemName"].ToString() , myDataReader["itemShortDesc"].ToString() , myDataReader["itemId"].ToString() , myDataReader["itemAltId"].ToString() , myDataReader["itemAltId2"].ToString() , MainClass.ToInt(TableName, myDataReader["itemClass"]) , MainClass.ToInt(TableName, myDataReader["itemConsign"]) , MainClass.ToInt(TableName, myDataReader["itemStock"]) , MainClass.ToInt(TableName, myDataReader["itemTrackLot"]) , MainClass.ToInt(TableName, myDataReader["itemTrackSerial"]) , MainClass.ToInt(TableName, myDataReader["itemBillOnly"]) , MainClass.ToInt(TableName, myDataReader["itemType"]) , myDataReader["itemUnitOfIssue"].ToString() , myDataReader["itemUnitOfRefill"].ToString() , myDataReader["itemUnitOfOrder"].ToString() , MainClass.ToInt(TableName, myDataReader["itemReOrderRatio"]) , MainClass.ToInt(TableName, myDataReader["itemRefillRatio"]) , MainClass.ToInt(TableName, myDataReader["UOIPerUOO"]) , MainClass.ToInt(TableName, myDataReader["UOIPerUOR"]) , MainClass.ToInt(TableName, myDataReader["autoResolveDiscrep"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerIssue"]) , MainClass.ToDecimal(TableName, myDataReader["costPerUnitRefill"]) , MainClass.ToDecimal(TableName, myDataReader["costPerUnitOrder"]) , MainClass.ToInt(TableName, myDataReader["itemIsChargeable"]) , MainClass.ToInt(TableName, myDataReader["leadTime"]) , MainClass.ToInt(TableName, myDataReader["orderCycle"]) , MainClass.ToInt(TableName, myDataReader["safetyDays"]) , MainClass.ToInt(TableName, myDataReader["inclusionDays"]) , MainClass.ToDate(TableName, myDataReader["last_modified"]) , MainClass.ToInt(TableName, myDataReader["tempItem"]) , MainClass.ToInt(TableName, myDataReader["isPerishable"])); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( myDataReader["DeviceName"].ToString() , MainClass.ToDate(TableName, myDataReader["TxTime"]) , MainClass.ToInt(TableName, myDataReader["BtnDoorNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnBoardNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnBoardSeq"]) , MainClass.ToInt(TableName, myDataReader["SubDrawer"]) , myDataReader["PktDescriptor"].ToString() , MainClass.ToInt(TableName, myDataReader["TrxSeq"]) , MainClass.ToInt(TableName, myDataReader["ChassisSeqNbr"]) , MainClass.ToInt(TableName, myDataReader["BtnColumnNbr"]) , MainClass.ToInt(TableName, myDataReader["MsgTypeId"]) , myDataReader["ItemName"].ToString() , myDataReader["ItemShortDesc"].ToString() , myDataReader["ItemAlias"].ToString() , myDataReader["ItemId"].ToString() , myDataReader["ItemAltId"].ToString() , myDataReader["ItemAltId2"].ToString() , MainClass.ToInt(TableName, myDataReader["ItemClass"]) , myDataReader["ItemClassName"].ToString() , MainClass.ToInt(TableName, myDataReader["ItemType"]) , MainClass.ToInt(TableName, myDataReader["ExpBeginCount"]) , MainClass.ToInt(TableName, myDataReader["ActualBeginCount"]) , MainClass.ToInt(TableName, myDataReader["TrxQty"]) , MainClass.ToInt(TableName, myDataReader["PktPhysMaxQty"]) , MainClass.ToInt(TableName, myDataReader["PktParQty"]) , MainClass.ToInt(TableName, myDataReader["PktRefillPoint"]) , MainClass.ToInt(TableName, myDataReader["PktCritLow"]) , MainClass.ToInt(TableName, myDataReader["StnTotal"]) , MainClass.ToDate(TableName, myDataReader["PostDateTime"]) , myDataReader["LotNumber"].ToString() , myDataReader["SerialNumber"].ToString() , myDataReader["VendorName"].ToString() , myDataReader["UserName"].ToString() , myDataReader["UserId"].ToString() , MainClass.ToInt(TableName, myDataReader["TempUser"]) , myDataReader["WitnName"].ToString() , myDataReader["WitnId"].ToString() , myDataReader["PtLastName"].ToString() , myDataReader["PtFirstName"].ToString() , myDataReader["PtMiddleName"].ToString() , myDataReader["PtId"].ToString() , myDataReader["PtAltId1"].ToString() , myDataReader["PtAltId2"].ToString() , myDataReader["PtComment1"].ToString() , myDataReader["PtComment2"].ToString() , myDataReader["NUnitName"].ToString() , myDataReader["Room"].ToString() , myDataReader["Bed"].ToString() , MainClass.ToInt(TableName, myDataReader["PtType"]) , MainClass.ToInt(TableName, myDataReader["EADT"]) , MainClass.ToInt(TableName, myDataReader["TempPatient"]) , myDataReader["Waste"].ToString() , myDataReader["PtMergeId"].ToString() , MainClass.ToInt(TableName, myDataReader["HasBeenArchived"]) , MainClass.ToDate(TableName, myDataReader["NextExpireTime"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerIssue"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerUnitRefill"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerUnitOrder"]) , myDataReader["AreaName"].ToString() , myDataReader["ItemUnitOfIssue"].ToString() , myDataReader["ItemUnitOfRefill"].ToString() , myDataReader["ItemUnitOfOrder"].ToString() , MainClass.ToInt(TableName, myDataReader["TrxUOM"]) , myDataReader["AdmitDrName"].ToString() , myDataReader["AttendDrName"].ToString() , myDataReader["KitId"].ToString() , myDataReader["FacilityCode"].ToString() , MainClass.ToInt(TableName, myDataReader["OrigVendSeq"]) , MainClass.ToDate(TableName, myDataReader["OrigVendDate"]) , MainClass.ToInt(TableName, myDataReader["IsBillable"]) , myDataReader["CostCenter"].ToString() , myDataReader["VendorPartNumber"].ToString() , MainClass.ToInt(TableName, myDataReader["TimeBias"]) , MainClass.ToInt(TableName, myDataReader["ItemIsChargeable"]) , MainClass.ToInt(TableName, myDataReader["ItemStock"]) , myDataReader["RefillId"].ToString() , MainClass.ToInt(TableName, myDataReader["RefillOrderedQty"]) , MainClass.ToInt(TableName, myDataReader["RefillShippedQty"]) , MainClass.ToInt(TableName, myDataReader["BtnPocketNbr"]) , myDataReader["XfrToStation"].ToString() , myDataReader["CaseId"].ToString() , myDataReader["CaseName"].ToString() , myDataReader["CaseCart"].ToString()); }
// make a TableData object from a SADataReader record #if !NO_ASA static void MakeDataRec(SADataReader myDataReader, out TableData data) { data = new TableData( myDataReader["RefillId"].ToString() , MainClass.ToDate(TableName, myDataReader["RefillQueTime"]) , myDataReader["StnName"].ToString() , myDataReader["ItemId"].ToString() , myDataReader["AreaName"].ToString() , MainClass.ToInt(TableName, myDataReader["Zone"]) , MainClass.ToInt(TableName, myDataReader["BtnBoardNbr"]) , MainClass.ToInt(TableName, myDataReader["SubDrawer"]) , myDataReader["PktDescriptor"].ToString() , MainClass.ToInt(TableName, myDataReader["BtnPocketNbr"]) , myDataReader["ItemName"].ToString() , myDataReader["ItemShortDesc"].ToString() , myDataReader["ItemAltId"].ToString() , myDataReader["ItemAltId2"].ToString() , MainClass.ToInt(TableName, myDataReader["ItemClass"]) , myDataReader["ItemClassName"].ToString() , myDataReader["PrimPickAreaName"].ToString() , myDataReader["SecPickAreaName"].ToString() , MainClass.ToInt(TableName, myDataReader["ItemType"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerIssue"]) , MainClass.ToDecimal(TableName, myDataReader["CostPerUnitRefill"]) , myDataReader["ItemUnitOfIssue"].ToString() , MainClass.ToInt(TableName, myDataReader["ItemConsign"]) , MainClass.ToInt(TableName, myDataReader["ItemStock"]) , myDataReader["ItemUnitOfRefill"].ToString() , MainClass.ToInt(TableName, myDataReader["UOIPerUOR"]) , MainClass.ToInt(TableName, myDataReader["ItemRefillRatio"]) , MainClass.ToInt(TableName, myDataReader["PktIid"]) , MainClass.ToInt(TableName, myDataReader["PktPhysMaxQty"]) , MainClass.ToInt(TableName, myDataReader["PktParQty"]) , MainClass.ToInt(TableName, myDataReader["PktRefillPoint"]) , MainClass.ToInt(TableName, myDataReader["PktCurQty"]) , MainClass.ToInt(TableName, myDataReader["PktCritLow"]) , myDataReader["VendorName"].ToString() , myDataReader["VendorPartNumber"].ToString() , MainClass.ToInt(TableName, myDataReader["SendRefillMsg"]) , MainClass.ToInt(TableName, myDataReader["ItemIsStandard"]) , MainClass.ToInt(TableName, myDataReader["RefillOrderedQty"]) , MainClass.ToInt(TableName, myDataReader["RefillShippedQty"]) , MainClass.ToInt(TableName, myDataReader["RefillBackOrderQty"]) , MainClass.ToInt(TableName, myDataReader["RefillDone"]) , MainClass.ToDate(TableName, myDataReader["RefillDoneTime"]) , MainClass.ToDate(TableName, myDataReader["DeliveryDate"]) , MainClass.ToInt(TableName, myDataReader["OrderMethod"]) , myDataReader["RefillUserName"].ToString() , myDataReader["RefillUserId"].ToString() , myDataReader["RefillOrderStatus"].ToString() , MainClass.ToDate(TableName, myDataReader["RefillBackOrderEta"]) , myDataReader["PrimPickAreaLoc"].ToString() , myDataReader["SecPickAreaLoc"].ToString() , MainClass.ToInt(TableName, myDataReader["BtnBoardSeq"]) , MainClass.ToInt(TableName, myDataReader["BtnDoorNbr"]) , myDataReader["PocketUnitOfIssue"].ToString() , MainClass.ToInt(TableName, myDataReader["PocketUOIRatio"]) , MainClass.ToInt(TableName, myDataReader["SystemType"]) , MainClass.ToInt(TableName, myDataReader["CabinetId"]) , MainClass.ToInt(TableName, myDataReader["Drawer"]) , myDataReader["StorageUnitName"].ToString() , myDataReader["SubUnitName"].ToString() , MainClass.ToInt(TableName, myDataReader["BinNumber"]) , myDataReader["ItemCatName"].ToString() , MainClass.ToInt(TableName, myDataReader["PoIsComplete"])); }