protected void CabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, string nNuOs, string nNuDemanda)
{
String strFont = "Helvetica";
int leftMargin = 30;
//myDoc.addImageReference(EnderecoLogoOrion, "logo1");
//myPage.addImage(myDoc.getImageReference("logo1"), leftMargin, getTop(myPage, top));
//if (EnderecoLogoObra != "")
//{
// myDoc.addImageReference(EnderecoLogoObra, "logo2");
// myPage.addImage(myDoc.getImageReference("logo2"), 530, getTop(myPage, top));
//}
//top += 10;
myPage.addText("ORDEM DE SERVIÇO", 235, getTop(myPage, 30), myDoc.getFontReference(strFont), 12, pdfColor.Black);
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), 9, pdfColor.Black, pdfColor.White));
top += 20;
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader.addColumn(570, predefinedAlignment.csLeft);
myTable.tableHeader[cl].addText("Obra: " + DadosObra);
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), 9, pdfColor.Black, pdfColor.White));
top += 20;
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
cl = 0;
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader.addColumn(285, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Nº ORDEM DE SERVIÇO: " + nNuOs.ToString());
top += 20;
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader.addColumn(285, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Nº DEMANDA CLIENTE: " + nNuDemanda.ToString());
myPage.addTable(myTable);
}
protected static void SubCabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, DataRow row)
{
String strFont = "Helvetica";
int leftMargin = 30;
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 9, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 8, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader.addColumn(110, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("ATIVIDADE");
myTable.tableHeader.addColumn(60, predefinedAlignment.csCenter);
myTable.tableHeader[cl++].addText("DATA");
myTable.tableHeader.addColumn(80, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Nº PREVENTIVA");
myTable.tableHeader.addColumn(90, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("PERIODICIDADE");
myTable.tableHeader.addColumn(100, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("SITUAÇÃO");
myTable.tableHeader.addColumn(110, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("TIPO PREVENTIVA");
top += 20;
cl = 0;
pdfTableRow myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText(row["cmpDcTipoAtividade"].ToString().TrimEnd());
myRow[cl++].addText(row["cmpDtReprogramacaoPreventivaAgenda"].ToString().Substring(0, 10));
myRow[cl++].addText(row["cmpNuPreventivaAgenda"].ToString().TrimEnd());
myRow[cl++].addText(row["cmpDcPeriodicidade"].ToString().TrimEnd());
myRow[cl++].addText(row["EstadoManutencaoPreventiva"].ToString().TrimEnd());
myRow[cl++].addText(row["TPPREVENTIVA"].ToString().TrimEnd());
myTable.addRow(myRow);
myPage.addTable(myTable);
}
protected static void CabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, string NomeObra, string Atividade, string Periodicidade)
{
String strFont = "Helvetica";
int leftMargin = 30;
myPage.addText("Formulário de Manutenção Preventiva", 200, getTop(myPage, top),
myDoc.getFontReference(strFont), 12, pdfColor.Black);
top += 15;
myPage.addText("OBRA: " + NomeObra.TrimEnd(), leftMargin, getTop(myPage, top),
myDoc.getFontReference(strFont), 10, pdfColor.Black);
top += 15;
myPage.addText("TIPO ATIVIDADE: " + Atividade.TrimEnd() + " " + "PERIODICIDADE : " + Periodicidade.TrimEnd(), leftMargin, getTop(myPage, top),
myDoc.getFontReference(strFont), 10, pdfColor.Black);
}
// Constructor
public ReportWriter(string releaseVersion)
{
strFont = "Helvetica";
leftMargin = 60;
rightMargin = 60;
topMargin = 60;
bottomMargin = 60;
lineHeight = 20;
myDoc = new pdfDocument("Stormwater Calculator Report", "swc");
int strWidth = myDoc.getFontReference(strFont).getWordWidth("Page x Of x", 10);
int left = 612 - rightMargin - strWidth;
myDoc.pageMarker = new pdfPageMarker(left, bottomMargin - lineHeight, predefinedMarkerStyle.csArabic,
myDoc.getFontReference(strFont), 10);
footer = footer + releaseVersion;
}
public virtual int CabRelatorio(pdfDocument myDoc, pdfPage myPage, int top)
{
String strFont = "Helvetica";
int leftMargin = 30;
myPage.addText("Formulário de Manutenção Preventiva de Equipamento", 200, getTop(myPage, top),
myDoc.getFontReference(strFont), 12, pdfColor.Black);
top += 15;
myPage.addText("OBRA: " + cmpNoObra, leftMargin, getTop(myPage, top),
myDoc.getFontReference(strFont), 10, pdfColor.Black);
top += 15;
myPage.addText("TIPO ATIVIDADE: " + cmpDcTipoAtividade + " " + "PERIODICIDADE : " + cmpDcPeriodicidade, leftMargin, getTop(myPage, top),
myDoc.getFontReference(strFont), 10, pdfColor.Black);
top += 20;
myPage.addText("Dados do Equipamento", 230, getTop(myPage, top), myDoc.getFontReference(strFont), 12, pdfColor.Black);
return(top += 15);
}
protected static void ImprimeGrupo(pdfDocument myDoc, pdfPage myPage, int top, string GrupoAtividade)
{
String strFont = "Helvetica";
int leftMargin = 30;
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 9, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 8, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.addColumn(550, predefinedAlignment.csLeft);
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader[cl++].addText("GRUPO DE ATIVIDADE: " + GrupoAtividade);
myPage.addTable(myTable);
}
/// <summary>
/// Código da Ordem de Serviço
/// </summary>
//public string cmpIdOS { get; set; }
/// <summary>
/// Código da Obra
/// </summary>
//public string cmpCoObra { get; set; }
/// <summary>
/// Documento PDF
/// </summary>
//public pdfDocument myDoc { get; set; }
#endregion
#region Base Functions
protected static pdfTable CabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, string DadosObra, string DataInicial, string DataFinal)
{
String strFont = "Helvetica";
int leftMargin = 30;
// Cabeçalho Relatório
myPage.addText("Atendimentos Realizados - Período : " + DataInicial + " a " + DataFinal, leftMargin, getTop(myPage, 30),
myDoc.getFontReference(strFont), 15, pdfColor.Black);
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 11, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 11, pdfColor.Black, pdfColor.White));
top += 20;
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.rowHeight = 30;
myTable.tableHeader.addColumn(550, predefinedAlignment.csLeft);
myTable.tableHeader[cl].addText("Obra: " + DadosObra.ToString());
myPage.addTable(myTable);
top += 30;
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), 8, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
cl = 0;
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(450, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Descrição da Solicitação");
myTable.tableHeader.addColumn(100, predefinedAlignment.csCenter);
myTable.tableHeader[cl++].addText("Data da Conclusão");
top = +15;
return(myTable);
}
protected static pdfTable ItemAtividade(pdfDocument myDoc, pdfPage myPage, int top, DataRow r)
{
String strFont = "Helvetica";
int leftMargin = 30;
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 12, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 12, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.addColumn(550, predefinedAlignment.csCenter);
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader[cl++].addText("Itens da Manutenção");
myPage.addTable(myTable);
top += 20;
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.addColumn(20, predefinedAlignment.csLeft);
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader[cl++].addText("");
myTable.tableHeader.addColumn(530, predefinedAlignment.csLeft);
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader[cl++].addText(TiraCaractEspecial(r["cmpDcItemAtividadePreventiva"].ToString().TrimEnd()));
return(myTable);
}
protected void CabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, string DadosObra, string DtInicial, string DtFinal)
{
String strFont = "Helvetica";
int leftMargin = 30;
//myDoc.addImageReference(EnderecoLogoOrion, "logo1");
//myPage.addImage(myDoc.getImageReference("logo1"), leftMargin, getTop(myPage, top));
//if (EnderecoLogoObra != "")
//{
// myDoc.addImageReference(EnderecoLogoObra, "logo2");
// myPage.addImage(myDoc.getImageReference("logo2"), 530, getTop(myPage, top));
//}
//top += 20;
myPage.addText("AGENDA MANUTENÇÃO PREVENTIVA", 235, getTop(myPage, top),
myDoc.getFontReference(strFont), 12, pdfColor.Black);
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), 8, pdfColor.Black, pdfColor.White));
top += 10;
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader.addColumn(350, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Obra: " + DadosObra.ToString().TrimEnd());
myTable.tableHeader.addColumn(200, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Período: " + DtInicial + " a " + DtFinal);
myPage.addTable(myTable);
}
protected static pdfTable SubCabRelatorio(pdfDocument myDoc, pdfPage myPage, int top)
{
String strFont = "Helvetica";
int leftMargin = 30;
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 7, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 6, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(40, predefinedAlignment.csCenter);
myTable.tableHeader[cl++].addText("Nº O.S");
myTable.tableHeader.addColumn(80, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Solicitante");
myTable.tableHeader.addColumn(200, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Detalhamento Serviço");
myTable.tableHeader.addColumn(100, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Local");
myTable.tableHeader.addColumn(40, predefinedAlignment.csCenter);
myTable.tableHeader[cl++].addText("Abertura");
myTable.tableHeader.addColumn(40, predefinedAlignment.csCenter);
myTable.tableHeader[cl++].addText("Conclusão");
myTable.tableHeader.addColumn(50, predefinedAlignment.csRight);
myTable.tableHeader[cl++].addText("Total Material");
return(myTable);
}
protected static void SubCabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, string CoObra, string cmpCoPreventiva)
{
String strFont = "Helvetica";
int leftMargin = 30;
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 7, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 6, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.addColumn(200, predefinedAlignment.csCenter);
myTable.tableHeader.rowHeight = 20;
myTable.tableHeader[cl++].addText("Atividades da Manutenção Preventiva");
myPage.addTable(myTable);
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 7, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 5, pdfColor.Black, pdfColor.White));
top = 70;
myTable.coordX = 220;
myTable.coordY = getTop(myPage, top);
cl = 0;
myTable.tableHeader.addColumn(352, predefinedAlignment.csCenter);
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader[cl++].addText("Pavimentos");
myPage.addTable(myTable);
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 5, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 3, pdfColor.Black, pdfColor.White));
top += 10;
myTable.coordX = 220;
myTable.coordY = getTop(myPage, top);
cl = 0;
myTable.tableHeader.rowHeight = 10;
DataTable table = tblPreventivaAtividade.RetornaFormPreventivaPivot(Global.GetConnection(), cmpCoPreventiva, CoObra);
for (int i = 2; i <= 23; ++i)
{
myTable.tableHeader.addColumn(16, predefinedAlignment.csCenter);
if (i <= table.Columns.Count - 1)
{
myTable.tableHeader[cl++].addText(table.Columns[i].ColumnName.ToString());
}
else
{
myTable.tableHeader[cl++].addText("");
}
}
myPage.addTable(myTable);
}
protected static void CabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, string DadosObra)
{
String strFont = "Helvetica";
int leftMargin = 30;
myPage.addText("Plano de Manutenção Preventiva", leftMargin, getTop(myPage, 30), myDoc.getFontReference(strFont), 12, pdfColor.Black);
pdfTable myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 11, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 11, pdfColor.Black, pdfColor.White));
top += 10;
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
int cl = 0;
myTable.tableHeader.rowHeight = 25;
myTable.tableHeader.addColumn(550, predefinedAlignment.csLeft);
myTable.tableHeader[cl].addText("Obra: " + DadosObra.ToString());
myPage.addTable(myTable);
}
protected int GetCenteredOffset(pdfPage myPage, string text, int fontSize)
{
// Get width of string
int strWidth = myDoc.getFontReference(strFont).getWordWidth(text, fontSize);
// Find left coordinate
return((myPage.width - strWidth) / 2);
}
public static pdfDocument ImprimeFechamento(DataTable table, string DataInicial, string DataFinal)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 40;
//Tamanho da lin em pixel
int nTamLinPixel = 19;
// Variaveis de controle para quebra de linha de campos
int QtdCaracterLinha = 80;
int Tamanho;
int QtdLin;
int StrInicio;
int StrFim;
int cl;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
string DadosObra = (table.Rows[0]["cmpNoObra"].ToString().Trim() + (table.Rows[0]["cmpNuContrato"] != null ? " -> Contrato nº " + table.Rows[0]["cmpNuContrato"].ToString() : ""));
CabRelatorio(myDoc, myPage, top, DadosObra, DataInicial, DataFinal);
top += 30;
pdfTable myTable = SubCabRelatorio(myDoc, myPage, top);
top += 10;
// Imprimir linhas de detalhes
pdfTableRow myRow = myTable.createRow();
int cont = 0;
foreach (DataRow row in table.Rows)
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText(row["cmpNuOs"].ToString());
myRow[cl++].addText(row["cmpNoSolicitante"].ToString().TrimEnd());
row["cmpDcObservacoes"] = TiraCaractEspecial(row["cmpDcObservacoes"].ToString().ToUpper());
Tamanho = row["cmpDcObservacoes"].ToString().Length;
if (Tamanho > 0)
{
QtdLin = (Tamanho % QtdCaracterLinha == 0 ? Tamanho / QtdCaracterLinha : (Tamanho / QtdCaracterLinha) + 1);
StrInicio = 0;
for (int Linha = 1; Linha <= QtdLin; Linha++)
{
StrFim = Linha == QtdLin ? Tamanho - StrInicio : QtdCaracterLinha;
if (Linha == 1)
{
myRow[cl++].addText(row["cmpDcObservacoes"].ToString().Substring(StrInicio, StrFim).Trim());
if (row["cmpDcLocal"] != null)
{
cont++;
//System.Diagnostics.Debug.WriteLine(cont.ToString());
myRow[cl++].addText(TiraCaractEspecial(row["cmpDcLocal"].ToString()));
}
else
{
myRow[cl++].addText(" ");
}
myRow[cl++].addText(row["cmpDtAbertura"].ToString().Substring(0, 10));
myRow[cl++].addText(row["cmpDtConclusaoAtendimento"].ToString() == "" ? "" : row["cmpDtConclusaoAtendimento"].ToString().Substring(0, 10));
}
else
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText(row["cmpDcObservacoes"].ToString().Substring(StrInicio, StrFim).Trim());
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("");
}
myTable.addRow(myRow);
StrInicio += QtdCaracterLinha;
top += nTamLinPixel;
}
}
else
{
myRow[cl++].addText(row["cmpDcDescricaoSolicitacao"].ToString().TrimEnd());
myRow[cl++].addText(row["cmpDcLocal"].ToString());
myRow[cl++].addText(row["cmpDtAbertura"].ToString().Substring(0, 10));
myRow[cl++].addText(row["cmpDtConclusaoAtendimento"].ToString() == "" ? "" : row["cmpDtConclusaoAtendimento"].ToString().Substring(0, 10));
myTable.addRow(myRow);
top += nTamLinPixel;
}
if (top > 1230)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 30;
CabRelatorio(myDoc, myPage, top, DadosObra, DataInicial, DataFinal);
top += 30;
myTable = SubCabRelatorio(myDoc, myPage, top);
top = +10;
}
}
if (top < 1230)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
}
return(myDoc);
}
public static pdfDocument ImprimePlano(DataTable table, string NoObra)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 40;
//Tamanho da lin em pixel
int nTamLinPixel = 12;
// Variaveis de controle para quebra de linha de campos
int QtdCaracterLinha = 120;
int Tamanho;
int QtdLin;
int StrInicio;
int StrFim;
int cl;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
CabRelatorio(myDoc, myPage, top, NoObra);
top += 40;
// Create Table
pdfTable myTable;
// Create Table Row
pdfTableRow myRow;
string TipoAtividade = table.Rows[0]["cmpCoTipoAtividade"].ToString();
string GrupoAtividade = table.Rows[0]["cmpCoGrupoAtividade"].ToString();
string Periodicidade = table.Rows[0]["cmpCoPeriodicidade"].ToString();
myTable = SubCabRelatorio(myDoc, myPage, top, table.Rows[0]["cmpDcTipoAtividade"].ToString(), table.Rows[0]["cmpDcGrupoAtividade"].ToString(), table.Rows[0]["cmpDcPeriodicidade"].ToString());
top += 90;
int i = 1;
foreach (DataRow row in table.Rows)
{
cl = 0;
if (TipoAtividade != row["cmpCoTipoAtividade"].ToString() ||
GrupoAtividade != row["cmpCoGrupoAtividade"].ToString() ||
Periodicidade != row["cmpCoPeriodicidade"].ToString())
{
TipoAtividade = row["cmpCoTipoAtividade"].ToString();
GrupoAtividade = row["cmpCoGrupoAtividade"].ToString();
Periodicidade = row["cmpCoPeriodicidade"].ToString();
myPage.addTable(myTable);
if (pg == 2 && i == 0)
{
break;
}
top += 20;
myTable = SubCabRelatorio(myDoc, myPage, top, row["cmpDcTipoAtividade"].ToString(), row["cmpDcGrupoAtividade"].ToString(), row["cmpDcPeriodicidade"].ToString());
top += 90;
cl = 0;
i++;
}
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
row["cmpDcItemAtividadePreventiva"] = TiraCaractEspecial(row["cmpDcItemAtividadePreventiva"].ToString());
Tamanho = row["cmpDcItemAtividadePreventiva"].ToString().Length;
if (Tamanho > 0)
{
QtdLin = (Tamanho % QtdCaracterLinha == 0 ? Tamanho / QtdCaracterLinha : (Tamanho / QtdCaracterLinha) + 1);
StrInicio = 0;
for (int Linha = 1; Linha <= QtdLin; Linha++)
{
StrFim = Linha == QtdLin ? Tamanho - StrInicio : QtdCaracterLinha;
if (Linha == 1)
{
myRow[cl++].addText(row["cmpDcItemAtividadePreventiva"].ToString().Substring(StrInicio, StrFim).Trim());
}
else
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText(row["cmpDcItemAtividadePreventiva"].ToString().Substring(StrInicio, StrFim).Trim());
}
myTable.addRow(myRow);
StrInicio += QtdCaracterLinha;
top += nTamLinPixel;
//if (top % 3 == 0)
// top -= 3;
}
}
if (top > 700) //(top > 1230)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 40;
CabRelatorio(myDoc, myPage, top, NoObra);
top += 40;
myTable = SubCabRelatorio(myDoc, myPage, top, row["cmpDcTipoAtividade"].ToString(), row["cmpDcGrupoAtividade"].ToString(), row["cmpDcPeriodicidade"].ToString());
top = +90;
if (pg == 2)
{
i = 0;
}
}
//if (pg == 3)
// break;
}
return(myDoc);
}
public static pdfDocument ImprimeCapaRostoOS(DataTable table, string DataInicial, string DataFinal)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 40;
//Tamanho da lin em pixel
int nTamLinPixel = 19;
// Variaveis de controle para quebra de linha de campos
int QtdCaracterLinha = 50;
int Tamanho;
int QtdLin;
int StrInicio;
int StrFim;
int cl;
DataTable DtTotMatOs;
decimal TotMatOs = 0;
TotMaterial totalMat = new TotMaterial();
totalMat.Adicionar(table);
decimal ValorBdiLucro = totalMat.Valor * decimal.Parse(table.Rows[0]["cmpPeBDILucro"].ToString()) / 100;
decimal ValorBdiTributo = totalMat.Valor * decimal.Parse(table.Rows[0]["cmpPeBDITributos"].ToString()) / 100;
decimal TotalMaterialLucroTributo = totalMat.Valor + ValorBdiLucro + ValorBdiTributo;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
string DadosObra = (table.Rows[0]["cmpNoObra"].ToString().Trim() + (table.Rows[0]["cmpNuContrato"] != null ? " -> Contrato nº " + table.Rows[0]["cmpNuContrato"].ToString() : ""));
CabRelatorio(myDoc, myPage, top, DadosObra, DataInicial, DataFinal);
top += 30;
#region Resultado Financeiro
//Imprime Total Geral de Material
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);
cl = 0;
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(400, predefinedAlignment.csRight);
myTable.tableHeader[cl++].addText("Total do Material R$ ");
myTable.tableHeader.addColumn(150, predefinedAlignment.csRight);
myTable.tableHeader[cl++].addText(totalMat.Valor.ToString("0,0.00"));
top += 20;
// Create Table Row
pdfTableRow myRow = myTable.createRow();
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csRight;
myRow[cl++].addText("Lucro + Despesas Administrativas (" + table.Rows[0]["cmpPeBDILucro"].ToString() + "%)");
myRow[cl++].addText(ValorBdiLucro.ToString("0,0.00"));
myTable.addRow(myRow);
top += 20;
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csRight;
myRow[cl++].addText("Tributos (" + table.Rows[0]["cmpPeBDITributos"].ToString() + "%)");
myRow[cl++].addText(ValorBdiTributo.ToString("0,0.00"));
myTable.addRow(myRow);
top += 20;
cl = 0;
myRow = myTable.createRow();
myRow[cl].columnAlign = predefinedAlignment.csRight;
myRow[cl++].addText("Total (Material + Lucro + Tributos)");
myRow[cl++].addText(TotalMaterialLucroTributo.ToString("0,0.00"));
myTable.addRow(myRow);
myPage.addTable(myTable);
#endregion
top += 10;
myTable = SubCabRelatorio(myDoc, myPage, top);
top += 10;
// Imprimir linhas de detalhes
myRow = myTable.createRow();
foreach (DataRow row in table.Rows)
{
DtTotMatOs = tblOSMaterial.RetornarTotalMatOS(Global.GetConnection(), row["cmpIdOs"].ToString());
TotMatOs = DtTotMatOs.Rows[0]["TotalMaterial"].ToString() != "" ? decimal.Parse(DtTotMatOs.Rows[0]["TotalMaterial"].ToString()) : 0;
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText(row["cmpNuOs"].ToString());
myRow[cl++].addText(row["cmpNoSolicitante"].ToString().TrimEnd());
row["cmpDcObservacoes"] = TiraCaractEspecial(row["cmpDcObservacoes"].ToString().ToUpper());
Tamanho = row["cmpDcObservacoes"].ToString().Length;
if (Tamanho > 0)
{
QtdLin = (Tamanho % QtdCaracterLinha == 0 ? Tamanho / QtdCaracterLinha : (Tamanho / QtdCaracterLinha) + 1);
StrInicio = 0;
for (int Linha = 1; Linha <= QtdLin; Linha++)
{
StrFim = Linha == QtdLin ? Tamanho - StrInicio : QtdCaracterLinha;
if (Linha == 1)
{
myRow[cl++].addText(row["cmpDcObservacoes"].ToString().Substring(StrInicio, StrFim).Trim());
myRow[cl++].addText(row["cmpDcLocal"].ToString());
myRow[cl++].addText(row["cmpDtAbertura"].ToString().Substring(0, 10));
myRow[cl++].addText(row["cmpDtConclusaoAtendimento"].ToString() == "" ? "" : row["cmpDtConclusaoAtendimento"].ToString().Substring(0, 10));
myRow[cl++].addText(TotMatOs.ToString("0,0.00"));
}
else
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText(row["cmpDcObservacoes"].ToString().Substring(StrInicio, StrFim).Trim());
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("");
}
myTable.addRow(myRow);
StrInicio += QtdCaracterLinha;
top += nTamLinPixel;
}
}
else
{
myRow[cl++].addText(row["cmpDcDescricaoSolicitacao"].ToString().TrimEnd());
myRow[cl++].addText(row["cmpDcLocal"].ToString());
myRow[cl++].addText(row["cmpDtAbertura"].ToString().Substring(0, 10));
myRow[cl++].addText(row["cmpDtConclusaoAtendimento"].ToString() == "" ? "" : row["cmpDtConclusaoAtendimento"].ToString().Substring(0, 10));
myRow[cl++].addText(TotMatOs.ToString("0,0.00"));
myTable.addRow(myRow);
top += nTamLinPixel;
}
if (top > 1230)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 30;
CabRelatorio(myDoc, myPage, top, DadosObra, DataInicial, DataFinal);
top += 30;
myTable = SubCabRelatorio(myDoc, myPage, top);
top = +10;
}
}
if (top < 1230)
{
//Imprime Total Geral de Material
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
cl = 0;
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("Total ==>");
myRow[cl++].addText(totalMat.Valor.ToString("0,0.00"));
myTable.addRow(myRow);
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
}
return(myDoc);
}
public static pdfDocument ImprimePlano(DataTable table, string NoObra)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 40;
//Tamanho da lin em pixel
int nTamLinPixel = 19;
// Variaveis de controle para quebra de linha de campos
int QtdCaracterLinha = 100;
int Tamanho;
int QtdLin;
int StrInicio;
int StrFim;
int cl;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
string DadosObra = NoObra;
CabRelatorio(myDoc, myPage, top, DadosObra);
top += 30;
pdfTable myTable = SubCabRelatorio(myDoc, myPage, top);
top += 10;
string TipoAtividade = "";
string GrupoAtividade = "";
string Periodicidade = "";
// Imprimir linhas de detalhes
pdfTableRow myRow = myTable.createRow();
try
{
foreach (DataRow row in table.Rows)
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
if (TipoAtividade != row["cmpCoTipoAtividade"].ToString())
{
row["cmpDcTipoAtividade"] = TiraCaractEspecial(row["cmpDcTipoAtividade"].ToString());
myRow[cl++].addText(row["cmpDcTipoAtividade"].ToString().TrimEnd());
TipoAtividade = row["cmpCoTipoAtividade"].ToString();
}
else
{
myRow[cl++].addText("");
}
if (GrupoAtividade != row["cmpCoGrupoAtividade"].ToString())
{
row["cmpDcGrupoAtividade"] = TiraCaractEspecial(row["cmpDcGrupoAtividade"].ToString());
myRow[cl++].addText(row["cmpDcGrupoAtividade"].ToString().TrimEnd());
GrupoAtividade = row["cmpCoGrupoAtividade"].ToString();
}
else
{
myRow[cl++].addText("");
}
if (Periodicidade != row["cmpCoPeriodicidade"].ToString())
{
myRow[cl++].addText(row["cmpDcPeriodicidade"].ToString());
Periodicidade = row["cmpCoPeriodicidade"].ToString();
}
else
{
myRow[cl++].addText("");
}
row["cmpDcItemAtividadePreventiva"] = TiraCaractEspecial(row["cmpDcItemAtividadePreventiva"].ToString());
Tamanho = row["cmpDcItemAtividadePreventiva"].ToString().Length;
if (Tamanho > 0)
{
QtdLin = (Tamanho % QtdCaracterLinha == 0 ? Tamanho / QtdCaracterLinha : (Tamanho / QtdCaracterLinha) + 1);
StrInicio = 0;
for (int Linha = 1; Linha <= QtdLin; Linha++)
{
StrFim = Linha == QtdLin ? Tamanho - StrInicio : QtdCaracterLinha;
if (Linha == 1)
{
myRow[cl++].addText(row["cmpDcItemAtividadePreventiva"].ToString().Substring(StrInicio, StrFim).Trim());
}
else
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText("");
myRow[cl++].addText(row["cmpDcItemAtividadePreventiva"].ToString().Substring(StrInicio, StrFim).Trim());
}
myTable.addRow(myRow);
StrInicio += QtdCaracterLinha;
top += nTamLinPixel;
}
}
//else
//{
// myRow[cl++].addText(row["cmpDcDescricaoSolicitacao"].ToString().TrimEnd());
// myRow[cl++].addText(row["cmpDcLocal"].ToString());
// myRow[cl++].addText(row["cmpDtAbertura"].ToString().Substring(0, 10));
// myRow[cl++].addText(row["cmpDtConclusaoAtendimento"].ToString() == "" ? "" : row["cmpDtConclusaoAtendimento"].ToString().Substring(0, 10));
// myTable.addRow(myRow);
// top += nTamLinPixel;
//}
if (top > 1250)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 30;
CabRelatorio(myDoc, myPage, top, DadosObra);
top += 30;
myTable = SubCabRelatorio(myDoc, myPage, top);
top = +10;
}
}
if (top < 1250)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
}
}
catch (Exception ex)
{
Global.ShowError(Global.Title, ex);
}
return(myDoc);
}
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);
//}
}
public static pdfDocument ImprimeAtividades(DataTable table, string NomeObra, string TipoAtividade, string Periodicidade)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 20;
//Tamanho da lin em pixel
int nTamLinPixel = 19;
// Variaveis de controle para quebra de linha de campos
int QtdCaracterLinha = 50;
int Tamanho;
int QtdLin;
int StrInicio;
int StrFim;
int cl;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
CabRelatorio(myDoc, myPage, top, NomeObra, TipoAtividade, Periodicidade);
top += 50;
SubCabRelatorio(myDoc, myPage, top, table.Rows[0]["cmpCoObra"].ToString(), table.Rows[0]["cmpCoPreventiva"].ToString());
top += 20;
DataTable table2 = tblPreventivaAtividade.RetornaFormPreventivaPivot(Global.GetConnection(), table.Rows[0]["cmpCoPreventiva"].ToString(), table.Rows[0]["cmpCoObra"].ToString());
pdfTable myTable;
string GrupoAtividade = "";
foreach (DataRow row in table2.Rows)
{
row["cmpDcGrupoAtividade"] = TiraCaractEspecial(row["cmpDcGrupoAtividade"].ToString().TrimEnd());
if (row["cmpDcGrupoAtividade"].ToString() != GrupoAtividade)
{
GrupoAtividade = row["cmpDcGrupoAtividade"].ToString();
ImprimeGrupo(myDoc, myPage, top, GrupoAtividade);
top += 10;
}
// Imprimir Itens do grupo atividade
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 5, pdfColor.Black, new pdfColor("FFFFFF")),
new pdfTableStyle(myDoc.getFontReference(strFont), 5, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
cl = 0;
myTable.tableHeader.addColumn(190, predefinedAlignment.csLeft);
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader[cl].addText(TiraCaractEspecial(row["cmpDcItemAtividadePreventiva"].ToString()));
for (int i = 2; i <= 23; ++i)
{
myTable.tableHeader.addColumn(16, predefinedAlignment.csCenter);
myTable.tableHeader[cl++].addText("");
}
myPage.addTable(myTable);
top += 10;
}
top += 20;
myTable = ConclusaoRelatorio(myDoc, myPage, top);
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
return(myDoc);
}
protected static pdfTable ConclusaoRelatorio(pdfDocument myDoc, pdfPage myPage, int top)
{
String strFont = "Helvetica";
int leftMargin = 30;
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);
int cl = 0;
myTable.tableHeader.rowHeight = 15;
myTable.tableHeader.addColumn(550, predefinedAlignment.csCenter);
myTable.tableHeader[cl].addText("Responsável pela Execução dos Serviços");
myPage.addTable(myTable);
top += 15;
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 = 15;
myTable.tableHeader.addColumn(275, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Nome do Técnico:");
myTable.tableHeader.rowHeight = 15;
myTable.tableHeader.addColumn(275, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Data: _____________________________, ____/____/" + DateTime.Now.Year);
myPage.addTable(myTable);
top += 15;
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 = 15;
myTable.tableHeader.addColumn(275, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Hora de Entrada: ________________");
myTable.tableHeader.rowHeight = 15;
myTable.tableHeader.addColumn(275, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Hora da Saída: ______________");
myPage.addTable(myTable);
top += 30;
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 = 15;
myTable.tableHeader.addColumn(550, predefinedAlignment.csCenter);
myTable.tableHeader[cl].addText("Conclusão / Aceite do Cliente");
myPage.addTable(myTable);
top += 15;
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 = 15;
myTable.tableHeader.addColumn(550, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Nome do Cliente: Data:");
pdfTableRow myRow;
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl].addText("Satisfeito com o serviço? _________ Sim _________ Não");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("Comentários: ");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("");
myTable.addRow(myRow);
myRow = myTable.createRow();
myRow[cl].addText("");
myTable.addRow(myRow);
return(myTable);
}
public pdfDocument ImprimeAgenda(DataTable table, string NoObra, string DtInicial, string DtFinal)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 40;
//Tamanho da lin em pixel
int nTamLinPixel = 12;
// Variaveis de controle para quebra de linha de campos
int QtdCaracterLinha = 145;
int Tamanho;
int QtdLin;
int StrInicio;
int StrFim;
int cl;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
pdfTable myTable;
pdfTableRow myRow;
DataTable table2;
DataColumn column;
string DadosObra = NoObra;
int qtdReg;
foreach (DataRow row in table.Rows)
{
top = 40;
CabRelatorio(myDoc, myPage, top, DadosObra, DtInicial, DtFinal);
top += 55;
SubCabRelatorio(myDoc, myPage, top, row);
top += 32;
column = table.Columns["cmpCoPreventiva"];
table2 = tblPreventivaAtividade.Get(Global.GetConnection(), row[column].ToString());
string GrupoAtividade = "";
qtdReg = 0;
foreach (DataRow row2 in table2.Rows)
{
row2["cmpDcGrupoAtividade"] = TiraCaractEspecial(row2["cmpDcGrupoAtividade"].ToString());
if (row2["cmpDcGrupoAtividade"].ToString() != GrupoAtividade)
{
qtdReg = 0;
GrupoAtividade = row2["cmpDcGrupoAtividade"].ToString();
ImprimeGrupo(myDoc, myPage, top, GrupoAtividade);
top += 20;
ItensAtividade(myDoc, myPage, top);
top += 20;
}
cl = 0;
row2["cmpDcItemAtividadePreventiva"] = TiraCaractEspecial(row2["cmpDcItemAtividadePreventiva"].ToString());
Tamanho = row2["cmpDcItemAtividadePreventiva"].ToString().Length;
if (Tamanho > 0)
{
QtdLin = (Tamanho % QtdCaracterLinha == 0 ? Tamanho / QtdCaracterLinha : (Tamanho / QtdCaracterLinha) + 1);
StrInicio = 0;
cl = 0;
for (int Linha = 1; Linha <= QtdLin; Linha++)
{
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;
myTable.coordY = getTop(myPage, top);
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(550, predefinedAlignment.csLeft);
StrFim = Linha == QtdLin ? Tamanho - StrInicio : QtdCaracterLinha;
myTable.tableHeader[cl].addText(row2["cmpDcItemAtividadePreventiva"].ToString().Substring(StrInicio, StrFim).Trim());
myPage.addTable(myTable);
StrInicio += QtdCaracterLinha;
top += nTamLinPixel;
qtdReg++;
if (top > 700)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 40;
CabRelatorio(myDoc, myPage, top, DadosObra, DtInicial, DtFinal);
top += 30;
if (qtdReg <= table2.Rows.Count)
{
SubCabRelatorio(myDoc, myPage, top, row);
top += 32;
ImprimeGrupo(myDoc, myPage, top, GrupoAtividade);
top += 20;
ItensAtividade(myDoc, myPage, top);
top += 20;
}
}
}
}
}
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
}
//if (top < 700)
//{
// myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
//}
return(myDoc);
}
public virtual pdfDocument ImprimeAtividades(DataTable table)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 20;
int RegItemAtv;
//Tamanho da lin em pixel
int nTamLinPixel = 19;
// Variaveis de controle para quebra de linha de campos
//int QtdCaracterLinha = 50;
//int Tamanho;
//int QtdLin;
//int StrInicio;
//int StrFim;
int cl;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
ImprimeFormPrevEquipamento Cab = new ImprimeFormPrevEquipamento();
Cab.cmpNoObra = table.Rows[0]["cmpNoObra"].ToString().TrimEnd();
Cab.cmpDcTipoAtividade = table.Rows[0]["cmpDcTipoAtividade"].ToString().TrimEnd();
Cab.cmpDcPeriodicidade = table.Rows[0]["cmpDcPeriodicidade"].ToString().TrimEnd();
top = Cab.CabRelatorio(myDoc, myPage, top);
top = Cab.SubCabRelatorio(myDoc, myPage, top, table.Rows[0]);
pdfTable myTable = ItemAtividade(myDoc, myPage, top, table.Rows[0]);
top += 40;
RegItemAtv = 0;
int IdEquipamento = int.Parse(table.Rows[0]["cmpIdEquipamentoObra"].ToString());
// Imprimir linhas de detalhes
pdfTableRow myRow = myTable.createRow();
foreach (DataRow row in table.Rows)
{
if (IdEquipamento != int.Parse(row["cmpIdEquipamentoObra"].ToString()))
{
IdEquipamento = int.Parse(row["cmpIdEquipamentoObra"].ToString());
myPage.addTable(myTable);
myTable = ConclusaoRelatorio(myDoc, myPage, top);
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
pg = 1;
top = 30;
top = Cab.CabRelatorio(myDoc, myPage, top);
top = Cab.SubCabRelatorio(myDoc, myPage, top, row);
myTable = ItemAtividade(myDoc, myPage, top, row);
top += 40;
}
else
{
if (RegItemAtv == 0)
{
RegItemAtv = 1;
}
else
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("");
myRow[cl++].addText(row["cmpDcItemAtividadePreventiva"].ToString().TrimEnd());
myTable.addRow(myRow);
top += nTamLinPixel;
}
}
if (top > 1000)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 30;
top = Cab.CabRelatorio(myDoc, myPage, top);
top = Cab.SubCabRelatorio(myDoc, myPage, top, row);
myTable = ItemAtividade(myDoc, myPage, top, row);
top += 40;
}
}
if (top < 1000)
{
myPage.addTable(myTable);
myTable = ConclusaoRelatorio(myDoc, myPage, top);
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
}
return(myDoc);
}
private pdfPage getNewPage(ref double yPos)
{
yPos = topMargin;
if (document == null)
{
document = new pdfDocument(myInterface.GetCompetitions()[0].Name, "Allberg Winshooter");
font = document.getFontReference(predefinedFont.csTimes);
fontCompetitionHeader = document.getFontReference(predefinedFont.csTimesBold);
fontHeader = document.getFontReference(predefinedFont.csTimesBold);
}
//double xsize = 210/conversionPixelsToMM; // A4 = 210*297mm (35,3*35,3 mm)
//double ysize = 297/conversionPixelsToMM;
bottomMargin = (int)((297 - 20));
//pdfPage myPage = document.addPage((int)ysize, (int)xsize);
pdfPage myPage = document.addPage(predefinedPageSize.csA4Page);
sharpPDF.Fonts.pdfAbstractFont headerFont = document.getFontReference(predefinedFont.csTimes);
// Add copyright text
addText(myPage, "WinShooter",
leftMargin, (int)((bottomMargin + 3)), headerFont, 10);
//addText(myPage, "©" + settings.PrinterSettings.Copyright,
// leftMargin+155, (int)((bottomMargin+3)), headerFont, 10);
// Add club logo
Image image = settings.Logo;
int logoHeight = image.Height;
int logoWidth = image.Width;
calculateLogoSize(image, 60, 200, out logoHeight, out logoWidth);
int logoX = myPage.width - 20 - logoWidth;
int logoY = myPage.height - 20 - logoHeight;
try
{
sharpPDF.Elements.pdfImageReference imageRef = document.getImageReference("logo");
myPage.addImage(imageRef, logoX, logoY, logoHeight, logoWidth);
}
catch (sharpPDF.Exceptions.pdfImageNotLoadedException)
{
document.addImageReference((System.Drawing.Image)image, "logo");
sharpPDF.Elements.pdfImageReference imageRef = document.getImageReference("logo");
myPage.addImage(imageRef, logoX, logoY, logoHeight, logoWidth);
}
// Add Winshooter logo
image = settings.GetWinshooterLogo(1000, 1000);
logoHeight = image.Height;
logoWidth = image.Width;
calculateLogoSize(image, 50, 200, out logoHeight, out logoWidth);
logoX = myPage.width - 20 - logoWidth;
logoY = 10;
try
{
sharpPDF.Elements.pdfImageReference imageRef = document.getImageReference("WinShooterLogo");
myPage.addImage(imageRef, logoX, logoY, logoHeight, logoWidth);
}
catch (sharpPDF.Exceptions.pdfImageNotLoadedException)
{
document.addImageReference((System.Drawing.Image)image, "WinShooterLogo");
sharpPDF.Elements.pdfImageReference imageRef = document.getImageReference("WinShooterLogo");
myPage.addImage(imageRef, logoX, logoY, logoHeight, logoWidth);
}
//
TextStart = 20 + conversionPixelsToMM * logoHeight;
return(myPage);
}
public virtual int SubCabRelatorio(pdfDocument myDoc, pdfPage myPage, int top, DataRow r)
{
String strFont = "Helvetica";
int leftMargin = 30;
//Tamanho da lin em pixel
int nTamLinPixel = 19;
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("Descrição do Equipamento");
myTable.tableHeader.addColumn(400, predefinedAlignment.csLeft);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csLeft;
myTable.tableHeader[cl++].addText(r["cmpDcEquipamentoObra"].ToString());
top += nTamLinPixel;
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 = 10;
myTable.tableHeader.addColumn(150, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Código do Equipamento");
myTable.tableHeader.addColumn(125, predefinedAlignment.csLeft);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csLeft;
myTable.tableHeader[cl++].addText(r["CodEquipamento"].ToString().TrimEnd());
myTable.tableHeader.rowHeight = 10;
myTable.tableHeader.addColumn(115, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Tipo do Equipamento");
myTable.tableHeader.addColumn(160, predefinedAlignment.csLeft);
myTable.tableHeader[cl].columnAlign = predefinedAlignment.csLeft;
myTable.tableHeader[cl++].addText(r["cmpDcTipoAtividade"].ToString().TrimEnd());
top += nTamLinPixel;
// Create Table Row - 1ª linha
pdfTableRow myRow = myTable.createRow();
myRow = myTable.createRow();
cl = 0;
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Capacidade do Equipamento");
myRow[cl++].addText(r["DcCapacidade"].ToString().TrimEnd());
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Marca / Modelo");
myRow[cl++].addText(r["cmpDcMarcaModeloEquipamento"].ToString().TrimEnd());
myTable.addRow(myRow);
top += nTamLinPixel;
// Create Table Row - 2ª linha
myRow = myTable.createRow();
cl = 0;
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Número de Série");
myRow[cl++].addText(r["cmpNuSerieEquipamento"].ToString().TrimEnd());
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Número do Patrimônio");
myRow[cl++].addText(r["cmpNuPatrimonio"].ToString().TrimEnd());
myTable.addRow(myRow);
top += nTamLinPixel;
// Create Table Row - 3ª linha
myRow = myTable.createRow();
cl = 0;
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Pavimento");
myRow[cl++].addText(r["cmpDcPavimento"].ToString().TrimEnd());
myRow[cl].columnAlign = predefinedAlignment.csLeft;
myRow[cl++].addText("Localização");
myRow[cl++].addText(r["cmpDcLocalEquipamento"].ToString().TrimEnd());
myTable.addRow(myRow);
top += nTamLinPixel;
myPage.addTable(myTable);
return(top);
}
public static pdfDocument ImprimeResumoOS(DataTable table, string DataInicial, string DataFinal)
{
String strFont = "Helvetica";
int leftMargin = 30;
int pg = 1;
int top = 40;
TotalOS totalos = new TotalOS();
//Tamanho da lin em pixel
int nTamLinPixel = 19;
// Variaveis de controle para quebra de linha de campos
int QtdCaracterLinha = 120;
int Tamanho;
int QtdLin;
int StrInicio;
int StrFim;
int cl;
// Adiciona Página
pdfDocument myDoc = new pdfDocument("Horizon", "Orion");
pdfPage myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
string DadosObra = (table.Rows[0]["cmpNoObra"].ToString().Trim() + (table.Rows[0]["cmpNuContrato"] != null ? " -> Contrato nº " + table.Rows[0]["cmpNuContrato"].ToString() : ""));
pdfTable myTable = CabRelatorio(myDoc, myPage, top, DadosObra, DataInicial, DataFinal);
// Imprimir linhas de detalhes
pdfTableRow myRow = myTable.createRow();
foreach (DataRow row in table.Rows)
{
totalos.Adicionar(row["cmpDcOrigemOS"].ToString());
cl = 0;
row["cmpDcObservacoes"] = TiraCaractEspecial(row["cmpDcObservacoes"].ToString());
Tamanho = row["cmpDcObservacoes"].ToString().Length;
if (Tamanho > 0)
{
QtdLin = (Tamanho % QtdCaracterLinha == 0 ? Tamanho / QtdCaracterLinha : (Tamanho / QtdCaracterLinha) + 1);
StrInicio = 0;
for (int Linha = 1; Linha <= QtdLin; Linha++)
{
StrFim = Linha == QtdLin ? Tamanho - StrInicio : QtdCaracterLinha;
if (Linha == 1)
{
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText(row["cmpDcObservacoes"].ToString().Substring(StrInicio, StrFim).Trim());
myRow[cl++].addText(row["cmpDtAbertura"].ToString());
}
else
{
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText(row["cmpDcObservacoes"].ToString().Substring(StrInicio, StrFim).Trim());
myRow[cl++].addText("");
}
myTable.addRow(myRow);
StrInicio += QtdCaracterLinha;
top += nTamLinPixel;
}
}
else
{
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText(row["cmpDcDescricaoSolicitacao"].ToString().TrimEnd());
myRow[cl++].addText(row["cmpDtAbertura"].ToString());
myTable.addRow(myRow);
top += nTamLinPixel;
}
if (top > 980)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 40;
myTable = CabRelatorio(myDoc, myPage, top, DadosObra, DataInicial, DataFinal);
top = +15;
}
}
if (top < 980)
{
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
// Adiciona uma página
myPage = myDoc.addPage(predefinedPageSize.csSharpPDFFormat);
top = 40;
myTable = CabRelatorio(myDoc, myPage, top, DadosObra, DataInicial, DataFinal);
top = +120;
}
// Imprimir Resumo dos atendimentos
myTable = new pdfTable(myDoc, 1, new pdfColor("000000"), 2,
new pdfTableStyle(myDoc.getFontReference(strFont), 12, 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 = 30;
myTable.tableHeader.addColumn(300, predefinedAlignment.csCenter);
myTable.tableHeader[cl++].addText("RESUMO DAS ATIVIDADES REALIZADAS");
myPage.addTable(myTable);
top += 30;
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), 8, pdfColor.Black, pdfColor.White));
myTable.coordX = leftMargin;
myTable.coordY = getTop(myPage, top);
cl = 0;
myTable.tableHeader.rowHeight = 12;
myTable.tableHeader.addColumn(200, predefinedAlignment.csLeft);
myTable.tableHeader[cl++].addText("Tipo de Atendimento");
myTable.tableHeader.addColumn(100, predefinedAlignment.csRight);
myTable.tableHeader[cl++].addText("Quantidade");
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("Eventuais");
myRow[cl++].addText(totalos.Eventual.ToString());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("Interno");
myRow[cl++].addText(totalos.Interno.ToString());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("Preventiva");
myRow[cl++].addText(totalos.Preventiva.ToString());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("Externo");
myRow[cl++].addText(totalos.Externa.ToString());
myTable.addRow(myRow);
cl = 0;
myRow = myTable.createRow();
myRow.rowStyle = myTable.rowStyle;
myRow[cl++].addText("Fora de Escopo");
myRow[cl++].addText(totalos.ForaEscopo.ToString());
myTable.addRow(myRow);
myPage.addText("Pág. " + pg++, leftMargin, 10, myDoc.getFontReference(strFont), 10, pdfColor.Black);
myPage.addTable(myTable);
return(myDoc);
}
//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);
}
}
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;
}
