﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="03/20/2023 11:16:04" ReportInfo.Modified="05/30/2023 14:36:05" 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
  {

    private void Acc_smName_BeforePrint(object sender, EventArgs e)
    {
      if(Convert.ToInt32((String)Report.GetParameterValue(&quot;MoreThan&quot;)) &gt; 0)
      {
      Acc_smName.Text = FormatNumber(( ((Double)Report.GetColumnValue(&quot;MatMaxLimit_Report.Qty&quot;))-((Double)Report.GetColumnValue(&quot;MatMaxLimit_Report.MaxLimit&quot;)) ),2);           
      Acc_smName.Visible=true;
      Memo19.Visible=true;
      Memo34.Visible=true;
      Memo12.Visible=true;
      }
      if(Convert.ToInt32((String)Report.GetParameterValue(&quot;LessThan&quot;)) &gt; 0)
      {
      Acc_smName.Text=FormatNumber(( ((Double)Report.GetColumnValue(&quot;MatMaxLimit_Report.Qty&quot;))- ((Double)Report.GetColumnValue(&quot;MatMaxLimit_Report.MinLimit&quot;))),2);
      Acc_smName.Visible=true;
      Memo19.Visible=true;
      Memo34.Visible=true;
      Memo12.Visible=true;
      }
      if( Convert.ToInt32((String)Report.GetParameterValue(&quot;OrderLimit&quot;)) &gt; 0)
      {Acc_smName.Text=FormatNumber((((Double)Report.GetColumnValue(&quot;MatMaxLimit_Report.Qty&quot;)) -((Double)Report.GetColumnValue(&quot;MatMaxLimit_Report.OrderLimit&quot;))),2);
      Acc_smName.Visible=true;
      Memo19.Visible=true;
      Memo34.Visible=true;
      Memo12.Visible=true;
      }
    }
  }
}


