using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;
namespace FastReport
{
public class ReportScript
{
int decimalValue = 0;
private void _StartReport(object sender, EventArgs e)
{
//Style
string stylePath = Report.GetParameterValue("MainAppPath").ToString() + "\\Resources\\DocStyles\\Styles\\" +
Report.GetColumnValue("companies.InvoiceStylePath").ToString();
if (stylePath.Length > 0)
{
picStyle.ImageLocation = stylePath;
}
//Logo
string logoPath = Report.GetColumnValue("companies.LogoPath").ToString();
if (logoPath.Length > 0)
{
picLogo.ImageLocation = Report.GetParameterValue("MainAppPath").ToString() + "\\Resources\\Logos\\" + logoPath;
picLogo.Printable = true;
}
else
{
picLogo.Printable = false;
}
//Qty Column format
decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
//Show Amount Due on Sales docs
if (Report.GetColumnValue("programs_config.ShowAmountDueOnSalesDocs").ToString() == "1")
{
lblAmountDue.Visible = true;
txtAmountDue.Visible = true;
}
else
{
lblAmountDue.Visible = false;
txtAmountDue.Visible = false;
}
}
private void PageHeader1_AfterData(object sender, EventArgs e)
{
//Invoice OR Tax Invoice
if (Report.GetColumnValue("companies.VATno").ToString().Length > 0)
txtInvoice.Text = "Tax Credit Note";
else
txtInvoice.Text = "Credit Note";
//Print the SalesRep
if (Report.GetColumnValue("trans.SalesRep").ToString().Length == 0)
{
txtSalesRep1.Visible = false;
txtSalesRep2.Visible = false;
}
}
private void Data1_AfterData(object sender, EventArgs e)
{
//Include when items were sold with a zero qty
decimal qty = Convert.ToDecimal(Report.GetColumnValue("trans_items.Qty"));
decimal unitPrice = 0;
decimal total = 0;
if (qty != 0)
{
//Total
if (Report.GetColumnValue("programs_config.InvShowRetailPriceExcl").ToString() == "1")
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingExcl"));
else
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingIncl"));
//Unit Price
unitPrice = (total / qty);
}
//exclude notes
if (Report.GetColumnValue("trans_items.ProductCode").ToString().Length > 0)
{
txtQty.Text = String.Format("{0:F" + decimalValue + "}", qty);
txtItemPrice.Text = unitPrice.ToString("# ### ###.00");
txtItemTotal.Text = total.ToString("# ### ###.00");
}
}
private void PageFooter1_AfterData(object sender, EventArgs e)
{
//Total Qty field - format
decimal qtyVal = 0;
if (Decimal.TryParse(txtTotQty.Text, out qtyVal))
{
txtTotQty.Text = "Total Qty: " + String.Format("{0:F" + decimalValue + "}", qtyVal);
}
}
}
}