[FaultException: Mutator 'modify()' on '@Result' cannot be called on a null value.
select CommodityNServicePropertyID,
isnull(CommodityNServiceProperty_CommodityNService_NameID,0) as CommodityNServiceProperty_CommodityNService_NameID,
isnull(CommodityNServiceProperty_CommodityNService_CategoryParentID,0) as CommodityNServiceProperty_CommodityNService_CategoryParentID,
isnull(CommodityNServiceProperty_CommodityNService_CategoryChildID,0) as CommodityNServiceProperty_CommodityNService_CategoryChildID,
IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0))>0,1,2) as CommodityNServiceProperty_CommodityNService_Pricing_QualityID,
CommodityNServiceProperty_Code,
CASE
WHEN isnull(CommodityNServiceProperty_CnSSerialNumber,'')!=''
THEN CommodityNServiceProperty_Title +' ['+ isnull(CommodityNServiceProperty_CnSSerialNumber,'')+']'
else
CommodityNServiceProperty_Title
end as CommodityNServiceProperty_Title,
isnull(CommodityNServiceProperty_ExpirationDateTime,'') as CommodityNServiceProperty_ExpirationDateTime,
CommodityNService_CategoryParent_Title,
CommodityNService_CategoryChild_Title,
CommodityNService_Name_Title,
IIF((isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0))>0,N'موجود',N'ناموجود') as CommodityNService_Pricing_Quality_Title,
CommodityNServiceProperty_Icon,
CommodityNServiceProperty_ShabnamCode,
CommodityNServiceProperty_BateFlag,
CommodityNServiceProperty_PriceIncreaseFlag,
CommodityNServiceProperty_ConsumableFlag,
CommodityNServiceProperty_PriceBasedNumberFlag,
replace(CommodityNServiceProperty_Description,char(10),'<br/>') as CommodityNServiceProperty_Description,
CommodityNServiceProperty_TotalPurchased as CommodityNServiceProperty_PurchasingPrice,
CommodityNServiceProperty_Price,
CommodityNServiceProperty_Barcode,
CommodityNService_Usage_Title,
CommodityNService_Location_Title,
CommodityNService_Pricing_CommodityTypeBasedPrice_Title,
CommodityNServiceProperty_SellersFactor,
isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0) AS Max_number_Order,
isnull((SELECT SUM(WarehouseSalableRemained) FROM dbo.Warehouse_StockImported WHERE CommodityNServicePropertyID=CommodityNServiceProperty_View.CommodityNServicePropertyID AND WarehouseID IN (8,9,10)
AND DelFlag=0 AND ActiveFlag=1
),0) AS Movjoodi,
isnull(CommodityNService_Location_Title,'') as CommodityNServiceProperty_Brand,
replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/UsageDescription)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_UsageDescription,
replace(isnull(CommodityNServiceProperty_PriceBasedNumberXML.value('(./PriceBasedNumberXML/Tel/Nokat)[1]','nvarchar(max)'),''),char(10),'<br/>') as CommodityNServiceProperty_Nokat,
isnull(Content_HowToDisplay.PublicFlag,0) as likeFlag
From CommodityNServiceProperty_View
left join Content_HowToDisplay on Content_HowToDisplay.Content_GeneralID=CommodityNServiceProperty_View.CommodityNServicePropertyID
where CommodityNServiceProperty_SalableFlag=0 and CommodityNServiceProperty_DelFlag=0 and CommodityNServiceProperty_ActiveFlag=1 and CommodityNServicePropertyID=6140 for XML RAW
Warning: Null value is eliminated by an aggregate or other SET operation.]
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +14764695
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +403
TolueShop.DynamicServiceReference.IDynamicService.Show_List_ByMenuID(String username, String password, Int32 MenuID, Int32 pagelenth, Int32 order_column, String order_dir, Int32 startRecord, String condition) +0
TolueShop.Page.Product.Page_Load(Object sender, EventArgs e) in C:\Users\S.Hasanzadeh\Source\Workspaces\TolueShop\TolueShop\Page\Product.aspx.cs:90
System.Web.UI.Control.OnLoad(EventArgs e) +108
System.Web.UI.Control.LoadRecursive() +90
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533
|