{
  "TableName":"",
  "QuerySQL":"select top(1) t1.*, t2.*,t3.*
  ,case ISSUPERVISORARRIVE when 0 then '否' else  '是' end as ISSUPERVISORARRIVE2
,case ISLEADERARRIVE when 0 then '否' else  '是' end as ISLEADERARRIVE2
  from CIV_HFRQ_PROJECT_INSPECTION_INFO 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": "CONTENTINFO"
        
	},
{
    	 "IsRead": "true",
        "DisplayName": "报验级别",      
	"Type": "短文本",     
	"DefaultValues": "",   
	 "Value": "",     
	"UploadArgs": "",      
	"DisplayColSpan": 2,     
	 "Validate": "",    
	 "Name": "INSPECTLEVEL"
	 },	
        {
          "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": "PROCESS"
       
	 },

		
	{
 "IsRead": "true",
        
	  "DisplayName": "计划验收时间",
         
	 "Type": "短文本",
          
	"DefaultValues": "",
          
	"Value": "",
         
	 "UploadArgs": "",
         
	 "DisplayColSpan": 2,
         
	 "Validate": "",
         
	 "Name": "PLANACCEPTANCETIME"
      
	  },
         {
 "IsRead": "true",
        
	  "DisplayName": "报验位置描述",
         
	 "Type": "百度地址",
          
	"DefaultValues": "",
          
	"Value": "",
         
	 "UploadArgs": "",
         
	 "DisplayColSpan": 2,
         
	 "Validate": "",
         
	 "Name": "ADDRESS"
	  },
 	{
          "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"
 
       }

     ]
    },
	{
      "Name": "反馈信息",
      "Icon": "./images/formLegendIcon/工程基础信息.png",
      "Url": "",
      "Controls": [
        {
          "IsRead": "true",
          "DisplayName": "监理是否到达现场",
          "Type": "短文本",
          "DefaultValues": "",
          "Value": "",
          "UploadArgs": "",
          "DisplayColSpan": 2,
          "Validate": "",
          "Name": "ISSUPERVISORARRIVE2"
        },
        {
          "IsRead": "true",
          "DisplayName": "项目负责人是否到达现场",
          "Type": "短文本",
          "DefaultValues": "",
          "Value": "",
          "UploadArgs": "",
          "DisplayColSpan": 2,
          "Validate": "",
          "Name": "ISLEADERARRIVE2"
        },
        {
          "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": "1",
      "Name": "退单",
      "Type": "退单"
    },
     {
      "ID": "2",
      "Name": "处理",
      "Type": "处理"
    }
  ]
}