private void PopulateLookups()
{
// cmbFilterStorageTypes.DataSource = StorageType.GetDataTableWithAll;
BLL.Shelf shelf = new BLL.Shelf();
shelf.LoadForMergedView();
gridShelfDetails.DataSource = shelf.DefaultView;
lkStorageTypes.Properties.DataSource = StorageType.AllStorageTypes;
cmbStorageTypeFilter.Properties.DataSource = StorageType.AllStorageTypes;
cmbStorageTypeFilter.EditValue = StorageType.BulkStore;
ps.LoadAll();
gridPhysicalStore.DataSource = ps.DefaultView;
psType.LoadAll();
gridWarehouse.DataSource = psType.DefaultView;
lkPhysicalStoreType.DataSource = psType.DefaultView;
lkWarehouse.Properties.DataSource = ps.DefaultView;
lkEditWarehouse.DataSource = ps.DefaultView;
cluster.LoadAll();
grdClusters.DataSource = cluster.DefaultView;
lkCluster.DataSource = cluster.DefaultView;
gridShelves.DataSource = Shelf.AllShelves;
gridShelvesView.ExpandAllGroups();
}
public static bool CheckOutStandingIssues(int warehouseID = 0)
{
Warehouse warehouse = new Warehouse();
warehouse.LoadAll();
string query =
HCMIS.Repository.Queries.IssueDoc.SelectCheckOutStandingIssues(warehouseID, warehouse.RowCount,
OrderStatus.Constant.ORDER_APPROVED,
OrderStatus.Constant.ISSUED);
IssueDoc issueDoc = new IssueDoc();
issueDoc.LoadFromRawSql(query);
return issueDoc.Getint("count") == 0;
}
public static bool CheckOutStandingIssues(int warehouseID = 0)
{
Warehouse warehouse = new Warehouse();
warehouse.LoadAll();
string query =
HCMIS.Repository.Queries.IssueDoc.SelectCheckOutStandingIssues(warehouseID, warehouse.RowCount,
OrderStatus.Constant.ORDER_APPROVED,
OrderStatus.Constant.ISSUED);
IssueDoc issueDoc = new IssueDoc();
issueDoc.LoadFromRawSql(query);
return(issueDoc.Getint("count") == 0);
}
