private static int ValidaExistente(CPSysUDB.CPSysSQLFramework2 db, string campo, object valor)
{
try
{
List <CPSysUDB.CPSysSQLFramework2.Select> select = new List <CPSysUDB.CPSysSQLFramework2.Select>();
List <CPSysUDB.CPSysSQLFramework2.Field> campos = new List <CPSysUDB.CPSysSQLFramework2.Field>();
List <CPSysUDB.CPSysSQLFramework2.Where> where = new List <CPSysUDB.CPSysSQLFramework2.Where>();
campos.Add(new CPSysUDB.CPSysSQLFramework2.Field().NewField <acessos>("*"));// INFORME TODOS OS CAMPOS DO SELECT OU * PARA TODOS
where.Add(new CPSysUDB.CPSysSQLFramework2.Where(new CPSysUDB.CPSysSQLFramework2.Field().NewField <acessos>(campo), CPSysUDB.Enums.Command.EQUALS, new CPSysUDB.DAL.Values(valor)));
select.Add(new CPSysUDB.CPSysSQLFramework2.Select().NewSelect <acessos>(campos, null, where));
DataSet ds = db.SelectValue(select);
return(ds.Tables[0].Rows.Count);
}
catch
{
return(-1);
}
}
