/// <summary> /// Binds the report. /// </summary> private void BindReport() { DataCommand cmd = OrderDataHelper.CreateTranDataCommand(); cmd.CommandText = String.Format("SELECT E.[Name], I.* from [Inventory] I INNER JOIN [CatalogEntry] E ON E.Code = I.SkuId INNER JOIN Catalog C ON C.CatalogId = E.CatalogId WHERE (I.InstockQuantity - I.ReservedQuantity) < 20 AND I.InventoryStatus <> 0 AND C.ApplicationId = '{0}';", OrderConfiguration.Instance.ApplicationId); cmd.CommandType = CommandType.Text; cmd.Parameters = new DataParameters(); cmd.TableMapping = DataHelper.MapTables("EntryStock"); cmd.DataSet = new ProductDataSet(); DataResult results = DataService.LoadDataSet(cmd); ReportDataSource source = new ReportDataSource(); source.Name = "EntryStock"; source.Value = ((ProductDataSet)results.DataSet).EntryStock; MyReportViewer.LocalReport.DataSources.Add(source); MyReportViewer.DataBind(); }
/// <summary> /// Binds the report. /// </summary> private void BindReport() { DataCommand cmd = OrderDataHelper.CreateTranDataCommand(); cmd.CommandText = "[ecf_reporting_CustomerNumOrders]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters = new DataParameters(); cmd.Parameters.Add(new DataParameter("ApplicationId", CatalogConfiguration.Instance.ApplicationId, DataParameterType.UniqueIdentifier)); cmd.Parameters.Add(new DataParameter("interval", GroupBy.SelectedValue, DataParameterType.VarChar)); cmd.Parameters.Add(new DataParameter("startdate", StartDate.Value.ToUniversalTime(), DataParameterType.DateTime)); cmd.Parameters.Add(new DataParameter("enddate", EndDate.Value.ToUniversalTime(), DataParameterType.DateTime)); cmd.TableMapping = DataHelper.MapTables("CustomerNumOrdersReport"); cmd.DataSet = new CustomersDataSet(); DataResult results = DataService.LoadDataSet(cmd); ReportDataSource source = new ReportDataSource(); source.Name = "CustomerNumOrdersReport"; source.Value = ((CustomersDataSet)results.DataSet).CustomerNumOrdersReport; MyReportViewer.LocalReport.DataSources.Clear(); MyReportViewer.LocalReport.DataSources.Add(source); MyReportViewer.DataBind(); }