// GET: MassCollection public ActionResult Index(int?page, string MemberId = null, int BillID = 0, string sDate = null, string eDate = null, string currentMemerid = "", int currentBillID = 0, string CurrsDate = "", string curreDate = "") { if (MemberId != null) { page = 1; } else { MemberId = currentMemerid; } if (sDate != null) { page = 1; } else { sDate = CurrsDate; } if (eDate != null) { page = 1; } else { eDate = curreDate; } ViewBag.CurrsDate = sDate; ViewBag.curreDate = eDate; ViewBag.currentBillID = BillID; ViewBag.currentMemerid = MemberId; var billRegisters = db.BillRegisters.Include(b => b.MemeberCompanyInfo).Where(s => s.paid == "N"); if (!String.IsNullOrEmpty(MemberId)) { List <string> memid = new List <string>(); string[] str = MemberId.Split(','); foreach (string s in str) { memid.Add(s); } billRegisters = from c in billRegisters where memid.Contains(c.MemeberCompanyInfo.mid) select c; } if (!String.IsNullOrEmpty(sDate) && !String.IsNullOrEmpty(eDate)) { DateTime dtfrom = Convert.ToDateTime(sDate); DateTime dtTo = Convert.ToDateTime(eDate); billRegisters = billRegisters.Where(s => s.BillDate >= dtfrom && s.BillDate <= dtTo); } billRegisters = billRegisters.OrderBy(s => s.BillID); int pageNumber = (page ?? 1); return(View(billRegisters.ToPagedList(pageNumber, 100))); }