/// <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());
}
