CommandContent name="CT_GetOffOrderReturnData" commandType="Text" operateType="Write" cacheEnabled="true">
<CommandText>
<![CDATA[
select a.ID,b.ID as ProductID,b.ProductName,b.ProductCode,b.ProductKG,b.ProductUnit,a.TankCode,c.Order_ID,c.FK_SystemUser_ID,c.CreateTime,d.ChineseName as UserName
from (select * from TBProductTankCode inner join STRING_SPLIT(@codes, ',') t on TankCode = t.value where [status]=1 and IsDelete=0 and IsValid=1) a
left join TBProduct b on a.FK_TBProduct_ID=b.ID
left join TBProductOrder c on a.FK_TBProductOrder_ID=c.ID
left join SystemUser d on c.FK_SystemUser_ID=d.ID
where c.FK_TBStore_ID=@FK_StoreID
]]>
</CommandText>
</CommandContent>