在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
要删除的字符串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> |
请发表评论