Programmer:Get Stock Cost: Difference between revisions
Content added Content deleted
No edit summary |
No edit summary |
||
Line 50: | Line 50: | ||
} |
} |
||
</syntaxhighlight> |
</syntaxhighlight> |
||
[[File:Prog StkBalwQtyCost.png|1200px| |
[[File:Prog StkBalwQtyCost.png|left|1200px|thumb|Stock Balance Table with Quantity and Cost Balance]]<br/> |
||
<br/><br/><br/><br/><br/><br/> |
|||
<br/> |
|||
[[Category:Programmer]] |
[[Category:Programmer]] |
||
[[Category:API]] |
[[Category:API]] |
Revision as of 04:58, 9 August 2018
Standard Cost
Get Standard Cost with ItemRecord
public decimal GetItemStandardCostWithItemRecord(BCE.Data.DBSetting dbSetting, string itemCode, string uom)
{
BCE.AutoCount.Data.ItemRecord itemRec = BCE.AutoCount.Data.CommonRecordUtils.GetItem(dbSetting, itemCode, uom);
return itemRec == null ? 0 : itemRec.Cost;
}
Get Standard Cost with StockHelper
public decimal GetItemStandardCostWithStockHelper(BCE.Data.DBSetting dbSetting, string itemCode, string uom)
{
BCE.AutoCount.Stock.StockHelper stkHelper = BCE.AutoCount.Stock.StockHelper.Create(dbSetting);
return stkHelper.GetFixedCost(itemCode, uom);
}
Most Recent Cost
public decimal GetRecentStockCost(BCE.Data.DBSetting dbSetting, string itemCode, string uom, string loc)
{
BCE.AutoCount.Stock.UTDCostHelper costHelper =
BCE.AutoCount.Stock.UTDCostHelper.Create(dbSetting, itemCode, uom, loc, null, DateTime.Today.Date);
return costHelper.GetMostRecentlyCost().Cost;
}
Up-to-date Cost
public decimal GetUpToDateUnitCost(BCE.Data.DBSetting dbSetting, string itemCode, string uom, decimal qty, DateTime date)
{
BCE.AutoCount.Stock.StockHelper stkHelper = BCE.AutoCount.Stock.StockHelper.Create(dbSetting);
return stkHelper.GetUpToDateUnitCost(itemCode, uom, qty, date);
}
Items' Stock Balance, Quantity and Costing Table
public System.Data.DataTable GetStockBalanceCostTable(BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.Stock.StockBalance.StockBalanceHelper sbHelper = new BCE.AutoCount.Stock.StockBalance.StockBalanceHelper(dbSetting);
sbHelper.Inquire(DateTime.Today.Date);
return sbHelper.ResultTable;
}
![](http://static.miraheze.org/autocountwiki/thumb/0/02/Prog_StkBalwQtyCost.png/1200px-Prog_StkBalwQtyCost.png)
![]() |
Go to top
|
![]() |
Resources For AutoCount Software Developers
|