//
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);
}
