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

要删除的字符串ID为
代码如下:

string SDSALES_IDString = 1,2,3,4,5,6,7 
//转成Array 
Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray<string>(); 
 
在模型定义一个 public Array SDSALES_IDs {get;set;} 
XML： 
 代码如下:

<delete id="DeleteManyT_LABEL_SDSALES" parameterClass="T_LABEL_SDSALES"> 
DELETE FROM T_LABEL_SDSALES WHERE 
<isNotNull property="SDSALES_IDs"> 
SDSALES_ID IN 
<iterate property="SDSALES_IDs" conjunction="," open="(" close=")"> 
#SDSALES_IDs[]# 
</iterate> 
</isNotNull> 
</delete> 

            
            


           
                
                                                

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！