Administration des missions, (Web, Web Services, PDA, WidGet, Fat Client)
XAS.Services
  XML Kiosk  
Technologie XAS.Technology Version V 6.0.1
Dernière modification Samedi 17 Avril 2010 Par Zaïr BEZGHICHE
Dernière vérification Samedi 1 Mai 2010 Par Support France
ThèmeAdministration des missions, (Web, Web Services, PDA, WidGet, Fat Client) Fonction ALRTBAS.PUSHFormatHyb

Prototype
Function PUSHFormatHyb (Ctrl As Control, IsInit As Integer) As Integer
Usage
Administration-des-missions.PUSHFormatHyb(...)
HTTP (GET,POST)SOAP WSDLSOAP RESTXML-RPC
Format de sortie
XML HTML TEXT EXCEL(CSV)

Code Source - développement open source
Function PUSHFormatHyb (Ctrl As Control, IsInit As Integer) As Integer
Function PUSHFormatHyb (Ctrl As Control, IsInit As Integer) As Integer
Dim Ret%
Dim sData$
Dim s1$
Dim i%
Dim iLig%
Dim iType%

ModeCreation = False
If IsInit = True Then
    GlobGridRow = 0
    GlobGridCol = 0
    GlobGridSorded = 0
    Ret = OPESetRech(Ctrl, "2;1;5;7;")
    Ret = PUSHSETCombo(15)
    Ret = XasUserSetProperties(FrmMain.CelContain, 18, 1)
Else
    Ret = XasUserSetProperties(FrmMain.CelJob, 18, 1)
End If
GlobCurColId = 11
Ctrl.Clear
Ret = XasXMLDom(GlobCurFileDom, GlobCurService + ".FrmMain.GridPush", 0)
Ret = XasUserSetProperties(FrmMain.LabMsg, 7, "")
Ret = XasUserSetProperties(FrmMain.LabMsg, 146, "submiddlebar")
Ret = XasUserSetProperties(FrmMain.BtnVers(0), 9, False)
Ret = XasUserSetProperties(FrmMain.BtnVers(1), 9, False)
Ret = XasUserSetProperties(FrmMain.BtnVers(2), 9, True)
Ret = XasUserSetProperties(FrmMain.BtnVers(0), 78, GlobCurService + ".FrmMain.GridPush")
sData = "SELECT TOP 100 "
sData = sData + "id.GetData(type,Client,CodeClient), "
sData = sData + "id.GetData(raisonsociale,Client,CodeClient), "
sData = sData + "id.GetData(identifiant,Client,CodeClient), "
sData = sData + "id.GetData(designation,Client,CodeClient), "
sData = sData + "id.GetData(matricule,Client,CodeClient), "
sData = sData + "maj.Format(27),maj.format(6),  "
sData = sData + "src,alink.GetData(name,@@XasUserPays.typepush,id),Text,"
sData = sData + "netchangeid "
sData = sData + "FROM netchange "
sData = sData + " WHERE netchangeid.xxkey != 0.0"
sData = sData + " AND alink.integer < 100"
If GlobLinkEntity <> "" Then
    sData = sData + " AND id.xxKey IN(" + GlobLinkEntity + ")"
End If
If IsInit = False Then
    s1 = FrmMain.TxDesi.Text
    If s1 <> "" Then
        sData = sData + " AND date.xxDate ='" + s1 + "'"
    End If
    s1 = sLibCboToSQL(FrmMain.Cbr(0), 1)
    If s1 <> "" Then
        sData = sData + " AND type.xxKey IN(" + s1 + ")"
    End If
    s1 = sLibCboToSQL(FrmMain.Cbr(1), 1)
    If s1 <> "" Then
        sData = sData + " AND name.GetData(CodeProgramme,transaction,id).xxKey IN(" + s1 + ")"
    End If
    s1 = sLibCboToSQL(FrmMain.Cbr(2), 1)
    If s1 <> "" Then
        sData = sData + " AND alink.integer IN(" + s1 + ")"
    End If
End If
sData = sData + PUSHSQLGetOrder(GlobGridRow, GlobGridCol, GlobGridSorded)
Ret = pTmpExecute(sData)
If Ret = True Then
    While (Ret = True)
        iLig = iLig + 1
        Ctrl.Row = iLig
        Ctrl.Col = 1
        iType = Val(pTmpGetItem(0))
        If sLibIsTypePro(iType) = True Then
            sData = pTmpGetItem(1)
        Else
            sData = sLibSetLabForRules(0, GlobIHMRules, pTmpGetItem(2), pTmpGetItem(3), pTmpGetItem(4))
        End If
        Ctrl.Text = sData

        Ctrl.Col = 2
        Ctrl.Text = pTmpGetItem(5)
        Ctrl.Col = 3
        Ctrl.Text = pTmpGetItem(6)
        Ctrl.Col = 6
        sData = GetCharByIndice(pTmpGetItem(7), "|", 2)
        Ctrl.Text = sData
        Ctrl.Col = 7
        Ctrl.Text = pTmpGetItem(8)
        s1 = GetCharByIndice(pTmpGetItem(9), "|", 4)
        If s1 <> "" Then
            Ret = pExecute("SELECT icon,name FROM Scenario WHERE id.xxKey=" + s1 + " USEINDEX('IdScenario')")
            If Ret = True Then
                Ctrl.Col = 4
                s1 = GetCharByIndice(OnSQLGetItem(0), ",", 1)
                Ret = sLibSetIconAction(Ctrl, iLig, 4, OnSQLGetItem(1), s1)
                Ctrl.Col = 5
                Ctrl.Text = OnSQLGetItem(1)
            End If
        End If
        s1 = GetCharByIndice(pTmpGetItem(9), "|", 3)
        Ctrl.Col = 11
        Ctrl.Text = s1
        s1 = GetCharByIndice(pTmpGetItem(9), "|", 1)
        If s1 <> "" Then
            Ret = pExecute("SELECT name FROM modeledoc WHERE id.xxKey=" + s1)
            If Ret = True Then
                Ctrl.Col = 8
                Ctrl.Text = OnSQLGetItem(0)
            End If
        End If
        Ret = sLibSetIconAction(Ctrl, iLig, 10, TrneeLabel(3), "35")
        Ret = pTmpMoveNext(0)
    Wend
    iLig = iLig + 1
Else
    iLig = 2
    Ret = XasUserSetProperties(FrmMain.LabMsg, 7, "")
    Ret = XasUserSetProperties(FrmMain.LabMsg, 146, "labelalert")
End If
Ctrl.Rows = iLig

End Function

Références Composants
Administration-des-missions-AMAIN-OPESetRech, Administration-des-missions-ALRTBAS-PUSHSETCombo, Administration-des-missions-ALRTBAS-PUSHSQLGetOrder,

Références XAS.Technology
XasUserSetProperties , Clear , XasXMLDom , Val , GetCharByIndice ,

Audience
Cette documentation est destinée aux personnes s'intéressant aux systèmes d'information collaboratifs.
Les Webservices, les architectures collabortives et distribuées, les moteurs transactionnelles et les concepts de programmation orientés objet.


XAS Services - Zaïr BEZGHICHE - Copyright 1991-2011 tous droits réservés- Powered by XAS.Technology