Function InewDefaultScenario (sCodeProg As String, sName As String, sType As Integer, Entity As Integer, critEntity As Integer, ope As Integer, valuea As Integer, valueb As Integer, isTraitement As Integer, TypeAlerte As Integer) As Integer
Dim Ret%
Dim sData$
Dim sRules$
Dim FilePush$
Dim screa$
Dim sidScenar$
InewDefaultScenario = False
If isTraitement > 0 Then
sRules = "000010"
FilePush = "2"
Else
sRules = "000000"
FilePush = "0"
End If
screa = Date$
sData = "SELECT heuredebut, icon, forecolor FROM typeTicket WHERE id.integer = " + CStr(sType)
Ret = pExecute(sData)
If Ret = True Then
TabSQLValue(2, 0) = OnSQLGetItem(0)
TabSQLValue(2, 1) = OnSQLGetItem(1)
TabSQLValue(2, 2) = OnSQLGetItem(2)
End If
sData = "SELECT CodeProgramme FROM Programme WHERE CodeProgramme.xxKey = " + CStr(sCodeProg)
Ret = pExecute(sData)
If Ret = True Then
sData = " INSERT INTO Programme.Scenario (Creation,maj,Name,CodeProgramme,debutvalidite,heuredebut,finvalidite,heurefin,point,burnpoint,burnlabpoint,"
sData = sData + " burnvaleur,burnaddpoint,valuea,valueb,article,modepassage,modesite,mediarules,"
sData = sData + " Type,uniteburn,codesite,entity,critentity,operateur,criterea,critereb,modeledocid,FileType,Traitement,isstate,icon,forecolor,typealerteid) VALUES ("
sData = sData + "'" + screa + "','" + Date$ + "',"
sData = sData + "'" + sName + "','" + CStr(sCodeProg) + "','01/01/00','00:00','30/12/10','23:59','0','0',' ',"
sData = sData + "'1.00','0','" + CStr(valuea) + "','" + CStr(valueb) + "','0','0','0','" + sRules + "',"
sData = sData + "'" + CStr(sType) + "','1.00','0','" + CStr(Entity) + "','" + CStr(critEntity) + "','" + CStr(ope) + "','','','0','" + FilePush + "','" + CStr(isTraitement) + "',"
sData = sData + "'" + TabSQLValue(2, 0) + "','" + TabSQLValue(2, 1) + "','" + TabSQLValue(2, 2) + "','" + CStr(TypeAlerte) + "')"
Ret = pExecute(sData)
If Ret = True Then
Ret = XasUserGetString(1, sidScenar)
Else
Exit Function
End If
InewDefaultScenario = True
End If
End Function
|