<%@ CodePage=1252 %>
<%
'Include Common Files @1-8E2E0CFC
%>
<!-- #INCLUDE VIRTUAL="/DATABASE/unitati_insp_tari_terte/Common.asp"-->
<!-- #INCLUDE VIRTUAL="/DATABASE/unitati_insp_tari_terte/Cache.asp" -->
<!-- #INCLUDE VIRTUAL="/DATABASE/unitati_insp_tari_terte/Template.asp" -->
<!-- #INCLUDE VIRTUAL="/DATABASE/unitati_insp_tari_terte/Sorter.asp" -->
<!-- #INCLUDE VIRTUAL="/DATABASE/unitati_insp_tari_terte/Navigator.asp" -->
<%
'End Include Common Files

'Initialize Page @1-8D15860A
' Variables
Dim PathToRoot, ScriptPath, TemplateFilePath
Dim FileName
Dim Redirect
Dim Tpl, HTMLTemplate
Dim TemplateFileName
Dim ComponentName
Dim PathToCurrentPage
Dim Attributes

' Events
Dim CCSEvents
Dim CCSEventResult

' Connections
Dim DBConnection1

' Page controls
Dim tari_terte
Dim ChildControls

Response.ContentType = CCSContentType
Redirect = ""
TemplateFileName = "tari_terte_list.html"
Set CCSEvents = CreateObject("Scripting.Dictionary")
PathToCurrentPage = "./"
FileName = "tari_terte_list.asp"
PathToRoot = "./"
ScriptPath = Left(Request.ServerVariables("PATH_TRANSLATED"), Len(Request.ServerVariables("PATH_TRANSLATED")) - Len(FileName))
TemplateFilePath = ScriptPath
'End Initialize Page

'Initialize Objects @1-DA26C2F2
Set DBConnection1 = New clsDBConnection1
DBConnection1.Open
Set Attributes = New clsAttributes

' Controls
Set tari_terte = New clsGridtari_terte
tari_terte.Initialize DBConnection1

CCSEventResult = CCRaiseEvent(CCSEvents, "AfterInitialize", Nothing)
'End Initialize Objects

'Go to destination page @1-6D35F4FD
If NOT ( Redirect = "" ) Then
    UnloadPage
    Response.Redirect Redirect
End If
'End Go to destination page

'Initialize HTML Template @1-7509502B
CCSEventResult = CCRaiseEvent(CCSEvents, "OnInitializeView", Nothing)
Set HTMLTemplate = new clsTemplate
HTMLTemplate.Encoding = "windows-1252"
Set HTMLTemplate.Cache = TemplatesRepository
HTMLTemplate.LoadTemplate TemplateFilePath & TemplateFileName
HTMLTemplate.SetVar "@CCS_PathToRoot", PathToRoot
Set Tpl = HTMLTemplate.Block("main")
CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShow", Nothing)
'End Initialize HTML Template

'Show Page @1-36D02E70
Attributes.Show HTMLTemplate, "page:"
Set ChildControls = CCCreateCollection(Tpl, Null, ccsParseOverwrite, _
    Array(tari_terte))
ChildControls.Show
Dim MainHTML
HTMLTemplate.Parse "main", False
MainHTML = HTMLTemplate.GetHTML("main")
CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeOutput", Nothing)
If CCSEventResult Then Response.Write MainHTML
'End Show Page

'Unload Page @1-CB210C62
UnloadPage
Set Tpl = Nothing
Set HTMLTemplate = Nothing
'End Unload Page

'UnloadPage Sub @1-F4A62399
Sub UnloadPage()
    CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeUnload", Nothing)
    If DBConnection1.State = adStateOpen Then _
        DBConnection1.Close
    Set DBConnection1 = Nothing
    Set CCSEvents = Nothing
    Set Attributes = Nothing
    Set tari_terte = Nothing
End Sub
'End UnloadPage Sub

Class clsGridtari_terte 'tari_terte Class @2-27527B79

