Додаток а. Лістинг програми Модуль авторизации

using System;

using Gtk;

using System.Data;

using System.IO;

using Npgsql;

namespace CCR_final

{

public partial class login : Gtk.Dialog

{

public login()

{

this.Build();

}

protected virtual void OnEntryPasswordTextInserted (object o, Gtk.TextInsertedArgs args)

{

NpgsqlConnection dbconnection = new NpgsqlConnection(MainClass.connect_string);

NpgsqlCommand dbcommand = dbconnection.CreateCommand();

NpgsqlDataReader reader;

string login_user = entry_login.Text;

string password_user = entry_password.Text;

string password_base = "";

string kod_user = "";

string sql = string.Format("SELECT * from users where login='{0}'", login_user);

dbconnection.Open();

dbcommand.CommandText=sql;

reader = dbcommand.ExecuteReader();

while (reader.Read())

{

password_base=reader.GetString(reader.GetOrdinal("password"));

kod_user = reader.GetString(reader.GetOrdinal("kode_user"));

}

MainClass.working_user = kod_user;

if (password_user == password_base)

{

buttonOk.Show();

buttonOk.GrabFocus();

dbconnection.Close();

dbcommand.Dispose();

reader.Close();

}

}

Модуль Платежное паручение

using System;

using Gtk;

using System.Data;

using System.IO;

using Npgsql;

namespace PD

{

public partial class reg_schet : Gtk.Window

{

// Действие по нажатию кнопки "Отмена"

protected virtual void OnButtonCancelClicked (object sender, System.EventArgs e)

{

this.Hide();

}

public void insert_values ()

{

NpgsqlConnection dbconnection = new NpgsqlConnection(MainClass.connect_string);

NpgsqlCommand dbcommand = dbconnection.CreateCommand();

NpgsqlDataReader reader;

string sql = string.Format("SELECT * FROM PD WHERE kod_klienta='{0}';", MainClass.vibranii_klient);

dbconnection.Open();

dbcommand.CommandText=sql;

reader = dbcommand.ExecuteReader();

while (reader.Read())

{

entry_kod_klient.Text=reader.GetString(reader.GetOrdinal("nomer_kl"));

entry_fio_klient.Text=reader.GetString(reader.GetOrdinal("predpr"));

}

dbconnection.Close();

dbcommand.Dispose();

reader.Close();

}

public reg_schet() :

base(Gtk.WindowType.Toplevel)

{

this.Build();

NpgsqlConnection dbconnection = new NpgsqlConnection(MainClass.connect_string);

NpgsqlCommand dbcommand = dbconnection.CreateCommand();

NpgsqlDataReader reader;

//Заполнение р/с

combobox_val.Clear();

CellRendererText cr = new CellRendererText();

combobox_val.PackStart(cr, false);

combobox_val.AddAttribute(cr, "text", 0);

cr = new CellRendererText();

combobox_val.PackStart(cr, false);

combobox_val.AddAttribute(cr, "text", 1);

ListStore ls = new ListStore(typeof(string), typeof(string));

combobox_val.Model = ls;

dbconnection.Open();

string combo_query = "SELECT * from schet;";

dbcommand.CommandText=combo_query;

reader = dbcommand.ExecuteReader();

while (reader.Read())

{

string kod = reader.GetString(reader.GetOrdinal("kod_schet"));

string name = reader.GetString(reader.GetOrdinal("name_bank"));

ls.AppendValues(kod, name);

}

combobox_val.Active = 0;

dbconnection.Close();

dbcommand.Dispose();

reader.Close();

// Событие по нажатию кнопки выбрать предприятия

protected virtual void OnButtonSelectKlientClicked (object sender, System.EventArgs e)

{

PD_final.vibar_klientov viborklientawindow = new PD_final.vibar_klientov();

MainClass.vibranii_klient="";

viborklientawindow.Modal=true;

viborklientawindow.Show();

this.Hide();

if (MainClass.vibranii_klient != "")

{

insert_values();

}

}

// запись в базу

sql = string.Format("INSERT INTO accounts (nomer_scheta, kov_valuta, open_date, last_mod_date, kod_ispolnitelya, name_scheta, limit_scheta, proz_stavka, balans, kod_klienta) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', {6}, {7}, {8}, '{9}');", nomer_scheta, combobox_val.ActiveText, date, date, MainClass.working_user, name_scheta, limit, proz_stavka, 0, MainClass.vibranii_klient);

dbconnection.Open();

dbcommand.CommandText=sql;

dbcommand.ExecuteNonQuery();

dbconnection.Close();

dbcommand.Dispose();

}