/// <summary> /// 添加收货明细,引用POLine信息 /// </summary> /// <param name="session"></param> /// <param name="poLine"></param> /// <returns></returns> public bool AddLine(ISession session, POLine poLine) { if (poLine.ReceivableQty() <= 0M) { return(false); } if (!poLine.UnfinishedReceiveQtyChange(session, poLine.ReceivableQty())) { return(false); } RCVLine line = new RCVLine(); line.OrderNumber = this.OrderNumber; line.LineNumber = this.NextLineNumber(); line.TransTypeCode = " "; line.LocationCode = this.LocationCode; line.SKUID = poLine.SKUID; line.UnitID = poLine.UnitID; line.RefQty = poLine.ReceivableQty(); line.RCVTotalQty = poLine.ReceivableQty(); line.QualifiedQty = poLine.ReceivableQty(); line.UnQualifiedQty = 0M; line.RefOrderLine = line.OriginalOrderLine = poLine.LineNumber; line.TaxValue = 0M; // poLine.TaxValue; 系统默认进项税不可以退税抵扣,所以交易税率设置为0,需财务手工确定可以抵扣的进项税率 line.Price = poLine.Price; return(line.Create(session)); }
/// <summary> /// 删除收货单指定明细 /// </summary> /// <param name="session"></param> /// <param name="lienesToDelete"></param> /// <returns></returns> public int DeleteLines(ISession session, IList <RCVLine> lienesToDelete) { if (lienesToDelete == null || lienesToDelete.Count <= 0) { return(0); } if (this._status != ReceiveStatus.New) { throw new Exception("收货单不是新建状态,无法删除明细"); } int count = 0; foreach (RCVLine ltd in lienesToDelete) { if (this._orderTypeCode == RCVHead.ORD_TYPE_PUR) { //采购收货,删除明细时需要恢复采购订单的冗余字段值 POLine poLine = null; if (!string.IsNullOrEmpty(this._refOrderNumber) && this._refOrderNumber.Trim().Length > 0 && !string.IsNullOrEmpty(ltd.RefOrderLine) && ltd.RefOrderLine.Trim().Length > 0) { poLine = POLine.Retrieve(session, this._refOrderNumber, ltd.RefOrderLine); } if (poLine != null) { poLine.UnfinishedReceiveQtyChange(session, -ltd.QualifiedQty); } } ltd.Delete(session); count++; } return(count); }
/// <summary> /// ����ջ���ϸ������POLine��Ϣ /// </summary> /// <param name="session"></param> /// <param name="poLine"></param> /// <returns></returns> public bool AddLine(ISession session, POLine poLine) { if (poLine.ReceivableQty() <= 0M) return false; if (!poLine.UnfinishedReceiveQtyChange(session, poLine.ReceivableQty())) return false; RCVLine line = new RCVLine(); line.OrderNumber = this.OrderNumber; line.LineNumber = this.NextLineNumber(); line.TransTypeCode = " "; line.LocationCode = this.LocationCode; line.SKUID = poLine.SKUID; line.UnitID = poLine.UnitID; line.RefQty = poLine.ReceivableQty(); line.RCVTotalQty = poLine.ReceivableQty(); line.QualifiedQty = poLine.ReceivableQty(); line.UnQualifiedQty = 0M; line.RefOrderLine = line.OriginalOrderLine = poLine.LineNumber; line.TaxValue = 0M; // poLine.TaxValue; ϵͳĬ�Ͻ���˰��������˰�ֿۣ����Խ���˰������Ϊ0��������ֹ�ȷ�����Եֿ۵Ľ���˰�� line.Price = poLine.Price; return line.Create(session); }
public int UpdateLines(ISession session, IList <RCVLine> linesValue) { if (linesValue == null || linesValue.Count <= 0) { return(0); } #region 检查 IList <RCVLine> lines = new List <RCVLine>(linesValue.Count); bool error = false, errorHead = false; System.Text.StringBuilder builder = new System.Text.StringBuilder(); bool hasSection = false; foreach (RCVLine lv in linesValue) { errorHead = false; //收货数量是否有效 if (lv.RCVTotalQty <= 0M) { error = true; if (!errorHead) { builder.Append("行号").Append(lv.LineNumber).Append(": "); } errorHead = true; builder.Append("收货数量小于0; "); continue; } RCVLine l = RCVLine.Retrieve(session, lv.OrderNumber, lv.LineNumber); //可以不填写货架,但如果填写了,则检查货架有效性 WHSection section = null; hasSection = false; //库位、货架容量检查 WHArea area = WHArea.Retrieve(session, l.AreaCode); if (!string.IsNullOrEmpty(l.SectionCode) && l.SectionCode.Trim().Length > 0) { hasSection = true; section = WHSection.Retrieve(session, l.AreaCode, l.SectionCode); } decimal capacityFree = 0M; //取库位、货架容量 if (hasSection) { capacityFree = section.SectionCapacity; } else { capacityFree = area.AreaCapacity; } //库位容量扣减当前已存放量 if (hasSection) { capacityFree = capacityFree - Cast.Decimal(session.CreateObjectQuery(@" select sum(StockQty) from StockDetail where AreaCode=?area and SectionCode=?section") .Attach(typeof(StockDetail)) .SetValue("?area", area.AreaCode, "AreaCode") .SetValue("?section", section.SectionCode, "SectionCode") .Scalar(), 0M); } else { capacityFree = capacityFree - Cast.Decimal(session.CreateObjectQuery(@"select sum(StockQty) from StockDetail where AreaCode=?area") .Attach(typeof(StockDetail)) .SetValue("?area", area.AreaCode, "AreaCode") .Scalar(), 0M); } //剩余容量和本次入库量比较 if (capacityFree < lv.QualifiedQty) { builder.Append("行号").Append(lv.LineNumber).Append(": "); error = true; builder.Append("入库量").Append(lv.QualifiedQty).Append("大于剩余容量").Append(capacityFree); } if (!error) { lines.Add(l); } } if (error) { throw new Exception(builder.ToString()); } #endregion int count = 0; DbSession dbsession = session.DbSession as DbSession; session.BeginTransaction(); for (int i = 0; i < lines.Count; i++) { RCVLine line = lines[i]; POLine poLine = null; if (!string.IsNullOrEmpty(this._refOrderNumber) && this._refOrderNumber.Trim().Length > 0 && !string.IsNullOrEmpty(line.RefOrderLine) && line.RefOrderLine.Trim().Length > 0) { poLine = POLine.Retrieve(session, this._refOrderNumber, line.RefOrderLine); } if (poLine != null) { IDbCommand cmd = dbsession.CreateStoredProcCommand("F_PUR_RCV_TOLERANCE_RATIO", new object[] { 0, poLine.OrderNumber }); dbsession.ExecuteNonQuery(cmd); IDbDataParameter p = cmd.Parameters[0] as IDbDataParameter; decimal ration = Cast.Decimal(p.Value); if (poLine.PurchaseQty * (1 + ration) - poLine.ReceiveQty - poLine.UnfinishedReceiveQty - linesValue[i].QualifiedQty + line.QualifiedQty < 0) { error = true; builder.Append("行号").Append(line.LineNumber).Append("收货数量").Append(linesValue[i].QualifiedQty) .Append("超过PO最大可收货数量").Append(Math.Floor(poLine.PurchaseQty * (1 + ration)) - poLine.ReceiveQty - poLine.UnfinishedReceiveQty + line.QualifiedQty); break; } poLine.UnfinishedReceiveQtyChange(session, linesValue[i].QualifiedQty - line.QualifiedQty); } line.RCVTotalQty = linesValue[i].RCVTotalQty; line.QualifiedQty = linesValue[i].QualifiedQty; line.Update(session, "RCVTotalQty", "QualifiedQty"); count++; } if (error) { session.Rollback(); throw new Exception(builder.ToString()); } else { session.Commit(); } return(count); }
public SimpleJson AddLine(ISession session, string poLineNumber, string areaCode, string sectionCode, decimal qty) { //检查 if (string.IsNullOrEmpty(poLineNumber) || poLineNumber.Trim().Length <= 0) { return(new SimpleJson().HandleError("PO行为空")); } if (string.IsNullOrEmpty(areaCode) || areaCode.Trim().Length <= 0) { return(new SimpleJson().HandleError("库位为空")); } if (!string.IsNullOrEmpty(sectionCode) && sectionCode.Trim().Length > 0) { WHSection section = WHSection.Retrieve(session, areaCode, sectionCode); if (session == null) { return(new SimpleJson() .HandleError("库位" + areaCode.Trim().ToUpper() + "中的货架" + sectionCode.Trim().ToUpper() + "不存在")); } } if (qty <= 0) { return(new SimpleJson().HandleError("收货数量" + qty.ToString() + "小于0")); } POLine poLine = POLine.Retrieve(session, this.RefOrderNumber, poLineNumber); if (poLine == null) { return(new SimpleJson().HandleError("PO " + this.RefOrderNumber + "中不存在" + poLineNumber + "的行")); } if (poLine.ReceivableQty() <= 0M) { return(new SimpleJson().HandleError("订单" + this.RefOrderNumber + "行" + poLineNumber + "可收货数量为0")); } if (!poLine.UnfinishedReceiveQtyChange(session, qty)) { return(new SimpleJson().HandleError("无法更新订单" + this.RefOrderNumber + "行" + poLineNumber + "的待入库数量")); } RCVLine line = new RCVLine(); line.OrderNumber = this.OrderNumber; line.LineNumber = this.NextLineNumber(); line.TransTypeCode = " "; line.LocationCode = this.LocationCode; line.AreaCode = areaCode.Trim().ToUpper(); line.SectionCode = string.IsNullOrEmpty(sectionCode) ? " " : sectionCode.Trim().ToUpper(); line.SKUID = poLine.SKUID; line.UnitID = poLine.UnitID; line.RefQty = poLine.ReceivableQty(); line.RCVTotalQty = qty; line.QualifiedQty = qty; line.UnQualifiedQty = 0M; line.RefOrderLine = line.OriginalOrderLine = poLine.LineNumber; line.TaxValue = 0M; // poLine.TaxValue; 系统默认进项税不可以退税抵扣,所以交易税率设置为0,需财务手工确定可以抵扣的进项税率 line.Price = poLine.Price; line.Create(session); this.Update(session, "CurrentLineNumber"); return(new SimpleJson()); }