protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = this.dgdClientVendor.ClientNumber; string _div = this.dgdClientVendor.ClientDivsionNumber; string _clientName = this.dgdClientVendor.ClientName; string _pickupIDs = "", _vendor = "", _pudate = "", _punum = "", _pickups = ""; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(this.mDSName); foreach (GridViewRow row in SelectedRows) { DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex]; _pickupIDs += (_pickupIDs.Length > 0 ? "," : "") + dataKey["PickupID"].ToString(); _vendor = dataKey["VendorNumber"].ToString(); _pudate = DateTime.Parse(dataKey["PUDate"].ToString()).ToString("MM/dd"); _punum = dataKey["PUNumber"].ToString(); _pickups += (_pickups.Length > 0 ? ", " : "") + _vendor + "-" + _pudate + "-" + _punum; //_pickupIDs += (_pickupIDs.Length > 0 ? "," : "") + dataKey["PickupID"].ToString(); OnExportReport() } DataSet _ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _pickupIDs }); ds.Merge(_ds); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter div = new ReportParameter("ClientDivision", _div); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter pickups = new ReportParameter("Pickups", _pickups); report.SetParameters(new ReportParameter[] { client, div, clientName, pickups }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=MultiPickupSortInfo.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _fromDate = this.ddpPickups.FromDate.ToString("yyyy-MM-dd"); string _toDate = this.ddpPickups.ToDate.ToString("yyyy-MM-dd"); string _client = this.dgdClientShipper.ClientNumber; string _div = this.dgdClientShipper.ClientDivsionNumber; string _clientName = this.dgdClientShipper.ClientName; string _shipper = this.dgdClientShipper.ShipperNumber; string _shipperName = this.dgdClientShipper.ShipperName; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(); string reportFile = "", reportDS = ""; if (this.cboFreightType.SelectedValue == "0") { //Tsort- set dataset and report types reportDS = REPORT_DS_TSORT; switch (this.cboViewBy.SelectedItem.Text) { case "State": reportFile = REPORT_SRC_TSORT_STATE; break; case "Zone": reportFile = REPORT_SRC_TSORT_ZONE; break; case "Store": reportFile = REPORT_SRC_TSORT_STORE; break; } ds = enterprise.FillDataset(USP_REPORT_VENDOR, mTBLName, new object[] { _client, _div, _shipper, _fromDate, _toDate }); } else if (this.cboFreightType.SelectedValue == "1") { //Returns- set dataset and report types reportDS = REPORT_DS_RETURNS; switch (this.cboViewBy.SelectedItem.Text) { case "Vendor": reportFile = REPORT_SRC_RETURNS_VENDOR; break; case "Store": reportFile = REPORT_SRC_RETURNS_STORE; break; } ds = enterprise.FillDataset(USP_REPORT_AGENT, mTBLName, new object[] { _client, _div, _shipper, _fromDate, _toDate }); } if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(reportFile); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter fromDate = new ReportParameter("StartPUDate", _fromDate); ReportParameter toDate = new ReportParameter("EndPUDate", _toDate); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter div = new ReportParameter("ClientDivision", _div); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter shipper = new ReportParameter((this.dgdClientShipper.FreightType == FreightType.Regular ? "VendorNumber" : "AgentNumber"), _shipper); ReportParameter shipperName = new ReportParameter((this.dgdClientShipper.FreightType == FreightType.Regular ? "VendorName" : "AgentName"), _shipperName); report.SetParameters(new ReportParameter[] { client, div, fromDate, toDate, clientName, shipper, shipperName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=Discrepancy.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _startDate = DateTime.Parse(this.txtFrom.Text).ToString("yyyy-MM-dd"); string _endDate = DateTime.Parse(this.txtTo.Text).ToString("yyyy-MM-dd"); string _startTime = "07:00:01", _endTime = "07:00:00"; string _client = this.dgdClientDivision.ClientNumber; string _clientName = this.dgdClientDivision.ClientName; string _clientDiv = this.dgdClientDivision.DivisionNumber; string _div = this.txtDivision.Text.Trim().Length > 0 ? this.txtDivision.Text : null; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _clientDiv, _startDate, _endDate, _startTime, _endTime, _div }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter clientDiv = new ReportParameter("ClientDivision", _clientDiv); ReportParameter startDate = new ReportParameter("StartShipDate", _startDate); ReportParameter endDate = new ReportParameter("EndShipDate", _endDate); ReportParameter startTime = new ReportParameter("StartShipTime", _startTime); ReportParameter endTime = new ReportParameter("EndShipTime", _endTime); ReportParameter div = new ReportParameter("Division", _div); report.SetParameters(new ReportParameter[] { client, clientName, clientDiv, startDate, endDate, startTime, endTime, div }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=AmscanImperialDelivery.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _cartonID = this.txtSearchNo.Text; string _client = this.grdClients.SelectedRow.Cells[1].Text; string _div = this.grdClients.SelectedRow.Cells[2].Text; string _clientName = this.grdClients.SelectedRow.Cells[3].Text; string _terminal = this.grdClients.SelectedRow.Cells[4].Text; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(((this.cboSearchBy.SelectedValue == "ByCarton") ? USP_REPORT_BYCARTONNUMBER : USP_REPORT_BYLABELSEQNUMBER), TBL_REPORT, new object[] { _cartonID, _terminal, _client }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter cartonID = new ReportParameter("SearchNumber", _cartonID); ReportParameter terminal = new ReportParameter("TerminalCode", _terminal); ReportParameter client = new ReportParameter("Client", _client); report.SetParameters(new ReportParameter[] { cartonID, terminal, client }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=CartonSearch.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = Master.ClientNumber; string _division = Master.Division; string _agent = Master.AgentNumber; string _region = Master.Region; string _district = Master.District; string _store = Master.StoreNumber; int _isException = this.chkExceptionsOnly.Checked ? 1 : 0; string _start = Master.StartDate; string _end = Master.EndDate; string _vendor = this.cboVendorLoc.SelectedValue != "" ? this.cboVendor.SelectedValue : null; string _vendorLoc = this.cboVendorLoc.SelectedValue != "" ? this.cboVendorLoc.SelectedValue : null; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _division, _agent, _region, _district, _store, _start, _end, _isException, _vendor, _vendorLoc }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", Master.ClientName); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter division = new ReportParameter("Division", _division); ReportParameter agent = new ReportParameter("AgentNumber"); if (_agent != null) { agent.Values.Add(_agent); } ReportParameter region = new ReportParameter("Region"); if (_region != null) { region.Values.Add(_region); } ReportParameter district = new ReportParameter("District"); if (_district != null) { district.Values.Add(_district); } ReportParameter store = new ReportParameter("StoreNumber"); if (_store != null) { store.Values.Add(_store); } ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); ReportParameter isException = new ReportParameter("IsExceptionOnly", _isException.ToString()); ReportParameter vendor = new ReportParameter("VendorCompany"); if (_vendor != null) { vendor.Values.Add(_vendor); } ReportParameter vendorLoc = new ReportParameter("VendorLocation"); if (_vendorLoc != null) { vendorLoc.Values.Add(_vendorLoc); } ReportParameter vendorName = new ReportParameter("VendorName", this.cboVendor.SelectedItem.Text); ReportParameter vendorLocName = new ReportParameter("LocationName", this.cboVendorLoc.SelectedItem.Text); report.SetParameters(new ReportParameter[] { client, division, agent, vendor, vendorLoc, region, district, store, start, end, isException, clientName, vendor, vendorLoc, vendorName, vendorLocName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=OnTimeDeliveryDetailByStoreAndVendor.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for view button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _text = this.txtNumbers.Text.Replace("\r\n", ","); string _terminal = this.cboTerminal.SelectedValue; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _text, _terminal }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter terminal = new ReportParameter("TerminalCode", _terminal); ReportParameter text = new ReportParameter("Text", _text); report.SetParameters(new ReportParameter[] { text, terminal }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=MultipleCartonSearch.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _fromDate = this.ddpPickups.FromDate.ToString("yyyy-MM-dd"); string _toDate = this.ddpPickups.ToDate.ToString("yyyy-MM-dd"); string _client = this.dgdClientVendor.ClientNumber; string _div = (this.chkAllDivs.Checked) ? null : this.dgdClientVendor.ClientDivsionNumber; string _clientName = this.dgdClientVendor.ClientName; string _vendor = this.dgdClientVendor.VendorNumber; string _vendorName = this.dgdClientVendor.VendorName; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(); string reportFile = "", reportDS = "", usp = ""; switch (this.cboType.SelectedItem.Text) { case "Over": reportFile = REPORT_SRC_OVER; reportDS = REPORT_DS_OVER; usp = USP_REPORT_OVER; break; case "Short": reportFile = REPORT_SRC_SHORT; reportDS = REPORT_DS_SHORT; usp = USP_REPORT_SHORT; break; } ds = enterprise.FillDataset(usp, mTBLName, new object[] { _fromDate, _toDate, _vendor, _client, _div }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(reportFile); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter fromDate = new ReportParameter("Startdate", _fromDate); ReportParameter toDate = new ReportParameter("EndDate", _toDate); ReportParameter client = new ReportParameter("ClientNumber", _client + "-" + (_div == null?"All":_div) + " " + _clientName); ReportParameter div = new ReportParameter("DivisionNumber", (_div == null?"All":_div)); ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter vendor = new ReportParameter("VendorNumber", _vendor + " " + _vendorName); ReportParameter vendorName = new ReportParameter("VendorName", _vendorName); report.SetParameters(new ReportParameter[] { fromDate, toDate, vendor, client, div }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, reportDS)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(reportDS, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=TimePeriodCartonCompare.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _clientName = this.dgdClientVendor.ClientName; string _pickupID = "", _termCode = ""; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(REPORT_DS); foreach (GridViewRow row in SelectedRows) { DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex]; _pickupID += (_pickupID.Length > 0 ? ", " : "") + dataKey["PickupID"].ToString(); _termCode = dataKey["TerminalCode"].ToString(); DataSet _ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { dataKey["TerminalCode"].ToString(), dataKey["PickupID"].ToString() }); ds.Merge(_ds); } if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter puID = new ReportParameter("PickupID", _pickupID); ReportParameter termCode = new ReportParameter("TerminalCode", _termCode); report.SetParameters(new ReportParameter[] { termCode, puID, clientName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ASNTracking.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _clientName = this.dgdClientVendor.ClientName; string _pickupID = "", _termCode = ""; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(this.mDSName); foreach (GridViewRow row in SelectedRows) { DataKey dataKey = (DataKey)this.grdPickups.DataKeys[row.RowIndex]; _pickupID += (_pickupID.Length > 0 ? ", " : "") + dataKey["PickupID"].ToString(); _termCode = dataKey["TerminalCode"].ToString(); DataSet _ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { dataKey["TerminalCode"].ToString(), dataKey["PickupID"].ToString() }); ds.Merge(_ds); } if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", _clientName); ReportParameter puID = new ReportParameter("PickupID", _pickupID); ReportParameter termCode = new ReportParameter("TerminalCode", _termCode); ReportParameter store = new ReportParameter("StoreNumber", this.txtStore.Text.Trim().Length > 0 ? this.txtStore.Text.Trim() : null); ReportParameter zone = new ReportParameter("ZoneCode", this.txtZone.Text.Trim().Length > 0 ? this.txtZone.Text.Trim().PadRight(2) : null); report.SetParameters(new ReportParameter[] { termCode, puID, clientName, store, zone }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ASNTracking.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _from = this.ddpPickups.FromDate.ToString("yyyy-MM-dd"); string _to = this.ddpPickups.ToDate.ToString("yyyy-MM-dd"); string _zone = this.cboAgent.SelectedValue != "" ? this.cboAgent.SelectedValue : null; string _weight = this.txtWeight.Text; string _cube = this.txtCube.Text; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _from, _to, _zone, _weight, _cube }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter from = new ReportParameter("StartDate", _from); ReportParameter to = new ReportParameter("EndDate", _to); ReportParameter weight = new ReportParameter("OptimalTrailerWeight", _weight); ReportParameter zone = new ReportParameter("MainZone", _zone); report.SetParameters(new ReportParameter[] { from, to, weight, zone }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ScanningSummaryByStore.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string dates = this.cboDateValue.SelectedValue; string _start = dates.Split(':')[0].Trim(); string _end = dates.Split(':')[1].Trim(); string type = this.cboType.SelectedValue; string _vendor = this.cboCustomer.SelectedValue; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = null; switch (type) { case "DDU": if (this.chkZips.Checked) { ds = enterprise.FillDataset(USP_REPORT_DDU, TBL_REPORT, new object[] { _end, _vendor }); } else { ds = enterprise.FillDataset(USP_REPORT_DDU_SUBSET, TBL_REPORT, new object[] { _end, _vendor }); } break; case "NDC": ds = enterprise.FillDataset(USP_REPORT_NDC, TBL_REPORT, new object[] { _end, _vendor }); break; case "SCF": ds = enterprise.FillDataset(USP_REPORT_SCF, TBL_REPORT, new object[] { _end, _vendor }); break; } if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = null; switch (type) { case "DDU": stream = Master.GetReportDefinition(REPORT_SRC_DDU); break; case "NDC": stream = Master.GetReportDefinition(REPORT_SRC_NDC); break; case "SCF": stream = Master.GetReportDefinition(REPORT_SRC_SCF); break; } report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter end = new ReportParameter("EndDate", _end); ReportParameter vendor = new ReportParameter("VendorNumber", _vendor); ReportParameter customer = new ReportParameter("Customer", this.cboCustomer.SelectedItem.Text); report.SetParameters(new ReportParameter[] { end, vendor, customer }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=BNConsumerDirectWeeklyPerformanceSummary.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = Master.ClientNumber; string _division = Master.Division; string _agent = Master.AgentNumber; string _region = Master.Region; string _district = Master.District; string _store = Master.StoreNumber; string _start = Master.StartDate; string _end = Master.EndDate; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _division, _agent, _region, _district, _store, _start, _end }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", Master.ClientName); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter division = new ReportParameter("Division", _division); ReportParameter agent = new ReportParameter("AgentNumber", _agent); ReportParameter region = new ReportParameter("Region", _region); ReportParameter district = new ReportParameter("District", _district); ReportParameter store = new ReportParameter("StoreNumber", _store); ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); report.SetParameters(new ReportParameter[] { client, division, agent, region, district, store, start, end, clientName }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=DeliveryWindowSummaryByStore.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = Master.ClientNumber; string _agent = Master.AgentNumber; string _start = Master.StartDate; string _end = Master.EndDate; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _agent, _start, _end }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); DataSet _ds = enterprise.FillDataset("uspRptAgentRead", mTBLName, new object[] { _agent }); report.DataSources.Add(new ReportDataSource("DataSet1", _ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter agent = new ReportParameter("AgentNumber", _agent); ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); report.SetParameters(new ReportParameter[] { client, agent, start, end }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ScanningSummaryByClient.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string dates = this.cboDateValue.SelectedValue; string _start = dates.Split(':')[0].Trim(); string _end = dates.Split(':')[1].Trim(); int _delivDays = Convert.ToInt32(this.cboDelivDays.Text); string _locType = this.cboLocType.Text; string _vendor = this.cboCustomer.SelectedValue; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _start, _end, _delivDays, _locType, _vendor }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); ReportParameter delivDays = new ReportParameter("DeliveryDays", _delivDays.ToString()); ReportParameter locType = new ReportParameter("LocationType", _locType); report.SetParameters(new ReportParameter[] { start, end, delivDays, locType }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=BNConsumerDirectCartonDetail.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = this.cboClient.SelectedValue != "" ? this.cboClient.SelectedValue : null; string _vendor = this.cboVendor.SelectedValue != "" ? this.cboVendor.SelectedValue : null; string _numbers = this.txtNumbers.Text.Replace("\r\n", ","); //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); string sp = this.mUSPName; switch (this.cboBy.SelectedValue.ToLower()) { case "carton": sp = this.mUSPName; break; case "tracking": sp = USP_REPORT_BYTRACKINGNUMBER; break; case "labelsequence": sp = USP_REPORT_BYLABELSEQNUMBER; break; } DataSet ds = enterprise.FillDataset(sp, this.mTBLName, new object[] { _numbers, _client, _vendor }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter numbers = new ReportParameter("Text", _numbers); ReportParameter client = new ReportParameter("Client", _client); ReportParameter vendor = new ReportParameter("Vendor", _vendor); report.SetParameters(new ReportParameter[] { numbers, client, vendor }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=MultiCartonPOD.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnViewerDrillthrough(object sender, DrillthroughEventArgs e) { //Event handler for drill through if (!e.Report.IsDrillthroughReport) { return; } //Determine which drillthrough report is requested LocalReport report = (LocalReport)e.Report; report.DisplayName = e.ReportPath; report.EnableExternalImages = true; switch (e.ReportPath) { case "Scanning Summary By Client": { //Get drillthrough parameters string _agent = "", _start = "", _end = ""; for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++) { switch (report.OriginalParametersToDrillthrough[i].Name) { case "StartDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "EndDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "AgentNumber": _agent = report.OriginalParametersToDrillthrough[i].Values[0]; break; } } //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition("/Executive/" + e.ReportPath); report.LoadReportDefinition(stream); EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset("uspRptScanningSummaryByClient", "NewTable", new object[] { null, _agent, _start, _end }); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource("ScanningSummaryByClientDS", ds.Tables["NewTable"])); DataSet _ds = enterprise.FillDataset("uspRptAgentRead", mTBLName, new object[] { _agent }); report.DataSources.Add(new ReportDataSource("DataSet1", _ds.Tables["NewTable"])); ReportParameter client = new ReportParameter("ClientNumber"); ReportParameter agent = new ReportParameter("AgentNumber", _agent); ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); report.SetParameters(new ReportParameter[] { client, agent, start, end }); report.Refresh(); } break; case "Scanning Summary By Agent": { //Get drillthrough parameters string _client = "", _start = "", _end = ""; for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++) { switch (report.OriginalParametersToDrillthrough[i].Name) { case "StartDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "EndDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break; case "ClientNumber": _client = report.OriginalParametersToDrillthrough[i].Values[0]; break; } } //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition("/Executive/" + e.ReportPath); report.LoadReportDefinition(stream); EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, null, null, null, null, null, null, _start, _end }); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); DataSet _ds = enterprise.FillDataset("uspRptClientRead", mTBLName, new object[] { _client }); report.DataSources.Add(new ReportDataSource("DataSet1", _ds.Tables[mTBLName])); ReportParameter clientName = new ReportParameter("ClientName"); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter division = new ReportParameter("Division"); ReportParameter agentnumber = new ReportParameter("AgentParentNumber"); ReportParameter subagentnumber = new ReportParameter("AgentNumber"); ReportParameter region = new ReportParameter("Region"); ReportParameter district = new ReportParameter("District"); ReportParameter store = new ReportParameter("StoreNumber"); ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); report.SetParameters(new ReportParameter[] { client, division, agentnumber, subagentnumber, region, district, store, start, end, clientName }); report.Refresh(); } break; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for view button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = this.dgdClientVendorLog.ClientNumber; string _div = this.dgdClientVendorLog.ClientDivsionNumber; string _name = this.dgdClientVendorLog.ClientName; string _manifestID = "", _pickupDate = "", _pickupNum = ""; LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = new DataSet(REPORT_DS); for (int i = 0; i < this.dgdClientVendorLog.VendorLogEntries.VendorLogTable.Rows.Count; i++) { _manifestID = this.dgdClientVendorLog.VendorLogEntries.VendorLogTable[i].ID.ToString(); _pickupDate = this.dgdClientVendorLog.VendorLogEntries.VendorLogTable[i].PickupDate.ToString("MM-dd-yyyy"); _pickupNum = this.dgdClientVendorLog.VendorLogEntries.VendorLogTable[i].PickupNumber.ToString(); DataSet _ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _manifestID }); _ds.Tables[TBL_REPORT].Columns.Add("ManifestID"); _ds.Tables[TBL_REPORT].Columns.Add("PickupDate"); _ds.Tables[TBL_REPORT].Columns.Add("PickupNumber"); for (int j = 0; j < _ds.Tables[TBL_REPORT].Rows.Count; j++) { _ds.Tables[TBL_REPORT].Rows[j]["ManifestID"] = _manifestID; _ds.Tables[TBL_REPORT].Rows[j]["PickupDate"] = _pickupDate; _ds.Tables[TBL_REPORT].Rows[j]["PickupNumber"] = _pickupNum; } ds.Merge(_ds); } if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter manifestID = new ReportParameter("ManifestID", ""); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter div = new ReportParameter("ClientDivision", _div); ReportParameter name = new ReportParameter("ClientName", _name); ReportParameter punumber = new ReportParameter("PUNumber", ""); ReportParameter pudate = new ReportParameter("PUDate", ""); report.SetParameters(new ReportParameter[] { manifestID, client, div, name, punumber, pudate }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=AuditTrailer.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _client = this.cboClient.SelectedValue != "" ? this.cboClient.SelectedValue : null; string _division = this.cboParam.SelectedValue == "Divisions" && this.cboValue.SelectedValue != "" ? this.cboValue.SelectedValue : null; string _agent = this.cboParam.SelectedValue == "Agents" && this.cboValue.SelectedValue != "" ? this.cboValue.SelectedValue : null; string _region = this.cboParam.SelectedValue == "Regions" && this.cboValue.SelectedValue != "" ? this.cboValue.SelectedValue : null; string _district = this.cboParam.SelectedValue == "Districts" && this.cboValue.SelectedValue != "" ? this.cboValue.SelectedValue : null; string _store = this.cboParam.SelectedValue == "Stores" && this.txtStore.Text.Length > 0 ? this.txtStore.Text : null; string _start = this.cboDateValue.SelectedValue.Split(',')[0].Split(':')[0].Trim(); string _end = this.cboDateValue.SelectedValue.Split(',')[0].Split(':')[1].Trim(); string _filter = this.txtFilter.Text; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = this.mTitle; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(this.mUSPName, mTBLName, new object[] { _client, _division, _agent, _region, _district, _store, _end, _filter }); if (ds.Tables[mTBLName] == null) { ds.Tables.Add(mTBLName); } switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(this.mSource); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); //Set the report parameters for the report ReportParameter clientName = new ReportParameter("ClientName", this.cboClient.SelectedItem.Text); ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter division = new ReportParameter("Division", _division); ReportParameter agent = new ReportParameter("AgentNumber", _agent); ReportParameter region = new ReportParameter("Region", _region); ReportParameter district = new ReportParameter("District", _district); ReportParameter store = new ReportParameter("StoreNumber", _store); ReportParameter start = new ReportParameter("StartDate", _start); ReportParameter end = new ReportParameter("EndDate", _end); ReportParameter filter = new ReportParameter("NotOnTimeDeliveriesFilter", _filter); Master.Viewer.LocalReport.SetParameters(new ReportParameter[] { client, division, agent, region, district, store, end, filter }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, this.mDSName)); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(this.mDSName, ds.Tables[mTBLName])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=InternalDeliveryWindowByStore.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[mTBLName]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } catch (Exception ex) { Master.ReportError(ex); } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for command button clicked //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _ssdate = this.ddpShipSchedDate.ToDate.ToString("yyyy-MM-dd"); //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _ssdate }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter ssdate = new ReportParameter("ShipScdeDate", _ssdate); report.SetParameters(new ReportParameter[] { ssdate }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=CartonsCap.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } }
protected void OnButtonCommand(object sender, CommandEventArgs e) { //Event handler for view button clicked try { //Change view to Viewer and reset to clear existing data Master.Viewer.Reset(); //Get parameters for the query string _from = this.ddpSetup.FromDate.ToString("yyyy-MM-dd"); string _to = this.ddpSetup.ToDate.ToString("yyyy-MM-dd"); string _client = this.cboClient.SelectedValue; string _terminal = this.cboTerminal.SelectedValue == "" ? null : this.cboTerminal.SelectedValue; string _vendor = this.cboVendor.SelectedValue == "" ? null : this.cboVendor.SelectedValue; string _zone = this.cboZone.SelectedValue == "" ? null : this.cboZone.SelectedValue; //Initialize control values LocalReport report = Master.Viewer.LocalReport; report.DisplayName = REPORT_NAME; report.EnableExternalImages = true; EnterpriseGateway enterprise = new EnterpriseGateway(); DataSet ds = enterprise.FillDataset(USP_REPORT, TBL_REPORT, new object[] { _client, _terminal, _vendor, _zone, _from, _to }); if (ds.Tables[TBL_REPORT].Rows.Count >= 0) { switch (e.CommandName) { case "Run": //Set local report and data source System.IO.Stream stream = Master.GetReportDefinition(REPORT_SRC); report.LoadReportDefinition(stream); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); //Set the report parameters for the report ReportParameter client = new ReportParameter("ClientNumber", _client); ReportParameter terminal = new ReportParameter("TerminalCode", _terminal); ReportParameter vendor = new ReportParameter("VendorNumber", _vendor); ReportParameter zone = new ReportParameter("ZoneCode", _zone); ReportParameter from = new ReportParameter("StartSortDate", _from.ToString()); ReportParameter to = new ReportParameter("EndSortDate", _to.ToString()); report.SetParameters(new ReportParameter[] { client, terminal, vendor, zone, from, to }); //Update report rendering with new data report.Refresh(); if (!Master.Viewer.Enabled) { Master.Viewer.CurrentPage = 1; } break; case "Data": //Set local export report and data source report.LoadReportDefinition(Master.CreateExportRdl(ds, REPORT_DS, "RGXSQLR.TSORT")); report.DataSources.Clear(); report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT])); report.Refresh(); break; case "Excel": //Create Excel mime-type page Response.ClearHeaders(); Response.Clear(); Response.Charset = ""; Response.AddHeader("Content-Disposition", "inline; filename=ClientCube.xls"); Response.ContentType = "application/vnd.ms-excel"; //application/octet-stream"; System.IO.StringWriter sw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); DataGrid dg = new DataGrid(); dg.DataSource = ds.Tables[TBL_REPORT]; dg.DataBind(); dg.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); break; } } else { Master.Status = "There were no records found."; } } catch (Exception ex) { Master.ReportError(ex); } }