示例#1
1
        public ActionResult BulkEditSave(GridCommand command,
            [Bind(Prefix = "updated")]IEnumerable<PluginModel> updatedPlugins)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManagePlugins))
                return AccessDeniedView();

            //bool changed = false;
            if (updatedPlugins != null)
            {
                foreach (var pluginModel in updatedPlugins)
                {
                    //update
                    var pluginDescriptor = _pluginFinder.GetPluginDescriptorBySystemName(pluginModel.SystemName, false);
                    if (pluginDescriptor != null)
                    {
                        //we allow editing of 'friendly name' and 'display order'
                        pluginDescriptor.FriendlyName = pluginModel.FriendlyName;
                        pluginDescriptor.DisplayOrder = pluginModel.DisplayOrder;
                        PluginFileParser.SavePluginDescriptionFile(pluginDescriptor);
                        //changed = true;
                    }
                }
            }

            //if (changed)
                //restart application
                //_webHelper.RestartAppDomain("~/Admin/Plugin/List");

            return BulkEditSelect(command);
        }
        public ActionResult _AjaxList(GridCommand command, WorkingCalendarSearchModel searchModel)
        {
            var objList = this.genericMgr.FindAllWithNativeSql<object[]>("exec USP_Busi_GetWorkingCalendarView ?,?,?,?",
                                                            new object[]
                                                               {
                                                                   searchModel.SearchRegion, "",
                                                                   searchModel.StartWorkingDate, searchModel.EndWorkingDate
                                                               });

            var list = new List<WorkingCalendarView>();
            foreach (var obj in objList)
            {
                var w = obj as object[];
                if (w == null) continue;

                list.Add(new WorkingCalendarView
                             {
                                 Date = (DateTime)w[0],
                                 DateFrom = (DateTime)w[1],
                                 DateTo = (DateTime)w[2]
                             });
            }

            return PartialView(new GridModel(list));
        }
        public ActionResult Configure(GridCommand command)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageTaxSettings))
                return Content("Access denied");

            var tmp = new List<FixedTaxRateModel>();
            foreach (var taxCategory in _taxCategoryService.GetAllTaxCategories())
                tmp.Add(new FixedTaxRateModel()
                {
                    TaxCategoryId = taxCategory.Id,
                    TaxCategoryName = taxCategory.Name,
                    Rate = GetTaxRate(taxCategory.Id)
                });

            var tmp2 = tmp.ForCommand(command);
            var gridModel = new GridModel<FixedTaxRateModel>
            {
                Data = tmp2,
                Total = tmp2.Count()
            };
            return new JsonResult
            {
                Data = gridModel
            };
        }
        public ActionResult List(GridCommand command)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageCustomers))
                return AccessDeniedView();

            var customers = _customerService.GetOnlineCustomers(DateTime.UtcNow.AddMinutes(-_customerSettings.OnlineCustomerMinutes),
                null, command.Page - 1, command.PageSize);
            var model = new GridModel<OnlineCustomerModel>
            {
                Data = customers.Select(x =>
                {
                    return new OnlineCustomerModel()
                    {
                        Id = x.Id,
                        CustomerInfo = x.IsRegistered() ? x.Email : _localizationService.GetResource("Admin.Customers.Guest"),
                        LastIpAddress = x.LastIpAddress,
                        Location = _geoCountryLookup.LookupCountryName(x.LastIpAddress),
                        LastActivityDate = _dateTimeHelper.ConvertToUserTime(x.LastActivityDateUtc, DateTimeKind.Utc),
                        LastVisitedPage = x.GetAttribute<string>(SystemCustomerAttributeNames.LastVisitedPage)
                    };
                }),
                Total = customers.TotalCount
            };
            return new JsonResult
            {
                Data = model
            };
        }
        public ActionResult RoutingMasterList(GridCommand command, RoutingMasterSearchModel searchModel)
        {

            SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
            ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
            return View();
        }
        public ActionResult AffiliatedCustomerList(int affiliateId, GridCommand command)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageAffiliates))
                return AccessDeniedView();

            var affiliate = _affiliateService.GetAffiliateById(affiliateId);
            if (affiliate == null)
                throw new ArgumentException("No affiliate found with the specified id");

            var customers = _customerService.GetAllCustomers(
                affiliateId: affiliate.Id,
                pageIndex: command.Page - 1,
                pageSize: command.PageSize);
            var model = new GridModel<AffiliateModel.AffiliatedCustomerModel>
            {
                Data = customers.Select(customer =>
                    {
                        var customerModel = new AffiliateModel.AffiliatedCustomerModel();
                        customerModel.Id = customer.Id;
                        customerModel.Name = customer.Email;
                        return customerModel;
                    }),
                Total = customers.TotalCount
            };

            return new JsonResult
            {
                Data = model
            };
        }
        public ActionResult Configure(GridCommand command)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageShippingSettings))
                return Content("Access denied");

            var tmp = new List<FixedShippingRateModel>();
            foreach (var shippingMethod in _shippingService.GetAllShippingMethods())
                tmp.Add(new FixedShippingRateModel()
                {
                    ShippingMethodId = shippingMethod.Id,
                    ShippingMethodName = shippingMethod.Name,
                    Rate = GetShippingRate(shippingMethod.Id)
                });

            var tmp2 = tmp.ForCommand(command);
            var gridModel = new GridModel<FixedShippingRateModel>
            {
                Data = tmp2,
                Total = tmp2.Count()
            };
            return new JsonResult
            {
                Data = gridModel
            };
        }
