<?xml version="1.0" encoding="utf-8"?>
|
<Report ScriptLanguage="CSharp" ReportInfo.Created="11/03/2020 09:15:48" ReportInfo.Modified="11/04/2020 10:06:30" ReportInfo.CreatorVersion="2018.4.2.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 Text16_BeforePrint(object sender, EventArgs e)
|
{
|
Text16.Text="第 "+Convert.ToString(((Int32)Report.GetVariableValue("Page"))-0)+" 页";
|
}
|
}
|
}
|
</ScriptText>
|
<Styles Name="Gray">
|
<Style Name="Title" Font="宋体, 12pt, style=Bold"/>
|
<Style Name="Header" Fill.Color="Gainsboro" Font="宋体, 10pt, style=Bold"/>
|
<Style Name="Group" Font="宋体, 10pt, style=Bold"/>
|
<Style Name="Data"/>
|
<Style Name="Footer" Fill.Color="Gainsboro"/>
|
<Style Name="EvenRows" Fill.Color="WhiteSmoke"/>
|
</Styles>
|
<Dictionary>
|
<MsSqlDataConnection Name="Connection" ConnectionString="rijcmlqHwzMSgwTFaHpjtG3vsOj8Q9j98uNTIkJPCtutysyaPPLahZmez9+u+qpMBrinHhsH0G4yoCbFR5OkipqoGJtGTxsais4CHMqU7ffXTV30VN44GT1D6Dy6xuk3PAPX57rcHQ4WSMY/4XX9Z2dwXKp7vfNiKRso7NRSIbsUN20TuxkwIlAx90zZwdTxE6tyDs2cByD96vCaziZKHW/3c26Rg==">
|
<TableDataSource Name="View_StroeMat_Material" DataType="System.Int32" Enabled="true" TableName="View_StroeMat_Material">
|
<Column Name="MatNo" DataType="System.String"/>
|
<Column Name="MatName" DataType="System.String"/>
|
<Column Name="Quant" DataType="System.String"/>
|
<Column Name="Quant_Out" DataType="System.String"/>
|
<Column Name="Quant_Outing" DataType="System.String"/>
|
<Column Name="PackFormat" DataType="System.String"/>
|
<Column Name="UnitName" DataType="System.String"/>
|
<Column Name="BrandName" DataType="System.String"/>
|
<Column Name="NWeight" DataType="System.String"/>
|
<Column Name="Long" DataType="System.String"/>
|
<Column Name="Width" DataType="System.String"/>
|
<Column Name="Height" DataType="System.String"/>
|
<Column Name="MatType" DataType="System.String"/>
|
<Column Name="Unit" DataType="System.String"/>
|
<Column Name="BrandId" DataType="System.String"/>
|
<Column Name="MatTypeId" DataType="System.String"/>
|
</TableDataSource>
|
</MsSqlDataConnection>
|
<MsSqlDataConnection Name="Connection1" ConnectionString="rijcmlqHwzMSgwTFaHpjtG3vsOj8Q9j98uNTIkJPCtutysyaPPLahZmez9+u+qpMBrinHhsH0G4yoCbFR5OkipqoGJtGTxsais4CHMqU7ffXTV30VN44GT1D6Dy6xuk3PAPX57rcHQ4WSMY/4XX9Z2dwXKp7vfNiKRso7NRSIbsUN20TuxkwIlAx90zZwdTxE6tyDs26Th2hpgOefaDaMiJqpVFlw==">
|
<TableDataSource Name="UserInfo" DataType="System.Int32" Enabled="true" TableName="UserInfo">
|
<Column Name="ID" DataType="System.Int32"/>
|
<Column Name="UserCode" DataType="System.String"/>
|
<Column Name="UserName" DataType="System.String"/>
|
<Column Name="Pwd" DataType="System.String"/>
|
<Column Name="RealName" DataType="System.String"/>
|
<Column Name="RoleNum" DataType="System.String"/>
|
<Column Name="DepartNum" DataType="System.String"/>
|
<Column Name="Mobile" DataType="System.String"/>
|
<Column Name="Phone" DataType="System.String"/>
|
<Column Name="Email" DataType="System.String"/>
|
<Column Name="Ord" DataType="System.Int32"/>
|
<Column Name="IsDel" DataType="System.Int32"/>
|
<Column Name="CreatUser" DataType="System.String"/>
|
<Column Name="CreatTime" DataType="System.DateTime"/>
|
<Column Name="UpdateUser" DataType="System.String"/>
|
<Column Name="UpdateTime" DataType="System.DateTime"/>
|
<Column Name="Demo" DataType="System.String"/>
|
<Column Name="guid" DataType="System.String"/>
|
<Column Name="Sex" DataType="System.Int32"/>
|
<Column Name="IDcard" DataType="System.String"/>
|
<Column Name="Address" DataType="System.String"/>
|
</TableDataSource>
|
</MsSqlDataConnection>
|
</Dictionary>
|
<ReportPage Name="Page1" RawPaperSize="9" LeftMargin="5" RightMargin="5" FirstPageSource="15" OtherPagesSource="15" Guides="311.85,434.7,444.15,510.3,595.35,642.6,604.8,737.1,0,103.95,255.15,321.3,472.5,557.55,661.5,756">
|
<ReportTitleBand Name="ReportTitle1" Width="756" Height="47.25" Guides="0,28.35,47.25">
|
<TextObject Name="Text1" Left="311.85" Width="122.85" Height="28.35" Text="库存统计" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 12pt, style=Bold" Style="Title"/>
|
<TextObject Name="Text17" Left="444.15" Top="28.35" Width="66.15" Height="18.9" Text="统计人：" HorzAlign="Center" VertAlign="Bottom"/>
|
<TextObject Name="Text18" Left="595.35" Top="28.35" Width="47.25" Height="18.9" Text="日期：" HorzAlign="Center" VertAlign="Bottom"/>
|
<TextObject Name="Text19" Left="510.3" Top="28.35" Width="94.5" Height="18.9" Text="[UserInfo.UserName]" VertAlign="Bottom"/>
|
<TextObject Name="Text20" Left="642.6" Top="28.35" Width="94.5" Height="18.9" Text="[UserInfo.CreatTime]" Format="Date" Format.Format="d" VertAlign="Bottom"/>
|
</ReportTitleBand>
|
<PageHeaderBand Name="PageHeader1" Top="50.11" Width="756" Height="18.9" Guides="0,18.9">
|
<TextObject Name="Text3" Width="103.95" Height="18.9" Fill.Color="Gainsboro" Text="物料编码" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
|
<TextObject Name="Text5" Left="103.95" Width="151.2" Height="18.9" Fill.Color="Gainsboro" Text="物料名称" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
|
<TextObject Name="Text7" Left="255.15" Width="66.15" Height="18.9" Fill.Color="Gainsboro" Text="数量" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
|
<TextObject Name="Text9" Left="321.3" Width="151.2" Height="18.9" Fill.Color="Gainsboro" Text="规格型号" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
|
<TextObject Name="Text11" Left="472.5" Width="85.05" Height="18.9" Fill.Color="Gainsboro" Text="单位" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
|
<TextObject Name="Text13" Left="557.55" Width="103.95" Height="18.9" Fill.Color="Gainsboro" Text="品牌" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
|
<TextObject Name="Text15" Left="661.5" Width="94.5" Height="18.9" Fill.Color="Gainsboro" Text="类别" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
|
</PageHeaderBand>
|
<DataBand Name="Data1" Top="71.86" Width="756" Height="18.9" EvenStyle="EvenRows" Guides="0,18.9" DataSource="View_StroeMat_Material">
|
<TextObject Name="Text2" Width="103.95" Height="18.9" CanGrow="true" Text="[View_StroeMat_Material.MatNo]" VertAlign="Bottom" Style="Data"/>
|
<TextObject Name="Text4" Left="103.95" Width="151.2" Height="18.9" CanGrow="true" Text="[View_StroeMat_Material.MatName]" VertAlign="Bottom" Style="Data"/>
|
<TextObject Name="Text6" Left="255.15" Width="66.15" Height="18.9" CanGrow="true" Text="[View_StroeMat_Material.Quant]" VertAlign="Bottom" Style="Data"/>
|
<TextObject Name="Text8" Left="321.3" Width="151.2" Height="18.9" CanGrow="true" Text="[View_StroeMat_Material.PackFormat]" VertAlign="Bottom" Style="Data"/>
|
<TextObject Name="Text10" Left="472.5" Width="85.05" Height="18.9" CanGrow="true" Text="[View_StroeMat_Material.UnitName]" VertAlign="Bottom" Style="Data"/>
|
<TextObject Name="Text12" Left="557.55" Width="103.95" Height="18.9" CanGrow="true" Text="[View_StroeMat_Material.BrandName]" VertAlign="Bottom" Style="Data"/>
|
<TextObject Name="Text14" Left="661.5" Width="94.5" Height="18.9" CanGrow="true" Text="[View_StroeMat_Material.MatType]" VertAlign="Bottom" Style="Data"/>
|
</DataBand>
|
<PageFooterBand Name="PageFooter1" Top="93.62" Width="756" Height="18.9" Guides="0,18.9">
|
<TextObject Name="Text16" Width="756" Height="18.9" Dock="Fill" Fill.Color="Gainsboro" BeforePrintEvent="Text16_BeforePrint" Text="[PageN]" ProcessAt="PageFinished" HorzAlign="Center" VertAlign="Bottom" Style="Footer"/>
|
</PageFooterBand>
|
</ReportPage>
|
</Report>
|
