public void DepartureLoad(string CommPartnerId, string TransactionId, DepartureLoadDoc aDepartureLoadDoc) { this.Invoke("DepartureLoad", new object[] { CommPartnerId, TransactionId, aDepartureLoadDoc }); return; }
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)); }