简单分页以及多条件查询

最新推荐文章于 2024-04-19 15:49:21 发布

转载最新推荐文章于 2024-04-19 15:49:21 发布 · 118 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/MenBe/p/9614625.html

public ActionResult Index(string time = "", string time1 = "", string PName = "", string SName = "", string name = "",int id=1,int size = 3)
{
SuoShuPinType();
UserInfoType();

List<UserInfoModel> list = ShowPage(PName, SName, time, time1, name);

ViewBag.Index = id;
ViewBag.Count = list.Count;
ViewBag.Page = Math.Ceiling((decimal)list.Count / size);
list = list.Skip((id - 1) * size).Take(size).ToList();

return View(list);
}
/// <summary>
/// 下拉查询
/// </summary>
/// <param name="pinpai"></param>
/// <param name="fenlei"></param>
/// <param name="time"></param>
/// <param name="time1"></param>
/// <param name="name"></param>
public List<UserInfoModel> ShowPage(string pinpai = "", string fenlei = "", string time = "", string time1 = "", string name = "")
{
string where = "1=1 ";
if (!string.IsNullOrEmpty(pinpai))
{
where = "and a.PinPaiID=b.PinPaiID";
}
if (!string.IsNullOrEmpty(fenlei))
{
Where = "and a.SuoShuID=c.SuoShuID";
}
if (!string.IsNullOrEmpty(name))
{
Where = "where a.Name like '%" + name + "%'";
}
if (time != null)
{
Where = "and GengXin between '" + time + "' and '" + time1 + "'";
}
Where = where;
List<UserInfoModel> list = JsonConvert.DeserializeObject<List<UserInfoModel>>(JsonConvert.SerializeObject(bll.DataBind(name,time,time1)));
return list;
}