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); }
public static void FormTable(dbReader reader, DataGridView dataGridView1) { Conn.SQLDA.SelectCommand.CommandText = "select * from Readers..Main where NumberReader = " + reader.id; Conn.SQLDA.SelectCommand.Connection = Conn.ZakazCon; DataSet DS = new DataSet(); Conn.SQLDA.Fill(DS, "lll"); dataGridView1.Columns.Add("value", ""); dataGridView1.ColumnHeadersVisible = false; dataGridView1.RowHeadersWidth = 296; dataGridView1.Columns[0].Width = 436; int i = 0; Dictionary <string, string> FieldsCaptions = new Dictionary <string, string>(); Conn.SQLDA.SelectCommand.CommandText = " USE Readers; " + "SELECT " + " [Table Name] = OBJECT_NAME(c.object_id), " + " [Column Name] = c.name, " + " [Description] = ex.value " + " FROM " + " sys.columns c " + " LEFT OUTER JOIN " + " sys.extended_properties ex " + " ON " + " ex.major_id = c.object_id " + " AND ex.minor_id = c.column_id " + " AND ex.name = 'MS_Description' " + " WHERE " + " OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 " + " AND OBJECT_NAME(c.object_id) = 'Main' " + " ORDER " + " BY OBJECT_NAME(c.object_id), c.column_id;"; Conn.SQLDA.SelectCommand.Connection = Conn.ZakazCon; //DataSet DS = new DataSet(); Conn.SQLDA.Fill(DS, "fldcap"); foreach (DataRow r in DS.Tables["fldcap"].Rows) { FieldsCaptions.Add(r["Column Name"].ToString(), r["Description"].ToString()); } foreach (DataColumn col in DS.Tables["lll"].Columns) { if ((col.ColumnName == "AbonementType") || (col.ColumnName == "SheetWithoutCard") || (col.ColumnName == "Password") || (col.ColumnName == "FamilyNameFind") || (col.ColumnName == "NameFind") || (col.ColumnName == "FatherNameFind") || (col.ColumnName == "Interest") || (col.ColumnName == "DocumentNumber") || (col.ColumnName == "DateRegistration") || (col.ColumnName == "DateReRegistration") || (col.ColumnName == "MobileTelephone") || (col.ColumnName == "WorkCity") || (col.ColumnName == "WorkName") || (col.ColumnName == "WorkPosition") || (col.ColumnName == "WorkTelephone") || (col.ColumnName == "WorkTelephoneAdd") || (col.ColumnName == "WorkDepartment") || (col.ColumnName == "RegistrationPostOffice") || (col.ColumnName == "RegistrationCountry") || (col.ColumnName == "RegistrationRegion") || (col.ColumnName == "RegistrationProvince") || (col.ColumnName == "RegistrationDistrict") || (col.ColumnName == "RegistrationCity") || (col.ColumnName == "RegistrationStreet") || (col.ColumnName == "RegistrationHouse") || (col.ColumnName == "RegistrationFlat") || (col.ColumnName == "RegistrationTelephone") || (col.ColumnName == "LivePostOffice") || (col.ColumnName == "LiveCountry") || (col.ColumnName == "LiveRegion") || (col.ColumnName == "LiveProvince") || (col.ColumnName == "LiveDistrict") || (col.ColumnName == "LiveCity") || (col.ColumnName == "LiveStreet") || (col.ColumnName == "LiveHouse") || (col.ColumnName == "LiveFlat") || (col.ColumnName == "LiveTelephone") || (col.ColumnName == "WordReg") || (col.ColumnName == "Email") || (col.ColumnName == "NumberSC") || (col.ColumnName == "SerialSC") || (col.ColumnName == "Document") || (col.ColumnName == "ClassInfringer") || (col.ColumnName == "SheetWithoutCardData") || (col.ColumnName == "SpecialNote") || (col.ColumnName == "EditorCreate") || (col.ColumnName == "EditorEnd") || (col.ColumnName == "EditEndDate") || (col.ColumnName == "EditorNow") || (col.ColumnName == "SelfRecord") || (col.ColumnName == "ReRegistration") || (col.ColumnName == "AbonementType") || (col.ColumnName == "InBlackList") || (col.ColumnName == "Photo") || (col.ColumnName == "InputAlwaysDate") ) { continue; } dataGridView1.Rows.Add(); dataGridView1.Rows[i].HeaderCell.Value = FieldsCaptions[col.ColumnName]; string value = DS.Tables["lll"].Rows[0][col].ToString(); value = MethodsForCurBase.GetValueFromList(col.ColumnName, value); value = MethodsForCurBase.GetRightBoolValue(value); if (DS.Tables["lll"].Rows[0][col].GetType() == typeof(DateTime)) { value = ((DateTime)DS.Tables["lll"].Rows[0][col]).ToShortDateString(); } if (dataGridView1.Rows[i].HeaderCell.Value.ToString() == "Инвалидность") { if (value == "1") { value = "нет"; } else { value = "да"; } } dataGridView1.Rows[i].Cells[0].Value = value; i++; } /*Conn.SQLDA.SelectCommand.CommandText = "select B.NameInterest intr from Readers..Interest A inner join Readers..InterestList B on A.IDInterest = B.IDInterest where IDReader = " + reader.id; * Conn.SQLDA.Fill(DS, "itrs"); * foreach (DataRow r in DS.Tables["itrs"].Rows) * { * dataGridView1.Rows.Add(); * dataGridView1.Rows[i].HeaderCell.Value = "Интерес"; * dataGridView1.Rows[i].Cells[0].Value = r["intr"].ToString(); * i++; * } * Conn.SQLDA.SelectCommand.CommandText = "select B.NameLanguage lng from Readers..Language A inner join Readers..LanguageList B on A.IDLanguage = B.IDLanguage where IDReader = " + reader.id; * Conn.SQLDA.Fill(DS, "lng"); * foreach (DataRow r in DS.Tables["lng"].Rows) * { * dataGridView1.Rows.Add(); * dataGridView1.Rows[i].HeaderCell.Value = "Язык"; * dataGridView1.Rows[i].Cells[0].Value = r["lng"].ToString(); * i++; * }*/ Conn.SQLDA.SelectCommand.CommandText = "select B.SHORTNAME dep from Readers..ReaderRight A inner join BJVVV..LIST_8 B on A.IDOrganization = B.ID where A.IDReader = " + reader.id; Conn.SQLDA.Fill(DS, "d"); foreach (DataRow r in DS.Tables["d"].Rows) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].HeaderCell.Value = "Отдел (если сотрудник)"; dataGridView1.Rows[i].Cells[0].Value = r["dep"].ToString(); i++; } }
public static void FormTable(ReaderVO reader, DataGridView dataGridView1) { SqlDataAdapter SQLDA = new SqlDataAdapter(); SQLDA.SelectCommand = new SqlCommand(); SQLDA.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/CirculationFCC")); SQLDA.SelectCommand.CommandText = "select * from Readers..Main where NumberReader = " + reader.ID; DataSet DS = new DataSet(); SQLDA.Fill(DS, "lll"); dataGridView1.Columns.Add("value", ""); dataGridView1.ColumnHeadersVisible = false; dataGridView1.RowHeadersWidth = 296; dataGridView1.Columns[0].Width = 436; int i = 0; Dictionary <string, string> FieldsCaptions = new Dictionary <string, string>(); SQLDA.SelectCommand.CommandText = " USE Readers; " + "SELECT " + " [Table Name] = OBJECT_NAME(c.object_id), " + " [Column Name] = c.name, " + " [Description] = ex.value " + " FROM " + " sys.columns c " + " LEFT OUTER JOIN " + " sys.extended_properties ex " + " ON " + " ex.major_id = c.object_id " + " AND ex.minor_id = c.column_id " + " AND ex.name = 'MS_Description' " + " WHERE " + " OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 " + " AND OBJECT_NAME(c.object_id) = 'Main' " + " ORDER " + " BY OBJECT_NAME(c.object_id), c.column_id;"; SQLDA.Fill(DS, "fldcap"); foreach (DataRow r in DS.Tables["fldcap"].Rows) { FieldsCaptions.Add(r["Column Name"].ToString(), r["Description"].ToString()); } foreach (DataColumn col in DS.Tables["lll"].Columns) { if ((col.ColumnName == "Document") || (col.ColumnName == "DocumentNumber") || (col.ColumnName == "Photo") || (col.ColumnName == "Photo") || (col.ColumnName == "AbonementType") || (col.ColumnName == "SheetWithoutCard") || (col.ColumnName == "Password") || (col.ColumnName == "FamilyNameFind") || (col.ColumnName == "NameFind") || (col.ColumnName == "FatherNameFind") || (col.ColumnName == "Interest")) { continue; } dataGridView1.Rows.Add(); dataGridView1.Rows[i].HeaderCell.Value = FieldsCaptions[col.ColumnName]; string value = DS.Tables["lll"].Rows[0][col].ToString(); value = MethodsForCurBase.GetValueFromList(col.ColumnName, value); value = MethodsForCurBase.GetRightBoolValue(value); if (DS.Tables["lll"].Rows[0][col].GetType() == typeof(DateTime)) { value = ((DateTime)DS.Tables["lll"].Rows[0][col]).ToShortDateString(); } dataGridView1.Rows[i].Cells[0].Value = value; i++; } /*SQLDA.SelectCommand.CommandText = "select B.NameInterest intr from Readers..Interest A inner join Readers..InterestList B on A.IDInterest = B.IDInterest where IDReader = " + reader.ID; * SQLDA.Fill(DS, "itrs"); * foreach (DataRow r in DS.Tables["itrs"].Rows) * { * dataGridView1.Rows.Add(); * dataGridView1.Rows[i].HeaderCell.Value = "Интерес"; * dataGridView1.Rows[i].Cells[0].Value = r["intr"].ToString(); * i++; * }*/ /*SQLDA.SelectCommand.CommandText = "select B.NameLanguage lng from Readers..Language A inner join Readers..LanguageList B on A.IDLanguage = B.IDLanguage where IDReader = " + reader.ID; * SQLDA.Fill(DS, "lng"); * foreach (DataRow r in DS.Tables["lng"].Rows) * { * dataGridView1.Rows.Add(); * dataGridView1.Rows[i].HeaderCell.Value = "Язык"; * dataGridView1.Rows[i].Cells[0].Value = r["lng"].ToString(); * i++; * }*/ }