96 lines
6.2 KiB
XML
96 lines
6.2 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report ScriptLanguage="CSharp" ReportInfo.Created="08/22/2017 01:05:12" ReportInfo.Modified="03/16/2020 09:25:09" ReportInfo.CreatorVersion="2017.1.16.0">
|
|
<ScriptText>using System;
|
|
using System.Collections;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Windows.Forms;
|
|
using System.Drawing;
|
|
using System.Data;
|
|
using FastReport;
|
|
using FastReport.Data;
|
|
using FastReport.Dialog;
|
|
using FastReport.Barcode;
|
|
using FastReport.Table;
|
|
using FastReport.Utils;
|
|
|
|
namespace FastReport
|
|
{
|
|
public class ReportScript
|
|
{
|
|
|
|
private void Cell5_AfterData(object sender, EventArgs e)
|
|
{
|
|
if(Cell5.Text.Contains("小计"))
|
|
{
|
|
|
|
Font f = new System.Drawing.Font("宋体", 15F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
|
|
Cell5.Font=f;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
</ScriptText>
|
|
<Dictionary>
|
|
<MsSqlDataConnection Name="Connection" ConnectionString="rijcmlq+rW0RkboK+/8CKGGYUID3ctBV8q9SvKYxl3iiE7vBnh7Tgou0+4WFf3NfmPSvHVFbgAuMkhKi1+dg3SnVy9+79pRZi64OOHjC6MK1u8gcNFgi3jlsydEl1HlIE2kOieySm7C003q2bWQCvM/TyXduJ7G1TcD9tAbCyGQedNyOfibQGvBdywrcP1OeCspucvQ">
|
|
<TableDataSource Name="Table" Alias="Table1" DataType="System.Int32" Enabled="true" SelectCommand="select '' as sfxm,'' as sl,'' as dj,'' as xj">
|
|
<Column Name="sfxm" DataType="System.String"/>
|
|
<Column Name="sl" DataType="System.String"/>
|
|
<Column Name="dj" DataType="System.String"/>
|
|
<Column Name="xj" DataType="System.String"/>
|
|
</TableDataSource>
|
|
</MsSqlDataConnection>
|
|
<Parameter Name="start" DataType="System.String"/>
|
|
<Parameter Name="end" DataType="System.String"/>
|
|
<Parameter Name="sffstj" DataType="System.String"/>
|
|
</Dictionary>
|
|
<ReportPage Name="Page1">
|
|
<ReportTitleBand Name="ReportTitle1" Width="718.2" Height="113.4">
|
|
<TextObject Name="Text1" Left="18.9" Width="699.3" Height="37.8" Text="收 费 统 计" HorzAlign="Center" VertAlign="Center" Font="宋体, 22pt, style=Bold"/>
|
|
<TextObject Name="Text2" Left="18.9" Top="37.8" Width="113.4" Height="37.8" Text="汇总日期：" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text4" Left="548.1" Top="37.8" Width="94.5" Height="37.8" Text="所附单据" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text5" Left="633.15" Top="37.8" Width="47.25" Height="37.8" Border.Lines="Bottom" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text6" Left="680.4" Top="37.8" Width="37.8" Height="37.8" Text="张" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text7" Left="132.3" Top="37.8" Width="170.1" Height="37.8" Text="[Date]" Format="Date" Format.Format="D" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text8" Left="18.9" Top="75.6" Width="113.4" Height="37.8" Text="收费日期：" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text9" Left="132.3" Top="75.6" Width="170.1" Height="37.8" Text="[start]" Format="Date" Format.Format="D" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text10" Left="302.4" Top="75.6" Width="18.9" Height="37.8" Text="~" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text11" Left="321.3" Top="75.6" Width="217.35" Height="37.8" Text="[end]" Format="Date" Format.Format="D" VertAlign="Center" Font="宋体, 14pt"/>
|
|
</ReportTitleBand>
|
|
<DataBand Name="Data1" Top="161.59" Width="718.2" Height="28.35" DataSource="Table">
|
|
<TableObject Name="Table2" Left="18.9" Width="698.93" Height="28.35" Border.Lines="All">
|
|
<TableColumn Name="Column5" Width="364.01"/>
|
|
<TableColumn Name="Column6" Width="80.14"/>
|
|
<TableColumn Name="Column7" Width="108.49"/>
|
|
<TableColumn Name="Column8" Width="146.29"/>
|
|
<TableRow Name="Row2" Height="28.35">
|
|
<TableCell Name="Cell5" Border.Lines="All" AfterDataEvent="Cell5_AfterData" Text="[Table1.sfxm]" VertAlign="Center" Font="宋体, 12pt"/>
|
|
<TableCell Name="Cell6" Border.Lines="All" Text="[Table1.sl]" HorzAlign="Right" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TableCell Name="Cell7" Border.Lines="All" Text="[Table1.dj]" HorzAlign="Right" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TableCell Name="Cell8" Border.Lines="All" Text="[Table1.xj]" HorzAlign="Center" VertAlign="Center" Font="宋体, 14pt"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
<DataHeaderBand Name="DataHeader1" Top="118.59" Width="718.2" Height="37.8">
|
|
<TableObject Name="Table1" Left="18.9" Top="9.45" Width="698.96" Height="28.35" Border.Lines="All">
|
|
<TableColumn Name="Column1" Width="363.74"/>
|
|
<TableColumn Name="Column2" Width="80.24"/>
|
|
<TableColumn Name="Column3" Width="108.59"/>
|
|
<TableColumn Name="Column4" Width="146.39"/>
|
|
<TableRow Name="Row1" Height="28.35">
|
|
<TableCell Name="Cell1" Border.Lines="All" Text="收费项目" HorzAlign="Center" VertAlign="Center" Font="宋体, 14pt, style=Bold"/>
|
|
<TableCell Name="Cell2" Border.Lines="All" Text="数量" HorzAlign="Center" VertAlign="Center" Font="宋体, 14pt, style=Bold"/>
|
|
<TableCell Name="Cell3" Border.Lines="All" Text="单价" HorzAlign="Center" VertAlign="Center" Font="宋体, 14pt, style=Bold"/>
|
|
<TableCell Name="Cell4" Border.Lines="All" Text="小计" HorzAlign="Center" VertAlign="Center" Font="宋体, 14pt, style=Bold"/>
|
|
</TableRow>
|
|
</TableObject>
|
|
</DataHeaderBand>
|
|
<DataFooterBand Name="DataFooter1" Top="195.13" Width="718.2" Height="94.5">
|
|
<TextObject Name="Text3" Left="18.9" Width="699.3" Height="28.35" Border.Lines="All" Text="[sffstj]" VertAlign="Center" Font="黑体, 14pt, style=Bold"/>
|
|
<TextObject Name="Text12" Left="18.9" Top="56.7" Width="160.65" Height="37.8" Text="交款人：" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text13" Left="274.05" Top="56.7" Width="160.65" Height="37.8" Text="收款人：" VertAlign="Center" Font="宋体, 14pt"/>
|
|
<TextObject Name="Text14" Left="548.1" Top="56.7" Width="160.65" Height="37.8" Text="复核人：" VertAlign="Center" Font="宋体, 14pt"/>
|
|
</DataFooterBand>
|
|
</DataBand>
|
|
</ReportPage>
|
|
</Report>
|