public ActionResult InstanceList(GridCommand command, MachineInstanceSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
ViewBag.DateType = searchModel.DateType == null ? null : searchModel.DateType.ToString();
return View();
}
public void ExportXLS(MachineInstanceSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(com.Sconit.Entity.SYS.EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = value;
SearchStatementModel searchStatementModel = this.PrepareInstanceSearchStatement(command, searchModel);
var fileName = string.Format("FICalendar.xls");
ExportToXLS<SnapMachine>(fileName, GetAjaxPageData<SnapMachine>(searchStatementModel, command).Data.ToList());
}
public ActionResult _AjaxInstanceList(GridCommand command, MachineInstanceSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareInstanceSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<SnapMachine>(searchStatementModel, command));
}
private SearchStatementModel PrepareInstanceSearchStatement(GridCommand command, MachineInstanceSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
if (searchModel.DateType != null)
{
if (searchModel.DateType.Value == 4)
{
if (searchModel.DateIndexDate != null & searchModel.DateIndexToDate != null)
{
HqlStatementHelper.AddBetweenStatement("DateIndex", searchModel.DateIndexDate.Value.ToString("yyyy-MM-dd"), searchModel.DateIndexToDate.Value.ToString("yyyy-MM-dd"), "m", ref whereStatement, param);
}
else if (searchModel.DateIndexDate != null & searchModel.DateIndexToDate == null)
{
HqlStatementHelper.AddGeStatement("DateIndex", searchModel.DateIndexDate.Value.ToString("yyyy-MM-dd"), "m", ref whereStatement, param);
}
else if (searchModel.DateIndexDate == null & searchModel.DateIndexToDate != null)
{
HqlStatementHelper.AddLeStatement("DateIndex", searchModel.DateIndexToDate.Value.ToString("yyyy-MM-dd"), "m", ref whereStatement, param);
}
}
else
{
if (!string.IsNullOrEmpty(searchModel.DateIndex) & !string.IsNullOrEmpty(searchModel.DateIndexTo))
{
HqlStatementHelper.AddBetweenStatement("DateIndex", searchModel.DateIndex, searchModel.DateIndexTo, "m", ref whereStatement, param);
}
else if (!string.IsNullOrEmpty(searchModel.DateIndex) & string.IsNullOrEmpty(searchModel.DateIndexTo))
{
HqlStatementHelper.AddGeStatement("DateIndex", searchModel.DateIndex, "m", ref whereStatement, param);
}
else if (string.IsNullOrEmpty(searchModel.DateIndex) & !string.IsNullOrEmpty(searchModel.DateIndexTo))
{
HqlStatementHelper.AddLeStatement("DateIndex", searchModel.DateIndexTo, "m", ref whereStatement, param);
}
}
}
HqlStatementHelper.AddEqStatement("Code", searchModel.Code, "m", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("MachineType", searchModel.MachineType, "m", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("SnapTime", searchModel.SnapTime, "m", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Region", searchModel.Region, "m", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("ShiftType", searchModel.ShiftType, "m", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("DateType", searchModel.DateType, "m", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by m.Code desc";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountInstanceStatement;
searchStatementModel.SelectStatement = selectInstanceStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}