예제 #1
0
        /// <summary>
        /// 采购完成后重新领料
        /// </summary>
        /// <param name="orderID"></param>
        /// <param name="currentUser"></param>
        /// <returns></returns>
        public async Task <ResponseObject <NOEntity> > RePick(int orderID, CurrentUser currentUser)
        {
            try
            {
                TMMProductionOrderMainDbModel tMMProductionOrderMainDbModel = _db.Instance.Queryable <TMMProductionOrderMainDbModel>().Where(p => p.ID == orderID).First();

                if (tMMProductionOrderMainDbModel.IsPickAll == true)
                {
                    throw new Exception("已全部转领料");
                }

                TMMPurchaseApplyMainDbModel purchaseEntity = await _db.Instance.Queryable <TMMPurchaseApplyMainDbModel>().Where(p => p.SourceId == orderID && p.CompanyId == currentUser.CompanyID && p.DeleteFlag == false).FirstAsync();

                NOEntity nOEntity = new NOEntity();
                if (purchaseEntity == null)
                {
                    throw new Exception("还没采购,或者无需采购");
                }

                if (purchaseEntity.TransferFlag == true)
                {
                    throw new Exception("采购流程未完成");
                }
                else
                {
                    int producePurchaseId = purchaseEntity.ID;
                    if (_db.Instance.Queryable <TPSMPurchaseOrderMainDbModel>().Any(p => p.DeleteFlag == false && p.TransferStatus == true && p.SourceId == purchaseEntity.ID))
                    {
                        throw new Exception("采购流程未完成");
                    }
                    var allTWMPurchase = _db.Instance.Queryable <TWMPurchaseDetailDbModel, TWMPurchaseMainDbModel>((t, t1) => new object[] { JoinType.Inner, t.MainId == t1.ID }).
                                         Where((t, t1) => t1.DeleteFlag == false && SqlFunc.Subqueryable <TPSMPurchaseOrderMainDbModel>().
                                               Where(p1 => p1.SourceId == producePurchaseId && t1.SourceId == p1.ID).Any()).Select((t, t1) => new { Main = t1, Deatail = t }).ToList();

                    if (allTWMPurchase.Any(p => p.Main.AuditStatus != 2))
                    {
                        throw new Exception("采购流程未完成");
                    }
                    else
                    {
                        var basicMe  = BasicCacheGet.GetMaterial(currentUser);
                        var groupSum = allTWMPurchase.Select(p => p.Deatail).GroupBy(x => x.MaterialId);

                        List <TMMPickApplyDetailDbModel> PickApplyList = new List <TMMPickApplyDetailDbModel>();
                        foreach (var item in groupSum)
                        {
                            var key          = item.Key;
                            var itemDeatails = item.ToList();
                            var firstItem    = itemDeatails.FirstOrDefault();

                            decimal total = item.Sum(p => p.ActualNum);
                            var     me    = basicMe.Where(p => p.ID == item.Key).FirstOrDefault();

                            decimal ProduceTotal = UnitChange.TranserUnit(me, UnitType.Warehouse, UnitType.Produce, total);

                            TMMPickApplyDetailDbModel ApplyDetail = new TMMPickApplyDetailDbModel();
                            ApplyDetail.ApplyNum   = ProduceTotal;
                            ApplyDetail.MaterialId = key;
                            ApplyDetail.TransNum   = ProduceTotal;
                            PickApplyList.Add(ApplyDetail);
                        }

                        if (PickApplyList.Count() > 0)
                        {
                            TMMPickApplyMainDbModel tMMPickApplyMainDbModel = new TMMPickApplyMainDbModel();
                            tMMPickApplyMainDbModel.DeleteFlag = false;
                            tMMPickApplyMainDbModel.SourceId   = orderID;
                            //tMMPickApplyMainDbModel.PickNo = OrderGenerator.Generator(OrderEnum.PMR, currentUser.CompanyID);
                            string code = _codeMakers.Where(p => p.ProvideName == OrderEnum.PMR.GetDescription()).FirstOrDefault()?.MakeNo(currentUser.CompanyID);
                            tMMPickApplyMainDbModel.PickNo       = code;
                            tMMPickApplyMainDbModel.ApplyDate    = DateTime.Now;
                            tMMPickApplyMainDbModel.OperatorId   = currentUser.UserID;
                            tMMPickApplyMainDbModel.OperatorTime = DateTime.Now;
                            tMMPickApplyMainDbModel.AuditStatus  = 2;
                            tMMPickApplyMainDbModel.CompanyId    = currentUser.CompanyID;
                            tMMPickApplyMainDbModel.TransferFlag = true;

                            int mId = _db.Instance.Insertable(tMMPickApplyMainDbModel).ExecuteReturnIdentity();

                            PickApplyList.ForEach((x) =>
                            {
                                x.MainId = mId;
                            });

                            _db.Instance.Insertable(PickApplyList).ExecuteCommand();

                            _db.Instance.Updateable <TMMProductionOrderMainDbModel>().SetColumns(p => new TMMProductionOrderMainDbModel {
                                IsPickAll = true
                            }).Where(p => p.ID == orderID).ExecuteCommand();

                            nOEntity.ID = tMMPickApplyMainDbModel.ID;
                            nOEntity.NO = tMMPickApplyMainDbModel.PickNo;
                        }
                    }
                }

                _db.Instance.CommitTran();
                return(ResponseUtil <NOEntity> .SuccessResult(nOEntity));
            }
            catch (Exception ex)
            {
                _db.Instance.RollbackTran();
                return(ResponseUtil <NOEntity> .FailResult(null, ex.Message));
            }
        }
