Пример #1
0
        public virtual List <TClass> GetAll(SqlWhereList sqlWhereList)
        {
            string strSql = string.Format("Select Top 500 * From {0} {1}", tableName,
                                          isLogicDelete ? "Where DelStatus=0" : "");

            strSql += isLogicDelete ? "" : " WHERE 1=1 ";
            strSql  = sqlWhereList.Aggregate(strSql,
                                             (current, field) =>
                                             current + (" AND " + field.ParaName + " = @" + field.ParaName));
            return(ExecuteDataSet(strSql, sqlWhereList.ToParas()).ToList <TClass>());
        }