private void DownloadInBD()
{
try
{
Alco.AlcoholismPersona.Clear();
Narcoman.Drug_Addiction.Clear();
Polizavis.Alco_Narco_Person.Clear();
foreach (Alco alco in db.Alcos)
{
Alco.AlcoholismPersona.Add(alco);
}
foreach (Narcoman narc in db.Narcomans)
{
Narcoman.Drug_Addiction.Add(narc);
}
foreach (Polizavis poli in db.Polizaviss)
{
Polizavis.Alco_Narco_Person.Add(poli);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
ExcepLog.Excep(ex);
}
}
public static void CreatPerson(string fio, string position, string pass)
{
try
{
ApplicationContext db = new ApplicationContext();
db.Incitalizations.Load();
foreach (var item in db.Incitalizations)
{
Inci.Add(item);
}
int intId = 0;
for (int i = 0; i < Inci.Count; i++)
{
intId++;
}
Incitalization person = new Incitalization
{
Id = intId,
Name = fio,
Pass = pass,
Pasition = position
};
db.Incitalizations.Add(person);
db.SaveChanges();
MessageBox.Show("Регистрация прошла успешна");
db.Dispose();
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
/// <summary>
/// Добавляем в массив данных по персонал
/// </summary>
public static void Patient_Сreation_Person(string fio, string pass, string position)
{
try
{
Person newPerson = new Person();
if (Person.Persons.Count == 0)
{
int a = 1;
newPerson.Id = a;
}
for (int i = 0; i <= Person.Persons.Count; i++)
{
newPerson.Id = i + 1;
}
newPerson.FIO = fio;
newPerson.Pass = pass;
newPerson.Position = position;
Person.Persons.Add(newPerson);
Save_Excel_Person();
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
/// <summary>
/// Сохранение Колекции в Excel персонал
/// </summary>
public static void Save_Excel_Person()
{
try
{
string ExcelFilePath = @"D:\HelaMedical\HelaMedical\File\Person.xlsx";
Excel.Application excelApp = new Excel.Application();
Workbook workBook;
Worksheet workSheet;
workBook = excelApp.Workbooks.Open(ExcelFilePath);
workSheet = (Excel.Worksheet)workBook.Worksheets.get_Item(1);
// Получаем активную таблицу
for (int i = 0; i < Person.Persons.Count + 1; i++)
{
if (i == Person.Persons.Count)
{
int j = i - 1;
workSheet.Cells[i, 1] = Person.Persons[j].Id;
workSheet.Cells[i, 2] = Person.Persons[j].FIO;
workSheet.Cells[i, 3] = Person.Persons[j].Pass;
workSheet.Cells[i, 4] = Person.Persons[j].Position;
}
}
workBook.Save();
workBook.Close();
excelApp.Quit();
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
/// <summary>
/// загружаем полизавис из Excel в бд
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MenuItem_Download_Polizavis(object sender, RoutedEventArgs e)
{
try
{
bool check = false;
DownloadDBPoliz.ReadExcel_Poliz();
check = DownloadDBPoliz.Download_Poliz();
if (check)
{
MessageBox.Show("Запись в бд прошла успешно");
}
else
{
MessageBox.Show("Ошибка записи в бд");
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
finally
{
db.Dispose();
}
}
/// <summary>
/// Способ получить все записи из Excel персоналу
/// </ summary>
/// <Return> </ Return>
public static void Reader_Excel_Person()
{
try
{
string ExcelFilePath = @"D:\HelaMedical\HelaMedical\File\Person.xlsx";
Excel.Application excelApp = new Excel.Application();
Workbook workBook;
Worksheet workSheet;
Range range;
workBook = excelApp.Workbooks.Open(ExcelFilePath);
workSheet = (Worksheet)workBook.Worksheets.get_Item(1);
range = workSheet.UsedRange;
for (int cCnt = 1; cCnt <= range.Rows.Count; cCnt++)
{
Person persons = new Person();
persons.Id = Convert.ToInt32(workSheet.Cells[cCnt, 1].Value);
persons.FIO = Convert.ToString(workSheet.Cells[cCnt, 2].Value);
persons.Position = Convert.ToString(workSheet.Cells[cCnt, 4].Value);
persons.Pass = Convert.ToString(workSheet.Cells[cCnt, 3].Value);
Person.Persons.Add(persons);
}
workBook.Close();
excelApp.Quit();
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
public static void Closed()
{
try
{
sqlConnection.Close(); // Закрываем соединение
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
public static void Generate_a_raport(List <Alco> alco, List <Narcoman> narco, List <Polizavis> poliz, String data, String type)
{
try
{
bool flag = false;
if (type == "Алкогольная")
{
for (int i = 0; i < Alco.AlcoholismPersona.Count; i++)
{
if (Alco.AlcoholismPersona[i].DataInfo == data)
{
alco.Add(Alco.AlcoholismPersona[i]);
}
}
ExcelDataServis.Save_Report_Excel_Alco(alco);
flag = true;
}
else if (type == "Наркотическая")
{
for (int i = 0; i < Narcoman.Drug_Addiction.Count; i++)
{
if (Narcoman.Drug_Addiction[i].DataInfo == data)
{
narco.Add(Narcoman.Drug_Addiction[i]);
}
}
ExcelDataServis.Save_Report_Excel_Narco(narco);
flag = true;
}
else if (type == "Полизависимость")
{
for (int i = 0; i < Polizavis.Alco_Narco_Person.Count; i++)
{
if (Polizavis.Alco_Narco_Person[i].DataInfo == data)
{
poliz.Add(Polizavis.Alco_Narco_Person[i]);
}
}
ExcelDataServis.Save_Report_Excel_Poliz(poliz);
flag = true;
}
if (flag)
{
MessageBox.Show("Данные записаны");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
ExcepLog.Excep(ex);
}
}
public static void Select(string ConnectionString) // функция подключения к базе данных и обработка запросов
{
try
{
sqlConnection = new SqlConnection(ConnectionString); // подключаемся к базе данны
sqlConnection.Open(); // открываем соединение
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
ExcepLog.Excep(ex);
}
}
public MainWindow()
{
try
{
ReadPerson.Reader_Excel_Person();
InitializeComponent();
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
/// <summary>
/// Вход в систему
/// </summary>
private void Button_Entry(object sender, RoutedEventArgs e)
{
try
{
bool c = false; // Для проверики наличия имени в массиве
string a = tb.Text;
string b = Convert.ToString(pass.Password);
// проверяем соответствие имени и пароля в системе
foreach (var sIncitalization in Person.Persons)
{
if (a == sIncitalization.FIO && b == sIncitalization.Pass)
{
c = true;
Incitalization reg = new Incitalization
{
Name = a
};
Incitalization.Registr.Add(reg);
Other.Regis = a; // запоминаем имя регистратора данных
break;
}
// имя не найдено
else
{
c = false;
}
}
// если в массиве нет имени
if (c == false)
{
MessageBox.Show("Неправельно введен логин или пароль");
tb.Clear(); // очищает поле логин
pass.Clear(); // очищает поле пароль
}
else
{
Interface iInterface = new Interface();
iInterface.Show();
Close();
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
return;
}
}
public MainWindow()
{
try
{
FileLoad();
db = new ApplicationContext();
db.Incitalizations.Load(); //загружаем из бд именна
InitializeComponent();
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
/// <summary>
/// Закрытие окна и закрытие связей с бд
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Generate_A_Report_Closing(object sender, CancelEventArgs e)
{
try
{
if (db != null)
{
db.Dispose();
}
DbContexte.DBConection.Closed();
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
/// <summary>
/// удалить пациента из БД
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_Button(object sender, RoutedEventArgs e)
{
try
{
if (ListOrder.SelectedItems.Count > 0)
{
for (int i = 0; i < ListOrder.SelectedItems.Count; i++)
{
if (check_alco == true)
{
Alco alco = ListOrder.SelectedItems[i] as Alco;
if (alco != null)
{
db.Alcos.Remove(alco);
}
}
if (check_narco == true)
{
Narcoman narco = ListOrder.SelectedItems[i] as Narcoman;
if (narco != null)
{
db.Narcomans.Remove(narco);
}
}
if (check_poliz == true)
{
Polizavis poli = ListOrder.SelectedItems[i] as Polizavis;
if (poli != null)
{
db.Polizaviss.Remove(poli);
}
}
}
db.SaveChanges();
}
ListOrder.ItemsSource = null;
MessageBox.Show("Пациент удален");
}
catch (Exception ex)
{
ExcepLog.Excep(ex);
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Загрузка фаила с сервером
/// </summary>
public static void FileLoad()
{
try
{
string path = @"\HelaMedical\HelaMedical\File\INC.INI";
if (!File.Exists(path))
{
MessageBox.Show("Файл с нахождением информации по серверу не найден!" +
"\nУкажите место нахождение файла");
path = OpenFile.Open_File();
}
string s = File.ReadAllText(path);
DBConection.Select(s);
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
private void Next_Click(object sender, RoutedEventArgs e)
{
try
{
if (Other.Obl == "" || Other.Reg == "" || Other.Obl == null || Other.Reg == null)
{
MessageBox.Show("Не выбрали район");
return;
}
else
{
Close();
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
return;
}
}
/// <summary>
/// Записывает полизависимых в бд
/// </summary>
public static void Patient_Сreation_Alco_Narco(string fio, string sex, string data, string regionCenterBLR, string raenCentrBLR, string life, string age, string familyStatus,
string costOfKids, string familyComposition, string education, string profession, string theSkillLevelOfTheProfession, string addressOfRegistration,
string addressAtTheTimeOfDeath, string dataOfRegistration, string reRegistrationData, string typeOfRegistration, string heredity, string disabilityGroup,
string disabilityStatus, string reasonForDisability, string socialStatus, string admOtv, string ugOtv, string dlitMLS, string statja107, string statUKRB,
string rodPrav, string nomLTP, string LTPkol, string hosp, string EK, string dateOfDeregistration, string dateOfDead, string placeOfDead,
string deathCertificate, string causeOfDeat, string deathCategory, string openingPlace, string historyOfParasucicides, string featuresOfObservation,
string DrugDiagnosisAlc, string experienceAbuse, string AlcoholicDrinks, string intranozologicalComorbidity, string typeOfDrug, string drugUse,
string yearOfFirstUse, string experienceAbuseDrug, string remissions, string remissionNumber, string remissionTimer, string drugDiagnosisX, string ageOfDead,
string ageOfRegistration, string dataInfo)
{
try
{
ApplicationContext db = new ApplicationContext();
foreach (var item in db.Polizaviss)
{
Polizavis.Alco_Narco_Person.Add(item);
}
int IntId = 0;
for (int i = 0; i < Polizavis.Alco_Narco_Person.Count; i++)
{
IntId++;
}
Polizavis newPolizavis = new Polizavis
{
Id = IntId,
FIO = fio,
Sex = sex,
Date = data,
RegionCenterBLR = regionCenterBLR,
RaenCentrBLR = raenCentrBLR,
Life = life,
Age = age,
FamilyStatus = familyStatus,
CostOfKids = costOfKids,
FamilyComposition = familyComposition,
Education = education,
Profession = profession,
TheSkillLevelOfTheProfession = theSkillLevelOfTheProfession,
AddressOfRegistration = addressOfRegistration,
AddressAtTheTimeOfDeath = addressAtTheTimeOfDeath,
DataOfRegistration = dataOfRegistration,
ReRegistrationData = reRegistrationData,
TypeOfRegistration = typeOfRegistration,
Heredity = heredity,
DisabilityGroup = disabilityGroup,
DisabilityStatus = disabilityStatus,
ReasonForDisability = reasonForDisability,
WorksStatus = socialStatus,
AdmOtv = Convert.ToString(admOtv),
UgOtv = Convert.ToString(ugOtv),
DlitsMLS = Convert.ToString(dlitMLS),
Stat107 = statja107,
StatUKRB = statUKRB,
RodPrav = rodPrav,
NomLTP = nomLTP,
LTPKol = LTPkol,
Hospitel = hosp,
EK = EK,
DateOfDeregistration = dateOfDeregistration,
DateOfDead = dateOfDead,
PlaceOfDead = placeOfDead,
DeathCertificate = deathCertificate,
CauseOfDead = causeOfDeat,
DeathCategory = deathCategory,
OpeningPlace = openingPlace,
HistoryOfParasucicides = historyOfParasucicides,
FeaturesOfObservation = featuresOfObservation,
ExperienceAbuse = experienceAbuse,
AlcoholicDrinks = AlcoholicDrinks,
DrugDiagnosisAlc = DrugDiagnosisAlc,
IntranozologicalComorbidity = intranozologicalComorbidity,
TypeOfDrug = typeOfDrug,
DrugUse = drugUse,
YearOfFirstUse = yearOfFirstUse,
ExperienceAbuseDrug = experienceAbuseDrug,
Remissions = remissions,
RemissionNumber = remissionNumber,
RemissionTimer = remissionTimer,
DrugDiagnosisX = drugDiagnosisX,
AgeOfDead = ageOfDead,
AgeOfRegistration = ageOfRegistration,
DataInfo = dataInfo,
Registrotor = Other.Regis,
};
db.Polizaviss.Add(newPolizavis);
db.SaveChanges();
db.Dispose();
Polizavis.Alco_Narco_Person.Clear();
MessageBox.Show("Данные записаны");
}
catch (Exception excep)
{
MessageBox.Show("Произошла ошибка при добавленни данных в БД");
ExcepLog.Excep(excep);
}
}
/// <summary>
/// Поиск карты пациента
/// </summary>
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
check_alco = false;
check_narco = false;
check_poliz = false;
db = new ApplicationContext();
string findperson = FindPerson.Text;
//Очищаем память перед записью новой информации
alcoFindPerson.Clear();
narcoFindPerson.Clear();
polizFindPerson.Clear();
DownloadInBD();
//Ищим инфу в колекциях
for (int i = 0; i < Alco.AlcoholismPersona.Count; i++)
{
if (findperson == Alco.AlcoholismPersona[i].FIO)
{
check_alco = true;
alcoFindPerson.Add(Alco.AlcoholismPersona[i]);
}
}
for (int i = 0; i < Narcoman.Drug_Addiction.Count; i++)
{
if (findperson == Narcoman.Drug_Addiction[i].FIO)
{
check_narco = true;
narcoFindPerson.Add(Narcoman.Drug_Addiction[i]);
}
}
for (int i = 0; i < Polizavis.Alco_Narco_Person.Count; i++)
{
if (findperson == Polizavis.Alco_Narco_Person[i].FIO)
{
check_poliz = true;
polizFindPerson.Add(Polizavis.Alco_Narco_Person[i]);
}
}
if (check_alco == true)
{
//Выводим инфу на экран
ListOrder.ItemsSource = alcoFindPerson;
}
else if (check_narco == true)
{
ListOrder.ItemsSource = narcoFindPerson;
}
else if (check_poliz == true)
{
ListOrder.ItemsSource = polizFindPerson;
}
else if (check_alco == false && check_narco == false && check_poliz == false)
{
if (findperson == "Алкогольная зависимость" || findperson == "алкогольная зависимость" || findperson == "алко")
{
ListOrder.ItemsSource = db.Alcos.Local.ToBindingList();
}
else if (findperson == "Наркотическая зависимость" || findperson == "наркотическая зависимость" || findperson == "нарко")
{
ListOrder.ItemsSource = db.Narcomans.Local.ToBindingList();
}
else if (findperson == "Полизависимость" || findperson == "полизависимость" || findperson == "полиз")
{
ListOrder.ItemsSource = db.Polizaviss.Local.ToBindingList();
}
else
{
MessageBox.Show("ФИО не найдено");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
ExcepLog.Excep(ex);
}
}
/// <summary>
/// записываем алкоголика в бд
/// </summary>
public static void Patient_Сreation_Alco(string fio, string sex, string data, string regionCenterBLR, string raenCenterBLR, string life, string age, string familyStatus,
string costOfKids, string familyComposition, string education, string profession, string theSkillLevelOfTheProfession, string addressOfRegistration,
string addressAtTheTimeOfDeath, string dataOfRegistration, string reRegistrationData, string typeOfRegistration, string heredity, string disabilityGroup,
string disabilityStatus, string reasonForDisability, string socialStatus, string admOtv, string ugOtv, string dlitMLS, string statja107, string statUKRB,
string rodPrav, string nomLTP, string LTPkol, string hosp, string EK, string dateOfDeregistration, string dateOfDead, string placeOfDead,
string deathCertificate, string causeOfDeat, string deathCategory, string openingPlace, string historyOfParasucicides, string featuresOfObservation,
string DrugDiagnosisAlc, string experienceAbuse, string AlcoholicDrinks, string IComorbidity, string ageOfDead, string ageOfRegistration, string dataInfo)
{
try
{
ApplicationContext db = new ApplicationContext();
//считываем из бд в массив данных
foreach (var item in db.Alcos)
{
Alco.AlcoholismPersona.Add(item);
}
//иницилизируем переменную Id
int IntId = 0;
//считаем сколько записей в бд
for (int i = 0; i < Alco.AlcoholismPersona.Count; i++)
{
IntId++;
}
Alco newAlcoPerson = new Alco
{
Id = IntId,
FIO = fio,
Sex = sex,
Date = data,
RegionCenterBLR = regionCenterBLR,
RaenCenterBLR = raenCenterBLR,
Life = life,
Age = age,
FamilyStatus = familyStatus,
CostOfKids = costOfKids,
FamilyComposition = familyComposition,
Education = education,
Profession = profession,
TheSkillLevelOfTheProfession = theSkillLevelOfTheProfession,
AddressOfRegistration = addressOfRegistration,
AddressAtTheTimeOfDeath = addressAtTheTimeOfDeath,
DataOfRegistration = dataOfRegistration,
ReRegistrationData = reRegistrationData,
TypeOfRegistration = typeOfRegistration,
Heredity = heredity,
DisabilityGroup = disabilityGroup,
DisabilityStatus = disabilityStatus,
ReasonForDisability = reasonForDisability,
WorksStatus = socialStatus,
AdmOtv = admOtv,
UgOtv = ugOtv,
DlitsMLS = dlitMLS,
Stat107 = statja107,
StatUKRB = statUKRB,
RodPrav = rodPrav,
NomLTP = nomLTP,
LTPKol = LTPkol,
Hospitel = hosp,
EK = EK,
DateOfDeregistration = dateOfDeregistration,
DateOfDead = dateOfDead,
PlaceOfDead = placeOfDead,
DeathCertificate = deathCertificate,
CauseOfDead = causeOfDeat,
DeathCategory = deathCategory,
OpeningPlace = openingPlace,
HistoryOfParasucicides = historyOfParasucicides,
FeaturesOfObservation = featuresOfObservation,
ExperienceAbuse = experienceAbuse,
AlcoholicDrinks = AlcoholicDrinks,
IK = IComorbidity,
DrugDiagnosisAlc = DrugDiagnosisAlc,
AgeOfRegistration = ageOfRegistration,
AgeOfDead = ageOfDead,
DataInfo = dataInfo,
Registrotor = Other.Regis,
};
db.Alcos.Add(newAlcoPerson);
db.SaveChanges();
db.Dispose();
Alco.AlcoholismPersona.Clear();
MessageBox.Show("Данные записаны");
}
catch (Exception excep)
{
MessageBox.Show("Произошла ошибка при добавленни данных в БД");
ExcepLog.Excep(excep);
return;
}
}
/// <summary>
/// Добавление нового персонала
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void NewPersonalAdd_Click(object sender, RoutedEventArgs e)
{
try
{
int a = 0;
string fio = NewPersonalFIO.Text;
//проверяем пустое ли поле
if (fio == "")
{
NewPersonalFIO.BorderBrush = Brushes.Red;
MessageBox.Show("Не ввели ФИО");
return;
}
else
{
a++;
}
string position = NewPersonalPosition.Text;
if (position == "")
{
NewPersonalPosition.BorderBrush = Brushes.Red;
MessageBox.Show("Не ввели должность");
return;
}
else
{
a++;
}
string pass = NewPersonalPassword.Text;
if (pass == "")
{
NewPersonalPassword.BorderBrush = Brushes.Red;
MessageBox.Show("Не ввели пароль");
return;
}
else
{
a++;
}
string pass1 = NewPersonalPassword1.Text;
if (pass == "")
{
NewPersonalPassword1.BorderBrush = Brushes.Red;
MessageBox.Show("Не ввели повторно пароль");
return;
}
else
{
a++;
}
//Проверяем на наличие данного имени в базе
for (int i = 0; i < Inci.Count; i++)
{
if (fio == Inci[i].Name)
{
NewPersonalFIO.BorderBrush = Brushes.Red;
MessageBox.Show("Данное ФИО есть в базе");
return;
}
}
if (NewPersonalPassword.Text != NewPersonalPassword1.Text)
{
NewPersonalPassword.BorderBrush = Brushes.Red;
NewPersonalPassword1.BorderBrush = Brushes.Red;
MessageBox.Show("Пароли не совпадают");
return;
}
if (a <= 3)
{
return;
}
else
{
ReadPerson.Patient_Сreation_Person(fio, position, pass);
Close();
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
/// <summary>
/// Сохранение информации по выборке из отчета по алкогольной зависимости
/// </summary>
public static void Save_Report_Excel_Alco(List <Alco> alco)
{
try
{
int count = 0;
for (int i = 0; i < alco_col; i++)
{
count++;
}
if (count > 0)
{
string ExcelFilePath = @"D:\HelaMedical\HelaMedical\File\AlcoReport.xlsx";
Excel.Application excelApp = new Excel.Application();
Workbook workBook;
Worksheet workSheet;
workBook = excelApp.Workbooks.Open(ExcelFilePath);
workSheet = (Excel.Worksheet)workBook.Worksheets.get_Item(1);
// Получаем активную таблицу
for (int i = 1; i <= alco.Count; i++)
{
int j = i - 1;
workSheet.Cells[i, 1] = alco[j].Id;
workSheet.Cells[i, 2] = alco[j].FIO;
workSheet.Cells[i, 3] = alco[j].Sex;
workSheet.Cells[i, 4] = alco[j].Date;
workSheet.Cells[i, 5] = alco[j].RegionCenterBLR;
workSheet.Cells[i, 6] = alco[j].RaenCenterBLR;
workSheet.Cells[i, 6] = alco[j].Life;
workSheet.Cells[i, 7] = alco[j].Age;
workSheet.Cells[i, 8] = alco[j].FamilyStatus;
workSheet.Cells[i, 9] = alco[j].CostOfKids;
workSheet.Cells[i, 10] = alco[j].FamilyComposition;
workSheet.Cells[i, 11] = alco[j].Education;
workSheet.Cells[i, 12] = alco[j].Profession;
workSheet.Cells[i, 13] = alco[j].TheSkillLevelOfTheProfession;
workSheet.Cells[i, 14] = alco[j].AddressOfRegistration;
workSheet.Cells[i, 15] = alco[j].AddressAtTheTimeOfDeath;
workSheet.Cells[i, 16] = alco[j].DataOfRegistration;
workSheet.Cells[i, 17] = alco[j].ReRegistrationData;
workSheet.Cells[i, 18] = alco[j].TypeOfRegistration;
workSheet.Cells[i, 19] = alco[j].Heredity;
workSheet.Cells[i, 20] = alco[j].DisabilityGroup;
workSheet.Cells[i, 21] = alco[j].DisabilityStatus;
workSheet.Cells[i, 22] = alco[j].ReasonForDisability;
workSheet.Cells[i, 23] = alco[j].WorksStatus;
workSheet.Cells[i, 24] = alco[j].AdmOtv;
workSheet.Cells[i, 25] = alco[j].UgOtv;
workSheet.Cells[i, 26] = alco[j].DlitsMLS;
workSheet.Cells[i, 27] = alco[j].Stat107;
workSheet.Cells[i, 28] = alco[j].StatUKRB;
workSheet.Cells[i, 29] = alco[j].RodPrav;
workSheet.Cells[i, 30] = alco[j].NomLTP;
workSheet.Cells[i, 31] = alco[j].LTPKol;
workSheet.Cells[i, 32] = alco[j].Hospitel;
workSheet.Cells[i, 33] = alco[j].EK;
workSheet.Cells[i, 34] = alco[j].DateOfDeregistration;
workSheet.Cells[i, 35] = alco[j].DateOfDead;
workSheet.Cells[i, 36] = alco[j].PlaceOfDead;
workSheet.Cells[i, 37] = alco[j].DeathCertificate;
workSheet.Cells[i, 38] = alco[j].CauseOfDead;
workSheet.Cells[i, 39] = alco[j].DeathCategory;
workSheet.Cells[i, 40] = alco[j].OpeningPlace;
workSheet.Cells[i, 41] = alco[j].HistoryOfParasucicides;
workSheet.Cells[i, 42] = alco[j].FeaturesOfObservation;
workSheet.Cells[i, 43] = alco[j].ExperienceAbuse;
workSheet.Cells[i, 44] = alco[j].AlcoholicDrinks;
workSheet.Cells[i, 45] = alco[j].IK;
workSheet.Cells[i, 46] = alco[j].DrugDiagnosisAlc;
workSheet.Cells[i, 47] = alco[j].AgeOfRegistration;
workSheet.Cells[i, 48] = alco[j].AgeOfDead;
workSheet.Cells[i, 49] = alco[j].Registrotor;
}
workBook.Save();
workBook.Close();
excelApp.Quit();
}
else
{
MessageBox.Show("Нет информации для создания отчета!!! Сформируйте отчет для записи информации в файл");
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
}
public static void ReadExcel_Alco()
{
try
{
string ExcelFilePath = OpenFile.Open_File();
excelApp = new Excel.Application();
workBook = excelApp.Workbooks.Open(ExcelFilePath);
workSheet = (Worksheet)workBook.Worksheets.get_Item(1);
range = workSheet.UsedRange;
for (int cCnt = 2; cCnt <= range.Rows.Count; cCnt++)
{
Alco alcos = new Alco
{
FIO = Convert.ToString(workSheet.Cells[cCnt, 2].Value),
Sex = Convert.ToString(workSheet.Cells[cCnt, 3].Value),
Date = Convert.ToString(workSheet.Cells[cCnt, 4].Value),
RegionCenterBLR = Convert.ToString(workSheet.Cells[cCnt, 5].Value),
RaenCenterBLR = Convert.ToString(workSheet.Cells[cCnt, 6].Value),
Life = Convert.ToString(workSheet.Cells[cCnt, 7].Value),
Age = Convert.ToString(workSheet.Cells[cCnt, 8].Value),
FamilyStatus = Convert.ToString(workSheet.Cells[cCnt, 9].Value),
CostOfKids = Convert.ToString(workSheet.Cells[cCnt, 10].Value),
FamilyComposition = Convert.ToString(workSheet.Cells[cCnt, 11].Value),
Education = Convert.ToString(workSheet.Cells[cCnt, 12].Value),
Profession = Convert.ToString(workSheet.Cells[cCnt, 13].Value),
TheSkillLevelOfTheProfession = Convert.ToString(workSheet.Cells[cCnt, 14].Value),
AddressOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 15].Value),
AddressAtTheTimeOfDeath = Convert.ToString(workSheet.Cells[cCnt, 16].Value),
DataOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 17].Value),
ReRegistrationData = Convert.ToString(workSheet.Cells[cCnt, 18].Value),
TypeOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 19].Value),
Heredity = Convert.ToString(workSheet.Cells[cCnt, 20].Value),
DisabilityGroup = Convert.ToString(workSheet.Cells[cCnt, 21].Value),
DisabilityStatus = Convert.ToString(workSheet.Cells[cCnt, 22].Value),
ReasonForDisability = Convert.ToString(workSheet.Cells[cCnt, 23].Value),
WorksStatus = Convert.ToString(workSheet.Cells[cCnt, 24].Value),
AdmOtv = Convert.ToString(workSheet.Cells[cCnt, 25].Value),
UgOtv = Convert.ToString(workSheet.Cells[cCnt, 26].Value),
DlitsMLS = Convert.ToString(workSheet.Cells[cCnt, 27].Value),
Stat107 = Convert.ToString(workSheet.Cells[cCnt, 28].Value),
StatUKRB = Convert.ToString(workSheet.Cells[cCnt, 29].Value),
RodPrav = Convert.ToString(workSheet.Cells[cCnt, 30].Value),
NomLTP = Convert.ToString(workSheet.Cells[cCnt, 31].Value),
LTPKol = Convert.ToString(workSheet.Cells[cCnt, 32].Value),
Hospitel = Convert.ToString(workSheet.Cells[cCnt, 33].Value),
EK = Convert.ToString(workSheet.Cells[cCnt, 34].Value),
DateOfDeregistration = Convert.ToString(workSheet.Cells[cCnt, 35].Value),
DateOfDead = Convert.ToString(workSheet.Cells[cCnt, 36].Value),
PlaceOfDead = Convert.ToString(workSheet.Cells[cCnt, 37].Value),
DeathCertificate = Convert.ToString(workSheet.Cells[cCnt, 38].Value),
CauseOfDead = Convert.ToString(workSheet.Cells[cCnt, 39].Value),
DeathCategory = Convert.ToString(workSheet.Cells[cCnt, 40].Value),
OpeningPlace = Convert.ToString(workSheet.Cells[cCnt, 41].Value),
HistoryOfParasucicides = Convert.ToString(workSheet.Cells[cCnt, 42].Value),
FeaturesOfObservation = Convert.ToString(workSheet.Cells[cCnt, 43].Value),
ExperienceAbuse = Convert.ToString(workSheet.Cells[cCnt, 44].Value),
AlcoholicDrinks = Convert.ToString(workSheet.Cells[cCnt, 45].Value),
IK = Convert.ToString(workSheet.Cells[cCnt, 46].Value),
DrugDiagnosisAlc = Convert.ToString(workSheet.Cells[cCnt, 47].Value),
AgeOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 48].Value),
AgeOfDead = Convert.ToString(workSheet.Cells[cCnt, 49].Value),
DataInfo = Convert.ToString(workSheet.Cells[cCnt, 50].Value),
Registrotor = Convert.ToString(workSheet.Cells[cCnt, 51].Value)
};
AlcoholismPersona.Add(alcos);
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
finally
{
workBook.Close();
excelApp.Quit();
}
}
