//дополнительная инициализация контролов
private void InitControls()
{
InitFocusHandlers();
this.CenterToParent();
//this.MdiParent = MainClass.mainform;
bdc = MainClass.Bdc;
lblAdd.Text = string.Empty;
using (PriemEntities context = new PriemEntities())
{
extExamsVed exVed = (from ev in context.extExamsVed
where ev.Id == _vedId
select ev).FirstOrDefault();
_examId = exVed.ExamId.ToString();
_dateExam = exVed.Date;
_facultyId = exVed.FacultyId.ToString();
_studybasisId = exVed.StudyBasisId.ToString();
lblFaculty.Text += exVed.FacultyName;
if (exVed.StudyBasisId == null)
{
lblStudyBasis.Text += "все";
}
else
{
lblStudyBasis.Text += exVed.StudyBasisName;
}
lblExam.Text += exVed.ExamName;
lblDate.Text += exVed.Date.ToShortDateString();
if (exVed.IsAddVed)
{
lblAdd.Text += "дополнительная (" + exVed.AddCount.ToString() + ")";
}
if (MainClass.IsCryptoMain() || MainClass.IsPasha())
{
btnLoad.Visible = true;
}
else
{
btnLoad.Visible = false;
}
}
}
private void btnPrintSticker_Click(object sender, EventArgs e)
{
if (ExamVedId == null)
{
return;
}
if (MainClass.IsOwner() || MainClass.IsCrypto() || MainClass.IsPasha() || MainClass.IsCryptoMain())
{
FileStream fileS = null;
string savePath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + @"\Sticker.pdf";
float fontsize = 8;
try
{
using (PriemEntities context = new PriemEntities())
{
Document document = new Document(PageSize.A4, 50, 50, 50, 50);
document.SetMargins(18, 18, 36, 5);
using (fileS = new FileStream(savePath, FileMode.Create))
{
BaseFont bfTimes = BaseFont.CreateFont(string.Format(@"{0}\times.ttf", MainClass.dirTemplates), BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
iTextSharp.text.Font font = new iTextSharp.text.Font(bfTimes, 10);
PdfWriter pw = PdfWriter.GetInstance(document, fileS);
document.Open();
int cntCells = 2;
int.TryParse(tbCountCell.Text.Trim(), out cntCells);
string examId;
string examName;
string examDate;
string facId;
string vedNumber;
extExamsVed ved = (from ev in context.extExamsVed
where ev.Id == ExamVedId
select ev).FirstOrDefault();
examId = ved.ExamId.ToString();
examName = ved.ExamName.ToString();
examDate = ved.Date.ToShortDateString();
vedNumber = ved.Number.ToString();
facId = FacultyId.ToString();
DataSet dsPersons = bdc.GetDataSet(string.Format("SELECT DISTINCT ed.extPerson.Id, ed.extPerson.PersonNum as RegNum, ed.extPerson.FIO, ed.ExamsVedHistory.PersonVedNumber " +
"FROM ed.extPerson LEFT JOIN ed.ExamsVedHistory ON ed.ExamsVedHistory.PersonId = ed.extPerson.Id WHERE ed.ExamsVedHistory.ExamsVedId = '{0}' ORDER BY FIO ", ExamVedId.ToString()));
PdfPTable t = new PdfPTable(3);
float pgW = (PageSize.A4.Width - 36) / 3;
float[] headerwidths = { pgW, pgW, pgW };
t.SetWidths(headerwidths);
t.WidthPercentage = 100f;
t.SpacingBefore = 10f;
t.SpacingAfter = 10f;
t.DefaultCell.MinimumHeight = 120;
int cellsNum = (dsPersons.Tables[0].Rows.Count) * (cntCells + 1);
int ost = cellsNum % 3;
foreach (DataRow drr in dsPersons.Tables[0].Rows)
{
string text = drr["FIO"].ToString() + "\n" + drr["RegNum"].ToString() + " " + facId + "\n";
text += examDate + " " + examName;
Barcode128 barcode1 = new Barcode128();
barcode1.Code = vedNumber + "==" + drr["PersonVedNumber"].ToString() + "-";
Barcode128 barcode2 = new Barcode128();
barcode2.Code = vedNumber + "==" + drr["PersonVedNumber"].ToString() + "-";
PdfContentByte cb = pw.DirectContent;
iTextSharp.text.Image img1 = barcode1.CreateImageWithBarcode(cb, null, null);
img1.ScaleAbsolute(80f, 60f);
iTextSharp.text.Image img2 = barcode2.CreateImageWithBarcode(cb, iTextSharp.text.Color.BLACK, iTextSharp.text.Color.WHITE);
img2.ScaleAbsolute(80f, 60f);
PdfPTable ptPl = new PdfPTable(1);
float[] hwh = { pgW };
ptPl.SetWidthPercentage(hwh, PageSize.A4);
PdfPCell clPlText = new PdfPCell(new Phrase(text, new iTextSharp.text.Font(bfTimes, fontsize)));
clPlText.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
clPlText.PaddingBottom = 2;
clPlText.PaddingTop = 2;
clPlText.Border = iTextSharp.text.Rectangle.NO_BORDER;
PdfPCell clPlBarc = new PdfPCell();
clPlBarc.AddElement(img1);
clPlBarc.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
clPlBarc.PaddingTop = 1;
clPlBarc.PaddingLeft = 40;
clPlBarc.Border = iTextSharp.text.Rectangle.NO_BORDER;
ptPl.AddCell(clPlText);
ptPl.AddCell(clPlBarc);
PdfPCell pcell = new PdfPCell(ptPl);
pcell.PaddingTop = 6;
pcell.PaddingBottom = 6;
pcell.PaddingLeft = 6;
pcell.PaddingRight = 6;
pcell.FixedHeight = 100;
pcell.Border = iTextSharp.text.Rectangle.NO_BORDER;
t.AddCell(pcell);
PdfPCell pcell1;
for (int i = 0; i < cntCells; i++)
{
ptPl = new PdfPTable(1);
ptPl.SetWidthPercentage(hwh, PageSize.A4);
clPlText = new PdfPCell();
clPlText.AddElement(img2);
clPlText.PaddingLeft = 40;
clPlText.PaddingRight = 40;
clPlText.PaddingTop = 20;
clPlText.Border = iTextSharp.text.Rectangle.NO_BORDER;
clPlBarc = new PdfPCell(new Phrase((i + 1).ToString(), new iTextSharp.text.Font(bfTimes, fontsize)));
clPlBarc.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
clPlBarc.PaddingTop = 1;
clPlBarc.Border = iTextSharp.text.Rectangle.NO_BORDER;
ptPl.AddCell(clPlText);
ptPl.AddCell(clPlBarc);
pcell1 = new PdfPCell(ptPl);
pcell1.FixedHeight = 100;
pcell1.Border = iTextSharp.text.Rectangle.NO_BORDER;
t.AddCell(pcell1);
}
}
for (int i = 0; i < 3 - ost; i++)
{
PdfPCell pc = new PdfPCell();
pc.Border = iTextSharp.text.Rectangle.NO_BORDER;
t.AddCell(pc);
}
if (t != null)
{
document.Add(t);
}
document.Close();
Process pr = new Process();
pr.StartInfo.Verb = "Print";
pr.StartInfo.FileName = string.Format(savePath);
pr.Start();
pr.Close();
}
}
}
catch (Exception exc)
{
WinFormsServ.Error(exc.Message);
}
finally
{
if (fileS != null)
{
fileS.Dispose();
}
}
}
else
{
WinFormsServ.Error("Невозможно создание наклеек, недостаточно прав");
}
}
//дополнительная инициализация контролов
private void InitControls()
{
InitFocusHandlers();
bdc = MainClass.Bdc;
try
{
btnDeleteFromVed.Visible = btnDeleteFromVed.Enabled = false;
btnUnload.Visible = btnUnload.Enabled = false;
//наверное нужно писать права по отдельным группам. Чуть больше, зато на порядок понятнее. И чтобы "левых" вставок не было
//Паше наклейки печатать нельзя??? Непорядок!!!
if (MainClass.IsFacMain())
{
btnCreate.Visible = true;
btnChange.Visible = true;
btnDelete.Visible = false;
tbCountCell.Visible = false;
lblCountCell.Visible = false;
btnLock.Visible = false;
btnCreateAdd.Visible = true;
btnPrintSticker.Visible = false;
}
else if (MainClass.IsCryptoMain() || MainClass.IsPasha())
{
btnCreate.Visible = false;
btnChange.Visible = false;
btnDelete.Visible = false;
tbCountCell.Visible = true;
lblCountCell.Visible = true;
btnLock.Visible = true;
btnCreateAdd.Visible = true;
btnPrintSticker.Visible = true;
}
else if (MainClass.IsPasha())
{
btnDelete.Visible = true;
btnChange.Visible = true;
btnDeleteFromVed.Visible = btnDeleteFromVed.Enabled = true;
btnUnload.Visible = btnUnload.Enabled = true;
}
else
{
btnCreate.Visible = false;
btnChange.Visible = false;
btnDelete.Visible = false;
tbCountCell.Visible = false;
lblCountCell.Visible = false;
btnLock.Visible = false;
btnCreateAdd.Visible = false;
btnPrintSticker.Visible = false;
}
if (MainClass.IsOwner())
{
btnCreate.Visible = true;
btnChange.Visible = true;
btnDelete.Visible = true;
tbCountCell.Visible = true;
lblCountCell.Visible = true;
btnLock.Visible = true;
btnCreateAdd.Visible = true;
btnPrintSticker.Visible = true;
}
//по умолчанию печатается 2 штрих-кода
tbCountCell.Text = (2).ToString();
using (PriemEntities context = new PriemEntities())
{
ComboServ.FillCombo(cbStudyLevelGroup, HelpClass.GetComboListByTable("ed.StudyLevelGroup", ""), false, false);
ComboServ.FillCombo(cbFaculty, HelpClass.GetComboListByTable("ed.qFaculty", "ORDER BY Acronym"), false, false);
ComboServ.FillCombo(cbStudyBasis, HelpClass.GetComboListByTable("ed.StudyBasis", "ORDER BY Name"), false, true);
UpdateVedList();
UpdateDataGrid();
cbFaculty.SelectedIndexChanged += new EventHandler(cbFaculty_SelectedIndexChanged);
cbStudyBasis.SelectedIndexChanged += new EventHandler(cbStudyBasis_SelectedIndexChanged);
cbExamVed.SelectedIndexChanged += new EventHandler(cbExamVed_SelectedIndexChanged);
}
}
catch (Exception ex)
{
WinFormsServ.Error("Ошибка при инициализации формы ведомостей: " + ex.Message);
}
}
/// <summary>
/// extra information for open - what smi are enabled
/// </summary>
/// <param name="path"></param>
public void OpenHelp(string path)
{
try
{
bFirstRun = false;
// убирает все IsOpen для данного пользователя
MainClass.DeleteAllOpenByHolder();
tsslMain.Text = string.Format("Открыта база: Прием в СПбГУ {0} {1}; ", MainClass.sPriemYear, path);
MainClass.dirTemplates = string.Format(@"{0}\Templates", Application.StartupPath);
MainClass.InitQueryBuilder();
ShowProtocolWarning();
//предупреждение об рабочем режиме базы
//MessageBox.Show("Уважаемые пользователи!\nСистема находится в рабочем режиме.\nВведение тестовых записей не допускается.", "Внимание");
if (MainClass.IsOwner())
{
return;
}
// магистратура!
if (MainClass.dbType == PriemType.PriemMag || MainClass.dbType == PriemType.PriemForeigners)
{
smiOlympAbitList.Visible = false;
smiOlymps.Visible = false;
smiOlymp2Competition.Visible = false;
smiOlymp2Mark.Visible = false;
}
else
{
smiOnlineChanges.Visible = false;
smiLoad.Visible = false;
}
smiRatingList.Visible = false;
smiOrderNumbers.Visible = false;
smiOlymps.Visible = false;
smiCreateVed.Visible = false;
smiBooks.Visible = false;
smiCrypto.Visible = false;
smiFBS.Visible = false;
smiExport.Visible = false;
smiImport.Visible = false;
smiExamsVedRoomList.Visible = false;
//smiProblemSolver.Visible = false;
smiEntryView.Visible = false;
smiDisEntryView.Visible = false;
smiEGEStatistics.Visible = false;
smiDynamics.Visible = false;
smiFormA.Visible = false;
smiForm2.Visible = false;
smiAbitFacultyIntesection.Visible = false;
smiRegionStat.Visible = false;
smiOlympStatistics.Visible = false;
// Разделение видимости меню
if (MainClass.IsFacMain())
{
smiOlymps.Visible = true;
smiCreateVed.Visible = true;
smiExamsVedRoomList.Visible = true;
smiRatingList.Visible = true;
smiEntryView.Visible = true;
smiDisEntryView.Visible = true;
smiAbitFacultyIntesection.Visible = true;
smiExport.Visible = true;
}
if (MainClass.IsEntryChanger())
{
smiBooks.Visible = true;
smiEnterManual.Visible = false;
smiRatingListPasha.Visible = false;
smiRatingList.Visible = true;
smiExport.Visible = true;
}
if (MainClass.IsPasha())
{
smiCrypto.Visible = true;
smiBooks.Visible = true;
smiRatingList.Visible = true;
smiFBS.Visible = true;
smiOrderNumbers.Visible = true;
smiExport.Visible = true;
smiEntryView.Visible = true;
smiDisEntryView.Visible = true;
smiEnterManual.Visible = true;
smiAppeal.Visible = true;
smiDecryptor.Visible = true;
//Паша попросил добавить себе
smiCreateVed.Visible = true;
smiExamsVedRoomList.Visible = true;
smiRatingListPasha.Visible = true;
smiEGEStatistics.Visible = true;
smiDynamics.Visible = true;
smiFormA.Visible = true;
smiForm2.Visible = true;
smiAbitFacultyIntesection.Visible = true;
smiRegionStat.Visible = true;
smiOlympStatistics.Visible = true;
}
if (MainClass.IsRectorat())
{
smiEGEStatistics.Visible = true;
smiFormA.Visible = true;
smiExport.Visible = true;
smiAbitFacultyIntesection.Visible = true;
smiRegionStat.Visible = true;
smiOlympStatistics.Visible = true;
}
if (MainClass.IsSovetnik() || MainClass.IsSovetnikMain())
{
smiAbitFacultyIntesection.Visible = true;
}
if (MainClass.IsCrypto())
{
smiCrypto.Visible = true;
smiExamsVedRoomList.Visible = true;
smiAppeal.Visible = false;
smiDecryptor.Visible = false;
smiLoadMarks.Visible = false;
}
if (MainClass.IsCryptoMain())
{
smiCrypto.Visible = true;
smiAppeal.Visible = true;
smiExamsVedRoomList.Visible = true;
//глава шифровалки тоже хочет создавать ведомости
smiCreateVed.Visible = true;
smiDecryptor.Visible = false;
smiLoadMarks.Visible = false;
}
if (MainClass.IsPrintOrder())
{
smiEntryView.Visible = true;
}
//временно
smiImport.Visible = false;
Form frm;
if (MainClass._config.ValuesList.Keys.Contains("lstAbitDef"))
{
bool lstAbitDef = bool.Parse(MainClass._config.ValuesList["lstAbitDef"]);
if (lstAbitDef)
{
frm = new ListAbit(this);
smiListAbit.Checked = true;
smiListPerson.Checked = false;
}
else
{
if (MainClass.dbType == PriemType.PriemMag)
{
frm = new ApplicationInetList();
}
else
{
frm = new PersonInetList();
}
smiListPerson.Checked = true;
smiListAbit.Checked = false;
}
}
else
{
frm = new PersonInetList();
}
ShowProtocolWarning();
frm.Show();
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка инициализации " + exc.Message);
}
}
private void btnLoad_Click(object sender, EventArgs e)
{
if (MainClass.IsCryptoMain() || MainClass.IsPasha())
{
try
{
using (PriemEntities context = new PriemEntities())
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.RequiresNew))
{
int marksCount = 0;
foreach (DataGridViewRow dgvr in dgvMarks.Rows)
{
string balWr = dgvr.Cells["Баллы (письм)"].Value == null ? string.Empty : dgvr.Cells["Баллы (письм)"].Value.ToString();
string balOr = dgvr.Cells["Баллы (устные)"].Value == null ? string.Empty : dgvr.Cells["Баллы (устные)"].Value.ToString();
string valWr = dgvr.Cells["Баллы(письм) по аппеляции"].Value == null ? string.Empty : dgvr.Cells["Баллы(письм) по аппеляции"].Value.ToString();
string valOr = dgvr.Cells["Баллы (устные) по аппеляции"].Value == null ? string.Empty : dgvr.Cells["Баллы (устные) по аппеляции"].Value.ToString();
if (string.IsNullOrEmpty(balWr) && string.IsNullOrEmpty(balOr))
{
continue;
}
if (string.IsNullOrEmpty(valWr) && string.IsNullOrEmpty(valOr))
{
continue;
}
Guid persId = new Guid(dgvr.Cells["PersonId"].Value.ToString());
int persNum = int.Parse(dgvr.Cells["Номер"].Value.ToString());
int mrkWrTmp;
int mrkOrTmp;
int?mrkWr;
int?mrkOr;
if (string.IsNullOrEmpty(valWr))
{
mrkWr = null;
}
else if (!(int.TryParse(valWr, out mrkWrTmp) && mrkWrTmp >= 0 && mrkWrTmp < 101))
{
dgvMarks.CurrentCell = dgvr.Cells["Баллы(письм) по аппеляции"];
WinFormsServ.Error(dgvr.Cells["ФИО"].Value.ToString() + ": неправильно введены данные");
return;
}
else
{
mrkWr = mrkWrTmp;
}
if (string.IsNullOrEmpty(valOr))
{
mrkOr = null;
}
else if (!(int.TryParse(valOr, out mrkOrTmp) && mrkOrTmp >= 0 && mrkOrTmp < 101))
{
dgvMarks.CurrentCell = dgvr.Cells["Баллы (устные) по аппеляции"];
WinFormsServ.Error(dgvr.Cells["ФИО"].Value.ToString() + ": неправильно введены данные");
return;
}
else
{
mrkOr = mrkOrTmp;
}
context.ExamsVedHistory_UpdateMarkAppeal(_vedId, persId, persNum, mrkWr);
context.ExamsVedHistory_UpdateMarkOralAppeal(_vedId, persId, persNum, mrkOr);
DataSet ds = bdc.GetDataSet(string.Format("SELECT Id, EntryId FROM ed.qAbiturient WHERE PersonId = '{0}' AND FacultyId={1} {2}", persId.ToString(), _facultyId, _studybasisId == "" ? "" : " AND ed.qAbiturient.StudyBasisId = " + _studybasisId));
foreach (DataRow row in ds.Tables[0].Rows)
{
string examInPr = Exams.GetExamInEntryId(_examId, row["EntryId"].ToString());
Guid abitId = new Guid(row["Id"].ToString());
if (string.IsNullOrEmpty(examInPr))
{
continue;
}
int examInEntryId = int.Parse(examInPr);
int?sumMark = 0;
if (mrkWr == null && mrkOr == null)
{
sumMark = null;
}
else
{
sumMark = (mrkWr ?? 0) + (mrkOr ?? 0);
}
int cnt = (from mrk in context.qMark
where mrk.ExamInEntryId == examInEntryId && mrk.AbiturientId == abitId
select mrk).Count();
if (cnt > 0)
{
context.Mark_updateByAbVedId(abitId, examInEntryId, sumMark, _dateExam, _vedId);
marksCount++;
}
}
}
transaction.Complete();
MessageBox.Show(marksCount + " записей изменено.", "Выполнено");
}
}
}
catch (Exception exc)
{
WinFormsServ.Error("Ошибка сохранения данных: \n" + exc.Message);
return;
}
}
}
//дополнительная инициализация контролов
private void InitControls()
{
InitFocusHandlers();
this.CenterToParent();
//this.MdiParent = MainClass.mainform;
bdc = MainClass.Bdc;
slReplaceMark = new SortedList <string, string>();
slNewMark = new SortedList <string, string>();
dgvMarks.ReadOnly = true;
lblAdd.Text = string.Empty;
using (PriemEntities context = new PriemEntities())
{
extExamsVed exVed = (from ev in context.extExamsVed
where ev.Id == _vedId
select ev).FirstOrDefault();
_isAdditional = exVed.IsAddVed;
_examId = exVed.ExamId.ToString();
_dateExam = exVed.Date;
_facultyId = exVed.FacultyId.ToString();
_studybasisId = exVed.StudyBasisId.ToString();
_vedNum = exVed.Number.ToString();
lblFaculty.Text += exVed.FacultyName;
if (exVed.StudyBasisId == null)
{
lblStudyBasis.Text += "все";
}
else
{
lblStudyBasis.Text += exVed.StudyBasisName;
}
lblExam.Text += exVed.ExamName;
lblDate.Text += exVed.Date.ToShortDateString();
if (exVed.IsAddVed)
{
lblAdd.Text += "дополнительная (" + exVed.AddCount.ToString() + ")";
}
btnPrintVed.Enabled = false;
if (exVed.IsLoad)
{
_isLoad = true;
dgvMarks.ReadOnly = true;
lblIsLoad.Text = "Загружена";
btnPrintVed.Enabled = true;
}
if ((MainClass.IsCryptoMain() || MainClass.IsPasha()) && !exVed.IsLoad)
{
btnLoad.Visible = true;
}
else
{
btnLoad.Visible = false;
}
if (MainClass.IsPasha())
{
btnPrintVed.Enabled = true;
}
btnDoubleLanguage.Visible = false;//MainClass.IsPasha();
}
}
