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)
{
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"));
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";
//For a specific Supplier
string forSupplier = "ID >= 0";
if (cboSupplierName.Text != "All")
forSupplier = String.Format("SupplierName = '{0}'", cboSupplierName.Text);
//Purchase Orders
grpHeadPO.Printable = chkShowPO.Checked;
DataPO.Printable = chkShowPO.Checked;
GrpFootPO.Printable = chkShowPO.Checked;
if (chkShowPO.Checked)
{
TableDataSource tPO = Report.GetDataSource("PO") as TableDataSource;
tPO.SelectCommand = tPO.SelectCommand.ToString().Replace("@OrderBy", orderBy);
tPO.SelectCommand = tPO.SelectCommand.ToString().Replace("@ForSupplier", forSupplier);
}
}
}
}