示例#8
1
        public ActionResult _SearchResult(GridCommand command, string item, string supplier, DateTime? dateFrom, DateTime? dateTo)
        {
            string sqlStr = PrepareSearchStatement(command, item, supplier, dateFrom, dateTo);
            IList<object[]> objectList = this.queryMgr.FindAllWithNativeSql<object[]>(sqlStr);

            var inspectDetailList = (from inp in objectList
                                     select new InspectDetail
                                     {
                                         IpNo = (string)inp[0],
                                         ManufactureParty = (string)inp[1],
                                         ManufacturePartyName = (string)inp[2],
                                         Item = (string)inp[3],
                                         ItemDescription = (string)inp[4],
                                         ReferenceItemCode = (string)inp[5],
                                         UnitCount = (decimal)inp[6],
                                         Uom = (string)inp[7],
                                         RejectQty = (decimal)inp[8],
                                         InspectQty = (decimal)inp[9]
                                     }).ToList();

            int count = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
            if (inspectDetailList.Count > count)
            {
                SaveWarningMessage(string.Format(Resources.EXT.ControllerLan.Con_DataExceedRowTheSpecifiedRows, count));
            }
            return View(inspectDetailList.Take(count));
        }
示例#9
1
        public ActionResult _ReturnHierarchyAjax(GridCommand command, string item, string supplier, DateTime? dateFrom, DateTime? dateTo)
        {
            string sqlStr = PrepareReturnSearchStatement(command, item, supplier, dateFrom, dateTo);
            IList<object[]> objectList = this.queryMgr.FindAllWithNativeSql<object[]>(sqlStr);

            var receiveReturnList = (from rr in objectList
                                     select new ReceiveReturnModel
                                     {
                                         Supplier = (string)rr[0],
                                         Item = (string)rr[1],
                                         ReceivedQty = rr[2] == null ? 0 : (decimal)rr[2],
                                         RejectedQty = rr[3] == null ? 0 : (decimal)rr[3],
                                         ItemDescription = (string)rr[4],
                                         ReferenceItemCode = (string)rr[5],
                                         Uom = (string)rr[6],
                                         SupplierName = (string)rr[7]
                                     }).ToList();

            int count = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
            if (receiveReturnList.Count > count)
            {
                SaveWarningMessage(string.Format(Resources.EXT.ControllerLan.Con_DataExceedRowTheSpecifiedRows, count));
            }
            return PartialView(new GridModel(receiveReturnList));
        }
示例#10
1
        public ActionResult _AjaxList(GridCommand command, SearchModel searchModel)
        {

            SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
            GridModel<PostDO> gridlist = GetAjaxPageData<PostDO>(searchStatementModel, command);
            return PartialView(gridlist);
        }
