﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReferencedAssemblies="System.dll&#13;&#10;System.Drawing.dll&#13;&#10;System.Data.dll&#13;&#10;System.Xml.dll&#13;&#10;FastReport.Compat.dll&#13;&#10;System.Windows.Forms.dll&#13;&#10;FastReport.DataVisualization.dll&#13;&#10;MFRComLib.dll" StartReportEvent="_StartReport" ReportInfo.Created="10/22/2021 12:22:29" ReportInfo.Modified="03/17/2023 10:23:58" 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;
using FRCom;

namespace FastReport
{
  public class ReportScript
  {
    
    void Text6_AfterPrint(object sender, EventArgs e)
    { 
      
      int count=0;
      DataSourceBase ds =Report.GetDataSource(&quot;PosBill&quot;);
       ds.Init();
      while(ds.HasMoreRows)
      {
        
        if(((Int64)Report.GetColumnValue(&quot;PosBill.Printed&quot;))&gt;0  )
        {
          count=count+1;
          
        }
        ds.Next();
             
      
      }
      if(count==ds.RowCount)
      {
        Text6.Text=&quot;نسخة مكررة&quot;;
         
           
      }
      else{Text6.Text=&quot;&quot;;}
  
        
    }
    

    private void Barcode1_BeforePrint(object sender, EventArgs e)
    {
      Guid newCode;

      Barcode1.Text = ((String)Report.GetColumnValue(&quot;Bill_Main.BEFaturaNumber&quot;));
      
      if(!string.IsNullOrEmpty((String)Report.GetColumnValue(&quot;Bill_Main.Bstr1&quot;)))
      {
        if(Guid.TryParse((String)Report.GetColumnValue(&quot;Bill_Main.Bstr1&quot;) , out newCode))
        {
          Barcode1.Text = (String)Report.GetColumnValue(&quot;Bill_Main.Bstr1&quot;);
        }
      }
    }
  }
}
</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiLeyYgzGsg8K0w/wV+uVJpRb9DC+IFtFJ1Ya+wGL6sGP+LlGmWCsZftl80X1OZU2OLg7Xmxnkp41Wl7LrNJHJ83vvlYpsJ+6DtFdt82j1thRJJ4BPMOXXQ/VznxXbVK4wYXEfc/GT9jRWt/AYscmVrEJOp4AS6pfF/zabOfAeUxnPCFZuNTTYf/Anqida2Bnq4wWsjYQk+bW2BLfUXiq65uF50V779GQRASHenAhYUkWSzDbA55v76C9I5KXmHcVFOiKZ+crBw0xzYGCLy1zA+5u2EhK1ncHnju8fsDtQSCKHPF/gcZOsPDlVLbNE0mfQthSkUwe+rOWG2wRpE+KPod4Fcxq3gunpXyR6lKHmlhZCpEl+DhWx7PfMSbDazPY+COK+/qGCXHLZyacBrpvSmak7r6CzLPw4+h0pwFa+tzSii0Zv9DN8UEf7Wbq03UkBiyGMlaM3mpkAwbcbFlMcfoVkaKlOuSDBdv7Zmh9anZplloQRffHv2Tv2GkEp72wdqH/k4XVmDCpyw2JLs0oHt2xIq29iX3qXEUhQeNJBjOCsK4r0Uq7hFWmN6TQWZjgtcbITZpBU/ZoOeZAdy4/jGg==">
      <TableDataSource Name="Bill_Main" DataType="System.Int32" Enabled="true" TableName="Bill_Main" SelectCommand="exec [dbo].[mnrFrx_BillMain] '{34A2AE05-D3DE-4321-A9DD-512C60010F25}'">
        <Column Name="BID" DataType="System.Guid"/>
        <Column Name="BNumber" DataType="System.Double"/>
        <Column Name="BDate" DataType="System.DateTime"/>
        <Column Name="BAccCustID" DataType="System.Guid"/>
        <Column Name="BAccCustName" DataType="System.String"/>
        <Column Name="BPayType" DataType="System.Int32"/>
        <Column Name="BAccAccountID" DataType="System.Guid"/>
        <Column Name="BCurrencyID" DataType="System.Guid"/>
        <Column Name="BCurrencyVal" DataType="System.Double"/>
        <Column Name="BNotes" DataType="System.String"/>
        <Column Name="BTotal" DataType="System.Double"/>
        <Column Name="BTotalItem" DataType="System.Double"/>
        <Column Name="BTotalExtra" DataType="System.Double"/>
        <Column Name="BTotalDisc" DataType="System.Double"/>
        <Column Name="BItemsExtra" DataType="System.Double"/>
        <Column Name="BItemsDisc" DataType="System.Double"/>
        <Column Name="BTotalPaid" DataType="System.Double"/>
        <Column Name="BProfits" DataType="System.Double"/>
        <Column Name="BStatus" DataType="System.Int32"/>
        <Column Name="BStoreID" DataType="System.Guid"/>
        <Column Name="BCostJobID" DataType="System.Guid"/>
        <Column Name="BBillTypeID" DataType="System.Guid"/>
        <Column Name="BBranchID" DataType="System.Guid"/>
        <Column Name="BSalesmanID" DataType="System.Guid"/>
        <Column Name="BVendor" DataType="System.String"/>
        <Column Name="BUserID" DataType="System.Guid"/>
        <Column Name="BIsPosted" DataType="System.Int32"/>
        <Column Name="BVAT" DataType="System.Double"/>
        <Column Name="BClass" DataType="System.String"/>
        <Column Name="BLinkID" DataType="System.Guid"/>
        <Column Name="BTermType" DataType="System.Int32"/>
        <Column Name="BTermCnt" DataType="System.Int32"/>
        <Column Name="Bstr1" DataType="System.String"/>
        <Column Name="Bstr2" DataType="System.String"/>
        <Column Name="Bstr3" DataType="System.String"/>
        <Column Name="Bstr4" DataType="System.String"/>
        <Column Name="Bstr5" DataType="System.String"/>
        <Column Name="Bstr6" DataType="System.String"/>
        <Column Name="BDate1" DataType="System.DateTime"/>
        <Column Name="BDate2" DataType="System.DateTime"/>
        <Column Name="BDate3" DataType="System.DateTime"/>
        <Column Name="BIsPrinted" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="BTimeIn" DataType="System.DateTime"/>
        <Column Name="BParentID" DataType="System.Guid"/>
        <Column Name="BParentType" DataType="System.Int32"/>
        <Column Name="BInsuranceID" DataType="System.Guid"/>
        <Column Name="BInsurCardNum" DataType="System.String"/>
        <Column Name="BInsurExpDate" DataType="System.DateTime"/>
        <Column Name="BInsurRate" DataType="System.Double"/>
        <Column Name="BInsurMaxVal" DataType="System.Double"/>
        <Column Name="BInsurClass" DataType="System.String"/>
        <Column Name="BInsurNetwork" DataType="System.String"/>
        <Column Name="BInsurNotes" DataType="System.String"/>
        <Column Name="BCheck" DataType="System.Int32"/>
        <Column Name="BItemsDisc1" DataType="System.Double"/>
        <Column Name="BItemsDisc2" DataType="System.Double"/>
        <Column Name="BEFaturaNumber" DataType="System.String"/>
        <Column Name="BCFVal1" DataType="System.String"/>
        <Column Name="BCFVal2" DataType="System.String"/>
        <Column Name="BCFVal3" DataType="System.String"/>
        <Column Name="BCFVal4" DataType="System.String"/>
        <Column Name="BCFVal5" DataType="System.String"/>
        <Column Name="BCFVal6" DataType="System.String"/>
        <Column Name="BCFVal7" DataType="System.String"/>
        <Column Name="BCFVal8" DataType="System.String"/>
        <Column Name="BCFVal9" DataType="System.String"/>
        <Column Name="BCFVal10" DataType="System.String"/>
        <Column Name="BCFVal11" DataType="System.String"/>
        <Column Name="BCFVal12" DataType="System.String"/>
        <Column Name="BCFVal13" DataType="System.String"/>
        <Column Name="BCFVal14" DataType="System.String"/>
        <Column Name="BCFVal15" DataType="System.String"/>
        <Column Name="BCFVal16" DataType="System.String"/>
        <Column Name="BCFVal17" DataType="System.String"/>
        <Column Name="BCFVal18" DataType="System.String"/>
        <Column Name="BCFVal19" DataType="System.String"/>
        <Column Name="BCFVal20" DataType="System.String"/>
        <Column Name="BCFVal21" DataType="System.String"/>
        <Column Name="BCFVal22" DataType="System.String"/>
        <Column Name="BCFVal23" DataType="System.String"/>
        <Column Name="BCFVal24" DataType="System.String"/>
        <Column Name="BCFVal25" DataType="System.String"/>
        <Column Name="BCFVal26" DataType="System.String"/>
        <Column Name="BCFVal27" DataType="System.String"/>
        <Column Name="BCFVal28" DataType="System.String"/>
        <Column Name="BCFVal29" DataType="System.String"/>
        <Column Name="BCFVal30" DataType="System.String"/>
        <Column Name="BCFVal31" DataType="System.String"/>
        <Column Name="BCFVal32" DataType="System.String"/>
        <Column Name="BCFVal33" DataType="System.String"/>
        <Column Name="BCFVal34" DataType="System.String"/>
        <Column Name="BCFVal35" DataType="System.String"/>
        <Column Name="BCFVal36" DataType="System.String"/>
        <Column Name="BCFVal37" DataType="System.String"/>
        <Column Name="BCFVal38" DataType="System.String"/>
        <Column Name="BCFVal39" DataType="System.String"/>
        <Column Name="BCFVal40" DataType="System.String"/>
        <Column Name="BCFVal41" DataType="System.String"/>
        <Column Name="BCFVal42" DataType="System.String"/>
        <Column Name="BCFVal43" DataType="System.String"/>
        <Column Name="BCFVal44" DataType="System.String"/>
        <Column Name="BCFVal45" DataType="System.String"/>
        <Column Name="BCFVal46" DataType="System.String"/>
        <Column Name="BCFVal47" DataType="System.String"/>
        <Column Name="BCFVal48" DataType="System.String"/>
        <Column Name="BCFVal49" DataType="System.String"/>
        <Column Name="BCFVal50" DataType="System.String"/>
        <Column Name="BCFVal51" DataType="System.String"/>
        <Column Name="BCFVal52" DataType="System.String"/>
        <Column Name="BCFVal53" DataType="System.String"/>
        <Column Name="BCFVal54" DataType="System.String"/>
        <Column Name="BCFVal55" DataType="System.String"/>
        <Column Name="BCFVal56" DataType="System.String"/>
        <Column Name="BCFVal57" DataType="System.String"/>
        <Column Name="BCFVal58" DataType="System.String"/>
        <Column Name="BCFVal59" DataType="System.String"/>
        <Column Name="BCFVal60" DataType="System.String"/>
        <Column Name="BCFVal61" DataType="System.String"/>
        <Column Name="BCFVal62" DataType="System.String"/>
        <Column Name="BCFVal63" DataType="System.String"/>
        <Column Name="BCFVal64" DataType="System.String"/>
        <Column Name="diTotalDisc" DataType="System.Double"/>
        <Column Name="diTotalExtra" DataType="System.Double"/>
        <Column Name="BillType_Code" DataType="System.String"/>
        <Column Name="BillType_Name" DataType="System.String"/>
        <Column Name="BillType_LatinName" DataType="System.String"/>
        <Column Name="Branch_Code" DataType="System.String"/>
        <Column Name="Branch_Name" DataType="System.String"/>
        <Column Name="Branch_LatinName" DataType="System.String"/>
        <Column Name="Curr_Code" DataType="System.String"/>
        <Column Name="Curr_Name" DataType="System.String"/>
        <Column Name="Curr_LatinName" DataType="System.String"/>
        <Column Name="Curr_PartName" DataType="System.String"/>
        <Column Name="Curr_PartLatinName" DataType="System.String"/>
        <Column Name="acID" DataType="System.Guid"/>
        <Column Name="acNumber" DataType="System.Int32"/>
        <Column Name="acName" DataType="System.String"/>
        <Column Name="acLatinName" DataType="System.String"/>
        <Column Name="acCode" DataType="System.String"/>
        <Column Name="acNotes" DataType="System.String"/>
        <Column Name="acParentID" DataType="System.Guid"/>
        <Column Name="acFinalAccID" DataType="System.Guid"/>
        <Column Name="acType" DataType="System.Int32"/>
        <Column Name="acBudgetType" DataType="System.Int32"/>
        <Column Name="acBudget" DataType="System.Double"/>
        <Column Name="acMatchDate" DataType="System.DateTime"/>
        <Column Name="acDebit" DataType="System.Double"/>
        <Column Name="acCredit" DataType="System.Double"/>
        <Column Name="acCurrencyID" DataType="System.Guid"/>
        <Column Name="acCurrencyVal" DataType="System.Double"/>
        <Column Name="acCustID" DataType="System.Guid"/>
        <Column Name="acActivityID" DataType="System.Guid"/>
        <Column Name="acNSons" DataType="System.Int32"/>
        <Column Name="acUseFlage" DataType="System.Int32"/>
        <Column Name="acBalanced" DataType="System.Int32"/>
        <Column Name="CuID" DataType="System.Guid"/>
        <Column Name="CuNumber" DataType="System.Int32"/>
        <Column Name="CuName" DataType="System.String"/>
        <Column Name="CuLatinName" DataType="System.String"/>
        <Column Name="CuPriceType" DataType="System.Int32"/>
        <Column Name="CuDiscRate" DataType="System.Double"/>
        <Column Name="CuBarcode" DataType="System.String"/>
        <Column Name="CuPrefix" DataType="System.String"/>
        <Column Name="CuSuffix" DataType="System.String"/>
        <Column Name="CuCountry" DataType="System.String"/>
        <Column Name="CuCity" DataType="System.String"/>
        <Column Name="CuArea" DataType="System.String"/>
        <Column Name="CuStreet" DataType="System.String"/>
        <Column Name="CuNationality" DataType="System.String"/>
        <Column Name="CuPoBox" DataType="System.String"/>
        <Column Name="CuMailBox" DataType="System.String"/>
        <Column Name="CuPhone1" DataType="System.String"/>
        <Column Name="CuPhone2" DataType="System.String"/>
        <Column Name="CuMobile" DataType="System.String"/>
        <Column Name="CuFax" DataType="System.String"/>
        <Column Name="CuTelex" DataType="System.String"/>
        <Column Name="CuEmail" DataType="System.String"/>
        <Column Name="CuWebPage" DataType="System.String"/>
        <Column Name="CuNotes" DataType="System.String"/>
        <Column Name="CuTermType" DataType="System.Int32"/>
        <Column Name="CuTermCnt" DataType="System.Int32"/>
        <Column Name="CuSalesmanID" DataType="System.Guid"/>
        <Column Name="CuInactive" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="CuHold" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="CuVATAccID" DataType="System.Guid"/>
        <Column Name="CuBeginPoint" DataType="System.Double"/>
        <Column Name="CuCurrentPoint" DataType="System.Double"/>
        <Column Name="CuTaxNum" DataType="System.String"/>
        <Column Name="CuClassID" DataType="System.Guid"/>
        <Column Name="CuType" DataType="System.Int32"/>
        <Column Name="CuSMCode" DataType="System.String"/>
        <Column Name="CuSMName" DataType="System.String"/>
        <Column Name="CuCFVal1" DataType="System.String"/>
        <Column Name="CuCFVal2" DataType="System.String"/>
        <Column Name="CuCFVal3" DataType="System.String"/>
        <Column Name="CuCFVal4" DataType="System.String"/>
        <Column Name="CuCFVal5" DataType="System.String"/>
        <Column Name="CuCFVal6" DataType="System.String"/>
        <Column Name="CuCFVal7" DataType="System.String"/>
        <Column Name="CuCFVal8" DataType="System.String"/>
        <Column Name="CuCFVal9" DataType="System.String"/>
        <Column Name="CuCFVal10" DataType="System.String"/>
        <Column Name="CuCFVal11" DataType="System.String"/>
        <Column Name="CuCFVal12" DataType="System.String"/>
        <Column Name="CuCFVal13" DataType="System.String"/>
        <Column Name="CuCFVal14" DataType="System.String"/>
        <Column Name="CuCFVal15" DataType="System.String"/>
        <Column Name="CuCFVal16" DataType="System.String"/>
        <Column Name="CuCFVal17" DataType="System.String"/>
        <Column Name="CuCFVal18" DataType="System.String"/>
        <Column Name="CuCFVal19" DataType="System.String"/>
        <Column Name="CuCFVal20" DataType="System.String"/>
        <Column Name="CuCFVal21" DataType="System.String"/>
        <Column Name="CuCFVal22" DataType="System.String"/>
        <Column Name="CuCFVal23" DataType="System.String"/>
        <Column Name="CuCFVal24" DataType="System.String"/>
        <Column Name="CuCFVal25" DataType="System.String"/>
        <Column Name="CuCFVal26" DataType="System.String"/>
        <Column Name="CuCFVal27" DataType="System.String"/>
        <Column Name="CuCFVal28" DataType="System.String"/>
        <Column Name="CuCFVal29" DataType="System.String"/>
        <Column Name="CuCFVal30" DataType="System.String"/>
        <Column Name="CuCFVal31" DataType="System.String"/>
        <Column Name="CuCFVal32" DataType="System.String"/>
        <Column Name="CuCFVal33" DataType="System.String"/>
        <Column Name="CuCFVal34" DataType="System.String"/>
        <Column Name="CuCFVal35" DataType="System.String"/>
        <Column Name="CuCFVal36" DataType="System.String"/>
        <Column Name="CuCFVal37" DataType="System.String"/>
        <Column Name="CuCFVal38" DataType="System.String"/>
        <Column Name="CuCFVal39" DataType="System.String"/>
        <Column Name="CuCFVal40" DataType="System.String"/>
        <Column Name="CuCFVal41" DataType="System.String"/>
        <Column Name="CuCFVal42" DataType="System.String"/>
        <Column Name="CuCFVal43" DataType="System.String"/>
        <Column Name="CuCFVal44" DataType="System.String"/>
        <Column Name="CuCFVal45" DataType="System.String"/>
        <Column Name="CuCFVal46" DataType="System.String"/>
        <Column Name="CuCFVal47" DataType="System.String"/>
        <Column Name="CuCFVal48" DataType="System.String"/>
        <Column Name="CuCFVal49" DataType="System.String"/>
        <Column Name="CuCFVal50" DataType="System.String"/>
        <Column Name="CuCFVal51" DataType="System.String"/>
        <Column Name="CuCFVal52" DataType="System.String"/>
        <Column Name="CuCFVal53" DataType="System.String"/>
        <Column Name="CuCFVal54" DataType="System.String"/>
        <Column Name="CuCFVal55" DataType="System.String"/>
        <Column Name="CuCFVal56" DataType="System.String"/>
        <Column Name="CuCFVal57" DataType="System.String"/>
        <Column Name="CuCFVal58" DataType="System.String"/>
        <Column Name="CuCFVal59" DataType="System.String"/>
        <Column Name="CuCFVal60" DataType="System.String"/>
        <Column Name="CuCFVal61" DataType="System.String"/>
        <Column Name="CuCFVal62" DataType="System.String"/>
        <Column Name="CuCFVal63" DataType="System.String"/>
        <Column Name="CuCFVal64" DataType="System.String"/>
        <Column Name="ac2Code" DataType="System.String"/>
        <Column Name="ac2Name" DataType="System.String"/>
        <Column Name="ac2LatinName" DataType="System.String"/>
        <Column Name="store_Code" DataType="System.String"/>
        <Column Name="store_Name" DataType="System.String"/>
        <Column Name="store_LatinName" DataType="System.String"/>
        <Column Name="costjob_Code" DataType="System.String"/>
        <Column Name="costjob_Name" DataType="System.String"/>
        <Column Name="costjob_LatinName" DataType="System.String"/>
        <Column Name="sellman_Code" DataType="System.String"/>
        <Column Name="sellman_Name" DataType="System.String"/>
        <Column Name="sellman_LatinName" DataType="System.String"/>
        <Column Name="user_Name" DataType="System.String"/>
        <Column Name="user_LatinName" DataType="System.String"/>
        <Column Name="ENumber" DataType="System.Double"/>
        <Column Name="bin_store_Code" DataType="System.String"/>
        <Column Name="bin_store_Name" DataType="System.String"/>
        <Column Name="bin_store_LatinName" DataType="System.String"/>
        <Column Name="bin_costjob_Code" DataType="System.String"/>
        <Column Name="bin_costjob_Name" DataType="System.String"/>
        <Column Name="bin_costjob_LatinName" DataType="System.String"/>
        <Column Name="bin_sellman_Code" DataType="System.String"/>
        <Column Name="bin_sellman_Name" DataType="System.String"/>
        <Column Name="bin_sellman_LatinName" DataType="System.String"/>
        <Column Name="bTotalQty" DataType="System.Double"/>
        <Column Name="CuActivityType" DataType="System.Int32"/>
        <Column Name="CuTaxCode" DataType="System.String"/>
        <Column Name="CuIdentity" DataType="System.String"/>
        <Column Name="CuPassportNum" DataType="System.String"/>
        <Column Name="CuRegistrationNum" DataType="System.String"/>
        <Column Name="CuResidenceNum" DataType="System.String"/>
        <Column Name="CuLicense1" DataType="System.String"/>
        <Column Name="CuLicense2" DataType="System.String"/>
        <Column Name="CuLicense3" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="Bill_Details" DataType="System.Int32" Enabled="true" TableName="Bill_Details" SelectCommand="exec [dbo].[mnrFrx_BillDetails] '{34A2AE05-D3DE-4321-A9DD-512C60010F25}'">
        <Column Name="biID" DataType="System.Guid"/>
        <Column Name="biBillID" DataType="System.Guid"/>
        <Column Name="biNumber" DataType="System.Int32"/>
        <Column Name="biMatID" DataType="System.Guid"/>
        <Column Name="biStoreID" DataType="System.Guid"/>
        <Column Name="biCostJobID" DataType="System.Guid"/>
        <Column Name="biMatUnitFact" DataType="System.Double"/>
        <Column Name="biUnitName" DataType="System.String"/>
        <Column Name="biBillQty" DataType="System.Double"/>
        <Column Name="biDefQty" DataType="System.Double"/>
        <Column Name="biQty1" DataType="System.Double"/>
        <Column Name="biQty2" DataType="System.Double"/>
        <Column Name="biQty3" DataType="System.Double"/>
        <Column Name="biQty4" DataType="System.Double"/>
        <Column Name="biQty5" DataType="System.Double"/>
        <Column Name="biUnit" DataType="System.Int32"/>
        <Column Name="biPrice" DataType="System.Double"/>
        <Column Name="biDisc" DataType="System.Double"/>
        <Column Name="biDisc1" DataType="System.Double"/>
        <Column Name="biDisc2" DataType="System.Double"/>
        <Column Name="biExtra" DataType="System.Double"/>
        <Column Name="biBillBonus" DataType="System.Double"/>
        <Column Name="biDefBonus" DataType="System.Double"/>
        <Column Name="biBonus1" DataType="System.Double"/>
        <Column Name="biBonus2" DataType="System.Double"/>
        <Column Name="biBonus3" DataType="System.Double"/>
        <Column Name="biBonus4" DataType="System.Double"/>
        <Column Name="biBonus5" DataType="System.Double"/>
        <Column Name="biCostItem" DataType="System.Double"/>
        <Column Name="biNotes" DataType="System.String"/>
        <Column Name="biLength" DataType="System.Double"/>
        <Column Name="biWidth" DataType="System.Double"/>
        <Column Name="biHeight" DataType="System.Double"/>
        <Column Name="biCnt" DataType="System.Double"/>
        <Column Name="biExpireDate" DataType="System.DateTime"/>
        <Column Name="biProductDate" DataType="System.DateTime"/>
        <Column Name="biProvideDate" DataType="System.DateTime"/>
        <Column Name="biSalesmanID" DataType="System.Guid"/>
        <Column Name="biVendor" DataType="System.String"/>
        <Column Name="biVAT" DataType="System.Double"/>
        <Column Name="biVATRatio" DataType="System.Double"/>
        <Column Name="biClass" DataType="System.String"/>
        <Column Name="biRelNum" DataType="System.Int32"/>
        <Column Name="biLinkID" DataType="System.Guid"/>
        <Column Name="biStatus" DataType="System.Int32"/>
        <Column Name="mtID" DataType="System.Guid"/>
        <Column Name="mtNumber" DataType="System.Int32"/>
        <Column Name="mtCode" DataType="System.String"/>
        <Column Name="mtName" DataType="System.String"/>
        <Column Name="mtLatinName" DataType="System.String"/>
        <Column Name="mtParentID" DataType="System.Guid"/>
        <Column Name="mtUnit1" DataType="System.String"/>
        <Column Name="mtUnit2" DataType="System.String"/>
        <Column Name="mtUnit2Rate" DataType="System.Double"/>
        <Column Name="mtRate2Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtUnit3" DataType="System.String"/>
        <Column Name="mtUnit3Rate" DataType="System.Double"/>
        <Column Name="mtRate3Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtUnit4" DataType="System.String"/>
        <Column Name="mtUnit4Rate" DataType="System.Double"/>
        <Column Name="mtRate4Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtUnit5" DataType="System.String"/>
        <Column Name="mtUnit5Rate" DataType="System.Double"/>
        <Column Name="mtRate5Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtDefUnit" DataType="System.Int32"/>
        <Column Name="mtDefUnitName" DataType="System.String"/>
        <Column Name="mtDefUnitRate" DataType="System.Double"/>
        <Column Name="mtBarcode1" DataType="System.String"/>
        <Column Name="mtBarcode2" DataType="System.String"/>
        <Column Name="mtBarcode3" DataType="System.String"/>
        <Column Name="mtBarcode4" DataType="System.String"/>
        <Column Name="mtBarcode5" DataType="System.String"/>
        <Column Name="mtColor" DataType="System.String"/>
        <Column Name="mtStatus" DataType="System.String"/>
        <Column Name="mtBrand" DataType="System.String"/>
        <Column Name="mtSize" DataType="System.String"/>
        <Column Name="mtOrigin" DataType="System.String"/>
        <Column Name="mtCompany" DataType="System.String"/>
        <Column Name="mtShasseh" DataType="System.String"/>
        <Column Name="mtLocation" DataType="System.String"/>
        <Column Name="mtProducer" DataType="System.String"/>
        <Column Name="mtDistributor" DataType="System.String"/>
        <Column Name="mtProvenance" DataType="System.String"/>
        <Column Name="mtQuality" DataType="System.String"/>
        <Column Name="mtModel" DataType="System.String"/>
        <Column Name="mtVendor" DataType="System.String"/>
        <Column Name="mtSpec" DataType="System.String"/>
        <Column Name="mtOldCode" DataType="System.String"/>
        <Column Name="mtNewCode" DataType="System.String"/>
        <Column Name="mtType" DataType="System.Int32"/>
        <Column Name="mtExpireFlag" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtSnFlag" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtCollectFlag" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtCollectOneLevel" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtTimePrep" DataType="System.Double"/>
        <Column Name="mtMaxLimit" DataType="System.Double"/>
        <Column Name="mtMinLimit" DataType="System.Double"/>
        <Column Name="mtOrderLimit" DataType="System.Double"/>
        <Column Name="mtLength" DataType="System.Double"/>
        <Column Name="mtWidth" DataType="System.Double"/>
        <Column Name="mtHeight" DataType="System.Double"/>
        <Column Name="mtWeight" DataType="System.Double"/>
        <Column Name="mtQty1" DataType="System.Double"/>
        <Column Name="mtQty2" DataType="System.Double"/>
        <Column Name="mtQty3" DataType="System.Double"/>
        <Column Name="mtQty4" DataType="System.Double"/>
        <Column Name="mtQty5" DataType="System.Double"/>
        <Column Name="mtCurrencyID" DataType="System.Guid"/>
        <Column Name="mtCurrencyVal" DataType="System.Double"/>
        <Column Name="mtLastSellPrice" DataType="System.Double"/>
        <Column Name="mtLastSellPriceDate" DataType="System.DateTime"/>
        <Column Name="mtLastPurchasePrice" DataType="System.Double"/>
        <Column Name="mtLastPurchasePriceDate" DataType="System.DateTime"/>
        <Column Name="mtAvgCostPrice" DataType="System.Double"/>
        <Column Name="mtWhole1" DataType="System.Double"/>
        <Column Name="mtRetail1" DataType="System.Double"/>
        <Column Name="mtExport1" DataType="System.Double"/>
        <Column Name="mtImport1" DataType="System.Double"/>
        <Column Name="mtDealer1" DataType="System.Double"/>
        <Column Name="mtGeneral1" DataType="System.Double"/>
        <Column Name="mtVendor1" DataType="System.Double"/>
        <Column Name="mtEndUser1" DataType="System.Double"/>
        <Column Name="mtWhole2" DataType="System.Double"/>
        <Column Name="mtRetail2" DataType="System.Double"/>
        <Column Name="mtExport2" DataType="System.Double"/>
        <Column Name="mtImport2" DataType="System.Double"/>
        <Column Name="mtDealer2" DataType="System.Double"/>
        <Column Name="mtGeneral2" DataType="System.Double"/>
        <Column Name="mtVendor2" DataType="System.Double"/>
        <Column Name="mtEndUser2" DataType="System.Double"/>
        <Column Name="mtWhole3" DataType="System.Double"/>
        <Column Name="mtRetail3" DataType="System.Double"/>
        <Column Name="mtExport3" DataType="System.Double"/>
        <Column Name="mtImport3" DataType="System.Double"/>
        <Column Name="mtDealer3" DataType="System.Double"/>
        <Column Name="mtGeneral3" DataType="System.Double"/>
        <Column Name="mtVendor3" DataType="System.Double"/>
        <Column Name="mtEndUser3" DataType="System.Double"/>
        <Column Name="mtWhole4" DataType="System.Double"/>
        <Column Name="mtRetail4" DataType="System.Double"/>
        <Column Name="mtExport4" DataType="System.Double"/>
        <Column Name="mtImport4" DataType="System.Double"/>
        <Column Name="mtDealer4" DataType="System.Double"/>
        <Column Name="mtGeneral4" DataType="System.Double"/>
        <Column Name="mtVendor4" DataType="System.Double"/>
        <Column Name="mtEndUser4" DataType="System.Double"/>
        <Column Name="mtWhole5" DataType="System.Double"/>
        <Column Name="mtRetail5" DataType="System.Double"/>
        <Column Name="mtExport5" DataType="System.Double"/>
        <Column Name="mtImport5" DataType="System.Double"/>
        <Column Name="mtDealer5" DataType="System.Double"/>
        <Column Name="mtGeneral5" DataType="System.Double"/>
        <Column Name="mtVendor5" DataType="System.Double"/>
        <Column Name="mtEndUser5" DataType="System.Double"/>
        <Column Name="mtUseFlage" DataType="System.Int32"/>
        <Column Name="mtVAT" DataType="System.Double"/>
        <Column Name="mtSnFlagIn" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtSnFlagOut" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtDimUnit" DataType="System.Int32"/>
        <Column Name="mtBonusQty" DataType="System.Double"/>
        <Column Name="mtBonusTo" DataType="System.Double"/>
        <Column Name="mtClassID" DataType="System.Guid"/>
        <Column Name="mtClassName" DataType="System.String"/>
        <Column Name="mtCriteria" DataType="System.Double"/>
        <Column Name="mtCFVal1" DataType="System.String"/>
        <Column Name="mtCFVal2" DataType="System.String"/>
        <Column Name="mtCFVal3" DataType="System.String"/>
        <Column Name="mtCFVal4" DataType="System.String"/>
        <Column Name="mtCFVal5" DataType="System.String"/>
        <Column Name="mtCFVal6" DataType="System.String"/>
        <Column Name="mtCFVal7" DataType="System.String"/>
        <Column Name="mtCFVal8" DataType="System.String"/>
        <Column Name="mtCFVal9" DataType="System.String"/>
        <Column Name="mtCFVal10" DataType="System.String"/>
        <Column Name="mtCFVal11" DataType="System.String"/>
        <Column Name="mtCFVal12" DataType="System.String"/>
        <Column Name="mtCFVal13" DataType="System.String"/>
        <Column Name="mtCFVal14" DataType="System.String"/>
        <Column Name="mtCFVal15" DataType="System.String"/>
        <Column Name="mtCFVal16" DataType="System.String"/>
        <Column Name="mtCFVal17" DataType="System.String"/>
        <Column Name="mtCFVal18" DataType="System.String"/>
        <Column Name="mtCFVal19" DataType="System.String"/>
        <Column Name="mtCFVal20" DataType="System.String"/>
        <Column Name="mtCFVal21" DataType="System.String"/>
        <Column Name="mtCFVal22" DataType="System.String"/>
        <Column Name="mtCFVal23" DataType="System.String"/>
        <Column Name="mtCFVal24" DataType="System.String"/>
        <Column Name="mtCFVal25" DataType="System.String"/>
        <Column Name="mtCFVal26" DataType="System.String"/>
        <Column Name="mtCFVal27" DataType="System.String"/>
        <Column Name="mtCFVal28" DataType="System.String"/>
        <Column Name="mtCFVal29" DataType="System.String"/>
        <Column Name="mtCFVal30" DataType="System.String"/>
        <Column Name="mtCFVal31" DataType="System.String"/>
        <Column Name="mtCFVal32" DataType="System.String"/>
        <Column Name="mtCFVal33" DataType="System.String"/>
        <Column Name="mtCFVal34" DataType="System.String"/>
        <Column Name="mtCFVal35" DataType="System.String"/>
        <Column Name="mtCFVal36" DataType="System.String"/>
        <Column Name="mtCFVal37" DataType="System.String"/>
        <Column Name="mtCFVal38" DataType="System.String"/>
        <Column Name="mtCFVal39" DataType="System.String"/>
        <Column Name="mtCFVal40" DataType="System.String"/>
        <Column Name="mtCFVal41" DataType="System.String"/>
        <Column Name="mtCFVal42" DataType="System.String"/>
        <Column Name="mtCFVal43" DataType="System.String"/>
        <Column Name="mtCFVal44" DataType="System.String"/>
        <Column Name="mtCFVal45" DataType="System.String"/>
        <Column Name="mtCFVal46" DataType="System.String"/>
        <Column Name="mtCFVal47" DataType="System.String"/>
        <Column Name="mtCFVal48" DataType="System.String"/>
        <Column Name="mtCFVal49" DataType="System.String"/>
        <Column Name="mtCFVal50" DataType="System.String"/>
        <Column Name="mtCFVal51" DataType="System.String"/>
        <Column Name="mtCFVal52" DataType="System.String"/>
        <Column Name="mtCFVal53" DataType="System.String"/>
        <Column Name="mtCFVal54" DataType="System.String"/>
        <Column Name="mtCFVal55" DataType="System.String"/>
        <Column Name="mtCFVal56" DataType="System.String"/>
        <Column Name="mtCFVal57" DataType="System.String"/>
        <Column Name="mtCFVal58" DataType="System.String"/>
        <Column Name="mtCFVal59" DataType="System.String"/>
        <Column Name="mtCFVal60" DataType="System.String"/>
        <Column Name="mtCFVal61" DataType="System.String"/>
        <Column Name="mtCFVal62" DataType="System.String"/>
        <Column Name="mtCFVal63" DataType="System.String"/>
        <Column Name="mtCFVal64" DataType="System.String"/>
        <Column Name="store_Code" DataType="System.String"/>
        <Column Name="store_Name" DataType="System.String"/>
        <Column Name="store_LatinName" DataType="System.String"/>
        <Column Name="costjob_Code" DataType="System.String"/>
        <Column Name="costjob_Name" DataType="System.String"/>
        <Column Name="costjob_LatinName" DataType="System.String"/>
        <Column Name="sellman_Code" DataType="System.String"/>
        <Column Name="sellman_Name" DataType="System.String"/>
        <Column Name="sellman_LatinName" DataType="System.String"/>
        <Column Name="mtPicture" DataType="System.Byte[]" BindableControl="Picture"/>
        <Column Name="flgHasOneUnit" DataType="System.Int32"/>
        <Column Name="biOfferID" DataType="System.Guid"/>
      </TableDataSource>
      <TableDataSource Name="Bill_Disc" DataType="System.Int32" Enabled="true" TableName="Bill_Disc" SelectCommand="exec [dbo].[mnrFrx_BillDisc] '{34A2AE05-D3DE-4321-A9DD-512C60010F25}'">
        <Column Name="diID" DataType="System.Guid"/>
        <Column Name="diBillID" DataType="System.Guid"/>
        <Column Name="diNumber" DataType="System.Double"/>
        <Column Name="diAccID" DataType="System.Guid"/>
        <Column Name="diDisc" DataType="System.Double"/>
        <Column Name="diExtra" DataType="System.Double"/>
        <Column Name="diCurrencyID" DataType="System.Guid"/>
        <Column Name="diCurrencyVal" DataType="System.Double"/>
        <Column Name="diNotes" DataType="System.String"/>
        <Column Name="diVendor" DataType="System.String"/>
        <Column Name="diCostJobID" DataType="System.Guid"/>
        <Column Name="diSalesmanID" DataType="System.Guid"/>
        <Column Name="diContraAccID" DataType="System.Guid"/>
        <Column Name="diClass" DataType="System.String"/>
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Int32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="Code" DataType="System.String"/>
        <Column Name="PartName" DataType="System.String"/>
        <Column Name="PartLatinName" DataType="System.String"/>
        <Column Name="PartRate" DataType="System.Double"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="ISOCode" DataType="System.String"/>
        <Column Name="acID" DataType="System.Guid"/>
        <Column Name="acNumber" DataType="System.Int32"/>
        <Column Name="acName" DataType="System.String"/>
        <Column Name="acLatinName" DataType="System.String"/>
        <Column Name="acCode" DataType="System.String"/>
        <Column Name="acNotes" DataType="System.String"/>
        <Column Name="acParentID" DataType="System.Guid"/>
        <Column Name="acFinalAccID" DataType="System.Guid"/>
        <Column Name="acType" DataType="System.Int32"/>
        <Column Name="acBudgetType" DataType="System.Int32"/>
        <Column Name="acBudget" DataType="System.Double"/>
        <Column Name="acMatchDate" DataType="System.DateTime"/>
        <Column Name="acDebit" DataType="System.Double"/>
        <Column Name="acCredit" DataType="System.Double"/>
        <Column Name="acCurrencyID" DataType="System.Guid"/>
        <Column Name="acCurrencyVal" DataType="System.Double"/>
        <Column Name="acCustID" DataType="System.Guid"/>
        <Column Name="acActivityID" DataType="System.Guid"/>
        <Column Name="acNSons" DataType="System.Int32"/>
        <Column Name="acUseFlage" DataType="System.Int32"/>
        <Column Name="acBalanced" DataType="System.Int32"/>
        <Column Name="acID1" DataType="System.Guid"/>
        <Column Name="acNumber1" DataType="System.Int32"/>
        <Column Name="acName1" DataType="System.String"/>
        <Column Name="acLatinName1" DataType="System.String"/>
        <Column Name="acCode1" DataType="System.String"/>
        <Column Name="acNotes1" DataType="System.String"/>
        <Column Name="acParentID1" DataType="System.Guid"/>
        <Column Name="acFinalAccID1" DataType="System.Guid"/>
        <Column Name="acType1" DataType="System.Int32"/>
        <Column Name="acBudgetType1" DataType="System.Int32"/>
        <Column Name="acBudget1" DataType="System.Double"/>
        <Column Name="acMatchDate1" DataType="System.DateTime"/>
        <Column Name="acDebit1" DataType="System.Double"/>
        <Column Name="acCredit1" DataType="System.Double"/>
        <Column Name="acCurrencyID1" DataType="System.Guid"/>
        <Column Name="acCurrencyVal1" DataType="System.Double"/>
        <Column Name="acCustID1" DataType="System.Guid"/>
        <Column Name="acActivityID1" DataType="System.Guid"/>
        <Column Name="acNSons1" DataType="System.Int32"/>
        <Column Name="acUseFlage1" DataType="System.Int32"/>
        <Column Name="acBalanced1" DataType="System.Int32"/>
        <Column Name="coID" DataType="System.Guid"/>
        <Column Name="coNumber" DataType="System.Int32"/>
        <Column Name="coName" DataType="System.String"/>
        <Column Name="coLatinName" DataType="System.String"/>
        <Column Name="coCode" DataType="System.String"/>
        <Column Name="coNotes" DataType="System.String"/>
        <Column Name="coParentID" DataType="System.Guid"/>
        <Column Name="smID" DataType="System.Guid"/>
        <Column Name="smNumber" DataType="System.Int32"/>
        <Column Name="smName" DataType="System.String"/>
        <Column Name="smLatinName" DataType="System.String"/>
        <Column Name="smCode" DataType="System.String"/>
        <Column Name="smNotes" DataType="System.String"/>
        <Column Name="smParentID" DataType="System.Guid"/>
      </TableDataSource>
      <TableDataSource Name="Bill_SN" DataType="System.Int32" Enabled="true" TableName="Bill_SN" SelectCommand="exec [dbo].[mnrFrx_BillSN] '{34A2AE05-D3DE-4321-A9DD-512C60010F25}'">
        <Column Name="snID" DataType="System.Guid"/>
        <Column Name="snParentID" DataType="System.Guid"/>
        <Column Name="snBillID" DataType="System.Guid"/>
        <Column Name="snNumber" DataType="System.Double"/>
        <Column Name="snMatID" DataType="System.Guid"/>
        <Column Name="snSN" DataType="System.String"/>
        <Column Name="snNotes" DataType="System.String"/>
        <Column Name="mtID" DataType="System.Guid"/>
        <Column Name="mtNumber" DataType="System.Int32"/>
        <Column Name="mtCode" DataType="System.String"/>
        <Column Name="mtName" DataType="System.String"/>
        <Column Name="mtLatinName" DataType="System.String"/>
        <Column Name="mtParentID" DataType="System.Guid"/>
        <Column Name="mtUnit1" DataType="System.String"/>
        <Column Name="mtUnit2" DataType="System.String"/>
        <Column Name="mtUnit2Rate" DataType="System.Double"/>
        <Column Name="mtRate2Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtUnit3" DataType="System.String"/>
        <Column Name="mtUnit3Rate" DataType="System.Double"/>
        <Column Name="mtRate3Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtUnit4" DataType="System.String"/>
        <Column Name="mtUnit4Rate" DataType="System.Double"/>
        <Column Name="mtRate4Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtUnit5" DataType="System.String"/>
        <Column Name="mtUnit5Rate" DataType="System.Double"/>
        <Column Name="mtRate5Fixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtDefUnit" DataType="System.Int32"/>
        <Column Name="mtDefUnitName" DataType="System.String"/>
        <Column Name="mtDefUnitRate" DataType="System.Double"/>
        <Column Name="mtBarcode1" DataType="System.String"/>
        <Column Name="mtBarcode2" DataType="System.String"/>
        <Column Name="mtBarcode3" DataType="System.String"/>
        <Column Name="mtBarcode4" DataType="System.String"/>
        <Column Name="mtBarcode5" DataType="System.String"/>
        <Column Name="mtColor" DataType="System.String"/>
        <Column Name="mtStatus" DataType="System.String"/>
        <Column Name="mtBrand" DataType="System.String"/>
        <Column Name="mtSize" DataType="System.String"/>
        <Column Name="mtOrigin" DataType="System.String"/>
        <Column Name="mtCompany" DataType="System.String"/>
        <Column Name="mtShasseh" DataType="System.String"/>
        <Column Name="mtLocation" DataType="System.String"/>
        <Column Name="mtProducer" DataType="System.String"/>
        <Column Name="mtDistributor" DataType="System.String"/>
        <Column Name="mtProvenance" DataType="System.String"/>
        <Column Name="mtQuality" DataType="System.String"/>
        <Column Name="mtModel" DataType="System.String"/>
        <Column Name="mtVendor" DataType="System.String"/>
        <Column Name="mtSpec" DataType="System.String"/>
        <Column Name="mtOldCode" DataType="System.String"/>
        <Column Name="mtNewCode" DataType="System.String"/>
        <Column Name="mtType" DataType="System.Int32"/>
        <Column Name="mtExpireFlag" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtSnFlag" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtCollectFlag" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtCollectOneLevel" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtTimePrep" DataType="System.Double"/>
        <Column Name="mtMaxLimit" DataType="System.Double"/>
        <Column Name="mtMinLimit" DataType="System.Double"/>
        <Column Name="mtOrderLimit" DataType="System.Double"/>
        <Column Name="mtLength" DataType="System.Double"/>
        <Column Name="mtWidth" DataType="System.Double"/>
        <Column Name="mtHeight" DataType="System.Double"/>
        <Column Name="mtWeight" DataType="System.Double"/>
        <Column Name="mtQty1" DataType="System.Double"/>
        <Column Name="mtQty2" DataType="System.Double"/>
        <Column Name="mtQty3" DataType="System.Double"/>
        <Column Name="mtQty4" DataType="System.Double"/>
        <Column Name="mtQty5" DataType="System.Double"/>
        <Column Name="mtCurrencyID" DataType="System.Guid"/>
        <Column Name="mtCurrencyVal" DataType="System.Double"/>
        <Column Name="mtLastSellPrice" DataType="System.Double"/>
        <Column Name="mtLastSellPriceDate" DataType="System.DateTime"/>
        <Column Name="mtLastPurchasePrice" DataType="System.Double"/>
        <Column Name="mtLastPurchasePriceDate" DataType="System.DateTime"/>
        <Column Name="mtAvgCostPrice" DataType="System.Double"/>
        <Column Name="mtWhole1" DataType="System.Double"/>
        <Column Name="mtRetail1" DataType="System.Double"/>
        <Column Name="mtExport1" DataType="System.Double"/>
        <Column Name="mtImport1" DataType="System.Double"/>
        <Column Name="mtDealer1" DataType="System.Double"/>
        <Column Name="mtGeneral1" DataType="System.Double"/>
        <Column Name="mtVendor1" DataType="System.Double"/>
        <Column Name="mtEndUser1" DataType="System.Double"/>
        <Column Name="mtWhole2" DataType="System.Double"/>
        <Column Name="mtRetail2" DataType="System.Double"/>
        <Column Name="mtExport2" DataType="System.Double"/>
        <Column Name="mtImport2" DataType="System.Double"/>
        <Column Name="mtDealer2" DataType="System.Double"/>
        <Column Name="mtGeneral2" DataType="System.Double"/>
        <Column Name="mtVendor2" DataType="System.Double"/>
        <Column Name="mtEndUser2" DataType="System.Double"/>
        <Column Name="mtWhole3" DataType="System.Double"/>
        <Column Name="mtRetail3" DataType="System.Double"/>
        <Column Name="mtExport3" DataType="System.Double"/>
        <Column Name="mtImport3" DataType="System.Double"/>
        <Column Name="mtDealer3" DataType="System.Double"/>
        <Column Name="mtGeneral3" DataType="System.Double"/>
        <Column Name="mtVendor3" DataType="System.Double"/>
        <Column Name="mtEndUser3" DataType="System.Double"/>
        <Column Name="mtWhole4" DataType="System.Double"/>
        <Column Name="mtRetail4" DataType="System.Double"/>
        <Column Name="mtExport4" DataType="System.Double"/>
        <Column Name="mtImport4" DataType="System.Double"/>
        <Column Name="mtDealer4" DataType="System.Double"/>
        <Column Name="mtGeneral4" DataType="System.Double"/>
        <Column Name="mtVendor4" DataType="System.Double"/>
        <Column Name="mtEndUser4" DataType="System.Double"/>
        <Column Name="mtWhole5" DataType="System.Double"/>
        <Column Name="mtRetail5" DataType="System.Double"/>
        <Column Name="mtExport5" DataType="System.Double"/>
        <Column Name="mtImport5" DataType="System.Double"/>
        <Column Name="mtDealer5" DataType="System.Double"/>
        <Column Name="mtGeneral5" DataType="System.Double"/>
        <Column Name="mtVendor5" DataType="System.Double"/>
        <Column Name="mtEndUser5" DataType="System.Double"/>
        <Column Name="mtUseFlage" DataType="System.Int32"/>
        <Column Name="mtVAT" DataType="System.Double"/>
        <Column Name="mtSnFlagIn" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtSnFlagOut" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="mtDimUnit" DataType="System.Int32"/>
        <Column Name="mtBonusQty" DataType="System.Double"/>
        <Column Name="mtBonusTo" DataType="System.Double"/>
        <Column Name="mtClassID" DataType="System.Guid"/>
        <Column Name="mtClassName" DataType="System.String"/>
        <Column Name="mtCriteria" DataType="System.Double"/>
        <Column Name="mtCFVal1" DataType="System.String"/>
        <Column Name="mtCFVal2" DataType="System.String"/>
        <Column Name="mtCFVal3" DataType="System.String"/>
        <Column Name="mtCFVal4" DataType="System.String"/>
        <Column Name="mtCFVal5" DataType="System.String"/>
        <Column Name="mtCFVal6" DataType="System.String"/>
        <Column Name="mtCFVal7" DataType="System.String"/>
        <Column Name="mtCFVal8" DataType="System.String"/>
        <Column Name="mtCFVal9" DataType="System.String"/>
        <Column Name="mtCFVal10" DataType="System.String"/>
        <Column Name="mtCFVal11" DataType="System.String"/>
        <Column Name="mtCFVal12" DataType="System.String"/>
        <Column Name="mtCFVal13" DataType="System.String"/>
        <Column Name="mtCFVal14" DataType="System.String"/>
        <Column Name="mtCFVal15" DataType="System.String"/>
        <Column Name="mtCFVal16" DataType="System.String"/>
        <Column Name="mtCFVal17" DataType="System.String"/>
        <Column Name="mtCFVal18" DataType="System.String"/>
        <Column Name="mtCFVal19" DataType="System.String"/>
        <Column Name="mtCFVal20" DataType="System.String"/>
        <Column Name="mtCFVal21" DataType="System.String"/>
        <Column Name="mtCFVal22" DataType="System.String"/>
        <Column Name="mtCFVal23" DataType="System.String"/>
        <Column Name="mtCFVal24" DataType="System.String"/>
        <Column Name="mtCFVal25" DataType="System.String"/>
        <Column Name="mtCFVal26" DataType="System.String"/>
        <Column Name="mtCFVal27" DataType="System.String"/>
        <Column Name="mtCFVal28" DataType="System.String"/>
        <Column Name="mtCFVal29" DataType="System.String"/>
        <Column Name="mtCFVal30" DataType="System.String"/>
        <Column Name="mtCFVal31" DataType="System.String"/>
        <Column Name="mtCFVal32" DataType="System.String"/>
        <Column Name="mtCFVal33" DataType="System.String"/>
        <Column Name="mtCFVal34" DataType="System.String"/>
        <Column Name="mtCFVal35" DataType="System.String"/>
        <Column Name="mtCFVal36" DataType="System.String"/>
        <Column Name="mtCFVal37" DataType="System.String"/>
        <Column Name="mtCFVal38" DataType="System.String"/>
        <Column Name="mtCFVal39" DataType="System.String"/>
        <Column Name="mtCFVal40" DataType="System.String"/>
        <Column Name="mtCFVal41" DataType="System.String"/>
        <Column Name="mtCFVal42" DataType="System.String"/>
        <Column Name="mtCFVal43" DataType="System.String"/>
        <Column Name="mtCFVal44" DataType="System.String"/>
        <Column Name="mtCFVal45" DataType="System.String"/>
        <Column Name="mtCFVal46" DataType="System.String"/>
        <Column Name="mtCFVal47" DataType="System.String"/>
        <Column Name="mtCFVal48" DataType="System.String"/>
        <Column Name="mtCFVal49" DataType="System.String"/>
        <Column Name="mtCFVal50" DataType="System.String"/>
        <Column Name="mtCFVal51" DataType="System.String"/>
        <Column Name="mtCFVal52" DataType="System.String"/>
        <Column Name="mtCFVal53" DataType="System.String"/>
        <Column Name="mtCFVal54" DataType="System.String"/>
        <Column Name="mtCFVal55" DataType="System.String"/>
        <Column Name="mtCFVal56" DataType="System.String"/>
        <Column Name="mtCFVal57" DataType="System.String"/>
        <Column Name="mtCFVal58" DataType="System.String"/>
        <Column Name="mtCFVal59" DataType="System.String"/>
        <Column Name="mtCFVal60" DataType="System.String"/>
        <Column Name="mtCFVal61" DataType="System.String"/>
        <Column Name="mtCFVal62" DataType="System.String"/>
        <Column Name="mtCFVal63" DataType="System.String"/>
        <Column Name="mtCFVal64" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="Bill_Pay" DataType="System.Int32" Enabled="true" TableName="Bill_Pay" SelectCommand="exec [dbo].[mnrPrcGetBill_Pay] '{34A2AE05-D3DE-4321-A9DD-512C60010F25}'">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="mnrBillID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="AccID" DataType="System.Guid"/>
        <Column Name="Debit" DataType="System.Double"/>
        <Column Name="Credit" DataType="System.Double"/>
        <Column Name="CurrencyID" DataType="System.Guid"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="Vendor" DataType="System.String"/>
        <Column Name="CostJobID" DataType="System.Guid"/>
        <Column Name="SalesmanID" DataType="System.Guid"/>
        <Column Name="ContraAccID" DataType="System.Guid"/>
        <Column Name="Class" DataType="System.String"/>
        <Column Name="CurrencyVal2" DataType="System.Double"/>
        <Column Name="acCode" DataType="System.String"/>
        <Column Name="acName" DataType="System.String"/>
        <Column Name="cacCode" DataType="System.String"/>
        <Column Name="cacName" DataType="System.String"/>
        <Column Name="coCode" DataType="System.String"/>
        <Column Name="coName" DataType="System.String"/>
        <Column Name="smCode" DataType="System.String"/>
        <Column Name="smName" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="Bill_PayTerm" DataType="System.Int32" Enabled="true" TableName="Bill_PayTerm" SelectCommand="exec [dbo].[mnrPrcGetBill_PayTerm] '{34A2AE05-D3DE-4321-A9DD-512C60010F25}'">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="Val" DataType="System.Double"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="Cnt" DataType="System.Int32"/>
        <Column Name="Notes" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="Table" Alias="PosBill" DataType="System.Int32" Enabled="true" SelectCommand="select distinct b.id,b.Number,b.Date,b.TotalDisc,b.TotalExtra,b.TotalItem,b.Total,b.bTable,b.VAT,b.Bill1ID,b.TotalOfferDisc,                                  &#13;&#10;		     m.Name as MatName,m.LatinName as MatLatinName,b.StationID,&#13;&#10;		     bi.Number,bi.Qty,bi.Price,bi.Unit,bi.iTime,b.TotalTax1,b.TotalTax2,b.TotalTax3,&#13;&#10;		     c.Name AS CustName , c.LatinName AS CustLatinName,bt.Rate1,bt.Rate2,bt.Rate3,&#13;&#10;		     t.parentid , pt.Name as TblName,&#13;&#10;                                     bi.Printed AS Printed,&#13;&#10;                              [dbo].[mnrRound]( 1, 3, 100) as test&#13;&#10;	from Mnrposbill b&#13;&#10;		     inner join mnrPOSBillItem bi on bi.ParentID = b.ID&#13;&#10;                                    &#13;&#10;                                      left join mnrPOSTax bt on bt.StationID =  b.StationID&#13;&#10;		     inner join mnrMaterial m on m.ID =  bi.MatID&#13;&#10;		     left join mnrPOSBillTable t on t.ParentID =  b.ID&#13;&#10;		     left join mnrPOSTable pt on pt.ID = t.TableID&#13;&#10;		     left join Mnracc a on a.ID = b.AccCustID &#13;&#10;		     left join mnrCust c on c.ID = a.CustID			  &#13;&#10;where (b.ID  = @PosBillID Or b.Bill1ID = @BillID) and (deleted=0) &#13;&#10;Order By&#13;&#10; bi.Number asc">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Int32"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="TotalDisc" DataType="System.Double"/>
        <Column Name="TotalExtra" DataType="System.Double"/>
        <Column Name="TotalItem" DataType="System.Double"/>
        <Column Name="Total" DataType="System.Double"/>
        <Column Name="bTable" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="VAT" DataType="System.Double"/>
        <Column Name="Bill1ID" DataType="System.Guid"/>
        <Column Name="TotalOfferDisc" DataType="System.Double"/>
        <Column Name="MatName" DataType="System.String"/>
        <Column Name="MatLatinName" DataType="System.String"/>
        <Column Name="Number1" DataType="System.Int32"/>
        <Column Name="Qty" DataType="System.Double"/>
        <Column Name="Price" DataType="System.Double"/>
        <Column Name="Unit" DataType="System.Int32"/>
        <Column Name="iTime" DataType="System.DateTime"/>
        <Column Name="CustName" DataType="System.String"/>
        <Column Name="CustLatinName" DataType="System.String"/>
        <Column Name="TblName" DataType="System.String"/>
        <Column Name="Printed" DataType="System.Int64"/>
        <Column Name="StationID" DataType="System.Guid"/>
        <Column Name="Rate1" DataType="System.Double"/>
        <Column Name="Rate2" DataType="System.Double"/>
        <Column Name="Rate3" DataType="System.Double"/>
        <Column Name="test" DataType="System.Double"/>
        <Column Name="TotalTax1" DataType="System.Double"/>
        <Column Name="TotalTax2" DataType="System.Double"/>
        <Column Name="TotalTax3" DataType="System.Double"/>
        <CommandParameter Name="PosBillID" DataType="14" Expression="[PosBillId]" DefaultValue="00000000-0000-0000-0000-000000000000"/>
        <CommandParameter Name="BillID" DataType="14" Expression="[BillId1]" DefaultValue="00000000-0000-0000-0000-000000000000"/>
      </TableDataSource>
      <TableDataSource Name="mnrPOSTax" DataType="System.Int32" Enabled="true" TableName="mnrPOSTax">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="StationID" DataType="System.Guid"/>
        <Column Name="Tax1" DataType="System.String"/>
        <Column Name="Acc1ID" DataType="System.Guid"/>
        <Column Name="Rate1" DataType="System.Double"/>
        <Column Name="Tax2" DataType="System.String"/>
        <Column Name="Acc2ID" DataType="System.Guid"/>
        <Column Name="Rate2" DataType="System.Double"/>
        <Column Name="bSplited2" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCalc2After1" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Tax3" DataType="System.String"/>
        <Column Name="Acc3ID" DataType="System.Guid"/>
        <Column Name="Rate3" DataType="System.Double"/>
        <Column Name="bSplited3" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCalc3After1" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCalc3After2" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Round_Type" DataType="System.Int32"/>
        <Column Name="Round_To" DataType="System.Double"/>
        <Column Name="bCalc2OnTax1" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCalc3OnTax1" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCalc3OnTax2" DataType="System.Boolean" BindableControl="CheckBox"/>
      </TableDataSource>
      <TableDataSource Name="Table1" Alias="FileInfo" DataType="System.Int32" Enabled="true" SelectCommand="select &#13;&#10;	c.value  as CompanyName, &#13;&#10;    c1.Value as COMPANY_LNAME ,&#13;&#10;	c2.Value as COMPANY_PNAME ,&#13;&#10;	c3.Value as COMPANY_PLNAME ,&#13;&#10;	c4.Value as COMPANY_ACTIVITY ,&#13;&#10;	c5.Value as COMPANY_COMMERCIALREG ,&#13;&#10;	c6.Value as COMPANY_TAXNUM ,&#13;&#10;	c7.Value as COMPANY_MOBILE ,&#13;&#10;	c8.Value as COMPANY_PHONE ,&#13;&#10;	c9.Value as COMPANY_FINDATE ,&#13;&#10;	c10.Value as COMPANY_EXPORTDATE ,&#13;&#10;	c11.Value as COMPANY_COUNTRY ,&#13;&#10;	c12.Value as COMPANY_CITY ,&#13;&#10;	c13.Value as COMPANY_AREA ,&#13;&#10;	c14.Value as COMPANY_STREET ,&#13;&#10;	c15.Value as COMPANY_BUILDING ,&#13;&#10;	c16.Value as COMPANY_EMAILADDRESS &#13;&#10;from (select  isnull(value , '') as value from mnrFileInfo where Type = 'COMPANY_NAME' ) c , &#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_LNAME')  c1,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_PNAME')  c2,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_PLNAME')  c3,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_ACTIVITY')  c4,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_COMMERCIALREG')  c5,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_TAXNUM')  c6,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_MOBILE')  c7,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_PHONE')  c8,&#13;&#10;	  (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_FINDATE')  c9,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_EXPORTDATE')  c10,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_COUNTRY')  c11,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_CITY')  c12,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_AREA')  c13,&#13;&#10;	  (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_STREET')  c14,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_BUILDING')  c15,&#13;&#10;	 (select  isnull(value, '' ) as value from mnrFileInfo where Type = 'COMPANY_EMAILADDRESS')  c16">
        <Column Name="CompanyName" DataType="System.String"/>
        <Column Name="COMPANY_LNAME" DataType="System.String"/>
        <Column Name="COMPANY_PNAME" DataType="System.String"/>
        <Column Name="COMPANY_PLNAME" DataType="System.String"/>
        <Column Name="COMPANY_ACTIVITY" DataType="System.String"/>
        <Column Name="COMPANY_COMMERCIALREG" DataType="System.String"/>
        <Column Name="COMPANY_TAXNUM" DataType="System.String"/>
        <Column Name="COMPANY_MOBILE" DataType="System.String"/>
        <Column Name="COMPANY_PHONE" DataType="System.String"/>
        <Column Name="COMPANY_FINDATE" DataType="System.String"/>
        <Column Name="COMPANY_EXPORTDATE" DataType="System.String"/>
        <Column Name="COMPANY_COUNTRY" DataType="System.String"/>
        <Column Name="COMPANY_CITY" DataType="System.String"/>
        <Column Name="COMPANY_AREA" DataType="System.String"/>
        <Column Name="COMPANY_STREET" DataType="System.String"/>
        <Column Name="COMPANY_BUILDING" DataType="System.String"/>
        <Column Name="COMPANY_EMAILADDRESS" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="mnrCurrency" DataType="System.Int32" Enabled="true" TableName="mnrCurrency">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Int32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="Code" DataType="System.String"/>
        <Column Name="PartName" DataType="System.String"/>
        <Column Name="PartLatinName" DataType="System.String"/>
        <Column Name="PartRate" DataType="System.Double"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="ISOCode" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="Table2" Alias="Table" DataType="System.Int32" Enabled="true" SelectCommand="SELECT &#13;&#10;   b.ID as ID,&#13;&#10;   STUFF((SELECT '; ' + pt.Name &#13;&#10;          FROM mnrPOSTable pt&#13;&#10;          inner join mnrPOSBillTable t on  pt.ID = t.TableID&#13;&#10;          where b.ID  = t.ParentID&#13;&#10;          FOR XML PATH('')), 1, 1, '') as  TableNo&#13;&#10;FROM &#13;&#10;	Mnrposbill b&#13;&#10;	inner join mnrPOSBillItem bi on bi.parentid = b.id&#13;&#10;where (b.ID  = @PosBillID Or b.Bill1ID = @BID ) and (bi.deleted=0)&#13;&#10;GROUP BY b.ID , b.bill1id&#13;&#10;">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="TableNo" DataType="System.String"/>
        <CommandParameter Name="PosBillID" DataType="14" Expression="[PosBillId]" DefaultValue="00000000-0000-0000-0000-000000000000"/>
        <CommandParameter Name="BID" DataType="14" Expression="[BillId1]" DefaultValue="00000000-0000-0000-0000-000000000000"/>
      </TableDataSource>
      <TableDataSource Name="mnrPOSBillTable" DataType="System.Int32" Enabled="true" TableName="mnrPOSBillTable">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Int32"/>
        <Column Name="TableID" DataType="System.Guid"/>
        <Column Name="PersNum" DataType="System.Int32"/>
        <Column Name="CurrPersNum" DataType="System.Double"/>
      </TableDataSource>
      <TableDataSource Name="mnrBill" DataType="System.Int32" Enabled="true" TableName="mnrBill">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="AccCustID" DataType="System.Guid"/>
        <Column Name="AccCustName" DataType="System.String"/>
        <Column Name="PayType" DataType="System.Int32"/>
        <Column Name="AccAccountID" DataType="System.Guid"/>
        <Column Name="CurrencyID" DataType="System.Guid"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="Total" DataType="System.Double"/>
        <Column Name="TotalItem" DataType="System.Double"/>
        <Column Name="TotalExtra" DataType="System.Double"/>
        <Column Name="TotalDisc" DataType="System.Double"/>
        <Column Name="ItemsExtra" DataType="System.Double"/>
        <Column Name="ItemsDisc" DataType="System.Double"/>
        <Column Name="Profits" DataType="System.Double"/>
        <Column Name="Status" DataType="System.Int32"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="CostJobID" DataType="System.Guid"/>
        <Column Name="BillTypeID" DataType="System.Guid"/>
        <Column Name="BranchID" DataType="System.Guid"/>
        <Column Name="SalesmanID" DataType="System.Guid"/>
        <Column Name="Vendor" DataType="System.String"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="IsPosted" DataType="System.Int32"/>
        <Column Name="VAT" DataType="System.Double"/>
        <Column Name="Class" DataType="System.String"/>
        <Column Name="str1" DataType="System.String"/>
        <Column Name="str2" DataType="System.String"/>
        <Column Name="str3" DataType="System.String"/>
        <Column Name="str4" DataType="System.String"/>
        <Column Name="str5" DataType="System.String"/>
        <Column Name="str6" DataType="System.String"/>
        <Column Name="Date1" DataType="System.DateTime"/>
        <Column Name="Date2" DataType="System.DateTime"/>
        <Column Name="Date3" DataType="System.DateTime"/>
        <Column Name="LinkID" DataType="System.Guid"/>
        <Column Name="TermType" DataType="System.Int32"/>
        <Column Name="TermCnt" DataType="System.Int32"/>
        <Column Name="IsPrinted" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="TimeIn" DataType="System.DateTime"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="ParentType" DataType="System.Int32"/>
        <Column Name="InsuranceID" DataType="System.Guid"/>
        <Column Name="InsurCardNum" DataType="System.String"/>
        <Column Name="InsurExpDate" DataType="System.DateTime"/>
        <Column Name="InsurRate" DataType="System.Double"/>
        <Column Name="InsurMaxVal" DataType="System.Double"/>
        <Column Name="InsurClass" DataType="System.String"/>
        <Column Name="InsurNetwork" DataType="System.String"/>
        <Column Name="InsurNotes" DataType="System.String"/>
        <Column Name="TotalPaid" DataType="System.Double"/>
        <Column Name="bCheck" DataType="System.Int32"/>
        <Column Name="ItemsDisc1" DataType="System.Double"/>
        <Column Name="ItemsDisc2" DataType="System.Double"/>
        <Column Name="EFaturaNumber" DataType="System.String"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Relation Name="mnrCurrency_Bill_Main" ParentDataSource="mnrCurrency" ChildDataSource="Bill_Main" ParentColumns="ID" ChildColumns="BCurrencyID" Enabled="true"/>
    <Relation Name="mnrPOSBillTable_Table" ParentDataSource="mnrPOSBillTable" ChildDataSource="Table" ParentColumns="ParentID" ChildColumns="ID" Enabled="true"/>
    <Relation Name="mnrBill_Bill_Main" ParentDataSource="mnrBill" ChildDataSource="Bill_Main" ParentColumns="ID" ChildColumns="BID" Enabled="true"/>
    <Parameter Name="BillID" DataType="System.String" Expression="&quot;'{34A2AE05-D3DE-4321-A9DD-512C60010F25}'&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{452D9B5F-1CC9-4407-B937-7ACB53469411}&quot;"/>
    <Parameter Name="PosBillId" DataType="System.String" Expression="Substring([BillID],2,36)"/>
    <Parameter Name="BillId1" DataType="System.String" Expression="Substring([BillID],2,36)"/>
    <Parameter Name="BillDate" DataType="System.String" Expression="PadLeft(ToString(Year([Bill_Main.BDate])), 4, '0')+ &quot;-&quot; +PadLeft(ToString(Month([Bill_Main.BDate])), 2, '0') + &quot;-&quot; + PadLeft(ToString(Day([Bill_Main.BDate])), 2, '0') + &quot;T&quot; + PadLeft(ToString(Hour([Bill_Main.BTimeIn])), 2, '0')+ (&quot;:&quot;)+ PadLeft(ToString(Minute([Bill_Main.BTimeIn])), 2, '0')+(&quot;:&quot;) +PadLeft(ToString(Minute([Bill_Main.BTimeIn])), 2, '0') + &quot;Z&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" PaperWidth="80" PaperHeight="210" LeftMargin="2.5" TopMargin="2.5" RightMargin="2.5" Watermark.Font="Arial, 60pt" StartPageEvent="_StartReport" UnlimitedHeight="true">
    <ReportTitleBand Name="ReportTitle1" Width="283.5" Height="160.65" CanGrow="true">
      <TextObject Name="Memo28" Left="46.69" Top="82.14" Width="162.52" Height="18.9" CanGrow="true" Text=" [FileInfo.COMPANY_TAXNUM]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
      <TextObject Name="Text1" Left="94.5" Top="63.8" Width="94.5" Height="18.9" Fill.Color="White" Text="الرقم الضريبي&#13;&#10;" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text2" Left="28.35" Top="9.45" Width="202.2" Height="17.01" CanGrow="true" Text="[FileInfo.CompanyName]" Padding="2, 1, 2, 1" HorzAlign="Center" RightToLeft="true" Font="Times New Roman, 12pt, style=Bold" Clip="false"/>
      <TextObject Name="Memo11" Left="177.65" Top="118.18" Width="100.16" Height="18.9" CanGrow="true" Text="وقت وتاريخ فتح الطلب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
      <TextObject Name="Text7" Left="37.8" Top="141.75" Width="132.3" Height="18.9" Text="[Bill_Main.BTimeIn]" HorzAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text8" Left="37.8" Top="117.4" Width="132.3" Height="18.9" Text="[PosBill.Date]" HorzAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text9" Left="179.55" Top="141.75" Width="100.16" Height="18.9" CanGrow="true" Text="وقت وتاريخ اغلاق الطلب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="164.65" Width="283.5" Height="21.95" CanGrow="true">
      <TextObject Name="Text6" Left="2.9" Top="3.05" Width="75.6" Height="18.9" BeforePrintEvent="Text6_AfterPrint" HorzAlign="Center" Font="Arial, 11pt, style=Bold"/>
    </PageHeaderBand>
    <GroupHeaderBand Name="GroupHeader1" Top="190.6" Width="283.5" Height="107.68" CanGrow="true" CanShrink="true" Condition="[PosBill.ID]" KeepTogether="true">
      <TextObject Name="Memo3" Left="58.79" Top="85" Width="43.47" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="الكمية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo20" Left="103.26" Top="85" Width="49.13" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="الأفرادي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo4" Left="152.98" Top="85" Width="126.61" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text=" المادة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo21" Left="4.64" Top="85" Width="52.91" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="الإجمالي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo14" Left="222.99" Top="54.19" Width="62.37" Height="18.9" CanGrow="true" Text=":البيان" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
      <TextObject Name="Memo18" Left="32.13" Top="53.19" Width="192.1" Height="18.9" CanGrow="true" Text="[Bill_Main.BNotes]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
      <TextObject Name="Memo5" Left="141.51" Top="3.04" Width="80.05" Height="18.9" CanGrow="true" Text="[Bill_Main.BNumber]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 11pt" Clip="false"/>
      <TextObject Name="Memo24" Left="216.54" Top="3.04" Width="62.36" Height="18.9" CanGrow="true" Text="رقم الفاتورة:" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
      <TextObject Name="Memo2" Left="225.48" Top="26.04" Width="51.02" Height="18.9" CanGrow="true" Text=" الطاولة  :" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
      <TextObject Name="Text5" Left="47.25" Top="26.04" Width="79.37" Height="18.9" CanGrow="true" Text="عدد الاشخاص  :" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold" Clip="false"/>
      <TextObject Name="Text4" Left="20.9" Top="26.04" Width="28.35" Height="18.9" Text="[PosBill.mnrPOSBillTable.CurrPersNum]" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo13" Left="174.19" Top="26.04" Width="49.14" Height="18.9" Text="[PosBill.TblName]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <DataBand Name="MasterData2" Top="302.28" Width="283.5" Height="19.9" CanGrow="true" CanShrink="true" DataSource="Table">
        <TextObject Name="PosBillMatName" Left="152.98" Top="1" Width="126.61" Height="18.9" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[PosBill.MatName]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 9pt"/>
        <TextObject Name="Memo6" Left="4.64" Top="1" Width="52.91" Height="18.9" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[[PosBill.Price] *[PosBill.Qty]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 9pt"/>
        <TextObject Name="PosBillPrice" Left="103.26" Top="1" Width="49.13" Height="18.9" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[PosBill.Price]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" WordWrap="false" Font="Times New Roman, 9pt"/>
        <TextObject Name="PosBillQty" Left="58.79" Top="1" Width="43.47" Height="18.9" Border.Lines="All" CanGrow="true" GrowToBottom="true" Text="[PosBill.Qty]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 9pt"/>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="326.18" Width="283.5" KeepWithData="true"/>
    </GroupHeaderBand>
    <ReportSummaryBand Name="ReportSummary1" Top="330.18" Width="283.5" Height="257.75">
      <TextObject Name="Text15" Left="47.55" Top="47.9" Width="94.5" Height="18.9" Text="[PosBill.TotalTax1]" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" WordWrap="false" Font="Arial, 8pt, style=Bold" Trimming="EllipsisCharacter"/>
      <TextObject Name="Memo19" Left="140.5" Top="48.12" Width="120.94" Height="18.9" Fill.Color="White" CanGrow="true" Text="رسم انفاق استهلاكي  %10 " Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo8" Left="140.5" Top="81.02" Width="120.94" Height="18.9" Fill.Color="White" CanGrow="true" Text=" ادارة محلية  %5 من الرسم " Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo15" Left="42.01" Top="81.02" Width="100.04" Height="18.9" Fill.Color="White" CanGrow="true" Text="[PosBill.TotalTax2]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo25" Left="140.5" Top="116.37" Width="120.94" Height="18.9" Fill.Color="White" CanGrow="true" Text=" اعادة اعمار  %10 من الرسم " Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo16" Left="42.01" Top="116.37" Width="100.04" Height="18.9" Fill.Color="White" CanGrow="true" Text="[PosBill.TotalTax3]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo7" Left="140.5" Top="8.13" Width="120.94" Height="18.9" Fill.Color="White" CanGrow="true" Text="المجموع " Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo17" Left="42.01" Top="8.13" Width="100.04" Height="18.9" Fill.Color="White" CanGrow="true" Text="[PosBill.TotalItem]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo26" Left="140.5" Top="148.12" Width="120.94" Height="18.9" Fill.Color="White" CanGrow="true" Text="اجمالي الفاتورة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 9pt, style=Bold"/>
      <TextObject Name="Memo10" Left="68.81" Top="148.12" Width="90.59" Height="18.9" Fill.Color="White" CanGrow="true" Text=" [PosBill.Total]  " Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text10" Left="18.9" Top="148.12" Width="43.34" Height="18.9" Fill.Color="White" CanGrow="true" Text="[Bill_Main.Curr_Code]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo35" Left="107.73" Top="182.74" Width="166.29" Height="58.59" CanGrow="true" GrowToBottom="true" Text="المبلغ المطلوب : [FrxCArbTafkit.tafkit(Abs([Bill_Main.BTotal]/[Bill_Main.BCurrencyVal]),[Bill_Main.Curr_Name],[Bill_Main.Curr_PartName] , 2 , false)]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt, style=Bold"/>
      <BarcodeObject Name="Barcode1" Top="167.85" Width="109.62" Height="89.9" BeforePrintEvent="Barcode1_BeforePrint" AutoSize="false" Text="" ShowText="false" AllowExpressions="true" Barcode="QR Code" Barcode.ErrorCorrection="L" Barcode.Encoding="UTF8" Barcode.QuietZone="true"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="591.93" Width="283.5" Height="31.35" Exportable="false">
      <TextObject Name="Memo31" Left="18.9" Top="1.01" Width="62.36" Height="11.34" CanGrow="true" Text="Printed on:" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold" Clip="false"/>
      <TextObject Name="Memo34" Left="232.45" Top="1.01" Width="79.37" Height="11.34" CanGrow="true" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold" Clip="false"/>
      <TextObject Name="Memo33" Left="147.06" Top="1.01" Width="41.57" Height="11.34" CanGrow="true" Text="Time:" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold" Clip="false"/>
      <TextObject Name="Memo32" Left="84.47" Top="1.01" Width="58.58" Height="11.34" CanGrow="true" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold" Clip="false"/>
      <TextObject Name="Text11" Left="160.1" Top="12.45" Width="122.85" Height="18.9" Text="[FileInfo.COMPANY_CITY]-[FileInfo.COMPANY_AREA]-[FileInfo.COMPANY_STREET]" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold">
        <Formats>
          <GeneralFormat/>
          <GeneralFormat/>
          <GeneralFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Text12" Left="9.45" Top="12.45" Width="122.85" Height="18.9" Text="[FileInfo.COMPANY_MOBILE]-[FileInfo.COMPANY_PHONE]" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold">
        <Formats>
          <GeneralFormat/>
          <GeneralFormat/>
          <GeneralFormat/>
        </Formats>
      </TextObject>
    </PageFooterBand>
  </ReportPage>
</Report>
