比如XML会视< 或 >为标记的开始结束,这时候就需要用<![CDATA[ xxxxxx ]]> 把你需要写入的结点内容括起来,如下
<select id="PickUpCalUnit_LNGJTM" parameterClass="Hashtable">
<![CDATA[
SELECT b.CalculatorUnitID ,
b.BackupYear ,
a.UnitID ,
a.UnitName ,
a.GeoID ,
c.WorkID,
c.CLLevelID
FROM dbo.T_Unit a
INNER JOIN t_calculatorunit b ON a.unitid = b.unitid
INNER JOIN T_LatestResult c ON a.UnitID = c.UnitID
WHERE a.UnitID IN (
SELECT UnitID
FROM T_LatestResult
WHERE WorkID = ( SELECT MAX(a.WorkID) AS WorkID
FROM T_LatestResult a
JOIN T_Work b ON a.WorkID = b.WorkID
JOIN DM_WorkStutas c ON b.StandardID = c.StandardID
AND b.WorkStutasID = c.WorkStutasID
WHERE a.CLLevelID = 1
AND b.StandardID = 1
AND DATEPART(year, b.WorkYear) < $Year$
) )
AND c.WorkID = ( SELECT MAX(a.WorkID) AS WorkID
FROM T_LatestResult a
JOIN T_Work b ON a.WorkID = b.WorkID
JOIN DM_WorkStutas c ON b.StandardID = c.StandardID
AND b.WorkStutasID = c.WorkStutasID
WHERE a.CLLevelID = 1
AND b.StandardID = 1
AND DATEPART(year, b.WorkYear) < $Year$
)
]]>
</select>
本文发布于:2025-04-05 22:40:00,感谢您对本站的认可!
本文链接:https://www.4u4v.net/it/1743864064584338.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
留言与评论(共有 0 条评论) |