银客环企年卡库存状态修改

[landv]

select * from GS_RM_REPORTMANAGEMENT WHERE  rm_name like ('%入库%')
-- 年卡入库

 select
GS_One.NPHYSICALNO 物理号,
GS_One.SPRINTNO 印刷号,
GS_Four.NTYPEID 一卡通ID,
GS_Four.STYPENAME 类型名称,
 CONVERT(varchar(100),GS_One.DCREATEDT,23) AS 录入日期,
GS_One.DCREATEDT AS 录入时间,
GS_Three.EMP_NAME 录入人,
 case GS_One.NSTATUS  
 when '0' then '已初始化'
 when '1' then '流通中'
 when '2' then '流通结束'
 when '3' then '作废'
 when '4' then '挂失'
 when '5' then '冻结'
 end 状态 ,
GS_Four.ISCARD 
from   GS_W_WRISTBANDDEPOT  GS_One
left join sac_employee GS_Three ON GS_One.NCREATEBY=GS_Three.EMP_ID
left join GS_W_WristbandType GS_Four ON GS_One.NSTARTNO= GS_Four.NTYPEID

select NSTATUS,* from GS_W_WRISTBANDDEPOT