﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="01/28/2024 11:29:51" ReportInfo.Modified="04/22/2024 16:30:28" 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 _StartReport(object sender, EventArgs e)
    {
      DataSourceBase ds = Report.GetDataSource(&quot;CloseOutEmpAcc_Report&quot;); 
      ds.Init();
 
      double  Sumbdalat =0;double sumextra =0;double sumdisc=0 ;double Sumratep=0;double Sumgheap=0;double Sumbouns=0; double Sumslf=0 ;double Sumpenalti=0;double Sumdisc=0;double Sumratebfali=0;double Sumextra=0;double Sumegazat=0;double  sumbouns =0;;double sumgheap=0;double sumratep=0;double  Sumnehaetkhdme=0;double Sumtzakermokfda=0;double Sumtzakeradee=0;double Sum=0 ;                         
      double count = 0;
      while  (ds.HasMoreRows)// do
      {

        count = count + 1 ;
        if( ((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;))== 14)
        {          
          Sumbdalat =            
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }                   
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 13)
        {          
          Sumslf =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 12)
        {          
          Sumpenalti =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 22)
        {          
          Sumdisc =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 6)
        {
          if( ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Debit&quot;))&gt; 0 )                                                                   
            Sumratebfali -=             
              ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;
          else
            Sumratebfali =             
              ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 21)
        {          
          Sumextra =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 18)
        {          
          Sumegazat =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 19)
        {          
          Sumgheap =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;
        }                  
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 7)
        {          
          Sumbouns =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;
        }          
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 5)
                    
        {          
          Sumratep =            
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;
                                                             
        }                   
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 1)
        {          
          Sumegazat =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 2)
        {          
          Sumtzakeradee =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 3)
        {          
          Sumtzakermokfda =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;                                                       
        }
        if(((Int32)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Type&quot;)) == 4)
        {          
          Sumnehaetkhdme =             
            ((Double)Report.GetColumnValue(&quot;CloseOutEmpAcc_Report.Value&quot;))   ;
        }          
                 
               
        ds.Next(); 
                  
      }
      
      
         
       Sum =  Sumtzakermokfda +   Sumtzakeradee;
       if(count==0) 
        MessageBox.Show(&quot;لايوجد نتائج ضمن الشروط المحددة&quot;);
    /*  Memo90.Text=ToString(FormatNumber(Sumegazat,2));
      Memo94.Text=ToString(FormatNumber(Sum,2));    
      Memo98.Text=ToString(FormatNumber(Sumslf,2));      
      Memo72.Text=ToString(FormatNumber(Sumnehaetkhdme,2));  
     /* Memo145.Text = ToString(FormatNumber(Sumratep,2));
      Memo146.Text = ToString(FormatNumber(Sumbdalat,2));
      Memo147.Text = ToString(FormatNumber(Sumegazat,2));
      Memo148.Text = ToString(FormatNumber(Sumbouns,2));
      Memo149.Text = ToString(FormatNumber(Sumpenalti,2));
      Memo150.Text = ToString(FormatNumber(Sumslf,2));
      Memo151.Text = ToString(FormatNumber(sumdisc,2));
      Memo153.Text = ToString(FormatNumber(sumextra,2));
      Memo157.Text = ToString (FormatNumber(Sumgheap,2));                   
      Memo159.Text = ToString(FormatNumber(Sumratebfali,2)); */
      
      
      
      
      
      
       
    }
  }
    
  
}
</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiaZpTEEWyUzaPuDP87XMIQMkFbwRDRqWcnOq05AHvy/3ciW7Aj4vKJx2xbvEamJYpY4S2ERmRvbANQbrAywWlloUqxbVuYJV9jZt8uEZY11kHXAvFLccnAbNsSBoKJMPUKGD+5qxgd/3RmGNgDkiRKTpyUoHIz9hleqSasEU5P/FpmEywyc79ElHV6JPmg0iqJNJlbxLNNtomz01DLmksgD71eGQwwl4Bz2QfeVElqEgAKMSDCPEyVQ5M7Y7/PoLGOS/s0jKpmwGaRMOX10IfnXqKmcQ5FjqHXqYD9eH/VFA+7mti6zwOpgJnq1N8B2jRP9IMpAPQFy1qL/pvqyl8xT+fxl0V44yaSC9BBUMufEgQeitxQd7gqNcASWo+O9O54DTOVb47BWeS7nIkxIsRxzkA3QAwL9cUVuuSQqmSZB8KCY8x8vbwXjFZ2mBBxJaQCNanxccxHB85pxH/PY0SYa2qzUwKaDRlTvu0OqnDjdUP+OyscmnOqY/UhM5kUtofJveBd0UT1MDf7pKbINVxuhjMRTe3Z53NJXeMvnvi1suj6fE7z6rz8VdADSgoSK3OGL+YLtv6o6dias78KvSd2hIzo9wxTlhr9Iuisz9d14O8SzKWZe+SKDF1bF7IYO+BrIQ51Xy+MNFpFf8oc/o90A==" CommandTimeout="1200">
      <TableDataSource Name="Table" Alias="employeeee" DataType="System.Int32" Enabled="true" SelectCommand="select * from mnrhrvwemployee where EmpID=@id">
        <Column Name="EmpID" DataType="System.Guid"/>
        <Column Name="EmpNumber" DataType="System.Double"/>
        <Column Name="EmpCode" DataType="System.String"/>
        <Column Name="EmpName" DataType="System.String"/>
        <Column Name="EmpLatinName" DataType="System.String"/>
        <Column Name="EmpFName" DataType="System.String"/>
        <Column Name="EmpLFName" DataType="System.String"/>
        <Column Name="EmpFamName" DataType="System.String"/>
        <Column Name="EmpLFamName" DataType="System.String"/>
        <Column Name="EmpGFName" DataType="System.String"/>
        <Column Name="EmpLGFName" DataType="System.String"/>
        <Column Name="EmpMotherName" DataType="System.String"/>
        <Column Name="EmpLMotherName" DataType="System.String"/>
        <Column Name="EmpFullName" DataType="System.String"/>
        <Column Name="EmpLFullName" DataType="System.String"/>
        <Column Name="EmpDateOfBirth" DataType="System.DateTime"/>
        <Column Name="EmpHDateOfBirth" DataType="System.String"/>
        <Column Name="EmpGender" DataType="System.Int32"/>
        <Column Name="EmpMilSrv" DataType="System.Int32"/>
        <Column Name="EmpMilFromDate" DataType="System.DateTime"/>
        <Column Name="EmpMilToDate" DataType="System.DateTime"/>
        <Column Name="EmpDrvLiceNum" DataType="System.String"/>
        <Column Name="EmpIsActive" DataType="System.Int32"/>
        <Column Name="EmpWorkType" DataType="System.Int32"/>
        <Column Name="EmpBirthPlace" DataType="System.String"/>
        <Column Name="EmpSocialStatus" DataType="System.Int32"/>
        <Column Name="EmpKids" DataType="System.Int32"/>
        <Column Name="EmpNatID" DataType="System.Guid"/>
        <Column Name="EmpReligionID" DataType="System.Guid"/>
        <Column Name="EmpCatID" DataType="System.Guid"/>
        <Column Name="EmpBuildUnitID" DataType="System.Guid"/>
        <Column Name="EmpDateWork" DataType="System.DateTime"/>
        <Column Name="EmpHDateWork" DataType="System.String"/>
        <Column Name="EmpPositionID" DataType="System.Guid"/>
        <Column Name="EmpBranchID" DataType="System.Guid"/>
        <Column Name="EmpDepID" DataType="System.Guid"/>
        <Column Name="EmpSupervisorID" DataType="System.Guid"/>
        <Column Name="EmpIsLeave" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpDateLeave" DataType="System.DateTime"/>
        <Column Name="EmpHDateLeave" DataType="System.String"/>
        <Column Name="EmpResLeaveID" DataType="System.Guid"/>
        <Column Name="EmpLeaveNote" DataType="System.String"/>
        <Column Name="EmpPhone1" DataType="System.String"/>
        <Column Name="EmpPhone2" DataType="System.String"/>
        <Column Name="EmpMobile1" DataType="System.String"/>
        <Column Name="EmpMobile2" DataType="System.String"/>
        <Column Name="EmpAddress1" DataType="System.String"/>
        <Column Name="EmpAddress2" DataType="System.String"/>
        <Column Name="EmpDistrict" DataType="System.String"/>
        <Column Name="EmpCity" DataType="System.String"/>
        <Column Name="EmpNeighborhood" DataType="System.String"/>
        <Column Name="EmpStreet" DataType="System.String"/>
        <Column Name="EmpEmail1" DataType="System.String"/>
        <Column Name="EmpEmail2" DataType="System.String"/>
        <Column Name="EmpIdNumber" DataType="System.String"/>
        <Column Name="EmpPassportNum" DataType="System.String"/>
        <Column Name="EmpSponsorID" DataType="System.Guid"/>
        <Column Name="EmpPassNum" DataType="System.String"/>
        <Column Name="EmpPassJob" DataType="System.String"/>
        <Column Name="EmpDatePass" DataType="System.DateTime"/>
        <Column Name="EmpHDatePass" DataType="System.String"/>
        <Column Name="EmpBorderPerson" DataType="System.String"/>
        <Column Name="EmpBorderNum" DataType="System.String"/>
        <Column Name="EmpDateEnter" DataType="System.DateTime"/>
        <Column Name="EmpHDateEnter" DataType="System.String"/>
        <Column Name="EmpContraTypeID" DataType="System.Guid"/>
        <Column Name="EmpbOffContra" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpOffNum" DataType="System.String"/>
        <Column Name="EmpOffContraType" DataType="System.Int32"/>
        <Column Name="EmpOffJob" DataType="System.String"/>
        <Column Name="EmpQualDate" DataType="System.DateTime"/>
        <Column Name="EmpOffNote" DataType="System.String"/>
        <Column Name="EmpbEnsrPragnance" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpFingerNB" DataType="System.String"/>
        <Column Name="EmpBSalary" DataType="System.Double"/>
        <Column Name="EmpSpeSalary" DataType="System.Double"/>
        <Column Name="EmpSpareSalary" DataType="System.Double"/>
        <Column Name="EmpHourCost" DataType="System.Double"/>
        <Column Name="EmpMonthlyDays" DataType="System.Double"/>
        <Column Name="EmpHoursWork" DataType="System.Double"/>
        <Column Name="EmpDayCost" DataType="System.Double"/>
        <Column Name="EmpBalanced" DataType="System.Double"/>
        <Column Name="EmpBalance" DataType="System.Double"/>
        <Column Name="EmpExcusedAbsence" DataType="System.Double"/>
        <Column Name="EmpUnExcusedAbsence" DataType="System.Double"/>
        <Column Name="EmpYearHoliday" DataType="System.Double"/>
        <Column Name="EmpDaysPerYear" DataType="System.Double"/>
        <Column Name="EmpClearHolidays" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpWayPay" DataType="System.Int32"/>
        <Column Name="EmpCurrencyID" DataType="System.Guid"/>
        <Column Name="EmpbStopSalary" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpStopSalaryDate" DataType="System.DateTime"/>
        <Column Name="EmpBankNum" DataType="System.String"/>
        <Column Name="EmpSoEnsrNumber" DataType="System.String"/>
        <Column Name="EmpSoEnsrDate" DataType="System.DateTime"/>
        <Column Name="EmpSoInsrEndDate" DataType="System.DateTime"/>
        <Column Name="EmpHSoEnsrDate" DataType="System.String"/>
        <Column Name="EmpTS1" DataType="System.Guid"/>
        <Column Name="EmpTS2" DataType="System.Guid"/>
        <Column Name="EmpTS3" DataType="System.Guid"/>
        <Column Name="EmpTS4" DataType="System.Guid"/>
        <Column Name="EmpTS5" DataType="System.Guid"/>
        <Column Name="EmpTS6" DataType="System.Guid"/>
        <Column Name="EmpTS7" DataType="System.Guid"/>
        <Column Name="EmpRepMSalary" DataType="System.Double"/>
        <Column Name="EmpRepNegate" DataType="System.Double"/>
        <Column Name="EmpRepDevide" DataType="System.Double"/>
        <Column Name="EmpRepTotal" DataType="System.Double"/>
        <Column Name="EmpRepYears" DataType="System.Int32"/>
        <Column Name="EmpRepAllYears" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpRegularTicket" DataType="System.Int32"/>
        <Column Name="EmpSpecificTicket" DataType="System.Int32"/>
        <Column Name="EmpVIPTicket" DataType="System.Int32"/>
        <Column Name="EmpVIPTicketBal" DataType="System.Int32"/>
        <Column Name="EmpNotes" DataType="System.String"/>
        <Column Name="EmpSickYearHoliday" DataType="System.Double"/>
        <Column Name="NNumber" DataType="System.Double"/>
        <Column Name="NCode" DataType="System.String"/>
        <Column Name="NName" DataType="System.String"/>
        <Column Name="NLatinName" DataType="System.String"/>
        <Column Name="BuNumber" DataType="System.Double"/>
        <Column Name="BuCode" DataType="System.String"/>
        <Column Name="BuName" DataType="System.String"/>
        <Column Name="BuLatinName" DataType="System.String"/>
        <Column Name="RNumber" DataType="System.Double"/>
        <Column Name="RCode" DataType="System.String"/>
        <Column Name="RName" DataType="System.String"/>
        <Column Name="RLatinName" DataType="System.String"/>
        <Column Name="SNumber" DataType="System.Double"/>
        <Column Name="SID" DataType="System.Guid"/>
        <Column Name="SCode" DataType="System.String"/>
        <Column Name="SName" DataType="System.String"/>
        <Column Name="SLatinName" DataType="System.String"/>
        <Column Name="SMobile" DataType="System.String"/>
        <Column Name="SAddress" DataType="System.String"/>
        <Column Name="BrID" DataType="System.Guid"/>
        <Column Name="BrNumber" DataType="System.Int32"/>
        <Column Name="BrCode" DataType="System.String"/>
        <Column Name="BrName" DataType="System.String"/>
        <Column Name="BrLatinName" DataType="System.String"/>
        <Column Name="DNumber" DataType="System.Double"/>
        <Column Name="DCode" DataType="System.String"/>
        <Column Name="DName" DataType="System.String"/>
        <Column Name="DLatinName" DataType="System.String"/>
        <Column Name="PoID" DataType="System.Guid"/>
        <Column Name="PoNumber" DataType="System.Double"/>
        <Column Name="PoCode" DataType="System.String"/>
        <Column Name="PoName" DataType="System.String"/>
        <Column Name="PoLatinName" DataType="System.String"/>
        <Column Name="CNumber" DataType="System.Double"/>
        <Column Name="CCode" DataType="System.String"/>
        <Column Name="CName" DataType="System.String"/>
        <Column Name="CLatinName" DataType="System.String"/>
        <Column Name="SpEmpID" DataType="System.Guid"/>
        <Column Name="SpEmpNumber" DataType="System.Double"/>
        <Column Name="SpEmpCode" DataType="System.String"/>
        <Column Name="SpEmpName" DataType="System.String"/>
        <Column Name="SpEmpLatinName" DataType="System.String"/>
        <Column Name="EmpAccID" DataType="System.Guid"/>
        <Column Name="EmpAccName" DataType="System.String"/>
        <Column Name="EmpAccLatinName" DataType="System.String"/>
        <Column Name="EmpSectorID" DataType="System.Guid"/>
        <Column Name="EmpSectorName" DataType="System.String"/>
        <Column Name="EmpSectorLatinName" DataType="System.String"/>
        <Column Name="EmpLeftReasID" DataType="System.Guid"/>
        <Column Name="EmpLeftReasName" DataType="System.String"/>
        <Column Name="EmpLeftReasLatinName" DataType="System.String"/>
        <Column Name="EmpOffQualID" DataType="System.Guid"/>
        <Column Name="EmpQualName" DataType="System.String"/>
        <Column Name="EmpQualLatinName" DataType="System.String"/>
        <Column Name="EmpOffEduDegID" DataType="System.Guid"/>
        <Column Name="EmpEduName" DataType="System.String"/>
        <Column Name="EmpEduLatinName" DataType="System.String"/>
        <Column Name="EmpEnsrTypeID" DataType="System.Guid"/>
        <Column Name="EmpInsName" DataType="System.String"/>
        <Column Name="EmpInsLatinName" DataType="System.String"/>
        <Column Name="EmpEnsrTypeKidID" DataType="System.Guid"/>
        <Column Name="EmpKidInsName" DataType="System.String"/>
        <Column Name="EmpKidInsLatinName" DataType="System.String"/>
        <Column Name="EmpEnsrTypeWifeID" DataType="System.Guid"/>
        <Column Name="EmpWifeInsName" DataType="System.String"/>
        <Column Name="EmpWifeInsLatinName" DataType="System.String"/>
        <Column Name="EmpSlarySysID" DataType="System.Guid"/>
        <Column Name="EmpSalaryName" DataType="System.String"/>
        <Column Name="EmpSalaryLatinName" DataType="System.String"/>
        <Column Name="EmpTimeSysID" DataType="System.Guid"/>
        <Column Name="EmpTimeSysName" DataType="System.String"/>
        <Column Name="EmpTimeSysLatinName" DataType="System.String"/>
        <Column Name="EmpAccGrpID" DataType="System.Guid"/>
        <Column Name="EmpAccGrpName" DataType="System.String"/>
        <Column Name="EmpAccGrpLatinName" DataType="System.String"/>
        <Column Name="EmpBankID" DataType="System.Guid"/>
        <Column Name="EmpBankCode" DataType="System.String"/>
        <Column Name="EmpBankName" DataType="System.String"/>
        <Column Name="EmpBankLatinName" DataType="System.String"/>
        <Column Name="EmpHeadingID" DataType="System.Guid"/>
        <Column Name="EmpTicketName" DataType="System.String"/>
        <Column Name="EmpTicketLatinName" DataType="System.String"/>
        <Column Name="EmpNormalTickBal" DataType="System.Int32"/>
        <Column Name="EmpLowTickBal" DataType="System.Int32"/>
        <Column Name="EmpbFixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpDateFixed" DataType="System.DateTime"/>
        <Column Name="EmpbSummryWork" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpbEndContra" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpDateEndContra" DataType="System.DateTime"/>
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="CFGrpID" DataType="System.Guid"/>
        <Column Name="DID" DataType="System.Int32"/>
        <Column Name="ObjID" DataType="System.Guid"/>
        <Column Name="CFVal1" DataType="System.String"/>
        <Column Name="CFVal2" DataType="System.String"/>
        <Column Name="CFVal3" DataType="System.String"/>
        <Column Name="CFVal4" DataType="System.String"/>
        <Column Name="CFVal5" DataType="System.String"/>
        <Column Name="CFVal6" DataType="System.String"/>
        <Column Name="CFVal7" DataType="System.String"/>
        <Column Name="CFVal8" DataType="System.String"/>
        <Column Name="CFVal9" DataType="System.String"/>
        <Column Name="CFVal10" DataType="System.String"/>
        <Column Name="CFVal11" DataType="System.String"/>
        <Column Name="CFVal12" DataType="System.String"/>
        <Column Name="CFVal13" DataType="System.String"/>
        <Column Name="CFVal14" DataType="System.String"/>
        <Column Name="CFVal15" DataType="System.String"/>
        <Column Name="CFVal16" DataType="System.String"/>
        <Column Name="CFVal17" DataType="System.String"/>
        <Column Name="CFVal18" DataType="System.String"/>
        <Column Name="CFVal19" DataType="System.String"/>
        <Column Name="CFVal20" DataType="System.String"/>
        <Column Name="CFVal21" DataType="System.String"/>
        <Column Name="CFVal22" DataType="System.String"/>
        <Column Name="CFVal23" DataType="System.String"/>
        <Column Name="CFVal24" DataType="System.String"/>
        <Column Name="CFVal25" DataType="System.String"/>
        <Column Name="CFVal26" DataType="System.String"/>
        <Column Name="CFVal27" DataType="System.String"/>
        <Column Name="CFVal28" DataType="System.String"/>
        <Column Name="CFVal29" DataType="System.String"/>
        <Column Name="CFVal30" DataType="System.String"/>
        <Column Name="CFVal31" DataType="System.String"/>
        <Column Name="CFVal32" DataType="System.String"/>
        <Column Name="CFVal33" DataType="System.String"/>
        <Column Name="CFVal34" DataType="System.String"/>
        <Column Name="CFVal35" DataType="System.String"/>
        <Column Name="CFVal36" DataType="System.String"/>
        <Column Name="CFVal37" DataType="System.String"/>
        <Column Name="CFVal38" DataType="System.String"/>
        <Column Name="CFVal39" DataType="System.String"/>
        <Column Name="CFVal40" DataType="System.String"/>
        <Column Name="CFVal41" DataType="System.String"/>
        <Column Name="CFVal42" DataType="System.String"/>
        <Column Name="CFVal43" DataType="System.String"/>
        <Column Name="CFVal44" DataType="System.String"/>
        <Column Name="CFVal45" DataType="System.String"/>
        <Column Name="CFVal46" DataType="System.String"/>
        <Column Name="CFVal47" DataType="System.String"/>
        <Column Name="CFVal48" DataType="System.String"/>
        <Column Name="CFVal49" DataType="System.String"/>
        <Column Name="CFVal50" DataType="System.String"/>
        <Column Name="CFVal51" DataType="System.String"/>
        <Column Name="CFVal52" DataType="System.String"/>
        <Column Name="CFVal53" DataType="System.String"/>
        <Column Name="CFVal54" DataType="System.String"/>
        <Column Name="CFVal55" DataType="System.String"/>
        <Column Name="CFVal56" DataType="System.String"/>
        <Column Name="CFVal57" DataType="System.String"/>
        <Column Name="CFVal58" DataType="System.String"/>
        <Column Name="CFVal59" DataType="System.String"/>
        <Column Name="CFVal60" DataType="System.String"/>
        <Column Name="CFVal61" DataType="System.String"/>
        <Column Name="CFVal62" DataType="System.String"/>
        <Column Name="CFVal63" DataType="System.String"/>
        <Column Name="CFVal64" DataType="System.String"/>
        <CommandParameter Name="id" DataType="14" Expression="[CloseOutEmpAcc_Report.EmpID]" DefaultValue="00000000-0000-0000-0000-000000000000"/>
      </TableDataSource>
      <TableDataSource Name="SalaryData_Report" DataType="System.Int32" Enabled="true" TableName="SalaryData_Report" SelectCommand="exec mnrPrcHrSalaryData '{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}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '11-1-2023' , '11-30-2023' , '' , '' , '' , '{00000000-0000-0000-0000-000000000000}' , '{4F425CE1-1697-4b62-A1A1-095D84C722A2}' , '0' , ' 1'">
        <Column Name="SalID" DataType="System.Guid"/>
        <Column Name="SalNumber" DataType="System.Double"/>
        <Column Name="MonthID" DataType="System.Guid"/>
        <Column Name="BranchID" DataType="System.Guid"/>
        <Column Name="SalaryType" DataType="System.Int32"/>
        <Column Name="bBonus" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bMiss" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bDisc" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCost" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bPenalty" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bAdv" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bDiscPub" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bBonPub" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bDWork" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bVac" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="CurrencyID" DataType="System.Guid"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="CDate" DataType="System.DateTime"/>
        <Column Name="UDate" DataType="System.DateTime"/>
        <Column Name="IsPosted" DataType="System.Int32"/>
        <Column Name="Code" DataType="System.String"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="EntryID" DataType="System.Guid"/>
        <Column Name="ShowType" DataType="System.Int32"/>
        <Column Name="SalItemID" DataType="System.Guid"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="EID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="EmpCodeName" DataType="System.String"/>
        <Column Name="DayNb" DataType="System.Int32"/>
        <Column Name="Salary" DataType="System.Double"/>
        <Column Name="DueSalary" DataType="System.Double"/>
        <Column Name="BounsVal" DataType="System.Double"/>
        <Column Name="MissHourVal" DataType="System.Double"/>
        <Column Name="MissDayVal" DataType="System.Double"/>
        <Column Name="ExtraVal" DataType="System.Double"/>
        <Column Name="DiscVal" DataType="System.Double"/>
        <Column Name="CostVal" DataType="System.Double"/>
        <Column Name="PenaltyVal" DataType="System.Double"/>
        <Column Name="AdvVal" DataType="System.Double"/>
        <Column Name="PubExVal" DataType="System.Double"/>
        <Column Name="PubVRateVal" DataType="System.Double"/>
        <Column Name="PubEDiscVal" DataType="System.Double"/>
        <Column Name="PubCDiscVal" DataType="System.Double"/>
        <Column Name="PubDVRateVal" DataType="System.Double"/>
        <Column Name="VacVal" DataType="System.Double"/>
        <Column Name="VacHVal" DataType="System.Double"/>
        <Column Name="TotalVacVal" DataType="System.Double"/>
        <Column Name="LateVal" DataType="System.Double"/>
        <Column Name="EOutVal" DataType="System.Double"/>
        <Column Name="LegAbsHourVal" DataType="System.Double"/>
        <Column Name="AbsHourVal" DataType="System.Double"/>
        <Column Name="SickAbsHourVal" DataType="System.Double"/>
        <Column Name="LegAbsDayVal" DataType="System.Double"/>
        <Column Name="AbsDayVal" DataType="System.Double"/>
        <Column Name="SickAbsDayVal" DataType="System.Double"/>
        <Column Name="AbsSumVal" DataType="System.Double"/>
        <Column Name="EAddVal1" DataType="System.Double"/>
        <Column Name="EAddVal2" DataType="System.Double"/>
        <Column Name="EAddVal3" DataType="System.Double"/>
        <Column Name="AddVal1" DataType="System.Double"/>
        <Column Name="AddVal2" DataType="System.Double"/>
        <Column Name="AddVal3" DataType="System.Double"/>
        <Column Name="OffHAddVal" DataType="System.Double"/>
        <Column Name="WeekHAddVal" DataType="System.Double"/>
        <Column Name="VacHourVal" DataType="System.Double"/>
        <Column Name="VacDayVal" DataType="System.Double"/>
        <Column Name="MissHourVal1" DataType="System.Double"/>
        <Column Name="MissDayVal1" DataType="System.Double"/>
        <Column Name="TotalDisc" DataType="System.Double"/>
        <Column Name="TotalExtra" DataType="System.Double"/>
        <Column Name="TotalAdd" DataType="System.Double"/>
        <Column Name="NetSalary" DataType="System.Double"/>
        <Column Name="IncomeTax" DataType="System.Double"/>
        <Column Name="InsureVal" DataType="System.Double"/>
        <Column Name="EInsureVal" DataType="System.Double"/>
        <Column Name="CInsureVal" DataType="System.Double"/>
        <Column Name="SectorID" DataType="System.Guid"/>
        <Column Name="SecCode" DataType="System.String"/>
        <Column Name="SecName" DataType="System.String"/>
        <Column Name="SecLatinName" DataType="System.String"/>
        <Column Name="FromDate" DataType="System.DateTime"/>
        <Column Name="ToDate" DataType="System.DateTime"/>
        <Column Name="SINumber" DataType="System.Double"/>
        <Column Name="ResExtVal" DataType="System.Double"/>
        <Column Name="EmpID" DataType="System.Guid"/>
        <Column Name="EEmpCode" DataType="System.String"/>
        <Column Name="EEmpFingerNB" DataType="System.String"/>
        <Column Name="EEmpName" DataType="System.String"/>
        <Column Name="EEmpFName" DataType="System.String"/>
        <Column Name="EEmpFamName" DataType="System.String"/>
        <Column Name="EEmpLatinName" DataType="System.String"/>
        <Column Name="EEmpLFName" DataType="System.String"/>
        <Column Name="EEmpLFamName" DataType="System.String"/>
        <Column Name="EEmpTimeSysID" DataType="System.Guid"/>
      </TableDataSource>
      <TableDataSource Name="Table1" Alias="CloseOutEmpAcc_Report" DataType="System.Int32" Enabled="true" SelectCommand="if(@EmpID='00000000-0000-0000-0000-000000000000')&#13;&#10;&#13;&#10; SELECT  	E.*, 	 C.*  , CASE WHEN (TotalDebit &gt; TotalCredit) THEN (TotalDebit - TotalCredit)/C.CurrencyVal ELSE  (TotalCredit - TotalDebit )/ C.CurrencyVal END AS TotalValue,  	 CI.* , CASE WHEN CI.Credit &gt; 0 THEN CI.Credit / C.CurrencyVal ELSE CI.Debit / C.CurrencyVal END AS Value  &#13;&#10; FROM  	mnrHrCloseAcc C  INNER JOIN mnrHrCloseAccItem CI ON C.ID = CI.ParentID  &#13;&#10; INNER JOIN [mnrHrEmployee] E ON E.ID = C.EmpID  WHERE    CI.Type &lt;&gt; -1 &#13;&#10;and c.date between @FromDate and @ToDate &#13;&#10;else&#13;&#10; SELECT  	E.*, 	 C.*  , CASE WHEN (TotalDebit &gt; TotalCredit) THEN (TotalDebit - TotalCredit)/C.CurrencyVal ELSE  (TotalCredit - TotalDebit )/ C.CurrencyVal END AS TotalValue,  	 CI.* , CASE WHEN CI.Credit &gt; 0 THEN CI.Credit / C.CurrencyVal ELSE CI.Debit / C.CurrencyVal END AS Value  &#13;&#10; FROM  	mnrHrCloseAcc C  INNER JOIN mnrHrCloseAccItem CI ON C.ID = CI.ParentID  &#13;&#10; INNER JOIN [mnrHrEmployee] E ON E.ID = C.EmpID  WHERE    CI.Type &lt;&gt; -1 &#13;&#10;and c.date between @FromDate and @ToDate &#13;&#10;and e.id =@EmpID">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="Code" DataType="System.String"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="FName" DataType="System.String"/>
        <Column Name="GFName" DataType="System.String"/>
        <Column Name="FamName" DataType="System.String"/>
        <Column Name="LFName" DataType="System.String"/>
        <Column Name="LGFName" DataType="System.String"/>
        <Column Name="LFamName" DataType="System.String"/>
        <Column Name="DateOfBirth" DataType="System.DateTime"/>
        <Column Name="Gender" DataType="System.Int32"/>
        <Column Name="MilSrv" DataType="System.Int32"/>
        <Column Name="IsActive" DataType="System.Int32"/>
        <Column Name="MilFromDate" DataType="System.DateTime"/>
        <Column Name="MilToDate" DataType="System.DateTime"/>
        <Column Name="BirthPlace" DataType="System.String"/>
        <Column Name="SocialStatus" DataType="System.Int32"/>
        <Column Name="Kids" DataType="System.Int32"/>
        <Column Name="NatID" DataType="System.Guid"/>
        <Column Name="ReligionID" DataType="System.Guid"/>
        <Column Name="CatID" DataType="System.Guid"/>
        <Column Name="BuildUnitID" DataType="System.Guid"/>
        <Column Name="DateWork" DataType="System.DateTime"/>
        <Column Name="PositionID" DataType="System.Guid"/>
        <Column Name="BranchID" DataType="System.Guid"/>
        <Column Name="DepID" DataType="System.Guid"/>
        <Column Name="SupervisorID" DataType="System.Guid"/>
        <Column Name="IsLeave" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="DateLeave" DataType="System.DateTime"/>
        <Column Name="ResLeaveID" DataType="System.Guid"/>
        <Column Name="LeaveNote" DataType="System.String"/>
        <Column Name="Phone1" DataType="System.String"/>
        <Column Name="Phone2" DataType="System.String"/>
        <Column Name="Mobile1" DataType="System.String"/>
        <Column Name="Mobile2" DataType="System.String"/>
        <Column Name="Address1" DataType="System.String"/>
        <Column Name="Address2" DataType="System.String"/>
        <Column Name="Email1" DataType="System.String"/>
        <Column Name="Email2" DataType="System.String"/>
        <Column Name="SponsorID" DataType="System.Guid"/>
        <Column Name="PassNum" DataType="System.String"/>
        <Column Name="PassJob" DataType="System.String"/>
        <Column Name="DatePass" DataType="System.DateTime"/>
        <Column Name="BorderPerson" DataType="System.String"/>
        <Column Name="BorderNum" DataType="System.String"/>
        <Column Name="DateEnter" DataType="System.DateTime"/>
        <Column Name="ContraTypeID" DataType="System.Guid"/>
        <Column Name="bOffContra" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="OffNum" DataType="System.String"/>
        <Column Name="OffContraType" DataType="System.Int32"/>
        <Column Name="OffQualID" DataType="System.Guid"/>
        <Column Name="OffEduDegID" DataType="System.Guid"/>
        <Column Name="OffNote" DataType="System.String"/>
        <Column Name="EnsrTypeID" DataType="System.Guid"/>
        <Column Name="EnsrTypeWifeID" DataType="System.Guid"/>
        <Column Name="EnsrTypeKidID" DataType="System.Guid"/>
        <Column Name="bEnsrPragnance" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="SlarySysID" DataType="System.Guid"/>
        <Column Name="TimeSysID" DataType="System.Guid"/>
        <Column Name="AccGrpID" DataType="System.Guid"/>
        <Column Name="FingerNB" DataType="System.String"/>
        <Column Name="BSalary" DataType="System.Double"/>
        <Column Name="SpeSalary" DataType="System.Double"/>
        <Column Name="SpareSalary" DataType="System.Double"/>
        <Column Name="MonthlyDays" DataType="System.Double"/>
        <Column Name="HoursWork" DataType="System.Double"/>
        <Column Name="DayCost" DataType="System.Double"/>
        <Column Name="Balanced" DataType="System.Double"/>
        <Column Name="Balance" DataType="System.Double"/>
        <Column Name="ExcAbsence" DataType="System.Double"/>
        <Column Name="UnExcAbsence" DataType="System.Double"/>
        <Column Name="YearHoliday" DataType="System.Double"/>
        <Column Name="DaysPerYear" DataType="System.Double"/>
        <Column Name="ClearHolidays" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="WayPay" DataType="System.Int32"/>
        <Column Name="CurrencyID" DataType="System.Guid"/>
        <Column Name="BankID" DataType="System.Guid"/>
        <Column Name="BankNum" DataType="System.String"/>
        <Column Name="SoEnsrNumber" DataType="System.String"/>
        <Column Name="SoEnsrDate" DataType="System.DateTime"/>
        <Column Name="D1" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="D2" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="D3" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="D4" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="D5" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="D6" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="D7" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="TS1" DataType="System.Guid"/>
        <Column Name="TS2" DataType="System.Guid"/>
        <Column Name="TS3" DataType="System.Guid"/>
        <Column Name="TS4" DataType="System.Guid"/>
        <Column Name="TS5" DataType="System.Guid"/>
        <Column Name="TS6" DataType="System.Guid"/>
        <Column Name="TS7" DataType="System.Guid"/>
        <Column Name="RepMSalary" DataType="System.Double"/>
        <Column Name="RepNegate" DataType="System.Double"/>
        <Column Name="RepDevide" DataType="System.Double"/>
        <Column Name="RepTotal" DataType="System.Double"/>
        <Column Name="RepYears" DataType="System.Int32"/>
        <Column Name="RepAllYears" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="HeadingID" DataType="System.Guid"/>
        <Column Name="RegularTicket" DataType="System.Int32"/>
        <Column Name="SpecificTicket" DataType="System.Int32"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="CDate" DataType="System.DateTime"/>
        <Column Name="UDate" DataType="System.DateTime"/>
        <Column Name="IdNumber" DataType="System.String"/>
        <Column Name="PassportNum" DataType="System.String"/>
        <Column Name="QualDate" DataType="System.DateTime"/>
        <Column Name="DrvLiceNum" DataType="System.String"/>
        <Column Name="HourCost" DataType="System.Double"/>
        <Column Name="LowTickBal" DataType="System.Int32"/>
        <Column Name="NormalTickBal" DataType="System.Int32"/>
        <Column Name="AccID" DataType="System.Guid"/>
        <Column Name="SectorID" DataType="System.Guid"/>
        <Column Name="bSummryWork" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bFixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="DateFixed" DataType="System.DateTime"/>
        <Column Name="bEndContra" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="DateEndContra" DataType="System.DateTime"/>
        <Column Name="ExSMask1" DataType="System.Int64"/>
        <Column Name="ExSMask2" DataType="System.Int64"/>
        <Column Name="SickYearHoliday" DataType="System.Double"/>
        <Column Name="SoInsrEndDate" DataType="System.DateTime"/>
        <Column Name="bSoInsrEndDate" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="MotherName" DataType="System.String"/>
        <Column Name="LMotherName" DataType="System.String"/>
        <Column Name="District" DataType="System.String"/>
        <Column Name="City" DataType="System.String"/>
        <Column Name="Neighborhood" DataType="System.String"/>
        <Column Name="Street" DataType="System.String"/>
        <Column Name="OffJob" DataType="System.String"/>
        <Column Name="bStopSalary" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="StopSalaryDate" DataType="System.DateTime"/>
        <Column Name="VIPTicket" DataType="System.Int32"/>
        <Column Name="VIPTicketBal" DataType="System.Int32"/>
        <Column Name="LinkedinLink" DataType="System.String"/>
        <Column Name="FacebookLink" DataType="System.String"/>
        <Column Name="InstagramLink" DataType="System.String"/>
        <Column Name="TwitterLink" DataType="System.String"/>
        <Column Name="YoutubeLink" DataType="System.String"/>
        <Column Name="SnapchatLink" DataType="System.String"/>
        <Column Name="TickTokLink" DataType="System.String"/>
        <Column Name="TelegramLink" DataType="System.String"/>
        <Column Name="RedditLink" DataType="System.String"/>
        <Column Name="PinterestLink" DataType="System.String"/>
        <Column Name="WorkType" DataType="System.Int32"/>
        <Column Name="ID1" DataType="System.Guid"/>
        <Column Name="Number1" DataType="System.Double"/>
        <Column Name="EmpID" DataType="System.Guid"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="ToDate" DataType="System.DateTime"/>
        <Column Name="CloseType" DataType="System.Int32"/>
        <Column Name="SalType" DataType="System.Int32"/>
        <Column Name="bCalcSal" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="SalSDate" DataType="System.DateTime"/>
        <Column Name="bCalcAdv" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCalcVacExt" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="VacExtSDate" DataType="System.DateTime"/>
        <Column Name="bCalcTickExt" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="TickExtSDate" DataType="System.DateTime"/>
        <Column Name="bCalcRepay" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="RepayDateType" DataType="System.Int32"/>
        <Column Name="RepaySDate" DataType="System.DateTime"/>
        <Column Name="TotalDebit" DataType="System.Double"/>
        <Column Name="TotalCredit" DataType="System.Double"/>
        <Column Name="CurrencyID1" DataType="System.Guid"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="Notes1" DataType="System.String"/>
        <Column Name="CDate1" DataType="System.DateTime"/>
        <Column Name="UDate1" DataType="System.DateTime"/>
        <Column Name="UserID1" DataType="System.Guid"/>
        <Column Name="IsPosted" DataType="System.Int32"/>
        <Column Name="bVacBalOnSalExt" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="TotalValue" DataType="System.Double"/>
        <Column Name="ID2" DataType="System.Guid"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="Number2" DataType="System.Double"/>
        <Column Name="Name1" DataType="System.String"/>
        <Column Name="LatinName1" DataType="System.String"/>
        <Column Name="Debit" DataType="System.Double"/>
        <Column Name="Credit" DataType="System.Double"/>
        <Column Name="Notes2" DataType="System.String"/>
        <Column Name="TypeCnt" DataType="System.Double"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="Value" DataType="System.Double"/>
        <Column Name="NationAddress" DataType="System.String"/>
        <CommandParameter Name="FromDate" DataType="4" Expression="ToDateTime([FromDate])" DefaultValue="1999-10-12"/>
        <CommandParameter Name="ToDate" DataType="4" Expression="ToDateTime([ToDate])" DefaultValue="1999-10-12"/>
        <CommandParameter Name="EmpID" DataType="14" Expression="[m_EmpID]" DefaultValue="00000000-0000-0000-0000-000000000000"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{46329CDF-FD98-41f2-AA26-1F5456A21552}&quot;"/>
    <Parameter Name="CurrencyName" DataType="System.String" Expression="&quot;ريال سعودي&quot;"/>
    <Parameter Name="EmpName" DataType="System.String" Expression="&quot;1005-مدين منصور كوينجو اوغلو&quot;"/>
    <Parameter Name="Date" DataType="System.String" Expression="&quot;28/2/2023&quot;"/>
    <Parameter Name="TotalDebit" DataType="System.String" Expression="&quot;0.000000&quot;"/>
    <Parameter Name="TotalCredit" DataType="System.String" Expression="&quot;3382.370000&quot;"/>
    <Parameter Name="CurrencyVal" DataType="System.String" Expression="&quot;1.000000&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;11/30/2023&quot;"/>
    <Parameter Name="SalFDate" DataType="System.String" Expression="&quot;1/12/2023&quot;"/>
    <Parameter Name="vacFDate" DataType="System.String" Expression="&quot;1/1/2023&quot;"/>
    <Parameter Name="TickFDate" DataType="System.String" Expression="&quot;1/1/2023&quot;"/>
    <Parameter Name="RepayFDate" DataType="System.String" Expression="&quot;28/2/2024&quot;"/>
    <Parameter Name="CloseRes" DataType="System.String" Expression="&quot;استقالة&quot;"/>
    <Parameter Name="CloseSal" DataType="System.String" Expression="&quot;الراتب الأساسي&quot;"/>
    <Parameter Name="CalcSal" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="IsNew" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="IsRfreshed" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;11/01/2023&quot;"/>
    <Parameter Name="m_ShowBouns" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowMiss" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowDisc" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowCost" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowPen" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowAdv" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowPubDisc" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowPubBouns" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowTime" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowVac" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="m_ShowType" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="m_PeriodName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="m_sCurrencyID" DataType="System.String" Expression="&quot;{4F425CE1-1697-4b62-A1A1-095D84C722A2}&quot;"/>
    <Parameter Name="m_UserName" DataType="System.String" Expression="&quot;001&quot;"/>
    <Parameter Name="m_UserLatinName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="m_EmpID" DataType="System.String" Expression="&quot;{00000000-0000-0000-0000-000000000000}&quot;"/>
    <Total Name="Total" Expression="IIf([CloseOutEmpAcc_Report.Type] == 1 , [CloseOutEmpAcc_Report.Value],0)" Evaluator="Data2" PrintOn="GroupFooter1"/>
    <Total Name="Total1" Expression="IIf([CloseOutEmpAcc_Report.Type] == 2, [CloseOutEmpAcc_Report.Value],0)" Evaluator="Data2" PrintOn="GroupFooter1"/>
    <Total Name="Total2" Expression="IIf([CloseOutEmpAcc_Report.Type] == 3, [CloseOutEmpAcc_Report.Value],0)" Evaluator="Data2" PrintOn="GroupFooter1"/>
    <Total Name="Total3" Expression="IIf([CloseOutEmpAcc_Report.Type] == 13, [CloseOutEmpAcc_Report.Value],0)" Evaluator="Data2" PrintOn="GroupFooter1"/>
    <Total Name="Total4" Expression="IIf([CloseOutEmpAcc_Report.Type] == 4, [CloseOutEmpAcc_Report.Value],0)" Evaluator="Data2" PrintOn="GroupFooter1"/>
    <Total Name="Total5" Expression="IIf([CloseOutEmpAcc_Report.Type]==5,[CloseOutEmpAcc_Report.Value],0)" Evaluator="Data2" PrintOn="GroupFooter1"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2"/>
    <GroupHeaderBand Name="GroupHeader1" Top="2.67" Width="718.2" Height="357.28" StartNewPage="true" Condition="[CloseOutEmpAcc_Report.ID]">
      <TextObject Name="Memo2" Left="10.86" Top="203.3" Width="693.54" Height="30.24" Border.Lines="All" Fill.Color="216, 216, 216" Text="النموذج الموحد لتصفية حساب موظف" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 12pt, style=Bold"/>
      <TextObject Name="Memo3" Left="496.53" Top="279.61" Width="207.87" Height="22.68" Border.Lines="Right, Top" Text="التاريخ" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text1" Left="10.55" Top="279.61" Width="485.67" Height="22.68" Border.Lines="Left, Right, Top" Text="[CloseOutEmpAcc_Report.Date]" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Text3" Left="496.53" Top="300.97" Width="207.87" Height="22.68" Border.Lines="Right, Top, Bottom" Text="تصفية الى تاريخ" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text5" Left="496.53" Top="256.93" Width="207.87" Height="22.68" Border.Lines="Right, Top, Bottom" Text="الراتب الاساسي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text6" Left="10.55" Top="300.97" Width="485.67" Height="22.68" Border.Lines="All" Text=" [CloseOutEmpAcc_Report.ToDate]" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
      <PictureObject Name="Company_logo" Left="9.28" Top="9.45" Width="701.1" Height="98.27" Fill.Color="White" ImageLocation="\\server\Manara Tools\2019.bmp" SizeMode="StretchImage"/>
      <TextObject Name="Text26" Left="604.8" Top="170.1" Width="94.5" Height="18.9" Text="من تاريخ  :" VertAlign="Center" RightToLeft="true" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text27" Left="359.1" Top="170.1" Width="94.5" Height="18.9" Text="[ToDate]" HorzAlign="Right" VertAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Text28" Left="548.1" Top="170.1" Width="94.5" Height="18.9" Text="[FromDate]" HorzAlign="Right" VertAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Text29" Left="444.15" Top="170.1" Width="94.5" Height="18.9" Text=" : الى تاريخ" HorzAlign="Right" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text25" Left="165.38" Top="113.4" Width="368.55" Height="37.8" Text="تقرير تصفية مستحقات الموظفين" HorzAlign="Center" Font="Arial, 16pt, style=Bold"/>
      <TextObject Name="Memo16" Left="10.55" Top="256.93" Width="485.67" Height="22.68" Border.Lines="Left, Right, Top" Text=" [CloseOutEmpAcc_Report.BSalary]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Memo14" Left="10.55" Top="234.25" Width="485.67" Height="22.68" Border.Lines="Left, Right" Text="[CloseOutEmpAcc_Report.Name] [CloseOutEmpAcc_Report.FName]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt">
        <Formats>
          <GeneralFormat/>
          <GeneralFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Memo5" Left="496.53" Top="234.25" Width="207.87" Height="22.68" Border.Lines="Right" Text="اسم الموظف" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo13" Left="496.43" Top="323.75" Width="207.87" Height="22.68" Border.Lines="Right, Top, Bottom" Text="سبب التصفية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text4" Left="10.45" Top="323.75" Width="485.67" Height="22.68" Border.Lines="All" Text="[IIf([CloseOutEmpAcc_Report.CloseType]==0,&quot;استقالة&quot;,IIf([CloseOutEmpAcc_Report.CloseType]==1,&quot;إقالة&quot;,IIf([CloseOutEmpAcc_Report.CloseType]==2,&quot;وفاة&quot;,IIf([CloseOutEmpAcc_Report.CloseType]==3,&quot;إنتهاء العقد&quot;,&quot;&quot;))))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
      <DataBand Name="Data2" Top="362.61" Width="718.2" DataSource="Table1"/>
      <GroupFooterBand Name="GroupFooter1" Top="365.28" Width="718.2" Height="231.89">
        <TextObject Name="Memo72" Left="10.61" Top="157.73" Width="154.96" Height="22.68" Border.Lines="Left, Top, Bottom" Text="[Total4]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo75" Left="496.53" Top="157.73" Width="207.87" Height="22.68" Border.Lines="Right, Top, Bottom" Text="تعويض نهاية الخدمة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo98" Left="10.61" Top="135.05" Width="154.96" Height="22.68" Border.Lines="Left, Top, Bottom" Text="[Total3]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo101" Left="496.53" Top="135.05" Width="207.87" Height="22.68" Border.Lines="Right, Top, Bottom" Text="السلف" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo94" Left="10.61" Top="112.37" Width="154.96" Height="22.68" Border.Lines="Left, Top, Bottom" Text="[[Total1]+[Total2]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo97" Left="496.53" Top="112.37" Width="207.87" Height="22.68" Border.Lines="Right, Top, Bottom" Text="بدل تذاكر السفر" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo90" Left="10.61" Top="89.69" Width="154.96" Height="22.68" Border.Lines="Left, Top, Bottom" Text="[Total]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo93" Left="496.53" Top="89.69" Width="207.87" Height="22.68" Border.Lines="Right, Top, Bottom" Text="بدل الاجازة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo86" Left="10.61" Top="43.02" Width="154.96" Height="22.68" Border.Lines="Left, Top" Fill.Color="200, 200, 200" Text="القيمة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Memo85" Left="10.86" Top="12" Width="693.54" Height="30.24" Border.Lines="All" Fill.Color="Silver" Text="مستحقات نهاية الخدمة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 12pt, style=Bold"/>
        <TextObject Name="Text7" Left="10.61" Top="66.15" Width="154.96" Height="22.68" Border.Lines="Left, Top" Text="[Total5]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text8" Left="496.4" Top="66.15" Width="207.87" Height="22.68" Border.Lines="Right, Top" Text="الراتب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text10" Left="165.57" Top="135.05" Width="160.62" Height="22.68" Border.Lines="All" Text="[CloseOutEmpAcc_Report.ToDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text11" Left="165.57" Top="112.37" Width="160.62" Height="22.68" Border.Lines="All" Text="[CloseOutEmpAcc_Report.ToDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text12" Left="165.57" Top="89.69" Width="160.62" Height="22.68" Border.Lines="All" Text="[CloseOutEmpAcc_Report.ToDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text13" Left="165.57" Top="43.02" Width="160.62" Height="22.68" Border.Lines="Left, Right" Fill.Color="200, 200, 200" Text="الى تاريخ" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text14" Left="165.57" Top="66.15" Width="160.62" Height="22.68" Border.Lines="Left, Right, Top" Text="[CloseOutEmpAcc_Report.ToDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text9" Left="165.57" Top="157.73" Width="160.62" Height="22.68" Border.Lines="All" Text="[CloseOutEmpAcc_Report.ToDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text15" Left="326.19" Top="157.73" Width="170.07" Height="22.68" Border.Lines="All" Text="[CloseOutEmpAcc_Report.RepaySDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text16" Left="326.19" Top="135.05" Width="170.07" Height="22.68" Border.Lines="All" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text17" Left="326.19" Top="112.37" Width="170.07" Height="22.68" Border.Lines="All" Text="[CloseOutEmpAcc_Report.TickExtSDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text18" Left="326.19" Top="89.69" Width="170.07" Height="22.68" Border.Lines="All" Text="[CloseOutEmpAcc_Report.VacExtSDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text19" Left="326.19" Top="43.02" Width="170.07" Height="22.68" Border.Lines="Left" Fill.Color="200, 200, 200" Text="من تاريخ" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text20" Left="326.19" Top="66.15" Width="170.07" Height="22.68" Border.Lines="Left, Right, Top" Text="[CloseOutEmpAcc_Report.SalSDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text21" Left="10.61" Top="179.87" Width="154.96" Height="22.68" Border.Lines="Left, Bottom" Text="[[Total5]+[Total]+[Total1]+[Total2]+[Total3]+[Total4]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text22" Left="496.53" Top="179.87" Width="207.87" Height="22.68" Border.Lines="Right, Bottom" Text="الاجمالي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text23" Left="165.57" Top="179.87" Width="160.62" Height="22.68" Border.Lines="Left, Right, Bottom" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text24" Left="326.19" Top="179.87" Width="170.07" Height="22.68" Border.Lines="Left, Right, Bottom" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text30" Left="496.4" Top="43.02" Width="207.87" Height="22.68" Border.Lines="Left, Right" Fill.Color="200, 200, 200" Text="الراتب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      </GroupFooterBand>
    </GroupHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="599.84" Width="718.2" Height="44.78">
      <TextObject Name="Memo1" Left="638.74" Top="3.78" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
      <TextObject Name="Memo25" Left="67.81" 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="Memo54" Left="7.56" 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="Memo104" Left="157.3" Top="3.78" Width="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo152" Left="585.38" Top="29.66" Width="136.07" Height="15.12" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Text2" Left="189" Top="3.78" Width="83.15" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
    </PageFooterBand>
  </ReportPage>
</Report>
