static public ArrayList Read(IDataReader reader) { ArrayList aOrderQuantitiesList = new ArrayList(); while (reader.Read()) { OrderQuantities aOrderQuantities = new OrderQuantities(); aOrderQuantities.ClientIdentity = reader.GetString(0); aOrderQuantities.OrderNumber = reader.GetString(1); aOrderQuantities.OrderSequence = reader.GetInt32(2); aOrderQuantities.SubSequence = reader.GetInt32(3); aOrderQuantities.TotalNoOfLines = Convert.ToDouble(reader.GetDecimal(4)); aOrderQuantities.PickedNoOfLines = Convert.ToDouble(reader.GetDecimal(5)); aOrderQuantities.EstimatedWeight = Convert.ToDouble(reader.GetDecimal(6)); aOrderQuantities.EstimatedVolume = Convert.ToDouble(reader.GetDecimal(7)); aOrderQuantities.PlannedNoOfPallets = Convert.ToDouble(reader.GetDecimal(8)); aOrderQuantities.PlannedNoOfLowestUM = Convert.ToDouble(reader.GetDecimal(9)); aOrderQuantities.PlannedVolume = Convert.ToDouble(reader.GetDecimal(10)); aOrderQuantities.PlannedWeight = Convert.ToDouble(reader.GetDecimal(11)); aOrderQuantities.PickedNoOfPallets = Convert.ToDouble(reader.GetDecimal(12)); aOrderQuantities.PickedNoOfLowestUM = Convert.ToDouble(reader.GetDecimal(13)); aOrderQuantities.PickedVolume = Convert.ToDouble(reader.GetDecimal(14)); aOrderQuantities.PickedWeight = Convert.ToDouble(reader.GetDecimal(15)); aOrderQuantitiesList.Add(aOrderQuantities); } reader.Close(); return(aOrderQuantitiesList); }
public CustomerOrderInfoDoc GetCustomerOrderInfo( string ChannelId, string LanguageId, string ClientIdentity, string OrderNumber, Nullable <int> OrderSequence) { CustomerOrderInfoDoc res = new CustomerOrderInfoDoc(); try { BeginWebmethod(ChannelId); try { WebServicesQuery pkg = new WebServicesQuery(GetDataBase()); IDataReader aCustomerOrderRdr = null; IDataReader aCustomerWorkOrderRdr = null; IDataReader aDepartureRdr = null; IDataReader aOrderQuantitiesRdr = null; IDataReader aCustomerOrderRowRdr = null; pkg.GetCustomerOrderInfo(ClientIdentity, OrderNumber, OrderSequence, LanguageId, out aCustomerOrderRdr, out aCustomerWorkOrderRdr, out aDepartureRdr, out aOrderQuantitiesRdr, out aCustomerOrderRowRdr); ArrayList aCustomerOrderList = CustomerOrder.Read(aCustomerOrderRdr); ArrayList aCustomerWorkOrderList = CustomerWorkOrder.Read(aCustomerWorkOrderRdr); ArrayList aDepartureList = Departure.Read(aDepartureRdr); ArrayList aOrderQuantitiesList = OrderQuantities.Read(aOrderQuantitiesRdr); ArrayList aCustomerOrderRowList = CustomerOrderRow.Read(aCustomerOrderRowRdr); res.aCustomerOrderList = aCustomerOrderList.ToArray(typeof(CustomerOrder)) as CustomerOrder[]; res.aCustomerWorkOrderList = aCustomerWorkOrderList.ToArray(typeof(CustomerWorkOrder)) as CustomerWorkOrder[]; res.aDepartureList = aDepartureList.ToArray(typeof(Departure)) as Departure[]; res.aOrderQuantitiesList = aOrderQuantitiesList.ToArray(typeof(OrderQuantities)) as OrderQuantities[]; res.aCustomerOrderRowList = aCustomerOrderRowList.ToArray(typeof(CustomerOrderRow)) as CustomerOrderRow[]; GetDataBase().Commit(); } catch (Exception e) { try { GetDataBase().Rollback(); } catch (Exception) { } Exception InternalError = new Exception("DataError: Error processing data", e); throw (InternalError); } } finally { EndWebmethod(); } return(res); }