public void DepartureLoad(string CommPartnerId, string TransactionId, DepartureLoadDoc aDepartureLoadDoc)
 {
     this.Invoke("DepartureLoad", new object[] {
         CommPartnerId,
         TransactionId,
         aDepartureLoadDoc
     });
     return;
 }
Esempio n. 2
0
        public ArrayList InternalProcess(System.String MsgOutId)
        {
            ArrayList aDepartureLoadDocList = new ArrayList();

            IDataReader r = db.ExecuteReader(
                "select" +
                " MSG_OUT_DEPLOAD.DEPARTURELOADIDENTITY" +
                ",MSG_OUT_DEPLOAD.CUSTOMERORDERSEQUENCE" +
                ",MSG_OUT_DEPLOAD.DEPARTUREIDENTITY" +
                ",MSG_OUT_DEPLOAD.ROUTEIDENTITY" +
                ",MSG_OUT_DEPLOAD.ROUTEDESCRIPTION" +
                ",MSG_OUT_DEPLOAD.CUSTOMERORDERRELEASEDATETIME" +
                ",MSG_OUT_DEPLOAD.CUSTOMERORDERSTOPDATETIME" +
                ",MSG_OUT_DEPLOAD.PLANNEDDEPARTUREDATETIME" +
                ",MSG_OUT_DEPLOAD.ESTIMATEDARRIVALDATETIME" +
                ",MSG_OUT_DEPLOAD.LASTCHAINDEPARTUREIDENTITY" +
                ",MSG_OUT_DEPLOAD.WHYNODEPARTUREMESSAGE" +
                " from   MSG_OUT_DEPLOAD" +
                " where  MSG_OUT_DEPLOAD.MSG_OUT_ID = '" + MsgOutId + "'");

            while (r.Read())
            {
                DepartureLoadDoc aDepartureLoadDoc = new DepartureLoadDoc();

                aDepartureLoadDoc.OPCODE = "1";

                if (r.IsDBNull(0))
                {
                    aDepartureLoadDoc.DepartureLoadIdentity = null;
                }
                else
                {
                    aDepartureLoadDoc.DepartureLoadIdentity = r.GetString(0);
                }

                if (r.IsDBNull(1))
                {
                    aDepartureLoadDoc.CustomerOrderSequence = null;
                }
                else
                {
                    aDepartureLoadDoc.CustomerOrderSequence = Convert.ToDouble(r.GetDecimal(1));
                }

                if (r.IsDBNull(2))
                {
                    aDepartureLoadDoc.DepartureIdentity = null;
                }
                else
                {
                    aDepartureLoadDoc.DepartureIdentity = r.GetString(2);
                }

                if (r.IsDBNull(3))
                {
                    aDepartureLoadDoc.RouteIdentity = null;
                }
                else
                {
                    aDepartureLoadDoc.RouteIdentity = r.GetString(3);
                }

                if (r.IsDBNull(4))
                {
                    aDepartureLoadDoc.RouteDescription = null;
                }
                else
                {
                    aDepartureLoadDoc.RouteDescription = r.GetString(4);
                }

                if (r.IsDBNull(5))
                {
                    aDepartureLoadDoc.CustomerOrderReleaseDateTime = null;
                }
                else
                {
                    aDepartureLoadDoc.CustomerOrderReleaseDateTime = DateTime.SpecifyKind(r.GetDateTime(5), DateTimeKind.Local);
                }

                if (r.IsDBNull(6))
                {
                    aDepartureLoadDoc.CustomerOrderStopDateTime = null;
                }
                else
                {
                    aDepartureLoadDoc.CustomerOrderStopDateTime = DateTime.SpecifyKind(r.GetDateTime(6), DateTimeKind.Local);
                }

                if (r.IsDBNull(7))
                {
                    aDepartureLoadDoc.PlannedDepartureDateTime = null;
                }
                else
                {
                    aDepartureLoadDoc.PlannedDepartureDateTime = DateTime.SpecifyKind(r.GetDateTime(7), DateTimeKind.Local);
                }

                if (r.IsDBNull(8))
                {
                    aDepartureLoadDoc.EstimatedArrivalDateTime = null;
                }
                else
                {
                    aDepartureLoadDoc.EstimatedArrivalDateTime = DateTime.SpecifyKind(r.GetDateTime(8), DateTimeKind.Local);
                }

                if (r.IsDBNull(9))
                {
                    aDepartureLoadDoc.LastChainDepartureIdentity = null;
                }
                else
                {
                    aDepartureLoadDoc.LastChainDepartureIdentity = r.GetString(9);
                }

                if (r.IsDBNull(10))
                {
                    aDepartureLoadDoc.WhyNoDepartureMessage = null;
                }
                else
                {
                    aDepartureLoadDoc.WhyNoDepartureMessage = r.GetString(10);
                }

                aDepartureLoadDocList.Add(aDepartureLoadDoc);
            }

            r.Close();


            return(aDepartureLoadDocList);
        }
 public System.IAsyncResult BeginDepartureLoad(string CommPartnerId, string TransactionId, DepartureLoadDoc aDepartureLoadDoc, System.AsyncCallback callback, object asyncState)
 {
     return(this.BeginInvoke("DepartureLoad", new object[] {
         CommPartnerId,
         TransactionId,
         aDepartureLoadDoc
     }, callback, asyncState));
 }