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