protected void GerarRelatorio(object sender, EventArgs e)
{
try
{
//Obter o relatorio (caminho)
string Path = HttpContext.Current.Server.MapPath("/Reports/RelatorioVendas.rdlc");
//Resgatar as datas
DateTime dtIni = Convert.ToDateTime(txtDataInicio.Text);
DateTime dtFim = Convert.ToDateTime(txtDataTermino.Text);
using (VendaDal d = new VendaDal()) //inicializar
{
ReportDataSource dados = new ReportDataSource("DSRelatorio", d.ListarVendas(dtIni, dtFim));
//Mostrar o relatorio
ReportViewer.LocalReport.ReportPath = Path; //caminho do relatório
ReportViewer.LocalReport.DataSources.Add(dados); //passando os dados
ReportViewer.DataBind(); //Exibir
} //dispose (destruir)
}
catch (Exception ex)
{
lblMensagem.Text = ex.Message;
}
}
public static void LoadSQLReport(string ReportName, ReportViewer rv)
{
rv.ServerReport.ReportServerUrl = new Uri(System.Configuration.ConfigurationManager.AppSettings["SQLReportServer"]);
rv.ServerReport.ReportPath = "/" + System.Configuration.ConfigurationManager.AppSettings["SQLReportFolder"] + "/" + ReportName;
rv.DataBind();
}
protected void btnPesquisa_Click(object sender, EventArgs e)
{
try
{
//resgatar as datas dos campos..
string Nome = txtNomeF.Text;
//pesquisar os produtos no banco de dados...
Dal.Persistence.FuncionarioDal f = new Dal.Persistence.FuncionarioDal(); //classe de persistencia...
List <Dal.Entity.Funcionario> lista = new List <Dal.Entity.Funcionario>();
lista = f.FindAll(Nome);
//exibir o relatorio dentro do ReportViewer...
//Passo 1) Informar ao reportviewer o caminho do relatorio...
ReportViewer.LocalReport.ReportPath = HttpContext.Current.Server.
MapPath("/Reports/RelatorioFunc.rdlc");
//Passo 2) Preencher o relatorio com os dados (dataset)
ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSetFunc", lista));
//exibir o relatório...
ReportViewer.DataBind();
}
catch (Exception ex)
{
//imprimir mensagem de erro...
lblMensagem.Text = ex.Message;
}
}
protected void btnVerFactura_Click(object sender, EventArgs e)
{
ReportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer.LocalReport.ReportPath = Server.MapPath("FacturaVenta.rdlc");
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("Encabezado", MV.spEncabezado(Convert.ToInt32(Request.QueryString["Ve"].ToString()))));
ReportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("Cuerpo", MV.spCuerpo(Convert.ToInt32(Request.QueryString["Ve"].ToString()))));
ReportViewer.DataBind();
}
protected void btnBuscarReporte_Click(object sender, EventArgs e)
{
if (!inicio.Text.Equals("") && !fin.Text.Equals(""))
{
ReportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
ReportViewer.LocalReport.ReportPath = Server.MapPath("VentasPorFechas.rdlc");
ReportViewer.LocalReport.DataSources.Clear();
string[] f1 = inicio.Text.Split('/');
string[] f2 = fin.Text.Split('/');
ReportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("Reporte",
MV.spReporteVenta(DateTime.Parse(f1[1] + "/" + f1[0] + "/" + f1[2]), DateTime.Parse(f2[1] + "/" + f2[0] + "/" + f2[2]))));
ReportViewer.DataBind();
}
}
protected void btnDisplay_Click(object sender, EventArgs e)
{
if (Utils.LoggedUser == null)
{
Response.Redirect("~/login");
}
if (Utils.CheckPermission(5, 15, Utils.LoggedUser.Roles) < 1)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "lmis.notification.error('" + GetGlobalResourceObject("MessagesResource", "X_NotAuthorized") + @"');", true);
return;
}
var mr = Mgr.ListRequestLog().Where(w =>
(w.PortalUserName == ddlUsesr.SelectedValue || ddlUsesr.SelectedValue == "All") &&
(w.RequestType.desc == ddlRequestType.SelectedValue || ddlRequestType.SelectedValue == "All") &&
(ddlStatus.SelectedValue == "Pending" ? w.Approval == Approval.Pending : w.Approval == w.Approval) &&
(ddlStatus.SelectedValue == "Approved" ? w.Approval == Approval.Approved : w.Approval == w.Approval) &&
(ddlStatus.SelectedValue == "Rejected" ? w.Approval == Approval.Rejected : w.Approval == w.Approval) &&
(ddlTransactionType.SelectedValue == "New" ? w.DeleteDate == null && w.UpdateDate == null : w.PostDate == w.PostDate) &&
(ddlTransactionType.SelectedValue == "Updated" ? w.UpdateDate != null && w.DeleteDate == null : w.UpdateDate == w.UpdateDate) &&
(ddlTransactionType.SelectedValue == "Deleted" ? w.DeleteDate != null : w.DeleteDate == w.DeleteDate) &&
(
((string.IsNullOrEmpty(txtFrom.Text) ? w.PostDate == w.PostDate : w.PostDate.Date >= DateTime.Parse(txtFrom.Text).Date) &&
(string.IsNullOrEmpty(txtTo.Text) ? w.PostDate == w.PostDate : w.PostDate.Date <= DateTime.Parse(txtTo.Text).Date)) ||
((string.IsNullOrEmpty(txtFrom.Text) ? w.UpdateDate == w.UpdateDate : w.UpdateDate.HasValue && w.UpdateDate.Value.Date >= DateTime.Parse(txtFrom.Text).Date) &&
(string.IsNullOrEmpty(txtTo.Text) ? w.UpdateDate == w.UpdateDate : w.UpdateDate.HasValue && w.UpdateDate.Value.Date <= DateTime.Parse(txtTo.Text).Date)) ||
((string.IsNullOrEmpty(txtFrom.Text) ? w.DeleteDate == w.DeleteDate : w.DeleteDate.HasValue && w.DeleteDate.Value.Date >= DateTime.Parse(txtFrom.Text).Date) &&
(string.IsNullOrEmpty(txtTo.Text) ? w.DeleteDate == w.DeleteDate : w.DeleteDate.HasValue && w.DeleteDate.Value.Date <= DateTime.Parse(txtTo.Text).Date))
)
).Select(s => new { PortalUserName = s.PortalUserName, Date = s.PostDate, RequestTypeDesc = s.RequestType.desc, Status = (s.Approval == Approval.Approved ? "Approved" : (s.Approval == Approval.Pending ? "Pending" : "Rejected")), TransactionType = (s.DeleteDate != null ? "Deleted" : (s.UpdateDate != null ? "Updated" : "New")) });
ReportViewer.LocalReport.ReportPath = "BackEnd\\rdlc\\TransactionHistory.rdlc";
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", mr));
ReportViewer.DataBind();
ReportViewer.LocalReport.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
ClienteEnderecoDAL d = new ClienteEnderecoDAL();
List <ClienteEnderecoDTO> lista = d.FindAll();
ReportDataSource ds = new ReportDataSource("DataSetClientes", lista);
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("/Report/ReportClientes.rdlc");
ReportViewer.LocalReport.DataSources.Add(ds);
ReportViewer.DataBind();
}
catch (Exception ex)
{
lblMensagem.Text = "Erro ao gerar relatório de clientes. \n" + ex.Message;
}
}
}
public void RunReport(string sRDL)
{
try
{
RdlDocument rdl = new RdlDocument();
rdl.LoadRdl(sRDL);
DbProviderFactory dbf = DbProviderFactories.GetFactory();
using (IDbConnection con = dbf.CreateConnection())
{
using (IDbCommand cmd = con.CreateCommand())
{
rdl.BuildCommand(cmd);
sReportSQL = Sql.ExpandParameters(cmd);
using (DbDataAdapter da = dbf.CreateDataAdapter())
{
((IDbDataAdapter)da).SelectCommand = cmd;
dtReport = new DataTable();
{
da.Fill(dtReport);
// 07/12/2006 Paul. Every date cell needs to be localized.
foreach (DataRow row in dtReport.Rows)
{
foreach (DataColumn col in dtReport.Columns)
{
if (col.DataType == typeof(System.DateTime))
{
// 07/13/2006 Paul. Don't try and translate a NULL.
if (row[col.Ordinal] != DBNull.Value)
{
row[col.Ordinal] = T10n.FromServerTime(row[col.Ordinal]);
}
}
}
}
/*
* http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=444154&SiteID=1
* Brian Hartman - MSFT 06 Jun 2006, 10:22 PM UTC
* LocalReport has a limitation that the report definition can't be changed once the report has been processed.
* In winforms, you can use the ReportViewer.Reset() method to force the viewer to create a new instance of
* LocalReport and workaround this issue. But this method is currently not on the webforms version of report viewer.
* We hope to add it in an upcoming service pack, but for now,
* you must workaround this issue by creating a new instance of the ReportViewer.
*/
/*
* // 07/09/2006 Paul. Creating a new viewer solves the reset problem, but breaks ReportViewer pagination.
* rdlViewer = new ReportViewer();
* rdlViewer.ID = "rdlViewer";
* rdlViewer.Font.Names = new string[] { "Verdana" };
* rdlViewer.Font.Size = new FontUnit("8pt");
* rdlViewer.Height = new Unit("100%");
* rdlViewer.Width = new Unit("100%");
* rdlViewer.AsyncRendering = false;
* rdlViewer.SizeToReportContent = true;
* divReportView.Controls.Clear();
* divReportView.Controls.Add(rdlViewer);
*/
// 06/21/2006 Paul. The DataSource Name must match the value in the report.
string sDataSetName = rdl.SelectNodeValue("Body/ReportItems/Table/DataSetName");
ReportDataSource rds = new ReportDataSource(sDataSetName, dtReport);
rdlViewer.ProcessingMode = ProcessingMode.Local;
// 06/25/2006 Paul. The data sources need to be cleared, otherwise the report will not refresh.
rdlViewer.LocalReport.DataSources.Clear();
rdlViewer.LocalReport.DataSources.Add(rds);
rdlViewer.LocalReport.DisplayName = rdl.SelectNodeAttribute(String.Empty, "Name");
// 07/13/2006 Paul. The ReportViewer is having a problem interpreting the date functions.
// To solve the problem, we should go through all the parameters and replace the date functions with values.
rdl.ReportViewerFixups();
StringReader sr = new StringReader(rdl.OuterXml);
rdlViewer.LocalReport.LoadReportDefinition(sr);
// 06/25/2006 Paul. Refresh did not work, clear the data sources instead.
//rdlViewer.LocalReport.Refresh();
rdlViewer.DataBind();
}
}
}
}
}
catch (Exception ex)
{
lblError.Text = Utils.ExpandException(ex);
}
}
