已解决 移动表单发布到云之家后,IPHONE使用报错
金蝶云社区-广西尚贤李勇
广西尚贤李勇
0人赞赏了该文章 503次浏览 未经作者许可,禁止转载编辑于2016年03月28日 11:10:18


cloud5.0+2月补丁
目前安卓设备没有问题,
我是做的是一个可销售库存报表的查询,语句如下:
select
ROW_NUMBER() OVER(order by BAM_BD_Place_L.FNAME, T_BD_MATERIAL_L.FNAME) as FId,
BAM_BD_Place_L.FNAME,
T_BD_MATERIAL.FNUMBER,
T_BD_MATERIAL_L.FNAME as FMATERIALNAME,
[V_BAM_BaseCanSale].FSaleQTY,
[V_BAM_BaseCanSale].OnRoadQty,
[V_BAM_BaseCanSale].NowHave,
[V_BAM_BaseCanSale].OnSale,
T_BD_UNIT_L.FNAME as FBASEUNITNAME,
FSaleQTY*FCONVERTDENOMINATOR/FCONVERTNUMERATOR as FSaleQtyU,
OnRoadQty*FCONVERTDENOMINATOR/FCONVERTNUMERATOR as FOnRoadQtyU,
NowHave *FCONVERTDENOMINATOR/FCONVERTNUMERATOR as FNowHaveQtyU,
OnSale *FCONVERTDENOMINATOR/FCONVERTNUMERATOR as FOnSaleQtyU,
StockUnit.FNAME as FSTOCKUNITNAME from [V_BAM_BaseCanSale]
left outer join T_BD_MATERIALSTOCK on T_BD_MATERIALSTOCK.FMATERIALID =[V_BAM_BaseCanSale].FMATERIALID
left outer join T_BD_UNITCONVERTRATE
on FCURRENTUNITID =T_BD_MATERIALSTOCK.FSTOREUNITID
and FDESTUNITID =[V_BAM_BaseCanSale].FBASEUNITID
left outer join BAM_BD_Place_L on BAM_BD_Place_L.FID =[V_BAM_BaseCanSale].PlaceID
left outer join T_BD_MATERIAL on T_BD_MATERIAL.FMATERIALID=[V_BAM_BaseCanSale].FMATERIALID
left outer join T_BD_MATERIAL_L on T_BD_MATERIAL_L.FMATERIALID=[V_BAM_BaseCanSale].FMATERIALID
left outer join T_BD_UNIT_L on T_BD_UNIT_L.FUNITID =[V_BAM_BaseCanSale].FBASEUNITID
left outer join T_BD_UNIT_L StockUnit on StockUnit.FUNITID =T_BD_MATERIALSTOCK.FSTOREUNITID

where T_BD_MATERIAL_L.FNAME like '%#FMaterialName#%'
and (BAM_BD_Place_L.FNAME like '%#FPlace#%' or BAM_BD_Place_L.FNAME is null)
and T_BD_MATERIAL.FMATERIALID not in (select FMATERIALID from T_BD_MATERIALBASE where FERPCLSID='6' )