示例#11
1
        private SearchStatementModel PrepareSearchStatement(GridCommand command, SearchModel searchModel)
        {
            string whereStatement = "";

            IList<object> param = new List<object>();
            HqlStatementHelper.AddEqStatement("OrderNo", searchModel.OrderNo, "t", ref whereStatement, param);
            HqlStatementHelper.AddEqStatement("ReceiptNo", searchModel.ReceiptNo, "t", ref whereStatement, param);
            HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "t", ref whereStatement, param);

            if (searchModel.StartDate != null & searchModel.EndDate != null)
            {
                HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "t", ref whereStatement, param);
            }
            else if (searchModel.StartDate != null & searchModel.EndDate == null)
            {
                HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "t", ref whereStatement, param);
            }
            else if (searchModel.StartDate == null & searchModel.EndDate != null)
            {
                HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "t", ref whereStatement, param);
            }
            string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
            if (command.SortDescriptors.Count == 0)
            {
                sortingStatement = " order by t.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 SearchNativeSqlStatementModel PrepareSearchStatement(GridCommand command, CabProductionViewSearchModel searchModel)
        {
            string statement = selectStatement;
            if (!string.IsNullOrWhiteSpace(searchModel.Flow))
            {
                statement += string.Format(" and m.Flow = '{0}'", searchModel.Flow);
            }

            if (searchModel.Type != null)
            {
                statement += string.Format(" and m.Type = {0}", searchModel.Type);
            }

            if (searchModel.IsOut)
            {
                statement += " and exists(select 1 from ORD_OrderMstr_2 m2 where m2.OrderNo = m.ExtOrderNo)";
            }

            string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);

            if (string.IsNullOrEmpty(sortingStatement))
            {
                sortingStatement = " order by ExtSeq asc";
            }
            SearchNativeSqlStatementModel searchStatementModel = new SearchNativeSqlStatementModel();
            searchStatementModel.SelectSql = statement;
            searchStatementModel.SortingStatement = sortingStatement;
            return searchStatementModel;
        }
        public ActionResult TaxRateUpdate(FixedTaxRateModel model, GridCommand command)
        {
            int taxCategoryId = model.TaxCategoryId;
            decimal rate = model.Rate;

            _settingService.SetSetting(string.Format("Tax.TaxProvider.FixedRate.TaxCategoryId{0}", taxCategoryId), rate);

            var tmp = new List<FixedTaxRateModel>();
            foreach (var taxCategory in _taxCategoryService.GetAllTaxCategories())
                tmp.Add(new FixedTaxRateModel()
                {
                    TaxCategoryId = taxCategory.Id,
                    TaxCategoryName = taxCategory.Name,
                    Rate = GetTaxRate(taxCategory.Id)
                });

            var tmp2 = tmp.ForCommand(command);
            var gridModel = new GridModel<FixedTaxRateModel>
            {
                Data = tmp2,
                Total = tmp2.Count()
            };
            return new JsonResult
            {
                Data = gridModel
            };
        }
