public ActionResult List(GridCommand command, PickListSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (this.CheckSearchModelIsNull(searchCacheModel.SearchObject))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage(Resources.ErrorMessage.Errors_NoConditions);
}
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public void ExportMstr(PickListSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value;
if (!this.CheckSearchModelIsNull(searchModel))
{
return ;
}
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
ExportToXLS<PickListMaster>("PickListMaster.xls", GetAjaxPageData<PickListMaster>(searchStatementModel, command).Data.ToList());
}
private string PrepareSearchDetailStatement(GridCommand command, PickListSearchModel searchModel)
{
StringBuilder Sb = new StringBuilder();
string whereStatement = " select d from PickListDetail as d where exists (select 1 from PickListMaster as o"
+ " where o.PickListNo=d.PickListNo ";
Sb.Append(whereStatement);
if (searchModel.Flow != null)
{
Sb.Append(string.Format(" and o.Flow = '{0}'", searchModel.Flow));
}
if (searchModel.Status != null)
{
Sb.Append(string.Format(" and o.Status = '{0}'", searchModel.Status));
}
if (!string.IsNullOrEmpty(searchModel.PickListNo))
{
Sb.Append(string.Format(" and o.PickListNo like '%{0}%'", searchModel.PickListNo));
}
if (!string.IsNullOrEmpty(searchModel.PartyFrom))
{
Sb.Append(string.Format(" and o.PartyFrom = '{0}'", searchModel.PartyFrom));
}
if (!string.IsNullOrEmpty(searchModel.PartyTo))
{
Sb.Append(string.Format(" and o.PartyTo = '{0}'", searchModel.PartyTo));
}
string str = Sb.ToString();
//SecurityHelper.AddPartyFromPermissionStatement(ref str, "o", "PartyFrom", com.Sconit.CodeMaster.OrderType.Procurement, true);
SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref str, "o", "Type", "o", "PartyFrom", "o", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true);
if (searchModel.StartTime != null & searchModel.EndTime != null)
{
Sb.Append(string.Format(" and o.CreateDate between '{0}' and '{1}'", searchModel.StartTime, searchModel.EndTime));
}
else if (searchModel.StartTime != null & searchModel.EndTime == null)
{
Sb.Append(string.Format(" and o.CreateDate >= '{0}'", searchModel.StartTime));
}
else if (searchModel.StartTime == null & searchModel.EndTime != null)
{
Sb.Append(string.Format(" and o.CreateDate <= '{0}'", searchModel.EndTime));
}
Sb.Append(" )");
if (!string.IsNullOrEmpty(searchModel.Item))
{
Sb.Append(string.Format(" and d.Item like '{0}%' ", searchModel.Item));
}
if (searchModel.Type.HasValue && searchModel.Type > 0)
{
Sb.Append(string.Format(" and d.OrderType ='{0}' ", searchModel.Type));
}
return Sb.ToString();
}
public void Export(PickListSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
command.Page = 1;
command.PageSize = !this.CheckSearchModelIsNull(searchCacheModel.SearchObject) ? 0 : value;
TempData["_AjaxMessage"] = "";
IList<PickListDetail> lists = genericMgr.FindAll<PickListDetail>(PrepareSearchDetailStatement(command, searchModel));
if (lists.Count > value)
{
SaveWarningMessage(string.Format(Resources.EXT.ControllerLan.Con_DataExceedRow, value));
}
var listItemCount = lists.GroupBy(p => p.Item, (k, g) => new { k, g })
.ToDictionary(d => d.k, d => d.g.Count());
foreach (var list in lists)
{
list.ItemCount = listItemCount.Where(p => p.Key == list.Item).FirstOrDefault().Value;
}
lists = lists.OrderBy(o => o.Item).ToList();
ExportToXLS<PickListDetail>("PickListDetail.xls", lists);
}
public ActionResult DetailList(GridCommand command, PickListSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (this.CheckSearchModelIsNull(searchCacheModel.SearchObject))
{
TempData["_AjaxMessage"] = "";
IList<PickListDetail> list = genericMgr.FindAll<PickListDetail>(PrepareSearchDetailStatement(command, searchModel)); //GetPageData<OrderDetail>(searchStatementModel, command);
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
if (list.Count > value)
{
SaveWarningMessage(string.Format(Resources.EXT.ControllerLan.Con_DataExceedRow, value));
}
return View(list.Take(value));
}
else
{
SaveWarningMessage(Resources.SYS.ErrorMessage.Errors_NoConditions);
return View(new List<PickListDetail>());
}
}
private SearchStatementModel PrepareShipSearchStatement(GridCommand command, PickListSearchModel searchModel)
{
string whereStatement = " where p.Status =" + (int)com.Sconit.CodeMaster.PickListStatus.InProcess;
IList<object> param = new List<object>();
HqlStatementHelper.AddLikeStatement("PickListNo", searchModel.PickListNo, HqlStatementHelper.LikeMatchMode.Start, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "p", ref whereStatement, param);
if (searchModel.StartTime != null & searchModel.EndTime != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "p", ref whereStatement, param);
}
else if (searchModel.StartTime != null & searchModel.EndTime == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "p", ref whereStatement, param);
}
else if (searchModel.StartTime == null & searchModel.EndTime != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "p", ref whereStatement, param);
}
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "OrderTypeDescription")
{
command.SortDescriptors[0].Member = "OrderType";
}
else if (command.SortDescriptors[0].Member == "OrderStatusDescription")
{
command.SortDescriptors[0].Member = "Status";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by p.CreateDate desc";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountStatement;
searchStatementModel.SelectStatement = selectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, PickListSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "pl", "OrderType", "pl", "PartyFrom", "pl", "PartyTo", com.Sconit.CodeMaster.OrderType.Distribution, false);
// It should be logic "and" between checking pemission hql commands and other search condition(PickListNo,Status...etc)
//whereStatement = whereStatement.Insert(6, " (") + ")";
HqlStatementHelper.AddLikeStatement("PickListNo", searchModel.PickListNo, HqlStatementHelper.LikeMatchMode.End, "pl", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.End, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "pl", ref whereStatement, param);
if (searchModel.StartTime != null & searchModel.EndTime != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "pl", ref whereStatement, param);
}
else if (searchModel.StartTime != null & searchModel.EndTime == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "pl", ref whereStatement, param);
}
else if (searchModel.StartTime == null & searchModel.EndTime != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "pl", ref whereStatement, param);
}
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "OrderTypeDescription")
{
command.SortDescriptors[0].Member = "OrderType";
}
else if (command.SortDescriptors[0].Member == "OrderStatusDescription")
{
command.SortDescriptors[0].Member = "Status";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by pl.CreateDate desc";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = "select count(*) from PickListMaster as pl";
searchStatementModel.SelectStatement = "select pl from PickListMaster as pl";
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxShipList(GridCommand command, PickListSearchModel searchModel)
{
string replaceFrom = "_AjaxShipList";
string replaceTo = "ShipList";
this.GetCommand(ref command, searchModel, replaceFrom, replaceTo);
SearchStatementModel searchStatementModel = this.PrepareShipSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<PickListMaster>(searchStatementModel, command));
}
public ActionResult _AjaxList(GridCommand command, PickListSearchModel searchModel)
{
this.GetCommand(ref command, searchModel);
if (!this.CheckSearchModelIsNull(searchModel))
{
return PartialView(new GridModel(new List<OrderMaster>()));
}
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<PickListMaster>(searchStatementModel, command));
}
public ActionResult ShipList(GridCommand command, PickListSearchModel searchModel)
{
SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel);
if (searchCacheModel.isBack == true)
{
ViewBag.Page = searchCacheModel.Command.Page == 0 ? 1 : searchCacheModel.Command.Page;
}
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult _AjaxShipList(GridCommand command, PickListSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareShipSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<PickListMaster>(searchStatementModel, command));
}
public ActionResult ShipList(GridCommand command, PickListSearchModel searchModel)
{
SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel);
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, PickListSearchModel searchModel)
{
string whereStatement = " where 1=1 ";
if (!string.IsNullOrWhiteSpace(searchModel.Item))
{
whereStatement += " and exists( select 1 from PickListDetail as d where d.PickListNo=pl.PickListNo and d.Item='"+searchModel.Item+"' ) ";
}
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("PickListNo", searchModel.PickListNo, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "pl", ref whereStatement, param);
//HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "pl", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("DeliveryGroup", searchModel.DeliveryGroup, "pl", ref whereStatement, param);
if (searchModel.IsPrint)
{
HqlStatementHelper.AddEqStatement("IsPrintAsn", searchModel.IsPrint, "pl", ref whereStatement, param);
}
if (searchModel.StartTime != null & searchModel.EndTime != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "pl", ref whereStatement, param);
}
else if (searchModel.StartTime != null & searchModel.EndTime == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "pl", ref whereStatement, param);
}
else if (searchModel.StartTime == null & searchModel.EndTime != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "pl", ref whereStatement, param);
}
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "OrderTypeDescription")
{
command.SortDescriptors[0].Member = "OrderType";
}
else if (command.SortDescriptors[0].Member == "OrderStatusDescription")
{
command.SortDescriptors[0].Member = "Status";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by pl.CreateDate desc";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = "select count(*) from PickListMaster as pl";
searchStatementModel.SelectStatement = "select pl from PickListMaster as pl";
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
