1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
| <?xml version="1.0"?>
<xmlgram name="CalculResultatTransactionnelCompose_Stat">
<Assign Name="Params"/>
<DBExtract Name="TRSTATTYPE">
<DataSource>Database</DataSource>
<Kind>Multiple</Kind>
<MaxRows>-1</MaxRows>
<Object>QUERY</Object>
<StoredProcName/>
<GenerateOutput>True</GenerateOutput>
<MultipleContainerName/>
<RecordName/>
<ReplaceBlankValues/>
<Statement><![CDATA[select IDSTATTYPE,
IDTYPE,
NOMCOURT,
IDTYPESQLCMD,
SQLCMD,
IDTYPERESULTAT,
TXTLISTCHAMPINSERT
From TRSTATTYPE
where idtype=1 and IDTYPERESULTAT=1]]></Statement>
<Filter/>
<Fields/>
<Params/>
<DBBatch Name="DELETERESULTAT">
<DataSource>Database</DataSource>
<Object>QUERY</Object>
<StoredProcName/>
<Statement><![CDATA[DELETE FROM TRSTATRESULTAT
WHERE IDSTATTYPE = :IDSTATTYPE
AND IDLOGIN= 1]]></Statement>
<Params/>
</DBBatch>
<DBExtract Name="EXECUTESQL">
<DataSource>Database</DataSource>
<Kind>Multiple</Kind>
<MaxRows>-1</MaxRows>
<Object>QUERY</Object>
<StoredProcName/>
<GenerateOutput>True</GenerateOutput>
<MultipleContainerName/>
<RecordName/>
<ReplaceBlankValues/>
<Statement><![CDATA[{$SQLCMD}]]></Statement>
<Filter/>
<Fields/>
<Params/>
<DBBatch Name="INSERTRESULTAT">
<DataSource>Database</DataSource>
<Object>QUERY</Object>
<StoredProcName/>
<Statement><![CDATA[insert into TRSTATRESULTAT(IDSTATRESULTAT,
DATE_STATS,
IDTYPE,
IDTYPERESULTAT,
IDSTATTYPE,
IDLOGIN,
IDSTATLOT,
IDPERIM_FILTRE,
IDTYPEOP_FILTRE,
IDTYPEP_FILTRE,
IDTYPEPT_FILTRE,
{$TXTLISTCHAMPINSERT})
values (Gen_Id(GENE_NEXT_TRSTATRESULTAT,1),
'today',
1,
1,
:IDSTATTYPE,
1,
:IDLOT_STATS,
:IDPERIMETRE_STAT_SEARCH,
:IDTYPEOP_STAT_SEARCH,
:IDTYPEP_STAT_SEARCH,
:IDTYPEPT_STAT_SEARCH,
{$TXTINSERT}) ]]></Statement>
<Params/>
<Events>
<Event>
<Name>BeforeInstruction</Name>
<MethodName>CalculResultatTransactionnelCompose_Stat_INSERTRESULTAT_BeforeInstruction</MethodName>
<Language>JScript</Language>
<Module>CalculResultatTransactionnelCompose_Stat</Module>
<FileName>CalculResultatTransactionnelCompose_Stat.js</FileName>
</Event>
</Events>
</DBBatch>
</DBExtract>
</DBExtract>
</xmlgram> |
