public static PurchaseOrderHeader RetrieveByKey(EpTransaction epTran, string orderNumber) { PurchaseOrderHeader entity = null; string whereClause = " EBELN='" + DataManager.EscapeSQL(orderNumber) + "' "; Collection <PurchaseOrderHeader> entities = Retrieve(epTran, whereClause, ""); if (entities.Count > 0) { entity = entities[0]; } return(entity); }
public static Supplier RetrieveByKey(EpTransaction epTran, string supplierID) { Supplier entity = null; string whereClause = " LIFNR='" + DataManager.EscapeSQL(supplierID) + "' "; Collection <Supplier> entities = Retrieve(epTran, whereClause, ""); if (entities.Count > 0) { entity = entities[0]; } return(entity); }
public static PurchaseOrderItem RetrieveByKey(EpTransaction epTran, string orderNumber, string SequenceNO) { PurchaseOrderItem entity = null; string whereClause = " EBELN='" + DataManager.EscapeSQL(orderNumber) + "' "; whereClause += "AND EBELP='" + DataManager.EscapeSQL(SequenceNO) + "'"; Collection <PurchaseOrderItem> entities = Retrieve(epTran, whereClause, ""); if (entities.Count > 0) { entity = entities[0]; } return(entity); }
public static ContractItem RetrieveByKey(EpTransaction epTran, string contractNumber, string contractItemSequence) { ContractItem entity = null; string whereClause = " EBELN='" + DataManager.EscapeSQL(contractNumber) + "' "; whereClause += "AND EBELP='" + DataManager.EscapeSQL(contractItemSequence) + "'"; Collection <ContractItem> entities = Retrieve(epTran, whereClause, ""); if (entities.Count > 0) { entity = entities[0]; } return(entity); }
public static PurchaseOrderServiceTask RetrieveByKey(EpTransaction epTran, string ServiceLineNumber, string ServiceLineSequence) { PurchaseOrderServiceTask entity = null; string whereClause = " LBLN1='" + DataManager.EscapeSQL(ServiceLineNumber) + "' "; whereClause += "AND EXTROW='" + DataManager.EscapeSQL(ServiceLineSequence) + "'"; Collection <PurchaseOrderServiceTask> entities = Retrieve(epTran, whereClause, ""); if (entities.Count > 0) { entity = entities[0]; } return(entity); }
public static PurchaseOrderSubcontractComponent RetrieveByKey(EpTransaction epTran, string orderNumber, string ItemSequenceNumber, string ComponentSequenceNumber) { PurchaseOrderSubcontractComponent entity = null; string whereClause = " EBELN='" + DataManager.EscapeSQL(orderNumber) + "' "; whereClause += "AND EBELP='" + DataManager.EscapeSQL(ItemSequenceNumber) + "' "; whereClause += "AND COMPL='" + DataManager.EscapeSQL(ComponentSequenceNumber) + "'"; Collection <PurchaseOrderSubcontractComponent> entities = Retrieve(epTran, whereClause, ""); if (entities.Count > 0) { entity = entities[0]; } return(entity); }