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;
string orderBy = String.Empty;
string selection = String.Empty;
string showItems = String.Empty;
private void _StartReport(object sender, EventArgs e)
{
}
private void Form1_Shown(object sender, EventArgs e)
{
decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue"));
//MessageBox.Show(showItems);
cboSelection.Text = "All";
cboOrderBy.Text = "Description";
if (string.Compare(Report.GetColumnValue("programs_config.StockTake_VarianceShow").ToString(), "Show all items", true) == 0)
optShowAllItems.Checked = true;
else
optShowOnlyVariances.Checked = true;
if (string.Compare(Report.GetColumnValue("programs_config.StockTake_VarianceOrderBy").ToString(), "Description", true) == 0)
cboOrderBy.Text = "Description";
else
cboOrderBy.Text = "Item code";
}
private void btnOk_Click(object sender, EventArgs e)
{
//Report.SetParameterValue("OrderBy", cboOrderBy.Text); DOES NOT WORK ?????
TableDataSource tProducts = Report.GetDataSource("products") as TableDataSource;
if (cboOrderBy.Text == "Item code")
orderBy = "ProductCode";
else if (cboOrderBy.Text == "Description")
orderBy = "Description";
if (optShowOnlyVariances.Checked)
showItems = " AND QtyCounted - QtyAvailable <> 0";
if (cboSelection.Text == "All")
{
txtSelectionFeedback.Text = "Selection: All";
selection = "ID > 0";
}
else if (cboSelection.Text == "Location =")
{
txtSelectionFeedback.Text = "Location = " + cboLocation.Text;
selection = "Location = '" + cboLocation.Text + "'";
}
else if (cboSelection.Text == "Sub-Location =")
{
txtSelectionFeedback.Text = "Sub-Location = " + cboSubLocation.Text;
selection = "SubLocation = '" + cboSubLocation.Text + "'";
}
else if (cboSelection.Text == "Category =")
{
txtSelectionFeedback.Text = "Category = " + cboCategory.Text;
selection = "Category = '" + cboCategory.Text + "'";
}
else if (cboSelection.Text == "Sub-Category =")
{
txtSelectionFeedback.Text = "Sub-Category = " + cboSubCategory.Text;
selection = "SubCategory = '" + cboSubCategory.Text + "'";
}
tProducts.SelectCommand = tProducts.SelectCommand.ToString().Replace("@Selection", selection + showItems);
tProducts.SelectCommand = tProducts.SelectCommand.ToString().Replace("@OrderBy", orderBy);
}
private void Data1_AfterData(object sender, EventArgs e)
{
//total Qty Column format
decimal qtyVal = 0;
if (Decimal.TryParse(txtQtyAvailable.Text, out qtyVal))
{
txtQtyAvailable.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
if (Decimal.TryParse(txtQtyCounted.Text, out qtyVal))
{
txtQtyCounted.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
if (Decimal.TryParse(txtQtyDiff.Text, out qtyVal))
{
txtQtyDiff.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
}
private void DataFooter1_AfterData(object sender, EventArgs e)
{
//total Qty Column format
decimal qtyVal = 0;
if (Decimal.TryParse(txtQtyAvailableTotal.Text, out qtyVal))
{
txtQtyAvailableTotal.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
if (Decimal.TryParse(txtQtyCountedTotal.Text, out qtyVal))
{
txtQtyCountedTotal.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
if (Decimal.TryParse(txtQtyDiffTotal.Text, out qtyVal))
{
txtQtyDiffTotal.Text = String.Format("{0:F" + decimalValue + "}", qtyVal);
}
}
private void cboSelection_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboSelection.Text == "Location =")
cboLocation.Visible = true;
else if (cboSelection.Text == "Sub-Location =")
cboSubLocation.Visible = true;
else if (cboSelection.Text == "Category =")
cboCategory.Visible = true;
else if (cboSelection.Text == "Sub-Category =")
cboSubCategory.Visible = true;
}
}
}