ExecuteSqlTran(Hashtable SQLStringList)使用

最新推荐文章于 2022-04-11 11:18:02 发布

small_Y

最新推荐文章于 2022-04-11 11:18:02 发布

阅读量2.1k

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/yzl21061/article/details/17399175

版权

sql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

/// <summary>
        /// 执行多条SQL语句，实现数据库事务。
        /// </summary>
        /// <param name="SQLStringList">SQL语句的哈希表（key为sql语句，value是该语句的SqlParameter[]）</param>
        public static void ExecuteSqlTran(Hashtable SQLStringList)
        {
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    SqlCommand cmd = new SqlCommand();
                    try
                    {
                        //循环
                        foreach (DictionaryEntry myDE in SQLStringList)
                        {
                            string     cmdText=myDE.Key.ToString();
                            SqlParameter[] cmdParms=(SqlParameter[])myDE.Value;
                            PrepareCommand(cmd,conn,trans,cmdText, cmdParms);
                            int val = cmd.ExecuteNonQuery();
                            cmd.Parameters.Clear();

                            trans.Commit();
                        }
                    }
                    catch
                    {
                        trans.Rollback();
                        throw;
                    }
                }
            }
        }

eg:

Hashtable SQLStringList = new Hashtable();
string cmdText = "insert into userinfo (username,userpwd)values(@username,@userpwd) ";
SqlParameter[] cmdParms = new SqlParameter[2];
cmdParms[0] = new SqlParameter( "@username ", "name ");
cmdParms[1] = new SqlParameter( "@userpwd ", "pwd ");
....
SQLStringList.Add(cmdText, cmdParms);
ExecuteSqlTran(SQLStringList);