public ActionResult Summary(string CheckDate) { //初始化系統參數 Configer.Init(); //Log記錄用 SYSTEMLOG SL = new SYSTEMLOG(); SL.UId = Session["UserID"].ToString(); SL.Controller = "Review"; SL.Action = "Summary"; SL.StartDateTime = DateTime.Now; string MailServer = Configer.MailServer; int MailServerPort = Configer.MailServerPort; string MailSender = Configer.MailSender; List<string> MailReceiver = Configer.MailReceiver; try { vReviewSummary vRS = new vReviewSummary(); vRS.CheckDate = CheckDate; string CheckSN = CheckDate + "01"; vRS.EventItem = context.CHECKPROCESSDETAILS.Where(b => b.CheckSN == CheckSN).Where(b => b.ListID == 1).First().CheckResult; vRS.HandoverItem = context.CHECKPROCESSDETAILS.Where(b => b.CheckSN == CheckSN).Where(b => b.ListID == 2).First().CheckResult; var query01 = context.CHECKPROCESSES.Where(b => b.CheckDate == CheckDate).Where(b => b.CheckID == 1); if (query01.Count()>0) { vRS.ShiftOne = query01.First().ShiftOne; vRS.ShiftThree = query01.First().ShiftThree; vRS.ShiftFour = query01.First().ShiftFour; vRS.ShiftTop = query01.First().ShiftTop; vRS.ManageOne = query01.First().ManageOne; vRS.ManageTop = query01.First().ManageTop; } var query = context.REVIEWDATAS.Where(b => b.CheckDate == CheckDate); //.Where(b=>b.ListName!= "事件描述及行動").Where(b=>b.ListName != "交接事項"); if (query.Count() > 0) { SL.EndDateTime = DateTime.Now; SL.TotalCount = query.Count(); SL.SuccessCount = query.Count(); SL.FailCount = 0; SL.Result = true; SL.Msg = "取得[" + CheckDate + "]覆核資料作業成功"; SF.log2DB(SL, MailServer, MailServerPort, MailSender, MailReceiver); DateTime parsed; string parsedTime = "取得檢核件時間錯誤"; if (DateTime.TryParseExact(CheckDate, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out parsed)) { parsedTime = parsed.ToString("yyyy-MM-dd"); } TempData["TitleText"] = parsedTime + " 檢核資料"; vRS.RD = query.ToList(); return View(vRS); } else { SL.EndDateTime = DateTime.Now; SL.TotalCount = query.Count(); SL.SuccessCount = query.Count(); SL.FailCount = 0; SL.Result = true; SL.Msg = "取得[" + CheckDate + "]覆核資料作業失敗," + "錯誤訊息[找不到待覆核資料]"; SF.log2DB(SL, MailServer, MailServerPort, MailSender, MailReceiver); return null; } } catch (Exception ex) { SL.EndDateTime = DateTime.Now; SL.TotalCount = 0; SL.SuccessCount = 0; SL.FailCount = 0; SL.Result = false; SL.Msg = "取得[" + CheckDate + "]覆核資料作業失敗," + "錯誤訊息[" + ex.ToString() + "]"; SF.log2DB(SL, MailServer, MailServerPort, MailSender, MailReceiver); return null; } }
public ActionResult Summary(string CheckDate) { //初始化系統參數 Configer.Init(); //Log記錄用 SYSTEMLOG SL = new SYSTEMLOG(); SL.UId = Session["UserID"].ToString(); SL.Controller = "Review"; SL.Action = "Summary"; SL.StartDateTime = DateTime.Now; string MailServer = Configer.MailServer; int MailServerPort = Configer.MailServerPort; string MailSender = Configer.MailSender; List <string> MailReceiver = Configer.MailReceiver; try { vReviewSummary vRS = new vReviewSummary(); vRS.CheckDate = CheckDate; string CheckSN = CheckDate + "01"; vRS.EventItem = context.CHECKPROCESSDETAILS.Where(b => b.CheckSN == CheckSN).Where(b => b.ListID == 1).First().CheckResult; vRS.HandoverItem = context.CHECKPROCESSDETAILS.Where(b => b.CheckSN == CheckSN).Where(b => b.ListID == 2).First().CheckResult; var query01 = context.CHECKPROCESSES.Where(b => b.CheckDate == CheckDate).Where(b => b.CheckID == 1); if (query01.Count() > 0) { vRS.ShiftOne = query01.First().ShiftOne; vRS.ShiftThree = query01.First().ShiftThree; vRS.ShiftFour = query01.First().ShiftFour; vRS.ShiftTop = query01.First().ShiftTop; vRS.ManageOne = query01.First().ManageOne; vRS.ManageTop = query01.First().ManageTop; } var query = context.REVIEWDATAS.Where(b => b.CheckDate == CheckDate); //.Where(b=>b.ListName!= "事件描述及行動").Where(b=>b.ListName != "交接事項"); if (query.Count() > 0) { SL.EndDateTime = DateTime.Now; SL.TotalCount = query.Count(); SL.SuccessCount = query.Count(); SL.FailCount = 0; SL.Result = true; SL.Msg = "取得[" + CheckDate + "]覆核資料作業成功"; SF.log2DB(SL, MailServer, MailServerPort, MailSender, MailReceiver); DateTime parsed; string parsedTime = "取得檢核件時間錯誤"; if (DateTime.TryParseExact(CheckDate, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out parsed)) { parsedTime = parsed.ToString("yyyy-MM-dd"); } TempData["TitleText"] = parsedTime + " 檢核資料"; vRS.RD = query.ToList(); return(View(vRS)); } else { SL.EndDateTime = DateTime.Now; SL.TotalCount = query.Count(); SL.SuccessCount = query.Count(); SL.FailCount = 0; SL.Result = true; SL.Msg = "取得[" + CheckDate + "]覆核資料作業失敗," + "錯誤訊息[找不到待覆核資料]"; SF.log2DB(SL, MailServer, MailServerPort, MailSender, MailReceiver); return(null); } } catch (Exception ex) { SL.EndDateTime = DateTime.Now; SL.TotalCount = 0; SL.SuccessCount = 0; SL.FailCount = 0; SL.Result = false; SL.Msg = "取得[" + CheckDate + "]覆核資料作業失敗," + "錯誤訊息[" + ex.ToString() + "]"; SF.log2DB(SL, MailServer, MailServerPort, MailSender, MailReceiver); return(null); } }