Пример #1
0
        /// <summary>
        /// 返回所有信息
        /// </summary>
        /// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
        /// <param name="dict">参数的名/值集合</param>
        /// <returns></returns>
        public virtual DataTable GetAllData(string strWhere = "", Dictionary <string, object> dict = null)
        {
            string strSQL = "select * from ProductPrice where 1=1 ";

            if (!string.IsNullOrEmpty(strWhere))
            {
                strSQL += strWhere;
            }
            return(_DB.GetDataTable(strSQL, dict));
        }
        /// <summary>
        /// 返回所有信息
        /// </summary>
        /// <param name="strWhere">参数化查询条件(例如: and Name = @Name )</param>
        /// <param name="dict">参数的名/值集合</param>
        /// <returns></returns>
        public virtual DataTable GetAllData(string strWhere = "", Dictionary <string, object> dict = null)
        {
            string strSQL = "select * from GroupSpecialCategoryPermissions where 1=1 ";

            if (!string.IsNullOrEmpty(strWhere))
            {
                strSQL += strWhere;
            }
            return(_DB.GetDataTable(strSQL, dict));
        }