public IList <Book.Model.InvoiceJRDetail> Select(Book.Model.InvoiceJR invoice)
{
return(sqlmapper.QueryForList <Model.InvoiceJRDetail>("InvoiceJRDetail.select_by_invoiceid", invoice.InvoiceId));
}
public void Delete(Book.Model.InvoiceJR invoice)
{
sqlmapper.Delete("InvoiceJRDetail.delete_by_invoiceid", invoice.InvoiceId);
}
private void _Insert(Book.Model.InvoiceJR invoice)
{
//往来单位
//if (invoice.Customer != null)
// invoice.CustomerId = invoice.Customer.CustomerId;
// 库房
//invoice.DepotId = invoice.Depot.DepotId;
//经手人
invoice.Employee0Id = invoice.Employee0.EmployeeId;
//录单人
if (invoice.Employee1 != null)
{
invoice.Employee1Id = invoice.Employee1.EmployeeId;
}
if ((Helper.InvoiceStatus)invoice.InvoiceStatus.Value == Helper.InvoiceStatus.Normal)
{
//过账人
if (invoice.Employee2 != null)
{
invoice.Employee2Id = invoice.Employee2.EmployeeId;
}
//过账时间
invoice.InvoiceGZTime = DateTime.Now;
}
//插入表单
accessor.Insert(invoice);
//插入明细
foreach (Model.InvoiceJRDetail detail in invoice.Details)
{
if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId))
{
continue;
}
detail.InvoiceId = invoice.InvoiceId;
detail.InvoiceWeiHuaiChuQuantity = detail.InvoiceJRDetailQuantity;
detail.InvoiceYiHuaiChuQuantity = 0;
invoiceJRDetailAccessor.Insert(detail);
Model.Product p = detail.Product;
//if (detail.InvoiceProductUnit == p.ProductOuterPackagingUnit)
//{
// quantity = detail.InvoiceJRDetailQuantity * p.ProductBaseUnitRelationship * p.ProductInnerUnitRelationship;
//}
//else if (detail.InvoiceProductUnit == detail.Product.ProductInnerPackagingUnit)
//{
// quantity = detail.InvoiceJRDetailQuantity * p.ProductBaseUnitRelationship;
//}
//else
//{
// quantity = detail.InvoiceJRDetailQuantity;
//}
//byte[] pic = new byte[] { };
//if (p.ProductImage == null)
// p.ProductImage = pic;
//if (p.ProductImage1 == null)
// p.ProductImage1 = pic;
//if (p.ProductImage2 == null)
// p.ProductImage2 = pic;
//if (p.ProductImage3 == null)
// p.ProductImage3 = pic;
p.StocksQuantity += detail.InvoiceJRDetailQuantity;
productAccessor.Update(p);
Model.Stock stock = stockAccessor.GetStockByProductIdAndDepotPositionId(p.ProductId, detail.DepotPositionId);
if (stock == null)
{
stock = new Book.Model.Stock();
stock.StockId = Guid.NewGuid().ToString();
stock.ProductId = p.ProductId;
stock.DepotPositionId = detail.DepotPositionId;
stock.StockQuantity1 = detail.InvoiceJRDetailQuantity;
stock.StockCurrentJR = stock.StockCurrentJR == null ? detail.InvoiceJRDetailQuantity : stock.StockCurrentJR + detail.InvoiceJRDetailQuantity;
stock.DepotId = invoice.DepotId;
stock.ProduceUnit = p.ProduceUnit.CnName;
stockAccessor.Insert(stock);
}
else
{
stockAccessor.IncrementJR(depotPositionAcccessor.Get(detail.DepotPositionId), p, detail.InvoiceJRDetailQuantity.Value);
}
}
}
