Programmer:Stock Status Report 2: Difference between revisions

Content added Content deleted
(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...")
 
No edit summary
Line 38: Line 38:
public DataTable GetStockStatusTable(AutoCount.Authentication.UserSession userSession)
public DataTable GetStockStatusTable(AutoCount.Authentication.UserSession userSession)
{
{
AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(myUserSession);
AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(userSession);


//Filter Stock Location
//Filter Stock Location
Line 56: Line 56:
This example shows how to add a column "ReadyStock" and calculate the value using two existing values.
This example shows how to add a column "ReadyStock" and calculate the value using two existing values.
<syntaxhighlight lang="csharp">
<syntaxhighlight lang="csharp">
public DataTable GetStockStatusTableWithColumnExpression(BCE.Data.DBSetting dbSetting)
public DataTable GetStockStatusTableWithColumnExpression(AutoCount.Authentication.UserSession userSession)
{
{
BCE.AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new BCE.AutoCount.Stock.StockStatus.StockStatusHelper(dbSetting);
AutoCount.Stock.StockStatus.StockStatusHelper ssHelper = new AutoCount.Stock.StockStatus.StockStatusHelper(myUserSession);


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

ssHelper.Inquire();
ssHelper.Inquire();


Line 76: Line 75:
}
}
</syntaxhighlight>
</syntaxhighlight>



{{SeeAlsoStock}}
{{SeeAlsoStock}}
Retrieved from "https://wiki.autocountsoft.com/wiki/Programmer:Stock_Status_Report_2"