Administration des articles, (Web, Web Services, PDA, WidGet, Fat Client)
XAS.Services
  XML Kiosk  
Technologie XAS.Technology Version V 6.0.1
Dernière modification Vendredi 23 Juillet 2010 Par Zaïr BEZGHICHE
Dernière vérification Mercredi 28 Juillet 2010 Par Support France
ThèmeAdministration des articles, (Web, Web Services, PDA, WidGet, Fat Client) Fonction ARTMOD.LINKRowUpdate

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

Code Source - développement open source
Function LINKRowUpdate (Ctrl As Control, iRow As Integer) As Integer
Function LINKRowUpdate (Ctrl As Control, iRow As Integer) As Integer
Dim Ret%
Dim sData$
Dim sId$
Dim s$
Dim iErr%
Dim sRef$

Ctrl.Row = iRow
Ctrl.Col = 6
sId = Ctrl.Text
s = FrmLink.Txmp(0).Text
If s = "" Then
    Ret = sLibSQLSetRowError(Ctrl, iRow, 1, LinkModeCreation)
    iErr = 1
End If
s = FrmLink.Txmp(1).Text
If s = "" Then
    Ret = sLibSQLSetRowError(Ctrl, iRow, 1, LinkModeCreation)
    iErr = 1
End If
If iErr = 1 Then
    Ret = sLibSQLSetRowError(Ctrl, iRow, 0, LinkModeCreation)
    Exit Function
End If
If sId <> "" Then
    sData = "UPDATE linkcarte SET "
    sData = sData + "maj='" + Date$ + "',"
    sData = sData + "name=" + Chr$(3) + FrmLink.Txmp(0).Text + Chr$(4) + ","
    sData = sData + "text=" + Chr$(3) + FrmLink.Txmp(1).Text + Chr$(4) + ","
    s = LINKGetsValue(iRow)
    sData = sData + "value=" + Chr$(3) + s + Chr$(4) + ","
    sData = sData + "statut=" + Chr$(3) + GetCharByIndice(Trim$(FrmLink.cbp(0).Text), Chr$(9), 2) + Chr$(4) + ","
    sData = sData + "enabled=" + Chr$(3) + CStr(FrmLink.chkp(0).Value) + Chr$(4)
    sData = sData + " WHERE id.xxKey=" + sId
    Ret = pExecute(sData)
    If Ret = True Then
	Ctrl.Selected(iRow) = 0
    Else
	Ctrl.Selected(iRow) = 2
    End If
Else
    sRef = sLibLINKGetRef(201)
    Ret = pExecute("CLEAR")
    Ret = pExecute("Select " + GetCharByIndice(sRef, ";", 2) + " from " + GetCharByIndice(sRef, ";", 1) + " where xmluserid.xxkey=" + GlobCurEntity)
    If Ret <> False Then
	sData = "INSERT INTO " + GetCharByIndice(sRef, ";", 1) + ".linkcarte (type," + GetCharByIndice(sRef, ";", 2) + ",creation,maj,name,text,value,statut,enabled) VALUES ("
	sData = sData + "'" + CStr(GlobLinkCarteType) + "','" + GlobCurEntity + "',"
	sData = sData + "'" + Date$ + "','" + Date$ + "',"
	sData = sData + Chr$(3) + FrmLink.Txmp(0).Text + Chr$(4) + ","
	sData = sData + Chr$(3) + FrmLink.Txmp(1).Text + Chr$(4) + ","
	sData = sData + Chr$(3) + FrmLink.Txmp(2).Text + Chr$(4) + ","
	sData = sData + Chr$(3) + GetCharByIndice(Trim$(FrmLink.cbp(0).Text), Chr$(9), 2) + Chr$(4) + ","
	sData = sData + Chr$(3) + CStr(FrmLink.chkp(0).Value) + Chr$(4) + ")"
	Ret = pExecute(sData)
	If Ret = True Then
	    Ret = XasUserGetString(1, sId)
	    Ctrl.Selected(iRow) = 0
	Else
	    Ctrl.Selected(iRow) = 2
	End If
    Else
	Ctrl.Selected(iRow) = 2
    End If
End If
End Function

Références Composants
Administration-des-articles-ARTMOD-LINKGetsValue,

Références XAS.Technology
Date , Chr , GetCharByIndice , Trim , Cstr , XasUserGetString ,

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