分页加载,点击下一页,为什么会报:列名“编号”无效呢?
初始加载语句如下:
select DRId as N'编号',drmonth+N'月'+drDate+N'日' as '日期',DRInputer as '录入者',case when DRIfRemote IS Null then N'未开始维修' else case when SUBSTRING(DRIfRemote,DATALENGTH(DRIfRemote)-1,1) = 0 then N'远程' else N'现场' end end as '现场/远程',DRErrorMainModule as '主模块',DRErrorAttachModule as '附属模块',DRErrorSpecific as '具体故障',DRErrorType as '故障类型',DRCauseFinal as '最终原因',case when DRIfSolvedPro is null then N'未填写' else case when SUBSTRING(DRIfSolvedPro,DATALENGTH(DRIfSolvedPro)-1,1) = '1' then N'已解决' else N'未解决' end end as N'是否解决(处理)',case when DRIfSolved is null then N'未填写' else case when SUBSTRING(DRIfSolved,DATALENGTH(DRIfSolved)-1,1) = 1 then N'已解决' else N'未解决' end end as N'是否解决(回访)',DRServiceEngieer as '服务工程师',case when DRCustomAppraise Is null then N'未开始回访' else case when SUBSTRING(DRCustomAppraise,DATALENGTH(DRCustomAppraise)-1,1) = 0 then N'不满意' when DRCustomAppraise = 1 then N'一般' else N'满意' end end as '用户评价',DRReturnVisitTime as '回访时间',DRSuggestion as '用户建议',case when DRIfSatisfied Is null then N'未开始回访' when DRIfSatisfied = 1 then N'满意' else N'不满意' end as '是否满意',DRDesc as '备注' ,BankName as '银行名称',ProName as '省份',CityName as '地区',SerStationName as '服务站',case when DROrderStatus = 0 then N'未开始维修' when DROrderStatus = 1 then N'正在进行,正常' when DROrderStatus = 2 then N'等待改派' when DROrderStatus = 3 then N'维修完成,等待回访' when DROrderStatus = 4 then N'完成' end as N'任务状态' from {DailyReport} inner join {EquipInfo} on DRAtmId = EquipAtmId inner join {BankInfo} on BankId = EquipBank inner join {CityInfo} on EquipCity = CityId inner join {ProvinceInfo} on CityPro = ProId inner join {SerStationInfo} on SerStationId = EquipSerStation