{ "TableName":"", "QuerySQL":"select top(1) t2.*,t3.*,t4.*,'' as 坐标 from [CIV_HFRQ_PROJECT_CASEFLOW] as t1 left join CIV_HFRQ_PROJECT_MAIN as t2 on t1.ProjectID=t2.ID left join CIV_HFRQ_PROJECT_CONSTRUCTION_DESIGNCHANGE t3 on t3.CaseNo=t1.CaseNo left join [CIV_HFRQ_PROJECT_FEEDBACK_INFO] t4 on t4.[CASENO]=t1.CaseNo where t1.[FinishFlag]=0 and t1.[EXIST]=1 and t1.ProjectID=[$ID$] and t1.CaseNo like 'SGSJBG%' order by t4.ID desc", "QueryType":"SQL", "PageName": "工单详情", "Groups": [ { "Name": "办理过程", "Icon": "./images/formLegendIcon/工程设计图信息.png", "Url": "./Product/Repair/Standard/Common/CaseProcedureView.js", "IsHide":"" }, { "Name": "变更信息", "Icon": "./images/formLegendIcon/工程基础信息.png", "Url": "", "Controls": [ { "IsRead": "true", "DisplayName": "工程名称", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "PROJECTNAME" }, { "IsRead": "true", "DisplayName": "工程地址", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "PROJECTADDR" }, { "IsRead": "true", "DisplayName": "待确认的变更工程量", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "AMOUNTCONFIMR" }, { "IsRead": "true", "DisplayName": "市场发展处单位名称", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "MARKETDEVELOPMENT" }, { "IsRead": "true", "DisplayName": "市场发展处审核是否合格", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "MARKETISQUALIFIED" }, { "IsRead": "true", "DisplayName": "市场发展处审核意见", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "MARKETOPINION" }, { "IsRead": "true", "DisplayName": "设计院单位", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "DESIGNUNIT" }, { "IsRead": "true", "DisplayName": "设计院审核是否合格", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "DESIGNISQUALIFIED" }, { "IsRead": "true", "DisplayName": "设计院审核意见", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "DESIGNOPINION" } ] }, { "Name": "工程信息", "Icon": "./images/formLegendIcon/设计工程量信息.png", "Url": "", "Controls": [ { "IsRead": "true", "DisplayName": "EAS编码", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "EASCODE" }, { "IsRead": "true", "DisplayName": "工程名称", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "PROJECTNAME" }, { "IsRead": "true", "DisplayName": "工程地址", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "PROJECTADDR" }, { "IsRead": "true", "DisplayName": "用气类型", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "USEGASTYPE" }, { "IsRead": "true", "DisplayName": "客户名称", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "CUSTOMERNAME" }, { "IsRead": "true", "DisplayName": "客户办公电话", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "OFFICEPHONE" }, { "IsRead": "true", "DisplayName": "客户手机", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "MOBILEPHONE" }, { "IsRead": "true", "DisplayName": "工程简介", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "PROJECTINTRO" }, { "IsRead": "true", "DisplayName": "工程状态", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "PROJECTSTATE" }, { "IsRead": "true", "DisplayName": "工程性质", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "PROJECTTYPE" }, ] }, { "Name": "反馈信息", "Icon": "./images/formLegendIcon/工程基础信息.png", "Url": "", "Controls": [ { "IsRead": "true", "DisplayName": "反馈人员", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "UserName" }, { "IsRead": "true", "DisplayName": "反馈时间", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "FEEDBACKTIME" }, { "IsRead": "", "DisplayName": "照片", "Type": "拍照", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "IMAGE" }, { "IsRead": "", "DisplayName": "录音", "Type": "录音", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "RECORD" }, { "IsRead": "true", "DisplayName": "结果", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "RESULT" }, { "IsRead": "", "DisplayName": "反馈意见", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "FEEDBACKOPINION" }, { "IsRead": "", "DisplayName": "现场描述", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "DESCRIPTION" }, { "IsRead": "", "DisplayName": "坐标", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "POSITION" } ] } ], "TopURL": "", "MiddleURL": "", "BottomURL": "", "BottomButtons": [ { "ID": "2", "Name": "处理", "Type": "处理" } ] }