无为清净楼资源网 Design By www.qnjia.com
要删除的字符串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>
标签:
批量删除,Ibatis.net

无为清净楼资源网 Design By www.qnjia.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
无为清净楼资源网 Design By www.qnjia.com