'tari_terte Variables @2-8805006D

    ' Private variables
    Private VarPageSize
    ' Public variables
    Public ComponentName, CCSEvents
    Public Visible, Errors
    Public DataSource
    Public PageNumber
    Public Command
    Public TemplateBlock
    Public IsDSEmpty
    Public ForceIteration
    Public Attributes
    Private ShownRecords
    Public Recordset

    Private CCSEventResult

    ' Grid Controls
    Public StaticControls, RowControls
    Dim id_tari
    Dim tara
    Dim firma
    Dim adresa
    Dim fluxuri
    Dim data_insp
    Dim data_exp
    Dim Navigator
'End tari_terte Variables

'tari_terte Class_Initialize Event @2-ED304975
    Private Sub Class_Initialize()
        ComponentName = "tari_terte"
        Visible = True
        Set CCSEvents = CreateObject("Scripting.Dictionary")
        Set Attributes = New clsAttributes
        Set Errors = New clsErrors
        Set DataSource = New clstari_terteDataSource
        Set Command = New clsCommand
        PageSize = CCGetParam(ComponentName & "PageSize", Empty)
        If IsNumeric(PageSize) And Len(PageSize) > 0 Then
            If PageSize <= 0 Then Errors.AddError(CCSLocales.GetText("CCS_GridPageSizeError", Empty))
            If PageSize > 100 Then PageSize = 100
        End If
        If NOT IsNumeric(PageSize) OR IsEmpty(PageSize) Then _
            PageSize = 20 _
        Else _
            PageSize = CInt(PageSize)
        PageNumber = CCGetParam(ComponentName & "Page", 1)
        If Not IsNumeric(PageNumber) And Len(PageNumber) > 0 Then
            Errors.AddError(CCSLocales.GetText("CCS_GridPageNumberError", Empty))
            PageNumber = 1
        ElseIf Len(PageNumber) > 0 Then
            If PageNumber > 0 Then
                PageNumber = CInt(PageNumber)
            Else
                Errors.AddError(CCSLocales.GetText("CCS_GridPageNumberError", Empty))
                PageNumber = 1
            End If
        Else
            PageNumber = 1
        End If

        Set id_tari = CCCreateControl(ccsLabel, "id_tari", Empty, ccsInteger, Empty, CCGetRequestParam("id_tari", ccsGet))
        Set tara = CCCreateControl(ccsLabel, "tara", Empty, ccsText, Empty, CCGetRequestParam("tara", ccsGet))
        Set firma = CCCreateControl(ccsLabel, "firma", Empty, ccsText, Empty, CCGetRequestParam("firma", ccsGet))
        Set adresa = CCCreateControl(ccsLabel, "adresa", Empty, ccsText, Empty, CCGetRequestParam("adresa", ccsGet))
        Set fluxuri = CCCreateControl(ccsLabel, "fluxuri", Empty, ccsMemo, Empty, CCGetRequestParam("fluxuri", ccsGet))
        Set data_insp = CCCreateControl(ccsLabel, "data_insp", Empty, ccsText, Empty, CCGetRequestParam("data_insp", ccsGet))
        Set data_exp = CCCreateControl(ccsLabel, "data_exp", Empty, ccsText, Empty, CCGetRequestParam("data_exp", ccsGet))
        Set Navigator = CCCreateNavigator(ComponentName, "Navigator", FileName, 20, tpSimple)
    IsDSEmpty = True
    End Sub
'End tari_terte Class_Initialize Event

'tari_terte Initialize Method @2-57CE6952
    Sub Initialize(objConnection)
        If NOT Visible Then Exit Sub

        Set DataSource.Connection = objConnection
        DataSource.PageSize = PageSize
        DataSource.AbsolutePage = PageNumber
    End Sub
'End tari_terte Initialize Method

