1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

public static int ExecuteSqlBatch(List<string> listSql)

{

    using (var Db = GetInstance())

    {

        Db.Ado.BeginTran();

        try

        {

            foreach (var sql in listSql)

            {

                // 执行每条SQL语句

                var result = Db.Ado.ExecuteCommand(sql);

                if (result == -1)

                {

                    return 0;

                }

            }

            // 提交事务 

            Db.Ado.CommitTran();//.CommitTransaction();

            return 1;

        }

        catch (Exception ex)

        {

            // 发生异常，回滚事务 

            Db.Ado.RollbackTran();

            return 0;

        }

    };

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

public static void BulkInsert(List<SJ_EMR_INFO> entities)

{

    SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()

    {

        ConnectionString = ConfigurationManager.ConnectionStrings["MYDB"].ConnectionString,

        DbType = SqlSugar.DbType.SqlServer,//sqlserver、oracle、mysql

        IsAutoCloseConnection = true,

        InitKeyType = InitKeyType.Attribute

    });

    // 批量插入

    var insertObjs = db.Insertable(entities.ToArray());

    //批量更新

    //var updateObjs = db.Updateable(entities.ToArray());

    // 执行

    int count = insertObjs.ExecuteCommand();

}