private void InitializeReport()
{
int area = int.Parse(Request.QueryString["Area"]);
int subArea = int.Parse(Request.QueryString["SubArea"]);
string brand = Request.QueryString["Brand"];
string memoStatus = Request.QueryString["PriceStatus"];
string dateFrom = Request.QueryString["DateFrom"];
string dateTo = Request.QueryString["DateTo"];
string areaName = areaGroupManager.GetAreaGroupByKey(int.Parse(Request.QueryString["Area"])).GroupName;
string subAreaName = subAreaGroupManager.GetSubAreaGroupByKey(int.Parse(Request.QueryString["SubArea"])).GroupName;
string subAreaNameVal = string.Empty;
if (string.IsNullOrEmpty(subAreaName))
{
subAreaNameVal="";
}
else
{
subAreaNameVal = "SUB-AREA: "+subAreaName;
}
ReportDocument REPORT_DOC = new ReportDocument();
string reportCacheKey = string.Concat("StockInputReport", area, subArea,brand, memoStatus);
ParameterField prmArea = new ParameterField();
ParameterField prmAreaName = new ParameterField();
ParameterField prmSubArea = new ParameterField();
ParameterField prmSubAreaName = new ParameterField();
ParameterField prmBrand = new ParameterField();
ParameterField prmMemoStatus = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmDateFrom.ParameterFieldName = "@datefrom";
prmDateTo.ParameterFieldName = "@dateto";
prmBrand.ParameterFieldName = "@brandname";
prmMemoStatus.ParameterFieldName = "@memostatus";
prmArea.ParameterFieldName = "@agno";
prmAreaName.ParameterFieldName = "areaName";
prmSubArea.ParameterFieldName = "@sub_area";
prmSubAreaName.ParameterFieldName = "subAreaName";
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
ParameterDiscreteValue pramBrandValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmMemoStatusValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmAreaValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmAreaNameValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmSubAreaValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmSubAreaNameValue = new ParameterDiscreteValue();
prmDateFromValue.Value = dateFrom;
prmDateToValue.Value = dateTo;
pramBrandValue.Value = brand;
prmMemoStatusValue.Value =memoStatus;
prmAreaNameValue.Value = areaName;
prmSubAreaNameValue.Value = subAreaNameVal;
prmAreaValue.Value = area;
prmSubAreaValue.Value = subArea;
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmBrand.CurrentValues.Add(pramBrandValue);
prmMemoStatus.CurrentValues.Add(prmMemoStatusValue);
prmArea.CurrentValues.Add(prmAreaValue);
prmSubArea.CurrentValues.Add(prmSubAreaValue);
prmAreaName.CurrentValues.Add(prmAreaNameValue);
prmSubAreaName.CurrentValues.Add(prmSubAreaNameValue);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
prmList.Add(prmBrand);
prmList.Add(prmMemoStatus);
prmList.Add(prmArea);
prmList.Add(prmSubArea);
prmList.Add(prmSubAreaName);
prmList.Add(prmAreaName);
if (Cache[reportCacheKey] != null)
{
REPORT_DOC = (StockInputReport)Cache[reportCacheKey];
}
else
{
REPORT_DOC = new StockInputReport();
Cache.Insert(reportCacheKey, REPORT_DOC);
}
DataBaseLogIn(REPORT_DOC);
this.StockInputReportViewer.ParameterFieldInfo = prmList;
StockInputReportViewer.ReportSource = REPORT_DOC;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
StockInputReport rpt = new StockInputReport();
rpt.Site = this.Site;
return rpt;
}
