public RemoveDepartureInsert(WSBase owner)
: base(owner)
{
StringBuilder s = new StringBuilder("insert into EXT_MSG_OUT_REMOVE_DEP ( ");
s.Append(" MSG_IN_ID");
s.Append(",OPCODE");
s.Append(",DepartureIdentity");
s.Append(" ) values ( ");
s.Append(" :MSG_IN_ID");
s.Append(",:OPCODE");
s.Append(",:DepartureIdentity");
s.Append(" )");
fStmt.CommandText = s.ToString();
fStmt.Parameters.Add(StringParam("MSG_IN_ID", 35));
fStmt.Parameters.Add(StringParam("OPCODE", 1));
fStmt.Parameters.Add(StringParam("DepartureIdentity", 35));
fStmt.Prepare();
}
public DepartureTransportTypeInsert(WSBase owner)
: base(owner)
{
StringBuilder s = new StringBuilder("insert into EXT_MSG_OUT_DEPARTURE_TRP ( ");
s.Append(" MSG_IN_ID");
s.Append(",OPCODE");
s.Append(",DepartureIdentity");
s.Append(",ProductTransportIdentity");
s.Append(" ) values ( ");
s.Append(" :MSG_IN_ID");
s.Append(",:OPCODE");
s.Append(",:DepartureIdentity");
s.Append(",:ProductTransportIdentity");
s.Append(" )");
fStmt.CommandText = s.ToString();
fStmt.Parameters.Add(StringParam("MSG_IN_ID", 35));
fStmt.Parameters.Add(StringParam("OPCODE", 1));
fStmt.Parameters.Add(StringParam("DepartureIdentity", 35));
fStmt.Parameters.Add(StringParam("ProductTransportIdentity", 5));
fStmt.Prepare();
}
public ConfirmInsert(WSBase owner)
: base(owner)
{
StringBuilder s = new StringBuilder("insert into EXT_MSG_OUT_CONFIRM ( ");
s.Append(" MSG_IN_ID");
s.Append(",OPCODE");
s.Append(",Transaction_id");
s.Append(",Transaction_Status");
s.Append(",ErrCode");
s.Append(",Errmsg");
s.Append(" ) values ( ");
s.Append(" :MSG_IN_ID");
s.Append(",:OPCODE");
s.Append(",:Transaction_id");
s.Append(",:Transaction_Status");
s.Append(",:ErrCode");
s.Append(",:Errmsg");
s.Append(" )");
fStmt.CommandText = s.ToString();
fStmt.Parameters.Add(StringParam("MSG_IN_ID", 35));
fStmt.Parameters.Add(StringParam("OPCODE", 1));
fStmt.Parameters.Add(StringParam("Transaction_id", 35));
fStmt.Parameters.Add(StringParam("Transaction_Status", 1));
fStmt.Parameters.Add(StringParam("ErrCode", 12));
fStmt.Parameters.Add(StringParam("Errmsg", 1024));
fStmt.Prepare();
}
public DepartureInsert(WSBase owner)
: base(owner)
{
StringBuilder s = new StringBuilder("insert into EXT_MSG_OUT_DEPARTURE ( ");
s.Append(" MSG_IN_ID");
s.Append(",OPCODE");
s.Append(",DepartureIdentity");
s.Append(",DepartureIdentityReference");
s.Append(",FromNodeIdentity");
s.Append(",DeliveryMethod");
s.Append(",RouteIdentity");
s.Append(",RouteDescription");
s.Append(",CustomerOrderReleaseDateTime");
s.Append(",CustomerOrderStopDateTime");
s.Append(",TransitStopDateTime");
s.Append(",PlannedDepartureDateTime");
s.Append(",CheckProductTransportType");
s.Append(",VehicleIdentity");
s.Append(" ) values ( ");
s.Append(" :MSG_IN_ID");
s.Append(",:OPCODE");
s.Append(",:DepartureIdentity");
s.Append(",:DepartureIdentityReference");
s.Append(",:FromNodeIdentity");
s.Append(",:DeliveryMethod");
s.Append(",:RouteIdentity");
s.Append(",:RouteDescription");
s.Append(",:CustomerOrderReleaseDateTime");
s.Append(",:CustomerOrderStopDateTime");
s.Append(",:TransitStopDateTime");
s.Append(",:PlannedDepartureDateTime");
s.Append(",:CheckProductTransportType");
s.Append(",:VehicleIdentity");
s.Append(" )");
fStmt.CommandText = s.ToString();
fStmt.Parameters.Add(StringParam("MSG_IN_ID", 35));
fStmt.Parameters.Add(StringParam("OPCODE", 1));
fStmt.Parameters.Add(StringParam("DepartureIdentity", 35));
fStmt.Parameters.Add(StringParam("DepartureIdentityReference", 35));
fStmt.Parameters.Add(StringParam("FromNodeIdentity", 35));
fStmt.Parameters.Add(StringParam("DeliveryMethod", 17));
fStmt.Parameters.Add(StringParam("RouteIdentity", 17));
fStmt.Parameters.Add(StringParam("RouteDescription", 35));
fStmt.Parameters.Add(DateParam("CustomerOrderReleaseDateTime"));
fStmt.Parameters.Add(DateParam("CustomerOrderStopDateTime"));
fStmt.Parameters.Add(DateParam("TransitStopDateTime"));
fStmt.Parameters.Add(DateParam("PlannedDepartureDateTime"));
fStmt.Parameters.Add(StringParam("CheckProductTransportType", 1));
fStmt.Parameters.Add(StringParam("VehicleIdentity", 35));
fStmt.Prepare();
}
public DepartureLoadInsert(WSBase owner)
: base(owner)
{
StringBuilder s = new StringBuilder("insert into EXT_MSG_OUT_DEPLOAD ( ");
s.Append(" MSG_IN_ID");
s.Append(",OPCODE");
s.Append(",DepartureLoadIdentity");
s.Append(",CustomerOrderSequence");
s.Append(",DepartureIdentity");
s.Append(",RouteIdentity");
s.Append(",RouteDescription");
s.Append(",CustomerOrderReleaseDateTime");
s.Append(",CustomerOrderStopDateTime");
s.Append(",PlannedDepartureDateTime");
s.Append(",EstimatedArrivalDateTime");
s.Append(",LastChainDepartureIdentity");
s.Append(",WhyNoDepartureMessage");
s.Append(" ) values ( ");
s.Append(" :MSG_IN_ID");
s.Append(",:OPCODE");
s.Append(",:DepartureLoadIdentity");
s.Append(",:CustomerOrderSequence");
s.Append(",:DepartureIdentity");
s.Append(",:RouteIdentity");
s.Append(",:RouteDescription");
s.Append(",:CustomerOrderReleaseDateTime");
s.Append(",:CustomerOrderStopDateTime");
s.Append(",:PlannedDepartureDateTime");
s.Append(",:EstimatedArrivalDateTime");
s.Append(",:LastChainDepartureIdentity");
s.Append(",:WhyNoDepartureMessage");
s.Append(" )");
fStmt.CommandText = s.ToString();
fStmt.Parameters.Add(StringParam("MSG_IN_ID", 35));
fStmt.Parameters.Add(StringParam("OPCODE", 1));
fStmt.Parameters.Add(StringParam("DepartureLoadIdentity", 35));
fStmt.Parameters.Add(NumberParam("CustomerOrderSequence", 10, 0));
fStmt.Parameters.Add(StringParam("DepartureIdentity", 35));
fStmt.Parameters.Add(StringParam("RouteIdentity", 17));
fStmt.Parameters.Add(StringParam("RouteDescription", 35));
fStmt.Parameters.Add(DateParam("CustomerOrderReleaseDateTime"));
fStmt.Parameters.Add(DateParam("CustomerOrderStopDateTime"));
fStmt.Parameters.Add(DateParam("PlannedDepartureDateTime"));
fStmt.Parameters.Add(DateParam("EstimatedArrivalDateTime"));
fStmt.Parameters.Add(StringParam("LastChainDepartureIdentity", 35));
fStmt.Parameters.Add(StringParam("WhyNoDepartureMessage", 2000));
fStmt.Prepare();
}
public ModifyDepartureLoadInsert(WSBase owner)
: base(owner)
{
StringBuilder s = new StringBuilder("insert into EXT_MSG_OUT_MODIFY_DEPLOAD ( ");
s.Append(" MSG_IN_ID");
s.Append(",OPCODE");
s.Append(",DepartureLoadIdentity");
s.Append(",FromNodeIdentity");
s.Append(",DepartureIdentity");
s.Append(",RouteIdentity");
s.Append(",RouteDescription");
s.Append(",CustomerOrderReleaseDateTime");
s.Append(",CustomerOrderStopDateTime");
s.Append(",PlannedDepartureDateTime");
s.Append(",EstimatedArrivalDateTime");
s.Append(" ) values ( ");
s.Append(" :MSG_IN_ID");
s.Append(",:OPCODE");
s.Append(",:DepartureLoadIdentity");
s.Append(",:FromNodeIdentity");
s.Append(",:DepartureIdentity");
s.Append(",:RouteIdentity");
s.Append(",:RouteDescription");
s.Append(",:CustomerOrderReleaseDateTime");
s.Append(",:CustomerOrderStopDateTime");
s.Append(",:PlannedDepartureDateTime");
s.Append(",:EstimatedArrivalDateTime");
s.Append(" )");
fStmt.CommandText = s.ToString();
fStmt.Parameters.Add(StringParam("MSG_IN_ID", 35));
fStmt.Parameters.Add(StringParam("OPCODE", 1));
fStmt.Parameters.Add(StringParam("DepartureLoadIdentity", 35));
fStmt.Parameters.Add(StringParam("FromNodeIdentity", 35));
fStmt.Parameters.Add(StringParam("DepartureIdentity", 35));
fStmt.Parameters.Add(StringParam("RouteIdentity", 17));
fStmt.Parameters.Add(StringParam("RouteDescription", 35));
fStmt.Parameters.Add(DateParam("CustomerOrderReleaseDateTime"));
fStmt.Parameters.Add(DateParam("CustomerOrderStopDateTime"));
fStmt.Parameters.Add(DateParam("PlannedDepartureDateTime"));
fStmt.Parameters.Add(DateParam("EstimatedArrivalDateTime"));
fStmt.Prepare();
}
public DepartureNodeInsert(WSBase owner)
: base(owner)
{
StringBuilder s = new StringBuilder("insert into EXT_MSG_OUT_DEPARTURE_NODE ( ");
s.Append(" MSG_IN_ID");
s.Append(",OPCODE");
s.Append(",DepartureIdentity");
s.Append(",SEQNUM");
s.Append(",ToNodeIdentity");
s.Append(",EstimatedArrivalDateTime");
s.Append(",ReceiveTransitGoods");
s.Append(" ) values ( ");
s.Append(" :MSG_IN_ID");
s.Append(",:OPCODE");
s.Append(",:DepartureIdentity");
s.Append(",:SEQNUM");
s.Append(",:ToNodeIdentity");
s.Append(",:EstimatedArrivalDateTime");
s.Append(",:ReceiveTransitGoods");
s.Append(" )");
fStmt.CommandText = s.ToString();
fStmt.Parameters.Add(StringParam("MSG_IN_ID", 35));
fStmt.Parameters.Add(StringParam("OPCODE", 1));
fStmt.Parameters.Add(StringParam("DepartureIdentity", 35));
fStmt.Parameters.Add(NumberParam("SEQNUM", 5, 0));
fStmt.Parameters.Add(StringParam("ToNodeIdentity", 35));
fStmt.Parameters.Add(DateParam("EstimatedArrivalDateTime"));
fStmt.Parameters.Add(StringParam("ReceiveTransitGoods", 1));
fStmt.Prepare();
}
public SegmentImpl(WSBase owner)
{
fStmt = owner.GetDataBase().GetConnection().CreateCommand();
fStmt.CommandType = System.Data.CommandType.Text;
}
