public IList <Book.Model.InvoiceJCDetail> Select(Book.Model.InvoiceJC invoice) { return(accessor.Select(invoice)); }
public IList <Book.Model.InvoiceJCDetail> Select(Book.Model.InvoiceJC invoice) { return(sqlmapper.QueryForList <Model.InvoiceJCDetail>("InvoiceJCDetail.select_by_invoiceid", invoice.InvoiceId)); }
public void Delete(Book.Model.InvoiceJC invoice) { sqlmapper.Delete("InvoiceJCDetail.delete_by_invoiceid", invoice.InvoiceId); }
private void _Insert(Book.Model.InvoiceJC invoice) { //往来单位 //if (invoice.Customer != null) //{ // invoice.CustomerId = invoice.Customer.CustomerId; //} // 库房 //invoice.DepotId = invoice.Depot.DepotId; //经手人 if (invoice.Employee0 != null) { 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.InvoiceJCDetail detail in invoice.Details) { if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId)) { continue; } detail.InvoiceId = invoice.InvoiceId; detail.InvoiceWeiHuaiRuQuantity = detail.InvoiceJCDetailQuantity; detail.InvoiceYiHuaiRuQuantity = 0; invoiceJCDetailAccessor.Insert(detail); Model.Product p = detail.Product; p.StocksQuantity += detail.InvoiceJCDetailQuantity.Value; productAccessor.Update(p); //if (detail.InvoiceProductUnit == p.ProductOuterPackagingUnit) //{ // quantity = detail.InvoiceJCDetailQuantity * p.ProductBaseUnitRelationship * p.ProductInnerUnitRelationship; //} //else if (detail.InvoiceProductUnit == detail.Product.ProductInnerPackagingUnit) //{ // quantity = detail.InvoiceJCDetailQuantity * p.ProductBaseUnitRelationship; //} //else //{ // quantity = detail.InvoiceJCDetailQuantity; //} 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.InvoiceJCDetailQuantity; stock.StockCurrentJC = stock.StockCurrentJR == null ? detail.InvoiceJCDetailQuantity : stock.StockCurrentJC - detail.InvoiceJCDetailQuantity; stock.DepotId = invoice.DepotId; stock.ProduceUnit = p.ProduceUnit.CnName; stockAccessor.Insert(stock); } else { stockAccessor.IncrementJC(depotpositionAccessor.Get(detail.DepotPositionId), p, detail.InvoiceJCDetailQuantity.Value); } } }