{
  "TableName":"",
  "LogicFncName":"FlowPageControlDisplay",
	"QueryType":"SQL",
	"QuerySQL":"if((select COUNT(1) from CIV_GD_WX_CASELIST a inner join CIV_GD_WX_SB_FEEDBACK b on a.CaseNo=b.caseno  and a.ID=[$ID$])> 0)
   begin 
   select '管网维修' as InvalidGroups,* from CIV_GD_WX_CASELIST a inner join CIV_GD_WX_SB_FEEDBACK b on a.CaseNo=b.caseno  and a.ID=[$ID$]
   end
   else if ((select COUNT(1) from CIV_GD_WX_CASELIST a inner join CIV_GD_WX_GW_FEEDBACK b on a.CaseNo=b.caseno  and a.ID=[$ID$])> 0)
   begin
      select '水表维修' as InvalidGroups,* from CIV_GD_WX_CASELIST a inner join CIV_GD_WX_GW_FEEDBACK b on a.CaseNo=b.caseno  and a.ID=[$ID$]
   end 
   else 
   begin 
     select '管网维修,水表维修' as InvalidGroups,* from CIV_GD_WX_CASELIST a where a.ID=[$ID$]
   end",
    "Groups":[
      {
            "Name":"水表维修",
            "Icon":"./images/formLegendIcon/工程基础信息.png",
            "Url":"",
            "Controls":[
                {
                    "IsRead":"0",
                    "DisplayName":"ID",
                    "Type":"保留字",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"ID"
                },
                {
                    "IsRead":"",
                    "DisplayName":"CaseNo",
                    "Type":"标签",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"CaseNo"
                },
                {
                    "IsRead":"",
                    "DisplayName":"到场时间",
                    "Type":"时间",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"到场时间"
                },
                {
                    "IsRead":"",
                    "DisplayName":"结束时间",
                    "Type":"时间",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"结束时间"
                },
                {
                    "IsRead":"",
                    "DisplayName":"原表底数",
                    "Type":"浮点型",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"原表底数"
                },
                {
                    "IsRead":"",
                    "DisplayName":"水表口径",
                    "Type":"浮点型",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"水表口径"
                },
                {
                    "IsRead":"",
                    "DisplayName":"新表底数",
                    "Type":"浮点型",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"新表底数"
                },
                {
                    "IsRead":"",
                    "DisplayName":"新表编号",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"新表编号"
                },
                {
                    "IsRead":"",
                    "DisplayName":"封铅号",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"封铅号"
                },
                {
                    "IsRead":"",
                    "DisplayName":"材质类型",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"材质类型"
                },
                {
                    "IsRead":"",
                    "DisplayName":"损坏部位",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"损坏部位"
                },
                {
                    "IsRead":"",
                    "DisplayName":"主管规格",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"主管规格"
                },
                {
                    "IsRead":"",
                    "DisplayName":"具体原因",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"具体原因"
                },
                {
                    "IsRead":"",
                    "DisplayName":"维修方法",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"维修方法"
                },
                {
                    "IsRead":"",
                    "DisplayName":"处理结果",
                    "Type":"图片",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"处理结果"
                }
            ]
        },{
            "Name":"管网维修",
            "Icon":"./images/formLegendIcon/工程基础信息.png",
            "Url":"",
            "Controls":[
                {
                    "IsRead":"0",
                    "DisplayName":"ID",
                    "Type":"保留字",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"ID"
                },
                {
                    "IsRead":"",
                    "DisplayName":"CaseNo",
                    "Type":"标签",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"CaseNo"
                },
                {
                    "IsRead":"",
                    "DisplayName":"到场时间",
                    "Type":"时间",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"到场时间"
                },
                {
                    "IsRead":"",
                    "DisplayName":"结束时间",
                    "Type":"时间",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"结束时间"
                },
                {
                    "IsRead":"",
                    "DisplayName":"具体原因",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"具体原因"
                },
                {
                    "IsRead":"",
                    "DisplayName":"维修方法",
                    "Type":"短文本",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"维修方法"
                },
                {
                    "IsRead":"",
                    "DisplayName":"维修前",
                    "Type":"图片",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"维修前"
                },
                {
                    "IsRead":"",
                    "DisplayName":"维修中",
                    "Type":"图片",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"维修中"
                },
                {
                    "IsRead":"",
                    "DisplayName":"维修后",
                    "Type":"图片",
                    "DefaultValues":"",
                    "Value":"",
                    "UploadArgs":"",
                    "DisplayColSpan":2,
                    "Validate":"",
                    "Name":"维修后"
                }
            ]
        }
    ],
    "TopURL":"",
    "MiddleURL":"",
    "BottomURL":"",
    "BottomButtons":[
        {
            "ID":"",
            "Name":"移交",
            "Type":"移交"
        },
        {
            "ID":"",
            "Name":"关闭",
            "Type":"关闭"
        }
    ]
}