public ActionResult _AjaxTaskStatusList(GridCommand command, TaskStatusSearchModel searchModel, string taskCode)
{
ViewBag.TaskCode = taskCode;
SearchStatementModel searchStatementModel = PrepareSearchTaskStatusStatement(command, searchModel, taskCode);
return PartialView(GetAjaxPageData<TaskStatus>(searchStatementModel, command));
}
private SearchStatementModel PrepareSearchTaskStatusStatement(GridCommand command, TaskStatusSearchModel searchModel, string taskCode)
{
string whereStatement = " where t.TaskCode ='" + taskCode + "'";
IList<object> param = new List<object>();
//HqlStatementHelper.AddLikeStatement("Party", searchModel.Party, HqlStatementHelper.LikeMatchMode.Anywhere, "pa", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("Description", searchModel.Description, HqlStatementHelper.LikeMatchMode.Start, "t", ref whereStatement, param);
if (searchModel.StartDate != null)
{
HqlStatementHelper.AddGeStatement("StartDate", searchModel.StartDate.Value, "t", ref whereStatement, param);
}
if (searchModel.EndDate != null)
{
HqlStatementHelper.AddLeStatement("StartDate", searchModel.EndDate.Value, "t", ref whereStatement, param);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectTaskStatusCountStatement;
searchStatementModel.SelectStatement = selectTaskStatusStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _TaskStatusList(GridCommand command, TaskStatusSearchModel searchModel, string taskCode)
{
ViewBag.TaskCode = taskCode;
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
ViewBag.PageSize = this.ProcessPageSize(command.PageSize);
return PartialView();
}