S4产品FAQ

请先备份数据
维修管理界面的显示顺序调整:
update DataQueryMap set displayseq=6 where queryname='ipd_svbill_v' and displayname='进厂日期'
update DataQueryMap set displayseq=6 where queryname='ipd_svbill_v' and displayname='计划完工日'
update DataQueryMap set displayseq=7 where queryname='ipd_svbill_v' and displayname='客户名称'
update DataQueryMap set displayseq=8 where queryname='ipd_svbill_v' and displayname='工单类别'
update DataQueryMap set displayseq=9 where queryname='ipd_svbill_v' and displayname='维修类别'
update DataQueryMap set displayseq=10 where queryname='ipd_svbill_v' and displayname='负责部门'
update DataQueryMap set displayseq=11 where queryname='ipd_svbill_v' and displayname='接车人员'
update DataQueryMap set displayseq=12 where queryname='ipd_svbill_v' and displayname='客户专员'
update DataQueryMap set displayseq=13 where queryname='ipd_svbill_v' and displayname='保险名称'
update DataQueryMap set displayseq=14 where queryname='ipd_svbill_v' and displayname='VIN号'
update DataQueryMap set displayseq=15 where queryname='ipd_svbill_v' and displayname='索赔名称'
update DataQueryMap set displayseq=16 where queryname='ipd_svbill_v' and displayname='发动机号'
update DataQueryMap set displayseq=17 where queryname='ipd_svbill_v' and displayname='驾驶人员'
update DataQueryMap set displayseq=18 where queryname='ipd_svbill_v' and displayname='会员卡号'
update DataQueryMap set displayseq=19 where queryname='ipd_svbill_v' and displayname='固定电话'
update DataQueryMap set displayseq=20 where queryname='ipd_svbill_v' and displayname='移动电话'
update DataQueryMap set displayseq=21 where queryname='ipd_svbill_v' and displayname='客帐金额'
update DataQueryMap set displayseq=22 where queryname='ipd_svbill_v' and displayname='客帐余额'
update DataQueryMap set displayseq=23 where queryname='ipd_svbill_v' and displayname='保险金额'
update DataQueryMap set displayseq=24 where queryname='ipd_svbill_v' and displayname='索赔金额'
update DataQueryMap set displayseq=25 where queryname='ipd_svbill_v' and displayname='实际完工'
update DataQueryMap set displayseq=26 where queryname='ipd_svbill_v' and displayname='结算日期'
update DataQueryMap set displayseq=27 where queryname='ipd_svbill_v' and displayname='结案日期'
update DataQueryMap set displayseq=28 where queryname='ipd_svbill_v' and displayname='厂家单号'
update DataQueryMap set displayseq=29 where queryname='ipd_svbill_v' and displayname='出厂状态'

---------------
颜色调整：
data_list.jsp IPD目录下这个文件