{ "TableName":"CIV_GD_WX_CASELIST", "LogicFncName":"FlowPageControlDisplay,ShenheJiean", "PageName":"咸安审核", "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":"./Product/Maintenance/general/EventManage/views/TimeAxis.js", "Controls":[ ] }, { "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":"true", "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":"required", "Name":"上报时间" }, { "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":"save", "Name":"审核通过", "Type":"保存并归档" }, { "ID":"caseGoBack", "Name":"打回", "Type":"保存并移交" }, { "ID":"goback", "Name":"返回", "Type":"返回" } ] }