【视图】CommGroup

语言

【视图】CommGroup

By 江翠 | xml | 视图

ListXML
1.配置视图为CommonGroup
2.配置Tab数据源 Operation="SearchByStatus" ControlType="tab"
3.配置DetailDataSource
4. 可配分页（配分页必配ListOrder）

SQL
1.配置Tab数据源 SearchByStatus
2.配置搜索数据源 SelectObjectFilter 注意@FilterQuery 的放置位置
3.配置Paging 注意筛选条件

1. ListXML
  <?xml version="1.0" encoding="utf-8" ?>
<Root>
  <DataSource Folder="PRD" FileName="PRD_DesignImplement" View="CommonGroup"  PrimaryKey="ProjectProductID"   Title="设计执行">
    <Search>
      <Subject TitleName="状态" ColumnName="Status" DataType="System.String"  Operation="SearchByStatus" ControlType="tab" Value="4" />
      <Subject TitleName="产品编号" ColumnName="ProjectProductCode" DataType="System.String"/>
    </Search>
    <Show ViewClass="col-sm-5">
      <Head TitleName="产品编号" ColumnName="ProjectProductCode"/>
      <Head TitleName="产品名称" ColumnName="ProjectProductName"/>
      <Head TitleName="当前任务" ColumnName="TaskName" ViewClass="col-8"/>
    </Show>
    <Paging/>
    <ListOrder>
      <Column ColumnName="ProjectProductCode" Order="DESC"></Column>
    </ListOrder>
  </DataSource>
  <DetailDataSource Folder="PRD" FileName="PRD_DesignImplementDetail" Title="计划" PrimaryKey="PlanDetailID" Foreignkey="ProjectProductID"  Icon="fa-home" ViewClass="col-sm-6">
  </DetailDataSource>
</Root>
2.SqlXML
<?xml version="1.0" encoding="utf-8" ?>
<Entity>
  <Sqls>
    <Sql Name="SelectObjectFilter">
      <String>
        <![CDATA[
		  	  select distinct b.ProjectProductID,b.ProjectProductCode,b.ProjectProductName,b.TaskName
		      from (select * from PRD_PlanDetail where Enable = 1 and TaskPhase = '设计' And (Status=4 or Status = 5 or Status = 6) 
          and ResourcesUserID = @CurrUserID  @FilterQuery) as a
          left join PJT_ProjectProduct as b on a.ProjectProductID = b.ProjectProductID Where 1=1 
          ]]>
      </String>
      <Param Name="@FilterQuery" Column="FilterQuery" />
      <Param Name="@CurrUserID" Column="CurrUserID" />
    </Sql>
      
    <Sql Name="SearchByStatus">
      <String>
        <![CDATA[
          select a.Number,a.Status ID,b.StatusName TabName from (select Status,count(distinct ProjectProductID) number 
              From PRD_PlanDetail Where Enable = 1 and TaskPhase = '设计' and  (Status=4 or Status = 5 or Status = 6)  and ResourcesUserID = @CurrUserID Group By Status) a
              left join (select * from  PAR_Status where StatusCate='PlanAllot') b  on a.Status=b.StatusValue
          ]]>
      </String>
      <Param Name="@FilterQuery" Column="FilterQuery" />
      <Param Name="@CurrUserID" Column="CurrUserID" />
    </Sql>
      
    <Sql Name="Paging">
      <String>
        <![CDATA[
        select Count(1) from (
			    SELECT 1 as number
          from (select * from PRD_PlanDetail where Enable = 1 and TaskPhase = '设计' 
          And (Status=4 or Status = 5 or Status = 6) and ResourcesUserID = @CurrUserID  @FilterQuery) as a
          left join PJT_ProjectProduct as b on a.ProjectProductID = b.ProjectProductID Where 1=1 
          group by b.ProjectProductID,b.ProjectProductCode,b.ProjectProductName ) a
			  ]]>
      </String>
      <Param Name="@FilterQuery" Column="FilterQuery" />
      <Param Name="@CurrUserID" Column="CurrUserID" />
    </Sql>
  </Sqls>
</Entity>

代码片段 视图 CommGroup

语言

【视图】CommGroup

代码片段视图 CommGroup