public static DataTable GetStockStatusByAccountDamagedExcluded(int AccountID,bool showUnitPrice = false)
{
string query;
if(showUnitPrice)
{
query = HCMIS.Repository.Queries.Balance.SelectGetStockStatusByAccountDamagedExcludedShowUnitPrice(AccountID);
}
else
{
query = HCMIS.Repository.Queries.Balance.SelectGetStockStatusByAccountDamagedExcludedHideUnitPrice(AccountID);
}
Balance balance = new Balance();
balance.LoadFromRawSql(query);
balance.AddColumn("LineNo", typeof(int));
int i = 1;
while (!balance.EOF)
{
balance.SetColumn("LineNo", i++);
balance.MoveNext();
}
return balance.DataTable;
}
