LeoNew
+X7RK8VKk7xvS6Fs8YhlP95aZQ3NTPodaUuhzGgE9o/D8sGhSFTTiMsT1cxNmLET/lb5C1Z3AdVyTe3MYVy1Y8PE+evFQTrx7VF9UOk9oj+NdM0JzV+TpP1J5QhjxOAqgix3icYYo939XHn4Y2xim/XIgStNCUmFYRi1hPh4bWffePc=
LeoNew
ListeDesMouvementsCaisse
Date,System.DateTime
Vendeur,System.String
TypeMvt,System.String
Commentaire,System.String
Montant,System.Decimal
30
ListeDesMouvementsCaisse
LeoNew
DateDebut,DateDebut,4,0
DateFin,DateFin_x0020__x003F__x003F__x0020_DateDebut,4,0
PorteSurJourneeFermees,PorteSurJourneeFermees,2,0
SELECT
(CASE WHEN @PorteSurJourneeFermees = 0 THEN mvt.Mvt_DateMouvement ELSE mvt.Mvt_DateImputation END) as Date,
'XBDD' as Vendeur,
tmc.Tmc_Libelle as TypeMvt,
mvt.Mvt_Commentaire as Commentaire,
mvt.Mvt_Montant as Montant
FROM
MouvementCaisse as mvt
INNER JOIN TypeMouvementCaisse as tmc ON tmc.Tmc_Id = mvt.Tmc_Id
WHERE
(
@PorteSurJourneeFermees = 0
AND
@DateDebut <= CONVERT(date, mvt.Mvt_DateMouvement)
AND
@DateFin >= CONVERT(date, mvt.Mvt_DateMouvement)
)
OR
(
@PorteSurJourneeFermees = 1
AND
@DateDebut <= CONVERT(date, mvt.Mvt_DateImputation)
AND
@DateFin >= CONVERT(date, mvt.Mvt_DateImputation)
);
StoredProcedure
,DateDebut,DateDebut,System.DateTime,new_x0020_DateTime_x0028_2013_x002C_08_x002C_21_x0029_,True,True
,DateFin,DateFin,System.Nullable`1[System.DateTime],null,True,True
,PorteSurJourneeFermees,PorteSurJourneeFermees,System.Boolean,false,True,True
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,19,0.7
All;Black;1;Solid;False;4;Black
[165:165:165]
0,0,3.4,0.7
Left
Calibri,10,Bold
Center
0,0,0,0
HeaderListeDesMouvementsCaisse_Date
Date
[255:255:255]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
All;Black;1;Solid;False;4;Black
[165:165:165]
3.4,0,2.2,0.7
Left
Calibri,10,Bold
Center
0,0,0,0
HeaderListeDesMouvementsCaisse_Vendeur
Vendeur
[255:255:255]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
All;Black;1;Solid;False;4;Black
[165:165:165]
5.6,0,3.8,0.7
Left
Calibri,10,Bold
Center
0,0,0,0
HeaderListeDesMouvementsCaisse_Type
Type
[255:255:255]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
All;Black;1;Solid;False;4;Black
[165:165:165]
9.4,0,6.6,0.7
Left
Calibri,10,Bold
Center
0,0,0,0
HeaderListeDesMouvementsCaisse_Commentaire
Commentaire
[255:255:255]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
All;Black;1;Solid;False;4;Black
[165:165:165]
16,0,3,0.7
Left
Calibri,10,Bold
Center
0,0,0,0
HeaderListeDesMouvementsCaisse_Montant
Montant
[255:255:255]
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
HeaderListeDesMouvementsCaisse
Transparent
0,1.9,19,0.43
All;Black;1;Solid;False;4;Black
Transparent
True
0,0,3.4,0.43
Left
Calibri,10
Center
0,0,0,0
DataListeDesMouvementsCaisse_Date
{ListeDesMouvementsCaisse.Date}
Black
dd/MM/yyyy HH:mm
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
All;Black;1;Solid;False;4;Black
Transparent
True
3.4,0,2.2,0.43
Left
Calibri,10
Center
0,0,0,0
DataListeDesMouvementsCaisse_Vendeur
{ListeDesMouvementsCaisse.Vendeur}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
All;Black;1;Solid;False;4;Black
Transparent
True
5.6,0,3.8,0.43
Left
Calibri,10
0,0,0,0
DataListeDesMouvementsCaisse_Type
{ListeDesMouvementsCaisse.TypeMvt}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
Transparent
All;Black;1;Solid;False;4;Black
9.4,0,6.6,0.43
Left
byte[] byteArray = System.Text.Encoding.Default.GetBytes(ListeDesMouvementsCaisse.Commentaire);
System.IO.MemoryStream stream = new System.IO.MemoryStream(byteArray);
string str = Stimulsoft.Report.Wpf.StiRtfHelper.ConvertFlowDocumentToRtf(stream);
e.Value = System.Xml.XmlConvert.EncodeName(StiRichText.PackRtf(str));
0,0,0,0
RichText1
__LP___x005C_rtf1_x005C_ansi_x005C_ansicpg1252_x005C_uc1_x005C_htmautsp_x005C_deff2__LP___x005C_fonttbl__LP___x005C_f0_x005C_fcharset0_x0020_Times_x0020_New_x0020_Roman_x003B___RP____LP___x005C_f2_x005C_fcharset0_x0020_Segoe_x0020_UI_x003B___RP____RP____LP___x005C_colortbl_x005C_red0_x005C_green0_x005C_blue0_x003B__x005C_red255_x005C_green255_x005C_blue255_x003B___RP___x005C_loch_x005C_hich_x005C_dbch_x005C_pard_x005C_plain_x005C_ltrpar_x005C_itap0__LP___x005C_lang1033_x005C_fs18_x005C_f2_x005C_cf0_x0020__x005C_cf0_x005C_ql__LP___x005C_f2_x0020__x005C_li0_x005C_ri0_x005C_sa0_x005C_sb0_x005C_fi0_x005C_ql_x005C_par__RP___x000D__x000A___RP___x000D__x000A___RP__
All;Black;1;Solid;False;4;Black
Transparent
True
16,0,3,0.43
Left
Calibri,10
Right
0,0,0,0
DataListeDesMouvementsCaisse_Montant
{ListeDesMouvementsCaisse.Montant}
Black
,
8
3
€
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
ListeDesMouvementsCaisse
DataListeDesMouvementsCaisse
Transparent
0,3.13,19,0.76
Transparent
0,0,3.8,0.76
Arial,10,Bold
Right
0,0,0,0
FooterListeDesMouvementsCaisse_Date
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
3.8,0,3.8,0.76
Arial,10,Bold
Right
0,0,0,0
FooterListeDesMouvementsCaisse_Vendeur
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
7.6,0,3.8,0.76
Arial,10,Bold
Right
0,0,0,0
FooterListeDesMouvementsCaisse_Type
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
11.4,0,3.8,0.76
Arial,10,Bold
Right
0,0,0,0
FooterListeDesMouvementsCaisse_Commentaire
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
15.2,0,3.8,0.76
Arial,10,Bold
Right
0,0,0,0
FooterListeDesMouvementsCaisse_Montant
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
FooterListeDesMouvementsCaisse
b6a84e1224ec4836a8195785f54c2ec4
1,1,1,1
Page1
29.7
21
Arial,100
[50:0:0:0]
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Stimulsoft.Report.Wpf.dll
ListeMouvements
8/22/2013 2:46:24 PM
8/21/2013 11:07:05 AM
C:\_TFS\LeoV200\Trunk\Editions\Shared\GestionOfficine\LeoV200.Editions.EditionsCaisse\mrt\ListeMouvements.mrt
edc132dbca0f44e7aff7597c0276ece0
ListeMouvements
Centimeters
2013.1.1600
CSharp