public static CL_Visita buscaVistaIDUmov(int idUmov, string con)
{
return(DB_Visita.buscaVisitaIDUmov(idUmov, con));
}
public static bool verificaVisita(string v_lcto, string con)
{
return(DB_Visita.verificaVisita(v_lcto, con));
}
public static bool incluiVisita(CL_Visita objVisita, string con)
{
return(DB_Visita.incluiVisita(objVisita, con));
}
public static List <CL_Visita> pesqVisita(string dataI, string dataF, int cliente, int vendedor, string modelo, string con)
{
string sql = "";
if (modelo == "S")
{
if (vendedor > 0)
{
if (cliente > 0)
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_clicod =" + cliente + " AND v_vend=" + vendedor + " AND v_prxvis>='" + dataI + "' AND v_prxvis<='" + dataF + "'";
return(DB_Visita.pesqVisita(sql, con));
}
else
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_vend=" + vendedor + " AND v_prxvis>='" + dataI + "' AND v_prxvis<='" + dataF + "'";
return(DB_Visita.pesqVisita(sql, con));
}
}
else
{
if (cliente > 0)
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_clicod=" + cliente + " AND v_prxvis>='" + dataI + "' AND v_prxvis<='" + dataF + "'";
return(DB_Visita.pesqVisita(sql, con));
}
else
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_prxvis>='" + dataI + "' AND v_prxvis<='" + dataF + "'";
return(DB_Visita.pesqVisita(sql, con));
}
}
}
else
{
if (vendedor > 0)
{
if (cliente > 0)
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_clicod=" + cliente + " AND v_vend=" + vendedor + " AND v_ultvisit>='" + dataI + "' AND v_ultvisit<='" + dataF + "' AND v_ultvisit is not null";
return(DB_Visita.pesqVisita(sql, con));
}
else
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_vend=" + vendedor + "v_ultvisit>='" + dataI + "' AND v_ultvisit<='" + dataF + "'";
return(DB_Visita.pesqVisita(sql, con));
}
}
else
{
if (cliente > 0)
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_clicod=" + cliente + " AND v_ultvisit>='" + dataI + "' AND v_ultvisit<='" + dataF + "'";
return(DB_Visita.pesqVisita(sql, con));
}
else
{
sql = "SELECT v_lcto, v_clicod, p_nome, p_cgc, v_ultvisit, v_vend, con_nome, v_desc, v_prxvis, v_hist1, v_idumov, v_situac FROM visitas, particip, convenio WHERE v_ultvisit IS NOT NULL AND v_prxvis IS NOT NULL AND con_cod = v_vend AND v_clicod = p_cod AND v_ultvisit>='" + dataI + "' AND v_ultvisit<='" + dataF + "'";
return(DB_Visita.pesqVisita(sql, con));
}
}
}
}
public static bool verificaUmov(int idUmov, string con)
{
return(DB_Visita.verificaUmov(idUmov, con));
}
public static int buscaCod(int v_cod, string con)
{
return(DB_Visita.buscaCod(v_cod, con));
}
