<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="12/02/2019 20:01:50" ReportInfo.Modified="01/06/2021 16:40:22" ReportInfo.CreatorVersion="2016.1.0.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 Barcode1_BeforePrint(object sender, EventArgs e)
    //{
         //String proBatchNO =Report.GetColumnValue(&quot;proBatch.proBatchNO&quot;).ToString();
         //int rowNnumber=int.Parse(Report.GetColumnValue(&quot;proBatch.rowNnumber&quot;).ToString());
         //Barcode1.Text= proBatchNO+&quot;.&quot;+rowNnumber.ToString(&quot;D4&quot;);
    //}
  }
 
}
</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="Connection" ConnectionString="rijcmlqHwzMSgwTFaHpjtG3vsOj8V4BVOqWUOQPCsfQyvMT6e6KxP0WED57aggvqTvDLYwGrTQ3STXxehLG0KYkql96Ue69uNBZEKLV+Xhfk98YYjsK2xwJhfSXeHkbOuj9l2z6dUQI3+uacx0jQmSFhYqZZrUY/vCILlnNiCnWjzlY5tNaQDe5xb4pSReKgeahSHwVfVJd2cKoThmfhC2AQ398UA==">
      <TableDataSource Name="Table" Alias="产品" DataType="System.Int32" Enabled="true" SelectCommand="SELECT V.id, V.toid, V.moduleId, V.proId, V.sysClass, V.proName, V.ProAlias, V.Barcode, V.Warehouse, V.Location, V.Unit, V.SalesPrice, V.UnitPrice, V.Description, V.Specifications, V.Brand, V.Origin, V.Supplier, V.SpellCode&#13;&#10;FROM &quot;View_sys_Materials&quot; V where V.id = (@Parameter)">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="toid" DataType="System.Int32"/>
        <Column Name="moduleId" DataType="System.Int32"/>
        <Column Name="proId" DataType="System.String"/>
        <Column Name="sysClass" DataType="System.String"/>
        <Column Name="proName" DataType="System.String"/>
        <Column Name="ProAlias" DataType="System.String"/>
        <Column Name="Warehouse" DataType="System.String"/>
        <Column Name="Location" DataType="System.String"/>
        <Column Name="Unit" DataType="System.String"/>
        <Column Name="SalesPrice" DataType="System.Decimal"/>
        <Column Name="UnitPrice" DataType="System.Decimal"/>
        <Column Name="Description" DataType="System.String"/>
        <Column Name="Specifications" DataType="System.String"/>
        <Column Name="Brand" DataType="System.String"/>
        <Column Name="Origin" DataType="System.String"/>
        <Column Name="Supplier" DataType="System.String"/>
        <Column Name="SpellCode" DataType="System.String"/>
        <Column Name="Barcode" DataType="System.String"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="[Parameter]"/>
      </TableDataSource>
      <TableDataSource Name="Table1" Alias="proBatch" DataType="System.Int32" Enabled="true" SelectCommand="select S.id, S.moduleId, S.toid, S.toProOrderNO, S.proBatchNO, S.proId, S.proName, S.proClass, S.Brand, S.Specification, S.Barcode, S.Unit, S.proBatchQty, S.Remarks,row_number() over(order by S.id) as rowNnumber from &quot;sys_proBatch&quot; S  join master..spt_values s1 on s1.type = 'P' and proBatchQty &gt; s1.number where S.proBatchNO ='@Parameter'&#13;&#10;">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="moduleId" DataType="System.Int32"/>
        <Column Name="toid" DataType="System.Int32"/>
        <Column Name="toProOrderNO" DataType="System.String"/>
        <Column Name="proBatchNO" DataType="System.String"/>
        <Column Name="proId" DataType="System.String"/>
        <Column Name="proName" DataType="System.String"/>
        <Column Name="proClass" DataType="System.String"/>
        <Column Name="Brand" DataType="System.String"/>
        <Column Name="Specification" DataType="System.String"/>
        <Column Name="Barcode" DataType="System.String"/>
        <Column Name="Unit" DataType="System.String"/>
        <Column Name="proBatchQty" DataType="System.String"/>
        <Column Name="Remarks" DataType="System.String"/>
        <Column Name="rowNnumber" DataType="System.Int64"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="[Parameter]"/>
      </TableDataSource>
      <TableDataSource Name="Table2" Alias="speed" DataType="System.Int32" Enabled="true" SelectCommand="SELECT S.id, S.toid, S.audit, S.invalid, S.proId, S.proName, S.proBatchNO, S.Barcode, S.Process, S.Station, S.Status, S.billNo&#13;&#10;FROM &quot;sys_speed&quot; S where  S.toid = @Parameter&#13;&#10;">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="toid" DataType="System.Int32"/>
        <Column Name="audit" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="invalid" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="proId" DataType="System.String"/>
        <Column Name="proName" DataType="System.String"/>
        <Column Name="proBatchNO" DataType="System.String"/>
        <Column Name="Barcode" DataType="System.String"/>
        <Column Name="Process" DataType="System.String"/>
        <Column Name="Station" DataType="System.String"/>
        <Column Name="Status" DataType="System.String"/>
        <Column Name="billNo" DataType="System.String"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="Parameter"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="Parameter" DataType="System.String"/>
  </Dictionary>
  <ReportPage Name="Page1" PaperWidth="100" PaperHeight="10" LeftMargin="1.5" TopMargin="1.5" RightMargin="1.5" BottomMargin="1.5" FirstPageSource="4" OtherPagesSource="4" Columns.Count="3" Columns.Width="32.3" Columns.Positions="0,32.3,64.7">
    <DataBand Name="Data1" Width="122.09" Height="37.8" DataSource="Table2">
      <BarcodeObject Name="Barcode1" Left="9.45" Width="88.45" Height="28.35" AutoSize="false" DataColumn="speed.Barcode" Text="010920060170" AllowExpressions="true" Barcode="Code128" Barcode.AutoEncode="true"/>
    </DataBand>
  </ReportPage>
</Report>
