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 30 Avril 2010 Par Zaïr BEZGHICHE
Dernière vérification Jeudi 13 Mai 2010 Par Support France
ThèmeAdministration des articles, (Web, Web Services, PDA, WidGet, Fat Client) Fonction ARTMOD.ARTGereCompo

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

Code Source - développement open source
Function ARTGereCompo (Ctrl As Control, iRow As Integer, iCol As Integer, iValue As Integer) As Integer
Function ARTGereCompo (Ctrl As Control, iRow As Integer, iCol As Integer, iValue As Integer) As Integer
Dim Ret%
Dim sId$
Dim sData$
Dim iMax%


Ret = XasUserSetProperties(FrmGes.LabMsg, 7, "")
Ctrl.Row = iRow
Ctrl.Col = 3
sId = Ctrl.Text
If sId = "" Then
    Ctrl.Selected(iRow) = 0
    Exit Function
End If

If iValue = 1 Then
    Ret = pExecute("CLEAR")
    sData = "Select CodeProduit From Produit WHERE CodeProduit.xxKey=" + GlobCurEntity
    Ret = pExecute(sData)
    If Ret = True Then
	sData = "INSERT INTO Produit.ArticleCompo (Id, cle) VALUES ('" + GlobCurEntity + "','" + sId + "')"
	Ret = pExecute(sData)
    End If
Else
    sData = "DELETE * FROM ArticleCompo WHERE id.xxKey = " + GlobCurEntity + " AND cle.xxKey =" + sId
    Ret = pExecute(sData)
End If
sData = "SELECT TOP 50 Reference, name,CodeProduit "
sData = sData + " FROM Produit  "
sData = sData + " WHERE CodeProduit.xxKey IN ( "
sData = sData + " SELECt cle FROM ArticleCompo WHERE id.xxKey= " + GlobCurEntity + ")"
Ret = XasUserSQLtoCtrl(1, TmpRowSet, "Article.FrmGes.GridCompo", sData, GlobCurFileDom)
If Ret > 0 Then
    iMax = Ret - 1
    Ret = sLibCtrlSelectAll(FrmGes.GridCompo, iMax, 1)
End If
Ret = XasUserSetProperties(FrmGes.CelA(4), 18, 1)

End Function

Références XAS.Technology
XasUserSetProperties , XasUserSQLtoCtrl ,

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