public static DataView SOHForFinance(int activityId, int periodId)
{
var query = HCMIS.Repository.Queries.Inventory.SelectSOHForFinance(activityId, periodId);
BLL.Inventory inventory = new Inventory();
inventory.FlushData();
inventory.LoadFromRawSql(query);
return inventory.DefaultView;
}
public static DataView GetOverageShortageReport(int activityId, int warehouseId, string periodIds)
{
var query = HCMIS.Repository.Queries.Inventory.SelectGetOverageShortageReport(activityId, warehouseId, periodIds);
BLL.Inventory inventory = new Inventory();
inventory.FlushData();
inventory.LoadFromRawSql(query);
return inventory.DefaultView;
}
public static DataView SOHForFinance(int activityId, int periodId)
{
var query = HCMIS.Repository.Queries.Inventory.SelectSOHForFinance(activityId, periodId);
BLL.Inventory inventory = new Inventory();
inventory.FlushData();
inventory.LoadFromRawSql(query);
return(inventory.DefaultView);
}
public static DataView GetOverageShortageAggregateReport(int activityId, int warehouseId, string periodIds)
{
var query = HCMIS.Repository.Queries.Inventory.SelectGetOverageShortageAggregateReport(activityId, warehouseId, periodIds);
BLL.Inventory inventory = new Inventory();
inventory.FlushData();
inventory.LoadFromRawSql(query);
return(inventory.DefaultView);
}