DocumentUsageReport.frx
10.7 KB
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
92
93
94
95
96
97
98
<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReferencedAssemblies="System.dll System.Core.dll System.Drawing.dll System.Windows.Forms.dll System.Data.dll System.Xml.dll Sungero.Domain.Shared Sungero.CoreEntities.Shared Sungero.Reporting.Shared CommonLibrary Sungero.Company.Shared Sungero.Company.Server Sungero.Domain.Interfaces Sungero.Docflow.Shared Sungero.Docflow.Server" StartReportEvent="_StartReport" ReportInfo.CreatorVersion="2020.2.12.0">
<ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text.RegularExpressions;
using System.Windows.Forms;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;
using Sungero.Company;
using Sungero.Domain.Shared;
using Sungero.CoreEntities;
using Sungero.Core;
using Resources = Sungero.Docflow.Reports.Resources;
namespace FastReport
{
public class ReportScript
{
private void _StartReport(object sender, EventArgs e)
{
if ((ReportExportFormat)Report.GetParameterValue("ExportFormat") == ReportExportFormat.Excel)
{
Page1.UnlimitedHeight = true;
}
}
}
}
</ScriptText>
<Dictionary>
<SungeroSqlDataConnection Name="Sungero_Connection" Restrictions="DontModify, DontEdit, DontDelete, HideAllProperties" ConnectionStringExpression="[SungeroConnectionString]">
<TableDataSource Name="Table" Alias="DocumentUsage" DataType="System.Int32" Enabled="true" CanEdit="true" SelectCommand="${ResultQuery}">
<Column Name="Employee" DataType="System.String" PropName="Column"/>
<Column Name="JobTitle" DataType="System.String" PropName="Column"/>
<Column Name="Department" DataType="System.String" PropName="Column"/>
<Column Name="Created" DataType="System.Int32" PropName="Column"/>
<Column Name="Updated" DataType="System.Int32" PropName="Column"/>
<Column Name="Readed" DataType="System.Int32" PropName="Column"/>
<CommandParameter Name="ReportSessionId" DataType="16" IsDbType="true" Expression="[ReportSessionId]"/>
</TableDataSource>
</SungeroSqlDataConnection>
<SungeroParameter Name="SungeroConnectionString" Restrictions="DontModify, DontEdit, DontDelete, HideAllProperties, DontShow" Id="9b8edffa-343c-49e0-8d40-2412f69cbff7" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="PeriodBegin" Id="34a1f6ea-2c4e-4ac7-b452-83d1cced9c44" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="PeriodEnd" Id="a6d314fa-ea3c-4892-b9ae-8441626f02f9" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="Department" Id="e201353f-c8bb-4a45-bf45-894958e74399" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IDepartment, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="61b1c19f-26e2-49a5-b3d3-0d3618151e12"/>
<SungeroParameter Name="DepartmentId" Id="d3ee3aea-ac3d-447c-95f8-2babf9444665" IsRequired="false" IsCollection="false" InternalDataType="System.Int32" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="ClientPeriodEnd" Id="4c0dc683-7872-4f50-b7a3-3e830a35827b" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="ReportDate" Id="451f7d8b-9668-4af1-b01c-b565686f99b2" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="ClientPeriodBegin" Id="c0859024-ee96-43d3-a323-9225a429c08d" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="Empty" Id="6a3cb071-fdd6-4ec6-8897-c642bb668ebe" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
<SungeroParameter Name="ReportSessionId" Id="0a19b226-2828-407d-8fab-5a2db25be2de" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
</Dictionary>
<ReportPage Name="Page1" FirstPageSource="15" OtherPagesSource="15" Watermark.Font="Arial, 60pt">
<ReportTitleBand Name="ReportTitle1" Width="718.2" Height="85.05" CanGrow="true">
<TextObject Name="Text8" Top="56.7" Width="718.2" Height="28.35" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.PeriodFrom] [ClientPeriodBegin] [Sungero.Docflow.Reports.Resources.DocumentUsageReport.PeriodTo] [ClientPeriodEnd]" HorzAlign="Center" Font="Arial, 12pt, style=Bold">
<Formats>
<DateFormat/>
<DateFormat/>
</Formats>
</TextObject>
<TextObject Name="Text9" Width="718.2" Height="18.9" Text="[Empty][ReportDate]" HorzAlign="Right" VertAlign="Center" Font="Arial, 10pt">
<Formats>
<GeneralFormat/>
<DateFormat/>
</Formats>
</TextObject>
<TextObject Name="Text18" Top="18.9" Width="718.2" Height="37.8" Text="[Sungero.Docflow.Resources.DocumentUsageReport]" HorzAlign="Center" VertAlign="Center" Font="Arial, 14pt, style=Bold"/>
</ReportTitleBand>
<PageHeaderBand Name="PageHeader1" Top="89.05" Width="718.2" Height="56.88" CanGrow="true">
<TextObject Name="Text1" Width="122.85" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.EmployeeName]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
<TextObject Name="Text2" Left="122.85" Width="122.85" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.JobTitle]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
<TextObject Name="Text3" Left="245.7" Width="122.85" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.Department]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
<TextObject Name="Text7" Left="652.05" Width="66.15" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.TotalDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
<TextObject Name="Text5" Left="463.05" Width="94.5" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.EditedDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
<TextObject Name="Text4" Left="368.55" Width="94.5" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.CreatedDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
<TextObject Name="Text6" Left="557.55" Width="94.5" Height="56.7" Border.Lines="All" CanGrow="true" CanShrink="true" GrowToBottom="true" CanBreak="false" Text="[Sungero.Docflow.Reports.Resources.DocumentUsageReport.ViewedDocumentsAmount]" HorzAlign="Center" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
</PageHeaderBand>
<DataBand Name="Data1" Top="149.93" Width="718.2" Height="37.8" CanGrow="true" CanBreak="true" DataSource="Table">
<TextObject Name="Text10" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Employee]" Padding="3, 3, 3, 3" VertAlign="Center" Font="Arial, 9pt"/>
<TextObject Name="Text11" Left="122.85" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.JobTitle]" Padding="3, 3, 3, 3" VertAlign="Center" Font="Arial, 9pt"/>
<TextObject Name="Text12" Left="245.7" Width="122.85" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Department]" Padding="3, 3, 3, 3" VertAlign="Center" Font="Arial, 9pt"/>
<TextObject Name="Text13" Left="368.55" Width="94.5" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Created]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
<TextObject Name="Text14" Left="463.05" Width="94.5" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Updated]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
<TextObject Name="Text15" Left="557.55" Width="94.5" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[DocumentUsage.Readed]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
<TextObject Name="Text16" Left="652.05" Width="66.15" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[[DocumentUsage.Created]+[DocumentUsage.Updated]+[DocumentUsage.Readed]]" Padding="3, 3, 5, 3" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt, style=Bold"/>
</DataBand>
<PageFooterBand Name="PageFooter1" Top="191.73" Width="718.2" Height="18.9"/>
</ReportPage>
</Report>