Показать сообщение отдельно
Старый 05.05.2008, 23:53   #11  
wojzeh is offline
wojzeh
Участник
Аватар для wojzeh
Соотечественники
 
675 / 517 (19) +++++++
Регистрация: 27.04.2006
Адрес: Montreal
\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:getTotalAmountCurByCustTable (DS: CustTable)
\Forms\DynLinkCustTransForm\Data Sources\CustTable\Methods\getTotalAmountCurByCustTable
------------------------------------------------------------------------------------------------------------------------------------------------
X++:
display AmountCurDebCred getTotalAmountCurByCustTable(CustTable _CustTable)
{
    ;
    select sum(AmountCur) from ctr
        where ctr.AccountNum == _CustTable.AccountNum;

    return ctr.AmountCur;
}
\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:getTotalAmountCurByCustTrans (DS: CustTrans)
\Forms\DynLinkCustTransForm\Data Sources\CustTrans\Methods\getTotalAmountCurByCustTrans
------------------------------------------------------------------------------------------------------------------------------------------------
X++:
display AmountCurDebCred getTotalAmountCurByCustTrans(CustTrans _CustTrans)
{
    ;
    select sum(AmountCur) from ctr
        where ctr.AccountNum == _CustTrans.AccountNum;

    return ctr.AmountCur;
}
\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:getTotalAmountCurByCustTable1 (DS: CustTrans)
\Forms\DynLinkCustTransForm\Data Sources\CustTrans\Methods\getTotalAmountCurByCustTable
----------------------------------------------------------------------------------------------------------------------------------------------
X++:
display AmountCurDebCred getTotalAmountCurByCustTable()
{
    ;
    select sum(AmountCur) from ctr
        where ctr.AccountNum == CustTable.AccountNum;

    return ctr.AmountCur;
}
\Forms\DynLinkCustTransForm\Designs\Design\[Group:Group]\[Group:Group2]\RealEdit:totalAmountCur (DS: CustTable)
\Data Dictionary\Tables\CustTable\Methods\totalAmountCur
--------------------------------------------------------------------------------------
X++:
display AmountCur totalAmountCur()
{
    CustTrans  custTrans;
    ;
    select sum (AmountCur) from custTrans
    where custTrans.AccountNum == this.accountnum;

    return custTrans.AmountCur;

}
табличный метод вызывался сначала без кеширования, затем с кешированием. вот результаты профайлинга:

__________________
Felix nihil admirari