public TermoEquipamento GetTermo(int cod)
{
string query = "select t.Rg RG, t.DataRetirada Retirada, e.Descricao Descricao, e.Patrimonio Patrimonio, e.NumSerie SN, t.DataDevolucao Devolucao " +
"from TERMO_DE_EMPRESTIMO t inner join EQUIPAMENTO e " +
"on t.CodEquipamento = e.CodEquipamento where t.CodTermo = @codTermo";
try
{
SqlDataReader reader = db.CallExecuteReader(query, new SqlParameter("@codTermo", cod));
reader.Read();
TermoEquipamento t = new TermoEquipamento();
t.DtpRetirada = DateTime.Parse(reader["Retirada"].ToString());
t.Rg = reader["Rg"].ToString();;
t.DtpDevolucao = DateTime.Parse(reader["Devolucao"].ToString());
t.Descricao = reader["Descricao"].ToString();
t.Patrimonio = reader["Patrimonio"].ToString();
t.NSerie = reader["SN"].ToString();
reader.Close();
return(t);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void opRelatorio_Termo_Click(object sender, EventArgs e)
{
CTRL_Termo_Emprestimo cTermo = new CTRL_Termo_Emprestimo();
TermoEquipamento t = cTermo.GetTermo(int.Parse(dgvTermo[0, dgvTermo.CurrentRow.Index].Value.ToString()));
using (var frm = new frmRelatorio(t))
frm.ShowDialog();
}
public frmRelatorio(TermoEquipamento t)
{
InitializeComponent();
this.rptReport.LocalReport.ReportPath = @"C:\Users\monitor\Desktop\Emanos\prjEstoque\prjEstoque\prjEstoque\Report\rptTermo.rdlc";
this.rptReport.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter("txtRg", t.Rg));
this.rptReport.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter("txtDataRetirada", t.DtpRetirada.ToString()));
this.rptReport.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter("txtDescricao", t.Descricao));
this.rptReport.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter("txtPatrimonio", t.Patrimonio));
this.rptReport.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter("txtNSerie", t.NSerie));
this.rptReport.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter("txtDataDevolucao", t.DtpDevolucao.ToString()));
}
