﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="01/16/2023 12:09:31" ReportInfo.Modified="02/14/2023 14:46:10" ReportInfo.CreatorVersion="2021.4.3.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
  {
     void Memo7_BeforePrint(object sender, EventArgs e)
    {     
      if(((string)Report.GetParameterValue(&quot;Cust&quot;))==&quot;1&quot;) 
      {     if(((string)Report.GetParameterValue(&quot;Store&quot;))==&quot;1&quot;)
      {
            Memo6.Visible=true;
            Memo7.Visible=true;
            Memo11.Visible=true;
            Memo12.Visible=true;                                                      
            Memo7.Text=&quot;المستودع&quot;;
     }                     
      }          
        if(((string)Report.GetParameterValue(&quot;Cust&quot;))==&quot;1&quot;)
        {
          Memo6.Visible=true;
          Memo11.Visible=true;
        }    
        
      if(((String)Report.GetParameterValue(&quot;Store&quot;))==&quot;1&quot;)      
      { 
        if(((String)Report.GetParameterValue(&quot;Cust&quot;))==&quot;0&quot;)  
      {  
        Memo6.Visible=true;
        Memo11.Visible=true;
      }                    
      }          
      }

   
   
  }
}
</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiLeyYgzGsg8K0w/wV+uVJpRb9DC+IFtFJ1Ya+wGL6sGP+LlGmWCsZftl80X1OZU2OLg7Xmxnkp41Wl7LrNJHJ83vvlYpsJ+6DtFdt82j1thRJJ4BPMOXXQ/VznxXbVK4wYXEfc/GT9jRWt/AYscmVrEJOp4AS6pfF/zabOfAeUxnPCFZuNTTYf/Anqida2Bnq4wWsjYQk+bW2BLfUXiq65uF50V779GQRASHenAhYUkWSzDbA55v76C9I5KXmHcVFOiKZ+crBw0xzYGCLy1zA+5u2EhK1ncHnju8fsDtQSCKHPF/gcZOsPDlVLbNE0mfQthSkUwe+rOWG2wRpE+KPod4Fcxq3gunpXyR6lKHmlhZCpEl+DhWx7PfMSbDazPY+COK+/qGCXHLZyacBrpvSmak7r6CzLPw4+h0pwFa+tzSii0Zv9DN8UEf7Wbq03UkBiyGMlaM3mpkAwbcbFlMcfoVkaKlOuSDBdv7Zmh9anZplloQRffHv2Tv2GkEp72wdqH/k4XVmDCpyw2JLs0oHt2xIq29iX3qXEUhQeNJBjOCsK4r0Uq7hFWmN6TQWZjgtHl1KJP9L2zf5n1Ed1UpYbg==">
      <TableDataSource Name="SerialNumberInv_Report" DataType="System.Int32" Enabled="true" TableName="SerialNumberInv_Report" SelectCommand="exec mnrPrcRepSerialNumberInventory '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{744919CF-0415-462b-B63C-3B7D253BEE2B}' ,  0  ,	 0	  , '1-1-2022'  , '2-14-2023'  , '{00000000-0000-0000-0000-000000000000}'  ,  1   ,  0 , 0 , '' , '' , ''">
        <Column Name="MatID" DataType="System.Guid"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="CustID" DataType="System.Guid"/>
        <Column Name="SNumber" DataType="System.String"/>
        <Column Name="SnNote" DataType="System.String"/>
        <Column Name="InOut" DataType="System.Int32"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="BillID" DataType="System.Guid"/>
        <Column Name="BillTypeID" DataType="System.Guid"/>
        <Column Name="bNumber" DataType="System.Int32"/>
        <Column Name="btName" DataType="System.String"/>
        <Column Name="btLName" DataType="System.String"/>
        <Column Name="CustName" DataType="System.String"/>
        <Column Name="CustLatinName" DataType="System.String"/>
        <Column Name="stCode" DataType="System.String"/>
        <Column Name="stName" DataType="System.String"/>
        <Column Name="stLatinName" DataType="System.String"/>
        <Column Name="MatCode" DataType="System.String"/>
        <Column Name="MatName" DataType="System.String"/>
        <Column Name="MatLatinName" DataType="System.String"/>
        <Column Name="Price" DataType="System.Double"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{452D9B5F-1CC9-4407-B937-7ACB53469411}&quot;"/>
    <Parameter Name="Cust" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Store" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowNotes" DataType="System.String" Expression="&quot;0&quot;"/>
    <Total Name="Total" TotalType="Count" Evaluator="MasterData1" PrintOn="ReportSummary1"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="151.18">
      <TextObject Name="Memo2" Left="3.78" Top="106.49" Width="710.55" Height="30.24" Text="جرد الأرقام التسلسلية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Left="9.45" Top="6.12" Width="699.21" Height="86.93" Fill.Color="White" SizeMode="CenterImage" Image=""/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="155.18" Width="718.2" Height="22.68" CanGrow="true" CanShrink="true">
      <TextObject Name="Memo3" Left="663.64" Width="49.13" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الرقم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo4" Left="550.25" Width="113.39" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الرقم التسلسلي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="250.6" Width="299.34" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="المادة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo6" Left="115.11" Width="136.06" Height="22.68" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="[IIf([Cust]==&quot;1&quot;,&quot;الزبون&quot;,IIf([Store]==&quot;1&quot;,&quot;المستودع&quot;,&quot;&quot;))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo7" Left="5.62" Width="109.61" Height="22.68" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" BeforePrintEvent="Memo7_BeforePrint" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="MasterData1" Top="181.86" Width="718.2" Height="22.68" CanGrow="true" CanShrink="true" DataSource="SerialNumberInv_Report">
      <TextObject Name="Memo8" Left="663.64" Width="49.13" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo9" Left="550.25" Width="113.39" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[SerialNumberInv_Report.SNumber]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo10" Left="250.6" Width="299.34" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[SerialNumberInv_Report.MatCode] - [SerialNumberInv_Report.MatName]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo11" Left="115.11" Width="136.06" Height="22.68" Visible="false" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="IIf[Cust]==1,[SerialNumberInv_Report.CustName],IIf([Store]==1,[SerialNumberInv_Report.stName],&quot;&quot;))" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo12" Left="5.62" Width="109.61" Height="22.68" Visible="false" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="IIf( [Store]==1,[SerialNumberInv_Report.stName],&quot;&quot;)" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" Top="208.54" Width="718.2" Height="22.68">
      <TextObject Name="Memo13" Left="550.25" Width="162.52" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" Text="إجمالي كمية المواد" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo14" Left="250.6" Width="299.34" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="[Total]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="235.22" Width="718.2" Height="44.57">
      <TextObject Name="Memo21" Left="633.85" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo140" Left="64.94" Width="83.15" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo141" Left="5.69" Width="56.69" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo142" Left="154.43" Width="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo143" Left="187.45" Width="56.69" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo1" Left="573.04" Top="23.9" Width="151.18" Height="18.9" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
