/// <summary>
/// Метод для записи конвертированого текста в PDF документ.
/// </summary>
/// <param name="p"></param>
public void WriteToFile(string p)
{
if (File.Exists(p))
{
File.Delete(p);
}
pdfData.createPDF(p);
}
private byte[] returnPdfInBytes()
{
System.IO.MemoryStream stream = new MemoryStream();
document.createPDF(stream);
document = null;
page = null;
return(stream.ToArray());
}
private void button1_Click(object sender, EventArgs e)
{
pdfDocument myDoc = new pdfDocument("RemiseImpot", "ME");
pdfPage myFirstPage = myDoc.addPage();
myDoc.createPDF(@"C:\Users\William\Documents\Remises_Impots.pdf");
myFirstPage = null;
myDoc = null;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
pdfDocument myDoc = new pdfDocument("TUTORIAL", "ME");
pdfPage myPage = myDoc.addPage();
myPage.addText("Hello,World!", 200, 450, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
myDoc.addTrueTypeFont(@"verdana.ttf", "verdana");
myPage.addText("Привет, мир!", 200, 250, myDoc.getFontReference("verdana"), 20);
myDoc.createPDF(@"test.pdf");
myPage = null;
myDoc = null;
}
public void CreatePDF(string pdfFileName)
{
try
{
myDoc.createPDF(pdfFileName);
}
catch
{
MessageBox.Show("Could not write results to PDF file." +
System.Environment.NewLine +
"Make sure file is not currently being viewed.", "PDF Error");
}
}
private IEnumerator createPdf()
{
pdfDocument myDoc = new pdfDocument("Palm Measure Application", "", false);
pdfPage myFirstPage = myDoc.addPage();
//yield return StartCoroutine(myFirstPage.newAddImage(Application.persistentDataPath + "/" + "screenshot.png", 0, 800));
myFirstPage.addText("Name: " + NameInputField.text, 0, 700, sharpPDF.Enumerators.predefinedFont.csCourier, 36);
myFirstPage.addText("Id: " + IdInputField.text, 0, 650, sharpPDF.Enumerators.predefinedFont.csCourier, 36);
myFirstPage.addText("Scale: " + PreviewZoomIndication.text, 0, 600, sharpPDF.Enumerators.predefinedFont.csCourier, 36);
myFirstPage.addText("Comments: " + CommentsInputField.text, 0, 550, sharpPDF.Enumerators.predefinedFont.csCourier, 36);
myDoc.createPDF(Application.persistentDataPath + "/Data.pdf");
yield return(null);
}
/// <summary>
/// Exports the chart to the specified output stream as binary. When
/// exporting to a web response the WriteToHttpResponse() method is likely
/// preferred.
/// </summary>
/// <param name="outputStream">An output stream.</param>
internal void WriteToStream(Stream outputStream)
{
switch (this.ContentType)
{
case "image/jpeg":
CreateSvgDocument().Draw().Save(
outputStream,
ImageFormat.Jpeg);
break;
case "image/png":
// PNG output requires a seekable stream.
using (MemoryStream seekableStream = new MemoryStream())
{
CreateSvgDocument().Draw().Save(
seekableStream,
ImageFormat.Png);
seekableStream.WriteTo(outputStream);
}
break;
case "application/pdf":
SvgDocument svgDoc = CreateSvgDocument();
Bitmap bmp = svgDoc.Draw();
pdfDocument doc = new pdfDocument(this.Name, null);
pdfPage page = doc.addPage(bmp.Height, bmp.Width);
page.addImage(bmp, 0, 0);
doc.createPDF(outputStream);
break;
case "image/svg+xml":
using (StreamWriter writer = new StreamWriter(outputStream))
{
writer.Write(this.Svg);
writer.Flush();
}
break;
default:
throw new InvalidOperationException(string.Format(
"ContentType '{0}' is invalid.", this.ContentType));
}
outputStream.Flush();
}
/// <summary>
/// imprimir O.S
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnImprimirOS_Click(object sender, EventArgs e)
{
if (ViewState["cmpIdOS"].ToString() == "0")
{
this.GravarOS();
}
ImprimirOs Imprimir = new ImprimirOs();
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
Imprimir.myDoc = myDoc;
Imprimir.myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
Imprimir.cmpCoObra = loadObra();
Imprimir.cmpIdOS = ViewState["cmpIdOS"].ToString();
Imprimir.NomeObra = "Serviços de TI";
Imprimir.EnderecoLogoOrion = Server.MapPath("~/Imagens/logo_Orion.jpg");
if (ViewState["cmpInLogoObra"].ToString() == "1")
{
Imprimir.EnderecoLogoObra = Server.MapPath("~/Imagens/logo_IPEN.bmp");
}
else
{
Imprimir.EnderecoLogoObra = "";
}
Imprimir.ImprimeOrdemServico();
string filename = "pdf" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf";
string nomepdf = Server.MapPath("~/Relatorios/" + filename);
myDoc.createPDF(nomepdf);
Response.Write("<script>window.open('" + Global.UrlRelatorio + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105');</script>");
// Impressão ambiente desenvolvimento local
//Response.Write("<script language='javascript'>"
// + "window.open('" + @"http://*****:*****@"http://172.10.10.2/HzWebManutencao_Desenv/Relatorios/" + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105')"
// + "</script>");
}
private void ImprimirFechamentoMes()
{
DataTable table = pesquisaOs();
if (table != null && table.Rows.Count > 0)
{
//filename = "FechaMes" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf";
string nomepdf = Server.MapPath("~/Relatorios/" + filename);
pdfDocument myDoc = HzWebManutencao.ImprimirFechamentoMes.ImprimeFechamento(table, txtDataInicial.Text.ToString(), txtDataFinal.Text.ToString());
myDoc.createPDF(nomepdf);
Response.Write("<script>window.open('" + Global.UrlRelatorio + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105');</script>");
// Impressão ambiente produção ambiente interno orion
//Response.Write("<script language='javascript'>"
// + "window.open('" + @"http://172.10.10.2/HzWebManutencao_Desenv/Relatorios/" + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105')"
// + "</script>");
}
}
private void ImprimirTodasOS()
{
DataTable table = pesquisaOs();
if (table != null && table.Rows.Count > 0)
{
ImprimirOs Imprimir = new ImprimirOs();
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
Imprimir.myDoc = myDoc;
Imprimir.cmpCoObra = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpCoObraGrupoLista;
Imprimir.NomeObra = cmbObra.SelectedItem.ToString();
Imprimir.EnderecoLogoOrion = Server.MapPath("~/Imagens/logo_Orion.jpg");
if (ViewState["cmpInLogoObra"].ToString() == "True")
{
Imprimir.EnderecoLogoObra = Server.MapPath("~/Imagens/logo_IPEN.bmp");
}
else
{
Imprimir.EnderecoLogoObra = "";
}
foreach (DataRow lin in table.Rows)
{
Imprimir.cmpIdOS = lin["cmpIdOs"].ToString();
Imprimir.myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
Imprimir.ImprimeOrdemServico();
}
//filename = "pdf" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf";
string nomepdf = Server.MapPath("~/Relatorios/" + filename);
myDoc.createPDF(nomepdf);
Response.Write("<script>window.open('" + Global.UrlRelatorio + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105');</script>");
// Impressão ambiente produção ambiente interno orion
//Response.Write("<script language='javascript'>"
// + "window.open('" + @"http://172.10.10.2/HzWebManutencao_Desenv/Relatorios/" + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105')"
// + "</script>");
}
}
/// <summary>
/// creates a pdf using:
/// #the given results
/// #name of active scene
/// #images from Screenshot folder
/// </summary>
/// <param name="results"> the results to be displayed in the pdf </param>
public void createPdf(List <Results> results)
{
//get name of scene and current date
sceneName = UnityEngine.SceneManagement.SceneManager.GetActiveScene().name;
date = System.DateTime.Now.ToString("dd-MM-yyyy_hh.mm");
docname = sceneName + "-" + date;
//create document
pdfDocument pdfDocument = new pdfDocument(docname, "TI-2020");
//make the first page
Titlepage(pdfDocument);
//add the results from the results, 1 page per result
addResults(results, pdfDocument);
//add foto's to the document, 1 foto per page
//get the image files
DirectoryInfo d = new DirectoryInfo(ScreenshotPath);
FileInfo[] files = d.GetFiles();
//sort image files by date
System.Array.Sort(files, (f1, f2) => f1.CreationTime.CompareTo(f2.CreationTime));
foreach (var file in files)
{
//create new page and add image
InsertImage(ScreenshotPath + "/" + file.Name, pdfDocument);
}
//save the pdf in folder
if (!Directory.Exists("pdf"))
{
Directory.CreateDirectory("pdf");
}
pdfDocument.createPDF(@"pdf/" + docname + ".pdf");
}
// Update is called once per frame
public IEnumerator CreatePDF()
{
pdfDocument myDoc = new pdfDocument("Sample Application", "Me", false);
pdfPage myFirstPage = myDoc.addPage();
// Debug.Log ( "Continue to create PDF");
myFirstPage.addText("Daily Report", 10, 730, predefinedFont.csHelveticaOblique, 30, new pdfColor(predefinedColor.csOrange));
/*Table's creation*/
pdfTable myTable = new pdfTable();
//Set table's border
myTable.borderSize = 1;
myTable.borderColor = new pdfColor(predefinedColor.csDarkBlue);
/*Add Columns to a grid*/
myTable.tableHeader.addColumn(new pdfTableColumn("Building1", predefinedAlignment.csRight, 120));
myTable.tableHeader.addColumn(new pdfTableColumn("Building2", predefinedAlignment.csCenter, 120));
myTable.tableHeader.addColumn(new pdfTableColumn("Building3", predefinedAlignment.csLeft, 150));
myTable.tableHeader.addColumn(new pdfTableColumn("Building4", predefinedAlignment.csLeft, 150));
pdfTableRow myRow = myTable.createRow();
myRow[0].columnValue = "A";
myRow[1].columnValue = "100 km/h";
myRow[2].columnValue = "180Kg";
myRow[3].columnValue = "Orange";
myTable.addRow(myRow);
pdfTableRow myRow1 = myTable.createRow();
myRow1[0].columnValue = "B";
myRow1[1].columnValue = "130 km/h";
myRow1[2].columnValue = "150Kg";
myRow1[3].columnValue = "Yellow";
myTable.addRow(myRow1);
/*Set Header's Style*/
myTable.tableHeaderStyle = new pdfTableRowStyle(predefinedFont.csCourierBoldOblique, 12, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightOrange));
/*Set Row's Style*/
myTable.rowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 8, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csWhite));
/*Set Alternate Row's Style*/
myTable.alternateRowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 8, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightYellow));
/*Set Cellpadding*/
myTable.cellpadding = 10;
/*Put the table on the page object*/
myFirstPage.addTable(myTable, 5, 700);
yield return(StartCoroutine(myFirstPage.newAddImage(Application.dataPath + "/picture2.jpg", 2, 100)));
myDoc.createPDF(attacName);
myTable = null;
Application.OpenURL(attacName);
}
protected void Page_Load(object sender, EventArgs e)
{
HzConexao c = new HzConexao(@"192.168.200.170\desenv", "sa", "rona3007", "HzManutencao", "System.Data.SqlClient");
String strFont = "Helvetica";
int leftMargin = 30;
int topMargin = 30;
int bottomMargin = 30;
int lineHeight = 20;
int linesPerPage;
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
// Add a page
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
// Load an image (I was able to load JPEG, GIF, TIFF, and BMP formats)
//myDoc.addImageReference(Server.MapPath("~/Assets/Images/Sample.gif"), "ex");
//myPage.addImage(myDoc.getImageReference("ex"), leftMargin, getTop(myPage, 120));
// Header Text
myPage.addText("Ordem de Serviço", leftMargin, getTop(myPage, 30),
myDoc.getFontReference(strFont), 15, pdfColor.Black);
// Body Text
//myPage.addText("Divisão de Administração Predial, Obras e Instalações", leftMargin, getTop(myPage, 50),
// myDoc.getFontReference(strFont), 10, pdfColor.Black);
//myPage.addText("Relatório emitido em: " + DateTime.Now.ToShortDateString(), leftMargin, getTop(myPage, 70),
// myDoc.getFontReference(strFont), 10, pdfColor.Black);
//pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
// new pdfTableStyle(myDoc.getFontReference(strFont),
// 10, pdfColor.Black, new pdfColor("d9d1b3")),
// new pdfTableStyle(myDoc.getFontReference(strFont),
// 10, pdfColor.Black, pdfColor.White),
// new pdfTableStyle(myDoc.getFontReference(strFont),
// 10, pdfColor.Black, pdfColor.White));
int q = 0;
int pg = 1;
int top = 40;
using (DataTable table = c.loadDataTable("select * from HzManutencao..vwATE_OS where cmpIdOS = 1"))
{
if (table != null && table.Rows.Count > 0)
{
DataRow r = table.Rows[0];
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2, new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
//// Create table's header
int cl = 0;
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(150, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Nº O.S.");
myTable.tableHeader.addColumn(420, predefinedAlignment.csLeft);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csLeft;
myTable.tableHeader[cl++].addText(r["cmpNuOS"].ToString());
// Create Table Row
pdfTableRow myRow = myTable.createRow();
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Data Solicitação:");
myRow[cl++].addText(r["cmpDtAbertura"].ToString().Trim());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Obra:");
myRow[cl++].addText(r["cmpNoObra"].ToString().Trim() + (r["cmpNuContrato"] != null ? " -> Contrato nº " + r["cmpNuContrato"].ToString() : ""));
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Soliciante:");
myRow[cl++].addText(r["cmpNoSolicitante"].ToString().Trim());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Local:");
myRow[cl++].addText(r["cmpDcLocal"].ToString().Trim());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Setor:");
myRow[cl++].addText(r["cmpNoSetor"].ToString().Trim());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Data Início:");
myRow[cl++].addText(r["cmpDtInicioAtendimento"].ToString() != "" ? DateTime.Parse(r["cmpDtInicioAtendimento"].ToString()).ToString("dd/MM/yyyy HH:mm") : "");
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Data Conclusão:");
myRow[cl++].addText(r["cmpDtConclusaoAtendimento"].ToString() != "" ? DateTime.Parse(r["cmpDtConclusaoAtendimento"].ToString()).ToString("dd/MM/yyyy HH:mm") : "");
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Descrição do Serviço:");
myRow[cl++].addText(r["cmpDcDescricaoSolicitacao"].ToString().Trim());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow.rowHeight = 50;
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Verificação do Serviço:");
myRow[cl++].addText(r["cmpDcObservacaoConclusao"].ToString().Trim());
myTable.addRow(myRow);
top += 10 * 9;
myPage.addTable(myTable);
top += 100;
myPage.addText("Material Utilizado", leftMargin, this.getTop(myPage, top), myDoc.getFontReference(strFont), 10, pdfColor.Black);
top += 12;
string sql = "select * from HzManutencao..vwATE_OSMaterial where cmpIdOS = " + r["cmpIdOS"].ToString();
using (DataTable tblMat = Global.GetConnection().loadDataTable(sql))
{
if (tblMat != null && tblMat.Rows.Count > 0)
{
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2, new pdfTableStyle(myDoc.getFontReference(strFont), 8, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 8, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
//top = 210;
myTable.coordY = getTop(myPage, top);
//// Create table's header
cl = 0;
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(350, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Descrição");
myTable.tableHeader.addColumn(30, predefinedAlignment.csCenter);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csCenter;
myTable.tableHeader[cl++].addText("Unid");
myTable.tableHeader.addColumn(50, predefinedAlignment.csRight);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csRight;
myTable.tableHeader[cl++].addText("Qtd.");
myTable.tableHeader.addColumn(50, predefinedAlignment.csRight);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csRight;
myTable.tableHeader[cl++].addText("Preço");
myTable.tableHeader.addColumn(90, predefinedAlignment.csRight);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csRight;
myTable.tableHeader[cl++].addText("Sub-Total");
top += 15;
float total = 0f;
foreach (DataRow row in tblMat.Rows)
{
// Create Table Row
myRow = myTable.createRow();
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText(row["DcMaterial"].ToString().Trim());
myRow[cl++].addText(row["cmpDcUnidade"].ToString().Trim());
myRow[cl++].addText(decimal.Parse(row["cmpQtMaterial"].ToString()).ToString("0,0.00"));
myRow[cl++].addText(decimal.Parse(row["cmpVlMaterial"].ToString()).ToString("0,0.00"));
myRow[cl++].addText(decimal.Parse(row["cmpVlSubTotal"].ToString()).ToString("0,0.00"));
total += float.Parse(row["cmpVlSubTotal"].ToString());
myTable.addRow(myRow);
top += 12;
}
myPage.addTable(myTable);
top += 3;
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2, new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
//// Create table's header
cl = 0;
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(570, predefinedAlignment.csRight);
//IFormatProvider fp = new CultureInfo("pt-BR", true);
myTable.tableHeader[cl++].addText("Total: " + total.ToString("0,0.00"));
top += 17;
myPage.addTable(myTable);
}
}
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2, new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
//// Create table's header
cl = 0;
myTable.tableHeader.rowHeight = 30;
myTable.tableHeader.rowVerticalAlign = predefinedVerticalAlignment.csTop;
myTable.tableHeader.addColumn(570, predefinedAlignment.csLeft);
myTable.tableHeader[cl].columnVerticalAlign = predefinedVerticalAlignment.csTop;
myTable.tableHeader[cl++].addText("Conclusão/Aceite do Solicitante");
top += 30;
cl = 0;
myRow = myTable.createRow();
myRow.rowHeight = 10;
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Data: " + DateTime.Now.ToShortDateString() + " às " + DateTime.Now.ToShortTimeString());
myTable.addRow(myRow);
top += 15;
cl = 0;
myRow = myTable.createRow();
myRow.rowHeight = 10;
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Satisfeito com o serviço: " + "__Sim __Não");
myTable.addRow(myRow);
top += 15;
myPage.addTable(myTable);
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2, new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 10, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
cl = 0;
myTable.tableHeader.rowHeight = 50;
myTable.tableHeader.rowVerticalAlign = predefinedVerticalAlignment.csBottom;
myTable.tableHeader.addColumn(285, predefinedAlignment.csCenter);
myTable.tableHeader[cl].columnVerticalAlign = predefinedVerticalAlignment.csBottom;
myTable.tableHeader[cl++].addText("De acordo Empresa");
myTable.tableHeader.addColumn(285, predefinedAlignment.csCenter);
myTable.tableHeader[cl].columnVerticalAlign = predefinedVerticalAlignment.csBottom;
myTable.tableHeader[cl].addText("De acordo Gestor");
myPage.addTable(myTable);
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 5, pdfColor.Black);
//string nomepdf = "c:\\Horizon\\Ocr\\Relatorios\\" + "Relatorio_" + (txtPlacaRelatorio.Text != "" ? txtPlacaRelatorio.Text : "Todas") + "_" + retornaDataRelatorio(txtDataInicial.Text) + "_" + retornaDataRelatorio(txtDataFinal.Text) + ".pdf";
string nomepdf = Server.MapPath("pdf" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf");
myDoc.createPDF(nomepdf);
System.Diagnostics.Process.Start(nomepdf);
}
}
++q;
//if (q == 30)
//{
// myPage.addText("Pág. " + pg++, leftMargin, 10,
// myDoc.getFontReference(strFont), 5, pdfColor.Black);
// myPage.addTable(myTable);
// myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
// q = 0;
// myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 5,
// new pdfTableStyle(myDoc.getFontReference(strFont),
// 10, pdfColor.Black, new pdfColor("d9d1b3")),
// new pdfTableStyle(myDoc.getFontReference(strFont),
// 10, pdfColor.Black, pdfColor.White),
// new pdfTableStyle(myDoc.getFontReference(strFont),
// 10, pdfColor.Black, pdfColor.White));
// myTable.coordX = leftMargin;
// myTable.coordY = getTop(myPage, 100);
// // Create table's header
// myTable.tableHeader.rowHeight = 10;
// c = 0;
// myTable.tableHeader.addColumn(100, predefinedAlignment.csCenter);
// myTable.tableHeader[c++].addText("Placa");
// if (rdbAcesso.IsChecked.Value)
// {
// myTable.tableHeader.addColumn(200, predefinedAlignment.csLeft);
// myTable.tableHeader[c++].addText("Nome");
// }
// myTable.tableHeader.addColumn(150, predefinedAlignment.csCenter);
// myTable.tableHeader[c++].addText("Data");
// if (rdbAcesso.IsChecked.Value)
// {
// myTable.tableHeader.addColumn(100, predefinedAlignment.csCenter);
// myTable.tableHeader[c].addText("Cancela");
// }
// myPage.addText("Procuradoria Geral da República", leftMargin, getTop(myPage, 30),
// myDoc.getFontReference(strFont), 20, pdfColor.Black);
// // Body Text
// myPage.addText("Relatório dos Acessos à Garagem", leftMargin, getTop(myPage, 50),
// myDoc.getFontReference(strFont), 10, pdfColor.Black);
// myPage.addText("Relatório emitido em: " + DateTime.Now.ToShortDateString(), leftMargin, getTop(myPage, 70),
// myDoc.getFontReference(strFont), 10, pdfColor.Black);
//}
}
// Update is called once per frame
public IEnumerator CreatePDF()
{
pdfDocument myDoc = new pdfDocument("Sample Application", "Me", false);
pdfPage myFirstPage = myDoc.addPage();
pdfPage mySecondPage = myDoc.addPage();
Debug.Log("Continue to create PDF");
myFirstPage.addText("ADMIN Summary Sheet", 10, 730, predefinedFont.csHelveticaOblique, 30, new pdfColor(predefinedColor.csOrange));
/*Table's creation*/
pdfTable myTable = new pdfTable();
//Set table's border
myTable.borderSize = 1;
myTable.borderColor = new pdfColor(predefinedColor.csDarkBlue);
/*Add Columns to a grid*/
myTable.tableHeader.addColumn(new pdfTableColumn("faculty name", predefinedAlignment.csLeft, 90));
myTable.tableHeader.addColumn(new pdfTableColumn("year", predefinedAlignment.csLeft, 90));
myTable.tableHeader.addColumn(new pdfTableColumn("subject", predefinedAlignment.csLeft, 90));
myTable.tableHeader.addColumn(new pdfTableColumn("section", predefinedAlignment.csLeft, 90));
myTable.tableHeader.addColumn(new pdfTableColumn("category name", predefinedAlignment.csLeft, 90));
myTable.tableHeader.addColumn(new pdfTableColumn("filename", predefinedAlignment.csLeft, 90));
myTable.tableHeader.addColumn(new pdfTableColumn("extension", predefinedAlignment.csLeft, 50));
pdfTableRow myRow = myTable.createRow();
myRow[0].columnValue = "preeti";
myRow[1].columnValue = "2017-18";
myRow[2].columnValue = "4-Linux System Programming";
myRow[3].columnValue = "A";
myRow[4].columnValue = "Ethics";
myRow[5].columnValue = "facnames(1).pdf";
myRow[6].columnValue = "pdf";
myTable.addRow(myRow);
//pdfTableRow myRow1 = myTable.createRow();
//myRow1[0].columnValue = "B";
//myRow1[1].columnValue = "130 km/h";
//myRow1[2].columnValue = "150Kg";
//myRow1[3].columnValue = "Yellow";
//myTable.addRow(myRow1);
/*Set Header's Style*/
myTable.tableHeaderStyle = new pdfTableRowStyle(predefinedFont.csCourierBoldOblique, 12, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightOrange));
/*Set Row's Style*/
myTable.rowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 8, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csWhite));
/*Set Alternate Row's Style*/
myTable.alternateRowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 8, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightYellow));
/*Set Cellpadding*/
myTable.cellpadding = 10;
/*Put the table on the page object*/
myFirstPage.addTable(myTable, 5, 700);
//yield return StartCoroutine(myFirstPage.newAddImage("D:/TEMPORARY/UnitySharpPDF/picture2.jpg", 2, 100));
//yield return StartCoroutine(mySecondPage.newAddImage("D:/TEMPORARY/UnitySharpPDF/picture1.jpg", 2, 100));
yield return(myFirstPage);
yield return(mySecondPage);
myDoc.createPDF(attacName);
Debug.Log(" pdf created ");
myTable = null;
//yield return null;
}
private void btnGeneratePDF_Click(object sender, EventArgs e)
{
// Si un employé est sélectionné
if (this.dataEmployes.SelectedRows.Count > 0)
{
FolderBrowserDialog folderBrowserDialog = new System.Windows.Forms.FolderBrowserDialog();
DialogResult result = folderBrowserDialog.ShowDialog();
if (result == DialogResult.OK)
{
IGestionEmployes
gestionEmployes = GestionEmployesBuilderClassFactory.getInterface();
string folderName = folderBrowserDialog.SelectedPath;
int selectedRowIndex = this.dataEmployes.SelectedRows[0].Index;
int IdUtilisateur = Convert.ToInt32(this.dataEmployes.Rows[selectedRowIndex].Cells["IdUtilisateur"].Value);
object[] tabInfoUser = gestionEmployes.findUtilisateur(IdUtilisateur);
Utilisateur utilisateur = (Utilisateur)tabInfoUser[0];
Adresse adresse = (Adresse)tabInfoUser[1];
Societe societe = (Societe)tabInfoUser[2];
Role role = (Role)tabInfoUser[3];
Ville ville = (Ville)tabInfoUser[4];
FormModificationEmploye form = new FormModificationEmploye();
// Génération du fichier PDF
try
{
pdfDocument myDoc = new pdfDocument("Sample Application", "Me", false);
pdfPage myFirstPage = myDoc.addPage(700, 700);
myFirstPage.addText("Fiche d'information - " + utilisateur.Prenom.Trim() + " " + utilisateur.Nom.Trim(),
100, 630, predefinedFont.csHelvetica, 30, new pdfColor(predefinedColor.csBlack));
/*Table's creation*/
pdfTable myTable = new pdfTable();
//Set table's border
myTable.borderSize = 0;
myTable.borderColor = new pdfColor(predefinedColor.csBlack);
/*Create table's header*/
myTable.tableHeader.addColumn(new pdfTableColumn("Information", predefinedAlignment.csLeft, 150));
myTable.tableHeader.addColumn(new pdfTableColumn("Valeur", predefinedAlignment.csCenter, 250));
/*Create table's rows*/
pdfTableRow myRow = myTable.createRow();
myRow[0].columnValue = "Prénom";
myRow[1].columnValue = utilisateur.Prenom.Trim();
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Nom";
myRow[1].columnValue = utilisateur.Nom.Trim();
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Identifiant";
myRow[1].columnValue = utilisateur.Identifiant;
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Mot de passe";
myRow[1].columnValue = utilisateur.MotPasse;
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Rôle";
myRow[1].columnValue = role.CodeRole;
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Date de début";
myRow[1].columnValue = utilisateur.DateDebut.ToShortDateString();
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Date de fin";
myRow[1].columnValue = utilisateur.DateFin.ToShortDateString();
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Adresse";
myRow[1].columnValue = adresse.NumeroRue + " " + adresse.NomRue + ", " + adresse.CodePostal + " " +
ville.CodeVille;
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Nom de société";
myRow[1].columnValue = societe.NomSociete;
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Description de société";
myRow[1].columnValue = societe.DescriptionSociete;
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[0].columnValue = "Numéro de siret";
myRow[1].columnValue = societe.NumeroSiret;
myTable.addRow(myRow);
/*Set Header's Style*/
myTable.tableHeaderStyle = new pdfTableRowStyle(predefinedFont.csHelveticaBold, 12,
new pdfColor(predefinedColor.csWhite), new pdfColor(predefinedColor.csRed));
/*Set Row's Style*/
myTable.rowStyle = new pdfTableRowStyle(predefinedFont.csHelvetica, 10, new pdfColor(predefinedColor.csBlack),
new pdfColor(predefinedColor.csWhite));
/*Set Alternate Row's Style*/
myTable.alternateRowStyle = new pdfTableRowStyle(predefinedFont.csHelvetica, 10,
new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightGray));
/*Set Cellpadding*/
myTable.cellpadding = 10;
/*Put the table on the page object*/
myFirstPage.addTable(myTable, 150, 550);
myTable = null;
myDoc.createPDF(folderName + "\\FicheInformation.pdf");
MessageBox.Show("Le fichier PDF a bien été créé", "Génération de PDF");
Process.Start(folderName + "\\FicheInformation.pdf");
// Fin de génération du fichier PDF
}
// Quand il y a une erreur
catch (Exception exception)
{
MessageBox.Show("L'erreur suivante s'est produite : " + exception.Message + "", "Erreur lors de l'éxécution");
}
}
}
// Si aucun employé n'est sélectionné
else
{
MessageBox.Show("Sélectionnez un utilisateur.", "Génération fichier PDF");
}
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
string date1 = Date1.Text;
string date2 = Date2.Text;
string[] dateSeparator = { "/" };
string[] wordDate1 = date1.Split(dateSeparator, StringSplitOptions.RemoveEmptyEntries);
string[] wordDate2 = date2.Split(dateSeparator, StringSplitOptions.RemoveEmptyEntries);
string text = "";
XmlTextReader reader = new XmlTextReader("calendar.xml");
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Element: // Узел является элементом.
text = text + "<" + reader.Name + ">";
break;
case XmlNodeType.Text: // Вывести текст в каждом элементе.
text = text + reader.Value;
break;
case XmlNodeType.EndElement: // Вывести конец элемента.
text = text + "</" + reader.Name + ">";
break;
}
}
string[] separator = { "<", ">", " " };
string[] word = text.Split(separator, StringSplitOptions.RemoveEmptyEntries);// Разделение текста на слова
int i = 0;
pdfDocument myDoc = new pdfDocument("TUTORIAL", "ME");
string newText = "";
while (i < word.Length)
{
int j = i + 1;
if (word[i] == "First")
{
while (word[j] != "/First")
{
newText = newText + word[j] + " ";
j = j + 1;
}
newText = newText + "; ";
}
if (word[i] == "Check")
{
while (word[j] != "/Check")
{
newText = newText + word[j] + " ";
j = j + 1;
}
newText = newText + "; ";
}
if (word[i] == "Date")
{
string[] currentDate = word[i + 1].Split(dateSeparator, StringSplitOptions.RemoveEmptyEntries);
if (Convert.ToInt32(currentDate[2]) >= Convert.ToInt32(wordDate1[2]) && Convert.ToInt32(currentDate[2]) <= Convert.ToInt32(wordDate2[2]))
{
if (Convert.ToInt32(currentDate[0]) >= Convert.ToInt32(wordDate1[0]) && Convert.ToInt32(currentDate[0]) <= Convert.ToInt32(wordDate2[0]))
{
if (Convert.ToInt32(currentDate[1]) >= Convert.ToInt32(wordDate1[1]) && Convert.ToInt32(currentDate[1]) <= Convert.ToInt32(wordDate2[1]))
{
while (word[j] != "/Date")
{
newText = newText + word[j] + " ";
j = j + 1;
}
newText = newText + ".";
pdfPage myPage = myDoc.addPage();
myPage.addText(newText, 20, 700, myDoc.getFontReference(predefinedFont.csCourier), 14);
myDoc.createPDF(@"Dairy.pdf");
myPage = null;
newText = "";
}
else
{
newText = "";
}
}
else
{
newText = "";
}
}
else
{
newText = "";
}
}
i++;
}
myDoc = null;
}
private void Main(object link)
{
try
{
_novel = KitaabGhar.GetNovelInformation(link.ToString());
LogMessage("Information collected.");
LogMessage(string.Format("Total pages: {0} ({1} - {2})", _novel.TotalPages,
_novel.FirstIndex, _novel.LastIndex));
}
catch (Exception ex)
{
LogMessage("Error: " + ex.Message);
_running = false;
return;
}
var directory = System.Web.Hosting.HostingEnvironment.MapPath(Path.Combine(DownloadLocation, _novel.Name));
if (directory == null)
{
LogMessage("Unable to get permission");
return;
}
var imageFormat = Path.Combine(directory, "{0}.gif");
Directory.CreateDirectory(directory);
for (var i = _novel.FirstIndex; i <= _novel.LastIndex; i++)
{
LogMessage("Downloading page: " + i);
var r = 0;
Retry:
if (!_running)
{
return;
}
try
{
//TODO retries
if (r <= 3)
{
//TODO resume
//if (!(true && File.Exists(string.Format(imageFormat, i))))
if (!File.Exists(string.Format(imageFormat, i)))
{
var tempImage = Http.DownloadImage(_novel.GetImageLink(i), _novel.GetRefLink(i),
_novel.NewFormat);
tempImage.Save(string.Format(imageFormat, i));
tempImage.Dispose();
}
if (!_running)
{
return;
}
Progress((int)((double)((i - _novel.FirstIndex) * 100) / _novel.TotalPages));
}
else
{
LogMessage("Unable to download within the provided number of retries.");
}
}
catch
(Exception
ex)
{
LogMessage("Unable to download page: " + i);
LogMessage("Trying to download page" + i + " again.");
LogMessage("Error: " + ex.Message);
r++;
goto Retry;
}
}
LogMessage("Download complete.");
//TODO ApplicationSettings.CreatePdf
if (true)
{
LogMessage("Creating PDF file.");
try
{
using (var pdfFile = new pdfDocument(_novel.Name, "Abdullah Saleem"))
{
for (var i = _novel.FirstIndex; i <= _novel.LastIndex; i++)
{
var file = string.Format(imageFormat, i);
LogMessage("Processing page: " + i);
if (File.Exists(file))
{
try
{
using (var image = Image.FromFile(file))
{
pdfFile.addImageReference(file, i.ToString(CultureInfo.InvariantCulture));
var tempPage = pdfFile.addPage(image.Height, image.Width);
tempPage.addImage(
pdfFile.getImageReference(i.ToString(CultureInfo.InvariantCulture)), 0, 0);
}
LogMessage("Page " + i + " added.");
}
catch (Exception)
{
LogMessage("Page number " + i + "missing.");
}
}
else
{
LogMessage("Page number " + i + "missing.");
}
}
pdfFile.createPDF(Path.Combine(directory, _novel.Name + ".pdf"));
LogMessage("PDF Created!");
//TODO ApplicationSettings.OpenPdf
//if (false)
//{
// Process.Start(Path.Combine(directory, _novel.Name + ".pdf"));
//}
}
}
catch (Exception ex)
{
LogMessage("Error occured while creating the PDF.");
LogMessage("Error: " + ex.Message);
}
}
//TODO: ApplicationSettings.DeleteImages
if (true)
{
LogMessage("Deleting images.");
for (var i = _novel.FirstIndex; i <= _novel.LastIndex; i++)
{
if (File.Exists(string.Format(imageFormat, i)))
{
try
{
File.Delete(string.Format(imageFormat, i));
}
catch (Exception ex)
{
LogMessage("Error occured while deleting images.");
LogMessage("Error: " + ex.Message);
}
}
}
}
LogMessage("Completed.");
}
private void onCreatePDFFile()
{
if (string.IsNullOrWhiteSpace(fileName))
{
NotifyWindow notifyWindow = new NotifyWindow("错误", "请先输入生成PDF文件名称!");
notifyWindow.Show();
return;
}
if (ImagesList.Count == 0)
{
NotifyWindow notifyWindow = new NotifyWindow("错误", "请先添加文件!");
notifyWindow.Show();
return;
}
pdfDocument doc = new pdfDocument(fileName, "", false);
bool getIamge = false;
foreach (AddImageEntity imageEntity in ImagesList)
{
try
{
WriteableBitmap bitmap;
using (FileStream fs = new FileStream(imageEntity.FilePath, FileMode.Open))
{
BitmapImage bi = new BitmapImage();
bi.SetSource(fs);
bitmap = new WriteableBitmap(bi);
}
if (null != bitmap)
{
pdfPage page = doc.addPage((int)bitmap.PixelHeight, (int)bitmap.PixelWidth);
page.addImage(bitmap, 0, 0);
getIamge = true;
createPDFFileSuccess = true;
}
else
{
createPDFFileSuccess = false;
}
}
catch
{
createPDFFileSuccess = false;
NotifyWindow notifyWindow = new NotifyWindow("错误", string.Format("打开图片文件{0}失败，请检查文件!!!", imageEntity.FilePath));
notifyWindow.Show();
}
}
if (getIamge)
{
tempPDFFile = System.IO.Path.GetTempFileName();
using (FileStream fs = new FileStream(tempPDFFile, FileMode.Create))
{
doc.createPDF(fs);
}
UserFile = new UserFile();
UserFile.FileName = fileName;
UserFile.FileFolder = taxPayerEntity.TaxPayerId.ToString();
UserFile.FileStream = (new FileInfo(tempPDFFile)).OpenRead();
taxPayerDocumentEntity = new TaxPayerDocumentEntity();
taxPayerDocumentEntity.TaxPayerDocumentBytes = UserFile.FileStream.Length;
(OnUpdate as DelegateCommand).RaiseCanExecuteChanged();
UpdateChanged("UserFile");
}
}
protected void grdOS_RowCommand(object sender, GridViewCommandEventArgs e)
{
string[] ParImpressao = e.CommandArgument.ToString().Split(new char[] { '$' });
try
{
string p;
switch (e.CommandName.ToLower().Trim())
{
case "lnk":
if (cmbObra.SelectedItem.ToString().TrimEnd() == "SERVIÇOS DE TI" || chkServicosTI.Checked == true)
{
p = "webATE_ServicosTI.aspx?id=" + e.CommandArgument.ToString();
}
else
{
p = "webATE_OS.aspx?id=" + e.CommandArgument.ToString();
}
Response.Redirect(p, false);
break;
case "btn":
ImprimirOs Imprimir = new ImprimirOs();
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
Imprimir.myDoc = myDoc;
Imprimir.myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
Imprimir.cmpCoObra = ParImpressao[0].ToString();
Imprimir.cmpIdOS = ParImpressao[1].ToString();
Imprimir.NomeObra = cmbObra.SelectedItem.ToString();
Imprimir.EnderecoLogoOrion = Server.MapPath("~/Imagens/logo_Orion.jpg");
if (ViewState["cmpInLogoObra"].ToString() == "1")
{
Imprimir.EnderecoLogoObra = Server.MapPath("~/Imagens/logo_IPEN.bmp");
}
else
{
Imprimir.EnderecoLogoObra = "";
}
Imprimir.ImprimeOrdemServico();
//filename = "pdf" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf";
//string nomepdf = Server.MapPath("~/Relatorios/" + filename);
myDoc.createPDF(Server.MapPath("~/Relatorios/" + filename));
Response.Write("<script>window.open('" + Global.UrlRelatorio + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105');</script>");
break;
case "log":
DataTable dtLog = tblLogOS.LogOS(Global.GetConnection(), e.CommandArgument.ToString().Trim());
grdLogs.DataSource = dtLog;
grdLogs.DataBind();
ModalPopupExtender2.Show();
break;
}
}
catch (Exception ex)
{
Global.ShowError(Global.Title, ex);
}
}
public int CreatePDF(int id, string idrecord)
{
int pageIndex = 0;
int tableIndex = 0;
DateTime dateNow = DateTime.Now;
string getDate = String.Format("{0:D4}/{1:D2}/{2:D2} {3:D2}:{4:D2}", dateNow.Year, dateNow.Month, dateNow.Day, dateNow.Hour, dateNow.Minute);
this.Get_user(id);
this.Get_GameDetail(idrecord);
this.Get_GameRecord(id, idrecord);
attachName = "Rundom_" + nama.ToUpper() + "_" + gametype + "_" + idrecord + ".pdf";
myDoc = new pdfDocument("Rundom PDF Proses", "rajebdev", false);
myFirstPage = myDoc.addPage();
pageList.Add(myFirstPage);
pageList[0].addText("Hasil Perkembangan Siswa - RUNDOM GAME", 45, 730, predefinedFont.csHelveticaOblique, 20, new pdfColor(predefinedColor.csBlack));
pageList[0].addText("Nama Siswa : " + nama.ToUpper(), 50, 680, predefinedFont.csHelveticaOblique, 14, new pdfColor(predefinedColor.csBlack));
pageList[0].addText("Jenis Kelamin : " + sex, 50, 660, predefinedFont.csHelveticaOblique, 14, new pdfColor(predefinedColor.csBlack));
pageList[0].addText("Tingkatan : " + gametype, 50, 640, predefinedFont.csHelveticaOblique, 14, new pdfColor(predefinedColor.csBlack));
pageList[0].addText("ID Permainan : " + idrecord, 50, 620, predefinedFont.csHelveticaOblique, 14, new pdfColor(predefinedColor.csBlack));
pageList[0].addText("Ringkasan Permainan ", 50, 580, predefinedFont.csHelveticaOblique, 16, new pdfColor(predefinedColor.csBlack));
tableList.Add(new pdfTable());
//Set table's border
tableList[tableIndex].borderSize = 1;
tableList[tableIndex].borderColor = new pdfColor(predefinedColor.csDarkBlue);
/*Set Header's Style*/
tableList[tableIndex].tableHeaderStyle = new pdfTableRowStyle(predefinedFont.csCourierBoldOblique, 12, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightOrange));
tableList[tableIndex].rowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 12, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csWhite));
tableList[tableIndex].alternateRowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 12, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightYellow));
tableList[tableIndex].cellpadding = 7;
//==========================
/*Add Columns to a grid*/
tableList[tableIndex].tableHeader.addColumn(new pdfTableColumn("Keterangan", predefinedAlignment.csCenter, 150));
tableList[tableIndex].tableHeader.addColumn(new pdfTableColumn("Nilai", predefinedAlignment.csCenter, 200));
pdfTableRow myRow = tableList[tableIndex].createRow();
myRow[0].columnValue = "Jumlah Benar";
myRow[1].columnValue = nilaibenar;
tableList[tableIndex].addRow(myRow);
pdfTableRow myRow1 = tableList[tableIndex].createRow();
myRow1[0].columnValue = "Jumlah Salah";
myRow1[1].columnValue = nilaisalah;
tableList[tableIndex].addRow(myRow1);
pdfTableRow myRow2 = tableList[tableIndex].createRow();
myRow2[0].columnValue = "Score";
myRow2[1].columnValue = score;
tableList[tableIndex].addRow(myRow2);
pdfTableRow myRow3 = tableList[tableIndex].createRow();
myRow3[0].columnValue = "Waktu";
myRow3[1].columnValue = time + " Detik";
tableList[tableIndex].addRow(myRow3);
pdfTableRow myRow4 = tableList[tableIndex].createRow();
myRow4[0].columnValue = "Total Lompatan";
myRow4[1].columnValue = (int.Parse(nilaibenar) + int.Parse(nilaisalah)).ToString() + " Kali";
tableList[tableIndex].addRow(myRow4);
pageList[pageIndex].addTable(tableList[tableIndex], 55, 560);
// Detail Permainan
pageList[0].addText("Detail Permainan ", 50, 350, predefinedFont.csHelveticaOblique, 16, new pdfColor(predefinedColor.csBlack));
tableList.Add(new pdfTable());
//Set table's border
tableList[tableIndex].borderSize = 1;
tableList[tableIndex].borderColor = new pdfColor(predefinedColor.csDarkBlue);
/*Set Header's Style*/
tableList[1].tableHeaderStyle = new pdfTableRowStyle(predefinedFont.csCourierBoldOblique, 11, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightOrange));
tableList[1].rowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 11, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csWhite));
tableList[1].alternateRowStyle = new pdfTableRowStyle(predefinedFont.csCourier, 11, new pdfColor(predefinedColor.csBlack), new pdfColor(predefinedColor.csLightYellow));
tableList[1].cellpadding = 5;
//==========================
/*Add Columns to a grid*/
tableList[1].tableHeader.addColumn(new pdfTableColumn("No", predefinedAlignment.csCenter, 30));
tableList[1].tableHeader.addColumn(new pdfTableColumn("Soal", predefinedAlignment.csCenter, 150));
tableList[1].tableHeader.addColumn(new pdfTableColumn("Jawab", predefinedAlignment.csCenter, 150));
tableList[1].tableHeader.addColumn(new pdfTableColumn("Kondisi", predefinedAlignment.csCenter, 50));
tableList[1].tableHeader.addColumn(new pdfTableColumn("Score", predefinedAlignment.csCenter, 50));
tableList[1].tableHeader.addColumn(new pdfTableColumn("Waktu", predefinedAlignment.csCenter, 70));
// add data gameecord hit to data;
string connection = "URI=file:" + Application.dataPath + "/StreamingAssets/rundomdb.db";
IDbConnection dbcon = new SqliteConnection(connection);
dbcon.Open();
IDbCommand cmnd_read = dbcon.CreateCommand();
IDataReader reader;
string query = "SELECT * FROM GameRecordHit" +
" WHERE idGameRecord='" + idrecord + "'";
cmnd_read.CommandText = query;
reader = cmnd_read.ExecuteReader();
int no = 1;
int tmp = 0;
while (reader.Read())
{
pdfTableRow tmpRow = tableList[1].createRow();
tmpRow[0].columnValue = no.ToString();
tmpRow[1].columnValue = soal[int.Parse(reader[1].ToString())];
tmpRow[2].columnValue = reader[6].ToString() + " " + namaBangun[int.Parse(reader[5].ToString())];
tmpRow[3].columnValue = reader[3].ToString() == "0" ? "SALAH" : "BENAR";
tmpRow[4].columnValue = reader[4].ToString();
tmpRow[5].columnValue = (int.Parse(reader[7].ToString()) - tmp).ToString() + " Detik";
tmp = int.Parse(reader[7].ToString());
tableList[1].addRow(tmpRow);
no++;
}
pageList[pageIndex].addTable(tableList[1], 55, 330);
pageList[0].addText("Generate at " + getDate, 400, 50, predefinedFont.csHelveticaOblique, 8, new pdfColor(predefinedColor.csBlack));
myDoc.createPDF(Application.dataPath + "/StreamingAssets/Pdf File/" + attachName);
if (myDoc.isSucces == true)
{
pdfSuc.SetActive(true);
}
else
{
pdfWarn.SetActive(true);
}
pageList = null;
tableList = null;
return(0);
}
//Onglet Recapitulatif
private void btnCreeReca_Click(object sender, EventArgs e)
{
try
{
//Initialisation des variables
connec.Open();
string mois = dtpReca.Value.Month.ToString();
string annee = dtpReca.Value.Year.ToString();
string text = "____________________________________________________";
string typeNull = "Type NULL";
float montant = 0;
int recette = 0;
int percu = 0;
int indentation = 20;
int hauteurDesLignes = 720;
List <string> un = new List <string>();
List <string> de = new List <string>();
List <string> tr = new List <string>();
List <string> qu = new List <string>();
List <string> ci = new List <string>();
List <string> si = new List <string>();
List <Boolean> nbTransaction = new List <Boolean>();
pdfDocument myDoc = new pdfDocument("Recapitulatif_" + mois + "_" + annee, "Pique_Sous");
pdfPage myPage = myDoc.addPage();
//SQL
OleDbCommand cd1 = new OleDbCommand("SELECT [Transaction].* FROM [Transaction] WHERE MONTH([dateTransaction]) = " + dtpReca.Value.Month.ToString(), connec);
OleDbDataReader dr1 = cd1.ExecuteReader();
//Lecture de la base
while (dr1.Read())
{
nbTransaction.Add(dr1.GetBoolean(4));
if (dr1.GetBoolean(4) == true)
{
recette++;
}
if (dr1.GetBoolean(5) == true)
{
percu++;
}
montant = montant + dr1.GetFloat(3);
un.Add(dr1[1].ToString().Substring(0, 11));
de.Add(dr1[2].ToString());
tr.Add(dr1[3].ToString());
qu.Add(dr1[4].ToString());
ci.Add(dr1[5].ToString());
if (dr1[6].ToString() != "")
{
si.Add(dr1[6].ToString());
}
else
{
si.Add(typeNull);
}
}
for (int i = 0; i < si.Count; i++)
{
if (si[i] != typeNull)
{
//Pour eviter de faire une requette avec une jointure
OleDbCommand cd2 = new OleDbCommand("SELECT [TypeTransaction].* FROM [TypeTransaction] where [codeType] = " + si[i], connec);
OleDbDataReader dr2 = cd2.ExecuteReader();
while (dr2.Read())
{
si[i] = dr2[1].ToString();
}
}
}
//Creation du text dans le PDF
myPage.addText("Recapitulatif du : " + mois + "_" + annee, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText("Dépenses", indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - (30 + 25 * un.Count);
myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText("Recette : " + recette.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText(" Depenses : " + montant.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText("Reste a persevoir : " + percu.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText("Somme total dépensée : -" + montant.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText("nombres de transactions : " + nbTransaction.Count.ToString(), indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
hauteurDesLignes = hauteurDesLignes - 30;
myPage.addText(text, indentation, hauteurDesLignes, myDoc.getFontReference(predefinedFont.csHelvetica), 20);
//Initiallisation tableau PDF
pdfTable myTable = new pdfTable(myDoc);
myTable.borderSize = 1;
myTable.borderColor = sharpPDF.pdfColor.Black;
myTable.tableHeader.addColumn(90);
myTable.tableHeader.addColumn(120);
myTable.tableHeader.addColumn(70);
myTable.tableHeader.addColumn(70);
myTable.tableHeader.addColumn(70);
myTable.tableHeader.addColumn(110);
pdfTableRow myRow = myTable.createRow();
//Remplissage de la première ligne du tableau
myRow[0].addText("Date Transaction");
myRow[1].addText("Description");
myRow[2].addText("Montant");
myRow[3].addText("Recette ?");
myRow[4].addText("Perçu ?");
myRow[5].addText("Type de dépence ?");
myTable.addRow(myRow);
//Remplissage des ligne du tableau
for (int i = 0; i < un.Count; i++)
{
myRow = myTable.createRow();
myRow[0].addText(un[i]);
myRow[1].addText(de[i]);
myRow[2].addText(tr[i]);
myRow[3].addText(qu[i]);
myRow[4].addText(ci[i]);
myRow[5].addText(si[i]);
myTable.addRow(myRow);
}
//Place le tableau
myTable.coordY = 650;
myTable.coordX = 20;
myPage.addTable(myTable);
//creer le PDF
FolderBrowserDialog fbd = new FolderBrowserDialog();
if (fbd.ShowDialog() == DialogResult.OK)
{
myDoc.createPDF(fbd.SelectedPath + @"\Recapitulatif_" + mois + "_" + annee + ".pdf");
}
myPage = null;
myDoc = null;
connec.Close();
MessageBox.Show("PDF créé");
}
catch (InvalidOperationException erreur)
{
MessageBox.Show("Erreur de chaine de connexion ! pdf");
MessageBox.Show(erreur.Message);
}
catch (OleDbException erreur)
{
MessageBox.Show("Erreur de requete SQL ! pdf");
MessageBox.Show(erreur.Message);
}
}
protected void btnGerarRel_Click(object sender, EventArgs e)
{
System.Threading.Thread.Sleep(5000);
string filename;
string nomepdf;
DataTable table = new DataTable();
if (ViewState["tipoMaterial"] != null && ViewState["tipoMaterial"].ToString() == "LGMT")
{
table = RetornaMaterialObra();
if (table != null && table.Rows.Count > 0)
{
ImprimirMaterialObra Imprimir = new ImprimirMaterialObra();
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
filename = "MaterialObra" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf";
nomepdf = Server.MapPath("~/Relatorios/" + filename);
Imprimir.myDoc = myDoc;
Imprimir.myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
Imprimir.NomeObra = cmbObra.SelectedItem.ToString();
Imprimir.EnderecoLogoOrion = Server.MapPath("~/Imagens/logo_Orion.jpg");
if (ViewState["cmpInLogoObra"].ToString() == "True")
{
Imprimir.EnderecoLogoObra = Server.MapPath("~/Imagens/logo_IPEN.bmp");
}
else
{
Imprimir.EnderecoLogoObra = "";
}
Imprimir.ImprimeMaterial(table);
myDoc.createPDF(nomepdf);
btnImprimir.Visible = true;
btnImprimir.Attributes.Add("onclick", "window.open('" + Global.UrlRelatorio + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105');");
}
else
{
CaixaMensagem.Mostar(Mensagem.Tipo.Aviso, "Não há consumo de material para o período!");
}
}
else if (ViewState["tipoMaterial"] != null && ViewState["tipoMaterial"].ToString() == "LMUO")
{
if (ValidaPeriodo())
{
table = RetornaMaterialPeriodo();
if (table != null && table.Rows.Count > 0)
{
ImprimirMaterialObraPeriodo Imprimir = new ImprimirMaterialObraPeriodo();
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
filename = "MaterialObra" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf";
nomepdf = Server.MapPath("~/Relatorios/" + filename);
Imprimir.myDoc = myDoc;
Imprimir.myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
Imprimir.NomeObra = cmbObra.SelectedItem.ToString();
Imprimir.EnderecoLogoOrion = Server.MapPath("~/Imagens/logo_Orion.jpg");
if (ViewState["cmpInLogoObra"].ToString() == "True")
{
Imprimir.EnderecoLogoObra = Server.MapPath("~/Imagens/logo_IPEN.bmp");
}
else
{
Imprimir.EnderecoLogoObra = "";
}
Imprimir.DtInicial = txtDataInicial.Text.Substring(0, 10);
Imprimir.DtFinal = txtDataFinal.Text.Substring(0, 10);
Imprimir.ImprimeMaterial(table);
myDoc.createPDF(nomepdf);
btnImprimir.Visible = true;
btnImprimir.Attributes.Add("onclick", "window.open('" + Global.UrlRelatorio + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105');");
}
else
{
CaixaMensagem.Mostar(Mensagem.Tipo.Aviso, "Não há consumo de material para o período!");
}
}
}
else if (ViewState["tipoMaterial"] != null && ViewState["tipoMaterial"].ToString() == "LMUA")
{
if (ValidaPeriodo())
{
table = RetornaMaterialGrupoObraPeriodo();
if (table != null && table.Rows.Count > 0)
{
ImprimirMaterialGrupoObraPeriodo Imprimir = new ImprimirMaterialGrupoObraPeriodo();
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
filename = "MaterialObra" + DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Millisecond.ToString() + ".pdf";
nomepdf = Server.MapPath("~/Relatorios/" + filename);
Imprimir.myDoc = myDoc;
Imprimir.myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
Imprimir.NomeObra = cmbObra.SelectedItem.ToString();
Imprimir.EnderecoLogoOrion = Server.MapPath("~/Imagens/logo_Orion.jpg");
if (ViewState["cmpInLogoObra"].ToString() == "True")
{
Imprimir.EnderecoLogoObra = Server.MapPath("~/Imagens/logo_IPEN.bmp");
}
else
{
Imprimir.EnderecoLogoObra = "";
}
Imprimir.DtInicial = txtDataInicial.Text.Substring(0, 10);
Imprimir.DtFinal = txtDataFinal.Text.Substring(0, 10);
Imprimir.ImprimeMaterial(table);
myDoc.createPDF(nomepdf);
btnImprimir.Visible = true;
btnImprimir.Attributes.Add("onclick", "window.open('" + Global.UrlRelatorio + filename + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105');");
}
else
{
CaixaMensagem.Mostar(Mensagem.Tipo.Aviso, "Não há consumo de material para o período!");
}
}
}
}