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