private void btnConfirmar_Click(object sender, EventArgs ea)
{
//Get the value of the txt boxes and storage in variables with the get and set atributes.
filtro = new FiltroRelatorio();
String msgErro = "";
//Date validation, and error as send to the user, if the date is incorret or invalid.
try
{
if (maskedTextBox1.MaskCompleted)
{
filtro.DateManifesto = DateTime.ParseExact(maskedTextBox1.Text, "dd/MM/yyyy", CultureInfo.CreateSpecificCulture("pt-BR"));
}
}catch (Exception e)
{
msgErro = "Data Inválida ";
}
if (filtro.DateManifesto == DateTime.MinValue)
{
msgErro = "Data Inválida";
}
if (!String.IsNullOrEmpty(msgErro))
{
MessageBox.Show(msgErro, "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error);
filtro = null;
return;
}
if (cbVend.SelectedItem == null)
{
MessageBox.Show("Vendedor não encontrado", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var sel = (cbVend.SelectedItem as ItemData <Int64>);
if (sel.Codigo == -1)
{
filtro.VendedorCode = null;
}
else
{
filtro.VendedorCode = sel.Codigo.ToString();
}
//SyncInterativo.Sincronizar();
this.Close();
}
List <Det> getItens(FiltroRelatorio filtr)
{
if (filtr != null)
{
var conn = new NpgsqlConnection(ConfigurationManager.AppSettings["ConexaoFch"]);
String sql = $"select * from fechamento " +
$" inner join fechamentodet1220 on fech_transacao = fchd_transacao" +
$" left join produtos on prod_codigo = fchd_prod_codigo " +
$" where fech_data_fechamento = '{filtr.DateManifesto}' and fech_status = 'N' ";
if (!String.IsNullOrEmpty(filtr.VendedorCode))
{
sql += $" and fech_vend_codigo = '{filtr.VendedorCode}' ";
}
conn.Open();
var cmd = new NpgsqlCommand(sql, conn);
var dr = cmd.ExecuteReader();
List <Det> itens = new List <Det>();
//Set the data grid view infos, and convert his values, if needed.
while (dr.Read())
{
var item = new Det();
item.fchTransacao = dr.GetSafeValue <String>("fchd_transacao");
item.prodCodigo = dr.GetSafeValue <Int64>("fchd_prod_codigo");
item.prodCodigoRB = dr.GetSafeValue <Int64>("prod_codigo_rb");
item.fsProdNome = dr.GetSafeValue <String>("prod_descricao");
item.qtdeCarga = dr.GetSafeValue <Int64>("fchd_qtde_carga");
item.prQtdeVenda = dr.GetSafeValue <Int64>("fchd_pr_qtde_venda");
item.prQtdeTroca = dr.GetSafeValue <Int64>("fchd_pr_qtde_troca");
item.prQtdeRetorno = dr.GetSafeValue <Int64>("fchd_pr_qtde_retorno");
item.fsQtdeVenda = dr.GetSafeValue <Int64>("fchd_fr_qtde_venda");
item.fsQtdeTroca = dr.GetSafeValue <Int64>("fchd_fr_qtde_troca");
item.fsQtdeRetorno = dr.GetSafeValue <Int64>("fchd_fr_qtde_retorno");
item.prValorProd = dr.GetSafeValue <Decimal>("fchd_pr_valorprod");
item.prValorTotal = dr.GetSafeValue <Decimal>("fchd_pr_valortotal");
item.prComissao = dr.GetSafeValue <Decimal>("fchd_pr_valorcomissao");
itens.Add(item);
}
conn.Close();
return(itens);
}
else
{
List <Det> vazio = new List <Det>();
return(vazio);
}
}
//Get the requests where the doct code = 7505.
public static List <String> getRequests(FiltroRelatorio filtro)
{
AbrirConexao();
List <String> where = new List <String>();
if (filtro.DateManifesto != null)
{
//"yyyy-MM-dd" is the format of the date.
where.Add($" pvec_database = '{filtro.DateManifesto.ToString("yyyy-MM-dd")}' ");
}
where.Add(" mdoc_status = 'N' ");
where.Add(" mdoc_dcto_codigo = '7505' ");
var vendedor = BancoFechamento.getVendedores();
var sqlVendedor = vendedor.Select(t => t.Key).ToList().JoinArraySQL();
where.Add($" pvec_vend_codigo in ({sqlVendedor})");
//Get the tables in postgresql.
//Get the requests.
String sql = $" select mdoc_transacao, pvec_vend_codigo, pvec_database from movdctos " +
" inner join pedvendac on mdoc_transacao = pvec_transacao ";
if (where.Count > 0)
{
sql += " where ";
}
for (int i = 0; i < where.Count; i++)
{
sql += " " + where[i];
if (i != where.Count - 1)
{
sql += " and ";
}
}
//Get the requests and find the manifest.
var cmd = new NpgsqlCommand(sql, mConexao);
var dr = cmd.ExecuteReader();
List <String> infos = new List <String>();
//String requestTransation;
while (dr.Read())
{
infos.Add(dr.GetSafeValue <String>("mdoc_transacao"));
}
dr.Close();
return(infos);
}
