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");
cboOrderBy.Text = "Date";
}
private void btnOk_Click(object sender, EventArgs e)
{
if (txtItemCode.Text.Length > 0)
{
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 ?????
string orderBy = String.Empty;
//For Selected Item
TableDataSource tSelItem = Report.GetDataSource("Item_History") as TableDataSource;
if (cboOrderBy.Text == "Date")
orderBy = "DATE_FORMAT(`TransDate`,'%Y-%m-%d %H:%i%s')";
else if (cboOrderBy.Text == "Document #")
orderBy = "TransID";
else if (cboOrderBy.Text == "Client Name")
orderBy = "ClientName";
else if (cboOrderBy.Text == "Sales Rep")
orderBy = "SalesRep";
tSelItem.SelectCommand = tSelItem.SelectCommand.ToString().Replace("@OrderBy", orderBy);
}
else
{
MessageBox.Show("Please provide an item code, then try again.", "Missing Item code", MessageBoxButtons.OK);
}
}
private void Data1_AfterData(object sender, EventArgs e)
{
//Description
txtDescription.Text = Convert.ToString(Report.GetColumnValue("Item_History.Description"));
//total Qty Column format
int decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
decimal qtyVal = 0;
if (Decimal.TryParse(txtQty.Text, out qtyVal))
{
txtQty.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
decimal prevQtyVal = 0;
if (Decimal.TryParse(txtPrevQty.Text, out prevQtyVal))
{
txtPrevQty.Text = String.Format("{0:F" + decimalValue + "}", prevQtyVal);
}
}
private void DataFooter1_AfterData(object sender, EventArgs e)
{
//total Qty Column format
int decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
decimal qtyVal = 0;
if (Decimal.TryParse(txtQtyAvail.Text, out qtyVal))
{
txtQtyAvail.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
}
}
}