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