public static DataTable qrySeekRet(string sTabela, string sCampos, string sWhere, string sOrdem, List <ListaCampos> lCampos = null)
{
if (lCampos != null)
{
sCampos = MontaStringCampos(lCampos);
}
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 = '" + Acesso.CD_EMPRESA + "')");
}
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(HlpDbFuncoesGeral.conexao, strExpressao.ToString());
return(dt);
}
public static void qrySeekInsert(string sExpressao)
{
HlpDbFuncoesGeral.QrySeekInsert(HlpDbFuncoesGeral.conexao, sExpressao);
}
public static FbDataReader qrySeekReader(string sExpressao)
{
FbDataReader dr = HlpDbFuncoesGeral.QrySeekReader(HlpDbFuncoesGeral.conexao, sExpressao);
return(dr);
}
public static DataTable qrySeekRet(string sExpressao)
{
DataTable dt = HlpDbFuncoesGeral.QrySeekRet(HlpDbFuncoesGeral.conexao, sExpressao);
return(dt);
}
