public ActionResult _AjaxRoutingDetailList(GridCommand command, RoutingDetailSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.RoutingDetailPrepareSearchStatement(command, searchModel, searchModel.routingMasterCode);
return PartialView(GetAjaxPageData<RoutingDetail>(searchStatementModel, command));
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">RoutingDetail Search Model</param>
/// <param name="routingMasterCode">routingMaster Code</param>
/// <returns>Search Statement</returns>
private SearchStatementModel RoutingDetailPrepareSearchStatement(GridCommand command, RoutingDetailSearchModel searchModel, string routingMasterCode)
{
string whereStatement = "where r.Routing = '" + routingMasterCode + "'";
IList<object> param = new List<object>();
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "TimeUnitDescription")
{
command.SortDescriptors[0].Member = "TimeUnit";
}
}
HqlStatementHelper.AddEqStatement("Operation", searchModel.Operation, "r", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = routingDetailSelectCountStatement;
searchStatementModel.SelectStatement = routingDetailSelectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult RoutingDetailResult(GridCommand command, RoutingDetailSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return PartialView();
}