예제 #2
0
        /// <summary>
        /// 转采购
        /// </summary>
        /// <returns></returns>
        public async Task <ResponseObject <NOEntity> > TransPurchase(int orderID, CurrentUser currentUser)
        {
            try
            {
                _db.Instance.BeginTran();

                NOEntity nOEntity = new NOEntity();

                TMMProductionOrderMainDbModel mainEntity = _db.Instance.Queryable <TMMProductionOrderMainDbModel>().Where(p => p.ID == orderID &&
                                                                                                                          p.CompanyId == currentUser.CompanyID && p.IsPurchase == true).First();

                if (mainEntity == null)
                {
                    return(ResponseUtil <NOEntity> .FailResult(nOEntity, "生产订单不存在,或者已转生产采购单"));
                }
                if (mainEntity.MRPStatus == false)
                {
                    return(ResponseUtil <NOEntity> .FailResult(nOEntity, "还没算料,无法转单"));
                }

                var Allmaterial = _db.Instance.Queryable <TMMProductionOrderBOMSumDbModel>().Where(p => p.ProOrderId == orderID).ToList(); //生产单BOM

                List <TMMPurchaseApplyDetailDbModel> PurchaseList = new List <TMMPurchaseApplyDetailDbModel>();                            //生产采购申请单明细表

                List <TMMProductionOrderBOMSumDbModel> productionList = new List <TMMProductionOrderBOMSumDbModel>();                      //生产单BOM

                foreach (var item in Allmaterial)
                {
                    if (item.PurchaseNum > 0) //采购
                    {
                        TMMPurchaseApplyDetailDbModel purchaseDeatail = new TMMPurchaseApplyDetailDbModel();
                        purchaseDeatail.ApplyNum   = item.PurchaseNum;
                        purchaseDeatail.MaterialId = item.MaterialId;
                        purchaseDeatail.TransNum   = item.PurchaseNum;
                        PurchaseList.Add(purchaseDeatail);

                        item.PurchaseTransNum = item.PurchaseNum;
                        productionList.Add(item);
                    }
                }

                if (PurchaseList.Count() > 0)
                {
                    TMMPurchaseApplyMainDbModel tMMPurchaseApplyMainDbModel = new TMMPurchaseApplyMainDbModel();
                    tMMPurchaseApplyMainDbModel.DeleteFlag   = false;
                    tMMPurchaseApplyMainDbModel.SourceId     = orderID;
                    tMMPurchaseApplyMainDbModel.PurchaseNo   = _codeMakers.Where(p => p.ProvideName == OrderEnum.PR.GetDescription()).FirstOrDefault().MakeNo(currentUser.CompanyID);
                    tMMPurchaseApplyMainDbModel.ApplyDate    = DateTime.Now;
                    tMMPurchaseApplyMainDbModel.OperatorId   = currentUser.UserID;
                    tMMPurchaseApplyMainDbModel.OperatorTime = DateTime.Now;
                    tMMPurchaseApplyMainDbModel.AuditStatus  = 2;
                    tMMPurchaseApplyMainDbModel.CompanyId    = currentUser.CompanyID;
                    tMMPurchaseApplyMainDbModel.TransferFlag = true;
                    int mId = _db.Instance.Insertable(tMMPurchaseApplyMainDbModel).ExecuteReturnIdentity();

                    PurchaseList.ForEach((x) =>
                    {
                        x.MainId = mId;
                    });

                    await _db.Instance.Insertable(PurchaseList).ExecuteCommandAsync();

                    nOEntity.NO = tMMPurchaseApplyMainDbModel.PurchaseNo;
                    nOEntity.ID = mId;
                }

                if (productionList.Count() > 0)
                {
                    _db.Instance.Updateable(productionList).UpdateColumns(p => new { p.PurchaseTransNum }).ExecuteCommand();
                }

                mainEntity.IsPurchase = false;
                _db.Instance.Updateable(mainEntity).UpdateColumns(p => new { p.IsPurchase }).ExecuteCommand();

                _db.Instance.CommitTran();

                return(ResponseUtil <NOEntity> .SuccessResult(nOEntity));
            }
            catch (Exception ex)
            {
                _db.Instance.RollbackTran();
                return(ResponseUtil <NOEntity> .FailResult(null, ex.Message));
            }
        }