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); }
static public ArrayList MakeTestData() { ArrayList aOrderQuantitiesList = new ArrayList(); for (int i = 0; i < 10; i++) { OrderQuantities aOrderQuantities = new OrderQuantities(); aOrderQuantities.ClientIdentity = "IMISTD"; aOrderQuantities.OrderNumber = "1234"; aOrderQuantities.OrderSequence = i; aOrderQuantities.SubSequence = i; aOrderQuantities.TotalNoOfLines = 4; aOrderQuantities.PickedNoOfLines = 5; aOrderQuantities.EstimatedWeight = 6; aOrderQuantities.EstimatedVolume = 7; aOrderQuantities.PlannedNoOfPallets = 8; aOrderQuantities.PlannedNoOfLowestUM = 9; aOrderQuantities.PlannedVolume = 10; aOrderQuantities.PlannedWeight = 11; aOrderQuantities.PickedNoOfPallets = 12; aOrderQuantities.PickedNoOfLowestUM = 13; aOrderQuantities.PickedVolume = 14; aOrderQuantities.PickedWeight = 15; aOrderQuantitiesList.Add(aOrderQuantities); } return(aOrderQuantitiesList); }
public CustomerOrderInfoDoc GetCustomerOrderInfo( string PartnerName, string LanguageId, string ClientIdentity, string OrderNumber, Nullable <int> OrderSequence) { if ((PartnerName == "") || (PartnerName == null)) { // test mode! CustomerOrderInfoDoc testres = new CustomerOrderInfoDoc(); ArrayList aCustomerOrderList = CustomerOrder.MakeTestData(); ArrayList aCustomerWorkOrderList = CustomerWorkOrder.MakeTestData(); ArrayList aDepartureList = Departure.MakeTestData(); ArrayList aOrderQuantitiesList = OrderQuantities.MakeTestData(); ArrayList aCustomerOrderRowList = CustomerOrderRow.MakeTestData(); testres.aCustomerOrderList = aCustomerOrderList.ToArray(typeof(CustomerOrder)) as CustomerOrder[]; testres.aCustomerWorkOrderList = aCustomerWorkOrderList.ToArray(typeof(CustomerWorkOrder)) as CustomerWorkOrder[]; testres.aDepartureList = aDepartureList.ToArray(typeof(Departure)) as Departure[]; testres.aOrderQuantitiesList = aOrderQuantitiesList.ToArray(typeof(OrderQuantities)) as OrderQuantities[]; testres.aCustomerOrderRowList = aCustomerOrderRowList.ToArray(typeof(CustomerOrderRow)) as CustomerOrderRow[]; return(testres); } CustomerOrderInfoDoc res = new CustomerOrderInfoDoc(); using (DBHelper dbHelper = new DBHelper(PartnerName)) { try { WebServicesQuery pkg = new WebServicesQuery(dbHelper.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[]; dbHelper.GetDataBase().Commit(); } catch (Exception e) { try { dbHelper.GetDataBase().Rollback(); } catch (Exception) { } Exception InternalError = new Exception("DataError: Error processing data", e); throw (InternalError); } } return(res); }