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); }