﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="10/30/2021 13:17:07" ReportInfo.Modified="10/30/2021 14:00:12" 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 Page1_ManualBuild(object sender, EventArgs e)
    {
      Guid MatID = Guid.Empty  ;                                                     
      int Number = -1 ;
      int counter = 0 ;
      String notes = &quot;&quot;;
      String MatName = &quot;&quot; ;
      String CustName = &quot;&quot;;
        
      DataSourceBase ds = Report.GetDataSource(&quot;PosBill&quot;);
     
      ds.Init();

      Page1.Visible = false;                                                      
      while  (ds.HasMoreRows)// do
      {
        if( ( ((Int32)Report.GetColumnValue(&quot;PosBill.Type&quot;))  == 0) &amp;&amp; (((Int32)Report.GetColumnValue(&quot;PosBill.Number1&quot;)) != Number))
        {
        //showmessage( inttostr(counter) );                                                   
        if(counter &gt; 0 )        
        {                   
          Memo5.Text = CustName ;                   
          Memo6.Text = MatName ;
          Memo11.Text= notes;                      

          Page1.Visible = true;
                              
          MasterData2.Visible = true;                     
          MasterData2.StartNewPage = true;
          Engine.ShowBand(MasterData2);                   
                                                                  
          notes = &quot;&quot;;                                           
        }                     
                 
        MatID   =  ((Guid)Report.GetColumnValue(&quot;PosBill.MatID&quot;)) ;                       
        MatName =  ((String)Report.GetColumnValue(&quot;PosBill.MatName&quot;)) ;        
        CustName=  ((String)Report.GetColumnValue(&quot;PosBill.CustName&quot;)) ;                                                                                                
      }
        else   if(  ((Int32)Report.GetColumnValue(&quot;PosBill.Type&quot;))  == 1)  
        {
                   
        if(notes == &quot;&quot;)
        notes = notes + ((String)Report.GetColumnValue(&quot;PosBill.Notes&quot;)) ;  
        else                         
        notes = notes + &quot; / &quot;  +   ((String)Report.GetColumnValue(&quot;PosBill.Notes&quot;))  ;

                                 
        }
               
          counter++ ;
          Number = ((Int32)Report.GetColumnValue(&quot;PosBill.Number1&quot;)) ;                           
          ds.Next();                                          
        }

      Memo5.Text = CustName ;                   
      Memo6.Text = MatName ;
      Memo11.Text= notes;

      Page1.Visible = true;
             
      MasterData2.StartNewPage = true;
      MasterData2.Visible = true;              
      Engine.ShowBand(MasterData2);
    }
  }
}
/*void Page1OnManualBuild(TfrxComponent Sender)
{
      String MatID ;                                                     
      int Number = -1 ,counter = 0 ;
      String notes = &quot;&quot;;
      String MatName = &quot;&quot; , CustName = &quot;&quot;;
        
      TfrxDataSet DataSet;    
      DataSet = MasterData2.DataSet;
      DataSet.First;

     page1.visible = false;                                                      
    while  (!DataSet.Eof)// do
        {
           if( (&lt;PosBill.&quot;Type&quot;&gt;  == 0) &amp;&amp; (&lt;PosBill.&quot;Number_1&quot;&gt; != Number))
             {
               //showmessage( inttostr(counter) );                                                   
               if(counter &gt; 0 )        
               {                   
                 Memo5.Text = CustName ;                   
                 Memo6.Text = MatName ;
                 Memo11.Text= notes;                      

                 page1.visible = true;
                              
                 MasterData2.visible = true;                     
                 MasterData2.startnewpage = true;
                 Engine.ShowBand(MasterData2);                   
                                                                  
                 notes = &quot;&quot;;                                           
               }                     
                 
               MatID   =  &lt;PosBill.&quot;MatID&quot;&gt;;                       
               MatName =  &lt;PosBill.&quot;MatName&quot;&gt; ;        
               CustName=  &lt;PosBill.&quot;CustName&quot;&gt; ;                                                                                                
             }
             else   if( &lt;PosBill.&quot;Type&quot;&gt;  == 1)  
             {
                   
               if(notes == &quot;&quot;)
                  notes = notes + &lt;PosBill.&quot;Notes&quot;&gt; ;  
               else                         
                  notes = notes + &quot; / &quot;  +    &lt;PosBill.&quot;Notes&quot;&gt; ;

                                 
             }
               
           counter++ ;
           Number = &lt;PosBill.&quot;Number_1&quot;&gt;;                           
           DataSet.Next();                                          
         }

          Memo5.Text = CustName ;                   
          Memo6.Text = MatName ;
          Memo11.Text= notes;

          page1.visible = true;
             
          MasterData2.startnewpage = true;
          MasterData2.visible = true;              
          Engine.ShowBand(MasterData2);
                    
}  
  
{

}
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqM7gJFg/iaLrqMhRfGy5lGqO5IQ7/r0E7/Zm6fduOyQ4Zc5oL2jkQPt29YtGCCTQnzNz6563g9xqR43QpEoDMauCAVyz1R5jh8yymXK4GS6GOfQJvopC4D61Wj3gFATuDTD36iOxH/GgoNru+8+dOnOEzj9Xpwsvu8YnwHOEN2KrphgvheRiRBT660twL0ZHFXhJ/IAOVKAokPQstNQamlN6HRh4u6DatFn58gY0gh63sCDpLsRErnEG5Npd8SditQnrcpeY65HU0doEwDgAB15j9p5yT2gXP0iutzTq2BV+mXHlsnU4RRhnK2Ftg1nL/Zj7gpSEipblk78Xy0U2XKY1pDY82qlkXtzj/+607yJg=">
      <TableDataSource Name="Bill_Main" DataType="System.Int32" Enabled="true" TableName="Bill_Main" SelectCommand="exec [dbo].[mnrFrx_BillMain] '{A16787C5-689B-48d7-8BB9-180D8FDBC86D}'">
        <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"/>
      </TableDataSource>
      <TableDataSource Name="Bill_Details" DataType="System.Int32" Enabled="true" TableName="Bill_Details" SelectCommand="exec [dbo].[mnrFrx_BillDetails] '{A16787C5-689B-48d7-8BB9-180D8FDBC86D}'">
        <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"/>
      </TableDataSource>
      <TableDataSource Name="Bill_Disc" DataType="System.Int32" Enabled="true" TableName="Bill_Disc" SelectCommand="exec [dbo].[mnrFrx_BillDisc] '{A16787C5-689B-48d7-8BB9-180D8FDBC86D}'">
        <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] '{A16787C5-689B-48d7-8BB9-180D8FDBC86D}'">
        <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] '{A16787C5-689B-48d7-8BB9-180D8FDBC86D}'">
        <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] '{A16787C5-689B-48d7-8BB9-180D8FDBC86D}'">
        <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,bi.Type , b.Date,b.TotalDisc,b.TotalExtra,b.TotalItem,b.Total,b.bTable,b.VAT,b.salesmanid,b.Bill1ID,b.TotalOfferDisc,                                  &#13;&#10;		     bi.MatID , m.Name as MatName,m.LatinName as MatLatinName,&#13;&#10;		     bi.Number,bi.Qty,bi.Price,bi.Unit,bi.iTime,Bi.Notes,                    &#13;&#10;		     c.Name AS CustName , c.LatinName AS CustLatinName,&#13;&#10;		     t.parentid  , bi.notes                                   &#13;&#10;	from Mnrposbill b&#13;&#10;		     inner join mnrPOSBillItem bi on bi.ParentID = b.ID&#13;&#10;		     left 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.Bill1ID = @BillID) and (isnull(deleted , 0) =0)-- and bi.type = 0                                    &#13;&#10;Order By&#13;&#10; bi.Number asc">
        <Column Name="id" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="Type" DataType="System.Int32"/>
        <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="salesmanid" DataType="System.Guid"/>
        <Column Name="Bill1ID" DataType="System.Guid"/>
        <Column Name="TotalOfferDisc" DataType="System.Double"/>
        <Column Name="MatID" DataType="System.Guid"/>
        <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="Notes" DataType="System.String"/>
        <Column Name="CustName" DataType="System.String"/>
        <Column Name="CustLatinName" DataType="System.String"/>
        <Column Name="parentid" DataType="System.Guid"/>
        <Column Name="notes1" DataType="System.String"/>
        <CommandParameter Name="BillID" DataType="14" Expression="Substring( [BillID] , 2 , 36)" DefaultValue="00000000-0000-0000-0000-000000000000"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="BillID" DataType="System.String" Expression="&quot;'{A16787C5-689B-48d7-8BB9-180D8FDBC86D}'&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{59605D75-DA7B-48d5-A48A-5A79CC0F4A37}&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" PaperWidth="78" PaperHeight="55" LeftMargin="2.5" TopMargin="2.5" RightMargin="2.5" BottomMargin="2.5" Watermark.Font="Arial, 60pt" ManualBuildEvent="Page1_ManualBuild">
    <DataBand Name="MasterData2" Width="275.94" Height="136.06" CanGrow="true" CanShrink="true" DataSource="Table">
      <TextObject Name="Memo18" Left="34.02" Top="7.56" Width="211.65" Height="18.9" Text="صيدلية لؤلؤ الطبية" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo1" Left="190.74" Top="33.57" Width="79.37" Height="22.68" Text=" :اسم المريض" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="-3.78" Top="33.57" Width="193.21" Height="22.68" GrowToBottom="true" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo6" Left="7.56" Top="64.25" Width="193.21" Height="22.68" GrowToBottom="true" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo9" Left="205.86" Top="64.25" Width="64.25" Height="22.68" Text=" :اسم الدواء" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo10" Left="205.86" Top="96.05" Width="64.25" Height="22.68" Text=" :الوصفة" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo11" Left="7.56" Top="96.05" Width="193.21" Height="34.02" GrowToBottom="true" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
    </DataBand>
  </ReportPage>
</Report>
