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>