public ActionResult List(GridCommand command, PickTaskSearchModel searchModel)
{
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
ViewBag.SearchModel = searchModel;
return View();
}
public ActionResult _AjaxList(GridCommand command, PickTaskSearchModel searchModel)
{
if (String.IsNullOrEmpty(searchModel.LocationFrom))
{
return PartialView(new GridModel(new List<PickTask>()));
}
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<PickTask>(searchStatementModel, command));
}
public ActionResult List(GridCommand command, PickTaskSearchModel searchModel)
{
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (String.IsNullOrEmpty(searchModel.LocationFrom))
{
SaveWarningMessage("请选择来源库位!");
}
ViewBag.SearchModel = searchModel;
return View();
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, PickTaskSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("PickId", searchModel.PickId, "c", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = "select count(*) from PickResult c";
searchStatementModel.SelectStatement = "select c from PickResult as c";
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, PickTaskSearchModel searchModel)
{
string whereStatement = string.Empty;
if (!searchModel.IncludeFinished)
{
whereStatement += " where c.OrderedQty > c.PickedQty ";
}
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("PickId", searchModel.PickId, "c", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("LocationFrom", searchModel.LocationFrom, "c", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("OrderNo", searchModel.OrderNo, "c", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Picker", searchModel.Picker, "c", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "c", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "c", ref whereStatement, param);
//HqlStatementHelper.AddEqStatement("IncludeFinished", searchModel.IncludeFinished, "c", ref whereStatement, param);
if (searchModel.ReleaseStart != null)
{
HqlStatementHelper.AddGeStatement("ReleaseDate", searchModel.ReleaseStart.Value, "c", ref whereStatement, param);
}
if (searchModel.ReleaseEnd != null)
{
HqlStatementHelper.AddLtStatement("ReleaseDate", searchModel.ReleaseEnd.Value, "c", ref whereStatement, param);
}
if (searchModel.WindowStart != null)
{
HqlStatementHelper.AddGeStatement("WindowTime", searchModel.WindowStart.Value, "c", ref whereStatement, param);
}
if (searchModel.WindowEnd != null)
{
HqlStatementHelper.AddLtStatement("WindowTime", searchModel.WindowEnd.Value, "c", ref whereStatement, param);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = "select count(*) from PickTask c";
searchStatementModel.SelectStatement = "select c from PickTask as c";
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxList(GridCommand command, PickTaskSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<PickResult>(searchStatementModel, command));
}
public ActionResult _AjaxListOrderDetail(GridCommand command, PickTaskSearchModel searchModel)
{
string whereStatement = "select c.* from view_orderdet c inner join view_ordermstr o on c.orderno = o.orderno where "
+ "(o.Status = " + (int)CodeMaster.OrderStatus.Submit
+ " or o.Status = "
+ (int)CodeMaster.OrderStatus.InProcess
+ ") and c.orderno = '" + searchModel.OrderNo
+ "' and not exists (select 1 from ord_picktask as s where s.orddetid = c.id)";
IList<OrderDetail> ods = base.genericMgr.FindEntityWithNativeSql<OrderDetail>(whereStatement);
GridModel<OrderDetail> GridModel = new GridModel<OrderDetail>();
GridModel.Total = ods.Count;
GridModel.Data = ods;
ViewBag.Total = GridModel.Total;
return PartialView(GridModel);
}
public ActionResult _AjaxListHandle(GridCommand command, PickTaskSearchModel searchModel)
{
if (String.IsNullOrEmpty(searchModel.LocationFrom))
{
return PartialView(new GridModel(new List<PickTask>()));
}
//SearchStatementModel searchStatementModel = this.PrepareHandleSearchStatement(command, searchModel);
//return PartialView(GetAjaxPageData<PickTask>(searchStatementModel, command));
string whereStatement = "select c.* from ord_picktask c inner join view_ordermstr o on c.orderno = o.orderno where "
+ "(o.Status = " + (int)CodeMaster.OrderStatus.Submit
+ " or o.Status = "
+ (int)CodeMaster.OrderStatus.InProcess
+ ") and c.orderedqty > c.pickedqty ";
if (searchModel.ShowHold)
{
whereStatement += " and c.IsHold = 1 ";
}
else
{
whereStatement += " and c.IsHold = 0 ";
}
if (!String.IsNullOrEmpty(searchModel.PickId)) {
whereStatement += " and c.PickId = '" + searchModel.PickId + "'";
}
if (!String.IsNullOrEmpty(searchModel.LocationFrom))
{
whereStatement += " and c.LocationFrom = '" + searchModel.LocationFrom + "'";
}
if (!String.IsNullOrEmpty(searchModel.OrderNo))
{
whereStatement += " and c.OrderNo = '" + searchModel.OrderNo + "'";
}
if (!String.IsNullOrEmpty(searchModel.Picker))
{
whereStatement += " and c.Picker = '" + searchModel.Picker + "'";
}
if (!String.IsNullOrEmpty(searchModel.Item))
{
whereStatement += " and c.Item = '" + searchModel.Item + "'";
}
if (!String.IsNullOrEmpty(searchModel.Flow))
{
whereStatement += " and c.Flow = '" + searchModel.Flow + "'";
}
if (searchModel.ReleaseStart != null)
{
whereStatement += " and c.ReleaseDate >= '" + searchModel.ReleaseStart + "'";
}
if (searchModel.ReleaseEnd != null)
{
whereStatement += " and c.ReleaseDate < '" + searchModel.ReleaseEnd + "'";
}
if (searchModel.WindowStart != null)
{
whereStatement += " and c.WindowTime >= '" + searchModel.WindowStart + "'";
}
if (searchModel.WindowEnd != null)
{
whereStatement += " and c.WindowTime < '" + searchModel.WindowEnd + "'";
}
IList<PickTask> pts = base.genericMgr.FindEntityWithNativeSql<PickTask>(whereStatement);
foreach(PickTask pt in pts)
{
pt.NewPicker = pickTaskMgr.GetDefaultPicker(pt);
}
GridModel<PickTask> GridModel = new GridModel<PickTask>();
GridModel.Total = pts.Count;
GridModel.Data = pts;
ViewBag.Total = GridModel.Total;
return PartialView(GridModel);
}