public List <Employee> GetUserList(UserFilter filter, out int itemCount)
{
WhereSqlClauseBuilder where = filter.ConvertToWhereBuilder();
where.AppendItem("employeeStatus", 3, "<>");
QueryCondition qc = new QueryCondition(
filter.RowIndex,
filter.PageSize,
" * ",
ORMapping.GetTableName <Employee>(),
" orgName asc,username asc ",
where.ToSqlString(TSqlBuilder.Instance)
);
PartlyCollection <Employee> tuple = GetPageSplitedCollection(qc);
itemCount = tuple.TotalCount;
return(tuple.SubCollection);
}