public ActionResult List(GridCommand command, OrderMasterSearchModel searchModel) { SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel); ViewBag.PageSize = this.ProcessPageSize(command.PageSize); return(View()); }
public ActionResult Ship(GridCommand command, OrderMasterSearchModel searchModel) { if (string.IsNullOrWhiteSpace(searchModel.OrderNo) && string.IsNullOrWhiteSpace(searchModel.Flow) && (string.IsNullOrWhiteSpace(searchModel.PartyFrom) || string.IsNullOrWhiteSpace(searchModel.PartyTo)) && string.IsNullOrEmpty(searchModel.Dock)) { SaveWarningMessage("请选择查询条件"); } TempData["OrderMasterSearchModel"] = searchModel; ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return(View()); }
public ActionResult _AjaxShipOrderList(GridCommand command, OrderMasterSearchModel searchModel) { if (string.IsNullOrWhiteSpace(searchModel.OrderNo) && string.IsNullOrWhiteSpace(searchModel.Flow) && (string.IsNullOrWhiteSpace(searchModel.PartyFrom) || string.IsNullOrWhiteSpace(searchModel.PartyTo)) && string.IsNullOrEmpty(searchModel.Dock)) { return(PartialView(new GridModel(new List <OrderMaster>()))); } else { ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchStatement_1(command, searchModel); //SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); return(PartialView(GetAjaxPageDataProcedure <OrderMaster>(procedureSearchStatementModel, command))); } }
private SearchStatementModel PrepareShipSearchStatement(GridCommand command, OrderMasterSearchModel searchModel) { string whereStatement = " where o.Type in (" + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract + ")" + " and o.IsShipScanHu = 0 and o.Status in (" + (int)com.Sconit.CodeMaster.OrderStatus.Submit + "," + (int)com.Sconit.CodeMaster.OrderStatus.InProcess + ")" + " and o.SubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and exists (select 1 from OrderDetail as d where d.ShippedQty < d.OrderedQty and d.OrderNo = o.OrderNo) "; //SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "o", "PartyFrom", com.Sconit.CodeMaster.OrderType.Procurement, true); SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "o", "Type", "o", "PartyFrom", "o", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true); IList <object> param = new List <object>(); if (!string.IsNullOrEmpty(searchModel.OrderNo)) { HqlStatementHelper.AddLikeStatement("OrderNo", searchModel.OrderNo, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param); } else if (!string.IsNullOrEmpty(searchModel.Flow)) { HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "o", ref whereStatement, param); } else if (!string.IsNullOrEmpty(searchModel.PartyFrom) && !string.IsNullOrEmpty(searchModel.PartyTo)) { HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "o", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "o", ref whereStatement, param); } else if (!string.IsNullOrEmpty(searchModel.Dock)) { HqlStatementHelper.AddLikeStatement("Dock", searchModel.Dock, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by 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, OrderMasterSearchModel searchModel) { string whereStatement = " where o.Type in (" + (int)com.Sconit.CodeMaster.OrderType.Distribution + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")" + " and o.SubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal; IList <object> param = new List <object>(); HqlStatementHelper.AddLikeStatement("OrderNo", searchModel.OrderNo, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "o", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "o", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "o", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("CreateUserName", searchModel.CreateUserName, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "o", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Priority", searchModel.Priority, "o", ref whereStatement, param); //SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "o", "PartyFrom", com.Sconit.CodeMaster.OrderType.Procurement, true); SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "o", "Type", "o", "PartyFrom", "o", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true); if (searchModel.DateFrom != null & searchModel.DateTo != null) { HqlStatementHelper.AddBetweenStatement("StartTime", searchModel.DateFrom, searchModel.DateTo, "o", ref whereStatement, param); } else if (searchModel.DateFrom != null & searchModel.DateTo == null) { HqlStatementHelper.AddGeStatement("StartTime", searchModel.DateFrom, "o", ref whereStatement, param); } else if (searchModel.DateFrom == null & searchModel.DateTo != null) { HqlStatementHelper.AddLeStatement("StartTime", searchModel.DateTo, "o", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountStatement; searchStatementModel.SelectStatement = selectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray <object>(); return(searchStatementModel); }
public ActionResult _AjaxOrderDetailList(GridCommand command, OrderMasterSearchModel searchModel) { com.Sconit.Entity.ACC.User user = SecurityContextHolder.Get(); IList <OrderMaster> orderMasterList = null; if (user.Code.Trim().ToLower() != "su") { orderMasterList = base.genericMgr.FindAll <OrderMaster>("from OrderMaster as o where o.OrderNo=? and exists (select 1 from UserPermissionView as up where up.UserId =" + user.Id + " and up.PermissionCategoryType = " + (int)com.Sconit.CodeMaster.PermissionCategoryType.Supplier + " and up.PermissionCode = o.PartyFrom)", searchModel.OrderNo); if (orderMasterList.Count <= 0) { return(PartialView(new GridModel(new List <OrderDetail>()))); } } SearchStatementModel searchStatementModel = PrepareOrderDetailSearchStatement(command, searchModel); GridModel <OrderDetail> List = GetAjaxPageData <OrderDetail>(searchStatementModel, command); try { foreach (OrderDetail orderDetail in List.Data) { orderDetail.LotNo = LotNoHelper.GenerateLotNo(); } OrderMaster order = base.genericMgr.FindById <OrderMaster>(searchModel.OrderNo); foreach (OrderDetail orderDetail in List.Data) { orderDetail.ManufactureParty = order.PartyFrom; orderDetail.HuQty = orderDetail.OrderedQty; } return(View(List)); } catch (Exception) { return(PartialView(new GridModel(new List <IpLocationDetail>()))); } }
private ProcedureSearchStatementModel PrepareSearchStatement_1(GridCommand command, OrderMasterSearchModel searchModel) { string whereStatement = string.Format(" and o.IsShipScanHu = 0 and o.Status in ('{0}','{1}') and o.SubType='{2}' and exists (select 1 from OrderDetail as d where d.ShipQty < d.OrderQty and d.OrderNo = o.OrderNo) ", (int)com.Sconit.CodeMaster.OrderStatus.Submit, (int)com.Sconit.CodeMaster.OrderStatus.InProcess, (int)com.Sconit.CodeMaster.OrderSubType.Normal); List <ProcedureParameter> paraList = new List <ProcedureParameter>(); List <ProcedureParameter> pageParaList = new List <ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.SubType, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Priority, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ExternalOrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ReferenceOrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.TraceCode, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.CreateUserName, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.DateFrom, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.DateTo, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartTime, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndTime, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WindowTimeFrom, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WindowTimeTo, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Sequence, Type = NHibernate.NHibernateUtil.Int64 }); paraList.Add(new ProcedureParameter { Parameter = false, Type = NHibernate.NHibernateUtil.Boolean }); paraList.Add(new ProcedureParameter { Parameter = true, Type = NHibernate.NHibernateUtil.Boolean }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "OrderTypeDescription") { command.SortDescriptors[0].Member = "Type"; } else if (command.SortDescriptors[0].Member == "OrderPriorityDescription") { command.SortDescriptors[0].Member = "Priority"; } else if (command.SortDescriptors[0].Member == "OrderStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_ProcurementOrderCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_ProcurementOrder"; return(procedureSearchStatementModel); }
public ActionResult _AjaxBatchProcessList(GridCommand command, OrderMasterSearchModel searchModel) { SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); return(PartialView(GetAjaxPageData <OrderMaster>(searchStatementModel, command))); }
private SearchStatementModel PrepareOrderDetailSearchStatement(GridCommand command, OrderMasterSearchModel searchModel) { string whereStatement = string.Empty; IList <object> param = new List <object>(); HqlStatementHelper.AddEqStatement("OrderNo", searchModel.OrderNo, "o", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectOrderCountStatement; searchStatementModel.SelectStatement = selectOrderStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray <object>(); return(searchStatementModel); }