/// <summary> /// Gets the utilization. /// </summary> /// <param name="storageTypeID">The storage type ID.</param> /// <returns></returns> public DataTable GetUtilization(int storageTypeID) { string query = HCMIS.Repository.Queries.Shelf.SelectGetUtilization(storageTypeID); this.LoadFromRawSql(query); PalletLocation pl = new PalletLocation(); while (!this.EOF) { this.DataRow["Value"] = pl.CountUtilized(this.ID); this.MoveNext(); } return this.DataTable; }
/// <summary> /// Gets the utilization. /// </summary> /// <param name="storageTypeID">The storage type ID.</param> /// <returns></returns> public DataTable GetUtilization(int storageTypeID) { string query = HCMIS.Repository.Queries.Shelf.SelectGetUtilization(storageTypeID); this.LoadFromRawSql(query); PalletLocation pl = new PalletLocation(); while (!this.EOF) { this.DataRow["Value"] = pl.CountUtilized(this.ID); this.MoveNext(); } return(this.DataTable); }