public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptStockDemand rpt = new RptStockDemand();
rpt.Site = this.Site;
return(rpt);
}
// genarate Stock Demand report
public static ReportClass StockDemand(DateTime?from, DateTime?To)
{
OdbcDataAdapter reportAdapter;
DataSet reportDataSet;
ReportClass currentReport = null;
reportAdapter = new OdbcDataAdapter("call StockDemand(?,?)", DBConnection.getConnection());
reportAdapter.SelectCommand.Parameters.Add("@from", OdbcType.VarChar).Value = (from == null)?"":String.Format("{0:yyyy-MM-dd}", from);
reportAdapter.SelectCommand.Parameters.Add("@to", OdbcType.VarChar).Value = (To == null) ? "" : String.Format("{0:yyyy-MM-dd}", To);
reportDataSet = new reportDS();
reportAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
reportAdapter.Fill(reportDataSet, "StockDemand");
if (reportDataSet.Tables["StockDemand"].Rows.Count > 0)
{
currentReport = new RptStockDemand();
currentReport.SetDataSource(reportDataSet);
}
return(currentReport);
}