Ejemplo n.º 1
0
        /// <summary>获得数据列表
        ///
        /// </summary>
        /// <param name="strWhere">条件</param>
        /// <param name="strFields">字段</param>
        /// <returns>返回符合条件的DataSet数据集</returns>
        public DataSet GetList(string strWhere, string strFields)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select " + strFields + " ");
            strSql.Append(" FROM Bse_UI  ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            SQLiteHelper h = GlobalHelp.GetSQLiteHelper();

            h.CreateCommand(strSql.ToString());
            DataTable dt = h.ExecuteQuery();
            DataSet   ds = new DataSet();

            ds.Tables.Add(dt);
            return(ds);
        }