修改测试

bklLiudl

2024-07-23 675b8bcc4a3630d95e3d0b97d933e63442075ecb

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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="11/03/2020 09:15:48" ReportInfo.Modified="06/11/2021 10:16:08" 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=&quot;第 &quot;+Convert.ToString(((Int32)Report.GetVariableValue(&quot;Page&quot;))-0)+&quot; 页&quot;;
    }
  }
}
</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/4XX9Z2dwXKp7vfNiKRso7NRSIbsUN20TuxkwIlAx90zZwdTxE6tyDs216BarkVx//0azYQzNJYKKA==">
      <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/4XX9Z2dwXKp7vfNiKRso7NRSIbsUN20TuxkwIlAx90zZwdTxE6tyDs2Q3ajOkiYgobhSrta3ozmjw==">
      <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,302.4,359.1,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" Border.Lines="All" Fill.Color="Gainsboro" Text="物料编码" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
      <TextObject Name="Text5" Left="103.95" Width="198.45" Height="18.9" Border.Lines="All" Fill.Color="Gainsboro" Text="物料名称" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
      <TextObject Name="Text7" Left="302.4" Width="56.7" Height="18.9" Border.Lines="All" Fill.Color="Gainsboro" Text="数量" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
      <TextObject Name="Text9" Left="359.1" Width="236.25" Height="18.9" Border.Lines="All" Fill.Color="Gainsboro" Text="规格型号" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
      <TextObject Name="Text11" Left="595.35" Width="66.15" Height="18.9" Border.Lines="All" Fill.Color="Gainsboro" Text="单位" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 10pt, style=Bold" Style="Header"/>
      <TextObject Name="Text15" Left="661.5" Width="94.5" Height="18.9" Border.Lines="All" Fill.Color="Gainsboro" Text="类别" HorzAlign="Center" 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" Border.Lines="All" CanGrow="true" Text="[View_StroeMat_Material.MatNo]" HorzAlign="Center" VertAlign="Bottom" Style="Data"/>
      <TextObject Name="Text4" Left="103.95" Width="198.45" Height="18.9" Border.Lines="All" CanGrow="true" Text="[View_StroeMat_Material.MatName]" HorzAlign="Center" VertAlign="Bottom" Style="Data"/>
      <TextObject Name="Text6" Left="302.4" Width="56.7" Height="18.9" Border.Lines="All" CanGrow="true" Text="[View_StroeMat_Material.Quant]" HorzAlign="Center" VertAlign="Bottom" Style="Data"/>
      <TextObject Name="Text8" Left="359.1" Width="236.25" Height="18.9" Border.Lines="All" CanGrow="true" Text="[View_StroeMat_Material.PackFormat]" HorzAlign="Center" VertAlign="Bottom" Style="Data"/>
      <TextObject Name="Text10" Left="595.35" Width="66.15" Height="18.9" Border.Lines="All" CanGrow="true" Text="[View_StroeMat_Material.UnitName]" HorzAlign="Center" VertAlign="Bottom" Style="Data"/>
      <TextObject Name="Text14" Left="661.5" Width="94.5" Height="18.9" Border.Lines="All" CanGrow="true" Text="[View_StroeMat_Material.MatType]" HorzAlign="Center" 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>