Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)
XAS.Services
  XML Kiosk  
Technologie XAS.Technology Version V 6.0.1
Dernière modification Dimanche 22 Août 2010 Par Zaïr BEZGHICHE
Dernière vérification Mercredi 25 Août 2010 Par Support France
ThèmeAdministration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client) Fonction SQLDATA.InsertServeur

Prototype
Function InsertServeur (Id As Integer) As Integer
Usage
Administration-des-lots-de-cartes.InsertServeur(...)
HTTP (GET,POST)SOAP WSDLSOAP RESTXML-RPC
Format de sortie
XML HTML TEXT EXCEL(CSV)

Code Source - développement open source
Function InsertServeur (Id As Integer) As Integer
Function InsertServeur (Id As Integer) As Integer
Dim Ret%
Dim sData$
Dim s$
Dim screa$
Dim sidServeur$

InsertServeur = False

Ret = pExecute("CLEAR")
screa = Date$
sData = " INSERT INTO maitre.dbo.XmlServeur (Creation,maj,RaisonSociale,Index,Name,password,Adresse,AdresseSuite,Cp,ville,  "
sData = sData + " email,phone,fax,XasKey,Host,enabled,type,CodeEnseigne,Titre,pays,langue,xmluserid)  VALUES ("
sData = sData + "'" + screa + "',"
sData = sData + "'" + screa + "',"
sData = sData + "'" + TabSQLValue(0, 0) + "',"
sData = sData + "'" + TabSQLValue(0, 1) + "',"
sData = sData + "'" + TabSQLValue(0, 2) + "',"
sData = sData + "'" + TabSQLValue(0, 3) + "',"
sData = sData + "'" + TabSQLValue(0, 4) + "',"
sData = sData + "'" + TabSQLValue(0, 5) + "',"
sData = sData + "'" + TabSQLValue(0, 6) + "',"
sData = sData + "'" + TabSQLValue(0, 7) + "',"
sData = sData + "'" + TabSQLValue(0, 8) + "',"
sData = sData + "'" + TabSQLValue(0, 9) + "',"
sData = sData + "'" + TabSQLValue(0, 10) + "',"
sData = sData + "'" + TabSQLValue(0, 11) + "',"
sData = sData + "'" + TabSQLValue(0, 12) + "',"
sData = sData + "'" + TabSQLValue(0, 13) + "',"
sData = sData + "'" + TabSQLValue(0, 14) + "',"
sData = sData + "'" + TabSQLValue(0, 15) + "',"
sData = sData + "'" + TabSQLValue(0, 16) + "',"
sData = sData + "'" + TabSQLValue(0, 17) + "',"
sData = sData + "'" + TabSQLValue(0, 18) + "',"
sData = sData + "'" + TabSQLValue(0, 19) + "' ) "
Ret = pExecute(sData)
If Ret = True Then
    Ret = XasUserGetString(1, sidServeur)
    Ret = ServeurForINSERT(sidServeur)
    If Ret = True Then
	If TabSQLValue(0, 19) <> "" Then
	    sData = "UPDATE XmlUser SET Id='" + TabSQLValue(0, 1) + "' WHERE xmluserid.xxKey=" + TabSQLValue(0, 19) + " NOSYNCHRONISATION"
	    Ret = pExecute(sData)
	End If
	Ret = SQLCreateUser(0, "0.0", TabSQLValue(0, 2), TabSQLValue(0, 3), 7)
	Ret = XasSystemAddAgent(Val(TabSQLValue(0, 1)))
	Ret = XasSystemCreateUser(TabSQLValue(0, 2), TabSQLValue(0, 3), "7", "0111100", "MAITRE")
	InsertServeur = Ret
    End If
End If

End Function

Références Composants
Administration-des-lots-de-cartes-SQLDATA-ServeurForINSERT, Administration-des-lots-de-cartes-SQLDATA-SQLCreateUser,

Références XAS.Technology
Date , XasUserGetString , XasSystemAddAgent , Val , XasSystemCreateUser ,

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