{

            //Показать все записи таблицы

            vMAGAZINEBindingSource.Filter = "";

        } 

        private void button53_Click(object sender, EventArgs e)

        {

            //Удаление записи

            vMAGAZINEBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE DEL_EVENTS(:rn)", con, trans);

            com.Parameters.Add("rn", OleDbType.Char);

            com.Parameters["rn"].Value = textBox72.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.vMAGAZINETableAdapter.Fill(this.dataSet1.VMAGAZINE);

            con.Close();

            textBox72.Text = "";

        } 

        private void button55_Click(object sender, EventArgs e)

        {

            //Добавление записи

            vMAGAZINEBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE INS_MAGAZINE_EVENTS(:DATE_SOB, :TIME_V_EZD, :TIME_VYEZD, :RN_EMPLOYERS, :RN_TRANSPORT, :RN_MESTO)", con, trans);

            com.Parameters.Add("DATE_SOB", OleDbType.Char);

            com.Parameters["DATE_SOB"].Value = textBox81.Text;

            com.Parameters.Add("TIME_V_EZD", OleDbType.Char);

            com.Parameters["TIME_V_EZD"].Value = textBox80.Text;

            com.Parameters.Add("TIME_VYEZD", OleDbType.Char);

            com.Parameters["TIME_VYEZD"].Value = textBox79.Text;

            com.Parameters.Add("RN_EMPLOYERS", OleDbType.Char);

            com.Parameters["RN_EMPLOYERS"].Value = textBox78.Text;

            com.Parameters.Add("RN_TRANSPORT", OleDbType.Char);

            com.Parameters["RN_TRANSPORT"].Value = textBox84.Text;

            com.Parameters.Add("RN_MESTO", OleDbType.Char);

            com.Parameters["RN_MESTO"].Value = textBox85.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.vMAGAZINETableAdapter.Fill(this.dataSet1.VMAGAZINE);

            con.Close();

            textBox81.Text = "";

            textBox80.Text = "";

            textBox79.Text = "";

            textBox78.Text = "";

            textBox84.Text = "";

            textBox85.Text = "";

        } 

        private void обновитьToolStripMenuItem_Click(object sender, EventArgs e)

        {

            //Обновление

            this.vMAGAZINETableAdapter.Fill(this.dataSet1.VMAGAZINE);

            this.eMPLOYERSTableAdapter.Fill(this.dataSet1.EMPLOYERS);

            this.mESTO_PARKINGTableAdapter.Fill(this.dataSet1.MESTO_PARKING);

            this.tRANSPORTTableAdapter.Fill(this.dataSet1.TRANSPORT);

            this.cLIENTSTableAdapter.Fill(this.dataSet1.CLIENTS);

        } 

        private void button54_Click(object sender, EventArgs e)

        {

            //Добавление записи

            vMAGAZINEBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE UPD_MAGAZINE(:rn, :DATE_SOB, :TIME_V_EZD, :TIME_VYEZD, :RN_EMPLOYERS, :RN_TRANSPORT, :RN_MESTO)", con, trans);

            com.Parameters.Add("rn", OleDbType.Char);

            com.Parameters["rn"].Value = textBox74.Text;

            com.Parameters.Add("DATE_SOB", OleDbType.Char);

            com.Parameters["DATE_SOB"].Value = textBox77.Text;

            com.Parameters.Add("TIME_V_EZD", OleDbType.Char);

            com.Parameters["TIME_V_EZD"].Value = textBox76.Text;

            com.Parameters.Add("TIME_VYEZD", OleDbType.Char);

            com.Parameters["TIME_VYEZD"].Value = textBox75.Text;

            com.Parameters.Add("RN_EMPLOYERS", OleDbType.Char);

            com.Parameters["RN_EMPLOYERS"].Value = textBox73.Text;

            com.Parameters.Add("RN_TRANSPORT", OleDbType.Char);

            com.Parameters["RN_TRANSPORT"].Value = textBox83.Text;

            com.Parameters.Add("RN_MESTO", OleDbType.Char);

            com.Parameters["RN_MESTO"].Value = textBox86.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.vMAGAZINETableAdapter.Fill(this.dataSet1.VMAGAZINE);

            con.Close();

            textBox74.Text = "";

            textBox77.Text = "";

            textBox76.Text = "";

            textBox75.Text = "";

            textBox73.Text = "";

            textBox83.Text = "";

            textBox86.Text = "";

        }

                         

    }

} 

 

Приложение  3. Листинг PHP приложения

 

index.html 

<HTML>

<HEAD>

<TITLE>АВТОПАРКОВКА</TITLE>

</HEAD>

<FRAMESET cols="18%,82%" border=3>

<FRAME src="menu.html"SCROLLING = NO noresize>