ExchangeServiceDocumentReport.frx 11.1 KB
<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReferencedAssemblies="System.dll&#13;&#10;System.Core.dll&#13;&#10;System.Drawing.dll&#13;&#10;System.Windows.Forms.dll&#13;&#10;System.Data.dll&#13;&#10;System.Xml.dll&#13;&#10;Sungero.Domain.Shared&#13;&#10;Sungero.CoreEntities.Shared&#13;&#10;Sungero.Reporting.Shared&#13;&#10;CommonLibrary&#13;&#10;Sungero.CoreEntities.Server&#13;&#10;Sungero.Domain&#13;&#10;Sungero.Domain.Interfaces&#13;&#10;Sungero.Company.Shared&#13;&#10;Sungero.Company.Server&#13;&#10;Sungero.Parties.Shared&#13;&#10;Sungero.Parties.Server&#13;&#10;Sungero.ExchangeCore.Shared&#13;&#10;Sungero.ExchangeCore.Server&#13;&#10;Sungero.Docflow.Shared&#13;&#10;Sungero.Docflow.Server" 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.Parties;
using Sungero.ExchangeCore;
using Sungero.Domain.Shared;
using Sungero.CoreEntities;
using Sungero.Core;
using Resources = Sungero.Docflow.Reports.Resources;


