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
{
private void Form1_Shown(object sender, EventArgs e)
{
//Shows today's date
dtpFromDate.Text = System.DateTime.Now.ToString("d MMMM yyy");
dtpToDate.Text = System.DateTime.Now.ToString("d MMMM yyy");
cboSupplierName.Items.Insert(0, "All");
cboSupplierName.Text = "All";
cboOrderBy.Text = cboOrderBy.Items[0].ToString();
}
private void btnOk_Click(object sender, EventArgs e)
{
Report.SetParameterValue("FromDate", dtpFromDate.Value.ToString("yyyy-MM-dd"));
Report.SetParameterValue("ToDate", dtpToDate.Value.ToString("yyyy-MM-dd"));
TableDataSource tGRV = Report.GetDataSource("cash_purchases") as TableDataSource;
TableDataSource tRET = Report.GetDataSource("cash_purchases_returns") as TableDataSource;
//Order the records by...
string orderBy = String.Empty;
if (cboOrderBy.Text == "Date")
orderBy = "DATE_FORMAT(`Date`,'%Y-%m-%d')";
else if (cboOrderBy.Text == "Document #")
orderBy = "TransID";
else if (cboOrderBy.Text == "Supplier Name")
orderBy = "SupplierName";
else if (cboOrderBy.Text == "User")
orderBy = "User";
tGRV.SelectCommand = tGRV.SelectCommand.ToString().Replace("@OrderBy", orderBy);
tRET.SelectCommand = tRET.SelectCommand.ToString().Replace("@OrderBy", orderBy);
//For a specific Supplier
string forSupplier = "ID >= 0";
if (cboSupplierName.Text != "All")
forSupplier = String.Format("SupplierName = '{0}'", cboSupplierName.Text);
tGRV.SelectCommand = tGRV.SelectCommand.ToString().Replace("@ForSupplier", forSupplier);
tRET.SelectCommand = tRET.SelectCommand.ToString().Replace("@ForSupplier", forSupplier);
}
private void ReportSummary1_AfterData(object sender, EventArgs e)
{
txtTotExcl.Text = (Report.GetTotalValue("Total_Excl") - Report.GetTotalValue("Total_Excl_Returns")).ToString();
txtTotVAT.Text = (Report.GetTotalValue("Total_VAT") - Report.GetTotalValue("Total_VAT_Returns")).ToString();
txtTotIncl.Text = (Report.GetTotalValue("Total_Incl") - Report.GetTotalValue("Total_Incl_Returns")).ToString();
//Format the total values
//Use the tryParse method if there is no data to print
decimal number = 0;
if (Decimal.TryParse(txtTotExcl.Text, out number))
txtTotExcl.Text = Convert.ToDecimal(txtTotExcl.Text).ToString("# ###.00");
if (Decimal.TryParse(txtTotVAT.Text, out number))
txtTotVAT.Text = Convert.ToDecimal(txtTotVAT.Text).ToString("# ###.00");
if (Decimal.TryParse(txtTotIncl.Text, out number))
txtTotIncl.Text = Convert.ToDecimal(txtTotIncl.Text).ToString("# ###.00");
}
}
}