﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="08/28/2022 09:19:52" ReportInfo.Modified="10/15/2024 13:02:47" 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 _StartReport(object sender, EventArgs e)
    {
      if(((String)Report.GetParameterValue(&quot;ShowStore&quot;))==&quot;1&quot;)
      {      
  
      Memo9.Visible=true;
      Memo10.Visible=true;
      Memo10.AllowExpressions = true;
      Memo20.Visible=true;           
      Memo21.Visible=true;  
          Memo21.AllowExpressions = true;
    }
      }

   
  
  }
}
/*
void Memo9OnBeforePrint(TfrxComponent Sender)
{
  if(&lt;ShowStore&gt;==&quot;1&quot;)
  {      
  
       Memo9.Visible=True;
       Memo10.Visible=True;
       Memo20.Visible=True;           
       Memo21.Visible=True;    
  }
}

{

}
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqKjSU40dlxFMmorDfgW0xWghLfHh9It0YM419tI3EqnDwCQRhxmoCe6bhrhjTzx2Y0F0RTONUmYAGZ6dlXfrK+aaLoV3VCX81Ee/g9bTWGPLv0zbl5s2dOBVHvBKLS+Kdw1xelblGqTVepGfVY2zk+Y23WFm9hnxIT4nk8bJ+3+/0bRvr5TEDiVcIhN2qBJ2H8kT5g8c4LUiFC0IebojO5zuiQ2q0itFGH/zR/n6SlQtPw9EmA4j0TqdPVc9CViU3FoctYq33BMJQr4mApyOEZ+zUiLVrRGdC7IRe0Jv23xeB93phov6pBgoAlZNWXpXsRd9fMEEJOacMxba5FGFjr8jxfWrbJaNhePfuIFafSNbtCAF11VXnFztmtzGgVgjlrc3/FiyfRscPkj4cTi4T3oasx79+c1RzHxwxMJUp0TJNDAN3Ficp31azRHBAcCqjvLVuYrEnxQt5HqAGZBmk/tjwQ63TdEYRP4wlGCpJJU26TReRvv8+4CarkbUL8RH1c4bJxd04gXyCmhGxv/0FUbVK/PD02VwwOnxt+GdcdenQyeyM8udqi6L+58IcEYWczclyTb2JVkTVD9r6zY7NDDr1HuZQJCJ7UwhVIiwKHZ9ZfND153yfv5eo/CjltDnhvL0ntRfk+7Jnsc4Zs7/pphij4HYnZ8t+jczZl+B4rNRswSLFy96CK27twewF1MneZX+tVhmAP6QEjLFWdCl1uQ==" CommandTimeout="1200">
      <TableDataSource Name="MatLimitAndInv_Report" DataType="System.Int32" Enabled="true" TableName="MatLimitAndInv_Report" SelectCommand="exec mnrPrcRepMatLimitAndInv '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '12-31-2023' , '10-15-2024' , '{AC708B5B-2ACE-4849-A5C6-74232D5C7AF2}' , '1' , '0'  ,  0 , ''">
        <Column Name="MatID" DataType="System.Guid"/>
        <Column Name="MatCode" DataType="System.String"/>
        <Column Name="MatName" DataType="System.String"/>
        <Column Name="MatLaName" DataType="System.String"/>
        <Column Name="GrpID" DataType="System.Guid"/>
        <Column Name="GrpCode" DataType="System.String"/>
        <Column Name="GrpName" DataType="System.String"/>
        <Column Name="GrpLName" DataType="System.String"/>
        <Column Name="QtyIn" DataType="System.Double"/>
        <Column Name="QtyOut" DataType="System.Double"/>
        <Column Name="Qty" DataType="System.Double"/>
        <Column Name="MinLimit" DataType="System.Double"/>
        <Column Name="MaxLimit" DataType="System.Double"/>
        <Column Name="OrderLimit" DataType="System.Double"/>
        <Column Name="Unit" DataType="System.String"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="StoreCode" DataType="System.String"/>
        <Column Name="StoreName" DataType="System.String"/>
        <Column Name="StoreLName" DataType="System.String"/>
        <Column Name="Date" DataType="System.DateTime"/>
      </TableDataSource>
      <TableDataSource Name="ExtSecConnection" DataType="System.Int32" Enabled="true" TableName="ExtSecConnection" SelectCommand="exec mnrFrxPrcConnection_Add '{6CCA4800-C4E7-4c35-A2D8-FC4F74F6199B}'">
        <Column Name="TmpVal" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{6CCA4800-C4E7-4c35-A2D8-FC4F74F6199B}&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;31/12/2023&quot;"/>
    <Parameter Name="ShowStore" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="Type" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;15/10/2024&quot;"/>
    <Parameter Name="ShowStoreLimit" DataType="System.String" Expression="&quot;0&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" LeftMargin="0.1" RightMargin="0.1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="1121.9" Height="162.52">
      <TextObject Name="Memo2" Left="388.91" Top="104.39" Width="343.94" Height="30.24" Text="حدود المادة وجردها" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Memo3" Left="985.88" Top="139.84" Width="68.03" Height="18.9" Text=": إعتباراً من" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo4" Left="820.91" Top="139.84" Width="56.7" Height="18.9" Text=": ولغاية" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="885.62" Top="139.84" Width="98.27" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo7" Left="730.99" Top="139.84" Width="86.93" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <PictureObject Name="Company_Logo" Left="54.51" Top="3.78" Width="993.99" Height="88.13" Fill.Color="White" ImageLocation="C:\Program Files (x86)\Almanara Business Solutions\Bin\Res\Logo.bmp" SizeMode="CenterImage" ImageFormat="Bmp"/>
      <TextObject Name="mnrExtSecMemo" Text="[ExtSecConnection.TmpVal]" Font="Arial, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="166.52" Width="1121.9" Height="18.9" CanGrow="true" CanShrink="true">
      <TextObject Name="Memo6" Left="1065.49" Width="41.57" Height="18.9" 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="Memo36" Left="812.26" Width="83.15" Height="18.9" 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="Memo37" Left="725.33" Width="86.93" Height="18.9" 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="Memo11" Left="649.74" Width="75.59" Height="18.9" 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="Memo12" Left="577.93" Width="71.81" Height="18.9" 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="Memo13" Left="506.12" Width="71.81" Height="18.9" 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="Memo14" Left="430.53" Width="75.59" Height="18.9" 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="Memo15" Left="354.94" Width="75.59" Height="18.9" 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="Memo16" Left="279.35" Width="75.59" Height="18.9" 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="Memo17" Left="196.2" Width="83.15" Height="18.9" 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="Memo8" Left="959.66" Width="105.83" Height="18.9" 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="Memo38" Left="895.41" Width="64.25" Height="18.9" 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="Memo9" Left="101.71" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="187, 210, 244" Text="المستودع" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo20" Left="7.22" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="187, 210, 244" Text="التااريخ" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="MasterData1" Top="189.42" Width="1121.9" Height="18.9" CanGrow="true" CanShrink="true" DataSource="MatLimitAndInv_Report">
      <TextObject Name="Memo18" Left="1065.49" Width="41.57" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo1" Left="812.26" Width="83.15" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.QtyIn]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo35" Left="725.33" Width="86.93" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.QtyOut]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo22" Left="649.74" Width="75.59" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.Qty]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo23" Left="577.93" Width="71.81" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.MinLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo24" Left="506.12" Width="71.81" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.MaxLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo25" Left="430.53" Width="75.59" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.OrderLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo26" Left="354.94" Width="75.59" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[IIf([MatLimitAndInv_Report.MaxLimit]!=0,[MatLimitAndInv_Report.Qty]-[MatLimitAndInv_Report.MaxLimit],&quot;&quot;)]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo27" Left="279.35" Width="75.59" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[IIf([MatLimitAndInv_Report.MinLimit]!=0,[MatLimitAndInv_Report.Qty]-[MatLimitAndInv_Report.MinLimit],&quot;&quot;)]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo28" Left="196.2" Width="83.15" Height="18.9" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Text="[IIf([MatLimitAndInv_Report.OrderLimit]!=0,[MatLimitAndInv_Report.Qty]-[MatLimitAndInv_Report.OrderLimit],&quot;&quot;)]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo39" Left="895.41" Width="64.25" Height="18.9" Border.Lines="Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[MatLimitAndInv_Report.Unit]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo19" Left="959.66" Width="105.83" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[MatLimitAndInv_Report.MatCode] - [MatLimitAndInv_Report.MatName]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo10" Left="101.71" Width="94.49" Height="18.9" Visible="false" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.StoreName]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo21" Left="7.22" Width="94.49" Height="18.9" Visible="false" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Text="[MatLimitAndInv_Report.Date]" Padding="2, 1, 2, 1" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="212.32" Width="1121.9" Height="49.13">
      <TextObject Name="Memo29" Left="1033.42" Top="3.78" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo30" Left="70.05" Top="3.78" 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="Memo31" Left="10.8" Top="3.78" 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="Memo32" Left="159.54" Top="3.78" Width="39.69" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo33" Left="202" Top="3.78" 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="Memo34" Left="969.17" Top="30.54" Width="170.05" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
