C#执行添加事务

最新推荐文章于 2024-10-20 14:06:00 发布

原创最新推荐文章于 2024-10-20 14:06:00 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#c# #insert #list

C# 专栏收录该内容

64 篇文章

订阅专栏

/// <summary>
  /// 执行添加事务
  /// </summary>
  /// <param name="sqls"></param>
  /// <returns></returns>
  public int AddList(List<String> sqls)
  {

  return DbHelperSQL.ExecuteSqlTran(sqls);
  }

BLL.cs
/// <summary>
  /// 执行添加事务
  /// </summary>
  /// <param name="sqls"></param>
  /// <returns></returns>
  public bool AddList(List<M_Pact_ItemMoney> list)
  {

  List<String> sqls = new List<String>();
  foreach (M_Pact_ItemMoney model in list)
  {

  sqls.Add(@" insert into Pact_ItemMoney(PactCode,ItemName,ItemCent)  
  values  
  ('" + model.PactCode + @"','" + model.ItemName + @"','" + model.ItemCent + @"')");
  }

  if (dal.AddList(sqls) > 0)
  {
  return true;
  }
  else
  {
  return false;
  }
  }