public JsonResult GetMonthlyRptData(string EqpID)
{
try
{
DateTime Now = DateTime.Now;
DateTime LastWeek = Now.Date.AddDays(-7);
DateTime FourWeeksAgo = Now.Date.AddDays(-4 * 7);
int week_to_year = LastWeek.Year;
int week_to_week = TimeHelper.GetWeekOfYear(LastWeek);
int week_from_year = FourWeeksAgo.Year;
int week_from_week = TimeHelper.GetWeekOfYear(FourWeeksAgo);
var postModel = new ReqRpt018PostViewModel()
{
type = "week", frame = "", from = string.Format("{0}-W{1}", week_from_year, fixFigure(week_from_week)), to = string.Format("{0}-W{1}", week_to_year, fixFigure(week_to_week)), selectedeqpid = EqpID
};
TableViewModel = new ReqRpt018TableViewModel(postModel);
var data = TableViewModel.entities[0].Datas.Select(s => new { s.Date, s.SD, s.UD, EN = s.ENGHour / s.TotalHour, s.UUm, s.UPm });
var request = data;
return(Json(request, JsonRequestBehavior.DenyGet));
}
catch (Exception)
{ return(null); }
}
//直接返回布局页的方式：HTML
public JsonResult GetTableByAllConditions(ReqRpt018PostViewModel viewModel)
{
try
{
TableViewModel = new ReqRpt018TableViewModel(viewModel);
return(Json(TableViewModel, JsonRequestBehavior.DenyGet));
}
catch (Exception)
{
return(null);
}
}
//直接返回布局页的方式：HTML
public PartialViewResult GetTableByAllConditions(ReqRpt018PostViewModel viewModel)
{
try
{
TableViewModel = new ReqRpt018TableViewModel(viewModel);
return(PartialView(TableViewModel));
}
catch (Exception)
{
return(null);
}
}
public string Query(ReqRpt018PostViewModel viewModel)
{
string msg = "{\"success\":true,\"message\":\"" + viewModel.eqptype + " " + viewModel.from + "~" + viewModel.to + "\"}";
return(msg);
}
