盘点机兑换商品找不到所有商品。前台可以查看。绑定仓库和前台一个仓库。有库存。有写彩票兑换数量。没限制终端。客户导入的商品。
系统BUG
10.4.3077
在服务器数据库中执行以下语句
-----兑换视图兼容游乐宝转娱乐管家数据
IF EXISTS (SELECT 1 FROM sys.views WHERE object_id=OBJECT_ID('[dbo].[View_ExchangeGoodInfo]'))create view View_ExchangeGoodInfo
as
SELECT gb.ID, gb.GoodName, gb.GoodNO, gb.GoodsType, gb.IsReal,
(SELECT Barcode + ','
FROM dbo.Mall_GoodsBarcode
WHERE (Goods = gb.ID) AND (OwnedBusiness = gb.OwnedBusiness OR
OwnedBusiness IS NULL) AND (IsDelete = 0) FOR XML PATH('')) AS GoodsBarcode, exGd.PriceLottery AS TicketExChangeAmount,
exGd.PriceHeapcent AS HeacentExChangeAmount, exGd.PriceCoin AS CoinExChangeAmount, exGd.PriceGoldCoin AS GoldExChangeAmount,
exGd.PriceDoll AS DollExChangeAmount, exGd.PriceEnergy AS EnergyExChangeAmount, exGd.RecoverPriceLottery AS TicketRecoverAmount,
exGd.RecoverPriceHeapcent AS HeacentRecoverAmount, exGd.RecoverPriceCoin AS CoinRecoverAmount,
exGd.RecoverPriceGoldCoin AS GoldRecoverAmount, exGd.RecoverPriceDoll AS DollRecoverAmount,
exGd.RecoverPriceEnergy AS EnergyRecoverAmount, exGd.IsCanRecover, gb.IsDelete, gb.IsEnable, gb.CreateTime, gb.UpdateTime, exGd.OwnedMall,
exGd.OwnedBusiness, gb.IsNoExchangeRate, gb.MemCode
FROM Mall_ExchangeGoodsPrice AS exGd
JOIN Mall_GoodBase AS gb ON exGd.Goods = gb.ID
LEFT JOIN Mall_GoodExtent as ge on gb.ID=ge.Good
WHERE exGd.IsDelete = 0 AND gb.IsDelete = 0 AND (gb.GoodsType IN (0, 1, 2, 6, 101, 102)) AND gb.IsSys = 0 and (ge.ID is null or ge.GoodsAtt!=4)
