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));
}
