public Form9(dbReader reader_)
{
InitializeComponent();
reader = reader_;
label2.Text = reader.FIO;
MethodsForCurBase.FormTable(reader, dataGridView1);
}
public ReaderInformation(ReaderVO reader_, Form1 f1_)
{
InitializeComponent();
f1 = f1_;
reader = reader_;
label2.Text = reader.FIO;
pictureBox1.Image = reader.Photo;
MethodsForCurBase.FormTable(reader, dataGridView1);
//DisplayCommNote();
//RegInMos();
label6.Text = "Дата последней отправки письма: " + reader.GetLastDateEmail();
}
private bool FindReaderInOldBase(dbReader reader)
{
Conn.SQLDA.SelectCommand.CommandText = " select * from AbonOld..Main " +
" where lower(FullName) like ltrim(rtrim( (lower('" +
reader.Surname + " " + reader.Name + " " + reader.SecondName + " " + "'))))+'%' ";
DataSet DS = new DataSet();
int cnt = Conn.SQLDA.Fill(DS, "old");
if (cnt == 0)
{
return(false);
}
dataGridView1.DataSource = DS.Tables["old"];
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Номер читателя";
dataGridView1.Columns[2].HeaderText = "ФИО";
dataGridView1.Columns[3].HeaderText = "Дата рождения";
dataGridView1.Columns[4].HeaderText = "Документ";
dataGridView1.Columns[5].HeaderText = "Вид абонемента";
dataGridView1.Columns[6].HeaderText = "Телефон";
dataGridView1.Columns[7].HeaderText = "Учебное заведение";
dataGridView1.Columns[8].HeaderText = "Адрес";
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[9].HeaderText = "Индекс";
dataGridView1.Columns[10].HeaderText = "Страна";
dataGridView1.Columns[11].HeaderText = "Область";
dataGridView1.Columns[12].HeaderText = "Город";
dataGridView1.Columns[13].HeaderText = "Улица";
dataGridView1.Columns[14].HeaderText = "Дом";
dataGridView1.Columns[15].HeaderText = "Индекс2";
dataGridView1.Columns[16].HeaderText = "Страна2";
dataGridView1.Columns[17].HeaderText = "Область2";
dataGridView1.Columns[18].HeaderText = "Город2";
dataGridView1.Columns[19].HeaderText = "Улица2";
dataGridView1.Columns[20].HeaderText = "Дом2";
dataGridView1.Columns[21].HeaderText = "Дата регистрации";
dataGridView1.Columns[22].HeaderText = "Дата перерегистрации";
dataGridView1.Columns[23].HeaderText = "Потерян";
dataGridView1.Columns[24].HeaderText = "Научная степень";
dataGridView1.Columns[25].HeaderText = "Отдел";
dataGridView1.Columns[26].HeaderText = "Сектор";
dataGridView1.Columns[27].HeaderText = "Номер комнаты";
dataGridView1.Columns[28].HeaderText = "Местонахождение";
dataGridView1.Columns[29].HeaderText = "Email";
dataGridView1.Columns[30].HeaderText = "Отделение библиотеки";
dataGridView1.Columns[31].HeaderText = "Коментарии";
dataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
MethodsForCurBase.FormTable(reader, dataGridView2);
return(true);
}
