// GET: Mps public ActionResult Index(int?page) { int pageIndex = PagingHelper.GetPageIndex(page); MpsSeachModel q = new MpsSeachModel(); IMpsService ms = new MpsService(Settings.Default.db); IPagedList <MP> mps = ms.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; SetMpStatusDisplayList(null); return(View(mps)); }
public ActionResult Search([Bind(Include = "PartNr,PartNrAct, OrderedDateFrom, OrderedDateTo,RequiredDateFrom, RequiredDateTo, Status")] MpsSeachModel q) { int pageIndex = 0; int.TryParse(Request.QueryString.Get("page"), out pageIndex); pageIndex = PagingHelper.GetPageIndex(pageIndex); IMpsService ms = new MpsService(Settings.Default.db); IPagedList <MP> mps = ms.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; SetMpStatusDisplayList(q.Status); return(View("Index", mps)); }
public void Export([Bind(Include = "PartNr,PartNrAct, OrderedDateFrom, OrderedDateTo,RequiredDateFrom, RequiredDateTo, Status")] MpsSeachModel q) { IMpsService bs = new MpsService(Settings.Default.db); List <MP> mps = bs.Search(q).ToList(); ViewBag.Query = q; MemoryStream ms = new MemoryStream(); using (StreamWriter sw = new StreamWriter(ms, Encoding.UTF8)) { List <string> head = new List <string> { " No.", "ID", "PartNr", "OrderedDate", "RequiredDate", "Quantity", "Source", "SourceDoc", "Status", "UnitId", "Action" }; sw.WriteLine(string.Join(Settings.Default.csvDelimiter, head)); for (var i = 0; i < mps.Count; i++) { List <string> ii = new List <string>(); ii.Add((i + 1).ToString()); ii.Add(mps[i].id.ToString()); ii.Add(mps[i].partnr); ii.Add(mps[i].orderedDate.ToString()); ii.Add(mps[i].requiredDate.ToString()); ii.Add(mps[i].quantity.ToString()); ii.Add(mps[i].source); ii.Add(mps[i].sourceDoc); ii.Add(mps[i].status.ToString()); ii.Add(mps[i].unitId); ii.Add(""); sw.WriteLine(string.Join(Settings.Default.csvDelimiter, ii.ToArray())); } //sw.WriteLine(max); } var filename = "Mps" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv"; var contenttype = "text/csv"; Response.Clear(); Response.ContentEncoding = Encoding.UTF8; Response.ContentType = contenttype; Response.AddHeader("content-disposition", "attachment;filename=" + filename); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.BinaryWrite(ms.ToArray()); Response.End(); }