public ActionResult _MiUpdate(GridCommand command, WorkCalendar workCalendar, string NDateIndexTo, string NDateIndex
, string NProductLine, DateTime? NDateIndexDate, DateTime? NDateIndexToDate, com.Sconit.CodeMaster.TimeUnit NDateType)
{
WorkCalendarSearchModel searchModel = new WorkCalendarSearchModel();
searchModel.ProductLine = NProductLine;
searchModel.DateType = (short)NDateType;
searchModel.DateIndex = NDateIndex;
searchModel.DateIndexTo = NDateIndexTo;
searchModel.DateIndexDate = NDateIndexDate;
searchModel.DateIndexToDate = NDateIndexToDate;
WorkCalendar newWorkCalendar = genericMgr.FindAll<WorkCalendar>(" from WorkCalendar as w where w.DateIndex=? and w.Flow=? and w.DateType=? ", new object[] { workCalendar.DateIndex, workCalendar.Flow, workCalendar.DateType })[0];
if (workCalendar.DateType == com.Sconit.CodeMaster.TimeUnit.Day)
{
newWorkCalendar.UpTime = 24 - (workCalendar.TrialTime + workCalendar.Holiday + workCalendar.HaltTime);
}
else if (workCalendar.DateType == com.Sconit.CodeMaster.TimeUnit.Week)
{
newWorkCalendar.UpTime = 7 - (workCalendar.TrialTime + workCalendar.Holiday + workCalendar.HaltTime);
}
else if (workCalendar.DateType == com.Sconit.CodeMaster.TimeUnit.Month)
{
string[] strArray = workCalendar.DateIndex.Split('-');
int monthDay = DateTime.DaysInMonth(Convert.ToInt32(strArray[0]), Convert.ToInt32(strArray[1]));
newWorkCalendar.UpTime = monthDay - (workCalendar.TrialTime + workCalendar.Holiday + workCalendar.HaltTime);
}
newWorkCalendar.TrialTime = workCalendar.TrialTime;
newWorkCalendar.Holiday = workCalendar.Holiday;
newWorkCalendar.HaltTime = workCalendar.HaltTime;
genericMgr.Update(newWorkCalendar);
SearchStatementModel searchStatementModel = PrepareSearchMIStatement(command, searchModel);
return PartialView(GetAjaxPageData<WorkCalendar>(searchStatementModel, command));
}
public ActionResult _AjaxList(GridCommand command, WorkCalendarSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
GridModel<WorkCalendar> WorkCalendarList = GetAjaxPageData<WorkCalendar>(searchStatementModel, command);
foreach (var WorkCalendar in WorkCalendarList.Data)
{
WorkCalendar.UpTime = Math.Round(WorkCalendar.UpTime, 3);
WorkCalendar.TrialTime = Math.Round(WorkCalendar.TrialTime, 3);
WorkCalendar.HaltTime = Math.Round(WorkCalendar.HaltTime, 3);
WorkCalendar.Holiday = Math.Round(WorkCalendar.Holiday, 3);
}
return PartialView(WorkCalendarList);
}
private SearchStatementModel PrepareSearchMIStatement(GridCommand command, WorkCalendarSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
whereStatement += " where exists (select 1 from FlowMaster s where s.ResourceGroup=? and w.Flow=s.Code) ";
param.Add((int)com.Sconit.CodeMaster.ResourceGroup.MI);
if (searchModel.DateType == (int)com.Sconit.CodeMaster.TimeUnit.Day)
{
HqlStatementHelper.AddEqStatement("DateType", com.Sconit.CodeMaster.TimeUnit.Day, "w", ref whereStatement, param);
HqlStatementHelper.AddBetweenStatement("DateIndex", searchModel.DateIndexDate.Value.ToString("yyyy-MM-dd"), searchModel.DateIndexToDate.Value.ToString("yyyy-MM-dd"), "w", ref whereStatement, param);
}
else
{
if (string.IsNullOrWhiteSpace(searchModel.DateIndexTo))
{
searchModel.DateIndexTo = "9999-01";
}
HqlStatementHelper.AddEqStatement("DateType", searchModel.DateType, "w", ref whereStatement, param);
HqlStatementHelper.AddBetweenStatement("DateIndex", searchModel.DateIndex, searchModel.DateIndexTo, "w", ref whereStatement, param);
}
HqlStatementHelper.AddEqStatement("Flow", searchModel.ProductLine, "w", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountStatement;
searchStatementModel.SelectStatement = selectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _GetWorkCalendarMiList(WorkCalendarSearchModel searchModel)
{
ViewBag.PageSize = 20;
ViewBag.ProductLine = searchModel.ProductLine;
ViewBag.DateType = searchModel.DateType;
ViewBag.DateIndexDate = searchModel.DateIndexDate;
ViewBag.DateIndexTo = searchModel.DateIndexTo;
ViewBag.DateIndexToDate = searchModel.DateIndexToDate;
ViewBag.DateIndex = searchModel.DateIndex;
return PartialView();
}
