private void BtnImpRecibo_Click(object sender, EventArgs e)
{
string sSQL = "SELECT TOP 1 T1.ID_PESSOA,T7.Vencimento, T1.NumDocumento+' NFe: '+rtrim(T9.FormNF) as NumDocumento, T1.VlrTotal as VlrOriginal, T1.PESSOA AS RazaoSocial, RTRIM(T1.Endereco) + ',' + RTRIM(T1.Numero) " +
" + ' ' + RTRIM(T1.Complemento) AS ENDERECO, T1.Cep, T1.Bairro, T1.Cidade, T3.Sigla, T1.CNPJCPF as Cnpj," +
" T4.FormaPgto,T1.Fone,T8.Vendedor,' ' as Documento,T0.IMAGEM AS LOGO," +
" T6.Filial as NomeFilial, RTRIM(T6.Endereco) + ',' + RTRIM(T6.Numero) + ' ' + RTRIM(T6.Complemento) AS ENDFILIAL, T6.Cep AS CepFilial, T6.Bairro as BairroFilial,T6.Cidade as CidFilial,T6.Fone1 AS FoneFilial,T6.Cnpj as CnpjFilial,T6.Insc_UF as InscFilial" +
" FROM MvVenda AS T1 " +
" LEFT OUTER JOIN Pessoas AS T2 ON T2.Id_Pessoa = T1.Id_Pessoa " +
" LEFT OUTER JOIN Estados AS T3 ON T3.Id_Uf = T2.Id_Uf" +
" LEFT OUTER JOIN FormaPagamento AS T4 ON T4.Id_FormaPgto = T1.Id_FormaPgto" +
" LEFT OUTER JOIN Empresa_Filial as T6 on T6.Id_Filial=t1.Id_Filial" +
" LEFT OUTER JOIN LancFinanceiro as T7 on T7.Id_Venda=T1.Id_Venda" +
" LEFT OUTER JOIN Vendedores as T8 on T8.Id_Vendedor=T1.Id_Vendedor" +
" LEFT OUTER JOIN MVVENDA AS T9 ON (T9.ID_VENDA=T1.ID_VENDA)" +
" LEFT OUTER JOIN TABIMAGENS AS T0 ON (T0.ID_CHAVE=T6.ID_FILIAL AND T0.TABELA='FILIAL')" +
" WHERE T1.ID_VENDA=" + NumPedido.Value.ToString();
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelRecibo RelRec = new Relatorios.RelRecibo();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSQL);
RelRec.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = RelRec;
FrmRel.ShowDialog();
}
private void BtnImprimir_Click(object sender, EventArgs e)
{
if (TxtIdVenda.Value > 0)
{
Vendas.LerDados(int.Parse(TxtIdVenda.Value.ToString()));
if (Vendas.IdVenda == 0)
{
MessageBox.Show("Venda não localizada", "Informação", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
string sSQL = "";
if (!ImpBoleto && Rb_Sim.Checked)
{
sSQL = "SELECT TOP 1 T1.ID_PESSOA,T7.Vencimento, T1.NumDocumento+' NFe: '+rtrim(T9.FormNF) as NumDocumento, T1.VlrTotal as VlrOriginal, T1.PESSOA AS RazaoSocial, RTRIM(T1.Endereco) + ',' + RTRIM(T1.Numero) " +
" + ' ' + RTRIM(T1.Complemento) AS ENDERECO, T1.Cep, T1.Bairro, T1.Cidade, T3.Sigla, T1.CNPJCPF as Cnpj," +
" T4.FormaPgto,T1.Fone,T8.Vendedor,' ' as Documento,T0.IMAGEM AS LOGO," +
" T6.Filial as NomeFilial, RTRIM(T6.Endereco) + ',' + RTRIM(T6.Numero) + ' ' + RTRIM(T6.Complemento) AS ENDFILIAL, T6.Cep AS CepFilial, T6.Bairro as BairroFilial,T6.Cidade as CidFilial,T6.Fone1 AS FoneFilial,T6.Cnpj as CnpjFilial,T6.Insc_UF as InscFilial" +
" FROM MvVenda AS T1 " +
" LEFT OUTER JOIN Pessoas AS T2 ON T2.Id_Pessoa = T1.Id_Pessoa " +
" LEFT OUTER JOIN Estados AS T3 ON T3.Id_Uf = T2.Id_Uf" +
" LEFT OUTER JOIN FormaPagamento AS T4 ON T4.Id_FormaPgto = T1.Id_FormaPgto" +
" LEFT OUTER JOIN Empresa_Filial as T6 on T6.Id_Filial=t1.Id_Filial" +
" LEFT OUTER JOIN LancFinanceiro as T7 on T7.Id_Venda=T1.Id_Venda" +
" LEFT OUTER JOIN Vendedores as T8 on T8.Id_Vendedor=T1.Id_Vendedor" +
" LEFT OUTER JOIN MVVENDA AS T9 ON (T9.ID_VENDA=T1.ID_VENDA)" +
" LEFT OUTER JOIN TABIMAGENS AS T0 ON (T0.ID_CHAVE=T6.ID_FILIAL AND T0.TABELA='FILIAL')" +
" WHERE T1.ID_VENDA=" + Vendas.IdVdMaster.ToString();
}
else
{
if (ImpProm)
{
sSQL = "SELECT T1.ID_PESSOA,T1.DataLanc, T1.Vencimento, T1.NumDocumento, T1.VlrOriginal, T2.RazaoSocial, RTRIM(T2.Endereco) + ',' + RTRIM(T2.Numero) ";
}
else
{
sSQL = "SELECT T1.ID_PESSOA,T1.DataLanc, T1.Vencimento, T1.NumDocumento+' NFe: '+rtrim(T9.FormNF) as NumDocumento, T1.VlrOriginal, T2.RazaoSocial, RTRIM(T2.Endereco) + ',' + RTRIM(T2.Numero) ";
}
sSQL = sSQL + " + ' ' + RTRIM(T2.Complemento) AS ENDERECO, T2.Cep, T2.Bairro, T2.Cidade, T3.Sigla, T2.Cnpj, T2.Insc_UF,(((T1.VlrOriginal / 30) * 10) / 100) AS MultaBol," +
" T4.FormaPgto,T2.Fone,T5.Documento, RTRIM(T1.LinhaBoleto) AS LinhaDigBoleto, RTRIM(T1.CodBarraBoleto) AS CodBarraBoleto, RTRIM(T1.NossoNumero) AS NossoNumeroBoleto," +
" T6.FANTASIA AS Filial,T6.Juros as JuroBoleto,T6.Multa as MultaBoleto,T6.Instrucao,T7.NumAgencia,T7.Conta,T7.DigConta,T8.Vendedor,T0.IMAGEM AS LOGO, " +
" T6.Filial as NomeFilial, RTRIM(T6.Endereco) + ',' + RTRIM(T6.Numero) + ' ' + RTRIM(T6.Complemento) AS ENDFILIAL, T6.Cep AS CepFilial, T6.Bairro as BairroFilial,T6.Cidade as CidFilial,T6.Fone1 AS FoneFilial,T6.Cnpj as CnpjFilial,T6.Insc_UF as InscFilial" +
" FROM LancFinanceiro AS T1 " +
" LEFT OUTER JOIN Pessoas AS T2 ON T2.Id_Pessoa = T1.Id_Pessoa " +
" LEFT OUTER JOIN Estados AS T3 ON T3.Id_Uf = T2.Id_Uf" +
" LEFT OUTER JOIN FormaPagamento AS T4 ON T4.Id_FormaPgto = T1.Id_FormaPgto" +
" LEFT OUTER JOIN TipoDocumento AS T5 ON T5.Id_Documento = T1.Id_TipoDocumento" +
" LEFT OUTER JOIN Empresa_Filial as T6 on T6.Id_Filial=t1.Id_Filial" +
" LEFT OUTER JOIN Bancos as T7 on T7.Id_Banco=T6.Id_Banco" +
" LEFT OUTER JOIN MVVENDA AS T9 ON (T9.ID_VENDA=T1.ID_VENDA)" +
" LEFT OUTER JOIN Vendedores as T8 on T8.Id_Vendedor=T9.Id_Vendedor" +
" LEFT OUTER JOIN TABIMAGENS AS T0 ON (T0.ID_CHAVE=T6.ID_FILIAL AND T0.TABELA='FILIAL')" +
" WHERE T1.ID_VENDA=" + Vendas.IdVdMaster.ToString();
}
if (ImpBoleto)
{
FormaPgto.LerDados(Vendas.IdFormaPgto);
if (FormaPgto.PrimParcela <= 1)
{
MessageBox.Show("Boleto não pode ser impresso, Verificar a Forma de pagamento", "Informação", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
BtnImprimir.Enabled = false;
if (Rb_BoletoA4.Checked)
{
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelBoletoA4 RelBoleto = new Relatorios.RelBoletoA4();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSQL);
RelBoleto.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = RelBoleto;
FrmRel.ShowDialog();
}
else
{
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelBoleto RelBoleto = new Relatorios.RelBoleto();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSQL);
RelBoleto.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = RelBoleto;
FrmRel.ShowDialog();
}
BtnImprimir.Enabled = true;
}
else
{
//NumeroPorExtenso Extenso = new NumeroPorExtenso(Vendas.VlrTotal);
if (!ImpProm)
{
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelRecibo RelRec = new Relatorios.RelRecibo();
DataSet TabRel = new DataSet();
TabRel = Controle.ConsultaTabela(sSQL);
RelRec.SetDataSource(TabRel.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = RelRec;
FrmRel.ShowDialog();
}
else
{
string sSQLPrd = "Select rtrim(T2.descricao) as Descricao from MvVendaItens t1 left join Produtos t2 on (T2.id_produto=T1.Id_Produto) where t1.id_Venda=" + Vendas.IdVdMaster.ToString();
FrmRelatorios FrmRel = new FrmRelatorios();
Relatorios.RelPromissoria RelRec = new Relatorios.RelPromissoria();
DataSet TabRel = new DataSet();
DataSet TabRelPrd = new DataSet();
TabRel = Controle.ConsultaTabela(sSQL);
TabRelPrd = Controle.ConsultaTabela(sSQLPrd);
//RelRec.SetDataSource(TabRel.Tables[0]);
RelRec.Database.Tables[0].SetDataSource(TabRel.Tables[0]);
RelRec.Database.Tables[1].SetDataSource(TabRelPrd.Tables[0]);
FrmRel.cryRepRelatorio.ReportSource = RelRec;
FrmRel.ShowDialog();
}
BtnImprimir.Enabled = false;
}
}
}
BtnImprimir.Enabled = true;
}