Devart Forums

Code: Select all

CREATE OR REPLACE PACKAGE BODY USER_SETUP.PROCESSING_MESSAGES
IS
    function get_statistics_pm(date_point IN date)
        RETURN SYS_REFCURSOR
    IS
        l_cursor   SYS_REFCURSOR;
    BEGIN
        OPEN l_cursor FOR
            select t.name_type, t.descriptions,
                sum(case when (r.state not in (-1, 0)) then 1 else 0 end) as count_success,
                sum(case when (r.state in (-1, 0)) then 1 else 0 end) as count_error
        from bc_request_list r
            left join BC_TYPE_REQUEST t on t.id = r.type_request
        where TRUNC(r.date_stamp) = date_point
        group by t.name_type, t.descriptions;

        RETURN l_cursor;
    END;
END;

Code: Select all

/// <summary>
/// There are no comments for GetStatisticsPm in the schema.
/// </summary>
[Function(Name=@"USER_SETUP.PROCESSING_MESSAGES.GET_STATISTICS_PM")]
internal Devart.Data.Linq.ISingleResult<StatisticsPm> GetStatisticsPm([Parameter(Name="DATE_POINT", DbType="DATE")] System.Nullable<System.DateTime> DATE_POINT)
{
            IExecuteResult _GetStatisticsPmResult = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), DATE_POINT);
            return ((Devart.Data.Linq.ISingleResult<StatisticsPm>)(_GetStatisticsPmResult.ReturnValue));
}

Code: Select all

[Function(Name=@"USER_SETUP.PROCESSING_MESSAGES.GET_STATISTICS_PM")]
[ResultType(typeof(GETSTATISTICSPMResult), 1, ResultTypeOrigin.ReturnValue)]
internal Devart.Data.Linq.ISingleResult<StatisticsPm> GetStatisticsPm([Parameter(Name="DATE_POINT", DbType="DATE")] System.Nullable<System.DateTime> DATE_POINT)
{
            IExecuteResult _GetStatisticsPmResult = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), DATE_POINT);
            return ((Devart.Data.Linq.ISingleResult<StatisticsPm>)(_GetStatisticsPmResult.ReturnValue));
}