AutoCount Resource Center

Programmer:Stock Status Report: Difference between revisions

Page Discussion

Programmer:Stock Status Report (view source)

Revision as of 10:42, 26 June 2019

18 bytes added ,  4 years ago
no edit summary
No edit summary
No edit summary
Line 1:
==References of AutoCount Accounting version 12.90==
{{BaseReferenceAC20}}
{{BaseReferenceAC18}}
'''BCE.AutoCount.StockMaint.dll'''
'''BCE.AutoCount.Stock.dll'''
 
==Get all tables in the DataSet of Stock Status==
<syntaxhighlight lang="csharp">
public DataSet GetStockStatusDataSet(BCEAutoCount.DataAuthentication.DBSettingUserSession dbSettinguserSession)
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSettinguserSession);
 
//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(BCEAutoCount.DataAuthentication.DBSettingUserSession dbSettinguserSession)
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSettinguserSession);
 
//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(BCEAutoCount.DataAuthentication.DBSettingUserSession dbSettinguserSession)
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSettinguserSession);
 
//Filter Stock Location
BCE.AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
crit.LocationFilter.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
crit.LocationFilter.Add("HQ");
 
Retrieved from "https://wiki.autocountsoft.com/wiki/Special:MobileDiff/12936"