C#中事务的用法。

最新推荐文章于 2024-06-25 16:58:01 发布

VisageNocturne

最新推荐文章于 2024-06-25 16:58:01 发布

阅读量339

点赞数

文章标签： c#

原文链接：https://blog.csdn.net/weixin_44758276/article/details/111469650?ops_request_misc=&request_id=&biz_id=102&utm_term=C#%25E4%25BA%258B%25E5%258A%25A1&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-3-111469650.first_rank_v2_pc_

版权

using (var conn = new SqlConnection(connectionString))
            {
                conn.Open(); 
                using (IDbTransaction tran = conn.BeginTransaction())
                {
                    try
                    {
                        flag = await conn.ExecuteAsync(Applysql, Item, tran) > 0;
                        if (Item.Status==1)
                        {
                            flag = await conn.ExecuteAsync(Usersql, Item, tran) > 0;
                            var list = await userRepository.Get(new User() { Id = Item.Creater });
                            String hingeString = JsonConvert.SerializeObject(list);
                            flag = GetuiHelper.Send(Item.Creater, hingeString);
                           
                        }
                        flag = await conn.ExecuteAsync(Enterprisesql, Item, tran) > 0;
                        tran.Commit();提交事务
                        conn.Close();
                    }
                    catch (Exception ex)
                    {
                        flag = false;
                        tran.Rollback();回滚事务
                        conn.Close();
                    }
                }
            }