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;
}