{ "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": "", "DisplayName": "caseno", "Type": "保留字", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_HOTLINEEVENT", "Name": "CaseNo" }, { "IsRead": "", "DisplayName": "客户编号", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_HOTLINEEVENT", "Name": "客户编号" }, { "IsRead": "", "DisplayName": "联系电话", "Type": "短文本", "DefaultValues": "", "Value": "31", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_HOTLINEEVENT", "Name": "联系电话" }, { "IsRead": "", "DisplayName": "客户名称", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_HOTLINEEVENT", "Name": "客户名称" }, { "IsRead": "", "DisplayName": "客户地址", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_HOTLINEEVENT", "Name": "客户地址" } ] }, { "Name": "事件信息", "Icon": "./images/formLegendIcon/设计工程量信息.png", "Url": "", "Controls": [{ "IsRead": "true", "DisplayName": "事件类型", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_WX_CASELIST", "Name": "事件类型" }, { "IsRead": "true", "DisplayName": "案卷编号", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_WX_CASELIST", "Name": "CaseNo" }, { "IsRead": "true", "DisplayName": "信息类型", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_WX_CASELIST", "Name": "信息类型" }, { "IsRead": "", "DisplayName": "发送部门", "Type": "下拉框", "DefaultValues": ",咸安管网分部,温泉管网分部", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "TableName": "CIV_GD_WX_CASELIST", "Name": "发送部门" }, { "IsRead": "true", "DisplayName": "事项内容", "Type": "长文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 4, "Validate": "", "TableName": "CIV_GD_WX_CASELIST", "Name": "事项内容" }, { "IsRead": "", "DisplayName": "上报时间", "Type": "日期框", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "上报时间" }, { "IsRead": "", "DisplayName": "截止时间", "Type": "日期框", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "EndTime" }, { "IsRead": "", "DisplayName": "坐标", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "Position" }, { "IsRead": "", "DisplayName": "备注", "Type": "长文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 4, "Validate": "", "Name": "Remark" }, ] }, { "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": "关闭" }] }