/// <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); }
public void AddLine(ISession session, string po, string poLine, string area, string section, decimal qty) { if (this.Status != POReturnStatus.New) { throw new Exception("采购退货单不是新建状态,无法添加明细"); } POLine line = POLine.Retrieve(session, po, poLine); if (line == null) { throw new Exception(po + "行" + poLine + "不存在"); } if (line.ReceiveQty < qty) { throw new Exception(po + "行" + poLine + "退货数量" + qty.ToString() + "大于收货数量" + line.ReceiveQty.ToString()); } StockDetail sto = StockDetail.Retrieve(session, line.SKUID, this.LocationCode, area, section); if (sto == null) { throw new Exception(po + "行" + poLine + "库存明细(" + area + "," + section + ")不存在"); } if (sto.StockQty < qty) { throw new Exception(po + "行" + poLine + "退货数量" + qty.ToString() + "大于库存量" + sto.StockQty.ToString()); } DbSession dbsession = session.DbSession as DbSession; IDbCommand cmd = dbsession.CreateSqlStringCommand("Select Sum(a.rtn_qty) From ord_pur_rtn_line a Where a.po_num=:po And a.po_line=:poline"); dbsession.AddParameter(cmd, ":po", DbTypeInfo.AnsiString(16), po); dbsession.AddParameter(cmd, ":poline", DbTypeInfo.AnsiString(4), poLine); decimal returnedQty = Cast.Decimal(dbsession.ExecuteScalar(cmd)); if (returnedQty + qty > line.ReceiveQty) { throw new Exception(po + "行" + poLine + ",已退货数量" + returnedQty.ToString() + "本次退货数量" + qty.ToString() + "大于收货数量" + line.ReceiveQty.ToString()); } POReturnLine rtnLine = new POReturnLine(); rtnLine.OrderNumber = this.OrderNumber; rtnLine.LineNumber = this.NextLineNumber(); rtnLine.PONumber = po; rtnLine.POLine = poLine; rtnLine.SKUID = line.SKUID; rtnLine.Price = line.Price; rtnLine.Quantity = qty; rtnLine.TaxValue = line.TaxValue; rtnLine.StockDetailID = sto.StockDetailID; rtnLine.Create(session); }
public void Close(ISession session, bool throwException) { if (this._status != ReceiveStatus.Open) { log.ErrorFormat("收货单{0}不是待发货状态,无法执行关闭操作", this._orderNumber); if (throwException) { throw new Exception(string.Format("收货单{0}不是待发货状态,无法执行关闭操作", this._orderNumber)); } return; } //签核完成后会调用这个方法,尝试将收货单自动关闭,如果这个方法发生异常,签核处理正常完成,需要手工来关闭这个单据 //签核完成的关闭动作将新开一个session来完成,确保关闭时的异常不会影响签核操作的结束;手工关闭时由界面开session来执行这个方法 try { //库存交易 ERPUtil.CommitWHTrans(session, this); //更新PO行的冗余字段值 if (this._orderTypeCode == RCVHead.ORD_TYPE_PUR && !string.IsNullOrEmpty(this._refOrderNumber) && this._refOrderNumber.Trim().Length > 0) { IList <RCVLine> rcvLines = session.CreateEntityQuery <RCVLine>() .Where(Exp.Eq("OrderNumber", this._orderNumber)) .OrderBy("LineNumber") .List <RCVLine>(); foreach (RCVLine rcv in rcvLines) { if (!string.IsNullOrEmpty(rcv.RefOrderLine) && rcv.RefOrderLine.Trim().Length > 0) { POLine poLine = POLine.Retrieve(session, this._refOrderNumber, rcv.RefOrderLine); if (poLine != null) { poLine.ReceiveFinish(session, rcv.RCVTotalQty, rcv.QualifiedQty); } } } } //更新本身状态 this._status = ReceiveStatus.Close; this.Update(session, "Status"); } catch (Exception er) { log.Error(string.Format("收货单{0}关闭时发生异常", this._orderNumber), er); if (throwException) { throw er; } } }
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()); }