// GET: CountCartridge public ActionResult CountCartridge(string datetimepicker) { Debug.WriteLine(string.Format("datetimepicker={0}", datetimepicker)); string dateTimePicker; if (datetimepicker != null) { ViewBag.DTP = datetimepicker; dateTimePicker = datetimepicker; } else { ViewBag.DTP = DateTime.Today.ToShortDateString(); dateTimePicker = DateTime.Today.ToShortDateString(); } IEnumerable <sp_SEL_RemainDays2Result> remainDays = _db.sp_SEL_RemainDays2(); //CartridgeStateView cartridgeStateView = new CartridgeStateView(dateTimePicker); //IEnumerable<CartridgeStateView> csv=cartridgeStateView. IEnumerable <CartridgeStateView2> cartridgeStateView = new List <CartridgeStateView2>(); /* foreach(var item in cartridgeStateView) * { * item.InputDate = dateTimePicker; * }*/ Mapper.CreateMap <sp_SEL_RemainDays2Result, CartridgeStateView2>().ConstructProjectionUsing(x => new CartridgeStateView2(dateTimePicker)); //.ConstructUsing(new CartridgeStateView(dateTimePicker)); Mapper.Map(remainDays, cartridgeStateView); return(View(cartridgeStateView.Where(x => x.CountCartridge > 0).OrderBy(x => x.CountCartridge).ToList())); }
/* * public ActionResult Index() * { * IEnumerable<sp_SEL_RemainDaysResult> remainDays=_db.sp_SEL_RemainDays(); * IEnumerable<RemainDaysView> remainDaysView = new List<RemainDaysView>(); * Mapper.CreateMap<sp_SEL_RemainDaysResult, RemainDaysView>(); * Mapper.Map(remainDays, remainDaysView); * return View(remainDaysView.OrderBy(x=>x.NumberDays).ToList()); * }*/ public ActionResult Index() { IEnumerable <sp_SEL_RemainDays2Result> remainDays = _db.sp_SEL_RemainDays2(); IEnumerable <RemainDaysView2> remainDaysView = new List <RemainDaysView2>(); Mapper.CreateMap <sp_SEL_RemainDays2Result, RemainDaysView2>(); Mapper.Map(remainDays, remainDaysView); return(View(remainDaysView.OrderBy(x => x.NumberDays).ToList())); }