XAS, Xml Server, Xml Services, XML Kiosk, Administration des missions, (Web, Web Services, PDA, WidGet, Fat Client)

Administration des missions, (Web, Web Services, PDA, WidGet, Fat Client)

Technologie	XAS.Technology	Version	V 6.0.1
Dernière modification	Mercredi 28 Juillet 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Lundi 9 Août 2010	Par	Support France
Thème	Administration des missions, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	ALRTBAS.ALERTFormatHyb

Prototype

Function ALERTFormatHyb (Ctrl As Control, IsInit As Integer) As Integer

Usage
Administration-des-missions.ALERTFormatHyb(...)
HTTP (GET,POST)	SOAP WSDL	SOAP REST	XML-RPC

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function ALERTFormatHyb (Ctrl As Control, IsInit As Integer) As Integer

Function ALERTFormatHyb (Ctrl As Control, IsInit As Integer) As Integer
Dim Ret%
Dim sData$
Dim s1$
Dim s2$
Dim i%

ModeCreation = False
If IsInit = True Then
    GlobGridRow = 0
    GlobGridCol = 0
    GlobGridSorded = 0
    Ret = ALRTSetSearh(0)
    Ret = ALERTSETCombo(0)
    Ret = XasUserSetProperties(FrmMain.CelContain, 18, 1)
Else
    Ret = XasUserSetProperties(FrmMain.CelJob, 18, 1)
End If
GlobCurColId = 9
Ret = XasXMLDom(GlobCurFileDom, GlobCurService + ".FrmMain.GridAlerte", 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.GridAlerte")
sData = "SELECT TOP 100 "
sData = sData + " CodeClient.GetData(Identifiant,Client,CodeClient), "
sData = sData + " date.Format(27),date.format(6),  "
sData = sData + " tpe_typepoint, titre, "
sData = sData + " maj,maj,maj,id," '9
sData = sData + " tpe_way,tpe_cp,tpe_town, "
sData = sData + " CodeMobile.GetData(Designation,Client,CodeClient), "
sData = sData + " CodeChauffeur.GetData(Designation,Client,CodeClient), "
sData = sData + " tpe_duree,pushrules,CodeClient, "
sData = sData + " CodeClient.GetData(Designation,Client,CodeClient), "
sData = sData + " CodeClient.GetData(Matricule,Client,CodeClient)   "
sData = sData + " FROM Transaction "
sData = sData + " WHERE id.xxkey != 0.0"
sData = sData + " AND Type.integer IN (6,16)"
s1 = ""
If IsInit = False Then
    s1 = FrmMain.TxDesi.Text + Chr$(3)
    s1 = s1 + sLibCboToSQL(FrmMain.Cbr(0), 1) + Chr$(3)
    s1 = s1 + sLibCboToSQL(FrmMain.Cbr(1), 1) + Chr$(3)
    s1 = s1 + sLibCboToSQL(FrmMain.Cbr(2), 1) + Chr$(3)
End If
sData = sData + xGetDataSearch(3, 1, s1)
sData = sData + ALERTSQLGetOrder(GlobGridRow, GlobGridCol, GlobGridSorded)
Ret = XasUserSQLtoCtrl(1, TmpRowSet, GlobCurService + ".FrmMain.GridAlerte", sData, GlobCurFileDom)
If Ret > 0 Then
    MaxGridRow = Ret - 1
    For i = 1 To MaxGridRow
        Ctrl.Row = i
        Ctrl.Col = 18
        s1 = Ctrl.Text
        Ctrl.Col = 19
        s2 = Ctrl.Text
        Ctrl.Col = 1
        sData = sLibSetLabForRules(0, GlobIHMRules, Trim$(Ctrl.Text), s1, s2)
        Ctrl.Text = sData
        Ctrl.Col = 10
        s1 = Ctrl.Text + "
"
        Ctrl.Col = 11
        s1 = s1 + Ctrl.Text + " "
        Ctrl.Col = 12
        s1 = s1 + Ctrl.Text
        Ctrl.Col = 6
        Ctrl.Text = s1
        Ctrl.Col = 4
        s1 = Ctrl.Text
        Ret = sLibSetIconAction(Ctrl, i, 4, "", s1)
        
        sData = ""
        Ctrl.Col = 13
        s1 = Ctrl.Text
        If s1 <> "" Then
           sData = sData + AlerteLabel(0) + s1
        End If
        Ctrl.Col = 14
        s1 = Ctrl.Text
        If s1 <> "" Then
           sData = sData + ", " + s1
        End If
        sData = sData + "
"
        Ctrl.Col = 15
        s1 = Ctrl.Text
        If Val(s1) > 0 Then
           sData = sData + AlerteLabel(1) + Format$(Val(s1), "hh:nn:ss")
        End If
        Ctrl.Col = 16
        s1 = ALERTGetMedia(FrmMain.cb(0), Trim$(Ctrl.Text))
        If s1 <> "" Then
           sData = sData + ", " + AlerteLabel(2) + s1
        End If
        Ctrl.Col = 7
        Ctrl.Text = sData
        Ret = sLibSetIconAction(Ctrl, i, 8, TrneeLabel(3), "35")
    Next i
Else
    Ctrl.Rows = 2
    Ret = XasUserSetProperties(FrmMain.LabMsg, 7, "")
    Ret = XasUserSetProperties(FrmMain.LabMsg, 146, "labelalert")
End If

End Function

Références Composants

Administration-des-missions-ALRTBAS-ALRTSetSearh, Administration-des-missions-ALRTBAS-ALERTSETCombo, Administration-des-missions-AMAIN-xGetDataSearch, Administration-des-missions-ALRTBAS-ALERTSQLGetOrder, Administration-des-missions-ALRTBAS-ALERTGetMedia,

Références XAS.Technology

XasUserSetProperties , XasXMLDom , Chr , XasUserSQLtoCtrl , Trim , Val , Format ,

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.