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++; * }*/ }