示例#14
1
        public ActionResult _SearchResult(GridCommand command, string item, string supplier, DateTime? dateFrom, DateTime? dateTo)
        {
            string sqlStr = PrepareSearchStatement(command, item, supplier, dateFrom, dateTo);
            IList<object[]> objectList = base.genericMgr.FindAllWithNativeSql<object[]>(sqlStr);

            var inspectDetailList = (from inp in objectList
                                     select new InspectDetail
                                     {
                                         IpNo = (string)inp[0],
                                         ManufactureParty = (string)inp[1],
                                         ManufacturePartyName = (string)inp[2],
                                         Item = (string)inp[3],
                                         ItemDescription = (string)inp[4],
                                         ReferenceItemCode = (string)inp[5],
                                         UnitCount = (decimal)inp[6],
                                         Uom = (string)inp[7],
                                         RejectQty = (decimal)inp[8],
                                         InspectQty = (decimal)inp[9]
                                     }).ToList();

            int count = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
            if (inspectDetailList.Count > count)
            {
                SaveWarningMessage(string.Format("数据超过{0}行,只显示前{0}行", count));
            }
            //return PartialView(inspectDetailList.Take(count));
            GridModel<InspectDetail> gridModel = new GridModel<InspectDetail>();
            gridModel.Total = count;
            gridModel.Data = inspectDetailList.Take(count);
            return PartialView(gridModel);
        }
        public ActionResult Categories(GridCommand command)
        {
            var model = new GridModel<TaxCategoryModel>();

            if (_permissionService.Authorize(StandardPermissionProvider.ManageTaxSettings))
            {
                var categoriesModel = _taxCategoryService.GetAllTaxCategories()
                    .Select(x => x.ToModel())
                    .ForCommand(command)
                    .ToList();

                model.Data = categoriesModel;
                model.Total = categoriesModel.Count;
            }
            else
            {
                model.Data = Enumerable.Empty<TaxCategoryModel>();

                NotifyAccessDenied();
            }

            return new JsonResult
            {
                Data = model
            };
        }
示例#16
1
        public ActionResult CurrentCarts(GridCommand command)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageCurrentCarts))
                return AccessDeniedView();

            var customers = _customerService.GetAllCustomers(
                loadOnlyWithShoppingCart: true,
                sct: ShoppingCartType.ShoppingCart,
                pageIndex: command.Page - 1,
                pageSize: command.PageSize);

            var gridModel = new GridModel<ShoppingCartModel>
            {
                Data = customers.Select(x =>
                {
                    return new ShoppingCartModel()
                    {
                        CustomerId = x.Id,
                        CustomerEmail = x.IsRegistered() ? x.Email : _localizationService.GetResource("Admin.Customers.Guest"),
                        TotalItems = x.ShoppingCartItems.Where(sci => sci.ShoppingCartType == ShoppingCartType.ShoppingCart).ToList().GetTotalProducts()
                    };
                }),
                Total = customers.TotalCount
            };
            return new JsonResult
            {
                Data = gridModel
            };
        }
示例#17
1
        public ActionResult List(GridCommand command, OrderSeqSearchModel searchModel)
        {
            SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
            var error = false;
            if (string.IsNullOrWhiteSpace(searchModel.ProdLine))
            {
                error = true;
                SaveWarningMessage(Resources.ErrorMessage.Errors_Common_FieldRequired, Resources.ORD.OrderMaster.OrderMaster_Flow);
            }
            if (!string.IsNullOrWhiteSpace(searchModel.TraceCode) && !error)
            {
                if (base.genericMgr.FindAll<long>("select count(*) from OrderSeq as s where s.TraceCode = ? and s.ProductLine=? ", new object[] { searchModel.TraceCode, searchModel.ProdLine })[0] == 0)
                {
                    error = true;
                    SaveErrorMessage("Van号值加生产线找不到对应的数据。");
                }
            }

            if (error)
            {
                ViewBag.ReadOnly = true;
                return View();
            }

            ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
            return View();
        }
 public ActionResult List(GridCommand command, string Flow)
 {
     ViewBag.Flow = Flow;
     this.CheckFlow(Flow, true);
     ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
     return View();
 }
