public void merkezeiptalcekgonder(string Fisno)

        {

            try

            {

                if (Param.Param_SatisTabloAktif && Param.Param_SatisTabloGonderi > 0)

                {

                    DataTable dataTable = dbtools.SelectTableR($"select * from Cst_Satis_Ipt where Rsat_Fisno='{Fisno}'");

                    if (dataTable == null || dataTable.Rows.Count == 0) return;

                    using (SqlConnection destinationConnection = new SqlConnection(connstr))

                    {

                        destinationConnection.Open();

                        using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection))

                        {

                            bulkCopy.DestinationTableName = "Cst_Satis_Ipt"; // hedef tablo adı

                            // Kolon eşleştirmelerini belirt (eğer adlar birebirse bu adım gerekmez ama önerilir)

                            foreach (DataColumn column in dataTable.Columns)

                            {

                                bulkCopy.ColumnMappings.Add(column.ColumnName, column.ColumnName);

                            }

                            // Veriyi gönder

                            bulkCopy.WriteToServer(dataTable);

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                // Hata loglanabilir

                Console.WriteLine("Hata oluştu: " + ex.Message);

            }

        }