/// <summary>
        /// 执行查询
        /// </summary>
        /// <param name="Querys">T-SQL语句的List泛型集合 T是string </param>
        /// <returns>返回影响行数</returns>
        public static int ExecuteNonQuery(List<string> Querys)
        {
            using (SqlConnection con = new SqlConnection(connectionString))
            {
                using (SqlCommand com = new SqlCommand())
                {
                    com.Connection = con;
                    con.Open();
                    SqlTransaction sqlTran = con.BeginTransaction();
                    try
                    {
                        com.Transaction = sqlTran;
                        int row = 0; ;
                        foreach (string str in Querys)
                        {
                            if (str.Length > 1)
                            {
                                com.CommandText = str;
                                row += com.ExecuteNonQuery();
                            }
                        }
                        sqlTran.Commit();
                        con.Close();
                        com.Clone();
                        con.Dispose();
                        com.Dispose();
                        return row;
                    }
                    catch (SqlException e)
                    {
                        sqlTran.Rollback();
                        throw new Exception(e.Message);
                    }
                }
            }
        }