沈阳伙伴郭 - 2015/1/22 10:49:27
最近有客户钣喷看板变成这样了，下面的快喷消失了。只要开工 这个车信息就消失。
解决办法：
--------------------------------------------------------------------------------------------------------------
- 首先执行
- select c.LICENSE_PLATE_CODE ,isnull(a.IN_DATE,''),d.STAFF_NAME, isnull(a.SV_STATUS,0),dbo.MS_GetT3SVItemMainStaff(a.SV_ID),isnull
- (a.PLAN_DATE,''), b.BP_TYPE,(case when isnull(b.STEP,-1)=0 and isnull(b.S_STATUS,0)=0 THEN -1 ELSE isnull(b.STEP,-1) END), isnull
- (b.S0_B_TIME,''),isnull(b.S0_E_TIME,''),isnull(b.S0_PE_TIME,''),isnull(b.S0_WORKER,0), isnull(b.S1_B_TIME,''),isnull
- (b.S1_E_TIME,''),isnull(b.S1_PE_TIME,''),isnull(b.S1_WORKER,0), isnull(b.S2_B_TIME,''),isnull(b.S2_E_TIME,''),isnull
- (b.S2_PE_TIME,''),isnull(b.S2_WORKER,0), isnull(b.S3_B_TIME,''),isnull(b.S3_E_TIME,''),isnull(b.S3_PE_TIME,''),isnull
- (b.S3_WORKER,0), isnull(b.S4_B_TIME,''),isnull(b.S4_E_TIME,''),isnull(b.S4_PE_TIME,''),isnull(b.S4_WORKER,0), isnull
- (b.S5_B_TIME,''),isnull(b.S5_E_TIME,''),isnull(b.S5_PE_TIME,''),isnull(b.S5_WORKER,0), isnull(b.DS_B_TIME,''),isnull
- (b.DS_E_TIME,''),isnull(a.TG_TIME,'') from MS_SVMaster a with(nolock) join MS_SVBPmaster b with(nolock) on (a.SV_ID = b.SV_ID)
- left join MS_Vehicle c with(nolock) on (a.VEHICLE_ID=c.VEHICLE_ID) left join MS_Staff d with(nolock) on (a.Staff_ID = d.STAFF_ID)
- left join MS_Dept e with(nolock) on (a.DEPT_ID=e.DEPT_ID) where a.BILL_STATUS < 3 and a.BILL_STATUS > 0 order by b.S_STATUS
- 看是不是有的数据第二列为空 如果有 找到这列 然后把第二列数据插入
- update MS_SVMaster set IN_DATE='2015/01/17 10:42' where VEHICLE_ID ='21410'
- 想办法找到VEHICLE_ID 与日期 故障解决