【视图】GroupForm

语言

【视图】GroupForm

By 江翠 | xml | 视图

ListXML
1.配置视图为 GroupForm
2.配置Tab数据源 Operation="GroupByCode" ControlType="tab"
3.配置EditXML

SQL
1.配置Tab数据源 GroupByCode
2.配置搜索数据源 SelectObjectFilter 注意@FilterQuery 的放置位置

1.ListXML
<?xml version="1.0" encoding="utf-8"?>
<Root>
  <DataSource Folder="PUR" FileName="PUR_MaterialNeed"  PrimaryKey="MaterialNeedID" View="GroupForm" Title="物料需求">
    <Search>
      <Subject TitleName="产品编号" ColumnName="ProjectProductID" DataType="System.String" ControlType="Tab" Operation="GroupByCode" />
      <Subject TitleName="物料类型" ColumnName="MaterialCate" DataType="System.String" ControlType="Select"  />
    </Search>
    <Function>
      <Operation Title="新增" Name="add" Icon="fa-plus" Controller="BaseTable/ModalEdit/"    />
      <Operation Title="查看" Name="tourl" Icon="fa-file-text-o"  Controller="BaseTable/Edit/"    />
    </Function>
    <Show>
      <Head TitleName="产品编号" ColumnName="ProjectProductCode" />
      <Head TitleName="物料名称" ColumnName="MaterialName" />
      <Head TitleName="物料类型" ColumnName="MaterialCate" />
      <Head TitleName="物料型号" ColumnName="MaterialModel" />
      <Head TitleName="图号" ColumnName="PartDrawingNo" />
      <Head TitleName="详情" ColumnName="Remark" />
      <Head TitleName="长" ColumnName="Length" />
      <Head TitleName="宽" ColumnName="Width" />
      <Head TitleName="高" ColumnName="Height" />
      <Head TitleName="数量" ColumnName="Quantity"/>
      <Head TitleName="单位" ColumnName="Unit"/>
      <Head TitleName="价格" ColumnName="Price"/>
    </Show>
  </DataSource>
</Root>

2.SQLXML
<?xml version="1.0" encoding="utf-8" ?>
<Entity>
  <Sqls>
  
    
    <Sql Name="SelectObject">
      <String>
        <![CDATA[
          SELECT  '' SupplyID,0 Status
	]]>
      </String>
    </Sql>

<Sql Name="DeleteObject">
      <String>
        <![CDATA[
		UPDATE FNC_Payment SET Enable=0,ModifyTime = getdate()  WHERE PaymentID=@PaymentID;
	]]>
      </String>
      <Param Name="@PaymentID" Column="PaymentID" />
    </Sql>
  </Sqls>
</Entity>

代码片段 list

语言

【视图】GroupForm