private void импортИзФайлаToolStripMenuItem_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { int p = 25; string[] ch = { " " }; bool noadres = false; StreamReader sr = File.OpenText(openFileDialog1.FileName); List<ImportOchered> io = new List<ImportOchered>(); ImportOchered ioo = new ImportOchered(); while (!sr.EndOfStream) { ioo = new ImportOchered(); ioo.m_rab = ""; ioo.tel = ""; string buf = sr.ReadLine(); if (buf.Trim().Length > 0) { p++; int num; if (int.TryParse(buf, out num)) { ioo.kod = num; if (num == 185) { int ppp = 1; } } else { MessageBox.Show("Ошибка в строке:\n" + buf+"\nКод записи:"+ioo.kod); continue; } if (DateTime.TryParse(sr.ReadLine().Trim(), out ioo.dat_reg)) { string[] fio = sr.ReadLine().Trim().Split(ch, StringSplitOptions.RemoveEmptyEntries); ioo.fam = fio[0]; ioo.ima = fio[1]; ioo.otch = fio[2]; /*if(fio.Length>2) ioo.m_rab = string.Join(" ", fio, 3);*/ if (DateTime.TryParse(sr.ReadLine().Trim(), out ioo.dat_rozh)) { string adr = sr.ReadLine().Trim(); if (!char.IsDigit(adr[2]) && adr[2] != '-') { ioo.adres = adr; } else { ioo.tel = adr; noadres = true; } if (!noadres) { string tel = sr.ReadLine().Trim(); if (char.IsDigit(tel[2]) || tel[2] == '-') { ioo.tel = tel; string[] p_fio = sr.ReadLine().Trim().Split(' '); ioo.p_fam = p_fio[0]; ioo.p_ima = p_fio[1]; ioo.p_otch = p_fio[2]; if (p_fio.Length > 3) { for (int j = 3; j < p_fio.Length; j++) { ioo.m_rab = ioo.m_rab + p_fio[j] + " "; } ioo.m_rab = ioo.m_rab.Trim(); } string[] ser_nom = sr.ReadLine().Trim().Split(ch, StringSplitOptions.RemoveEmptyEntries); try { ioo.ser = ser_nom[0].Remove(ser_nom[0].IndexOf('-')); } catch (Exception ex) { MessageBox.Show("Ошибка в преобразовании серии:\n" + ser_nom[0]); } ioo.nom = ser_nom[1]; string comment = sr.ReadLine(); if (comment != null) { if (comment.Length > 0) { ioo.comment = comment; io.Add(ioo); continue; } else { io.Add(ioo); continue; } } else { io.Add(ioo); continue; } } else { string[] p_fio = tel.Split(ch, StringSplitOptions.RemoveEmptyEntries); ioo.p_fam = p_fio[0]; ioo.p_ima = p_fio[1]; ioo.p_otch = p_fio[2]; if (p_fio.Length > 3) { for (int j = 3; j < p_fio.Length; j++) { ioo.m_rab = ioo.m_rab + p_fio[j] + " "; } ioo.m_rab = ioo.m_rab.Trim(); } string[] ser_nom = sr.ReadLine().Trim().Split(ch,StringSplitOptions.RemoveEmptyEntries); try { ioo.ser = ser_nom[0].Remove(ser_nom[0].IndexOf('-')); } catch (Exception ex) { MessageBox.Show("Ошибка в преобразовании серии:\n" + ser_nom[0]); } ioo.nom = ser_nom[1]; string comment = sr.ReadLine(); if (comment.Length > 0) { ioo.comment = comment; io.Add(ioo); continue; } else { io.Add(ioo); continue; } } } } } else { MessageBox.Show("Ошибка в строке:\n" + buf+"\nКод записи:"+ioo.kod); continue; } } } for (int i = 0; i < io.Count; i++) { int kod_predst=-1; //Добавление представителя try { kod_predst = Convert.ToInt32(info_predstavitelTableAdapter.GetKodPredstavitel(io[i].p_fam, io[i].p_ima, io[i].p_otch, io[i].tel, io[i].adres)); if (!(kod_predst > 0)) { int ind = info_predstavitelTableAdapter.Insert(io[i].p_fam, io[i].p_ima, io[i].p_otch, io[i].m_rab, io[i].tel, io[i].adres); this.info_predstavitelTableAdapter.Fill(this.electronOcheredDataSet.info_predstavitel); kod_predst = Convert.ToInt32(info_predstavitelTableAdapter.GetKodPredstavitel(io[i].p_fam, io[i].p_ima, io[i].p_otch, io[i].tel, io[i].adres)); } //END добавление представителя //Добавление ребенк info_rebenokTableAdapter.Insert(io[i].fam, io[i].ima, io[i].otch, io[i].dat_rozh, kod_predst, 2, "", true, false, io[i].comment, io[i].ser, io[i].nom,0); //int kod_r = (int)info_rebenokTableAdapter.GetKodRebenok(textBox1.Text, textBox2.Text, textBox3.Text, Convert.ToInt32(textBox_kod_pred.Text)); int kod_r = (int)info_rebenokTableAdapter.GetLastId(); info_registrationTableAdapter.Insert(kod_r, io[i].dat_reg, 1); } catch (Exception ex) { of.ErrorInfoToFile(ex); } //END Добавление ребенка } } }
private void импортИзФайла2ToolStripMenuItem_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { int p = 25; int pp = 0; string[] ch = { "\t" }; string[] ch2 = { " " }; string[] ch3 = { " ", "-" }; bool noadres = false; StreamReader sr = new StreamReader(openFileDialog1.FileName, Encoding.UTF8); List<ImportOchered> io = new List<ImportOchered>(); ImportOchered ioo = new ImportOchered(); while (!sr.EndOfStream) { try { ioo = new ImportOchered(); ioo.m_rab = ""; ioo.tel = ""; string line = sr.ReadLine(); string[] sub_line = line.Split(ch, StringSplitOptions.None); if (sub_line[0] != "") { ioo.kod = Convert.ToInt32(sub_line[0]); if (ioo.kod == 117) { int o = 1; } ioo.dat_reg = DateTime.Parse(sub_line[1]); string[] fio = sub_line[2].Split(ch2, StringSplitOptions.RemoveEmptyEntries); ioo.fam = fio[0]; ioo.ima = fio[1]; ioo.otch = fio[2]; ioo.dat_rozh = DateTime.Parse(sub_line[3]); if (sub_line[4] != "") { string[] sernom = sub_line[4].Split(ch3, StringSplitOptions.RemoveEmptyEntries); ioo.ser = sernom[0]; for (int i = 1; i < sernom.Length; i++) { if (int.TryParse(sernom[i][0].ToString(), out pp)) { ioo.nom = sernom[i]; break; } } } else { ioo.ser = "I"; ioo.nom = "нет"; } string[] fio_p = sub_line[5].Split(ch2, StringSplitOptions.RemoveEmptyEntries); if (fio_p.Length > 2) { ioo.p_fam = fio_p[0]; ioo.p_ima = fio_p[1]; ioo.p_otch = fio_p[2]; } ioo.adres = sub_line[6]; if (sub_line.Length > 36) { ioo.tel = sub_line[36]; } if (sub_line[7] != "") { ioo.comment = sub_line[7]; } } io.Add(ioo); } catch (Exception ex) { MessageBox.Show("Ошибка в строке:\nКод записи:" + ioo.kod); } } for (int i = 0; i < io.Count; i++) { int kod_predst = -1; //Добавление представителя try { kod_predst = Convert.ToInt32(info_predstavitelTableAdapter.GetKodPredstavitel(io[i].p_fam, io[i].p_ima, io[i].p_otch, io[i].tel, io[i].adres)); if (!(kod_predst > 0)) { int ind = info_predstavitelTableAdapter.Insert(io[i].p_fam, io[i].p_ima, io[i].p_otch, io[i].m_rab, io[i].tel, io[i].adres); this.info_predstavitelTableAdapter.Fill(this.electronOcheredDataSet.info_predstavitel); kod_predst = Convert.ToInt32(info_predstavitelTableAdapter.GetKodPredstavitel(io[i].p_fam, io[i].p_ima, io[i].p_otch, io[i].tel, io[i].adres)); } //END добавление представителя //Добавление ребенк info_rebenokTableAdapter.Insert(io[i].fam, io[i].ima, io[i].otch, io[i].dat_rozh, kod_predst, 2, "", true, false, io[i].comment, io[i].ser, io[i].nom,0); //int kod_r = (int)info_rebenokTableAdapter.GetKodRebenok(textBox1.Text, textBox2.Text, textBox3.Text, Convert.ToInt32(textBox_kod_pred.Text)); int kod_r = (int)info_rebenokTableAdapter.GetLastId(); info_registrationTableAdapter.Insert(kod_r, io[i].dat_reg, 3); } catch (Exception ex) { of.ErrorInfoToFile(ex); } //END Добавление ребенка } } }