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