Ejemplo n.º 1
0
        public ActionResult List(GridCommand command, OrderMasterSearchModel searchModel)
        {
            SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel);

            ViewBag.PageSize = this.ProcessPageSize(command.PageSize);
            return(View());
        }
Ejemplo n.º 2
0
 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());
 }
Ejemplo n.º 3
0
 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)));
     }
 }
Ejemplo n.º 4
0
        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);
        }
Ejemplo n.º 5
0
        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);
        }
Ejemplo n.º 6
0
        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>())));
            }
        }
Ejemplo n.º 7
0
        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);
        }
Ejemplo n.º 8
0
        public ActionResult _AjaxBatchProcessList(GridCommand command, OrderMasterSearchModel searchModel)
        {
            SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);

            return(PartialView(GetAjaxPageData <OrderMaster>(searchStatementModel, command)));
        }
Ejemplo n.º 9
0
        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);
        }