示例#19
1
 public ActionResult List(GridCommand command, IssueNoSearchModel searchModel)
 {
     var search = this.ProcessSearchModel(command, searchModel);
     //TempData["IssueNoSearchModel"] = searchModel;
     ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
     return View();
 }
        public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
        {
            SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
            if (string.IsNullOrEmpty(searchModel.Location))
            {
                SaveWarningMessage(Resources.EXT.ControllerLan.Con_LocationCanNotBeEmpty);
                return View();
            }
            if (string.IsNullOrEmpty(searchModel.LotNoFrom))
            {
                SaveWarningMessage(Resources.EXT.ControllerLan.Con_FirstBatchNumberCanNotBeEmpty);
                return View();
            }
            if (string.IsNullOrEmpty(searchModel.LotNoFrom) && !string.IsNullOrEmpty(searchModel.LotNoTo))
            {
                SaveWarningMessage(Resources.EXT.ControllerLan.Con_FirstBatchNumberBeEmptyCanNotInputSecondBatchNumber);
                return View();
            }



            if (!string.IsNullOrEmpty(searchModel.Location)&&!string.IsNullOrEmpty(searchModel.LotNoFrom))
            {
                ViewBag.Region = searchModel.Region;
                TempData["_AjaxMessage"] = "";
            }
            else
            {
                SaveWarningMessage(Resources.EXT.ControllerLan.Con_SearchConditionNeedLocationAndBatchNo);
            }

            return View();
        }
        public ActionResult ShippingRateUpdate(FixedShippingRateModel model, GridCommand command)
        {
            int shippingMethodId = model.ShippingMethodId;
            decimal rate = model.Rate;

            _settingService.SetSetting(string.Format("ShippingRateComputationMethod.FixedRate.Rate.ShippingMethodId{0}", shippingMethodId), rate);

            var tmp = new List<FixedShippingRateModel>();
            foreach (var shippingMethod in _shippingService.GetAllShippingMethods())
                tmp.Add(new FixedShippingRateModel()
                {
                    ShippingMethodId = shippingMethod.Id,
                    ShippingMethodName = shippingMethod.Name,
                    Rate = GetShippingRate(shippingMethod.Id)
                });

            var tmp2 = tmp.ForCommand(command);
            var gridModel = new GridModel<FixedShippingRateModel>
            {
                Data = tmp2,
                Total = tmp2.Count()
            };
            return new JsonResult
            {
                Data = gridModel
            };
        }
        public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
        {

            if (string.IsNullOrEmpty(searchModel.Location))
            {
                return PartialView(new GridModel(new List<LocationLotDetail>()));
            }
            if (string.IsNullOrEmpty(searchModel.LotNoFrom))
            {
                return PartialView(new GridModel(new List<LocationLotDetail>())); ;
            }
            if (string.IsNullOrEmpty(searchModel.LotNoFrom) && !string.IsNullOrEmpty(searchModel.LotNoTo))
            {
                return PartialView(new GridModel(new List<LocationLotDetail>()));
            }

            ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
            GridModel<LocationLotDetail> gridModel = GetAuditInspectionPageData<LocationLotDetail>(reportSearchStatementModel);
            foreach (var locationLotDetail in gridModel.Data)
            {
              locationLotDetail.ItemDescription=genericMgr.FindById<Item>(locationLotDetail.Item).Description;
            }

            return PartialView(gridModel);
        }
        public ActionResult List(GridCommand command)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManagePolls))
                return AccessDeniedView();

            var polls = _pollService.GetPolls(0, false, command.Page - 1, command.PageSize, true);
            var gridModel = new GridModel<PollModel>
            {
                Data = polls.Select(x =>
                {
                    var m = x.ToModel();
                    if (x.StartDateUtc.HasValue)
                        m.StartDate = _dateTimeHelper.ConvertToUserTime(x.StartDateUtc.Value, DateTimeKind.Utc);
                    if (x.EndDateUtc.HasValue)
                        m.EndDate = _dateTimeHelper.ConvertToUserTime(x.EndDateUtc.Value, DateTimeKind.Utc);
                    m.LanguageName = x.Language.Name;
                    return m;
                }),
                Total = polls.TotalCount
            };
            return new JsonResult
            {
                Data = gridModel
            };
        }
