【视图】GroupList 统计视图配置

语言

【视图】GroupList 统计视图配置

By 江翠 | xml | 视图

1. 在当前ListXMl里配置按钮
FileName:自己配置的统计的 XML 名称
其他参数配置参考下方样例

2.配置统计XML
DataSource 节点：View="GroupList"、AuthWith：权限跟随、Title
配置统计和明细的宽度：GroupShow节点的 ViewClass、Show节点的 ViewClass
配置GroupLIst：参考下方样例
配置GroupShow 节点：分组列
配置显示列： **必须项：将会被Group配置的KeyField值替换
配置Show节点：明细列

3.配置数据源
根据当前样例的配置，数据源xml 需配置节点 ClientTop10、ClientRegister 来获取统计信息
还需配置节点 SelectObjectFilter 用以取详细信息具体配置方法参考下方样例代码

1. <Function ViewClass="col-5">
      <Operation Title="统计" Head="T" Name="tourl" Icon="fa-share-alt-square" Controller="BaseTable/GroupList/"  FileName="CSR/CSR_ClientGroup" />
    </Function>
      
 2.
<?xml version="1.0" encoding="utf-8" ?>
<Root>
  <DataSource Folder="CSR" FileName="CSR_ClientGroup" PrimaryKey="ClientID" Title="客户统计"  View="GroupList"  ViewClass="col-sm-4" AuthWith="CSR/CSR_Client">
    <Function>
      <Operation Title="返回" Head="T"  Name="tourl" Icon="fa-reply" Controller="BaseTable/List" FileName="CSR/CSR_Client" />
      <Operation Title="刷新"  Head="T"  Name="tourl" Icon="fa-refresh" Controller="BaseTable/GroupList" FileName="CSR/CSR_ClientGroup" />
      <Operation Title="查看"   Name="listview" Icon="fa-file-o" Controller="BaseTable/ShowView/" FileName="PJT/PJT_Project" Parameter="ProjectID" />
    </Function>
    <GroupList>
      <Group KeyField="ClientShort" TitleName="客户 Top 10"  Operation="ClientTop10"  Condition=" a.ClientShort='{0}'" />
      <Group KeyField="Dates" TitleName="客户 今年新增"  Operation="ClientRegister" Condition=" FORMAT(a.RegisterDate,'yyyy-MM')='{0}'"/>
    </GroupList>
    <GroupShow  ViewClass="col-sm-4">
      <Head TitleName="" ColumnName="Group"/>
      <Head TitleName="项目" ColumnName="Items" ViewClass="col-8" />
      <Head TitleName="金额" ColumnName="Amounts" ViewClass="col-8"  Format="N0" />
    </GroupShow>
    <Show Title ="Comments"  ViewClass="col-sm-8">
      <Head TitleName="NO." ColumnName="|Index|"  ViewClass="col-5" />
      <Head TitleName="ID" ColumnName="ProjectID" IsShow="F" Flag="T"/>
      <Head TitleName="类别" ColumnName="ProjectCate" ViewClass="col-5"/>
      <Head TitleName="项目编号" ColumnName="ProjectCode" ViewClass="col-8"/>
      <Head TitleName="项目名称" ColumnName="ProjectName" />
      <Head TitleName="客户" ColumnName="ClientShort" />
      <Head TitleName="商务" ColumnName="ProjectUser"  ViewClass="col-7"/>
      <Head TitleName="金额" ColumnName="Amount"  ViewClass="col-7 wz6" Format="N0" />
      <Head TitleName="计划交货" ColumnName="Delivery"  ViewClass="col-8" Format="d"/>
    </Show>
    
    <SearchField>
      <Column SearchName="ProjectCate" Condition="and PropertyCate='ProjectCate'"  DataSource="PropertyList"/>
    </SearchField>
  </DataSource>
</Root>

3. 配置数据源
<?xml version="1.0" encoding="utf-8" ?>
<Entity>
  <Sqls>
    <Sql Name="ClientTop10">
      <String>
        <![CDATA[
        Select top 10 a.ClientShort,count(1) as Items,Sum(b.Amount) as Amounts  from CSR_Client a,PJT_Project b where a.ClientID=b.ClientID and b.Enable = 1
            Group by a.ClientShort order by Amounts desc
			]]>
      </String>
      <Param Name="@FilterQuery" Column="FilterQuery" />
    </Sql>

</Sqls>
</Entity>

代码片段 统计 分组

语言

【视图】GroupList 统计视图配置

代码片段统计分组