namespace FastReport
{
  public class ReportScript
  {
  }
}
  </ScriptText>
  <Dictionary>
    <SungeroSqlDataConnection Name="Sungero_Connection" Restrictions="DontModify, DontEdit, DontDelete, HideAllProperties" ConnectionStringExpression="[SungeroConnectionString]">
      <TableDataSource Name="Table" Alias="Docs" DataType="System.Int32" Enabled="true" CanEdit="true" SelectCommand="${SourceQuery}">
        <Column Name="BusinessUnitName" DataType="System.String" PropName="Column"/>
        <Column Name="BusinessUnitId" DataType="System.Int32" PropName="Column"/>
        <Column Name="DocName" DataType="System.String" PropName="Column"/>
        <Column Name="DocId" DataType="System.Int32" PropName="Column"/>
        <Column Name="Counterparty" DataType="System.String" PropName="Column"/>
        <Column Name="SendDate" DataType="System.String" PropName="Column"/>
        <Column Name="Hyperlink" DataType="System.String" PropName="Column"/>
        <Column Name="Responsible" DataType="System.String" PropName="Column"/>
        <Column Name="Delay" DataType="System.String" PropName="Column"/>
        <Column Name="ExchangeService" DataType="System.String" PropName="Column"/>
        <Column Name="Department" DataType="System.String" PropName="Column"/>
        <Column Name="ReportSessionId" Enabled="false" DataType="System.String" PropName="Column"/>
        <CommandParameter Name="ReportSessionId" DataType="16" IsDbType="true" Expression="[ReportSessionId]"/>
      </TableDataSource>
    </SungeroSqlDataConnection>
    <SungeroParameter Name="SungeroConnectionString" Restrictions="DontModify, DontEdit, DontDelete, HideAllProperties, DontShow" Id="89a976ec-62e3-41d8-bdde-3b0cbc4e089f" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="DocumentsTableName" Id="7a6f655b-5b70-4e16-8cd1-2ade131c4b31" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="BusinessUnit" Id="98d37464-86dc-417b-aad9-877ad5e09def" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IBusinessUnit, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="eff95720-181f-4f7d-892d-dec034c7b2ab"/>
    <SungeroParameter Name="Department" Id="4c678037-35ab-4343-9bba-f673cdd01571" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IDepartment, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="61b1c19f-26e2-49a5-b3d3-0d3618151e12"/>
    <SungeroParameter Name="Employee" Id="38a95a37-3560-480e-98f0-b5fc1133b47a" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Company.IEmployee, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="b7905516-2be5-4931-961c-cb38d5677565"/>
    <SungeroParameter Name="Counterparty" Id="9a8f9c22-b6df-4582-aaa3-f95c507333ac" IsRequired="false" IsCollection="false" InternalDataType="Sungero.Parties.ICounterparty, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="294767f1-009f-4fbd-80fc-f98c49ddc560"/>
    <SungeroParameter Name="ExchangeService" Id="ada2c6f2-31fb-4ea9-8b93-abc683621495" IsRequired="false" IsCollection="true" InternalDataType="Sungero.ExchangeCore.IExchangeService, Sungero.Domain.Interfaces" IsSimpleDataType="false" EntityTypeId="d6c0fcaf-4ac9-4a6a-9e2c-8fed1e35c08a"/>
    <SungeroParameter Name="SendDateFrom" Id="7f6638ce-6935-4513-95cc-ba6521696de1" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="SendDateTo" Id="d9ddc857-d022-4727-b5fe-963a46051c23" IsRequired="false" IsCollection="false" InternalDataType="System.DateTime" IsSimpleDataType="true" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="SendPeriod" Id="955f07b9-3b50-4bae-8f8c-1285d9c405a0" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ParametersInfo" Id="d95750e4-a424-449f-84b1-dc3fe589a6e4" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
    <SungeroParameter Name="ReportSessionId" Id="9278ee20-c6c4-4d01-ad26-f9b1de22a4c2" IsRequired="false" IsCollection="false" InternalDataType="System.String" IsSimpleDataType="false" EntityTypeId="00000000-0000-0000-0000-000000000000"/>
  </Dictionary>
  <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" FirstPageSource="15" OtherPagesSource="15" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="85.05" CanGrow="true">
      <TextObject Name="Text12" Left="945" Top="9.45" Width="94.5" Height="18.9" Text="[Sungero.Core.Calendar.Now]" Format="Date" Format.Format="d" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Text14" Left="226.8" Top="56.7" Width="595.35" Height="28.35" CanBreak="false" Text="[SendPeriod]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Text15" Left="132.3" Top="28.35" Width="784.35" Height="28.35" Text="[Resources.ExchangeServiceDocumentReport.ReportName]" HorzAlign="Center" VertAlign="Center" Font="Arial, 14pt, style=Bold"/>
      <TextObject Name="Text16" Left="9.45" Top="9.45" Width="519.75" Height="18.9" CanGrow="true" Text="[ParametersInfo]" Font="Arial, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="89.05" Width="1047.06" Height="37.8">
      <TextObject Name="Text1" Width="378" Height="37.8" Border.Lines="All" Text="[Resources.ExchangeServiceDocumentReport.Document]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text2" Left="378" Width="56.7" Height="37.8" Border.Lines="All" Text="[Resources.ExchangeServiceDocumentReport.Id]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text3" Left="434.7" Width="189" Height="37.8" Border.Lines="All" Text="[Resources.ExchangeServiceDocumentReport.Counterparty]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text5" Left="973.35" Width="66.15" Height="37.8" Border.Lines="All" Text="[Resources.ExchangeServiceDocumentReport.Delay]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text17" Left="888.3" Width="85.05" Height="37.8" Border.Lines="All" Text="[Resources.ExchangeServiceDocumentReport.SendDate]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text19" Left="708.75" Width="179.55" Height="37.8" Border.Lines="All" Text="[Resources.ExchangeServiceDocumentReport.ResponsibleHeaderName]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text21" Left="623.7" Width="85.05" Height="37.8" Border.Lines="All" Text="[Resources.ExchangeServiceDocumentReport.ExchangeService]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
    </PageHeaderBand>
    <GroupHeaderBand Name="GroupHeader1" Top="130.85" Width="1047.06" Height="37.8" CanGrow="true" Condition="[Docs.BusinessUnitId]">
      <TextObject Name="Text6" Width="1039.5" Height="37.8" Border.Lines="All" Text="[Docs.BusinessUnitName]" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <DataBand Name="Data1" Top="172.65" Width="1047.06" Height="37.8" CanGrow="true" DataSource="Table">
        <TextObject Name="Text7" Width="378" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[Docs.DocName]" Padding="13, 1, 2, 1" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text8" Left="378" Width="56.7" Height="37.8" Border.Lines="All" Cursor="Hand" Hyperlink.Expression="[Docs.Hyperlink]" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[Docs.DocId]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Underline" TextFill.Color="Blue"/>
        <TextObject Name="Text9" Left="434.7" Width="189" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[Docs.Counterparty]" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text11" Left="973.35" Width="66.15" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[Docs.Delay]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text18" Left="888.3" Width="85.05" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[Docs.SendDate]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text20" Left="708.75" Width="179.55" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[Docs.Responsible] [Docs.Department]" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text22" Left="623.7" Width="85.05" Height="37.8" Border.Lines="All" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[Docs.ExchangeService]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <Sort>
          <Sort Expression="[Docs.SendDate]"/>
          <Sort Expression="[Docs.DocName]"/>
        </Sort>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="214.45" Width="1047.06"/>
    </GroupHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="218.45" Width="1047.06" Height="18.9">
      <TextObject Name="Text13" Left="945" Width="94.5" Height="18.9" Text="[Page]" HorzAlign="Right" Font="Arial, 10pt"/>
    </PageFooterBand>
  </ReportPage>
</Report>