[
    {
        "Key":"维修工单导出",
        "Value":"select t1.事件类型,t1.客户名称,t1.客户编号,t1.客户地址,t1.联系电话,到场时间,结束时间,原表底数, 水表口径, 新表底数, 新表编号, 封铅号, 主管规格, 材质类型, 损坏部位 from 
(select  c.CASENO,事件类型,客户名称,客户编号,g.到场时间,g.结束时间,客户地址,联系电话 from CIV_GD_WX_CASELIST c left join CIV_GD_WX_GW_FEEDBACK g
 on c.CASENO = g.CASENO ) t1
,
(select c.CASENO,事件类型,客户名称,客户编号,客户地址,联系电话,原表底数, 水表口径, 新表底数, 新表编号, 封铅号, 主管规格, 材质类型, 损坏部位 
from CIV_GD_WX_CASELIST c left join CIV_GD_WX_SB_FEEDBACK s
 on c.CASENO = s.CASENO) t2
where t1.CASENO = t2.caseno and t1.CASENO in ({1})",
        "Desc":"维修工单Excel导出语句"
    },
    {
        "Key":"DelayFlowName",
        "Value":"延期",
        "Desc":"延期申请流程名称"
    },
	{
        "Key":"DelaySupName",
        "Value":"主管审批",
        "Desc":"延期流程主管审核活动名称"
    },
	{
        "Key":"FixDispatchName",
        "Value":"维修派单",
        "Desc":"维修流程维修派单活动名称"
    },
	{
        "Key":"EventSuperviseName",
        "Value":"事件审核",
        "Desc":"维修流程维修派单活动名称"
    },
	{
		"Key":"EnableDeptSecurity",
        "Value":"1",
        "Desc":"是否启用按机构做权限控制,1:是,0:否"
	},
	{
		"Key":"EnableSA",
        "Value":"1",
        "Desc":"管理员是否不受机构权限控制,1:是,0:否"
	},
	{
		"Key":"SACode",
        "Value":"1-1",
        "Desc":"管理员机构编码"
	},
	{
		"Key":"OnlineByGPS",
        "Value":"1",
        "Desc":"是否根据GPS状态决定用户在线状态,1:是,0:否"
	},
	{
		"Key":"UserType_maintain",
        "Value":"2",
        "Desc":"维修员用户标识(不建议修改)"
	},
	{
		"Key":"WeiXiu_Code",
        "Value":"1",
        "Desc":"维修流程编码"
	},
	{
		"Key":"MobileNode",
        "Value":"管网维修,节点维修",
        "Desc":"手持端节点"
	}
]