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