Ibatis.net结合oracle批量删除实现代码

<br>string SDSALES_IDString = 1,2,3,4,5,6,7 <br>//转成Array <br>Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray<string>(); <br> <br>在模型定义一个 public Array SDSALES_IDs {get;set;} <br>XML： <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br><delete id="DeleteManyT_LABEL_SDSALES" parameterClass="T_LABEL_SDSALES"> <br>DELETE FROM T_LABEL_SDSALES WHERE <br><isNotNull property="SDSALES_IDs"> <br>SDSALES_ID IN <br><iterate property="SDSALES_IDs" conjunction="," open="(" close=")"> <br>#SDSALES_IDs[]# <br></iterate> <br></isNotNull> <br></delete> <br></li><li>            </li><li>                                </li></ol></pre>