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); }
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; }