示例#24
1
        private SearchStatementModel PrepareSearchStatement(GridCommand command, SMSRecSearchModel searchModel)
        {
            string whereStatement = string.Empty;

            IList<object> param = new List<object>();

            HqlStatementHelper.AddLikeStatement("Issue", searchModel.Issue, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param);
            HqlStatementHelper.AddLikeStatement("MsgID", searchModel.MsgID, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param);
            HqlStatementHelper.AddLikeStatement("Content", searchModel.Content, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param);
            HqlStatementHelper.AddLikeStatement("SrcID", searchModel.SrcID, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param);
            if (searchModel.DateFrom != null & searchModel.DateTo != null)
            {
                HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.DateFrom, searchModel.DateTo, "sms", ref whereStatement, param);
            }
            else if (searchModel.DateFrom != null & searchModel.DateTo == null)
            {
                HqlStatementHelper.AddGeStatement("CreateDate", searchModel.DateFrom, "sms", ref whereStatement, param);
            }
            else if (searchModel.DateFrom == null & searchModel.DateTo != null)
            {
                HqlStatementHelper.AddLeStatement("CreateDate", searchModel.DateTo, "sms", ref whereStatement, param);
            }
            HqlStatementHelper.AddEqStatement("EventHandler", SMSStatus.SMSEventHeadler_MESSAGERECEIVEDINTERFACE, "sms", 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 List(GridCommand command, WorkingCalendarSearchModel searchModel)
        {
            SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
            var error = false;
            if (string.IsNullOrWhiteSpace(searchModel.SearchRegion))
            {
                error = true;
                SaveErrorMessage(Resources.ErrorMessage.Errors_Common_FieldRequired, Resources.PRD.WorkingCalendar.WorkingCalendar_ProdLine);
            }
            if (!searchModel.StartWorkingDate.HasValue)
            {
                error = true;
                SaveErrorMessage(Resources.ErrorMessage.Errors_Common_FieldRequired, Resources.PRD.WorkingCalendar.WorkingCalendar_StartWorkingDate);
            }
            if (!searchModel.EndWorkingDate.HasValue)
            {
                error = true;
                SaveErrorMessage(Resources.ErrorMessage.Errors_Common_FieldRequired, Resources.PRD.WorkingCalendar.WorkingCalendar_EndWorkingDate);
            }
            if (searchModel.StartWorkingDate.HasValue && searchModel.EndWorkingDate.HasValue && searchModel.StartWorkingDate.Value >= searchModel.EndWorkingDate.Value)
            {
                error = true;
                SaveErrorMessage(Resources.PRD.WorkingCalendar.WorkingCalendar_EndDateMustGreaterThanStartDate);
            }
            ViewBag.ReadOnly = error;
            ViewBag.PageSize = base.ProcessPageSize(command.PageSize);

            return View();
        }
        //[SconitAuthorize(Permissions = "Url_LocationIOB_View")]
        public ActionResult _AjaxList(GridCommand command, LocationTransactionSearchModel searchModel)
        {
            if (string.IsNullOrEmpty(searchModel.Location))
            {
                return PartialView(new GridModel(new List<LocationTransactionView>()));
            }

            SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
            GridModel<string> itemModel = GetAjaxPageData<string>(searchStatementModel, command);

            #region 拼接库存收发存对象
            IList<string> itemLocList = (IList<string>)itemModel.Data;
            string hql = "from LocationTransaction as l where l.Item in (?";
            IList<object> param = new List<object>();
            param.Add(itemLocList[0]);
            for (int i = 1; i < itemLocList.Count; i++)
            {
                hql += ",?";
                param.Add(itemLocList[i]);
            }
            hql += ")";

            hql += " and (l.LocationFrom = ? and l.LocationTo = ?)";
            param.Add(searchModel.Location.Trim());
            param.Add(searchModel.Location.Trim());

            if (!string.IsNullOrEmpty(searchModel.Item))
            {
                hql += " and l.Item = ?";
                param.Add(searchModel.Item.Trim());
            }
            IList<LocationTransaction> loctransList = genericMgr.FindAll<LocationTransaction>(hql, param.ToArray());
            IList<LocationTransactionView> groupLoctransList = (from l in loctransList
                                                                group l by new
                                                                {
                                                                    Item = l.Item,
                                                                    Location = l.Location
                                                                }
                                                                    into result
                                                                    select new LocationTransactionView
                                                                    {
                                                                        Item = result.Key.Item,
                                                                        GroupLocation = result.Key.Location,
                                                                        SumProcurementInQty = result.Sum(t => t.ProcurementInQty),
                                                                        SumProductionInQty = result.Sum(t => t.ProductionInQty),
                                                                        SumProductionOutQty = result.Sum(t => t.ProductionOutQty),
                                                                        SumDistributionOutQty = result.Sum(t => t.DistributionOutQty),
                                                                        SumTransferInQty = result.Sum(t => t.TransferInQty),
                                                                        SumTransferOutQty = result.Sum(t => t.TransferOutQty),
                                                                    }).ToList();
            #endregion

            GridModel<LocationTransactionView> groupModel = new GridModel<LocationTransactionView>();
            groupModel.Total = itemModel.Total;
            groupModel.Data = groupLoctransList;
            ViewBag.Total = groupModel.Total;


            return PartialView(groupModel);
        }
        public ActionResult List(GridCommand command, ProductLineLocationDetailSearchModel searchModel)
        {
            this.ProcessSearchModel(command, searchModel);
            if (string.IsNullOrEmpty(searchModel.OrderNo))
            {
                SaveWarningMessage("请输入订单号。");
                return View(new List<OrderBomDetail>());
            }
            else
            {
                TempData["_AjaxMessage"] = "";
                string sql = PrepareSearchStatement(searchModel);
                IList<object[]> list = base.genericMgr.FindAllWithNativeSql<object[]>(sql);
                IList<OrderBomDetail> OrderBomDetailList = new List<OrderBomDetail>();
                OrderBomDetailList = (from tak in list
                                      select new OrderBomDetail
                                      {
                                          OrderNo = (string)tak[0],
                                          Item = (string)tak[1],
                                          ItemDescription = (string)tak[2],
                                          ReferenceItemCode = (string)tak[3],
                                          Uom = (string)tak[4],
                                          ManufactureParty = (string)tak[5],
                                          Operation = (int)tak[6],
                                          OpReference = (string)tak[7],
                                          OrderedQty = (decimal)tak[8],
                                          HuId = (string)tak[9],
                                          FeedQty = (decimal)tak[10],
                                      }).ToList();
                return View(OrderBomDetailList);
            }

           
        }
        public ActionResult _AjaxList(GridCommand command, OrderMasterSearchModel searchModel)
        {

            if (!this.CheckSearchModelIsNull(searchModel))
            {
                return PartialView(new GridModel(new List<OrderMaster>()));
            }

            string whereStatement = "and o.OrderStrategy=" + (int)com.Sconit.CodeMaster.FlowStrategy.SEQ;
           
            if (!string.IsNullOrWhiteSpace(searchModel.SequenceGroup))
            {
                whereStatement += " and o.SeqGroup='" + searchModel.SequenceGroup + "'";
            }
            if (searchModel.IsListPrice)
            {
                whereStatement += string.Format(" and IsListPrice=0 and o.Status not in ({0},{1})", (int)com.Sconit.CodeMaster.OrderStatus.Cancel, (int)com.Sconit.CodeMaster.OrderStatus.Close);
            }
            if (searchModel.IsPrintOrder)
            {
                whereStatement += string.Format(" and IsPrintOrder=0 and o.Status not in ({0},{1})", (int)com.Sconit.CodeMaster.OrderStatus.Cancel, (int)com.Sconit.CodeMaster.OrderStatus.Close);
            }
            searchModel.SubType = (int)com.Sconit.CodeMaster.OrderSubType.Normal;
            ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchStatement(command, searchModel, whereStatement, false);
            GridModel<OrderMaster> gridModel = GetAjaxPageDataProcedure<OrderMaster>(procedureSearchStatementModel, command);
            foreach (var ordermstr in gridModel.Data)
            {
                ordermstr.SeqOrderStrategyDescription = ordermstr.OrderTemplate == "KitOrder.xls" ? "Kit" : "排序";
            }
            return PartialView(gridModel);
        }
示例#29
0
 public ActionResult _AjaxOutSoureViewList(GridCommand command, CabProductionViewSearchModel searchModel)
 {
     SearchNativeSqlStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
     var list = GetPageDataEntityWithNativeSql<CabProductionView>(searchStatementModel, command);
     ViewBag.Total1 = list.Total;
     return PartialView(list);
 }
 public ActionResult List(GridCommand command, FacilityOrderSearchModel searchModel)
 {
     SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
   
     ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
     return View();
 }