Beispiel #1
0
        public static ReportDocument LoadSalesOrderList(DateTime date1, DateTime date2)
        {
            ReportDocument rpt = new Sales.rprSalesOrdersList();
            dsReports      ds  = new dsReports();

            ds.EnforceConstraints = false;

            DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();

            ta.ClearBeforeFill = true;
            ta.Connection      = AppHelper.GetDbConnection();
            ta.FillSalesOrders(ds.DenormalizedOrders, 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);
        }
Beispiel #2
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rprSalesOrdersList rpt = new rprSalesOrdersList();

            rpt.Site = this.Site;
            return(rpt);
        }
        public static ReportDocument LoadSalesOrderList(DateTime date1, DateTime date2)
        {
            ReportDocument rpt = new Sales.rprSalesOrdersList();
            dsReports ds = new dsReports();
            ds.EnforceConstraints = false;

            DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
            ta.ClearBeforeFill = true;
            ta.Connection = AppHelper.GetDbConnection();
            ta.FillSalesOrders(ds.DenormalizedOrders, 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() {
     rprSalesOrdersList rpt = new rprSalesOrdersList();
     rpt.Site = this.Site;
     return rpt;
 }