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);
}
}
