<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
  <DataSources>
    <DataSource Name="ZyacPatrolConnectionString1">
      <rd:DataSourceID>941625b1-9d0f-43f0-bde8-5ac2a5463a5d</rd:DataSourceID>
      <ConnectionProperties>
        <DataProvider>SQL</DataProvider>
        <ConnectString>Data Source=(local);Initial Catalog=ZyacPatrol;Persist Security Info=True;User ID=sa;Password=111111</ConnectString>
      </ConnectionProperties>
    </DataSource>
  </DataSources>
  <InteractiveHeight>11in</InteractiveHeight>
  <rd:DrawGrid>true</rd:DrawGrid>
  <InteractiveWidth>8.5in</InteractiveWidth>
  <rd:GridSpacing>0.07cm</rd:GridSpacing>
  <rd:SnapToGrid>true</rd:SnapToGrid>
  <RightMargin>0.3cm</RightMargin>
  <LeftMargin>1cm</LeftMargin>
  <PageHeader>
    <PrintOnFirstPage>true</PrintOnFirstPage>
    <ReportItems>
      <Textbox Name="textbox4">
        <rd:DefaultName>textbox4</rd:DefaultName>
        <Style>
          <FontFamily>宋体</FontFamily>
          <FontSize>20pt</FontSize>
          <TextAlign>Center</TextAlign>
          <VerticalAlign>Middle</VerticalAlign>
          <PaddingLeft>2pt</PaddingLeft>
          <PaddingRight>2pt</PaddingRight>
          <PaddingTop>2pt</PaddingTop>
          <PaddingBottom>2pt</PaddingBottom>
        </Style>
        <CanGrow>true</CanGrow>
        <Value>巡检汇总表</Value>
      </Textbox>
    </ReportItems>
    <Height>1cm</Height>
    <PrintOnLastPage>true</PrintOnLastPage>
  </PageHeader>
  <BottomMargin>0.5cm</BottomMargin>
  <rd:ReportID>5b0e46fa-5526-40bf-b196-2d862bf69a34</rd:ReportID>
  <PageWidth>29.7cm</PageWidth>
  <DataSets>
    <DataSet Name="Attendance_Attendance">
      <Fields>
        <Field Name="FromTime">
          <DataField>FromTime</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="PDate">
          <DataField>PDate</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="SpotID">
          <DataField>SpotID</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="InspectorID">
          <DataField>InspectorID</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="State">
          <DataField>State</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="IsAgent">
          <DataField>IsAgent</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="Inspector">
          <DataField>Inspector</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="FingerUser">
          <DataField>FingerUser</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="UserName">
          <DataField>UserName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="PlanID">
          <DataField>PlanID</DataField>
          <rd:TypeName>System.Decimal</rd:TypeName>
        </Field>
        <Field Name="PTime">
          <DataField>PTime</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>ZyacPatrolConnectionString1</DataSourceName>
        <CommandText>SELECT FromTime, PDate, SpotID, InspectorID, State, IsAgent, Inspector, FingerUser, UserName, PlanID, PTime FROM dbo.Attendance</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>
      <rd:DataSetInfo>
        <rd:DataSetName>Attendance</rd:DataSetName>
        <rd:TableName>Attendance</rd:TableName>
        <rd:TableAdapterName>AttendanceTableAdapter</rd:TableAdapterName>
        <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
        <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
      </rd:DataSetInfo>
    </DataSet>
  </DataSets>
  <Width>28cm</Width>
  <Body>
    <ColumnSpacing>0cm</ColumnSpacing>
    <ReportItems>
      <Matrix Name="matrix1">
        <MatrixColumns>
          <MatrixColumn>
            <Width>0.91cm</Width>
          </MatrixColumn>
          <MatrixColumn>
            <Width>0.91cm</Width>
          </MatrixColumn>
        </MatrixColumns>
        <DataSetName>Attendance_Attendance</DataSetName>
        <RowGroupings>
          <RowGrouping>
            <Width>2.52cm</Width>
            <DynamicRows>
              <Grouping Name="matrix1_PDate">
                <GroupExpressions>
                  <GroupExpression>=Fields!PDate.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="PDate">
                  <rd:DefaultName>PDate</rd:DefaultName>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontFamily>宋体</FontFamily>
                    <FontSize>9pt</FontSize>
                    <TextAlign>Center</TextAlign>
                    <VerticalAlign>Middle</VerticalAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <Value>=FormatDateTime(Fields!PDate.Value, DateFormat.LongDate)</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
          </RowGrouping>
          <RowGrouping>
            <Width>1.85015cm</Width>
            <DynamicRows>
              <Grouping Name="matrix1_UserName">
                <GroupExpressions>
                  <GroupExpression>=Fields!UserName.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="UserName">
                  <rd:DefaultName>UserName</rd:DefaultName>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontFamily>宋体</FontFamily>
                    <FontSize>9pt</FontSize>
                    <TextAlign>Center</TextAlign>
                    <VerticalAlign>Middle</VerticalAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <Value>=Fields!UserName.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicRows>
          </RowGrouping>
        </RowGroupings>
        <ColumnGroupings>
          <ColumnGrouping>
            <Height>0.42cm</Height>
            <DynamicColumns>
              <Grouping Name="matrix1_ColumnGroup1">
                <GroupExpressions>
                  <GroupExpression>=Fields!PTime.Value</GroupExpression>
                </GroupExpressions>
              </Grouping>
              <ReportItems>
                <Textbox Name="PTime_1">
                  <rd:DefaultName>PTime_1</rd:DefaultName>
                  <Style>
                    <BorderStyle>
                      <Default>Solid</Default>
                    </BorderStyle>
                    <FontFamily>宋体</FontFamily>
                    <FontSize>9pt</FontSize>
                    <TextAlign>Center</TextAlign>
                    <VerticalAlign>Middle</VerticalAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!PTime.Value</Value>
                </Textbox>
              </ReportItems>
            </DynamicColumns>
          </ColumnGrouping>
          <ColumnGrouping>
            <Height>0.56cm</Height>
            <StaticColumns>
              <StaticColumn>
                <ReportItems>
                  <Textbox Name="textbox2">
                    <rd:DefaultName>textbox2</rd:DefaultName>
                    <Style>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <FontFamily>宋体</FontFamily>
                      <FontSize>9pt</FontSize>
                      <TextAlign>Center</TextAlign>
                      <VerticalAlign>Middle</VerticalAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <Value>状态</Value>
                  </Textbox>
                </ReportItems>
              </StaticColumn>
              <StaticColumn>
                <ReportItems>
                  <Textbox Name="textbox3">
                    <rd:DefaultName>textbox3</rd:DefaultName>
                    <Style>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <FontFamily>宋体</FontFamily>
                      <FontSize>9pt</FontSize>
                      <TextAlign>Center</TextAlign>
                      <VerticalAlign>Middle</VerticalAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <Value>代检</Value>
                  </Textbox>
                </ReportItems>
              </StaticColumn>
            </StaticColumns>
          </ColumnGrouping>
        </ColumnGroupings>
        <Width>6.19015cm</Width>
        <Corner>
          <ReportItems>
            <Textbox Name="textbox1">
              <rd:DefaultName>textbox1</rd:DefaultName>
              <Style>
                <BorderStyle>
                  <Default>Solid</Default>
                </BorderStyle>
                <FontFamily>宋体</FontFamily>
                <PaddingLeft>2pt</PaddingLeft>
                <PaddingRight>2pt</PaddingRight>
                <PaddingTop>2pt</PaddingTop>
                <PaddingBottom>2pt</PaddingBottom>
              </Style>
              <CanGrow>true</CanGrow>
              <Value />
            </Textbox>
          </ReportItems>
        </Corner>
        <Style>
          <BorderStyle>
            <Default>Solid</Default>
          </BorderStyle>
          <FontFamily>宋体</FontFamily>
        </Style>
        <MatrixRows>
          <MatrixRow>
            <Height>0.56cm</Height>
            <MatrixCells>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="State">
                    <rd:DefaultName>State</rd:DefaultName>
                    <Style>
                      <Color>=IIf(Max(Fields!State.Value)=nothing,"Black",
switch(Max(Fields!State.value)=0, "Black",
Max(Fields!State.value)=1, "Green",
Max(Fields!State.Value)=2,"Blue",
Max(Fields!State.Value)=3,"Red"))</Color>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <FontFamily>宋体</FontFamily>
                      <FontSize>9pt</FontSize>
                      <TextAlign>Center</TextAlign>
                      <VerticalAlign>Middle</VerticalAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <Value>=IIf(Max(Fields!State.Value)=nothing,"-",
switch(Max(Fields!State.value)=0, "-",
Max(Fields!State.value)=1, "合格",
Max(Fields!State.Value)=2,"误点",
Max(Fields!State.Value)=3,"漏检"))</Value>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
              <MatrixCell>
                <ReportItems>
                  <Textbox Name="IsAgent">
                    <rd:DefaultName>IsAgent</rd:DefaultName>
                    <Style>
                      <Color>=IIf(Max(Fields!State.Value)=nothing,"Black",
switch(Max(Fields!State.value)=0, "Black",
Max(Fields!State.value)=1, "Green",
Max(Fields!State.Value)=2,"Blue",
Max(Fields!State.Value)=3,"Red"))</Color>
                      <BorderStyle>
                        <Default>Solid</Default>
                      </BorderStyle>
                      <FontFamily>宋体</FontFamily>
                      <FontSize>9pt</FontSize>
                      <TextAlign>Center</TextAlign>
                      <VerticalAlign>Middle</VerticalAlign>
                      <PaddingLeft>2pt</PaddingLeft>
                      <PaddingRight>2pt</PaddingRight>
                      <PaddingTop>2pt</PaddingTop>
                      <PaddingBottom>2pt</PaddingBottom>
                    </Style>
                    <Value>=iif(Max(Fields!IsAgent.Value)=0,"","代检")</Value>
                  </Textbox>
                </ReportItems>
              </MatrixCell>
            </MatrixCells>
          </MatrixRow>
        </MatrixRows>
        <Height>1.54cm</Height>
      </Matrix>
    </ReportItems>
    <Height>20.5cm</Height>
  </Body>
  <Language>zh-CN</Language>
  <TopMargin>1cm</TopMargin>
  <PageHeight>21cm</PageHeight>
</Report>