2,743
edits
Programmer:Stock Status Report: Difference between revisions
Undo revision 12936 by DanielY (talk)
No edit summary |
Tag: Undo |
||
Line 1:
==References of AutoCount Accounting version
{{BaseReferenceAC18}}
'''BCE.AutoCount.StockMaint.dll'''
'''BCE.AutoCount.Stock.dll'''
==Get all tables in the DataSet of Stock Status==
<syntaxhighlight lang="csharp">
public DataSet GetStockStatusDataSet(
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(
//No filter, warning without filter will load all data
Line 29:
==Get the Table of Stock Status with filter==
<syntaxhighlight lang="csharp">
public DataTable GetStockStatusTable(
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(
//Filter Stock Location
BCE.AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
crit.LocationFilter.Type = BCE.AutoCount.SearchFilter.FilterType.ByRange;
crit.LocationFilter.From = "HQ";
crit.LocationFilter.To = "HQ";
Line 49:
This example shows how to add a column "ReadyStock" and calculate the value using two existing values.
<syntaxhighlight lang="csharp">
public DataTable GetStockStatusTableWithColumnExpression(
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(
//Filter Stock Location
BCE.AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
crit.LocationFilter.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
crit.LocationFilter.Add("HQ");
| |||