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)
{
//Qty Column format
decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
}
private void PageHeader1_AfterData(object sender, EventArgs e)
{
//Print the User
if (Report.GetColumnValue("trans.User").ToString().Length == 0)
txtUser.Text = String.Empty;
//Reg No
if (Report.GetColumnValue("companies.RegNo").ToString().Length == 0)
txtRegNo.Text = String.Empty;
//Tel No
if (Report.GetColumnValue("companies.ContactNo").ToString().Length == 0)
txtTelNo.Text = String.Empty;
//Alt Tel No
if (Report.GetColumnValue("companies.AltNo").ToString().Length == 0)
txtAltNo.Text = String.Empty;
//Email
if (Report.GetColumnValue("companies.Email").ToString().Length == 0)
txtEmail.Text = String.Empty;
}
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 total = 0;
if (qty != 0)
{
//Total
if (String.Compare(Report.GetColumnValue("suppliers.TaxOnInvoice").ToString(), "inclusive", true) == 0)
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalIncl"));
else
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalExcl"));
}
//exclude notes
if (Report.GetColumnValue("trans_items.ProductCode").ToString().Length > 0)
{
txtQty.Text = String.Format("{0:F" + decimalValue + "}", qty);
txtItemTotal.Text = total.ToString("# ### ###.00");
}
}
}
}