예제 #1
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sale_id"></param>
        public void CreateBackStock(int backsale_id,List<BOrder> orders,int backSaleStatus)
        {
            KuanMaiEntities db = new KuanMaiEntities();
            try
            {
                if (orders == null || orders.Count == 0)
                {
                    throw new KMJXCException("没有退货信息");
                }

                Back_Sale dbbackSale = (from bsale in db.Back_Sale where bsale.Back_Sale_ID == backsale_id select bsale).FirstOrDefault<Back_Sale>();
                if (dbbackSale == null)
                {
                    throw new KMJXCException("退货单信息不存在");
                }

                //dbbackSale.Status = backSaleStatus;

                var bdetails = from bsd in db.Back_Sale_Detail
                               where bsd.Back_Sale_ID == backsale_id
                               select bsd;

                string[] order_id = (from o in orders select o.Order_ID).ToArray<string>();
                if (order_id != null)
                {
                    bdetails = bdetails.Where(d => order_id.Contains(d.Order_ID));
                }
                List<Sale_Detail> saleDetails=(from s in db.Sale_Detail where order_id.Contains(s.Mall_Order_ID) select s).ToList<Sale_Detail>();
                List<Back_Sale_Detail> backSaleDetails = bdetails.ToList<Back_Sale_Detail>();
                //Check if current sale trade has leave stock records
                //if the sale doesn't have leave stock, so no need to back stock
                Leave_Stock leave_Stock=(from ls in db.Leave_Stock where ls.Sale_ID==dbbackSale.Sale_ID select ls).FirstOrDefault<Leave_Stock>();
                if (leave_Stock!=null)
                {
                    List<Leave_Stock_Detail> leaveDetails=(from ld in db.Leave_Stock_Detail where ld.Leave_Stock_ID==leave_Stock.Leave_Stock_ID select ld).ToList<Leave_Stock_Detail>();

                    BBackStock backStock = new BBackStock();
                    backStock.BackSaleID = dbbackSale.Back_Sale_ID;
                    backStock.BackSale = new BBackSale() { ID = dbbackSale.Back_Sale_ID };
                    if (backSaleStatus == 1 || backSaleStatus==2)
                    {
                        backStock.UpdateStock = true;
                    }
                    else
                    {
                        backStock.UpdateStock = false;
                    }
                    backStock.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
                    backStock.BackDateTime = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
                    backStock.Created_By = new BUser() { ID = this.CurrentUser.ID };
                    if (!string.IsNullOrEmpty(dbbackSale.Description))
                    {
                        backStock.Description = dbbackSale.Description + "<br/> 生成了退库单";
                    }
                    else
                    {
                        backStock.Description = "生成了退库单";
                    }

                    backStock.Shop = new BShop() { ID = dbbackSale.Shop_ID };

                    //collect back stock details info from leave stock details

                    backStock.Details = new List<BBackStockDetail>();

                    foreach (Back_Sale_Detail bsd in backSaleDetails)
                    {
                        BOrder order=(from o in orders where bsd.Order_ID == o.Order_ID select o).FirstOrDefault<BOrder>();
                        Sale_Detail saleDetail=(from s in saleDetails where s.Mall_Order_ID==bsd.Order_ID select s).FirstOrDefault<Sale_Detail>();
                        Leave_Stock_Detail leaveStockDetail = (from lsd in leaveDetails where lsd.Order_ID == bsd.Order_ID select lsd).FirstOrDefault<Leave_Stock_Detail>();
                        if (leaveStockDetail == null)
                        {
                            continue;
                        }
                        BBackStockDetail bsDetail = new BBackStockDetail();
                        bsDetail.Price = leaveStockDetail.Price;
                        bsDetail.Quantity = leaveStockDetail.Quantity;
                        if (order != null && order.Quantity > 0 && order.Quantity<=leaveStockDetail.Quantity)
                        {
                            bsDetail.Quantity = order.Quantity;
                        }

                        bsDetail.ProductID = leaveStockDetail.Product_ID;
                        bsDetail.ParentProductID = leaveStockDetail.Parent_Product_ID;
                        bsDetail.Batch = new BStockBatch() { ID = leaveStockDetail.Batch_ID };
                        bsDetail.StoreHouse = new BStoreHouse() { ID = leaveStockDetail.StoreHouse_ID };
                        backStock.Details.Add(bsDetail);
                        bsd.Status = backSaleStatus;
                        //5 means refound and successfully back to sock
                        saleDetail.Status1 = (int)SaleDetailStatus.REFOUND_HANDLED;
                        saleDetail.SyncResultMessage = "退货已经处理";
                    }

                    if (backStock.Details.Count > 0)
                    {
                        this.CreateBackStock(backStock);
                    }
                }

                db.SaveChanges();
            }
            catch (KMJXCException kex)
            {
                throw kex;
            }
            catch(Exception ex)
            {
                throw ex;
            }
            finally
            {
                db.Dispose();
            }
        }