'tari_terte Class_Terminate Event @2-B97CC660
    Private Sub Class_Terminate()
        Set CCSEvents = Nothing
        Set DataSource = Nothing
        Set Command = Nothing
        Set Errors = Nothing
        Set Attributes = Nothing
    End Sub
'End tari_terte Class_Terminate Event

'tari_terte Show Method @2-4D57C148
    Sub Show(Tpl)
        Dim HasNext
        If NOT Visible Then Exit Sub

        Dim RowBlock


        CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeSelect", Me)
        Set Recordset = DataSource.Open(Command)
        If DataSource.Errors.Count = 0 Then IsDSEmpty = Recordset.EOF

        Set TemplateBlock = Tpl.Block("Grid " & ComponentName)
        If TemplateBlock is Nothing Then Exit Sub
        Set RowBlock = TemplateBlock.Block("Row")
        Set StaticControls = CCCreateCollection(TemplateBlock, Null, ccsParseOverwrite, _
            Array(Navigator))
            Navigator.SetDataSource Recordset
        Set RowControls = CCCreateCollection(RowBlock, Null, ccsParseAccumulate, _
            Array(id_tari, tara, firma, adresa, fluxuri, data_insp, data_exp))

        CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShow", Me)
        If NOT Visible Then Exit Sub

        RowControls.PreserveControlsVisible
        Errors.AddErrors DataSource.Errors
        If Errors.Count > 0 Then
            TemplateBlock.HTML = CCFormatError("Grid " & ComponentName, Errors)
        Else

            ' Show NoRecords block if no records are found
            If Recordset.EOF Then
                Attributes.Show TemplateBlock, "tari_terte:"
                TemplateBlock.Block("NoRecords").Parse ccsParseOverwrite
            End If
            HasNext = HasNextRow()
            ForceIteration = False
            Do While ForceIteration Or HasNext
                Attributes("rowNumber") = ShownRecords + 1
                If HasNext Then
                    id_tari.Value = Recordset.Fields("id_tari")
                    tara.Value = Recordset.Fields("tara")
                    firma.Value = Recordset.Fields("firma")
                    adresa.Value = Recordset.Fields("adresa")
                    fluxuri.Value = Recordset.Fields("fluxuri")
                    data_insp.Value = Recordset.Fields("data_insp")
                    data_exp.Value = Recordset.Fields("data_exp")
                End If
                CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeShowRow", Me)
                Attributes.Show TemplateBlock.Block("Row"), "tari_terte:"
                RowControls.Show
                If HasNext Then Recordset.MoveNext
                ShownRecords = ShownRecords + 1
                HasNext = HasNextRow()
            Loop
            Attributes.Show TemplateBlock, "tari_terte:"
            StaticControls.Show
        End If

    End Sub
'End tari_terte Show Method

'tari_terte PageSize Property Let @2-54E46DD6
    Public Property Let PageSize(NewValue)
        VarPageSize = NewValue
        DataSource.PageSize = NewValue
    End Property
'End tari_terte PageSize Property Let

'tari_terte PageSize Property Get @2-9AA1D1E9
    Public Property Get PageSize()
        PageSize = VarPageSize
    End Property
'End tari_terte PageSize Property Get

'tari_terte RowNumber Property Get @2-F32EE2C6
    Public Property Get RowNumber()
        RowNumber = ShownRecords + 1
    End Property
'End tari_terte RowNumber Property Get

'tari_terte HasNextRow Function @2-9BECE27A
    Public Function HasNextRow()
        HasNextRow = NOT Recordset.EOF AND ShownRecords < PageSize
    End Function
'End tari_terte HasNextRow Function

End Class 'End tari_terte Class @2-A61BA892

Class clstari_terteDataSource 'tari_terteDataSource Class @2-2FB44F98