</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqM7gJFg/iaLrqMhRfGy5lGqO5IQ7/r0E7/Zm6fduOyQ4Zc5oL2jkQPt29YtGCCTQnzNz6563g9xqR43QpEoDMahPylx+QysFgYJWxXILSARo3G6j/rJyOrzAYJZSgenJaXfkHn5+g5B97Ockka/5F0gH/dnMs/3OKT1F5qzRd7z6R77gkcZ1s7OY9Hw83cS00+Vlcf9i5QWGv0U1xel5EoaNTtww8Ay9wtrh8hTeLnB5H4g2vSkrK+pgkN0uQGZV13Bc97U/r3SAkXk7khjkmGhEMxzgSTT5RpgDVPbXysZVtbwNkfJ0tbwmtYmhVHxcamoWKxg6fqfmWjfB5N86T62alEJrgOSQYBBgFtdS+s0g8LhliilGj8JV6xSSC27y+qvfNCnFDIq9hCvnklLQGFQKJkBUw0brqyP5oFa8SYKeLDfGa4QI+Ish0ElgrE8w170uSj1gKoOlnivuV8xuUIjjjAe9RfSxQ+/I2JXor3mC91/Obu1VAc7APBK9+AZoQT213YjqydaqEPvJ69JCrgvUZO8iaAIyCWkUI4f2nxCOhRQWOy4ii0uqmtUsZeipaJWaSnOO1W4nsECnnvf3AmFL4NKsmNgxlmIzqxRbBjIueR5VbnqTJ7BWf4TuxDIzYCSaUPUEXJxC/06EdAMZkbj/MHvKMRu2kJ8EZr5th3Ww=">
      <TableDataSource Name="MatMaxLimit_Report" DataType="System.Int32" Enabled="true" TableName="MatMaxLimit_Report" SelectCommand="exec mnrPrcRepMaxlimitMat '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '' , '' , 0 , 3 , 0 , 0 , '{00000000-0000-0000-0000-000000000000}', 1 , 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="GrpLaName" DataType="System.String"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="StCode" DataType="System.String"/>
        <Column Name="StName" DataType="System.String"/>
        <Column Name="StLaName" DataType="System.String"/>
        <Column Name="MaxLimit" DataType="System.Double"/>
        <Column Name="OrderLimit" DataType="System.Double"/>
        <Column Name="MinLimit" DataType="System.Double"/>
        <Column Name="Qty" DataType="System.Double"/>
        <Column Name="Empty" DataType="System.Int32"/>
        <Column Name="DefUnitRate" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;1-1-2014&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;1-1-2015&quot;"/>
    <Parameter Name="MoreThan" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="LessThan" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="OrderLimit" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{C83973E7-C443-4597-B6F6-9B8FFBAEB16E}&quot;"/>
    <Parameter Name="StoreName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="CostJobName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="SaleManName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="GrpName" DataType="System.String" Expression="&quot;&quot;"/>
    <Total Name="Total-QTY" Expression="[MatMaxLimit_Report.Qty]" Evaluator="MasterData1" PrintOn="ReportSummary1"/>
    <Total Name="Total-MaxLimit" Expression="[MatMaxLimit_Report.MaxLimit]" Evaluator="MasterData1" PrintOn="ReportSummary1"/>
    <Total Name="Total-MiniLimit" Expression="[MatMaxLimit_Report.MinLimit]" Evaluator="MasterData1" PrintOn="ReportSummary1"/>
    <Total Name="Total-OrderLimit" Expression="[MatMaxLimit_Report.OrderLimit]" Evaluator="MasterData1" PrintOn="ReportSummary1"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="136.08">
      <TextObject Name="Memo2" Left="251.34" Top="80.24" Width="215.43" Height="22.68" Text="المواد التي تجاوزت الحد" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 16pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Left="7.56" Top="3.78" Width="702.99" Height="71.81" Fill.Color="White" ImageLocation="\\mnrsrv\DH-Tech\Logo001.jpg" SizeMode="CenterImage"/>
      <TextObject Name="Memo17" Left="12.8" Top="109.06" Width="200.32" Height="22.68" Text="[IIf([MoreThan]==&quot;1&quot;,&quot;الحد الأعلى&quot;,IIf([LessThan]==&quot;1&quot;,&quot;الحد الأدنى&quot;,IIf([OrderLimit]==&quot;1&quot;,&quot;حد الطلب&quot;,&quot;&quot;)))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 12pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Text1" Left="661.5" Top="113.4" Width="39.67" Height="22.68" Text=" : البائع" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text2" Left="567" Top="113.4" Width="96.37" Height="22.68" Text="[SaleManName]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="140.08" Width="718.2" Height="23.03">
      <TextObject Name="Memo3" Left="356.95" Top="0.27" Width="79.37" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="المجموعة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="279.58" Top="0.27" Width="77.48" Height="22.68" Border.Lines="Left, Top, Bottom" Fill.Color="187, 210, 244" Text="الكمية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo6" Left="214.21" Top="0.27" Width="66.14" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="الحد الأعلى" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo7" Left="148.72" Top="0.27" Width="66.14" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="الحد الأدنى" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo15" Left="435.5" Top="0.27" Width="245.67" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="المـــــــــادة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo16" Left="82.2" Top="0.27" Width="66.52" Height="22.68" Border.Lines="Left, Top, Bottom" Fill.Color="187, 210, 244" Text="حد الطلب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo19" Left="2.61" Top="0.27" Width="79.37" Height="22.68" Visible="false" Border.Lines="All" Fill.Color="187, 210, 244" Text="الفرق" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo22" Left="681.09" Top="0.35" Width="30.24" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="الرقم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="MasterData1" Top="167.11" Width="718.2" Height="18.9" CanGrow="true" CanShrink="true" DataSource="MatMaxLimit_Report">
      <TextObject Name="Acc_Per" Left="356.95" Width="79.37" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[MatMaxLimit_Report.GrpCode][MatMaxLimit_Report.GrpName]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Acc_Move_ReportDebit" Left="279.58" Width="77.48" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatMaxLimit_Report.Qty]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Acc_Move_ReportCredit" Left="214.21" Width="66.14" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[MatMaxLimit_Report.MaxLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo4" Left="148.72" Width="66.14" Height="18.9" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Text="[MatMaxLimit_Report.MinLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo14" Left="435.5" Width="245.67" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[MatMaxLimit_Report.MatCode][MatMaxLimit_Report.MatName]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Acc_smName" Left="2.61" Width="79.37" Height="18.9" Visible="false" Border.Lines="Left, Top, Bottom" GrowToBottom="true" BeforePrintEvent="Acc_smName_BeforePrint" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Acc_coName" Left="82.2" Width="66.52" Height="18.9" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Text="[MatMaxLimit_Report.OrderLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo20" Left="681.09" Width="30.24" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt"/>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" Top="190.01" Width="718.2" Height="41.36">
      <TextObject Name="Memo8" Left="356.06" Top="22.46" Width="355.28" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="المجموع" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo9" Left="279.58" Top="22.46" Width="77.48" Height="18.9" Border.Lines="Right, Top, Bottom" Text="[Total-QTY]" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Memo10" Left="214.21" Top="22.46" Width="66.14" Height="18.9" Border.Lines="All" Text="[Total-MaxLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo11" Left="148.72" Top="22.46" Width="66.14" Height="18.9" Border.Lines="Top, Bottom" Text="[Total-MiniLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo12" Left="2.61" Top="22.46" Width="79.37" Height="18.9" Visible="false" Border.Lines="All" Text="[IIf(ToDouble([MoreThan]) &gt; 0,[Total-QTY]- [Total-MaxLimit],IIf(ToDouble([LessThan])&gt; 0,[Total-QTY] - [Total-MiniLimit],IIf(ToDouble([OrderLimit])&gt; 0,[Total-QTY] - [Total-OrderLimit],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo13" Left="82.2" Top="22.46" Width="66.52" Height="18.9" Border.Lines="All" Text="[Total-OrderLimit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo23" Left="356.06" Top="0.56" Width="355.28" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo26" Left="279.58" Top="0.56" Width="77.48" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="الكمية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo31" Left="214.21" Top="0.56" Width="66.14" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="الحد الأعلى" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo32" Left="148.72" Top="0.56" Width="66.14" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="الحد الأدنى" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo33" Left="82.2" Top="0.56" Width="66.52" Height="22.68" Border.Lines="All" Fill.Color="187, 210, 244" Text="حد الطلب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo34" Left="2.61" Top="0.56" Width="79.37" Height="22.68" Visible="false" Border.Lines="All" Fill.Color="187, 210, 244" Text="الفرق" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="235.37" Width="718.2" Height="45.35">
      <TextObject Name="Memo1" Left="636.4" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo21" Left="70.05" Width="83.15" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo28" Left="10.8" Width="56.69" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Tahoma, 8pt"/>
      <TextObject Name="Memo29" Left="159.54" Width="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Tahoma, 8pt"/>
      <TextObject Name="Memo30" Left="192.55" Width="56.69" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo24" Left="593.38" Top="25.98" Width="119.02" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarsoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
