// public IList <Person> FindList(Person whereModel, string where, int top) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("select top {0} ", top); strSql.Append("id,username,password,age,registerDate,address "); strSql.Append("from [Person] "); strSql.AppendFormat("where 1=1 and {0} ", where); var result = _dbHelper.FindList <Person> (strSql.ToString(), whereModel); return(result); }
// public IList <User> FindList(User whereModel, string where, int top) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("select top {0} ", top); strSql.Append("userId,username,passwordHash,email,phoneNumber,isFirstTimeLogin,accessFailedCount,creationDate,isActive,lastTimestamp "); strSql.Append("from [User] "); strSql.AppendFormat("where 1=1 and {0} ", where); var result = _dbHelper.FindList <User> (strSql.ToString(), whereModel); return(result); }
// public IList <Person> FindListByPage(Person whereModel, string where, string orderBy, int pageIndex, int pageSize) { var startIndex = pageIndex * pageSize; var size = pageSize; StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append("id,username,password,age,registerDate,address "); strSql.Append("from [Person] "); strSql.AppendFormat("where 1=1 and {0} ", where); strSql.AppendFormat("ORDER BY {0} OFFSET {1} ROWS FETCH NEXT {2} ROWS ONLY", orderBy, startIndex, size); var result = DbHelperSql.FindList <Person>(strSql.ToString(), whereModel); return(result); }
// public IList <User> FindListByPage(User whereModel, string where, string orderBy, int pageIndex, int pageSize) { var startIndex = pageIndex * pageSize; var size = pageSize; StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append("userId,username,passwordHash,email,phoneNumber,isFirstTimeLogin,accessFailedCount,creationDate,isActive,lastTimestamp "); strSql.Append("from [User] "); strSql.AppendFormat("where 1=1 and {0} ", where); strSql.AppendFormat("ORDER BY {0} OFFSET {1} ROWS FETCH NEXT {2} ROWS ONLY", orderBy, startIndex, size); var result = DbHelperSql.FindList <User>(strSql.ToString(), whereModel); return(result); }