|
发表于 2008-9-9 09:57:59
|
显示全部楼层
select enum5.enumname as cretype,ctvcode,ciwhcode,cwhname,enum.enumname as issotype,csocode,cast (isoseq as nvarchar) as isoseq ,enum2.enumname as idsotype,cdsocode, cast( idsoseq as nvarchar) as idsoseq ,kc.cinvcode,I.cinvaddcode, I.cinvname,I.cinvstd,cinvm_unit,cinva_unit, iinvexchrate,itvquantity,itvnum,ctvbatch,kc.dmadedate,ddisdate,cast (I.imassdate as nvarchar) as imassdate,enum3.enumname as cmassunit, I.cInvDefine1,I.cInvDefine2,I.cInvDefine3,I.cInvDefine4,I.cInvDefine5,I.cInvDefine6,I.cInvDefine7,I.cInvDefine8,I.cInvDefine9,I.cInvDefine10,I.cInvDefine11,I.cInvDefine12,I.cInvDefine13,I.cInvDefine14,I.cInvDefine15,I.cInvDefine16, kc.cfree1,kc.cfree2,kc.cfree3,kc.cfree4,kc.cfree5,kc.cfree6,kc.cfree7,kc.cfree8,kc.cfree9,kc.cfree10, enum4.enumname as cordertype,kc.cinvouchcode,kc.cbvencode,cvenname,dtvdate,kc.cmaker
from ylcxlist kc left join inventory i on kc.cinvcode=i.cinvcode left join v_aa_enum enum4 on enum4.enumcode=kc.cvouchtype and enum4.enumtype='ST.Vouchtype'
left join v_aa_enum enum5 on enum5.enumcode=case when (isnull(issotype,0)=0 and isnull(idsotype,0)<>0) then 1 when (isnull(issotype,0)<>0 and isnull(idsotype,0)=0)
then 2 when (isnull(issotype,0)<>0 and isnull(idsotype,0)<>0 ) then 3 end and enum5.enumtype='ST.ResType' left join v_aa_enum enum on enum.enumcode=kc.issotype and
enum.enumtype='st.sotype' left join v_aa_enum enum2 on enum2.enumcode=kc.idsotype and enum2.enumtype='st.sotype' left join v_aa_enum enum3 on enum3.enumcode=I.cmassunit
and enum3.enumtype='ST.MassUnit' WHERE kc.csource=3 |
|