/* */ IDataReadble IDataReadble.Read(IDataReader reader) { Route x = new Route(); int i = 0; string DepartureIdentity = ReaderHelper.GetString(reader, i++); x.VehicleIdentity = ReaderHelper.GetString(reader, i++); Nullable <DateTime> dtm = ReaderHelper.GetDateTime(reader, i++); if (dtm != null) { x.EstimatedTimeOfDeparture = (DateTime)dtm; } else { x.EstimatedTimeOfDeparture = DateTime.MinValue; } x.RouteIdentity = ReaderHelper.GetString(reader, i++); x.Name = ReaderHelper.GetString(reader, i++); x.TotalUnloadingTimeInSeconds = ReaderHelper.GetInt32(reader, i++); x.TotalDrivingTimeInSeconds = ReaderHelper.GetInt32(reader, i++); x.TotalTimeInSeconds = ReaderHelper.GetInt32(reader, i++); x.TotalDistance = (double?)ReaderHelper.GetDecimal(reader, i++); return(x); }
/* * type WarehouseRow_Type is record * ( stockNo WH.WHID%type * ,name WH.WHNAME%type ); */ IDataReadble IDataReadble.Read(IDataReader reader) { RouteStop x = new RouteStop(); int i = 0; x.StopSequence = ReaderHelper.GetInt32(reader, i++); x.DistanceFromPreviousStop = ReaderHelper.GetInt32(reader, i++); Nullable <DateTime> dtm = ReaderHelper.GetDateTime(reader, i++); if (dtm != null) { x.EstimatedArrivalTime = (DateTime)dtm; } else { x.EstimatedArrivalTime = DateTime.MinValue; } x.Instructions = ReaderHelper.GetString(reader, i++); x.TotalUnloadingTimeInSeconds = ReaderHelper.GetInt32(reader, i++); x.TotalDrivingTimeInSeconds = ReaderHelper.GetInt32(reader, i++); x.TotalTimeInSeconds = ReaderHelper.GetInt32(reader, i++); x.Country = ReaderHelper.GetString(reader, i++); x.NodeIdentity = ReaderHelper.GetString(reader, i++); x.CustomerIdentity = ReaderHelper.GetString(reader, i++); x.Name1 = ReaderHelper.GetString(reader, i++); x.Name2 = ReaderHelper.GetString(reader, i++); x.Name3 = ReaderHelper.GetString(reader, i++); x.Name4 = ReaderHelper.GetString(reader, i++); x.Name5 = ReaderHelper.GetString(reader, i++); x.Address1 = ReaderHelper.GetString(reader, i++); x.Address2 = ReaderHelper.GetString(reader, i++); x.Address3 = ReaderHelper.GetString(reader, i++); x.Address4 = ReaderHelper.GetString(reader, i++); x.City = ReaderHelper.GetString(reader, i++); x.ZipCode = ReaderHelper.GetString(reader, i++); x.CountryCode = ReaderHelper.GetString(reader, i++); x.Region = ReaderHelper.GetString(reader, i++); x.Latitude = ReaderHelper.GetString(reader, i++); x.Longitude = ReaderHelper.GetString(reader, i++); x.ContactPerson = ReaderHelper.GetString(reader, i++); x.ContactPhone = ReaderHelper.GetString(reader, i++); x.ContactEmail = ReaderHelper.GetString(reader, i++); return(x); }
IDataReadble IDataReadble.Read(IDataReader reader) { order x = new order(); int i = 0; string ot = ReaderHelper.GetString(reader, i++); // orderType if (ot == "CO3PL") { x.orderType = orderType.CO3PL; } else if (ot == "PO") { x.orderType = orderType.PO; } else { throw new Exception("Order type <" + ot + "> not supported"); } x.orderTypeSpecified = true; x.coNo = ReaderHelper.GetString(reader, i++); x.customer = ReaderHelper.GetString(reader, i++); x.cuRef = ReaderHelper.GetString(reader, i++); x.yourCono = ReaderHelper.GetString(reader, i++); x.reqDelDate = ReaderHelper.GetDateTime(reader, i++); x.text = ReaderHelper.GetString(reader, i++); x.coMark = ReaderHelper.GetString(reader, i++); x.poid = ReaderHelper.GetString(reader, i++); x.poSeq = ReaderHelper.GetInt32(reader, i++); x.receivingWhid = ReaderHelper.GetString(reader, i++); x.shipFromPartyid = ReaderHelper.GetString(reader, i++); x.shipFromPartyQualifier = ReaderHelper.GetString(reader, i++); x.whName = ReaderHelper.GetString(reader, i++); x.methodOfShipmentId = ReaderHelper.GetString(reader, i++); x.methodOfShipmentName = ReaderHelper.GetString(reader, i++); x.customerOrderTypeId = ReaderHelper.GetString(reader, i++); x.customerOrderTypeName = ReaderHelper.GetString(reader, i++); return(x); }
IDataReadble IDataReadble.Read(IDataReader reader) { orderLine x = new orderLine(); int i = 0; x.partNo = ReaderHelper.GetString(reader, i++); x.partDescr1 = ReaderHelper.GetString(reader, i++); x.partDescr2 = ReaderHelper.GetString(reader, i++); x.custPartNo = ReaderHelper.GetString(reader, i++); x.custPartDescr1 = ReaderHelper.GetString(reader, i++); x.custPartDescr2 = ReaderHelper.GetString(reader, i++); x.text = ReaderHelper.GetString(reader, i++); x.qtyUnit = ReaderHelper.GetDecimal(reader, i++); x.originalQtyUnit = ReaderHelper.GetDecimal(reader, i++); x.unit = ReaderHelper.GetString(reader, i++); x.unitDescr = ReaderHelper.GetString(reader, i++); x.linePos = ReaderHelper.GetInt32(reader, i++); x.lineSeq = ReaderHelper.GetInt32(reader, i++); x.lineId = ReaderHelper.GetInt32(reader, i++); x.sellingUnit = ReaderHelper.GetString(reader, i++); x.sellingUnitDesc = ReaderHelper.GetString(reader, i++); x.delDate = ReaderHelper.GetDateTime(reader, i++); i = GetLineStatus(reader, x, i); x.rcvQtyUnit = ReaderHelper.GetDecimal(reader, i++); /* * x.blockCod = ReaderHelper.GetString(reader, i++); * x.serial = ReaderHelper.GetString(reader, i++); * x.serNumb = ReaderHelper.GetString(reader, i++); * x.prodLot = ReaderHelper.GetString(reader, i++); * x.promotn = ReaderHelper.GetString(reader, i++); * x.storBat = ReaderHelper.GetString(reader, i++); * x.prodLotReq = ReaderHelper.GetString(reader, i++); */ return(x); }