private SearchStatementModel PrepareSearchStatement(GridCommand command, FlowItemSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "d", ref whereStatement, param);
string sortingStatement = string.Empty;
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by CreateDate desc";
}
else
{
sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = "select count(*) from FlowDetail as d";
searchStatementModel.SelectStatement = "select d from FlowDetail as d";
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _SearchResult(GridCommand command, FlowItemSearchModel searchModel)
{
ViewBag.Item = searchModel.Item;
ViewBag.Flow = searchModel.Flow;
ViewBag.SearchType = searchModel.SearchType;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return PartialView();
}
public ActionResult _AjaxList(GridCommand command, FlowItemSearchModel searchModel)
{
var itemlist = itemMgr.GetCacheAllItem();
if (searchModel.SearchType == "searchFlow")
{
GridModel<FlowDetail> flowList = new GridModel<FlowDetail>();
var flowMasterList = this.genericMgr.FindAll<FlowMaster>
(" from FlowMaster where code like ? ", "%" + searchModel.Flow + "%");
var flowDetails = new List<FlowDetail>();
foreach (var flowMaster in flowMasterList)
{
flowDetails.AddRange(flowMgr.GetFlowDetailList(flowMaster.Code));
}
foreach (var flowDetail in flowDetails)
{
var item = itemMgr.GetCacheItem(flowDetail.Item);
flowDetail.WarnLeadTime = item.WarnLeadTime;
flowDetail.Warranty = item.Warranty;
flowDetail.ItemDescription = item.FullDescription;
}
FillFlowDetial(flowDetails);
foreach (var flowDetail in flowDetails)
{
flowDetail.ItemDescription = itemlist.ValueOrDefault(flowDetail.Item).FullDescription;
}
flowList.Total = flowDetails.Count();
flowList.Data = flowDetails;
return PartialView(flowList);
}
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<FlowDetail> List = GetAjaxPageData<FlowDetail>(searchStatementModel, command);
FillFlowDetial(List.Data);
foreach (var list in List.Data)
{
list.ItemDescription = itemlist.ValueOrDefault(list.Item).FullDescription;
}
return PartialView(List);
}
public ActionResult _ScmModelResult(FlowItemSearchModel searchModel)
{
SearchStatementModel searchStatementModel = PrepareSearchStatement(new GridCommand(), searchModel);
GridModel<FlowDetail> List = GetAjaxPageData<FlowDetail>(searchStatementModel, null);
FillFlowDetial(List.Data);
return View(List.Data);
}
