// 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)));
}