예제 #2
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="backSaleId"></param>
        /// <param name="backSaleDetailId"></param>
        /// <param name="productId"></param>
        private void CreateBackStock(BBackStock backStock)
        {
            List<BBackStockDetail> details = backStock.Details;

            if (this.CurrentUserPermission.HANDLE_BACK_SALE == 0)
            {
                throw new KMJXCException("没有权限进行退货退库存操作");
            }

            if (backStock == null)
            {
                throw new KMJXCException("输入错误", ExceptionLevel.SYSTEM);
            }

            if (backStock.BackSale == null || backStock.BackSale.ID <= 0)
            {
                throw new KMJXCException("请选择退货单进行退库存操作", ExceptionLevel.SYSTEM);
            }

            if (details == null)
            {
                throw new KMJXCException("没有选择产品进行退库存");
            }

            using(KuanMaiEntities db = new KuanMaiEntities())
            {
                using (TransactionScope tran = new TransactionScope())
                {
                    Back_Stock dbBackStock = (from dbStock in db.Back_Stock where dbStock.Back_Sale_ID == backStock.BackSale.ID select dbStock).FirstOrDefault<Back_Stock>();
                    if (dbBackStock == null)
                    {
                        dbBackStock = new Back_Stock();
                        if (backStock.BackDateTime > 0)
                        {
                            dbBackStock.Back_Date = backStock.BackDateTime;
                        }
                        else
                        {
                            dbBackStock.Back_Date = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
                        }
                        dbBackStock.Back_Sale_ID = backStock.BackSale.ID;
                        dbBackStock.Back_Sock_ID = 0;
                        dbBackStock.Description = backStock.Description;
                        dbBackStock.Shop_ID = this.Shop.Shop_ID;
                        if (backStock.Created > 0)
                        {
                            dbBackStock.Created = backStock.Created;
                        }
                        else
                        {
                            dbBackStock.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
                        }
                        dbBackStock.User_ID = this.CurrentUser.ID;
                        db.Back_Stock.Add(dbBackStock);
                        db.SaveChanges();
                    }

                    if (dbBackStock.Back_Sock_ID > 0)
                    {
                        foreach (BBackStockDetail detail in details)
                        {
                            Back_Stock_Detail dbDetail = new Back_Stock_Detail();
                            dbDetail.Back_Stock_ID = dbBackStock.Back_Sock_ID;
                            dbDetail.Price = detail.Price;
                            dbDetail.Product_ID = detail.ProductID;
                            dbDetail.Parent_Product_ID = detail.ParentProductID;
                            dbDetail.Quantity = detail.Quantity;
                            if (detail.Batch != null)
                            {
                                dbDetail.Batch_ID = detail.Batch.ID;
                            }

                            if (detail.StoreHouse != null)
                            {
                                dbDetail.StoreHouse_ID = detail.StoreHouse.ID;
                            }

                            //Update stock pile
                            if (backStock.UpdateStock)
                            {
                                Stock_Pile pile = (from spile in db.Stock_Pile where spile.Product_ID == dbDetail.Product_ID && spile.StockHouse_ID == detail.StoreHouse.ID && spile.Batch_ID == dbDetail.Batch_ID select spile).FirstOrDefault<Stock_Pile>();
                                if (pile != null)
                                {
                                    pile.Quantity = pile.Quantity + dbDetail.Quantity;
                                }

                                Product product = (from p in db.Product
                                                   join p1 in db.Product on p.Product_ID equals p1.Parent_ID
                                                   where p1.Product_ID == dbDetail.Product_ID
                                                   select p).FirstOrDefault<Product>();
                                if (product != null)
                                {
                                    product.Quantity += dbDetail.Quantity;
                                }
                                //1表示退库并更新了库存
                                dbDetail.Status = 1;
                            }

                            db.Back_Stock_Detail.Add(dbDetail);

                        }

                        db.SaveChanges();
                    }
                    else
                    {
                        throw new KMJXCException("退库存操作失败");
                    }

                    tran.Complete();
                }
            }
        }