110
_frmHistory.MdiParent = this.MdiParent;
_frmHistory.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "tsbHistory_Click()",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally { cmd.Connection.Close(); }
}
//проверка ввода
private void tbNum_KeyPress(object sender, KeyPressEventArgs e)
{
// Если это не цифра.
if (!Char.IsDigit(e.KeyChar))
{
TextBox tb = (TextBox)sender;
if ("а/-".IndexOf(e.KeyChar) == -1)
{
if (e.KeyChar != (int)Keys.Back)
e.Handled = true;
}
}
}
//выгрузка отчета
private static List<System.Drawing.Image> ExtractImages(byte[]
PDFSourcePath)
{
List<System.Drawing.Image> ImgList = new
List<System.Drawing.Image>();
iTextSharp.text.pdf.RandomAccessFileOrArray RAFObj = null;
iTextSharp.text.pdf.PdfReader PDFReaderObj = null;
iTextSharp.text.pdf.PdfObject PDFObj = null;
iTextSharp.text.pdf.PdfStream PDFStremObj = null;
try
{
RAFObj = new
iTextSharp.text.pdf.RandomAccessFileOrArray(PDFSourcePath);
PDFReaderObj = new iTextSharp.text.pdf.PdfReader(RAFObj,
null);
for (int i = 0; i <= PDFReaderObj.XrefSize - 1; i++)
{
PDFObj = PDFReaderObj.GetPdfObject(i);
if ((PDFObj != null) && PDFObj.IsStream())
{
PDFStremObj =
(iTextSharp.text.pdf.PdfStream)PDFObj;
iTextSharp.text.pdf.PdfObject subtype =
PDFStremObj.Get(iTextSharp.text.pdf.PdfName.SUBTYPE);
111
if ((subtype != null) && subtype.ToString() ==
iTextSharp.text.pdf.PdfName.IMAGE.ToString())
{
try
{
iTextSharp.text.pdf.parser.PdfImageObject PdfImageObj =
new
iTextSharp.text.pdf.parser.PdfImageObject((iTextSharp.text.pdf.PRStream)PDFStremObj);
System.Drawing.Image ImgPDF =
PdfImageObj.GetDrawingImage();
ImgList.Add(ImgPDF);
}
catch (Exception)
{
}
}
}
}
PDFReaderObj.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return ImgList;
}
//фильтр
public class CurrentFilter
{
public string Dept, TypeDoc,
NumDoc, InNumDoc, DateDoc ,
InDateDoc, Description;
public CurrentFilter(string Dept, string TypeDoc,
string NumDoc, string InNumDoc, string DateDoc,
string InDateDoc, string Description)
{
this.Dept = Dept;
this.TypeDoc = TypeDoc;
this.NumDoc = NumDoc;
this.InNumDoc = InNumDoc;
this.DateDoc = DateDoc;
this.InDateDoc = InDateDoc;
this.Description = Description;
}
}
private void tstbFilter_TextChanged(object sender, EventArgs e)
{
112
tblInDocs.DefaultView.RowFilter =
tblInDocs.Columns["Description"].ColumnName + string.Format(" Like '%{0}%'",
tstbFilter.Text);
}
}
}