此 SqlTransaction 已完成；它再也无法使用。


        public static bool InStock(SqlParameter[] OrderParas, List<SqlParameter[]> InStockParas, DataTable DetailTable)
        {
            bool _pass = false;
            string connectString = Encrypt.DecryptString(System.Configuration.ConfigurationManager.AppSettings["ConnetString"]);
            using (SqlConnection Conn = new SqlConnection(connectString))
            {
                Conn.Open();                using (SqlTransaction Tran = Conn.BeginTransaction())
                {
                    try
                    {
                        using (SqlCommand Comm = new SqlCommand())
                        {
                            Comm.Transaction = Tran;
                            Comm.Connection = Conn;
                            Comm.CommandType = CommandType.StoredProcedure;
                           
                            Comm.CommandText = "p_OutOrderStateUpdate_Update";
                            Comm.Parameters.AddRange(OrderParas);
                            Comm.ExecuteNonQuery();
                            
                            Comm.CommandText = "p_ProductsInStorage_Insert";                            for (int j = 0; j < InStockParas.Count; j++)
                            {
                                Comm.Parameters.Clear();
                                Comm.Parameters.AddRange(InStockParas[j]);
                                Comm.ExecuteNonQuery();
                            }
                        }                        using (SqlBulkCopy copy = new SqlBulkCopy(Conn, SqlBulkCopyOptions.CheckConstraints, Tran) { DestinationTableName = "tbInStockDetail" })
                        {
                            for (int i = 0; i < DetailTable.Columns.Count; i++)
                            {
                                copy.ColumnMappings.Add(DetailTable.Columns[i].ColumnName, DetailTable.Columns[i].ColumnName);
                            }
                            copy.WriteToServer(DetailTable);
                        }
                        Tran.Commit();
                        _pass = true;
                    }
                    catch (Exception ex)
                    {
                        Tran.Rollback();
                        throw new Exception(ex.ToString());
                    }
                }
            }
            return _pass;
        }
在copy.WriteToServer(DetailTable);时跳到catch错误是"在从服务器接收结果时发生传输级错误。 (provider: TCP 提供程序, error: 0 - 指定的网络名不再可用。)"然后,Tran.Rollback();提示此 SqlTransaction 已完成；它再也无法使用。不知是不是网络问题,ping服务器ip基本没有掉包和能查询请问应该怎么解决呢...