RsC.Open "select sj as 操作日期 ,djbh as 操作流水号 , (iif( djlx in ('ZLRK','PFRK') , '入库' iif( djlx='CK' , '出库' iif( djlx='BS' , '报损' iif( djlx='BC' , '补货',null)))) ) as 操作类型 ,sl as 数量,CZY as 操作人,rtrim(bz) from kcjl where djlx in ('ZLRK','PFRK','CK','BS','BC') and ((djbh='" & Trim(StrDjbh) & "'and djlx in ('ZLRK','PFRK'))or (hwmc='" & Trim(StrDjbh) & "'and djlx NOT in ('ZLRK','PFRK'))) order by sj", Conn
to zjcxc(邹建) 大哥我是你的景仰犹如滔滔江水,还准备去买你的书。不知道长沙有没有买??你都5个猩猩了,我还没有一个,你真是厉害啊!
(iif( djlx in ('ZLRK','PFRK') , '入库' iif( djlx='CK' , '出库' iif( djlx='BS' , '报损'
iif( djlx='BC' , '补货',null)))) ) as 操作类型 ,sl as 数量,CZY as 操作人,rtrim(bz) from kcjl
where djlx in ('ZLRK','PFRK','CK','BS','BC') and ((djbh='" & Trim(StrDjbh) & "'and djlx in ('ZLRK','PFRK'))or (hwmc='" & Trim(StrDjbh) & "'and djlx NOT in ('ZLRK','PFRK')))
order by sj", Conn
大哥我是你的景仰犹如滔滔江水,还准备去买你的书。不知道长沙有没有买??你都5个猩猩了,我还没有一个,你真是厉害啊!