private void Head_Load(object sender, EventArgs e)
        {
            try
            {
                using (OracleConnection conn = new OracleConnection(GetConnectionString))
                {
                    conn.Open();
                    using (OracleTransaction tran = conn.BeginTransaction())
                    {
                        string insert_row_text = "BEGIN TECH.PSERVICE_CENTER.INSERT_ROW (IN_SERVICE_CENTER_TYPE_ID => :IN_SERVICE_CENTER_TYPE_ID,IN_NODE_ID => :IN_NODE_ID,IN_NAME => :IN_NAME,IN_NOTE => :IN_NOTE,IN_VISIBLE => :IN_VISIBLE,IN_ID => :IN_ID,OUT_ID => :OUT_ID); END;";
                        using (OracleCommand cmd_ins = new OracleCommand(insert_row_text, tran.Connection))
                        {
                            OracleParameter prmInsServCenterId = cmd_ins.Parameters.Add("IN_SERVICE_CENTER_TYPE_ID", OracleType.Number);
                            OracleParameter prmInsNodeId = cmd_ins.Parameters.Add("IN_NODE_ID", OracleType.Number);
                            OracleParameter prmInsName = cmd_ins.Parameters.Add("IN_NAME", OracleType.VarChar);
                            OracleParameter prmInsNote = cmd_ins.Parameters.Add("IN_NOTE", OracleType.VarChar);
                            OracleParameter prmInsVisible = cmd_ins.Parameters.Add("IN_VISIBLE", OracleType.Number);
                            OracleParameter prmInsInId = cmd_ins.Parameters.Add("IN_ID", OracleType.Number);
                            OracleParameter prmInsOutId = cmd_ins.Parameters.Add("OUT_ID", OracleType.Number);
                            prmInsOutId.Direction = ParameterDirection.Output;

                            cmd_ins.Transaction = tran;
                            try
                            {
                                using (OracleCommand cmd_check = new OracleCommand("select count(*) from tech.service_center where service_center_type_id=4 and node_id=:NODE_ID", tran.Connection))
                                {
                                    cmd_check.Transaction = tran;
                                    OracleParameter prmChkNodeId = cmd_check.Parameters.Add("NODE_ID", OracleType.Number);
                                    using (DataTable tbl = new DataTable())
                                    {
                                        using (OracleDataAdapter adap = new OracleDataAdapter("", tran.Connection))
                                        {
                                            adap.SelectCommand.Transaction = tran;
                                            adap.SelectCommand.CommandText = "select sc.id sc_id,sc.node_id,t.name town_name " +
                                                                             "from tech.service_center sc,tech.node n,db.town t " +
                                                                             "where   sc.node_id=n.id and n.town_id=t.id " +
                                                                                 "and sc.service_center_type_id=4 " +
                                                                                 "and sc.id<=2206 " +
                                                                             "order by sc.id, sc.node_id";
                                            adap.Fill(tbl);
                                        }

                                        foreach (DataRow row in tbl.Rows)
                                        {
                                            prmChkNodeId.Value = row["node_id"];
                                            if (Convert.ToInt32(cmd_check.ExecuteScalar()) == 1)
                                            {
                                                System.Diagnostics.Debug.WriteLine("Будем работать с " + row["town_name"].ToString());
                                                prmInsServCenterId.Value = 4;
                                                prmInsNodeId.Value = row["node_id"];
                                                prmInsNote.Value = "";
                                                prmInsVisible.Value = 1;

                                                prmInsName.Value = "New рабочее место";
                                                prmInsInId.Value = DBNull.Value;
                                                prmInsOutId.Value = DBNull.Value;
                                                cmd_ins.ExecuteNonQuery();
                                                //prmInsName.Value =
                                            }
                                        }
                                    }
                                }
                                //tran.Commit();
                            }
                            catch (Exception ex)
                            {
                                tran.Rollback();
                                throw ex;
                            }

                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }