private void btnPrint_Click(object sender, EventArgs e) { try { WordDoc wd = new WordDoc(string.Format(@"{0}\ListPerson.dot", MainClass.dirTemplates)); int k = dgvAbiturients.Columns.Count; wd.AddNewTable(dgvAbiturients.Rows.Count + 1, k); TableDoc td = wd.Tables[0]; int? facId = ComboServ.GetComboIdInt(cbFaculty); string sFac = cbFaculty.Text.ToLower(); if (sFac.CompareTo("все") == 0) { sFac = ""; } else { sFac = "получивших направления на послеление от "; if (facId == 3) { sFac += "высшей школы менеджмента "; } else { sFac += sFac.Replace("кий", "кого ").Replace("ый", "ого ") + " факультета "; } } wd.Fields["Faculty"].Text = sFac; wd.Fields["Info"].Text = "для общежитий"; int i = 0; td[0, 0] = "№ п/п"; for (int j = 0; j < k - 1; j++) { td[j + 1, 0] = dgvAbiturients.Columns[j + 1].HeaderText; } // печать из грида foreach (DataGridViewRow dgvr in dgvAbiturients.Rows) { td[0, i + 1] = (i + 1).ToString(); for (int j = 0; j < k - 1; j++) { td[j + 1, i + 1] = dgvAbiturients.Rows[i].Cells[j + 1].Value.ToString(); } i++; } } catch (Exception exc) { WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message); } }
//предварительный просмотр protected override void Preview() { try { WordDoc wd = new WordDoc(string.Format(@"{0}\EmptyTemplate.dot", MainClass.dirTemplates)); int counter = 0; int lstCount = -1; int lstTableCount = 0; //foreach (List<string> lst in lstSelected.Values) foreach (int?key in lstSelected.Keys) { List <string> lst = lstSelected[key]; lstCount++; if (lst.Count == 0) { continue; } string header = MainClass.Bdc.GetStringValue("SELECT Name FROM ed.EntryHeader WHERE id=" + key); wd.AddParagraph(string.Format("\r\n {0}", header)); wd.AddNewTable(lst.Count + 1, 6); TableDoc td = wd.Tables[lstTableCount]; ++lstTableCount; //заполняем таблицу в шаблоне int r = 0; td[0, r] = "№ п/п"; td[1, r] = "Рег.номер"; td[2, r] = "ФАМИЛИЯ, ИМЯ, ОТЧЕСТВО"; td[3, r] = "Сумма баллов"; td[4, r] = "Направление или Направление (профиль или Профиль)"; td[5, r] = "Вид конкурса"; DataSet ds = MainClass.Bdc.GetDataSet(sQuery + string.Format(" WHERE ed.qAbiturientId IN ({0})", Util.BuildStringWithCollection(lst)) + sOrderby); foreach (DataRow row in ds.Tables[0].Rows) { ++r; ++counter; td[0, r] = counter.ToString(); td[1, r] = row["Рег_Номер"].ToString(); td[2, r] = row["ФИО"].ToString(); td[3, r] = row["Sum"].ToString(); td[4, r] = row["Направление"].ToString(); td[5, r] = row["Конкурс"].ToString(); } } } catch (Exception ex) { WinFormsServ.Error("Ошибка при выводе в Word протокола о допуске: " + ex.Message); } }
private void btnPrint_Click(object sender, EventArgs e) { List <string> columnList = new List <string>(); foreach (DataGridViewColumn column in dgvAbitList.Columns) { if (column.Visible) { columnList.Add(column.Name); } } try { WordDoc wd = new WordDoc(string.Format(@"{0}\Templates\ListAbit.dot", Application.StartupPath)); wd.AddNewTable(dgvAbitList.Rows.Count + 1, columnList.Count + 1); TableDoc td = wd.Tables[0]; //переменные int? FacId = ComboServ.GetComboIdInt(cbFaculty); string sFac = cbFaculty.Text; if (cbFaculty.Text == ComboServ.DISPLAY_ALL_VALUE) { sFac = "Все факультеты"; } wd.Fields["Faculty"].Text = sFac; //wd.Fields["Section"].Text = sForm; int i = 0; td[0, 0] = "№ п/п"; for (int j = 0; j < columnList.Count; j++) { td[j + 1, 0] = dgvAbitList.Columns[columnList[j]].HeaderText; } // печать из грида foreach (DataGridViewRow dgvr in dgvAbitList.Rows) { td[0, i + 1] = (i + 1).ToString(); for (int j = 0; j < columnList.Count; j++) { td[j + 1, i + 1] = dgvAbitList.Rows[i].Cells[columnList[j]].Value.ToString(); } i++; } } catch (Exception exc) { WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message); } }
//печать private void btnPrint_Click(object sender, EventArgs e) { if (ExamVedId == null) { return; } try { WordDoc wd = new WordDoc(string.Format(@"{0}\Templates\CryptoExamsVed.dot", Application.StartupPath)); TableDoc td = wd.Tables[0]; using (PriemEntities context = new PriemEntities()) { extExamsVed ved = (from ev in context.extExamsVed where ev.Id == ExamVedId select ev).FirstOrDefault(); wd.Fields["Faculty"].Text = cbFaculty.Text.ToLower(); wd.Fields["Exam"].Text = ved.ExamName; wd.Fields["StudyBasis"].Text = Util.ToStr(ved.StudyBasisId == null ? "все" : ved.StudyBasisName); wd.Fields["Date"].Text = ved.Date.ToShortDateString(); wd.Fields["VedNum"].Text = ved.Number.ToString(); int i = 1; // печать из грида foreach (DataGridViewRow dgvr in dgvList.Rows) { td[0, i] = i.ToString(); td[1, i] = dgvr.Cells["Фамилия"].Value.ToString(); td[2, i] = dgvr.Cells["Имя"].Value.ToString(); td[3, i] = dgvr.Cells["Отчество"].Value.ToString(); td[4, i] = DateTime.Parse(dgvr.Cells["Дата_рождения"].Value.ToString()).ToShortDateString(); td[5, i] = dgvr.Cells["Ид_номер"].Value.ToString(); td[6, i] = FacultyId.ToString(); td[7, i] = ved.ExamName; td[8, i] = ved.ExamId.ToString(); td[9, i] = ved.Date.ToShortDateString();; td.AddRow(1); i++; } td.DeleteLastRow(); } } catch (Exception exc) { WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message); } }
private void btnView_Click(object sender, EventArgs e) { try { WordDoc wd = new WordDoc(string.Format(@"{0}\Templates\EmptyTemplate.dot", Application.StartupPath)); int colCount = 0; foreach (DataGridViewColumn clm in dgvMarks.Columns) { if (clm.Visible) { colCount++; } } wd.AddNewTable(2, colCount); TableDoc td = wd.Tables[0]; // печать из грида int i = 0; foreach (DataGridViewColumn clm in dgvMarks.Columns) { if (clm.Visible) { td[i, 0] = clm.HeaderText; i++; } } i = 1; int j; foreach (DataGridViewRow dgvr in dgvMarks.Rows) { j = 0; foreach (DataGridViewColumn clm in dgvMarks.Columns) { if (clm.Visible) { td[j, i] = dgvr.Cells[clm.Index].Value.ToString(); j++; } } i++; td.AddRow(1); } } catch (Exception exc) { WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message); } }
//предварительный просмотр protected virtual void Preview() { if (dgvLeft.Rows.Count == 0) { MessageBox.Show("Протокол пуст", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } try { WordDoc wd = new WordDoc(string.Format(@"{0}\EmptyTemplate.dot", MainClass.dirTemplates)); wd.AddNewTable(dgvLeft.Rows.Count + 1, 7); TableDoc td = wd.Tables[0]; //заполняем таблицу в шаблоне int r = 0; td[0, r] = "№ п/п"; td[1, r] = "Рег.номер"; td[2, r] = "ФАМИЛИЯ, ИМЯ, ОТЧЕСТВО"; td[3, r] = "Номер документа об образовании"; td[4, r] = "Направление(профиль)"; td[5, r] = "Вид конкурса"; td[6, r] = "Номер и серия паспорта"; foreach (DataGridViewRow row in dgvLeft.Rows) { ++r; td[0, r] = r.ToString(); td[1, r] = row.Cells["Num"].Value.ToString(); td[2, r] = row.Cells["FIO"].Value.ToString(); td[3, r] = row.Cells["Attestat"].Value.ToString(); td[4, r] = row.Cells["Spec"].Value.ToString(); td[5, r] = row.Cells["Konkurs"].Value.ToString(); td[6, r] = row.Cells["Pasport"].Value.ToString(); } } catch (Exception ex) { WinFormsServ.Error("Ошибка при выводе в Word протокола о допуске: ", ex); } }
private void OpenFile() { try { bool bErr = false; string strFullPath = ""; OpenFileDialog dialog = new OpenFileDialog(); dialog.Multiselect = false; dialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory); dialog.Title = "配方读取"; dialog.RestoreDirectory = false; if (dialog.ShowDialog() != DialogResult.OK) { return; } strFullPath = dialog.FileName; TableDoc doc = TableDoc.LoadObj(strFullPath, ref bErr); if (bErr) { MessageBox.Show("不是正确的配方文件!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification); return; } TableManage.docTable = doc; TableManage.InitTables(); if (null != eventTableDataReLoad) { this.eventTableDataReLoad(); } MessageBox.Show("加载成功!", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification); } catch (Exception ex) { TableManage.strConfigFile = string.Empty; MessageBox.Show("加载失败!\r\n" + ex.ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification); } }
private void btnWord_Click(object sender, EventArgs e) { try { WordDoc wd = new WordDoc(string.Format(@"{0}\CPKForm1.dot", MainClass.dirTemplates)); TableDoc td = wd.Tables[0]; for (int i = 1; i < dgvData.RowCount; i++) { for (int j = 0; j < 9; j++) { td[j, i + 1] = dgvData.Rows[i - 1].Cells[j].Value.ToString(); } td.AddRow(1); } //td.DeleteLastRow(); string sFac = cbFaculty.Text.ToLower(); if (sFac.CompareTo("все") == 0) { sFac = "всех факультетов "; } else { if (ComboServ.GetComboId(cbFaculty) == "10") { sFac = "медицинского колледжа "; } else if (ComboServ.GetComboId(cbFaculty) == "3") { sFac = "высшей школы менеджмента "; } else { sFac = sFac.Replace("кий", "кого ").Replace("ый", "ого ") + " факультета "; } } string sForm = cbStudyForm.Text.ToLower(); if (sForm.CompareTo("все") == 0) { sForm = " всех форм обучения "; } else { sForm = sForm.Replace("ая", "ой").Replace("яя", "ей") + " формы обучения "; } wd.Fields["Faculty"].Text = sFac; wd.Fields["Section"].Text = sForm; wd.Fields["Date"].Text = "на " + dtpDate.Value.ToShortDateString(); } catch (WordException we) { WinFormsServ.Error(we.Message); } catch (Exception exc) { WinFormsServ.Error(exc.Message); } }
//печать private void btnPrint_Click(object sender, EventArgs e) { try { int k = 7; WordDoc wd = new WordDoc(string.Format(@"{0}\ListAbit.dot", MainClass.dirTemplates)); wd.AddNewTable(dgvAbitList.Rows.Count + 1, k + 1); TableDoc td = wd.Tables[0]; //переменные string sFac = cbFaculty.Text.ToLower(); if (sFac.CompareTo("все") == 0) { sFac = "всех факультетов "; } else { if (FacultyId == 3) { sFac = "высшей школы менеджмента "; } else { sFac = sFac.Replace("кий", "кого ").Replace("ый", "ого ") + " факультета "; } } string sForm = cbStudyForm.Text.ToLower(); if (sForm.CompareTo("все") == 0) { sForm = " всех форм обучения "; } else { sForm = sForm.Replace("ая", "ой").Replace("яя", "ей") + " формы обучения "; } wd.Fields["Faculty"].Text = sFac; wd.Fields["Section"].Text = sForm; int i = 0; td[0, 0] = "№ п/п"; for (int j = 0; j < k; j++) { td[j + 1, 0] = dgvAbitList.Columns[j + 1].HeaderText; } // печать из грида foreach (DataGridViewRow dgvr in dgvAbitList.Rows) { td[0, i + 1] = (i + 1).ToString(); for (int j = 0; j < k; j++) { td[j + 1, i + 1] = dgvAbitList.Rows[i].Cells[j + 1].Value.ToString(); } i++; } } catch (Exception exc) { WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message); } }
private void btnPrintVed_Click(object sender, EventArgs e) { if (!_isLoad) { return; } try { WordDoc wd = new WordDoc(string.Format(@"{0}\Templates\CryptoEnterMarks.dot", Application.StartupPath)); TableDoc td = wd.Tables[0]; //переменные string examId; string examName; DateTime examDate; string facultyId; using (PriemEntities context = new PriemEntities()) { extExamsVed exVed = (from ev in context.extExamsVed where ev.Id == _vedId select ev).FirstOrDefault(); examId = _examId; examName = exVed.ExamName; examDate = _dateExam; facultyId = _facultyId; wd.Fields["Faculty"].Text = exVed.FacultyName; wd.Fields["Exam"].Text = examName; wd.Fields["StudyBasis"].Text = exVed.StudyBasisId == null ? "все" : exVed.StudyBasisName; wd.Fields["Date"].Text = examDate.ToShortDateString(); wd.Fields["VedNum"].Text = exVed.Number.ToString(); int i = 1; var persMark = from evh in context.ExamsVedHistory join pers in context.extForeignPerson on evh.PersonId equals pers.Id where evh.ExamsVedId == _vedId select new { evh.ExamsVedId, pers.Surname, pers.Name, pers.SecondName, pers.BirthDate, pers.PersonNum, evh.PersonId, evh.PersonVedNumber, evh.Mark, evh.OralMark }; foreach (var pm in persMark) { td[0, i] = i.ToString(); td[1, i] = pm.Surname; td[2, i] = pm.Name; td[3, i] = pm.SecondName; td[4, i] = pm.BirthDate.ToShortDateString(); td[5, i] = pm.PersonNum; td[6, i] = facultyId; td[7, i] = examName; td[8, i] = examId; td[9, i] = examDate.ToShortDateString(); int?sumMark = 0; if (pm.Mark == null && pm.OralMark == null) { sumMark = null; } else { sumMark = (pm.Mark ?? 0) + (pm.OralMark ?? 0); } td[10, i] = sumMark == null ? "" : sumMark.ToString(); td.AddRow(1); i++; } td.DeleteLastRow(); } } catch (Exception exc) { WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message); } }
//печать private void btnPrint_Click(object sender, EventArgs e) { string s1 = string.Empty; //обработали факультет if (FacultyId != null) { s1 += " AND ed.extAbit.FacultyId = " + FacultyId; } //обработали Направление if (LicenseProgramId != null) { s1 += " AND ed.extAbit.LicenseProgramId = " + LicenseProgramId; } //обработали Образ программу if (ObrazProgramId != null) { s1 += " AND ed.extAbit.ObrazProgramId = " + ObrazProgramId; } string query = string.Format(@"SELECT ed.extPerson.PersonNum AS PerNum, ed.extAbit.RegNum, LicenseProgramName, ObrazProgramName, StudyFormName, ed.extAbit.FIO as fio, ed.Competition.Name as Competition FROM ed.extAbit INNER JOIN ed.extPerson ON ed.extAbit.PersonId = ed.extPerson.Id LEFT JOIN ed.Competition ON ed.extAbit.CompetitionId = ed.Competition.Id WHERE extAbit.CompFromOlymp = 1 AND extAbit.CompetitionId = 1 {0} ORDER BY 1", s1); try { DataSet ds = _bdc.GetDataSet(query); if (ds.Tables[0].Rows.Count == 0) { return; } WordDoc wd = new WordDoc(string.Format(@"{0}\Olymp2Competition.dot", MainClass.dirTemplates), true); TableDoc td = wd.Tables[0]; wd.Fields["Факультет"].Text = cbFaculty.Text; wd.Fields["Специальность"].Text = cbLicenseProgram.Text; wd.Fields["ОбразовательнаяПрограмма"].Text = cbObrazProgram.Text; int i = 1; foreach (DataRow dr in ds.Tables[0].Rows) { td.AddRow(1); td[0, i] = i.ToString(); td[1, i] = dr["PerNum"].ToString(); td[2, i] = dr["RegNum"].ToString(); td[3, i] = dr["LicenseProgramName"].ToString(); td[4, i] = dr["ObrazProgramName"].ToString(); td[5, i] = dr["StudyFormName"].ToString(); td[6, i] = dr["fio"].ToString(); td[7, i] = dr["Competition"].ToString(); i++; } } catch (Exception ex) { WinFormsServ.Error("Ошибка при выводе в Word: " + ex.Message); } }
// Кнопка Печать private void btnPrint_Click(object sender, EventArgs e) { try { WordDoc wd = new WordDoc(string.Format(@"{0}\ExamVed.dot", MainClass.dirTemplates)); TableDoc td = wd.Tables[0]; //переменные string sFac = cbFaculty.Text.ToString().ToLower(); if (sFac.CompareTo("все") == 0) { sFac = "всех факультетов "; } else { if (FacultyId == 3) { sFac = "высшей школы менеджмента "; } else { sFac = sFac.Replace("кий", "кого ").Replace("ый", "ого ").Replace("акультет", "акультета"); } } string sForm = cbStudyForm.Text.ToString().ToLower(); if (sForm.CompareTo("все") == 0) { sForm = " всех форм обучения "; } else { sForm = sForm.Replace("ая", "ой").Replace("яя", "ей") + " формы обучения "; } wd.Fields["Faculty"].Text = sFac; wd.Fields["Section"].Text = sForm; int i = 1; // печать из грида foreach (DataGridViewRow dgvr in dgvVed.Rows) { if (chbPrintChecked.Checked) { if (dgvr.Cells["Печать"].Value.ToString() == "True") { td[0, i] = i.ToString(); td[1, i] = dgvr.Cells["Рег_Номер"].Value.ToString(); td[2, i] = dgvr.Cells["ФИО"].Value.ToString(); td[3, i] = dgvr.Cells["Тип конкурса"].Value.ToString(); td.AddRow(1); i++; } } else { td[0, i] = i.ToString(); td[1, i] = dgvr.Cells["Рег_Номер"].Value.ToString(); td[2, i] = dgvr.Cells["ФИО"].Value.ToString(); td[3, i] = dgvr.Cells["Тип конкурса"].Value.ToString(); td.AddRow(1); i++; } } } catch (Exception exc) { WinFormsServ.Error("Ошибка вывода в Word: \n" + exc.Message); } }
private void btnPrint_Click(object sender, EventArgs e) { try { WordDoc wd = new WordDoc(string.Format(@"{0}\Marks.dot", MainClass.dirTemplates)); //переменные string sFac = cbFaculty.Text.ToLower(); if (sFac.CompareTo("все") == 0) { sFac = "все факультеты "; } else { if (FacultyId == 3) { sFac = "высшая школа менеджмента "; } else { sFac = sFac + " факультет "; } } string sForm = cbStudyForm.Text.ToLower(); if (sForm.CompareTo("все") == 0) { sForm = " все формы обучения "; } else { sForm = sForm + " форма обучения "; } string sCom = cbCompetition.Text.ToLower(); if (sCom.CompareTo("все") == 0) { sCom = "все типы конкурса "; } else { sCom = "тип конкурса: " + sCom; } string sSpec = cbLicenseProgram.Text.ToLower(); if (sSpec.CompareTo("все") == 0) { sSpec = " все направления"; } else { sSpec = " Направление: " + sSpec; } wd.Fields["Faculty"].Text = sFac; wd.Fields["Section"].Text = sForm; wd.Fields["Competition"].Text = sCom; wd.Fields["Profession"].Text = sSpec; int colCount = 0; foreach (DataGridViewColumn clm in dgvMarks.Columns) { if (clm.Visible) { colCount++; } } wd.AddNewTable(2, colCount); TableDoc td = wd.Tables[0]; int i = 0; foreach (DataGridViewColumn clm in dgvMarks.Columns) { if (clm.Visible) { td[i, 0] = clm.HeaderText; i++; } } i = 1; int j; foreach (DataGridViewRow dgvr in dgvMarks.Rows) { j = 0; foreach (DataGridViewColumn clm in dgvMarks.Columns) { if (clm.Visible) { td[j, i] = dgvr.Cells[clm.Index].Value.ToString(); j++; } } i++; td.AddRow(1); } } catch (WordException we) { WinFormsServ.Error(we.Message); } catch (Exception exc) { WinFormsServ.Error(exc.Message); } }