{ "TableName":"", "QuerySQL":"select top(1) t1.*, t2.*,t3.* from CIV_HFRQ_PROJECT_QUANTITY_CONFRIM t1 left join CIV_HFRQ_PROJECT_MAIN t2 on t1.Projectid=t2.ID left join [CIV_HFRQ_PROJECT_FEEDBACK_INFO] t3 on t1.caseno=t3.caseno and t3.projectid=t1.Projectid where t1.ID=[$ID$] order by t3.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": "POSITION_DESC" }, { "IsRead": "true", "DisplayName": "任务编号", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "CaseNO" }, { "IsRead": "true", "DisplayName": "发起人", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "LAUNCHMAN" }, { "IsRead": "true", "DisplayName": "发起时间", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "LAUNCHTIME" }, { "IsRead": "true", "DisplayName": "工程量确认内容", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "CONS_CONTENT" }, { "IsRead": "true", "DisplayName": "签证类型", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "VISA_TYPE" }, { "IsRead": "true", "DisplayName": "施工签证金额", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "CONS_VISA_MONEY" }, { "IsRead": "true", "DisplayName": "监理签证金额", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "SUPER_VISA_MONEY" }, { "IsRead": "true", "DisplayName": "建设单位签证金额", "Type": "短文本", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "BUILD_VISA_MONEY" }, { "IsRead": "", "DisplayName": "附件", "Type": "附件", "DefaultValues": "", "Value": "", "UploadArgs": "", "DisplayColSpan": 2, "Validate": "", "Name": "imgurl" } ] }, { "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" } ] } ], "TopURL": "", "MiddleURL": "", "BottomURL": "", "BottomButtons": [ { "ID": "2", "Name": "处理", "Type": "处理" } ] }