private SearchStatementModel PrepareBindedSearchStatement(GridCommand command, FlowBindModel searchModel, string id)
{
string whereStatement = " where bf.Code='" + id + "'";
IList<object> param = new List<object>();
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountBindStatement;
searchStatementModel.SelectStatement = selectBindStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
private SearchStatementModel PrepareBindSearchStatement(GridCommand command, FlowBindModel searchModel, string id)
{
string whereStatement = " where mf.Code='" + id + "'";
IList<object> param = new List<object>();
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "BindedFlow.Code")
{
command.SortDescriptors[0].Member = "bf.Code";
}
else if (command.SortDescriptors[0].Member == "BindedFlow.Description")
{
command.SortDescriptors[0].Member = "bf.Description";
}
else if (command.SortDescriptors[0].Member == "BindTypeDescription")
{
command.SortDescriptors[0].Member = "f.BindType";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountBindStatement;
searchStatementModel.SelectStatement = selectBindStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _Binded(GridCommand command, FlowBindModel searchModel, string id)
{
if (string.IsNullOrWhiteSpace(id))
{
return HttpNotFound();
}
ViewBag.flow = id;
searchModel.BindedFlow = id;
TempData["FlowBindModel"] = searchModel;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return PartialView();
}
public ActionResult _AjaxBinded(GridCommand command, FlowBindModel searchModel, string id)
{
SearchStatementModel searchStatementModel = PrepareBindedSearchStatement(command, searchModel, id);
return PartialView(GetAjaxPageData<FlowBinding>(searchStatementModel, command));
}
public ActionResult _Binded(GridCommand command, FlowBindModel searchModel, string id)
{
if (string.IsNullOrWhiteSpace(id))
{
return HttpNotFound();
}
ViewBag.flow = id;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel);
SearchStatementModel searchStatementModel = PrepareBindedSearchStatement(command, (FlowBindModel)searchCacheModel.SearchObject, id);
return PartialView(GetPageData<FlowBinding>(searchStatementModel, command));
}
