{ "TableName":"", "QuerySQL":"select top(1) *,(SELECT top(1) 活动名称 FROM FLOWDOINGCASE WHERE (案件编号 = t3.t1CaseNo) ORDER BY 承办时间 DESC) as 当前活动,(SELECT top(1) 承办人 FROM FLOWDOINGCASE WHERE (案件编号 = t3.t1CaseNo) ORDER BY 承办时间 DESC) as 承办人,(SELECT top(1) 承办意见 FROM FLOWDOINGCASE WHERE (案件编号 = t3.t1CaseNo) ORDER BY 承办时间 DESC) as 承办意见 from (select T2.caseno AS YIJICASENO,t1.id as t1id,t1.Position as t1Position,t1.PositonX_Y as t1PositonX_Y,t1.CaseNo as t1CaseNo,t1.GDID,t2.* from CIV_GD_TaskPoint t1 left join CIV_GD_WX_CASELIST t2 on t1.GDID = t2.id where t1.id=[$ID$]) t3 left join CIV_GD_WX_FEEDBACK t4 ON t3.t1CaseNo = t4.CaseNo order by FeedbackTime desc", "QueryType":"SQL", "PageName": "工单详情", "Groups": [ { "Name": "基本信息", "Icon": "./images/formLegendIcon/工程基础信息.png", "Url": "", "Controls": [ { "IsRead": "true", "DisplayName": "工单地址", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "t1Position" }, { "IsRead": "true", "DisplayName": "坐标", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "t1PositonX_Y" }, { "IsRead": "true", "DisplayName": "联系电话", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "联系电话" }, { "IsRead": "true", "DisplayName": "手机号码", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "手机号码" }, { "IsRead": "true", "DisplayName": "任务编号", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "YIJICASENO" }, { "IsRead": "true", "DisplayName": "热线编号", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "信息编号" }, { "IsRead": "true", "DisplayName": "当前活动", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "当前活动" }, { "IsRead": "true", "DisplayName": "承办人", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "承办人" }, { "IsRead": "true", "DisplayName": "受理备注", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "受理备注" }, { "IsRead": "true", "DisplayName": "一级平台派遣备注", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "派遣备注" }, { "IsRead": "true", "DisplayName": "现场图片", "Type": "图片", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "现场图片" } ] }, { "Name": "详细信息", "Icon": "./images/formLegendIcon/设计工程量信息.png", "Url": "", "Controls": [ { "IsRead": "true", "DisplayName": "事件来源", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "EVENTSOURCE" }, { "IsRead": "true", "DisplayName": "片区管理员", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "片区管理员" }, { "IsRead": "true", "DisplayName": "接报日期", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "接报日期" }, { "IsRead": "true", "DisplayName": "处理级别", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "处理级别" }, { "IsRead": "true", "DisplayName": "上报人", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "上报人" }, { "IsRead": "true", "DisplayName": "联系电话", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "联系电话" }, { "IsRead": "true", "DisplayName": "手机号码", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "手机号码" }, { "IsRead": "true", "DisplayName": "反映单位", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "反映单位" }, { "IsRead": "true", "DisplayName": "反映类别", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "反映类别" }, { "IsRead": "true", "DisplayName": "反映内容", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "反映内容" }, { "IsRead": "true", "DisplayName": "反映来源", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "反映来源" }, { "IsRead": "true", "DisplayName": "反映形式", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "反映形式" }, { "IsRead": "true", "DisplayName": "信息性质", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "信息性质" }, { "IsRead": "true", "DisplayName": "发生时间", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "发生时间" }, { "IsRead": "true", "DisplayName": "发生地址", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "发生地址" }, { "IsRead": "true", "DisplayName": "派遣时间", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "派遣时间" }, { "IsRead": "true", "DisplayName": "派遣备注", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "派遣备注" }, { "IsRead": "true", "DisplayName": "任务编号", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "YIJICASENO" }, { "IsRead": "true", "DisplayName": "热线编号", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "信息编号" } ] }, { "Name": "抢修信息", "Icon": "./images/formLegendIcon/工程基础信息.png", "Url": "", "Controls": [ { "IsRead": "true", "DisplayName": "抢修队名", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "1", "Name": "抢修队名" }, { "IsRead": "true", "DisplayName": "到场时间", "Type": "时间", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "1", "Name": "开始时间" }, { "IsRead": "true", "DisplayName": "施工时间", "Type": "时间", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "施工时间" }, { "IsRead": "true", "DisplayName": "结束时间", "Type": "时间", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "结束时间" }, { "IsRead": "true", "DisplayName": "损坏性质", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "事件描述" }, { "IsRead": "true", "DisplayName": "漏损部位", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "漏损位置" }, { "IsRead":"true", "DisplayName":"管道材质", "Type":"多值", "DefaultValues":"", "Value":"", "UploadArgs":"", "DisplayColSpan":2, "Validate":"", "Name":"管道材质" }, { "IsRead":"true", "DisplayName":"口径", "Type":"多值", "DefaultValues":"", "Value":"", "UploadArgs":"", "DisplayColSpan":2, "Validate":"", "Name":"口径" }, { "IsRead": "true", "DisplayName": "漏水情况", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "漏损情况" }, { "IsRead": "true", "DisplayName": "维修方法", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "维修方法" }, { "IsRead": "true", "DisplayName": "压力区域", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "压力区域" }, { "IsRead": "true", "DisplayName": "压力级别", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "压力级别" }, { "IsRead": "true", "DisplayName": "管道坐落", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "管道坐落" }, { "IsRead": "true", "DisplayName": "带水抢修", "Type": "多值", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "带水抢修" }, { "IsRead": "true", "DisplayName": "抢修拍照", "Type": "图片", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "1", "Name": "抢修方式" }, { "IsRead": "true", "DisplayName": "凿岩机", "Type": "浮点型", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "凿岩机" }, { "IsRead": "true", "DisplayName": "挖机", "Type": "浮点型", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "挖机" }, { "IsRead": "true", "DisplayName": "发电机", "Type": "浮点型", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "发电机" }, { "IsRead": "true", "DisplayName": "水泵", "Type": "浮点型", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "水泵" }, { "IsRead": "true", "DisplayName": "坐标", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "GPS状态" }, { "IsRead": "true", "DisplayName": "抢修说明", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "备注" } ] } ], "TopURL": "", "MiddleURL": "", "BottomURL": "", "BottomButtons": [ { "ID": "goback", "Name": "返回", "Type": "返回" } ] }