ibatis.net中insert返回主键

最新推荐文章于 2024-09-03 17:37:40 发布

weixin_33721344

最新推荐文章于 2024-09-03 17:37:40 发布

阅读量95

点赞数

文章标签： python

原文链接：https://my.oschina.net/CrazyBoy1024/blog/698259

版权

2019独角兽企业重金招聘Python工程师标准>>>

1.sqlmap：

在<insert>中添加<select>节点，resultClass为返回的字段类型

主键为ClientID

<insert id="InsertClient" resultMap="ClientList">
insert into TSos_ClientInfo(ClientNo,ShortName,FullName,Type,ClientManager,Address,InvoiceInformation,remar)values(#ClientNo#,#ShortName#,#FullName#,#Type#,#ClientManager#,#Address#,#InvoiceInformation#,#Remar#)
   <selectKey resultClass="int" type="post" property="ClientID">
       select @@IDENTITY  as value
   </selectKey>
</insert>

2.BLL:

返回主键=(int)SqlMap.Insert("selectID", object);

 public int InsertClient(string ClientInfo, DateTime edittime)
        {

            string[] list = ClientInfo.Split('^');
            Model.Table.Client client = new Model.Table.Client();
            client.ClientNo = list[0].ToString();
            client.Type = list[1].ToString();
            client.ShortName = list[2].ToString();
            client.FullName = list[3].ToString();
            client.ClientManager = list[4].ToString();
            client.Address = list[5].ToString();
            client.InvoiceInformation = list[6].ToString();
            client.Remar = list[7].ToString();
            client.EditTime = edittime;
            int ClientID = (int)SqlMap.Insert("InsertClient", client);
            return ClientID;
        }

转载于:https://my.oschina.net/CrazyBoy1024/blog/698259