OracleConnection
4DiRKNh8okVFaXlYem0qv//CgY1Nd0pZe3qcWGQlbgrkFrdvxWyiRe8BJYBOBPN703D/z198maRufCEEw4iov5g+lYDGfKoFcn45THSILZPjOEPhX2gxRcts/XTl3PYn41SdSFhwehl7Fch0+j2rj+XiQ81QfMLs/VxVgHjsbeeZyLvPYQrJ6ENhTRx2iKiP/MhBA11Zo7zyRylc9dz1DvMgaQLVd9M=
OracleConnection
<Alias>TITLE</Alias>
<Columns isList="true" count="5">
<value>DATE_FROM,System.String</value>
<value>DATE_TILL,System.String</value>
<value>PARTY_NAME,System.String</value>
<value>PRN,System.String</value>
<value>OPER_DATE,System.String</value>
</Columns>
<CommandTimeout>30</CommandTimeout>
<Dictionary isRef="1" />
<Name>TITLE</Name>
<NameInSource>OracleConnection</NameInSource>
<Parameters isList="true" count="1">
<value>INQ_ID,INQ_ID,13,0</value>
</Parameters>
<SqlCommand>select TR_UTIL_INQ.GET_ITEM_VALUE( :inq_id, TR_W_MRT.GET_REP_START_DT ) date_from
, TR_UTIL_INQ.GET_ITEM_VALUE( :inq_id, TR_W_MRT.GET_REP_END_DT ) date_till
, TR_UTIL_INQ.GET_ITEM_VALUE( :inq_id, 'PARTY_NAME' ) party_name
, TR_UTIL_INQ.GET_ITEM_VALUE( :inq_id, 'PRN' ) prn
, TR_UTIL_INQ.GET_ITEM_VALUE( :inq_id, 'OPER_DATE' ) oper_date
from dual</SqlCommand>
MAIN
SEC_SEC,System.String
SEC_CODE_REGISTRY,System.String
TRUNC_x0028_SELL_DATE_TIME_x0029_,System.DateTime
SEC_AMOUNT,System.Decimal
SELL_COMM,System.Decimal
SELL_COMM_VAT,System.Decimal
TRUNC_x0028_BUY_DATE_TIME_x0029_,System.DateTime
SEC_AMOUNT1,System.Decimal
BUY_COMM,System.Decimal
BUY_COMM_VAT,System.Decimal
TR_LIB_MATH.PLS_x0028_SELL_COMM_x002C_BUY_COMM_x0029_,System.Decimal
TR_LIB_MATH.PLS_x0028_SELL_COMM_VAT_x002C_BUY_COMM_VAT_x0029_,System.Decimal
30
MAIN
OracleConnection
INQ_ID,INQ_ID,13,0
select sec_sec
, sec_code_registry
, trunc( sell_date_time )
, sec_amount
, sell_comm
, sell_comm_vat
, trunc( buy_date_time )
, sec_amount
, buy_comm
, buy_comm_vat
, TR_LIB_MATH.PLS( sell_comm, buy_comm )
, TR_LIB_MATH.PLS( sell_comm_vat, buy_comm_vat )
from V_TR_INQ_REP_COMM
where inquiry_id = :inq_id
order
by sec_sec
, sell_date_time
, sell_short_ticket
, buy_short_ticket
,INQ_ID,INQ_ID,System.Int64,_x0031_05857707,False,False
EngineV1
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,4,380,4
Transparent
0,0,340,4
Courier New,8,Bold
16a819440b4f4e3c8f66add9013b39f9
Center
0,0,0,0
Text73
TITLE
Black
Expression
Center
ReportTitleBand1
Transparent
0,16,380,12
All;Black;1;Solid;False;4;Black
Transparent
0,0,32,12
Courier New,8,Bold
Center
0,0,0,0
Text1
Security
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Black;1;Solid;False;4;Black
Transparent
32,0,28,12
Courier New,8,Bold
686936e41c7f4310b85568ce704be835
Center
0,0,0,0
Text3
Stock code
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Black;1;Solid;False;4;Black
Transparent
60,0,28,12
Courier New,8,Bold
2de02a7f180143f0b56420e417bab9a7
Center
0,0,0,0
Text6
Date
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Black;1;Solid;False;4;Black
Transparent
88,0,28,12
Courier New,8,Bold
3154a29587e74e84a403bf66ba4c9de2
Center
0,0,0,0
Text7
Amount
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
All;Black;1;Solid;False;4;Black
Transparent
116,0,28,12
Courier New,8,Bold
f350e477ec674ed29ce0ff5d74418d0e
Center
0,0,0,0
Text8
Commission
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression
Center
HeaderBand1
True
False
Transparent
0,36,380,4
All;Black;1;Solid;False;4;Black
Transparent
0,0,32,4
Courier New,8
8fd3aafbad31481cbc6c68b39059064f
0,0,0,0
Text2
{MAIN.SEC_SEC}
Black
Expression
All;Black;1;Solid;False;4;Black
Transparent
32,0,28,4
Courier New,8
d5245f5ffda541f3987428b8044bfd43
0,0,0,0
Text4
{MAIN.SEC_CODE_REGISTRY}
Black
Expression
All;Black;1;Solid;False;4;Black
Transparent
60,0,28,4
Courier New,8
25711ec4c0134ad48c2418f8a0a185cc
Center
0,0,0,0
Text17
{MAIN.TRUNC_SELL_DATE_TIME_}
Black
DataColumn
All;Black;1;Solid;False;4;Black
Transparent
88,0,28,4
Courier New,8
63852524e0c6436489c9254429213c8f
Right
0,0,0,0
Text18
{MAIN.SEC_AMOUNT}
Black
DataColumn
All;Black;1;Solid;False;4;Black
Transparent
116,0,28,4
Courier New,8
48cabd6370d64e09a93eb040223b9c81
Right
0,0,0,0
Text19
{MAIN.SELL_COMM}
Black
1
DataColumn
MAIN
110bf3265d464695ab0a3709108d188e
DataBand1
Transparent
0,48,380,4
EmptyBand1
Transparent
0,60,380,4
EmptyBand2
Transparent
0,72,380,4
All;Black;1;Solid;False;4;Black
Transparent
0,0,60,4
Courier New,8,Bold
b34f1406c03940cb9e47badb9ef22c9d
0,0,0,0
Text28
MADE BY
Black
Expression
Center
All;Black;1;Solid;False;4;Black
Transparent
60,0,140,4
Courier New,8
Center
0,0,0,0
Text29
{TITLE.PRN}
Black
Expression
Center
All;Black;1;Solid;False;4;Black
Transparent
200,0,28,4
Courier New,8
Right
0,0,0,0
Text30
{TITLE.OPER_DATE}
Black
Expression
Center
ReportSummaryBand1
0d7d42b532eb41698d262681e9a5c102
10,10,10,10
Page1
Landscape
210
400
A4
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
Отчет
3/5/2024 3:49:42 AM
8/3/2017 5:39:49 PM
C:\Fund\Forms.0\Trfs_Bin_4.0\REPORT_COMM_REAL_SEC.mrt
74a176ecf02345bdb51723a21ec1ba67
Отчет
Millimeters
2013.3.1800
CSharp