IBatis.Net中既有In查询又有其他参数传入，怎么办

最新推荐文章于 2017-12-07 12:27:14 发布

安欧碰麦蔻德

最新推荐文章于 2017-12-07 12:27:14 发布

阅读量2.2k

点赞数

本文链接：https://blog.csdn.net/UnOpenMyCode/article/details/30494751

版权

1.先扩展一个参数实体：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MyDemo.com.Model
{
    public class ParameterClassEx
    {
        public string field1 { get; set; }
        public string[] ArrValue { get; set; }
    }
}

2.IBatis配置文件参数文件编写

 <typeAlias alias="ParameterClassEx" type="MyDemo.com.Model.ParameterClassEx,MyDemo.com.Model"/>

3.IBatis配置文件操作文件编写

<!--删除我的购物车(主表)-->
    <delete id="DeleteShopCartByIDs" parameterClass="ParameterClassEx">
      <![CDATA[Delete From Shop_ShoppingCart Where UserID=#field1# and ShopCartID in ]]>     
      <iterate open="(" close=")" conjunction="," property="ArrValue" >
          #ArrValue[]#
      </iterate>      
    </delete>
    <!--删除我的购物车(明细)-->
    <delete id="DeleteShopCartPaperDetailByIDs" parameterClass="ParameterClassEx">
      <![CDATA[Delete From Shop_ShoppingCartPaperDetail Where ShopCartID in ]]>
      <iterate open="(" close=")" conjunction="," property="ArrValue" >
        #ArrValue[]#
      </iterate>
    </delete>

4.业务逻辑层C#:

 public string DeleteShoppingCarts(ParameterClassEx shopCartIDs)
        {
            string resultMsg = "";
            ISqlMapper iSqlMapper = Mapper.Instance();
            if (iSqlMapper != null)
            {
                iSqlMapper.BeginTransaction();
                try
                {
                    iSqlMapper.Delete("DeleteShopCartByIDs", shopCartIDs);
                    iSqlMapper.Delete("DeleteShopCartPaperDetailByIDs", shopCartIDs);
                 

                    iSqlMapper.CommitTransaction();
                    resultMsg = "删除购物车成功！";
                }
                catch (Exception exp)
                {
                    resultMsg = exp.ToString();
                    iSqlMapper.RollBackTransaction();
                }
            }
            return resultMsg;
        }