Ibatis.net结合oracle批量删除实现代码
383人浏览 / 0人评论
要删除的字符串ID为
string SDSALES_IDString = 1,2,3,4,5,6,7
//转成Array
Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray();
在模型定义一个 public Array SDSALES_IDs {get;set;}
XML：
DELETE FROM T_LABEL_SDSALES WHERE
SDSALES_ID IN
#SDSALES_IDs[]#
复制代码 代码如下:
string SDSALES_IDString = 1,2,3,4,5,6,7
//转成Array
Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray();
在模型定义一个 public Array SDSALES_IDs {get;set;}
XML：
复制代码 代码如下:
DELETE FROM T_LABEL_SDSALES WHERE
SDSALES_ID IN
#SDSALES_IDs[]#
您可能感兴趣的文章:
微信公众号
关注微信公众号获取更多VSCode编程信息，定时发布干货文章
全部评论