public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rprSalesByProduct rpt = new rprSalesByProduct();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#2
0
        public static ReportDocument LoadSalesByProduct(DateTime date1, DateTime date2)
        {
            ReportDocument rpt = new Sales.rprSalesByProduct();
            dsReports      ds  = new dsReports();

            DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();

            ta.ClearBeforeFill = true;
            ta.Connection      = AppHelper.GetDbConnection();
            ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2);

            if (ds.DenormalizedOrders.Rows.Count <= 0)
            {
                FillNoData(ds.DenormalizedOrders);
            }

            RetrieveDeveloper(ds.Developer);
            RetrieveOwner(ds.Owner);
            rpt.SetDataSource(ds);
            rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
            rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
            return(rpt);
        }
示例#3
0
        public static ReportDocument LoadSalesByProduct(DateTime date1, DateTime date2)
        {
            ReportDocument rpt = new Sales.rprSalesByProduct();
            dsReports ds = new dsReports();

            DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
            ta.ClearBeforeFill = true;
            ta.Connection = AppHelper.GetDbConnection();
            ta.FillByDate(ds.DenormalizedOrders, TransactionTypes.TX_SALES_ORDER, date1, date2);

            if (ds.DenormalizedOrders.Rows.Count <= 0)
                FillNoData(ds.DenormalizedOrders);

            RetrieveDeveloper(ds.Developer);
            RetrieveOwner(ds.Owner);
            rpt.SetDataSource(ds);
            rpt.ParameterFields["@Date1"].CurrentValues.AddValue(date1);
            rpt.ParameterFields["@Date2"].CurrentValues.AddValue(date2);
            return rpt;
        }
 public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
     rprSalesByProduct rpt = new rprSalesByProduct();
     rpt.Site = this.Site;
     return rpt;
 }