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