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(); }