public DataTable qrySeekRet(string sExpressao)
{
DataTable dt = HlpDbFuncoesGeral.QrySeekRet(oTabelas.dbsGeral,
oTabelas.GetDriverBaseDados(),
oTabelas.GetClasseDbDataAdapterBaseDados(),
oTabelas.GetClasseDbCommandBaseDados(),
sExpressao, !oTabelas.MantemConexaoAberta);
return(dt);
}
public DataTable qrySeekRet(string sTabela, string sCampos,
string sWhere, string sOrdem)
{
StringBuilder strExpressao = new StringBuilder();
strExpressao.Append("SELECT ");
if (sCampos.Trim() == String.Empty)
{
strExpressao.Append("*");
}
else
{
strExpressao.Append(sCampos);
}
strExpressao.Append(" FROM " + sTabela);
StringBuilder strWhere = new StringBuilder();
if ((sWhere != null) && (sWhere.Trim() != String.Empty))
{
strWhere.Append(sWhere);
}
if ((fExisteCampo(sTabela, "CD_EMPRESA")) &&
(sWhere.ToUpper().IndexOf("CD_EMPRESA") < 0))
{
if (strWhere.Length > 0)
{
strWhere.Append(" AND ");
}
strWhere.Append("(CD_EMPRESA = '" + oTabelas.sEmpresa + "')");
}
if (strWhere.Length > 0)
{
strWhere.Insert(0, " WHERE ");
strExpressao.Append(strWhere.ToString());
}
if ((sOrdem != null) && (sOrdem.Trim() != String.Empty))
{
strExpressao.Append(" ORDER BY " + sOrdem);
}
DataTable dt = HlpDbFuncoesGeral.QrySeekRet(oTabelas.dbsGeral,
oTabelas.GetDriverBaseDados(),
oTabelas.GetClasseDbDataAdapterBaseDados(),
oTabelas.GetClasseDbCommandBaseDados(),
strExpressao.ToString(), !oTabelas.MantemConexaoAberta);
return(dt);
}
