示例#1
0
        public static ReportDocument LoadSalesInvoiceList(DateTime date1, DateTime date2)
        {
            ReportDocument rpt = new Sales.rprSalesInvoiceList();
            dsReports      ds  = new dsReports();

            ds.EnforceConstraints = false;

            DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();

            ta.ClearBeforeFill = true;
            ta.Connection      = AppHelper.GetDbConnection();
            ta.FillSalesInvoice(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);
        }
示例#2
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rprSalesInvoiceList rpt = new rprSalesInvoiceList();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#3
0
        public static ReportDocument LoadSalesInvoiceList(DateTime date1, DateTime date2)
        {
            ReportDocument rpt = new Sales.rprSalesInvoiceList();
            dsReports ds = new dsReports();
            ds.EnforceConstraints = false;

            DenormalizedOrdersTableAdapter ta = new DenormalizedOrdersTableAdapter();
            ta.ClearBeforeFill = true;
            ta.Connection = AppHelper.GetDbConnection();
            ta.FillSalesInvoice(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() {
     rprSalesInvoiceList rpt = new rprSalesInvoiceList();
     rpt.Site = this.Site;
     return rpt;
 }