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); }