public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RelNotaFiscais rpt = new RelNotaFiscais();
rpt.Site = this.Site;
return(rpt);
}
private void BtnImprimir_Click(object sender, EventArgs e)
{
BtnImprimir.Enabled = false;
if (Op01.Checked)
{
string sSql = "SELECT T2.RazaoSocial, T1.DtEmissao, T1.NumNota, T1.NumFormulario, T1.VlrNota, T1.BIcms, T1.VlrIcms, T1.BIcmsSub, T1.VlrIcmsSub, T1.VlrIpi, T1.VlrFrete, " +
" T1.VlrSeguro, T1.VlrOutraDesp, T3.CFOP, T3.Descricao,T4.FANTASIA AS Filial" +
" FROM NotaFiscal AS T1 " +
" LEFT OUTER JOIN Pessoas AS T2 ON T2.Id_Pessoa = T1.Id_Pessoa " +
" LEFT OUTER JOIN CFOP AS T3 ON T3.Id_CFOP = T1.Id_Cfop" +
" LEFT OUTER JOIN Empresa_Filial AS T4 ON T4.Id_Filial = T1.Id_Filial" +
" WHERE T1.DtEmissao >= Convert(DateTime,'" + Dt1.Value.Date.ToString() + "',103) AND T1.DtEmissao <= Convert(DateTime,'" + Dt2.Value.Date.ToString() + "',103)";
if (Rb_Emitida.Checked)
{
sSql = sSql + " AND T1.Status = 1 ";
}
if (Rb_Cancelada.Checked)
{
sSql = sSql + " AND T1.Status = 2 ";
}
if (Rb_Form.Checked)
{
sSql = sSql + " AND T1.NFE = 0 ";
}
else
{
sSql = sSql + " AND T1.NFE = 1 ";
}
if (LstFilial.SelectedValue.ToString() != "0")
{
sSql = sSql + " AND T1.Id_Filial=" + LstFilial.SelectedValue.ToString();
}
sSql = sSql + " ORDER BY T1.ID_FILIAL,T1.DTEMISSAO,T1.NumFormulario";
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelNotaFiscais Rel001 = new Relatorios.RelNotaFiscais();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSql);
Rel001.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = Rel001;
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section2.ReportObjects["LblFilial"])).Text = FrmPrincipal.LstFilial.Text.Trim();
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section2.ReportObjects["LblPeriodo"])).Text = "Período:" + Dt1.Value.ToShortDateString() + " a " + Dt2.Value.ToShortDateString();
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section5.ReportObjects["LblRodaPe"])).Text = FrmPrincipal.Rel_RodaPe;
FrmRel.ShowDialog();
Rel001.Dispose();
}
if (Op02.Checked) // Cupom Fiscal
{
string sSql = "SELECT CASE T1.STATUS WHEN 2 THEN 'CANCELADO' ELSE ' ' END AS STATUS,T1.DATA,T1.NUM_CF,T1.VLRSUBTOTAL,T1.VLRDESCONTO,T1.VLRTOTAL,T2.NUMDOCUMENTO,T2.PESSOA FROM CUPOMFISCAL T1" +
" LEFT JOIN MVVENDA T2 ON (T2.ID_VENDA=T1.ID_VENDA)" +
" WHERE T1.Data >= Convert(DateTime,'" + Dt1.Value.Date.ToString() + "',103) AND T1.Data <= Convert(DateTime,'" + Dt2.Value.Date.ToString() + "',103) ORDER BY T1.DATA";
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelCupomFiscais Rel001 = new Relatorios.RelCupomFiscais();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSql);
Rel001.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = Rel001;
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section2.ReportObjects["LblPeriodo"])).Text = "Período:" + Dt1.Value.ToShortDateString() + " a " + Dt2.Value.ToShortDateString();
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section5.ReportObjects["LblRodaPe"])).Text = FrmPrincipal.Rel_RodaPe;
FrmRel.ShowDialog();
Rel001.Dispose();
}
if (Op03.Checked)
{
if (int.Parse(TxtCodCliente.Text) == 0)
{
MessageBox.Show("Favor selecionar um clinete", "Alerta", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
string sSql = "SELECT T2.Cnpj+' '+T2.RazaoSocial as RazaoSocial,T1.DtEmissao, T1.NumNota, T1.NumFormulario, T1.VlrNota, T1.BIcms, T1.VlrIcms, T1.BIcmsSub, T1.VlrIcmsSub, T1.VlrIpi, T1.VlrFrete, " +
" T1.VlrSeguro, T1.VlrOutraDesp, T3.CFOP, T3.Descricao,T4.FANTASIA AS Filial" +
" FROM NotaFiscal AS T1 " +
" LEFT OUTER JOIN Pessoas AS T2 ON T2.Id_Pessoa = T1.Id_Pessoa " +
" LEFT OUTER JOIN CFOP AS T3 ON T3.Id_CFOP = T1.Id_Cfop" +
" LEFT OUTER JOIN Empresa_Filial AS T4 ON T4.Id_Filial = T1.Id_Filial" +
" WHERE T1.Status = 1 and T1.DtEmissao >= Convert(DateTime,'" + Dt1.Value.Date.ToString() + "',103) AND T1.DtEmissao <= Convert(DateTime,'" + Dt2.Value.Date.ToString() + "',103)";
sSql = sSql + " AND T1.Id_Pessoa=" + TxtCodCliente.Text;
sSql = sSql + " ORDER BY T1.ID_FILIAL,T2.RazaoSocial,T1.DTEMISSAO,T1.NumFormulario";
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelNotaFiscais Rel001 = new Relatorios.RelNotaFiscais();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSql);
Rel001.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = Rel001;
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section2.ReportObjects["LblFilial"])).Text = FrmPrincipal.LstFilial.Text.Trim();
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section2.ReportObjects["LblPeriodo"])).Text = "Período:" + Dt1.Value.ToShortDateString() + " a " + Dt2.Value.ToShortDateString();
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section5.ReportObjects["LblRodaPe"])).Text = FrmPrincipal.Rel_RodaPe;
FrmRel.ShowDialog();
Rel001.Dispose();
}
if (Op04.Checked) // Vendas com pendencia de Cupom Fiscal ou Nota
{
string sSql = "select t2.Data,t2.Pessoa,t2.NumDocumento,t3.Referencia,t3.Descricao,t1.Qtde,t1.VlrUnitario,t1.VlrTotal,t2.VlrDesconto+t2.Credito AS Desconto,t2.VlrTotal as TotalVenda from MvVendaItens t1" +
" left join MvVenda t2 on (t2.Id_Venda=t1.Id_Venda)" +
" left join Produtos t3 on (t3.Id_Produto=t1.Id_Produto)" +
" WHERE T2.Data >= Convert(DateTime,'" + Dt1.Value.Date.ToString() + "',103) AND T2.Data <= Convert(DateTime,'" + Dt2.Value.Date.ToString() + "',103) " +
" and t2.TpVenda='PV' and t2.ID_LancCF=0 AND t2.ImpNF=0" +
" order by t2.data,t2.NumDocumento";
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelVdSemCFNF Rel001 = new Relatorios.RelVdSemCFNF();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSql);
Rel001.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = Rel001;
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section2.ReportObjects["LblPeriodo"])).Text = "Período:" + Dt1.Value.ToShortDateString() + " a " + Dt2.Value.ToShortDateString();
((CrystalDecisions.CrystalReports.Engine.TextObject)(Rel001.Section5.ReportObjects["LblRodaPe"])).Text = FrmPrincipal.Rel_RodaPe;
FrmRel.ShowDialog();
Rel001.Dispose();
}
BtnImprimir.Enabled = true;
}