public ActionResult List(vList obj) { HYCEntities model = new HYCEntities(); var i2 = model.AS_WORKTIME.Where(x => x.AS_USERID == obj.EmployeeName && x.AS_DATE.ToString().Substring(0, 6) == obj.StartYYMM).Select(y => y); var i3 = model.AS_WORKTIME.Where(x => x.AS_USERID == obj.EmployeeName && x.AS_DATE.ToString().Substring(0, 6) == obj.StartYYMM).Sum(y => y.AS_HOURS); double result = Convert.ToInt32(i3); double Dd; double Hh; double Mm; if (result > 1440) { Dd = Math.Floor(result / 1440); Hh = Math.Floor((result / 60) % 24); Mm = Math.Floor(result % 60); } else { Dd = 0; Hh = Math.Floor(result / 60); Mm = result % 60; } List <vEmployeeWorktime> items = new List <vEmployeeWorktime>(); vEmployeeWorktime newItem = new vEmployeeWorktime(); newItem.ASS_SN = 0; newItem.AS_USERID = ""; newItem.AS_DATE = 0; newItem.AS_STIME = 0; newItem.AS_ETIME = 0; newItem.AS_HOURS = 0; newItem.SHOWTIME = Convert.ToString(Dd) + '天' + Convert.ToString(Hh) + '時' + Convert.ToString(Mm) + '分'; items.Add(newItem); foreach (var item in i2) { string oShowTime; item.AS_HOURS = calHours(item.AS_DATE, item.AS_ETIME, item.AS_STIME, out oShowTime); newItem = new vEmployeeWorktime(); newItem.ASS_SN = item.ASS_SN; newItem.AS_USERID = item.AS_USERID; newItem.AS_DATE = item.AS_DATE; newItem.AS_STIME = item.AS_STIME; newItem.AS_ETIME = item.AS_ETIME; newItem.AS_HOURS = item.AS_HOURS; newItem.SHOWTIME = oShowTime; items.Add(newItem); } return(View("Index", items)); }
// GET: Home public ActionResult Index() { HYCEntities model = new HYCEntities(); List <vEmployeeWorktime> items = new List <vEmployeeWorktime>(); foreach (var item in model.AS_WORKTIME) { string oShowTime; item.AS_HOURS = calHours(item.AS_DATE, item.AS_ETIME, item.AS_STIME, out oShowTime); vEmployeeWorktime newItem = new vEmployeeWorktime(); newItem.ASS_SN = item.ASS_SN; newItem.AS_USERID = item.AS_USERID; newItem.AS_DATE = item.AS_DATE; newItem.AS_STIME = item.AS_STIME; newItem.AS_ETIME = item.AS_ETIME; newItem.AS_HOURS = item.AS_HOURS; //SAVE DATA newItem.SHOWTIME = oShowTime; //VIEW DATA items.Add(newItem); } model.SaveChanges(); return(View(items)); }