// 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"]));
}
