コード例 #1
0
        public ActionResult _FilterPost(SaleDeliveryOrderFilterViewModel vm)
        {
            List <SaleDeliveryOrderLineViewModel> temp = _SaleDeliveryOrderLineService.GetSaleOrderLineForMultiSelect(vm).ToList();
            SaleDeliveryMasterDetailModel         svm  = new SaleDeliveryMasterDetailModel();

            svm.SaleDeliveryOrderLineViewModel = temp;
            return(PartialView("_Results", svm));
        }
コード例 #2
0
        public ActionResult _CreateMultiple(int id, int bid)
        {
            SaleDeliveryOrderFilterViewModel vm = new SaleDeliveryOrderFilterViewModel();

            vm.SaleDeliveryOrderHeaderId = id;
            vm.BuyerId = bid;
            return(PartialView("_Filters", vm));
        }
コード例 #3
0
        public IEnumerable <SaleDeliveryOrderLineViewModel> GetSaleOrderLineForMultiSelect(SaleDeliveryOrderFilterViewModel svm)
        {
            string[] ProductIdArr = null;
            if (!string.IsNullOrEmpty(svm.ProductId))
            {
                ProductIdArr = svm.ProductId.Split(",".ToCharArray());
            }
            else
            {
                ProductIdArr = new string[] { "NA" };
            }

            string[] SaleOrderIdArr = null;
            if (!string.IsNullOrEmpty(svm.SaleOrderId))
            {
                SaleOrderIdArr = svm.SaleOrderId.Split(",".ToCharArray());
            }
            else
            {
                SaleOrderIdArr = new string[] { "NA" };
            }

            string[] ProductGroupIdArr = null;
            if (!string.IsNullOrEmpty(svm.ProductGroupId))
            {
                ProductGroupIdArr = svm.ProductGroupId.Split(",".ToCharArray());
            }
            else
            {
                ProductGroupIdArr = new string[] { "NA" };
            }

            var temp = (from p in db.ViewSaleOrderBalanceForCancellation
                        join product in db.Product on p.ProductId equals product.ProductId into table2
                        from tab2 in table2.DefaultIfEmpty()
                        where (string.IsNullOrEmpty(svm.ProductId) ? 1 == 1 : ProductIdArr.Contains(p.ProductId.ToString())) &&
                        (svm.BuyerId == 0 ? 1 == 1 : p.BuyerId == svm.BuyerId) &&
                        (string.IsNullOrEmpty(svm.SaleOrderId) ? 1 == 1 : SaleOrderIdArr.Contains(p.SaleOrderHeaderId.ToString())) &&
                        (string.IsNullOrEmpty(svm.ProductGroupId) ? 1 == 1 : ProductGroupIdArr.Contains(tab2.ProductGroupId.ToString())) &&
                        p.BalanceQty > 0
                        select new SaleDeliveryOrderLineViewModel
            {
                BalanceQty = p.BalanceQty,
                Qty = p.BalanceQty,
                SaleOrderDocNo = p.SaleOrderNo,
                ProductName = tab2.ProductName,
                ProductId = p.ProductId,
                SaleDeliveryOrderHeaderId = svm.SaleDeliveryOrderHeaderId,
                SaleOrderLineId = p.SaleOrderLineId,
                UnitDecimalPlaces = tab2.Unit.DecimalPlaces,
            });

            return(temp);
        }