Programmer:Stock Status Report 2

From AutoCount Resource Center
Revision as of 03:09, 31 January 2023 by DanielY (talk | contribs) (Created page with "==References of AutoCount Accounting version 2.1== *nuget package "AutoCount2.Stock" AutoCount.dll AutoCount.Accounting.dll AutoCount.UI.dll AutoCount.Images.dll AutoCount.Accounting.UI.dll AutoCount.Inquiry.dll AutoCount.Invoicing.dll '''AutoCount.Stock.dll''' ==Get all tables in the DataSet of Stock Status== <syntaxhighlight lang="csharp"> public DataSet GetStockStatusDataSet(AutoCount.Authentication.UserSession userSession) { AutoCount.Stock.StockStatus...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

References of AutoCount Accounting version 2.1

  • nuget package "AutoCount2.Stock"
AutoCount.dll
AutoCount.Accounting.dll
AutoCount.UI.dll
AutoCount.Images.dll
AutoCount.Accounting.UI.dll
AutoCount.Inquiry.dll
AutoCount.Invoicing.dll
AutoCount.Stock.dll


Get all tables in the DataSet of Stock Status

public DataSet GetStockStatusDataSet(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(myUserSession);

    //No filter, warning without filter will load all data

    ssHelper.Inquire();
    return ssHelper.ResultDataSet;
}
  • The DataSet has 3 tables, below are the table names:
    1. Master - Contains basic data of item
    2. Detail - Stock Status of the item
    3. SubDetail - Documents for reference

Get the Table of Stock Status with filter

public DataTable GetStockStatusTable(AutoCount.Authentication.UserSession userSession)
{
    AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(myUserSession);

    //Filter Stock Location
    AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
    crit.LocationFilter.Type = AutoCount.SearchFilter.FilterType.ByRange;
    crit.LocationFilter.From = locationFrom;
    crit.LocationFilter.To = locationTo;

    ssHelper.Inquire();
    DataTable tblResult = ssHelper.ResultDataSet.Tables["Detail"];
    return tblResult;
}


Add a column of expression to stock status table

This example shows how to add a column "ReadyStock" and calculate the value using two existing values.

public DataTable GetStockStatusTableWithColumnExpression(BCE.Data.DBSetting dbSetting)
{
    BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSetting);

    //Filter Stock Location
    AutoCount.Stock.StockStatus.StockStatusCriteria crit = ssHelper.Criteria;
    crit.LocationFilter.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
    crit.LocationFilter.Add("HQ");

    ssHelper.Inquire();

    DataTable dtDtl = ssHelper.ResultDataSet.Tables["Detail"];
    if (!dtDtl.Columns.Contains("ReadyStock"))
    {
        dtDtl.Columns.Add("ReadyStock", typeof(decimal), "OnHandQty - CSGNBalQty");
    }

    return dtDtl;
}


See Also

See Also Report API

Category Reporting
AR
AP
Stock
Sales
Purchase

Go to menu

Go to top
Resources For AutoCount Software Developers