public static DataTable GetInvetoryPeriodByWarehouse(int warehouseId) { string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriodByWarehouse(warehouseId); InventoryPeriod period = new InventoryPeriod(); period.LoadFromRawSql(query); return period.DataTable; }
public static bool HasUnCommited(int periodID, int activityID) { InventoryPeriod period = new InventoryPeriod(); string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasUnCommited(periodID, activityID); period.LoadFromRawSql(query); return(period.Getint("Count") > 0); }
public static DataTable GetInventoryPeriodDatesByWareHouse(int WarehouseID) { string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInventoryPeriodDatesByWareHouse(WarehouseID); InventoryPeriod period = new InventoryPeriod(); period.LoadFromRawSql(query); return(period.DataTable); }
internal static bool HasInCompleteReceives(int activityID, int physicalStoreID) { InventoryPeriod period = new InventoryPeriod(); string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasInCompleteReceives(activityID, physicalStoreID, ReceiptConfirmationStatus.Constants.GRV_PRINTED); period.LoadFromRawSql(query); return(period.Getint("Count") > 0); }
public static DataTable GetInvetoryPeriods() { string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriods(); InventoryPeriod period = new InventoryPeriod(); period.LoadFromRawSql(query); return(period.DataTable); }
public static DataTable GetInvetoryPeriods(int physicalStoreId, int?Status = null) { if (Status == null) { string query = HCMIS.Repository.Queries.InventoryPeriod.GetInvetoryPeriods(physicalStoreId); InventoryPeriod period = new InventoryPeriod(); period.LoadFromRawSql(query); return(period.DataTable); } else { string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriods(physicalStoreId, Status); InventoryPeriod period = new InventoryPeriod(); period.LoadFromRawSql(query); return(period.DataTable); } }
public static DataTable GetInvetoryPeriods(int physicalStoreId,int? Status=null) { if (Status == null) { string query = HCMIS.Repository.Queries.InventoryPeriod.GetInvetoryPeriods(physicalStoreId); InventoryPeriod period = new InventoryPeriod(); period.LoadFromRawSql(query); return period.DataTable; } else { string query = HCMIS.Repository.Queries.InventoryPeriod.SelectGetInvetoryPeriods(physicalStoreId, Status); InventoryPeriod period = new InventoryPeriod(); period.LoadFromRawSql(query); return period.DataTable; } }
public static bool HasUnCommited(int periodID, int activityID) { InventoryPeriod period = new InventoryPeriod(); string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasUnCommited(periodID, activityID); period.LoadFromRawSql(query); return period.Getint("Count") > 0; }
internal static bool HasInCompleteReceives(int activityID,int physicalStoreID) { InventoryPeriod period = new InventoryPeriod(); string query = HCMIS.Repository.Queries.InventoryPeriod.SelectHasInCompleteReceives(activityID, physicalStoreID, ReceiptConfirmationStatus.Constants.GRV_PRINTED); period.LoadFromRawSql(query); return period.Getint("Count") > 0; }