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; }
转载于:https://www.cnblogs.com/MenBe/p/9614625.html
