public static string GetFacturaHtml(Factura f)
{
string html = "";
string plantilla = @"
<div class='panel panel-default'>
<div class='panel-heading'>
<a data-toggle='collapse' data-parent='#accordion' href='#collapse{0}{1}'>
<h4>Factura {0}-{1:0000000} de {2:dd/MM/yyyy} # {3:#,###,##0.00} + {4:#,###,##0.00} = {5:#,###,##0.00 €}</h4>
</a>
</div>
<div id='collapse{0}{1}' class='panel-collapse collapse'>
<div class='panel-body'>
<table class='table table-bordered'>
<tr class='info'>
<th>Albaran</th>
<th>Linea</th>
<th>Artículo</th>
<th class='text-right'>Cantidad</th>
<th class='text-right'>Precio</th>
<th class='text-right'>Dto1 (%)</th>
<th class='text-right'>Dto2 (%)</th>
<th class='text-right'>Importe</th>
</tr>
{6}
</table>
</div>
</div>
</div>
";
string plantillaLinea = @"
<tr>
<td>{10}</td>
<td>{2}</td>
<td>{3}</td>
<td class='text-right'>{5:##0.00}</td>
<td class='text-right'>{4:###,##0.00}</td>
<td class='text-right'>{6:0.00}</td>
<td class='text-right'>{7:0.00}</td>
<td class='text-right'>{8:##,###,##0.00}</td>
</tr>
";
string plantillaAlb = @"
<tr>
<td colspan='7'>
<strong>Albaran: </strong>{0}
</td>
</tr>
";
// Cargar las líneas
string lineas = "";
string codAlbar = "";
string codAlbarOld = "";
string showAlbar;
foreach (LinFactura lf in f.LineasFactura)
{
codAlbar = String.Format("{0}-{1:0000000}", lf.CodTipoa, lf.NumAlbar);
if (codAlbar != codAlbarOld)
{
showAlbar = codAlbar;
if (codAlbar == "-0000000")
showAlbar = "";
codAlbarOld = codAlbar;
}
else
{
showAlbar = "";
}
lineas += String.Format(plantillaLinea, lf.CodTipoa, lf.NumAlbar,
lf.NumLinea, lf.NomArtic, lf.PrecioAr, lf.Cantidad, lf.DtoLine1, lf.DtoLine2, lf.Importel, codAlbar, showAlbar);
}
html = String.Format(plantilla, f.CodTipom, f.NumFactu,
f.FecFactu, f.Bases, f.Cuotas, f.TotalFac, lineas);
return html;
}
public static Factura GetFactura(MySqlDataReader rdr)
{
if (rdr.IsDBNull(rdr.GetOrdinal("NUMFACTU")))
return null;
Factura f = new Factura();
f.CodTipom = rdr.GetString("CODTIPOM");
f.NumFactu = rdr.GetInt32("NUMFACTU");
f.FecFactu = rdr.GetDateTime("FECFACTU");
f.Bases = rdr.GetDecimal("BASES");
f.Cuotas = rdr.GetDecimal("CUOTAS");
f.TotalFac = rdr.GetDecimal("TOTALFAC");
return f;
}
