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> |
Partager