public static int k = 0; //alt contor
public static void PrintListaFacturiSiIncasariPerioada(PrintPageEventArgs e, Firma f, DateTime inceput, DateTime sfarsit)
{
int leftMargin = 50;
int inaltimeRand = 18;
int maxRanduriPePagina = 52;
int inceputTabel = 100;
int yTabelCurent = 0; //inaltimea din tabel la care ma aflu - cand se face o pagina noua incepe din nou de la 0
f.FacturiClient = DbaseConnection.DBFCitesteFacturiClientFirma(f, Settings.Ani_InUz);
f.Tranzactii = DbaseConnection.DBFCitesteTranzactiiFirma(f, Settings.Ani_InUz);
List <Factura> facPer = f.FacturiClientPePerioada(inceput, sfarsit);
List <Tranzactie> incasari = f.IncasariPePerioada(inceput, sfarsit);
decimal totalFara = 0;
decimal totalTVA = 0;
decimal totalCu = 0;
int totalPagini = 1 + facPer.Count / maxRanduriPePagina;
decimal totalIncasari = 0;
foreach (Factura fa in facPer)
{
totalFara += fa.Valoare;
totalTVA += fa.TVA;
totalCu += fa.Valoare_Cu_TVA;
}
foreach (Tranzactie t in incasari)
{
totalIncasari += t.Valoare;
}
#region toatePaginile
e.Graphics.DrawString(f.Nume, new Font("Calibri", 13, FontStyle.Bold), Brushes.Black, new Point(leftMargin, 40));
e.Graphics.DrawString("Lista facturilor platite din perioada " + inceput.ToShortDateString() + " - " + sfarsit.ToShortDateString(), new Font("Calibri", 11, FontStyle.Italic), Brushes.Black, new Point(380, 42));
e.Graphics.DrawString("Data tiparirii: " + DateTime.Now, new Font("Calibri", 10, FontStyle.Italic), Brushes.Black, new Point(leftMargin, e.MarginBounds.Bottom + 20));
e.Graphics.DrawString("pag. " + p + @"/" + totalPagini, new Font("Calibri", 10, FontStyle.Italic), Brushes.Black, new Point(e.MarginBounds.Right, e.MarginBounds.Bottom + 20));
#endregion
#region tabel - pe fiecare pagina apare
e.Graphics.DrawString("Serie doc.", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin, inceputTabel - 20));
e.Graphics.DrawString("Data emit.", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 100, inceputTabel - 20));
e.Graphics.DrawString("Data scad.", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 180, inceputTabel - 20));
e.Graphics.DrawString("Valoare", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 260, inceputTabel - 20));
e.Graphics.DrawString("TVA", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 350, inceputTabel - 20));
e.Graphics.DrawString("Val. cu TVA", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 430, inceputTabel - 20));
if (facPer.Count > 0)
{
while (i < facPer.Count)
{
if (i % 2 == 0)
{
e.Graphics.FillRectangle(new SolidBrush(Color.FromArgb(242, 242, 242)), 50, inceputTabel - 1 + yTabelCurent, 700, inaltimeRand);
}
e.Graphics.DrawString(facPer[i].Seria + facPer[i].Numar_Document, new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin, inceputTabel + yTabelCurent));
e.Graphics.DrawString(facPer[i].Data_Emitere.ToShortDateString(), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 100, inceputTabel + yTabelCurent));
e.Graphics.DrawString(facPer[i].Data_Scadenta.ToShortDateString(), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 180, inceputTabel + yTabelCurent));
e.Graphics.DrawString(facPer[i].Valoare.ToString("0.00"), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 260, inceputTabel + yTabelCurent));
e.Graphics.DrawString(facPer[i].TVA.ToString("0.00"), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 350, inceputTabel + yTabelCurent));
e.Graphics.DrawString(facPer[i].Valoare_Cu_TVA.ToString("0.00"), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 430, inceputTabel + yTabelCurent));
// e.Graphics.DrawString(facPer[i].Valoare_Cu_TVA.ToString(), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 520, inceputTabel + yTabelCurent));
i++; //incrementez contorul general in orice caz, cu asta se trece peste toate, neavand importanta cate intrari vreau in pagina
yTabelCurent += inaltimeRand; //trec pe urmatorul rand
if (j < maxRanduriPePagina) // verific daca am trecut cu contorul care merge pana la maximul de randuri din pagina
{
j++; //daca nu, il incrementez
e.HasMorePages = false; // si ii spun ca nu va fi o alta pagina
}
else // daca da
{
j = 0; //resetez contorul
e.HasMorePages = true; //si ii spun sa creeaze o pagina noua
p++;
return; //returnand aici, functia se va mai executa o data, cu variabilele globale in starea adecvata
}
}
}
#endregion
#region ultimaPagina - poate fi prima si ultima
e.Graphics.DrawString("Totaluri", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 180, inceputTabel + yTabelCurent + inaltimeRand));
e.Graphics.DrawString(totalFara.ToString("0.00"), new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 260, inceputTabel + yTabelCurent + inaltimeRand));
e.Graphics.DrawString(totalTVA.ToString("0.00"), new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 350, inceputTabel + yTabelCurent + inaltimeRand));
e.Graphics.DrawString(totalCu.ToString("0.00"), new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 430, inceputTabel + yTabelCurent + inaltimeRand));
#endregion
}
public static void PrintFacturaFurnizor(PrintPageEventArgs e, Firma firma, Factura f)
{
int leftMargin = 50;
int inaltimeRand = 18;
int maxRanduriPePagina = 46;
int inceputTabel = 220;
int yTabelCurent = 0; //inaltimea din tabel la care ma aflu - cand se face o pagina noua incepe din nou de la 0
List <Produs> produse = DbaseConnection.DBFCitesteProduseFacturaFurnizor(f, Settings.Ani_InUz);
int totalPagini = 1 + produse.Count / maxRanduriPePagina;
#region toatePaginile
e.Graphics.DrawString("Societatea: " + firma.Nume, new Font("Calibri", 13, FontStyle.Bold), Brushes.Black, new Point(leftMargin, 40));
e.Graphics.DrawString("Factura: " + f.Seria + f.Numar_Document, new Font("Calibri", 11, FontStyle.Bold), Brushes.Black, new Point(leftMargin, 70));
e.Graphics.DrawString("Data emiterii: " + f.Data_Emitere.ToShortDateString(), new Font("Calibri", 11, FontStyle.Italic), Brushes.Black, new Point(leftMargin, 98));
e.Graphics.DrawString("Data scadentei: " + f.Data_Scadenta.ToShortDateString(), new Font("Calibri", 11, FontStyle.Italic), Brushes.Black, new Point(leftMargin, 116));
e.Graphics.DrawString("Total fara TVA: " + f.Valoare.ToString("0.00") + " " + f.Moneda, new Font("Calibri", 11, FontStyle.Italic), Brushes.Black, new Point(leftMargin, 148));
e.Graphics.DrawString("TVA: " + f.TVA.ToString("0.00") + " " + f.Moneda, new Font("Calibri", 11, FontStyle.Italic), Brushes.Black, new Point(leftMargin, 166));
e.Graphics.DrawString("Data tiparirii: " + DateTime.Now, new Font("Calibri", 10, FontStyle.Italic), Brushes.Black, new Point(leftMargin, e.MarginBounds.Bottom + 20));
e.Graphics.DrawString("pag. " + p + @"/" + totalPagini, new Font("Calibri", 10, FontStyle.Italic), Brushes.Black, new Point(e.MarginBounds.Right, e.MarginBounds.Bottom + 20));
#endregion
#region tabel - pe fiecare pagina apare
e.Graphics.DrawString("Denumire produs", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin, inceputTabel - 20));
e.Graphics.DrawString("Pret/UM", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 400, inceputTabel - 20));
e.Graphics.DrawString("Cantitate", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 470, inceputTabel - 20));
e.Graphics.DrawString("Valoare", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 560, inceputTabel - 20));
e.Graphics.DrawString("TVA", new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 640, inceputTabel - 20));
if (produse.Count > 0)
{
while (i < produse.Count)
{
if (i % 2 == 0)
{
e.Graphics.FillRectangle(new SolidBrush(Color.FromArgb(242, 242, 242)), 50, inceputTabel - 1 + yTabelCurent, 700, inaltimeRand);
}
e.Graphics.DrawString(produse[i].Denumire_Produs, new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin, inceputTabel + yTabelCurent));
e.Graphics.DrawString(produse[i].Pret_Vanzare.ToString("0.00"), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 400, inceputTabel + yTabelCurent));
e.Graphics.DrawString(produse[i].Cantitate.ToString() + " " + produse[i].Unitate_Masura, new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 470, inceputTabel + yTabelCurent));
e.Graphics.DrawString(produse[i].Valoare.ToString("0.00"), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 560, inceputTabel + yTabelCurent));
e.Graphics.DrawString(produse[i].TVA.ToString("0.00"), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 640, inceputTabel + yTabelCurent));
// e.Graphics.DrawString(facPer[i].Valoare_Cu_TVA.ToString(), new Font("Calibri", 10, FontStyle.Regular), Brushes.Black, new Point(leftMargin + 520, inceputTabel + yTabelCurent));
i++; //incrementez contorul general in orice caz, cu asta se trece peste toate, neavand importanta cate intrari vreau in pagina
yTabelCurent += inaltimeRand; //trec pe urmatorul rand
if (j < maxRanduriPePagina) // verific daca am trecut cu contorul care merge pana la maximul de randuri din pagina
{
j++; //daca nu, il incrementez
e.HasMorePages = false; // si ii spun ca nu va fi o alta pagina
}
else // daca da
{
j = 0; //resetez contorul
e.HasMorePages = true; //si ii spun sa creeaze o pagina noua
p++;
return; //returnand aici, functia se va mai executa o data, cu variabilele globale in starea adecvata
}
}
}
#endregion
#region ultimaPagina - poate fi prima si ultima
e.Graphics.DrawString(f.Valoare.ToString("0.00"), new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 560, inceputTabel + yTabelCurent + inaltimeRand));
e.Graphics.DrawString(f.TVA.ToString("0.00"), new Font("Calibri", 10, FontStyle.Bold), Brushes.Black, new Point(leftMargin + 640, inceputTabel + yTabelCurent + inaltimeRand));
#endregion
}
