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 btnOk_Click(object sender, EventArgs e)
{
Report.SetParameterValue("FromDate", dtpFromDate.Value.ToString("yyyy-MM-dd"));
Report.SetParameterValue("ToDate", dtpToDate.Value.ToString("yyyy-MM-dd"));
//Report.SetParameterValue("OrderBy", cboOrderBy.Text); DOES NOT WORK ?????
TableDataSource tProducts = Report.GetDataSource("item_maintenance") as TableDataSource;
string orderBy = String.Empty;
if (cboOrderBy.Text == "Item code")
orderBy = "ProductCode";
else if (cboOrderBy.Text == "Description")
orderBy = "Description";
else if (cboOrderBy.Text == "Qty Difference")
orderBy = "QtyDiff";
tProducts.SelectCommand = tProducts.SelectCommand.ToString().Replace("@OrderBy", orderBy);
}
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");
cboOrderBy.Text = "Item code";
}
private void Data1_AfterData(object sender, EventArgs e)
{
//Qty Column format
int decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
decimal qtyVal = 0;
if (Decimal.TryParse(txtQtyAvailable.Text, out qtyVal))
{
txtQtyAvailable.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
if (Decimal.TryParse(txtQtyFound.Text, out qtyVal))
{
txtQtyFound.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
if (Decimal.TryParse(txtQtyDiff.Text, out qtyVal))
{
txtQtyDiff.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
}
private void ReportSummary1_AfterData(object sender, EventArgs e)
{
//total Qty Column format
int decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
decimal qtyVal = 0;
if (Decimal.TryParse(txtQtyDiffTotal.Text, out qtyVal))
{
txtQtyDiffTotal.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
}
private void GroupFooter1_AfterData(object sender, EventArgs e)
{
//total Qty Column format
int decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
decimal qtyVal = 0;
if (Decimal.TryParse(txtQtyDiffSubTot.Text, out qtyVal))
{
txtQtyDiffSubTot.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
}
}
}