public static byte[] GenPDFFile_A4_new(metka m_)
{
PdfDocument document = new PdfDocument();
Zen.Barcode.Code128BarcodeDraw bc = Zen.Barcode.BarcodeDrawFactory.Code128WithChecksum;
Zen.Barcode.Code128BarcodeDraw bc1 = Zen.Barcode.BarcodeDrawFactory.Code128WithChecksum;
DB2DataContext db2 = new DB2DataContext();
bool tylko_poler_wyk = false;// m_.komentarz.Contains("!!");
int ilosc = 0;
for (int i = 0; i < m_.il_stron; i++)
{
PdfPage page = document.AddPage();
page.Size = PdfSharp.PageSize.A4;
// Get an XGraphics object for drawing
XGraphics gfx = XGraphics.FromPdfPage(page);
XFont font = new XFont("Verdana", 15, XFontStyle.Bold);
XFont font1 = new XFont("Verdana", 10, XFontStyle.Regular);
XFont font2 = new XFont("Verdana", 8, XFontStyle.Regular);
XFont font3 = new XFont("Verdana", 8, XFontStyle.Italic);
// kod kreskowy
Image im = bc.Draw(m_.nr_zlec_szlif + "_" + (i + 1).ToString(), 35, 2);
XImage xim = XImage.FromGdiPlusImage(im);
gfx.DrawImage(xim, new Point(10, 10));
gfx.DrawString("Utw.: " + DateTime.Now.ToString(), font1, XBrushes.Black,
new XRect(210, 10, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString(m_.nazwa, font, XBrushes.Black,
new XRect(5, 40, 400, 22),
XStringFormats.Center);
gfx.DrawString("Kod części: " + m_.kod_zlecenia + " (partia nr " + (i + 1).ToString() + " z " + m_.il_stron.ToString() + ")", font1, XBrushes.Black,
new XRect(5, 65, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString("Ilość szt: " + m_.ilosc_szt[i].ToString(), font1, XBrushes.Black,
new XRect(240, 65, 300, 22),
XStringFormats.TopLeft);
ilosc = (int)m_.ilosc_szt[0];
gfx.DrawString("Nr rysunku: " + m_.nr_rysunku, font1, XBrushes.Black,
new XRect(5, 80, 300, 22),
XStringFormats.TopLeft);
//gfx.DrawString("Kod po wykonczeniu: " + m_.kod_po_wykonczeniu, font1, XBrushes.Black,
// new XRect(5, 95, 300, 22),
// XStringFormats.TopLeft);
gfx.DrawString("Kolor: " + m_.kolor, font1, XBrushes.Black,
new XRect(240, 75, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString("Nr_zlec: " + m_.nr_zlec_szlif, font1, XBrushes.Black,
new XRect(240, 95, 300, 22),
XStringFormats.TopLeft);
var rw = from c in db2.IPO_ZDAWKA_PW
where c.RW_PW == "RW" && c.Nr_zlecenia_IPO == m_.nr_zlec_szlif
group c by new { c.Magazyn_IPO, c.Nr_indeksu } into fgr
select new { Magazyn_IPO = fgr.Key.Magazyn_IPO, Nr_indeksu = fgr.Key.Nr_indeksu, Ilosc = fgr.Sum(g => g.Ilosc) };
int poz = 105;
foreach (var d in rw.Where(c => c.Ilosc != 0))
{
gfx.DrawString(d.Magazyn_IPO + " " + d.Nr_indeksu + " :" + d.Ilosc.ToString(), font1, XBrushes.Black,
new XRect(240, poz, 300, 22),
XStringFormats.TopLeft);
poz = poz + 10;
}
double st = 170;
szlif_operacjeDataContext db1 = new szlif_operacjeDataContext();
var oper = from c in db1.Marszruty_szlifiernia_s
where c.Id_wyrobu == m_.kod_zlecenia
orderby c.Nr_kol_operacji ascending
select new { c.Id_operacji, OPERACJA = c.Id_operacji + " " + c.Nazwa_operacji, c.IloscSztZm, c.NormaZatwierdzona, c.Nazwa_operacji, c.Nr_kol_operacji };
if (tylko_poler_wyk)
{
oper = oper.Where(x => x.Nazwa_operacji == "Polerowanie wykańczające");
}
else
{
oper = oper.Where(x => x.Nazwa_operacji != "Polerowanie wykańczające");
}
foreach (var o in oper)
{
string wst = "";
if (o.NormaZatwierdzona.Contains("*"))
{
wst = "*";
}
if (!o.Nr_kol_operacji.Value.ToString().EndsWith("0"))
{
wst = "A" + wst; //operacja nie kończy się na zero - to alternatywa!!!
}
//jeżeli wst zawiera A to drukuj pochyłą czcionką
if (wst.Contains("A"))
{
gfx.DrawString(wst + o.OPERACJA, font3, XBrushes.Black,
new XRect(240, st, 300, 22),
XStringFormats.TopLeft);
}
//lub normalną jeżeli nie alternatywna
else
{
gfx.DrawString(wst + o.OPERACJA, font2, XBrushes.Black,
new XRect(240, st, 300, 22),
XStringFormats.TopLeft);
}
im = bc1.Draw("OPER_" + o.Id_operacji.ToString(), 15, 2);
xim = XImage.FromGdiPlusImage(im);
gfx.DrawImage(xim, new Point(230, (int)(st + 15)));
gfx.DrawString(((decimal)((decimal)m_.ilosc_szt[i] * 480m) / (decimal)o.IloscSztZm).ToString("####.#") + "/" + o.IloscSztZm.ToString(), font1, XBrushes.Black,
new XRect(240, st + 26, 300, 22),
XStringFormats.TopLeft);
st = st + 55;
}
MemoryStream ms = new MemoryStream();
m_.rysunek.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
Image n_rys = System.Drawing.Image.FromStream(ms);
double r_width = 150;
double ratio = r_width / n_rys.Width;
double r_height = (double)n_rys.Height * ratio;
XImage rys = XImage.FromGdiPlusImage(n_rys);
gfx.DrawImage(rys, 10, 130, r_width, r_height);
Image im1 = bc.Draw(m_.kod_zlecenia, 20, 3);
XImage xim1 = XImage.FromGdiPlusImage(im1);
gfx.DrawImage(xim1, new Point(15, 150 + (int)r_height));
}
// Save the document...
//string filename = "HelloWorld.pdf";
MemoryStream str = new MemoryStream();
document.Save(str, true);
Metki_PDF m_pdf = new Metki_PDF();
m_pdf.Nr_zlecenia = m_.nr_zlec_szlif.ToString();
m_pdf.Data_utw = DateTime.Now;
m_pdf.PDF = str.ToArray();
m_pdf.Ilosc = ilosc;
baza_metekDataContext db = new baza_metekDataContext();
db.Metki_PDFs.InsertOnSubmit(m_pdf);
db.SubmitChanges();
return(str.ToArray());
}
public static byte[] GenPDFFile(metka m_)
{
PdfDocument document = new PdfDocument();
Zen.Barcode.Code128BarcodeDraw bc = Zen.Barcode.BarcodeDrawFactory.Code128WithChecksum;
Zen.Barcode.Code128BarcodeDraw bc1 = Zen.Barcode.BarcodeDrawFactory.Code128WithChecksum;
double ilosc = 0;
for (int i = 0; i < m_.il_stron; i++)
{
PdfPage page = document.AddPage();
page.Size = PdfSharp.PageSize.A5;
// Get an XGraphics object for drawing
XGraphics gfx = XGraphics.FromPdfPage(page);
XFont font = new XFont("Verdana", 15, XFontStyle.BoldItalic);
XFont font1 = new XFont("Verdana", 10, XFontStyle.Regular);
XFont font2 = new XFont("Verdana", 15, XFontStyle.Regular);
XFont font3 = new XFont("Verdana", 8, XFontStyle.Regular);
XFont font4 = new XFont("Verdana", 8, XFontStyle.Italic);
// kod kreskowy
Image im = bc.Draw(m_.nr_zlec_galw.ToString(), 20, 2);
XImage xim = XImage.FromGdiPlusImage(im);
gfx.DrawImage(xim, new Point(20, 10));
gfx.DrawString("Utw.: " + DateTime.Now.ToString(), font1, XBrushes.Black,
new XRect(210, 10, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString("Przez: " + m_.userid, font3, XBrushes.Black,
new XRect(210, 22, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString(m_.nazwa, font, XBrushes.Black,
new XRect(20, 40, 400, 22),
XStringFormats.TopLeft);
gfx.DrawString(m_.kod_zlecenia + " (Kod zlecenia)", font1, XBrushes.Black,
new XRect(20, 65, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString(m_.kod_materialu_galw + " (Kod materialu)", font1, XBrushes.Black,
new XRect(20, 80, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString(m_.kolor, font2, XBrushes.Black,
new XRect(20, 95, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString("Ilość szt: " + m_.ilosc_szt[i].ToString(), font1, XBrushes.Black,
new XRect(255, 65, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString("Nr rysunku: " + m_.nr_rysunku, font1, XBrushes.Black,
new XRect(255, 80, 300, 22),
XStringFormats.TopLeft);
gfx.DrawString("Zlec_IPO: " + m_.nr_zlec_galw, font1, XBrushes.Black,
new XRect(255, 95, 300, 22),
XStringFormats.TopLeft);
baza_metekDataContext db1 = new baza_metekDataContext();
var pow = from c in db1.GAL_POWIERZCHNIEs
where c.NR_RYS == m_.nr_rysunku && (bool)c.STATUS
select c;
if (pow.Count() == 1)
{
var pows = pow.Single();
gfx.DrawString("Pow: " + Math.Round((double)pows.POW, 3).ToString() + "(" + Math.Round(((double)pows.POW * m_.ilosc_szt[i]), 3).ToString() + ") dm2", font1, XBrushes.Black,
new XRect(255, 110, 300, 22),
XStringFormats.TopLeft);
}
gfx.DrawString("" + m_.komentarz, font4, XBrushes.Black,
new XRect(200, 125, 300, 22),
XStringFormats.TopLeft);
ilosc = ilosc + m_.ilosc_szt[i];
MemoryStream ms = new MemoryStream();
m_.rysunek.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
Image n_rys = System.Drawing.Image.FromStream(ms);
double r_width = 150;
double ratio = r_width / n_rys.Width;
double r_height = (double)n_rys.Height * ratio;
XImage rys = XImage.FromGdiPlusImage(n_rys);
gfx.DrawImage(rys, 15, 150, r_width, r_height);
Image im1 = bc.Draw("" + m_.nr_zlec_galw, 10, 2);
XImage xim1 = XImage.FromGdiPlusImage(im1);
gfx.DrawImage(xim1, new Point(15, 130));
gfx.DrawString(" Belka , il.szt", font4, XBrushes.Black,
new XRect(255, 140, 300, 22),
XStringFormats.TopLeft);
XPen pen = new XPen(XColors.Black, 1);
XPoint[] points = new XPoint[] { new XPoint(255, 150), new XPoint(355, 150), new XPoint(355, 190), new XPoint(255, 190), new XPoint(255, 150) };
gfx.DrawLines(pen, points);
points = new XPoint[] { new XPoint(355, 190), new XPoint(355, 230), new XPoint(255, 230), new XPoint(255, 190) };
gfx.DrawLines(pen, points);
points = new XPoint[] { new XPoint(355, 230), new XPoint(355, 270), new XPoint(255, 270), new XPoint(255, 230) };
gfx.DrawLines(pen, points);
}
// Save the document...
//string filename = "HelloWorld.pdf";
MemoryStream str = new MemoryStream();
document.Save(str, true);
Metki_PDF m_pdf = new Metki_PDF();
m_pdf.Nr_zlecenia = m_.nr_zlec_galw.ToString();
m_pdf.Data_utw = DateTime.Now;
m_pdf.PDF = str.ToArray();
m_pdf.Ilosc = (int)ilosc;
baza_metekDataContext db = new baza_metekDataContext();
db.Metki_PDFs.InsertOnSubmit(m_pdf);
db.SubmitChanges();
Metki_baza m = new Metki_baza();
m.Data_utw = DateTime.Now;
m.Ilosc = (int)m_.ilosc_szt[0];
m.Nr_kodu = m_.kod_zlecenia;
m.Nr_zlecenia = m_.nr_zlec_galw.ToString();
m.User_id = "galwanika";
db.Metki_bazas.InsertOnSubmit(m);
db.SubmitChanges();
return(str.ToArray());
}
