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