'DataSource Variables @2-CB286B51
    Public Errors, Connection, Parameters, CCSEvents

    Public Recordset
    Public SQL, CountSQL, Order, Where, Orders, StaticOrder
    Public PageSize
    Public PageCount
    Public AbsolutePage
    Public Fields
    Dim WhereParameters
    Public AllParamsSet
    Public CmdExecution
    Public InsertOmitIfEmpty
    Public UpdateOmitIfEmpty

    Private CurrentOperation
    Private CCSEventResult

    ' Datasource fields
    Public id_tari
    Public tara
    Public firma
    Public adresa
    Public fluxuri
    Public data_insp
    Public data_exp
'End DataSource Variables

'DataSource Class_Initialize Event @2-308A6EFD
    Private Sub Class_Initialize()

        Set CCSEvents = CreateObject("Scripting.Dictionary")
        Set Fields = New clsFields
        Set Recordset = New clsDataSource
        Set Recordset.DataSource = Me
        Set Errors = New clsErrors
        Set Connection = Nothing
        AllParamsSet = True
        Set id_tari = CCCreateField("id_tari", "id_tari", ccsInteger, Empty, Recordset)
        Set tara = CCCreateField("tara", "tara", ccsText, Empty, Recordset)
        Set firma = CCCreateField("firma", "firma", ccsText, Empty, Recordset)
        Set adresa = CCCreateField("adresa", "adresa", ccsText, Empty, Recordset)
        Set fluxuri = CCCreateField("fluxuri", "fluxuri", ccsMemo, Empty, Recordset)
        Set data_insp = CCCreateField("data_insp", "data_insp", ccsText, Empty, Recordset)
        Set data_exp = CCCreateField("data_exp", "data_exp", ccsText, Empty, Recordset)
        Fields.AddFields Array(id_tari, tara, firma, adresa, fluxuri, data_insp, data_exp)

        SQL = "SELECT TOP {SqlParam_endRecord} id_tari, tara, firma, adresa, fluxuri, data_insp, data_exp  " & vbLf & _
        "FROM tari_terte {SQL_Where} {SQL_OrderBy}"
        CountSQL = "SELECT COUNT(*) " & vbLf & _
        "FROM tari_terte"
        Where = ""
        Order = "id_tari"
        StaticOrder = ""
    End Sub
'End DataSource Class_Initialize Event

'BuildTableWhere Method @2-98E5A92F
    Public Sub BuildTableWhere()
    End Sub
'End BuildTableWhere Method

'Open Method @2-6EA306C4
    Function Open(Cmd)
        Errors.Clear
        If Connection Is Nothing Then
            Set Open = New clsEmptyDataSource
            Exit Function
        End If
        Set Cmd.Connection = Connection
        Cmd.CommandOperation = cmdOpen
        Cmd.PageSize = PageSize
        Cmd.ActivePage = AbsolutePage
        Cmd.CommandType = dsTable
        CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeBuildSelect", Me)
        Cmd.SQL = SQL
        Cmd.CountSQL = CountSQL
        Cmd.Where = Where
        Cmd.OrderBy = Order
        If(Len(StaticOrder)>0) Then
            If Len(Order)>0 Then Cmd.OrderBy = ", "+Cmd.OrderBy
            Cmd.OrderBy = StaticOrder + Cmd.OrderBy
        End If
        Cmd.Options("TOP") = True
        CCSEventResult = CCRaiseEvent(CCSEvents, "BeforeExecuteSelect", Me)
        If Errors.Count = 0 And CCSEventResult Then _
            Set Recordset = Cmd.Exec(Errors)
        CCSEventResult = CCRaiseEvent(CCSEvents, "AfterExecuteSelect", Me)
        Set Recordset.FieldsCollection = Fields
        Set Open = Recordset
    End Function
'End Open Method

'DataSource Class_Terminate Event @2-41B4B08D
    Private Sub Class_Terminate()
        If Recordset.State = adStateOpen Then _
            Recordset.Close
        Set Recordset = Nothing
        Set Parameters = Nothing
        Set Errors = Nothing
    End Sub
'End DataSource Class_Terminate Event

End Class 'End tari_terteDataSource Class @2-A61BA892


%>