<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="12/16/2016 09:45:09" ReportInfo.Modified="07/27/2021 16:57:22" ReportInfo.CreatorVersion="2016.1.0.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 System.Data.SqlClient;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
    public   int x=1; 
    private void Table2_ManualBuild(object sender, EventArgs e)
    {
      DataSourceBase rowData = Report.GetDataSource(&quot;sys_salesProducts&quot;);
      rowData.Init();
      
  
      Table2.PrintRow(0);
      Table2.PrintColumns();
      Table2.PrintRow(1);
      Table2.PrintColumns();
      x=1; 
      while (rowData.HasMoreRows)
      {
        Table2.PrintRow(2);
        Table2.PrintColumns();
        rowData.Next();
        x++;
      }
      Table2.PrintRow(3);
      Table2.PrintColumns();
      
     
    }

 

    private void ReportTitle1_AfterData(object sender, EventArgs e)
    {
      
    }
    
    

    private void Cell129_AfterData(object sender, EventArgs e)
    {

      string[] dataSts =  Cell129.Text.Split(new Char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
      if(dataSts.Length == 27)
      {
        Cell135.Text = dataSts[0].Split('：')[1];  //度数R
        Cell140.Text = dataSts[1].Split('：')[1];  //度数L
  
        Cell138.Text = dataSts[2].Split('：')[1]; //瞳距R
        Cell143.Text = dataSts[3].Split('：')[1];  //瞳距L
  
        Cell155.Text = dataSts[4].Split('：')[1];  //瞳高R
        Cell162.Text = dataSts[5].Split('：')[1];  //瞳高L
  
        Cell136.Text = dataSts[6].Split('：')[1];  //散光R
        Cell141.Text = dataSts[7].Split('：')[1];  //散光L
  
        Cell137.Text = dataSts[8].Split('：')[1];  //轴位R
        Cell142.Text = dataSts[9].Split('：')[1]; //轴位L
  
        Cell156.Text = dataSts[10].Split('：')[1]; //矫正R
        Cell163.Text = dataSts[11].Split('：')[1];  //矫正L
  
        Cell157.Text = dataSts[12].Split('：')[1];  //裸视R
        Cell164.Text = dataSts[13].Split('：')[1];  //裸视L
  
        Cell158.Text = dataSts[14].Split('：')[1];  //隐形R
        Cell165.Text = dataSts[15].Split('：')[1];  //隐形L
  
        Cell159.Text = dataSts[16].Split('：')[1];  //原光R
        Cell166.Text = dataSts[17].Split('：')[1];   //原光L
  
        Cell160.Text = dataSts[18].Split('：')[1];  //ADDR
        Cell167.Text = dataSts[19].Split('：')[1];  //ADDL
  
        Cell161.Text = dataSts[20].Split('：')[1];  //棱镜R
        Cell168.Text = dataSts[21].Split('：')[1];  //棱镜L
  
        Cell182.Text = dataSts[22].Split('：')[1];  //基底R
        Cell183.Text = dataSts[23].Split('：')[1];  //基底L
  
        Cell171.Text = dataSts[24].Split('：')[1];  //总瞳距
        Cell174.Text = dataSts[25].Split('：')[1];  //主视眼
        Cell178.Text = dataSts[26].Split('：')[1];  //验光备注
      }
      Cell129.Text = &quot;&quot;;
    } 
  }
}
</ScriptText>
  <Dictionary>
    <MsSqlDataConnection ConnectionString="rijcmlqLrsFCkq0pbnlrNLcvFVkCVz36UnLxRHvgKV5wrWz7Lvg1IFOQ9D9BrCqMoSCZSFsH4ojIy4nLXCN88PM+DUOuI0OzfGIQHMJPhtVMNqtlSG3BfpPatnrQVr91HI8qUh3dD8AYiq4uvxnq/FIfd6+dCSDzAP/z2sIl0qQlP6Ec5s=">
      <TableDataSource Name="sys_sales" DataType="System.Int32" Enabled="true" TableName="sys_sales" SelectCommand="SELECT S.id, S.moduleId, S.toid, S.sales_id, S.sales_time, S.sales_remark, S.sales_ChanPinZongJia, S.sales_JiaGeDiaoJian, S.sales_ShiShouJiaGe, S.sales_KeHuMingCheng, S.sales_KeHuBianHao, S.status, S.sales_WeiKuan, S.sales_payTime, S.sales_FuKuanFangShi, S.sales_JieDanYuan, S.sales_LiRun, S.sales_KeHuDengJi, S.sales_YanGuangShi, S.sales_PeiJingShi, S.sales_LiPin, S.sales_ZheKou,S.sales_JiFenDuiHuan,S.sales_ZheKouYouHui&#13;&#10;FROM &quot;sys_sales&quot; S where S.id =  @Parameter">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="moduleId" DataType="System.Int32"/>
        <Column Name="toid" DataType="System.Int32"/>
        <Column Name="sales_id" DataType="System.String"/>
        <Column Name="sales_time" DataType="System.DateTime"/>
        <Column Name="sales_remark" DataType="System.String"/>
        <Column Name="sales_ChanPinZongJia" DataType="System.Decimal"/>
        <Column Name="sales_JiaGeDiaoJian" DataType="System.Decimal"/>
        <Column Name="sales_ShiShouJiaGe" DataType="System.Decimal"/>
        <Column Name="sales_KeHuMingCheng" DataType="System.String"/>
        <Column Name="sales_KeHuBianHao" DataType="System.String"/>
        <Column Name="status" DataType="System.String"/>
        <Column Name="sales_WeiKuan" DataType="System.Decimal"/>
        <Column Name="sales_payTime" DataType="System.DateTime"/>
        <Column Name="sales_FuKuanFangShi" DataType="System.String"/>
        <Column Name="sales_JieDanYuan" DataType="System.String"/>
        <Column Name="sales_LiRun" DataType="System.Decimal"/>
        <Column Name="sales_KeHuDengJi" DataType="System.String"/>
        <Column Name="sales_YanGuangShi" DataType="System.String"/>
        <Column Name="sales_PeiJingShi" DataType="System.String"/>
        <Column Name="sales_LiPin" DataType="System.Decimal"/>
        <Column Name="sales_ZheKou" DataType="System.String"/>
        <Column Name="sales_JiFenDuiHuan" DataType="System.Decimal"/>
        <Column Name="sales_ZheKouYouHui" DataType="System.Decimal"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="[Parameter]"/>
      </TableDataSource>
      <TableDataSource Name="Table9" Alias="sys_user" DataType="System.Int32" Enabled="true" SelectCommand="SELECT [information_MingCheng]&#13;&#10;      ,[title]&#13;&#10;      ,[information_LianXiDianHua]&#13;&#10;      ,[information_LianXiDiZhi]&#13;&#10;      ,[companyName],[information_FuKuanFangShi]&#13;&#10;  FROM [sys_information]">
        <Column Name="information_MingCheng" DataType="System.String"/>
        <Column Name="title" DataType="System.String"/>
        <Column Name="information_LianXiDianHua" DataType="System.String"/>
        <Column Name="information_LianXiDiZhi" DataType="System.String"/>
        <Column Name="companyName" DataType="System.String"/>
        <Column Name="information_FuKuanFangShi" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="Table10" Alias="sys_optometry" DataType="System.Int32" Enabled="true" SelectCommand="SELECT S.id, S.moduleId, S.toid, S.Optometry_YanGuangShi, S.Optometry_YanGuangDan, S.Optometry_YanGuangShiJian, s1.id, s1.sales_KeHuBianHao, s2.id, s2.Clients_Number&#13;&#10;FROM &quot;sys_optometry&quot; S, &quot;sys_sales&quot; s1, &quot;sys_clients&quot; s2 where s1.id =  @Parameter and s2.Clients_Number = s1.sales_KeHuBianHao and s.toid = s2.id order by s.id desc">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="moduleId" DataType="System.Int32"/>
        <Column Name="toid" DataType="System.Int32"/>
        <Column Name="Optometry_YanGuangShi" DataType="System.String"/>
        <Column Name="Optometry_YanGuangDan" DataType="System.String"/>
        <Column Name="Optometry_YanGuangShiJian" DataType="System.DateTime"/>
        <Column Name="id1" DataType="System.Int32"/>
        <Column Name="sales_KeHuBianHao" DataType="System.String"/>
        <Column Name="id2" DataType="System.Int32"/>
        <Column Name="Clients_Number" DataType="System.String"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="[Parameter]"/>
      </TableDataSource>
      <TableDataSource Name="Table" Alias="sys_salesProducts" DataType="System.Int32" Enabled="true" SelectCommand="SELECT S.id, S.moduleId, S.toid, S.prod_id, S.salesproducts_ChanPinMingCheng, S.salesproducts_DanJia, S.salesproducts_ShuLiang, S.salesproducts_ZongJia, S.salesproducts_FenLei, S.salesproducts_BeiZhu, S.salesproducts_KaiGongShiJian, S.salesproducts_WanGongShiJian, S.salesproducts_ShiGongRenYuan, S.salesproducts_PinPai, S.salesproducts_GuiGe, S.sales_TianJiaShiJian, S.type, S.checkList_PanYingPanKui, S.sales_LingQuRen, S.sales_LingQuShiJian, S.purchaseList_ShouJia, S.salesproducts_LiPin,S.sales_DuiYingDingDanHao,S.salesproducts_JiFen  ,(select top 1 products_ShengChanPiHao from sys_products where prod_id=S.prod_id) as	  products_ShengChanPiHao	,&#13;&#10;			(select top 1 products_ShengChengRiQi from sys_products where prod_id=S.prod_id) as	  products_ShengChengRiQi	,&#13;&#10;			(select top 1 products_ZhuCeHao from sys_products where prod_id=S.prod_id) as	  products_ZhuCeHao ,&#13;&#10;			(select top 1 products_BaoZhiQi from sys_products where prod_id=S.prod_id) as	  BaoZhiQi ,&#13;&#10;			(select top 1 products_HeGeZhengMing from sys_products where prod_id=S.prod_id) as	  products_HeGeZhengMing ,&#13;&#10;			(select top 1 products_ShengChanChangJia from sys_products where prod_id=S.prod_id) as	  products_ShengChanChangJia  ,&#13;&#10;			(select top 1 products_ShengChanXuKeZheng from sys_products where prod_id=S.prod_id) as	  products_ShengChanXuKeZheng &#13;&#10;FROM &quot;sys_salesProducts&quot; S where  moduleId = 21 and type = 1 and s.toid = @Parameter&#13;&#10;">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="moduleId" DataType="System.Int32"/>
        <Column Name="toid" DataType="System.Int32"/>
        <Column Name="prod_id" DataType="System.String"/>
        <Column Name="salesproducts_ChanPinMingCheng" DataType="System.String"/>
        <Column Name="salesproducts_DanJia" DataType="System.Decimal"/>
        <Column Name="salesproducts_ShuLiang" DataType="System.Int32"/>
        <Column Name="salesproducts_ZongJia" DataType="System.Decimal"/>
        <Column Name="salesproducts_FenLei" DataType="System.String"/>
        <Column Name="salesproducts_BeiZhu" DataType="System.String"/>
        <Column Name="salesproducts_KaiGongShiJian" DataType="System.String"/>
        <Column Name="salesproducts_WanGongShiJian" DataType="System.String"/>
        <Column Name="salesproducts_ShiGongRenYuan" DataType="System.String"/>
        <Column Name="salesproducts_PinPai" DataType="System.String"/>
        <Column Name="salesproducts_GuiGe" DataType="System.String"/>
        <Column Name="sales_TianJiaShiJian" DataType="System.DateTime"/>
        <Column Name="type" DataType="System.Int32"/>
        <Column Name="checkList_PanYingPanKui" DataType="System.String"/>
        <Column Name="sales_LingQuRen" DataType="System.String"/>
        <Column Name="sales_LingQuShiJian" DataType="System.String"/>
        <Column Name="purchaseList_ShouJia" DataType="System.Decimal"/>
        <Column Name="salesproducts_LiPin" DataType="System.String"/>
        <Column Name="sales_DuiYingDingDanHao" DataType="System.String"/>
        <Column Name="salesproducts_JiFen" DataType="System.Double"/>
        <Column Name="products_ShengChanPiHao" DataType="System.String"/>
        <Column Name="products_ShengChengRiQi" DataType="System.DateTime"/>
        <Column Name="products_ZhuCeHao" DataType="System.String"/>
        <Column Name="BaoZhiQi" DataType="System.DateTime"/>
        <Column Name="products_HeGeZhengMing" DataType="System.String"/>
        <Column Name="products_ShengChanChangJia" DataType="System.String"/>
        <Column Name="products_ShengChanXuKeZheng" DataType="System.Int32"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="[Parameter]"/>
      </TableDataSource>
      <TableDataSource Name="Table3" Alias="sys_department" DataType="System.Int32" Enabled="true" SelectCommand="select Department_BuMenZhuGuan,Department_BuMenDianHua,Department_BuMenQuanCheng,Department_BuMenYingWenQuanCheng,Department_title,Department_BuMenBianHao,content from sys_department where Department_title = (select FenDian from sys_sales where id = @Parameter)">
        <Column Name="Department_BuMenZhuGuan" DataType="System.String"/>
        <Column Name="Department_BuMenDianHua" DataType="System.String"/>
        <Column Name="Department_BuMenQuanCheng" DataType="System.String"/>
        <Column Name="Department_BuMenYingWenQuanCheng" DataType="System.String"/>
        <Column Name="Department_title" DataType="System.String"/>
        <Column Name="Department_BuMenBianHao" DataType="System.String"/>
        <Column Name="content" DataType="System.String"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="[Parameter]"/>
      </TableDataSource>
      <TableDataSource Name="Table5" Alias="sys_clients" DataType="System.Int32" Enabled="true" SelectCommand="SELECT S.id, S.moduleId, S.toid, S.Clients_Number, S.Clients_Name, S.Clients_address1, S.Clients_telephone, S.Clients_addtime, S.Clients_SheBeiLeiXing, S.State, S.Clients_KeHuDengJi, S.Clients_SuoZaiDanWei, S.Clients_CheZhuXinXi, S.Clients_QiTaXinXi, S.Card_KaHao, S.Card_MiMa, S.Card_JinE, S.Card_BeiZhu, S.Card_KaiKaShiJian, S.clients_JieShaoRen, S.clients_ShengChuRiQi, S.openid, S.clients_SuoShuYuanGong, S.clients_QQ, S.clients_WeiXin, S.clients_YouXiang, S.clients_JiFen, S.clients_DengJi, S.clients_XingBie, S.clients_FuChaRiQi, S.clients_YinXingZhouQiTiXing, S.clients_TiXing, S.FenDian&#13;&#10;FROM &quot;sys_clients&quot; S where Clients_Number = (select sales_KeHuBianHao from sys_sales where id = @Parameter)">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="moduleId" DataType="System.Int32"/>
        <Column Name="toid" DataType="System.Int32"/>
        <Column Name="Clients_Number" DataType="System.String"/>
        <Column Name="Clients_Name" DataType="System.String"/>
        <Column Name="Clients_address1" DataType="System.String"/>
        <Column Name="Clients_telephone" DataType="System.String"/>
        <Column Name="Clients_addtime" DataType="System.DateTime"/>
        <Column Name="Clients_SheBeiLeiXing" DataType="System.String"/>
        <Column Name="State" DataType="System.String"/>
        <Column Name="Clients_KeHuDengJi" DataType="System.String"/>
        <Column Name="Clients_SuoZaiDanWei" DataType="System.String"/>
        <Column Name="Clients_CheZhuXinXi" DataType="System.String"/>
        <Column Name="Clients_QiTaXinXi" DataType="System.String"/>
        <Column Name="Card_KaHao" DataType="System.String"/>
        <Column Name="Card_MiMa" DataType="System.String"/>
        <Column Name="Card_JinE" DataType="System.Int32"/>
        <Column Name="Card_BeiZhu" DataType="System.String"/>
        <Column Name="Card_KaiKaShiJian" DataType="System.DateTime"/>
        <Column Name="clients_JieShaoRen" DataType="System.String"/>
        <Column Name="clients_ShengChuRiQi" DataType="System.DateTime"/>
        <Column Name="openid" DataType="System.String"/>
        <Column Name="clients_SuoShuYuanGong" DataType="System.String"/>
        <Column Name="clients_QQ" DataType="System.String"/>
        <Column Name="clients_WeiXin" DataType="System.String"/>
        <Column Name="clients_YouXiang" DataType="System.String"/>
        <Column Name="clients_JiFen" DataType="System.Int32"/>
        <Column Name="clients_DengJi" DataType="System.String"/>
        <Column Name="clients_XingBie" DataType="System.String"/>
        <Column Name="clients_FuChaRiQi" DataType="System.DateTime"/>
        <Column Name="clients_YinXingZhouQiTiXing" DataType="System.DateTime"/>
        <Column Name="clients_TiXing" DataType="System.String"/>
        <Column Name="FenDian" DataType="System.String"/>
        <CommandParameter Name="Parameter" DataType="22" Expression="[Parameter]"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="Parameter" DataType="System.String"/>
  </Dictionary>
  <ReportPage Name="Page1" PaperHeight="140" TopMargin="5" BottomMargin="2">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="151.2" CanGrow="true" AfterDataEvent="ReportTitle1_AfterData">
      <TextObject Name="Text1" Left="9.45" Top="-6.45" Width="689.85" Height="28.35" Text="[sys_department.Department_title]-销售单" HorzAlign="Center" VertAlign="Center" Font="微软雅黑, 12pt, style=Bold"/>
      <TextObject Name="Txt_totalPages" Left="-9450" Top="-9468.9" Width="37.8" Height="18.9" Text="第[Page#]页 共[TotalPages#]页 打印日期：[Date]" HorzAlign="Right" VertAlign="Center"/>
      <TextObject Name="Text40" Left="-9450" Top="-9450" Width="708.75" Height="18.9" Text="1、是否有托修人支付费用更换的旧配件：□ 旧配件已确认，并由托修方收回 □ 旧配件已确认，托修方声明放弃 □ 无旧配件" HorzAlign="Center" Font="宋体, 9pt"/>
      <TableObject Name="Table1" Left="9.45" Top="75.6" Width="689.06" Height="75.6" Border.Lines="All" Border.Style="Dot" Border.Width="0.5">
        <TableColumn Name="Column44" Width="42.59"/>
        <TableColumn Name="Column45" Width="52.04"/>
        <TableColumn Name="Column46" Width="52.04"/>
        <TableColumn Name="Column47" Width="52.04"/>
        <TableColumn Name="Column48" Width="52.04"/>
        <TableColumn Name="Column53" Width="55.97"/>
        <TableColumn Name="Column54" Width="55.97"/>
        <TableColumn Name="Column55" Width="55.97"/>
        <TableColumn Name="Column56" Width="55.97"/>
        <TableColumn Name="Column57" Width="55.97"/>
        <TableColumn Name="Column58" Width="55.97"/>
        <TableColumn Name="Column59" Width="55.97"/>
        <TableColumn Name="Column60" Width="46.52"/>
        <TableRow Name="Row25">
          <TableCell Name="Cell129" Border.Lines="All" Border.Style="Dot" AfterDataEvent="Cell129_AfterData" Text="[sys_optometry.Optometry_YanGuangDan]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell130" Border.Lines="All" Border.Style="Dot" Text="度数" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell131" Border.Lines="All" Border.Style="Dot" Text="散光" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell132" Border.Lines="All" Border.Style="Dot" Text="轴位" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell133" Border.Lines="All" Border.Style="Dot" Text="瞳距" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell148" Border.Lines="All" Border.Style="Dot" Text="瞳高" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell149" Border.Lines="All" Border.Style="Dot" Text="矫正" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell150" Border.Lines="All" Border.Style="Dot" Text="裸视" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell151" Border.Lines="All" Border.Style="Dot" Text="隐形" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell152" Border.Lines="All" Border.Style="Dot" Text="原光" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell153" Border.Lines="All" Border.Style="Dot" Text="ADD" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell154" Border.Lines="All" Border.Style="Dot" Text="棱镜" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell181" Border.Lines="All" Border.Style="Dot" Text="基底" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
        <TableRow Name="Row26">
          <TableCell Name="Cell134" Border.Lines="All" Border.Style="Dot" Text="右眼R" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell135" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell136" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell137" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell138" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell155" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell156" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell157" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell158" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell159" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt" TabWidth="55"/>
          <TableCell Name="Cell160" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell161" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell182" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
        <TableRow Name="Row27">
          <TableCell Name="Cell139" Border.Lines="All" Border.Style="Dot" Text="左眼L" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell140" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell141" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell142" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell143" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell162" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell163" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell164" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell165" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell166" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell167" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell168" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell183" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
        <TableRow Name="Row28" MinHeight="18.9" AutoSize="true">
          <TableCell Name="Cell169" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell170" Border.Lines="All" Border.Style="Dot" Text="总瞳距" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell171" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 9pt" ColSpan="2"/>
          <TableCell Name="Cell172" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell173" Border.Lines="All" Border.Style="Dot" Text="主视力" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell174" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 9pt" ColSpan="2"/>
          <TableCell Name="Cell175" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell176" Border.Lines="All" Border.Style="Dot" Text="验光备注" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt" ColSpan="2"/>
          <TableCell Name="Cell177" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell178" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Bottom" Font="宋体, 9pt" ColSpan="4"/>
          <TableCell Name="Cell179" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell180" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell184" Border.Lines="All" Border.Style="Dot" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
      </TableObject>
      <TableObject Name="Table11" Left="9.45" Top="18.9" Width="687.53" Height="56.7">
        <TableColumn Name="Column71" Width="57.87"/>
        <TableColumn Name="Column72" Width="180.72"/>
        <TableColumn Name="Column73" Width="48.42"/>
        <TableColumn Name="Column74" Width="171.27"/>
        <TableColumn Name="Column75" Width="76.77"/>
        <TableColumn Name="Column78" Width="152.48"/>
        <TableRow Name="Row32" MinHeight="18.9" AutoSize="true">
          <TableCell Name="Cell221" Border.Lines="All" Border.Style="Dot" Text="姓名：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell222" Border.Lines="All" Border.Style="Dot" Text="[sys_sales.sales_KeHuMingCheng]" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell223" Border.Lines="All" Border.Style="Dot" Text="卡号：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell224" Border.Lines="All" Border.Style="Dot" Text="[sys_clients.Card_KaHao]" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell225" Border.Lines="All" Border.Style="Dot" Text="时间：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell253" Border.Lines="All" Border.Style="Dot" Text="[sys_sales.sales_time]" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
        <TableRow Name="Row33" MinHeight="18.9" AutoSize="true">
          <TableCell Name="Cell226" Border.Lines="All" Border.Style="Dot" Text="电话：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell227" Border.Lines="All" Border.Style="Dot" Text="[sys_clients.Clients_telephone]" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell228" Border.Lines="All" Border.Style="Dot" Text="余额：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell229" Border.Lines="All" Border.Style="Dot" Text="[sys_clients.Card_JinE]" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell230" Border.Lines="All" Border.Style="Dot" Text="销售单号：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell254" Border.Lines="All" Border.Style="Dot" Text="[sys_sales.sales_id]" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
        <TableRow Name="Row34">
          <TableCell Name="Cell255" Border.Lines="All" Border.Style="Dot" Text="备注：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell256" Border.Lines="All" Border.Style="Dot" Text="[sys_sales.sales_remark]" VertAlign="Center" Font="宋体, 9pt" ColSpan="5"/>
          <TableCell Name="Cell257" Border.Lines="All" Border.Style="Dot" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell258" Border.Lines="All" Border.Style="Dot" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell259" Border.Lines="All" Border.Style="Dot" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell260" Border.Lines="All" Border.Style="Dot" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
      </TableObject>
    </ReportTitleBand>
    <DataBand Name="Data1" Top="155.05" Width="718.2" Height="75.6" CanGrow="true">
      <TableObject Name="Table2" Left="9.45" Width="690.92" Height="75.6" Border.Lines="All" ManualBuildEvent="Table2_ManualBuild">
        <TableColumn Name="Column6" Width="61.83"/>
        <TableColumn Name="Column7" Width="401.48"/>
        <TableColumn Name="Column69" Width="0"/>
        <TableColumn Name="Column10" Width="73.17"/>
        <TableColumn Name="Column11" Width="69.18"/>
        <TableColumn Name="Column61" Width="85.26"/>
        <TableRow Name="Row9">
          <TableCell Name="Cell44" Text="销售清单" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt, style=Bold" ColSpan="6"/>
          <TableCell Name="Cell45" Font="宋体, 9pt"/>
          <TableCell Name="Cell213" Font="宋体, 9pt"/>
          <TableCell Name="Cell48" Font="宋体, 9pt"/>
          <TableCell Name="Cell49" Font="宋体, 9pt"/>
          <TableCell Name="Cell185" Font="宋体, 9pt"/>
        </TableRow>
        <TableRow Name="Row6">
          <TableCell Name="Cell26" Border.Lines="All" Text="序号" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt, style=Bold"/>
          <TableCell Name="Cell27" Border.Lines="All" Text="商品名称" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt, style=Bold"/>
          <TableCell Name="Cell214" Border.Lines="All" Text="规格" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt, style=Bold"/>
          <TableCell Name="Cell30" Border.Lines="All" Text="单价" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt, style=Bold"/>
          <TableCell Name="Cell41" Border.Lines="All" Text="数量" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt, style=Bold"/>
          <TableCell Name="Cell186" Border.Lines="All" Text="总价" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt, style=Bold"/>
        </TableRow>
        <TableRow Name="Row7" MinHeight="18.9" AutoSize="true">
          <TableCell Name="Cell31" Text="[x]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell32" Text="[sys_salesProducts.salesproducts_ChanPinMingCheng] " VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell215" Text="[sys_salesProducts.salesproducts_GuiGe]" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell35" Text="[sys_salesProducts.salesproducts_DanJia]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell42" Text="[sys_salesProducts.salesproducts_ShuLiang]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell187" Text="[sys_salesProducts.salesproducts_ZongJia]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
        <TableRow Name="Row8">
          <TableCell Name="Cell36" Border.Lines="All" Text="合计:" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt" ColSpan="5"/>
          <TableCell Name="Cell37" Border.Lines="All" HorzAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell216" Font="宋体, 9pt"/>
          <TableCell Name="Cell40" Border.Lines="All" HorzAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell43" Border.Lines="All" HorzAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell188" Border.Lines="All" Text="[Sum(Cell187)]" VertAlign="Center" Font="宋体, 9pt, style=Bold"/>
        </TableRow>
      </TableObject>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" Top="234.49" Width="718.2" Height="66.15" CanGrow="true">
      <TableObject Name="Table7" Left="9.45" Width="690.13" Height="18.9" Border.Lines="All">
        <TableColumn Name="Column35" Width="47.06"/>
        <TableColumn Name="Column36" Width="65.96"/>
        <TableColumn Name="Column37" Width="47.06"/>
        <TableColumn Name="Column38" Width="75.6"/>
        <TableColumn Name="Column39" Width="1"/>
        <TableColumn Name="Column40" Width="65.96"/>
        <TableColumn Name="Column49" Width="55.19"/>
        <TableColumn Name="Column50" Width="64.57"/>
        <TableColumn Name="Column51" Width="45.67"/>
        <TableColumn Name="Column52" Width="64.57"/>
        <TableColumn Name="Column62" Width="55.12"/>
        <TableColumn Name="Column63" Width="102.37"/>
        <TableRow Name="Row24" MinHeight="18.9" AutoSize="true">
          <TableCell Name="Cell117" Border.Lines="All" Text="抹零" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell118" Border.Lines="All" Text="[sys_sales.sales_JiaGeDiaoJian]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt" ColSpan="2"/>
          <TableCell Name="Cell119" Border.Lines="All" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell120" Border.Lines="All" Text="折扣" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt" ColSpan="2"/>
          <TableCell Name="Cell121" Border.Lines="All" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell122" Border.Lines="All" Text="[sys_sales.sales_ZheKou]  折扣[sys_sales.sales_ZheKouYouHui]元 " HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt" ColSpan="2"/>
          <TableCell Name="Cell144" Border.Lines="All" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell145" Border.Lines="All" Text="欠款" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell146" Border.Lines="All" Text="[sys_sales.sales_WeiKuan]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt" ColSpan="2"/>
          <TableCell Name="Cell147" Border.Lines="All" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell189" Border.Lines="All" Text="实收" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
          <TableCell Name="Cell190" Border.Lines="All" Text="[sys_sales.sales_ShiShouJiaGe]" HorzAlign="Center" VertAlign="Center" Font="宋体, 11pt, style=Bold"/>
        </TableRow>
      </TableObject>
      <TableObject Name="Table4" Left="9.45" Top="20.9" Width="689.07" Height="22.05">
        <TableColumn Name="Column24" Width="94.06"/>
        <TableColumn Name="Column25" Width="137.96"/>
        <TableColumn Name="Column26" Width="99.32"/>
        <TableColumn Name="Column41" Width="131.83"/>
        <TableColumn Name="Column42" Width="94.05"/>
        <TableColumn Name="Column43" Width="131.85"/>
        <TableRow Name="Row15" MaxHeight="689.09" Height="22.05">
          <TableCell Name="Cell80" Text="销售员：" HorzAlign="Right" VertAlign="Center" Font="宋体, 8pt"/>
          <TableCell Name="Cell81" Text="[sys_sales.sales_JieDanYuan]" VertAlign="Center" Font="宋体, 8pt"/>
          <TableCell Name="Cell82" Text="验光师：" HorzAlign="Right" VertAlign="Center" Font="宋体, 8pt"/>
          <TableCell Name="Cell126" Text="[sys_sales.sales_YanGuangShi]" VertAlign="Center" Font="宋体, 8pt"/>
          <TableCell Name="Cell127" Text="客户签字：" HorzAlign="Right" VertAlign="Center" Font="宋体, 10pt"/>
          <TableCell Name="Cell128" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        </TableRow>
      </TableObject>
      <TableObject Name="Table8" Left="9.45" Top="47.25" Width="689.85" Height="18.9">
        <TableColumn Name="Column64" Width="96.39"/>
        <TableColumn Name="Column65" Width="96.39"/>
        <TableColumn Name="Column66" Width="96.39"/>
        <TableColumn Name="Column67" Width="96.39"/>
        <TableColumn Name="Column68" Width="96.39"/>
        <TableColumn Name="Column79" Width="207.9"/>
        <TableRow Name="Row30" MinHeight="18.9" AutoSize="true">
          <TableCell Name="Cell203" Text="地址：[sys_department.content]" VertAlign="Center" Font="宋体, 9pt" ColSpan="5"/>
          <TableCell Name="Cell204" Font="宋体, 9pt"/>
          <TableCell Name="Cell205" Font="宋体, 9pt"/>
          <TableCell Name="Cell206" Font="宋体, 9pt"/>
          <TableCell Name="Cell207" Font="宋体, 9pt"/>
          <TableCell Name="Cell261" Text="电话：[sys_department.Department_BuMenDianHua]" Font="宋体, 9pt"/>
        </TableRow>
      </TableObject>
    </ReportSummaryBand>
  </ReportPage>
</Report>
