private void reportViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
int CompanyId = int.Parse(Parameters.Find(p => p.Name == "CompanyId").Value);
int AccountId = 0;
DateTime FromDate = DateTime.Parse(Parameters.Find(p => p.Name == "FromDate").Value);
DateTime ToDate = DateTime.Parse(Parameters.Find(p => p.Name == "ToDate").Value);
ReportParameter[] reportParam = new ReportParameter[2];
EGeneralLedgerDetailsReportDS jDataSource = new EGeneralLedgerDetailsReportDS();
GeneralLedgerDetailsTableAdapter JournalAdapter = new GeneralLedgerDetailsTableAdapter();
ECompanyDS companyDataSource = new ECompanyDS();
tblCompaniesTableAdapter companyAdapter = new tblCompaniesTableAdapter();
if ((e.Report as LocalReport).GetParameters()["ReportType"].Values[0] == "Per Date")
{
FromDate = IDateHandler.Parse((e.Report as LocalReport).GetParameters()["FromDate"].Values[0]);
ToDate = IDateHandler.Parse((e.Report as LocalReport).GetParameters()["ToDate"].Values[0]);
}
AccountId = int.Parse((e.Report as LocalReport).GetParameters()["AccountId"].Values[0]);
JournalAdapter.Fill(jDataSource.GeneralLedgerDetails, CompanyId, FromDate, ToDate, AccountId);
companyAdapter.Fill(companyDataSource.tblCompanies, CompanyId);
reportParam[0] = new ReportParameter("FromDate", FromDate.ToString("MM'/'dd'/'yyyy"), false);
reportParam[1] = new ReportParameter("ToDate", ToDate.ToString("MM'/'dd'/'yyyy"), false);
(e.Report as LocalReport).SetParameters(reportParam);
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("GeneralLedgerDetails", jDataSource.Tables["GeneralLedgerDetails"]));
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("Company", companyDataSource.Tables["tblCompanies"]));
}
protected void rv_Drillthrough(object sender, DrillthroughEventArgs e)
{
switch (e.ReportPath)
{
case "subreport1":
;
break;
case "ReportOrder":
LocalReport report = (LocalReport)e.Report;
IList <ReportParameter> list = report.OriginalParametersToDrillthrough;
string strCaseId = list[0].Values[0].ToString();
InitDataBase();
cmd.CommandText = strOrderID + @" where ""CustomerID"" = '" + strCaseId + "'";
DataTable dtOrders = dc.GetDataSet(cmd, CommandType.Text, null).Tables[0];
report.DataSources.Add(new ReportDataSource("dtOrders", dtOrders));
break;
case "subreport3":
;
break;
default:
break;
}
}
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
this.reportViewer1.LocalReport.ReportEmbeddedResource = "SSS.Reports.Coordinator.StudentEngagement.ViewDisengagedStudentsReport.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
ReportDataConnect();
this.reportViewer1.RefreshReport();
}
/// <summary>
///
/// </summary>
/// <param name="currentDrillthroughEventArgs"></param>
private void OnReportDrilledThrough(DrillthroughEventArgs currentDrillthroughEventArgs)
{
if (ReportDrilledThrough != null)
{
ReportDrilledThrough(this, currentDrillthroughEventArgs);
}
}
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
this.reportViewer1.LocalReport.ReportEmbeddedResource = "SSS.Reports.Coordinator.StudentEngagement.ViewDisengagedStudentsReport.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
ReportDataConnect();
this.reportViewer1.RefreshReport();
}
/// <summary>
/// Handles the ReportViewer.Drillthrough event. Add the data for the drillthrough report here.
/// </summary>
private void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
LocalReport report = (LocalReport)e.Report;
// Supply a DataTable corresponding to each drillthrough report dataset
// The dataset name must match the name defined in the drillthrough report
report.DataSources.Add(new ReportDataSource(report.GetDataSourceNames()[0], LoadOrderDetailsData()));
}
public void OnDrillthrough(ReportViewer reportViewer, DrillthroughEventArgs e)
{
var report = (LocalReport)e.Report;
var parameters = report.GetParameters();
var countryId = int.Parse(parameters["CountryId"].Values.First());
var cities = LocalData.GetCitiesByCountryId(countryId);
report.DataSources.Add(new ReportDataSource("Cities", cities));
report.Refresh();
}
public void OnDrillthrough(ReportViewer reportViewer, DrillthroughEventArgs e)
{
var report = (LocalReport)e.Report;
var parameters = report.GetParameters();
var countryId = int.Parse(parameters["CountryId"].Values.First());
var cities = LocalData.GetCitiesByCountryId(countryId);
report.DataSources.Add(new ReportDataSource("Cities", cities));
report.Refresh();
}
private void DrillthroughEventHandler(object sender, DrillthroughEventArgs e)
{
if (UseSSRSParams())
{
return;
}
ReportStore store = GetStore();
try
{
e.Report.DisplayName = e.ReportPath;
DrillThrough dt = new DrillThrough();
dt.ReportPath = Util.ResolveReference(e.ReportPath, ReportPath);
if (e.Report.GetType() != typeof(ServerReport))
{
LocalReport localReport = (LocalReport)e.Report;
dt.ParamValues = localReport.OriginalParametersToDrillthrough;
Report rep = new Report(Util.ResolveReference(e.ReportPath, ReportPath), store);
e.Report.LoadReportDefinition(rep.Stream);
rep.AddSubreports(localReport, rep.ReportPath);
//Moify Data Source and Data Sets if needed
rep.SetDataSources(localReport.DataSources, new List <ReportParameter>(localReport.OriginalParametersToDrillthrough));
localReport.SetParameters(localReport.OriginalParametersToDrillthrough);
localReport.EnableExternalImages = true;
localReport.EnableHyperlinks = true;
localReport.Refresh();
}
else
{
dt.ParamValues = Util.GetRuntimeParameters(e.Report.GetParameters());
}
//Store params for client
string script = @"document.getElementById('DrillThroughParams').value = '" + JsonConvert.SerializeObject(dt) + "';";
ScriptManager.RegisterStartupScript(this, this.GetType(), "open", script, true);
}
catch (Exception ex)
{
string err = ex.Message;
if (ex.InnerException != null)
{
err = ex.InnerException.Message;
}
SetErrorText(err);
}
}
protected void OnViewerDrillthrough(object sender, DrillthroughEventArgs e)
{
//Event handler for drill through
try {
if (!e.Report.IsDrillthroughReport)
{
return;
}
//Determine which drillthrough report is requested
LocalReport report = (LocalReport)e.Report;
switch (e.ReportPath)
{
case "PacSun Delivery Carton Detail":
case "PacSun Delivery OSD Detail":
//Get drillthrough parameters
string _start = "", _end = "", _terminal = "", _store = "", _manifest = "";
for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++)
{
switch (report.OriginalParametersToDrillthrough[i].Name)
{
case "FromDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "ToDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "TerminalName": _terminal = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "StoreNumber": _store = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "ManifestNumber": _manifest = report.OriginalParametersToDrillthrough[i].Values[0]; break;
}
}
//Set data source and parameters
System.IO.Stream stream = Master.GetReportDefinition("/Tracking/" + e.ReportPath);
report.LoadReportDefinition(stream);
DataSet ds = (DataSet)Session["PacSunDS"];
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource(REPORT_DS, ds.Tables[TBL_REPORT]));
ReportParameter start = new ReportParameter("FromDate", _start);
ReportParameter end = new ReportParameter("ToDate", _end);
ReportParameter terminal = new ReportParameter("TerminalName", _terminal);
ReportParameter store = new ReportParameter("StoreNumber", _store);
ReportParameter manifest = new ReportParameter("ManifestNumber", _manifest);
e.Report.SetParameters(new ReportParameter[] { start, end, terminal, store, manifest });
e.Report.Refresh();
break;
}
}
catch (Exception ex) { Master.ReportError(ex, 4); }
}
private void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
int userid = 0;
LocalReport report = (LocalReport)e.Report;
foreach (ReportParameter rp in ((LocalReport)e.Report).OriginalParametersToDrillthrough)
{
userid = Convert.ToInt32(rp.Values[0]);
}
//Binding the DataTable to the Child report dataset.
//The name DataSet1 which can be located from,
//Go to Design view of Child.rdlc, Click View menu -> Report Data
//You'll see this name under DataSet2.
report.DataSources.Add(new ReportDataSource("DataSet1", objEmpModelService.GetEmployeeInfo(userid)));
}
private void visor_Drillthrough(object sender, DrillthroughEventArgs e)
{
LocalReport localReport = (LocalReport)e.Report;
string fn = System.IO.Path.GetFileNameWithoutExtension(localReport.ReportPath);
localReport.DataSources.Clear();
for (int j = 0; j <= this.ActDb.Tables.Count - 1; j++)
{
if (j == 0)
{
continue;//Saltar tabla con el nombre de las tablas que siempre debe de ser la primera en el conjunto de seleccion
}
DataTable table = this.ActDb.Tables[j];
localReport.DataSources.Add(new ReportDataSource(table.TableName, table));
}
}
void rptViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
LocalReport localreport = (LocalReport)e.Report;
IList<ReportParameter> list = localreport.OriginalParametersToDrillthrough;
DispatchOrderId =Convert.ToInt32(list[0].Values[0]);
var dtDetails = _dispatchOrderService.GetDispatchOrderDetailByDispatchOrderid(DispatchOrderId);
localreport.EnableHyperlinks = true;
ReportDataSource rds = new ReportDataSource("DispatchOrderDetail", dtDetails);
// ReportDataSource rds1 = new ReportDataSource("dsCashCard", dt);
localreport.DataSources.Clear();
localreport.DataSources.Add(rds);
localreport.Refresh();
}
/// <summary>
/// Handles drilldown report events
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
_localReport = (LocalReport)e.Report;
OnReportDrilledThrough(e);
byte[] rdlBytes = Encoding.UTF8.GetBytes(_reportInfo.ReportDefinition);
System.IO.MemoryStream stream = new System.IO.MemoryStream(rdlBytes);
_localReport.LoadReportDefinition(stream);
RunReport();
if (!_bDisplayedError)
{
_localReport.Refresh();
}
}
void rptViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
LocalReport localreport = (LocalReport)e.Report;
IList <ReportParameter> list = localreport.OriginalParametersToDrillthrough;
DispatchOrderId = Convert.ToInt32(list[0].Values[0]);
var dtDetails = _dispatchOrderService.GetDispatchOrderDetailByDispatchOrderid(DispatchOrderId);
localreport.EnableHyperlinks = true;
ReportDataSource rds = new ReportDataSource("DispatchOrderDetail", dtDetails);
// ReportDataSource rds1 = new ReportDataSource("dsCashCard", dt);
localreport.DataSources.Clear();
localreport.DataSources.Add(rds);
localreport.Refresh();
}
private void reportViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
int CompanyId = int.Parse(Parameters.Find(p => p.Name == "CompanyId").Value);
DateTime FromDate = DateTime.Parse(Parameters.Find(p => p.Name == "FromDate").Value);
DateTime ToDate = DateTime.Parse(Parameters.Find(p => p.Name == "ToDate").Value);
if (e.ReportPath == "Income Statement Detail Chart")
{
ReportParameter[] reportParam = new ReportParameter[2];
EIncomeStatementChartReportDS isDataSource = new EIncomeStatementChartReportDS();
IncomeStatementDetailChartReportTableAdapter isDetailAdapter = new IncomeStatementDetailChartReportTableAdapter();
ECompanyDS companyDataSource = new ECompanyDS();
tblCompaniesTableAdapter companyAdapter = new tblCompaniesTableAdapter();
isDetailAdapter.Fill(isDataSource.IncomeStatementDetailChartReport, CompanyId, FromDate, ToDate);
companyAdapter.Fill(companyDataSource.tblCompanies, CompanyId);
reportParam[0] = new ReportParameter("FromDate", FromDate.ToString("MM'/'dd'/'yyyy"), false);
reportParam[1] = new ReportParameter("ToDate", ToDate.ToString("MM'/'dd'/'yyyy"), false);
(e.Report as LocalReport).SetParameters(reportParam);
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("IncomeStatementDetailChartReport", isDataSource.Tables["IncomeStatementDetailChartReport"]));
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("Company", companyDataSource.Tables["tblCompanies"]));
}
else if (e.ReportPath == "Balance Sheet Detail Chart")
{
ReportParameter[] reportParam = new ReportParameter[1];
EBalanceSheetChartReport bsDataSource = new EBalanceSheetChartReport();
BalanceSheetDetailChartReportTableAdapter bsDetailAdapter = new BalanceSheetDetailChartReportTableAdapter();
ECompanyDS companyDataSource = new ECompanyDS();
tblCompaniesTableAdapter companyAdapter = new tblCompaniesTableAdapter();
bsDetailAdapter.Fill(bsDataSource.BalanceSheetDetailChartReport, CompanyId, ToDate);
companyAdapter.Fill(companyDataSource.tblCompanies, CompanyId);
reportParam[0] = new ReportParameter("AsOfDate", ToDate.ToString("MM'/'dd'/'yyyy"), false);
(e.Report as LocalReport).SetParameters(reportParam);
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("BalanceSheetDetailChartReport", bsDataSource.Tables["BalanceSheetDetailChartReport"]));
(e.Report as LocalReport).DataSources.Add(new ReportDataSource("Company", companyDataSource.Tables["tblCompanies"]));
}
}
private void rptView_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
LocalReport DetailReport = (LocalReport)e.Report;
MICS.Reports.PurchasedProducts.SalesDetailDataTable r = new PurchasedProducts.SalesDetailDataTable();
MICS.Reports.PurchasedProductsTableAdapters.SalesDetailsTableAdapter ad = new MICS.Reports.PurchasedProductsTableAdapters.SalesDetailsTableAdapter();
ad.SetTimeOut = 120;
ReportParameterInfoCollection p = DetailReport.GetParameters();
string name = p[0].Name;
string ParamValue = p[0].Values[0];
ad.FillByWhere(this.PurchasedProducts.SalesDetail, ParamValue);
DetailReport.DataSources.Add(new ReportDataSource("PurchasedProducts_SalesDetail", ad.GetData()));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
LocalReport lr = (LocalReport)e.Report;
/*
* this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
* if (lr.ReportPath.Contains("DashboardDetails") == true)
* {
* ReportParameterInfoCollection pars = e.Report.GetParameters();
* bizReport biz = new bizReport();
* List<proc_rpt_DashboardDetailResult> rs = biz.GetDashboardDetailData(
* DateTime.Parse(pars[0].Values[0]),
* DateTime.Parse(pars[1].Values[0]),
* pars[2].Values[0],
* int.Parse(pars[4].Values[0]),
* int.Parse(pars[3].Values[0]),
* pars[5].Values[0],
* pars[6].Values[0],
* pars[7].Values[0] == "" ? null : pars[7].Values[0],
* pars[8].Values[0] == "" ? null : pars[8].Values[0]);
* this.ucMessanger1.ProcessMessages(biz.MSGS, true);
* ReportDataSource myRDS = new ReportDataSource("proc_rpt_DashboardDetailResult", rs);
* lr.DataSources.Clear();
* lr.DataSources.Add(myRDS);
* lr.Refresh();
* this.ReportViewer1.Height = Unit.Point(800);
* this.ReportViewer1.Visible = true;
*
* }
*/
}
catch (Exception ex)
{
bizLog.InsertExceptionLog(ex);
Response.Redirect("~/ErrorPage.aspx", false);
}
}
protected void rpViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
// Handle local drillthrough only
if (e.Report is ServerReport)
{
return;
}
LocalReport localreport = (LocalReport)e.Report;
RDLReportDocument drillReport = new RDLReportDocument(e.ReportPath);
drillReport.ReportPathWithOutName = Report.ReportPathWithOutName;
drillReport.Load(String.Format(@"{0}\{1}.{2}", Report.ReportPathWithOutName, e.ReportPath, "rdl"));
drillReport.LoadSourceDataSet(localreport.OriginalParametersToDrillthrough);
localreport.DataSources.Clear();
localreport.LoadReportDefinition(drillReport.GetCustomTextReader(drillReport.ReportPath));
localreport.DisplayName = drillReport.Name;
SetDataSource(drillReport.dsSource, localreport);
ReportParameter[] Parameters = new ReportParameter[drillReport.Parameters.Count];
int i = 0;
foreach (RDLParameter rpParam in drillReport.Parameters)
{
Parameters[i] = new ReportParameter();
Parameters[i].Name = rpParam.Name;
Parameters[i].Values.Add(rpParam.Value.ToString());
i++;
}
localreport.Refresh();
}
catch (Exception ex)
{
this.ErrorMessage = (ExceptionHelper.getExceptionMessage(ex));
}
}
/// <summary>
/// Handles the Drillthrough event of the RptViewer control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Microsoft.Reporting.WebForms.DrillthroughEventArgs"/> instance containing the event data.</param>
private void RptViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
LocalReport lr = (LocalReport)e.Report;
string photo = lr.GetParameters()["Photo"].Values[0].ToString();
//2014.02.17 paulus: 直接用 Photo as image Uri
//string imageFolder = VWGContext.Current.Config.GetDirectory("RTImages");
//string imagePath = Path.Combine(Path.Combine(imageFolder, "Product"), photo);
string imagePath = photo;
ViewImage viewImage = new ViewImage();
viewImage.ImageName = imagePath;
viewImage.ShowDialog();
e.Cancel = true;
//LocalReport lr = (LocalReport)e.Report;
//lr.DataSources.Clear();
//lr.DataSources.Add(new ReportDataSource(reportDatasourceName, dataSource));
}
protected void RpViewerDrillthrough(object sender, DrillthroughEventArgs e)
{
try
{
if (e.Report is ServerReport)
{
return;
}
LocalReport localreport = (LocalReport)e.Report;
RDLReportDocument drillReport = new RDLReportDocument();
drillReport.SetFields(User.Identity.GetUserId <int>().ToString(), _reportDocument.Name, _reportDocument.ReportPathWithOutName);
drillReport.Load(string.Format(@"{0}\{1}.{2}", _reportDocument.ReportPathWithOutName, e.ReportPath, "rdl"));
drillReport.LoadSourceDataSet(localreport.OriginalParametersToDrillthrough);
localreport.DataSources.Clear();
localreport.LoadReportDefinition(drillReport.GetCustomTextReader(drillReport.ReportPath));
localreport.DisplayName = drillReport.Name;
SetDataSource(drillReport.DsSource, localreport);
ReportParameter[] Parameters = new ReportParameter[drillReport.Parameters.Count];
int i = 0;
foreach (RDLParameter rpParam in drillReport.Parameters)
{
Parameters[i] = new ReportParameter();
Parameters[i].Name = rpParam.Name;
Parameters[i].Values.Add(rpParam.Value.ToString());
i++;
}
localreport.Refresh();
}
catch (Exception ex)
{
throw (ex);
}
}
void rptViewer_Drillthrough1(object sender, DrillthroughEventArgs e)
{
try
{
ReportParameterInfoCollection drillThroughValues = e.Report.GetParameters();
DispatchOrderId = Convert.ToInt32(drillThroughValues[0].Values[0]);
var dtDetails = _dispatchOrderService.GetDispatchOrderDetailByDispatchOrderId(DispatchOrderId);
LocalReport localreport = (LocalReport)e.Report;
localreport.EnableHyperlinks = true;
ReportDataSource rds = new ReportDataSource("DispatchOrderDetail", dtDetails);
// ReportDataSource rds1 = new ReportDataSource("dsCashCard", dt);
localreport.DataSources.Clear();
localreport.DataSources.Add(rds);
localreport.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void DrillthroughEventHandler(object sender, DrillthroughEventArgs e)
{
Guid hubid = Guid.Empty;
var report = e.Report;
using (var c = ObjectFactory.Container.GetNestedContainer())
{
hubid = c.GetInstance<IConfigService>().Load().CostCentreId;
}
ReportParameter hubidparam = new ReportParameter("hubId", hubid.ToString(), false);
// ReportParameter hubidparam = new ReportParameter("hubId", "E6834108-4BA7-4A1A-98CA-9DD4DF8D68E2", false);
try
{
report.SetParameters(new ReportParameter[] { hubidparam });
}
catch (Exception ex)
{
}
report.Refresh();
}
protected void rvVenta_Drillthrough(object sender, DrillthroughEventArgs e)
{
Ventas loVentas = new Ventas();
try
{
#region Mostrar detalles
string lsClaveCliente = ((LocalReport)e.Report).OriginalParametersToDrillthrough[0].Values[0];
string lsCliente = ((LocalReport)e.Report).OriginalParametersToDrillthrough[1].Values[0];
string lsComodines = RetornaCadComodines();
Reglas.Comun loComun = new Reglas.Comun();
if (e.ReportPath == Comun.Definiciones.TipoSubreporte.DiasConPedidosDetalle.Descripcion())
{
((LocalReport)e.Report).ReportPath = "Informes/Ventas/" + e.ReportPath + ".rdl";
((LocalReport)e.Report).ReportEmbeddedResource = "Informes/Ventas/" + e.ReportPath + ".rdl";
((LocalReport)e.Report).DisplayName = "Analisis_dias_con_Pedidos_Cte-" + lsClaveCliente + "_" + ddlSucursales.SelectedItem.Text.Split('(')[1].Split(')')[0];
((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsImportePedidoDias", loVentas.ObtenerVentasPorDiasDetalle((Sesion)Session["Sesion"], lsClaveCliente, int.Parse(ddlSucursales.SelectedValue), DateTime.Parse(txtFechaInicio.Text), DateTime.Parse(txtFechaFin.Text), int.Parse(ddlVendedores.SelectedValue), lsComodines)));
((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsEncabezado", loComun.ObtenerEncabezado(
"Sucursal: " + ddlSucursales.SelectedItem.Text +
", Cliente: " + lsCliente +
((int.Parse(ddlVendedores.SelectedValue) == 0) ? string.Empty : ", Vendedor: " + ddlVendedores.SelectedItem.Text + " "),
(txtFechaInicio.Text) + " - " + txtFechaFin.Text)
));
//((LocalReport)e.Report).SetParameters(parametros);
((LocalReport)e.Report).Refresh();
}
else if (e.ReportPath == Comun.Definiciones.TipoSubreporte.FolioPedidosDias.Descripcion())
{
string ldFecha = ((LocalReport)e.Report).OriginalParametersToDrillthrough[2].Values[0];
((LocalReport)e.Report).ReportPath = "Informes/Ventas/" + e.ReportPath + ".rdl";
((LocalReport)e.Report).ReportEmbeddedResource = "Informes/Ventas/" + e.ReportPath + ".rdl";
((LocalReport)e.Report).DisplayName = "Analisis_Folio_Pedidos_Cte-" + lsClaveCliente + "_" + ddlSucursales.SelectedItem.Text.Split('(')[1].Split(')')[0];
((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsImportePedidoDias", loVentas.ObtenerFolioPedidosDias((Sesion)Session["Sesion"], lsClaveCliente, int.Parse(ddlSucursales.SelectedValue), DateTime.Parse(ldFecha), int.Parse(ddlVendedores.SelectedValue), lsComodines)));
((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsEncabezado", loComun.ObtenerEncabezado(
"Sucursal: " + ddlSucursales.SelectedItem.Text +
", Cliente: " + lsCliente +
((int.Parse(ddlVendedores.SelectedValue) == 0) ? string.Empty : ", Vendedor: " + ddlVendedores.SelectedItem.Text + " "),
DateTime.Parse(ldFecha).ToString("dd/MM/yyyy"))
));
((LocalReport)e.Report).Refresh();
}
else if (e.ReportPath == Comun.Definiciones.TipoSubreporte.ArticulosPedidosDias.Descripcion())
{
string lsFolio = ((LocalReport)e.Report).OriginalParametersToDrillthrough[2].Values[0];
int lnNumero = int.Parse(((LocalReport)e.Report).OriginalParametersToDrillthrough[3].Values[0]);
string ldFecha = ((LocalReport)e.Report).OriginalParametersToDrillthrough[4].Values[0];
((LocalReport)e.Report).ReportPath = "Informes/Ventas/" + e.ReportPath + ".rdl";
((LocalReport)e.Report).ReportEmbeddedResource = "Informes/Ventas/" + e.ReportPath + ".rdl";
((LocalReport)e.Report).DisplayName = "Analisis_Articulos_Pedidos_Cte-" + lsClaveCliente + "_" + ddlSucursales.SelectedItem.Text.Split('(')[1].Split(')')[0];
((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsImportePedidoDias", loVentas.ObtenerArticulosPedidosDias((Sesion)Session["Sesion"], lsClaveCliente, int.Parse(ddlSucursales.SelectedValue), DateTime.Parse(ldFecha), lsFolio, lnNumero, int.Parse(ddlVendedores.SelectedValue), lsComodines)));
((LocalReport)e.Report).DataSources.Add(new ReportDataSource("dsEncabezado", loComun.ObtenerEncabezado(
"Sucursal: " + ddlSucursales.SelectedItem.Text +
", Cliente: " + lsCliente +
((int.Parse(ddlVendedores.SelectedValue) == 0) ? string.Empty : ", Vendedor: " + ddlVendedores.SelectedItem.Text + " "),
DateTime.Parse(ldFecha).ToString("dd/MM/yyyy"))
));
((LocalReport)e.Report).Refresh();
}
#endregion
}
catch (Exception ex)
{
Session["Excepcion"] = ex;
Response.Redirect("~/Error.aspx", false);
}
}
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
this.div_1.Attributes.Add("style", "display:none");
}
/// <summary>
///
/// </summary>
/// <param name="currentDrillthroughEventArgs"></param>
private void OnReportDrilledThrough(DrillthroughEventArgs currentDrillthroughEventArgs)
{
if (ReportDrilledThrough != null)
{
ReportDrilledThrough(this, currentDrillthroughEventArgs);
}
}
/// <summary>
/// Handles drilldown report events
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
_localReport = (LocalReport)e.Report;
OnReportDrilledThrough(e);
byte[] rdlBytes = Encoding.UTF8.GetBytes(_reportInfo.ReportDefinition);
System.IO.MemoryStream stream = new System.IO.MemoryStream(rdlBytes);
_localReport.LoadReportDefinition(stream);
RunReport();
if (!_bDisplayedError)
_localReport.Refresh();
}
/// <summary>
/// 钻取报表事件
/// </summary>
private void ReportOnDrillthrough(object sender, DrillthroughEventArgs eventArgs)
{
base.RaiseEvent(new RoutedEventArgs(_DrillthroughEvent, this));
}
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
LocalReport localReport = (LocalReport)e.Report;
Console.WriteLine(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString());
DataTable dt = DBAdo.DtFillSql(string.Format("SELECT EXCHANGEDATE 日期,c.cname 客户,TYPE 类型,cash 现汇,note 票据,mz 抹账, cash+note+mz 小计 FROM ACASH a,aclients c where 1=1 AND HDW ='{0}' and c.ccode =a.ccode ORDER BY EXCHANGEDATE", ClassCustom.codeSub(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString())));
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_DataTable2", dt));
//ReportParameter rp1 = new ReportParameter("HDW", dt.Rows[0]["客户名"].ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
// MessageBox.Show(ex.Message);
return;
}
}
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
var localReport = (LocalReport)e.Report;
localReport.DataSources.Add(_reportViewer1.LocalReport.DataSources["DataSet1"]);
}
protected void rpViewer_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
// Handle local drillthrough only
if (e.Report is ServerReport) return;
LocalReport localreport = (LocalReport)e.Report;
RDLReportDocument drillReport = new RDLReportDocument(e.ReportPath);
drillReport.ReportPathWithOutName = Report.ReportPathWithOutName;
drillReport.Load(String.Format(@"{0}\{1}.{2}", Report.ReportPathWithOutName, e.ReportPath, "rdl"));
drillReport.LoadSourceDataSet(localreport.OriginalParametersToDrillthrough);
localreport.DataSources.Clear();
localreport.LoadReportDefinition(drillReport.GetCustomTextReader(drillReport.ReportPath));
localreport.DisplayName = drillReport.Name;
SetDataSource(drillReport.dsSource, localreport);
ReportParameter[] Parameters = new ReportParameter[drillReport.Parameters.Count];
int i = 0;
foreach (RDLParameter rpParam in drillReport.Parameters)
{
Parameters[i] = new ReportParameter();
Parameters[i].Name = rpParam.Name;
Parameters[i].Values.Add(rpParam.Value.ToString());
i++;
}
localreport.Refresh();
}
catch (Exception ex)
{
this.ErrorMessage = (ExceptionHelper.getExceptionMessage(ex));
}
}
/*
* protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
* {
* try
* {
* ServerReport sr = (ServerReport)e.Report;
* this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
* if (sr.ReportPath.Contains("DashboardDetails") == true)
* {
*
* }
* }
* catch (Exception ex)
* {
* bizLog.InsertExceptionLog(ex);
* Response.Redirect("~/ErrorPage.aspx", false);
* }
* }
* */
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
SearchOptions so = this.ucSearchOptions1.GetSearchOptions();
if (so == null)
{
this.pnlResults_CollapsiblePanelExtender.ClientState = "true";
this.pnlResults_CollapsiblePanelExtender.Collapsed = true;
return;
}
this.ReportViewer1.Reset();
this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
string ssrsURL = ConfigurationSettings.AppSettings["SSRS_URL"];
if (string.IsNullOrEmpty(ssrsURL))
{
throw new Exception("Error: Please set the SSRS_URL in the AppSetting in web.config");
}
this.ReportViewer1.ServerReport.ReportServerUrl = new Uri(ssrsURL);
this.ReportViewer1.ServerReport.ReportPath = "/enGage/DashboardDetails";
using (Timeline.Capture("ServerReport.Refresh()", "Reports"))
{
this.ReportViewer1.ServerReport.Refresh();
}
this.ReportViewer1.Height = Unit.Point(480);
this.ReportViewer1.Visible = true;
ReportParameter p11 = new ReportParameter("parDateFrom", so.DateFrom.ToString("dd MMM yyyy"));
ReportParameter p12 = new ReportParameter("parDateTo", so.DateTo.ToString("dd MMM yyyy"));
//ReportParameter p13 = new ReportParameter("parRegion", so.Region);
//ReportParameter p14 = new ReportParameter("parBranch", so.Branch);
ReportParameter p15 = new ReportParameter("parExecutive", so.Executive);
ReportParameter p16 = new ReportParameter("parClassification", so.Classification.ToString());
ReportParameter p17 = new ReportParameter("parBusinessType", so.BusinessType.ToString());
ReportParameter p18 = new ReportParameter("parIndustries", so.Industries == null ? "" : so.Industries);
ReportParameter p19 = new ReportParameter("parSources", so.Sources == null ? "" : so.Sources);
string ExecutiveName = this.ucSearchOptions1.GetExecutiveName(so.Executive);
string label = so.Executive != "(All)" ? ExecutiveName : so.Branch != "(All)" && so.Executive == "(All)" ? so.Region + " (" + so.Branch + ")" : so.Region != "(All)" && so.Branch == "(All)" ? so.Region : so.Region == "(All)" ? "OAMPS Insurance Brokers Ltd" : "";
ReportParameter p20 = new ReportParameter("parReportLabel", label);
//ReportParameter p21 = new ReportParameter("parOpportunities", so.Opportunities);
this.ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p11, p12, p15, p16, p17, p18, p19, p20 });
using (Timeline.Capture("ServerReport.Refresh()", "Reports"))
{
this.ReportViewer1.ServerReport.Refresh();
}
this.ReportViewer1.Height = Unit.Point(480);
this.ReportViewer1.Visible = true;
this.pnlResults_CollapsiblePanelExtender.ClientState = "false";
this.pnlResults_CollapsiblePanelExtender.Collapsed = false;
}
catch (Exception ex)
{
bizLog.InsertExceptionLog(ex);
Response.Redirect("~/ErrorPage.aspx", false);
}
}
protected void rvContent_Drillthrough(object sender, DrillthroughEventArgs e)
{
BindReport(e.ReportPath, e.Report as LocalReport);
BindExportButtons(e.Report as LocalReport);
}
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
}
protected void ReportViewer2_Drillthrough(object sender, DrillthroughEventArgs e)
{
Microsoft.Reporting.WebForms.ReportDataSource rdis = new Microsoft.Reporting.WebForms.ReportDataSource("dsDInventLog_sp_ReportDrugActivityLog");
//rds.Name = "table1";
int rdrugID=0, rfacID=0;
String rdrugName="", rclinName="", rdType="S";
String date1="", date2="";
LocalReport report = (LocalReport)e.Report;
//ReportViewer2.LocalReport.ReportPath = "Reports/RptSInventLog.rdlc";
IList<ReportParameter> list = report.OriginalParametersToDrillthrough;
int i = 0;
foreach (ReportParameter param in list) {
switch (i)
{
case 0:
rdrugID = Convert.ToInt32(param.Values[0].ToString());
break;
case 1:
rdrugName = param.Values[0].ToString();
break;
case 2:
rdType = param.Values[0].ToString();
break;
case 3:
rfacID = Convert.ToInt32(param.Values[0].ToString());
break;
case 4:
rclinName = param.Values[0].ToString();
break;
case 5:
date1 = param.Values[0].ToString();
break;
case 6:
date2 = param.Values[0].ToString();
break;
}
i++;
}
rdis.Value = GetInventData(rdrugID, rfacID, rdType, date1, date2);
ReportParameter DrugID = new ReportParameter("DrugID", rdrugID.ToString());
ReportParameter DType = new ReportParameter("DName", rdrugName);
ReportParameter DName = new ReportParameter("DType", rdType);
ReportParameter FacID = new ReportParameter("FacID", rfacID.ToString());
ReportParameter CName = new ReportParameter("CName", rclinName);
ReportParameter Date1 = new ReportParameter("FromDate", date1);
ReportParameter Date2 = new ReportParameter("ToDate", date2);
ReportParameter[] rp = new ReportParameter[] { DrugID, DType, FacID, Date1, Date2 };
report.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(rp);
//ReportViewer2.LocalReport.SetParameters(new ReportParameter("Date2", "8/8/2009"));
report.DataSources.Add(rdis);
//report.LocalReport.DataSources.Clear();
//report.LocalReport.DataSources.Add(rds);
//report.LocalReport.Refresh();
//ReportViewer2.DataBind();
}
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
LocalReport localReport = (LocalReport)e.Report;
//if (this.reportViewer1.LocalReport.ReportEmbeddedResource == "contract.Reports.Report合同收付款明细表.rdlc")
//{
// localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_AFKXX", DBAdo.DtFillSql("SELECT * FROM AFKXX")));
// localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP")));
//}
//localReport.OriginalParametersToDrillthrough
//Console.WriteLine(localReport.DisplayName);
//Console.WriteLine(int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()));
switch (this.reportViewer1.LocalReport.ReportEmbeddedResource)
{
case "contract.Reports.Report合同收付款明细表.rdlc":
if (int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()) == 0)
{
DataTable dt = DBAdo.DtFillSql(string.Format("SELECT * FROM Vcx1 WHERE 合同号 ='{0}'", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString()));
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP")));
if (dt.Rows.Count > 0)
{
ReportParameter rp1 = new ReportParameter("hkh", dt.Rows[0]["客户名"].ToString());
ReportParameter rp2 = new ReportParameter("qdrq", dt.Rows[0]["QDRQ"].ToString());
ReportParameter rp3 = new ReportParameter("jhrq", dt.Rows[0]["交货日期"].ToString());
ReportParameter rp4 = new ReportParameter("hlx", dt.Rows[0]["hlx"].ToString());
ReportParameter rp5 = new ReportParameter("sp", dt.Rows[0]["商品"].ToString());
ReportParameter rp6 = new ReportParameter("rmb", dt.Rows[0]["金额"].ToString());
ReportParameter rp7 = new ReportParameter("fp", dt.Rows[0]["发票"].ToString());
localReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7 });
DataTable _dtsp = DBAdo.DtFillSql(string.Format("SELECT HTH 合同号, YEAR(date) 年 ,month(date) 月,TYPE 类型, SUM(RMB) 金额 FROM AFKXX WHERE HTH ='{0}' GROUP BY HTH , YEAR(date) ,month(date) ,TYPE ", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString()));
for (int i = 0; i < 12; i++)
{
_dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1,
(dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"回款":"付款")
,0});
_dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1,
(dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"销项发票":"进项发票")
,0});
}
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_SP", _dtsp));
}
}
break;
case "contract.Reports.Report合同导航.rdlc":
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP")));
break;
case "contract.Reports.Report签订明细.rdlc":
if (int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()) == 0)
{
DataTable dt = DBAdo.DtFillSql(string.Format("SELECT * FROM Vcx1 WHERE 合同号 ='{0}'", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString()));
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP")));
if (dt.Rows.Count > 0)
{
ReportParameter rp1 = new ReportParameter("hkh", dt.Rows[0]["客户名"].ToString());
ReportParameter rp2 = new ReportParameter("qdrq", dt.Rows[0]["QDRQ"].ToString());
ReportParameter rp3 = new ReportParameter("jhrq", dt.Rows[0]["交货日期"].ToString());
ReportParameter rp4 = new ReportParameter("hlx", dt.Rows[0]["hlx"].ToString());
ReportParameter rp5 = new ReportParameter("sp", dt.Rows[0]["商品"].ToString());
ReportParameter rp6 = new ReportParameter("rmb", dt.Rows[0]["金额"].ToString());
ReportParameter rp7 = new ReportParameter("fp", dt.Rows[0]["发票"].ToString());
localReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7 });
DataTable _dtsp = DBAdo.DtFillSql(string.Format("SELECT HTH 合同号, YEAR(date) 年 ,month(date) 月,TYPE 类型, SUM(RMB) 金额 FROM AFKXX WHERE HTH ='{0}' GROUP BY HTH , YEAR(date) ,month(date) ,TYPE ", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString()));
for (int i = 0; i < 12; i++)
{
_dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1,
(dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"回款":"付款")
,0});
_dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1,
(dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"销项发票":"进项发票")
,0});
}
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_SP", _dtsp));
}
}
break;
case "contract.Reports.Report合同汇总.rdlc":
if (int.Parse(localReport.OriginalParametersToDrillthrough[0].Values[0].ToString()) == 0)
{
DataTable dt = DBAdo.DtFillSql(string.Format("SELECT * FROM Vcx1 WHERE 合同号 ='{0}'", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString()));
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_ASP", DBAdo.DtFillSql("SELECT * FROM ASP")));
if (dt.Rows.Count > 0)
{
ReportParameter rp1 = new ReportParameter("hkh", dt.Rows[0]["客户名"].ToString());
ReportParameter rp2 = new ReportParameter("qdrq", dt.Rows[0]["QDRQ"].ToString());
ReportParameter rp3 = new ReportParameter("jhrq", dt.Rows[0]["交货日期"].ToString());
ReportParameter rp4 = new ReportParameter("hlx", dt.Rows[0]["hlx"].ToString());
ReportParameter rp5 = new ReportParameter("sp", dt.Rows[0]["商品"].ToString());
ReportParameter rp6 = new ReportParameter("rmb", dt.Rows[0]["金额"].ToString());
ReportParameter rp7 = new ReportParameter("fp", dt.Rows[0]["发票"].ToString());
localReport.SetParameters(new ReportParameter[] { rp1, rp2, rp3, rp4, rp5, rp6, rp7 });
DataTable _dtsp = DBAdo.DtFillSql(string.Format("SELECT HTH 合同号, YEAR(date) 年 ,month(date) 月,TYPE 类型, SUM(RMB) 金额 FROM AFKXX WHERE HTH ='{0}' GROUP BY HTH , YEAR(date) ,month(date) ,TYPE ", localReport.OriginalParametersToDrillthrough[1].Values[0].ToString()));
for (int i = 0; i < 12; i++)
{
_dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1,
(dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"回款":"付款")
,0});
_dtsp.Rows.Add(new object[] { localReport.OriginalParametersToDrillthrough[1].Values[0].ToString() ,this.YEAR.Text,i+1,
(dt.Rows[0]["hlx"].ToString().Substring(0,2)=="02"?"销项发票":"进项发票")
,0});
}
localReport.DataSources.Add(new ReportDataSource("Contract1DataSet_SP", _dtsp));
}
}
break;
//Report合同汇总.rdlc
default:
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
// MessageBox.Show(ex.Message);
return;
}
}
/// <summary>
/// Event handler for when a report is drilled in to from the MS Viewer inside the ReportView control.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void wlbReportView1_ReportDrilledThrough(object sender, DrillthroughEventArgs e)
{
SynchTreeViewReportList(e.ReportPath.ToString());
}
void SalesDrillthroughEventHandler(object sender, DrillthroughEventArgs e)
{
var report = e.Report;
string distributorID = _vm.DistributorID.ToString();
//string distributorID = "167480A6-DC20-44B9-A1B6-0B523914B5CE";
var param = new ReportParameter();
param = new ReportParameter("distributorID", distributorID, false);
try
{
report.SetParameters(new ReportParameter[] { param });
}
catch (Exception ex)
{
}
report.Refresh();
}
protected void rvContent_Drillthrough(object sender, DrillthroughEventArgs e)
{
BindReport(e.ReportPath, e.Report as LocalReport);
BindExportButtons(e.Report as LocalReport);
}
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;
switch (e.ReportPath)
{
case "PacSunDeliveryCartonDetail": {
//Get drillthrough parameters
string _start = "", _end = "", _terminal = "", _store = "", _manifest = "";
for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++)
{
switch (report.OriginalParametersToDrillthrough[i].Name)
{
case "FromDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "ToDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "TerminalName": _terminal = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "StoreNumber": _store = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "ManifestNumber": _manifest = report.OriginalParametersToDrillthrough[i].Values[0]; break;
}
}
//Set data source and parameters
DataSet ds = (DataSet)Session["PacSunDS"];
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource("DetailDS", ds.Tables[mTBLName]));
ReportParameter start = new ReportParameter("FromDate", _start);
ReportParameter end = new ReportParameter("ToDate", _end);
ReportParameter terminal = new ReportParameter("TerminalName", _terminal);
ReportParameter store = new ReportParameter("StoreNumber", _store);
ReportParameter manifest = new ReportParameter("ManifestNumber", _manifest);
e.Report.SetParameters(new ReportParameter[] { start, end, terminal, store, manifest });
e.Report.Refresh();
}
break;
case "PacSunDeliveryOSDDetail": {
//Get drillthrough parameters
string _start = "", _end = "", _terminal = "", _store = "", _manifest = "";
for (int i = 0; i < report.OriginalParametersToDrillthrough.Count; i++)
{
switch (report.OriginalParametersToDrillthrough[i].Name)
{
case "FromDate": _start = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "ToDate": _end = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "TerminalName": _terminal = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "StoreNumber": _store = report.OriginalParametersToDrillthrough[i].Values[0]; break;
case "ManifestNumber": _manifest = report.OriginalParametersToDrillthrough[i].Values[0]; break;
}
}
//Set data source and parameters
DataSet ds = (DataSet)Session["PacSunDS"];
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource("DetailDS", ds.Tables[mTBLName]));
ReportParameter start = new ReportParameter("FromDate", _start);
ReportParameter end = new ReportParameter("ToDate", _end);
ReportParameter terminal = new ReportParameter("TerminalName", _terminal);
ReportParameter store = new ReportParameter("StoreNumber", _store);
ReportParameter manifest = new ReportParameter("ManifestNumber", _manifest);
e.Report.SetParameters(new ReportParameter[] { start, end, terminal, store, manifest });
e.Report.Refresh();
}
break;
}
}
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
LocalReport lp = (LocalReport)e.Report;
m_szTitle = lp.OriginalParametersToDrillthrough[0].Values[0].ToString();
if (m_szTitle == "个人日放映收入表")
{
lp.DataSources.Clear();
RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp);
flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter();
TableAdapter.FillPersonalDailyIncome(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users);
TableAdapter.ClearBeforeFill = true;
this.reportViewer1.RefreshReport();
}
else if (m_szTitle == "个人日售票成绩表")
{
lp.DataSources.Clear();
RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp);
flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter();
TableAdapter.FillPersonalDailySale(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users);
TableAdapter.ClearBeforeFill = true;
this.reportViewer1.RefreshReport();
}
else if (m_szTitle == "影院日放映收入表")
{
lp.DataSources.Clear();
RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp);
flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter();
TableAdapter.FillTheaterDailyIncome(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films);
TableAdapter.ClearBeforeFill = true;
this.reportViewer1.RefreshReport();
}
else if (m_szTitle == "影院日售票成绩表")
{
lp.DataSources.Clear();
RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.GroupClassTicketSale.rdlc", lp);
flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter();
TableAdapter.FillTheaterDailySale(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films);
TableAdapter.ClearBeforeFill = true;
this.reportViewer1.RefreshReport();
}
//if (lp.ReportEmbeddedResource == "PersonalDailyIncomeGroup.rdlc")
//{
// lp.DataSources.Clear();
// RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.PersonalDailyIncomeGroup.rdlc", lp);
// flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter();
// TableAdapter.FillPersonalDailyIncome(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users);
// TableAdapter.ClearBeforeFill = true;
// this.reportViewer1.RefreshReport();
//}
//else if (lp.ReportEmbeddedResource == "PersonalDailySalesGroup.rdlc")
//{
// lp.DataSources.Clear();
// RefleshReportViewer("dailydatagroup", "DailyDataGroup", "WinFormUI.Reporting.Reports.PersonalDailySalesGroup.rdlc", lp);
// flamingoDataSetTableAdapters.dailydatagroupTableAdapter TableAdapter = new flamingoDataSetTableAdapters.dailydatagroupTableAdapter();
// TableAdapter.FillPersonalDailySale(this.flamingoDataSet.dailydatagroup, startDate, endDate, halls, films, users);
// TableAdapter.ClearBeforeFill = true;
// this.reportViewer1.RefreshReport();
//}
}
protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
try
{
Rpt_PatientStatistics.Visible = true;
ReportParameterInfoCollection DrillThroughValues =
e.Report.GetParameters();
string[] Params = new string[2];
int i = 0;
foreach (ReportParameterInfo d in DrillThroughValues)
{
Params[i] = d.Values[0].ToString().Trim();
i += 1;
}
//ReportViewer reportviewer = new ReportViewer();
//reportviewer.ProcessingMode = ProcessingMode.Local;
//// Add a handler for drillthrough.
//reportviewer.Back += new
// BackEventHandler(BackEventHandlerFunc);
//reportviewer.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_TotalPaitentCount.rdlc");
// btnImgprint.Visible = true;
//reportviewer.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("~/RDLCReports/Rpt_TotalPaitentCount.rdlc");
LocalReport localreport = (LocalReport)e.Report;
DateTime FromDate = DateTime.Parse(txtFromDate.Text.Trim(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
DateTime ToDate = DateTime.Parse(txtToDate.Text.Trim(), provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault).Date;
if (e.ReportPath.ToString() == "Rpt_AllAnimalTypeDtls")
{
Session["ATypeCd"] = "T";
DataTable dt = ObjIns.GetAtypeALL1BAL(Session["UniqueInstId"].ToString(), FromDate, ToDate, ConnKey);
ReportDataSource datasource = new ReportDataSource("Ds_PatientDtls", dt);
localreport.DataSources.Clear();
localreport.DataSources.Add(datasource);
localreport.Refresh();
}
else if (e.ReportPath.ToString() == "Rpt_AnimalTypeWiseDtls")
{
Session["AnimalTypeCode"] = Params[1];
Session["ATypeCd"] = "R";
Session["Status"] = Params[0];
DataTable dt = ObjIns.GetAtypeRptBAL(Session["UniqueInstId"].ToString(), Params[1], Params[0], FromDate, ToDate, ConnKey);
// DataTable dt = ObjIns.GetAtypeRptBAL(Session["UniqueInstId"].ToString(), lblParam.Text, FromDate, ToDate);
ReportDataSource datasource = new ReportDataSource("Ds_PatientDtls", dt);
localreport.DataSources.Clear();
localreport.DataSources.Add(datasource);
localreport.Refresh();
}
//DataTable dt = ObjIns.GetAtypeALLBAL(Session["UniqueInstId"].ToString(), FromDate, ToDate);
//Assign dataset to report datasource
}
catch (Exception ex)
{
Response.Redirect("~/Error.aspx");
}
}
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 "Delivery Window Summary By Client With Early": {
//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("uspRptDeliveryWindowSummaryByClientWithEarly", "NewTable", new object[] { null, _agent, _start, _end });
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource("DeliveryWindowSumByClientWithEarlyDS", ds.Tables["NewTable"]));
DataSet _ds = enterprise.FillDataset("uspRptAgentRead", "NewTable", 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 "Delivery Window Summary By Agent With Early": {
//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("uspRptDeliveryWindowSummaryByAgentWithEarly", "NewTable", new object[] { _client, null, null, null, null, null, null, _start, _end });
report.DataSources.Clear();
report.DataSources.Add(new ReportDataSource("DeliveryWindowSummaryByAgentWithEarlyDS", ds.Tables["NewTable"]));
DataSet _ds = enterprise.FillDataset("uspRptClientRead", "NewTable", new object[] { _client });
report.DataSources.Add(new ReportDataSource("DataSet1", _ds.Tables["NewTable"]));
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 rptvContainer_OnDrillthrough(object sender, DrillthroughEventArgs e)
{
}
/// <summary>
/// Event handler for when a report is drilled in to from the MS Viewer inside the ReportView control.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void wlbReportView1_ReportDrilledThrough(object sender, DrillthroughEventArgs e)
{
SynchTreeViewReportList(e.ReportPath.ToString());
}
void rptViewer_Drillthrough1(object sender, DrillthroughEventArgs e)
{
try
{
ReportParameterInfoCollection drillThroughValues = e.Report.GetParameters();
DispatchOrderId = Convert.ToInt32(drillThroughValues[0].Values[0]);
var dtDetails = _dispatchOrderService.GetDispatchOrderDetailByDispatchOrderId(DispatchOrderId);
LocalReport localreport = (LocalReport)e.Report;
localreport.EnableHyperlinks = true;
ReportDataSource rds = new ReportDataSource("DispatchOrderDetail", dtDetails);
// ReportDataSource rds1 = new ReportDataSource("dsCashCard", dt);
localreport.DataSources.Clear();
localreport.DataSources.Add(rds);
localreport.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
