public static Document Document(bool horizontal = false)
{
PdfDocument pdfDocument = new PdfDocument(new PdfWriter(new FileStream(PATH, FileMode.Create, FileAccess.Write)));
if (horizontal)
{
pdfDocument.SetDefaultPageSize(pdfDocument.GetDefaultPageSize().Rotate());
}
Document doc = new Document(pdfDocument);
doc.SetFont(FONT);
return(doc);
}
static void Main(string[] args)
{
SQLiteConnection connection = new SQLiteConnection();
SQLiteConnection.CreateFile("Data.sqlite");
string script = File.ReadAllText(System.IO.Path.Combine(AppContext.BaseDirectory, "Database1.sql"));
connection = new SQLiteConnection(new SQLiteConnectionStringBuilder {
DataSource = "Data.sqlite"
}.ToString());
connection.Open();
var createDB = connection.CreateCommand();
createDB.CommandText = script;
createDB.ExecuteNonQuery();
connection.Close();
connection.Open();
var insertCommand = connection.CreateCommand();
insertCommand.CommandText = "INSERT INTO Books (Number, Title, Publisher, Version, Year, Medium, Place, DayBought, Pages, Price) " +
"VALUES (@Number,@Title,@Publisher,@Version,@Year,@Medium,@Place,@Date,@Pages,@Price)";
insertCommand.Parameters.AddWithValue("Number", 123);
insertCommand.Parameters.AddWithValue("Title", "qwerqwr'");
insertCommand.Parameters.AddWithValue("Publisher", "pub");
insertCommand.Parameters.AddWithValue("Version", 1);
insertCommand.Parameters.AddWithValue("Year", 2010);
insertCommand.Parameters.AddWithValue("Medium", "med");
insertCommand.Parameters.AddWithValue("Place", "bla");
insertCommand.Parameters.AddWithValue("Date", "12122010");
insertCommand.Parameters.AddWithValue("Pages", 15);
insertCommand.Parameters.AddWithValue("Price", 15.2);
insertCommand.ExecuteNonQuery();
connection.Close();
//using (PdfWriter pdfWriter = new PdfWriter(exportFile))
//{
// using (iText.Kernel.Pdf.PdfDocument pdf = new iText.Kernel.Pdf.PdfDocument(pdfWriter))
// {
// Rectangle envelope = new Rectangle(3016, 1327);
// PageSize ps = new PageSize(envelope);
// //ps.ApplyMargins(0, 0, 0, 0, true);
// Document document = new Document(pdf, ps);
// document.SetMargins(0, 0, 0, 0);
// Paragraph text = new Paragraph("Signature").SetTextAlignment(TextAlignment.CENTER).SetFontSize(200);
// Paragraph num = new Paragraph("011120").SetTextAlignment(TextAlignment.CENTER).SetFontSize(200);
// Barcode128 barcode128 = new Barcode128(pdf);
// barcode128.SetCodeType(Barcode128.CODE_C);
// barcode128.SetCode("011120");
// barcode128.FitWidth(2800);
// barcode128.SetBarHeight(700);
// barcode128.SetAltText("");
// Image barcodeImage = new Image(barcode128.CreateFormXObject(pdf));
// barcodeImage.SetHorizontalAlignment(HorizontalAlignment.CENTER);
// document.Add(text);
// document.Add(barcodeImage);
// document.Add(num);
// }
//}
//Spire.Pdf.PdfDocument document1 = new Spire.Pdf.PdfDocument();
//document1.LoadFromFile(exportFile);
//System.Drawing.Image img = document1.SaveAsImage(0);
//img.Save(exportImage);
//document1.SaveToFile(System.IO.Path.Combine(exportFolder, "bc.svg"), FileFormat.SVG);
//Process proc = new Process();
//proc.StartInfo.FileName = exportImage;
//proc.StartInfo.UseShellExecute = true;
//proc.Start();
//Process.Start("explorer.exe", "/select, " + exportImage);
using (PdfWriter writer = new PdfWriter(exportFile))
{
using (iText.Kernel.Pdf.PdfDocument pdfDocument = new iText.Kernel.Pdf.PdfDocument(writer))
{
float cellMainWidth = 176.5f;
float cellMainHeight = 80f;
float cellSpaceWidth = 3.2f;
pdfDocument.SetDefaultPageSize(PageSize.A4);
Document document = new Document(pdfDocument);
document.SetMargins(1.51f * 28.33f, 20f, 1.31f * 28.33f, 20f);
Barcode128 barcode = new Barcode128(pdfDocument);
barcode.SetCodeType(Barcode128.CODE_C);
barcode.SetCode("012345");
barcode.SetSize(14);
barcode.SetBaseline(15);
barcode.SetBarHeight(35f);
barcode.FitWidth(160f);
Image barcodeImage = new Image(barcode.CreateFormXObject(pdfDocument));
barcodeImage.SetHorizontalAlignment(HorizontalAlignment.CENTER);
//barcodeImage.Scale(2.5f, 2f);
Paragraph text = new Paragraph("TEST - TEST - TEST").SetTextAlignment(TextAlignment.CENTER).SetFontSize(14);
Paragraph num = new Paragraph("012345").SetTextAlignment(TextAlignment.CENTER).SetFontSize(14);
Paragraph barcodeCombine = new Paragraph().Add(text).Add(barcodeImage);
Table table = new Table(5);
int col = 3;
int row = 8;
for (int i = 1; i <= 9; i++)
{
for (int j = 1; j <= 3; j++)
{
Cell cellMain = new Cell().SetBorder(Border.NO_BORDER);
cellMain.SetVerticalAlignment(VerticalAlignment.MIDDLE);
cellMain.SetHeight(cellMainHeight);
cellMain.SetWidth(cellMainWidth);
if (i == row && j == col)
{
cellMain.Add(text).Add(barcodeImage);
}
table.AddCell(cellMain);
if (j % 3 != 0)
{
Cell cellSpace = new Cell().SetBorder(Border.NO_BORDER);
cellSpace.SetHeight(cellMainHeight);
cellSpace.SetWidth(cellSpaceWidth);
cellSpace.SetMargin(0);
table.AddCell(cellSpace);
}
}
}
//cellMain.Add(num);
//table.AddCell(cellMain);
//cellMain = new Cell();
//cellMain.SetVerticalAlignment(VerticalAlignment.MIDDLE);
//cellMain.SetHeight(cellMainHeight);
//cellMain.SetWidth(cellMainWidth);
//table.AddCell(cellMain);
//cellSpace = new Cell();
//cellSpace.SetHeight(cellMainHeight);
//cellSpace.SetWidth(cellSpaceWidth);
//table.AddCell(cellSpace);
//cellMain = new Cell();
//cellMain.SetVerticalAlignment(VerticalAlignment.MIDDLE);
//cellMain.SetHeight(cellMainHeight);
//cellMain.SetWidth(cellMainWidth);
//table.AddCell(cellMain);
//cellMain = new Cell();
//cellMain.SetVerticalAlignment(VerticalAlignment.MIDDLE);
//cellMain.SetHeight(cellMainHeight);
//cellMain.SetWidth(cellMainWidth);
//table.AddCell(cellMain);
document.Add(table);
}
}
Process proc = new Process();
proc.StartInfo.FileName = exportFile;
proc.StartInfo.UseShellExecute = true;
proc.EnableRaisingEvents = true;
proc.Start();
proc.Exited += Proc_Exited;
//Spire.Pdf.PdfDocument document1 = new Spire.Pdf.PdfDocument();
//document1.LoadFromFile(exportFile);
//System.Drawing.Image img = document1.SaveAsImage(0, 300, 300);
//img.Save(exportImage);
}
