public ActionResult List()
{
int page = 1;
if (!String.IsNullOrEmpty(Request["p"]))
{
page = Convert.ToInt32(Request["p"]);
}
String search_criteria = "";
if (!String.IsNullOrEmpty(Request.QueryString["s"]))
{
search_criteria = Request.QueryString["s"];
}
int total;
//Dictionary<T_UserColumns, AscDesc> orderBy = new Dictionary<T_UserColumns, AscDesc>();
//List<T_User> entitys = entityDao.WebSearch(page, this.pageSize, search_criteria, orderBy, out total);
T_User entity = new T_User();
List <T_User> entitys =
entityDao.Search(entity, page, this.pageSize, search_criteria, T_User.Columns.id, AscDesc.ASC, out total);
ViewBag.total = total;
ViewBag.pageSize = this.pageSize;
return(View("List", entitys));
}
public ActionResult List()
{
T_UserDAO entityDao = new T_UserDAO();
int page = 1;//第几页
if (!String.IsNullOrEmpty(Request.Query["p"]))
{
page = Convert.ToInt32(Request.Query["p"]);
}
String search_criteria = "";//全文模糊查询条件
if (!String.IsNullOrEmpty(Request.Query["s"]))
{
search_criteria = Request.Query["s"];
}
String col = null;//排序列
Expression <Func <T_User, dynamic> > orderBy = null;
try
{
if (!String.IsNullOrEmpty(Request.Query["o"]))
{
col = Request.Query["o"];
orderBy = entityDao.GetOrderByFromColName(col);
}
else
{
//如果页面没有排序规则，则按id排序
orderBy = entityDao.GetOrderByFromColName("id");
}
}
catch (Exception ex)
{
throw ex;
}
bool isDecending = true;//默认按降序排序
if (!String.IsNullOrEmpty(Request.Query["de"]))
{
try
{
isDecending = Convert.ToBoolean(Request.Query["de"]);
}
catch (Exception ex) { }
}
int total = 0;
List <T_User> list =
//从url输入的待查询文本，支持多关键字模糊查询
entityDao.Search(ref total, search_criteria,
null, //where里面支持另一些lambda条件表达式，跟前面的文本形成and关系
orderBy, isDecending, //排序
page, this.pageSize) //分页
.ToList();
ViewBag.total = total;
ViewBag.list = list;
ViewBag.pageSize = this.pageSize;
ViewData["Title"] = "用户列表";
ViewData["username"] = HttpContext.Session.GetString("username");
return(View());
}