{ "TableName":"", "LogicFncName":"FlowPageControlDisplay", "QueryType":"SQL", "QuerySQL":"select main.工单编号,main.CaseID, main.EVENTSOURCE, main.EVENTID, main.CASENO, main.信息编号, main.接报时间, main.处理级别 , main.反映人, main.联系电话, main.手机, main.客户号, main.Email, main.反映单位, main.反映类别, main.反映内容, main.反映来源 , main.反映形式, main.反映区域, main.表位状态, main.发生时间, main.预约时间, main.受理单位, main.发生地址, main.受理备注 , main.登录员, main.登录站点, main.坐标, main.图片, main.录音 , feedBack.处理状态 , doing.ID0, doing.案件编号, doing.案件名称, doing.流程名称, doing.流程ID, doing.活动名称, doing.活动ID, doing.承办人 , doing.承办人ID, landPre.承办意见, doing.承办时间, doing.移交方向, node.节点类型, node.节点ID from CIV_GD_WX_CASELIST main left join CIV_GD_WX_FEEDBACK feedBack on main.CaseID = feedBack.CaseID , FLOWDOINGCASE doing , FLOWNODE node , FLOWCTRLTBL caseInfo , LANDFLOWGLOB landNow left join LANDFLOWGLOB landPre on landNow.PRESTEP = landPre.ID0 , CIV_GD_WX_CASE_FLOW caseJoin where landNow.ID0 = doing.ID0 and doing.活动ID = node.活动ID and doing.活动名称 = '工单维修' and doing.流程ID = caseInfo.流程ID and caseJoin.CaseID = main.CaseID and caseJoin.CaseNO = doing.案件编号 and main.EXIST = 1 and main.CaseID=[$ID$]", "Groups":[ { "Name":"用户姓名", "Icon":"./images/formLegendIcon/1.png", "Url":"", "Controls":[ { "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":"Email", "Type":"短文本", "DefaultValues":"", "Value":"", "UploadArgs":"", "DisplayColSpan":2, "Validate":"", "Name":"Email" }, { "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":"坐标" } ] } ], "TopURL":"", "MiddleURL":"", "BottomURL":"", "BottomButtons":[ { "ID":"", "Name":"移交", "Type":"" }, { "ID":"", "Name":"", "Type":"" } ] }