{
  "TableName":"",
  "QuerySQL":"select top(1) *
  ,(select 名称  from [FLOW_GROUPS] where [机构ID]=(select top(1) [GROUPID] from [CIV_HFRQ_PROJECT_DEPART] where [PROJECTID]=[CIV_HFRQ_PROJECT_MAIN].ID and [COMPANYTYPE]='管道安装施工单位')) as shigongunit
   ,(select 名称  from [FLOW_GROUPS] where [机构ID]=(select top(1) [GROUPID] from [CIV_HFRQ_PROJECT_DEPART] where [PROJECTID]=[CIV_HFRQ_PROJECT_MAIN].ID and [COMPANYTYPE]='监理单位')) as jianliunit
    ,(select [USERNAME] from [CIV_HFRQ_PROJECT_CREW] where [PROJECTID]=[CIV_HFRQ_PROJECT_MAIN].ID and [UNIT]='管道安装施工单位' and [TYPE]='施工员') as shigongman
  ,(select [USERNAME] from [CIV_HFRQ_PROJECT_CREW] where [PROJECTID]=[CIV_HFRQ_PROJECT_MAIN].ID and [UNIT]='监理单位' and [TYPE]='专业监理工程师') as jianliman
   from [CIV_HFRQ_PROJECT_MAIN]
   where ID=[$ID$]  and EXIST=1",
  "QueryType":"SQL",
  "PageName": "工单详情",
  "Groups": [
    {
      "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"
        },
           {
          "IsRead": "true",
          "DisplayName": "施工单位",
          "Type": "短文本",
          "DefaultValues": "",
          "Value": "",
          "UploadArgs": "",
          "DisplayColSpan": 2,
          "Validate": "",
          "Name": "shigongunit"
        },
           {
          "IsRead": "true",
          "DisplayName": "施工员",
          "Type": "短文本",
          "DefaultValues": "",
          "Value": "",
          "UploadArgs": "",
          "DisplayColSpan": 2,
          "Validate": "",
          "Name": "shigongman"
        },
           {
          "IsRead": "true",
          "DisplayName": "监理单位",
          "Type": "短文本",
          "DefaultValues": "",
          "Value": "",
          "UploadArgs": "",
          "DisplayColSpan": 2,
          "Validate": "",
          "Name": "jianliunit"
        },
           {
          "IsRead": "true",
          "DisplayName": "监理人员",
          "Type": "短文本",
          "DefaultValues": "",
          "Value": "",
          "UploadArgs": "",
          "DisplayColSpan": 2,
          "Validate": "",
          "Name": "jianliman"
        }
      ]
    }
  ],
  "TopURL": "",
  "MiddleURL": "",
  "BottomURL": "",
  "BottomButtons": []
}