Exemplo n.º 1
0
        /// <summary>
        /// Fast querie. Get a sql querie informing table + where
        /// </summary>
        /// <param name="oConn"></param>
        /// <param name="table"></param>
        /// <param name="where"></param>
        /// <param name="order"></param>
        /// <returns></returns>
        public static DataTable fastQuerie(IDbPersist oConn, string table, string where = "", string order = "")
        {
            string sql = " select * from " + table;

            if (where != "")
            {
                sql += " where " + where;
            }

            if (order != "")
            {
                sql += " order by " + order;
            }


            return(oConn.fetchDados(sql));
        }
Exemplo n.º 2
0
 /// <summary>
 /// Perfoms a querie
 /// </summary>
 /// <param name="oConn"></param>
 /// <param name="sql"></param>
 /// <returns></returns>
 public static DataTable fetchData(IDbPersist oConn, string sql)
 {
     return(oConn.fetchDados(sql));
 }