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