private void lkRoute_EditValueChanged(object sender, EventArgs e) { Institution rec = new Institution(); if (lkRoute.EditValue.ToString() == "0") { lkIssuedTo.Properties.DataSource = rec.GetFacilitiesThatEverReceivedItems(); ; } else { lkIssuedTo.Properties.DataSource = rec.GetAllUnderRoute(Convert.ToInt32(lkRoute.EditValue)); } }
/// <summary> /// Gets the issues by receiving unit faster. /// </summary> /// <param name="storeID">The store ID.</param> /// <param name="routeID">The route ID.</param> /// <param name="type">The type.</param> /// <returns></returns> /// Shit: what a name? and it does crazy stuff too. public DataTable GetIssuesByReceivingUnitFaster(int storeID, int routeID, int type) { var ru = new Institution(); if (Settings.IsRdfMode) ru.GetFacilitiesThatEverReceivedItems(); else ru.GetAllUnderRoute(routeID); //Load all the items. var query = HCMIS.Repository.Queries.Item.SelectGetIssuesByReceivingUnitFaster(type); this.LoadFromRawSql(query); //Add the columns while (!ru.EOF) { this.AddColumn(string.Format("{0},{1}", ru.Name, ru.ID), typeof(int)); ru.MoveNext(); } while (!this.EOF) { Institution rus = new Institution(); if (Settings.IsRdfMode) rus.GetFacilitiesThatEverReceivedItems(); else rus.GetAllUnderRoute(routeID); while (!rus.EOF) { int itemID = int.Parse(this.GetColumn("ID").ToString()); var itm = new Item(); var issueQuery = HCMIS.Repository.Queries.Item.SelectGetIssuesByReceivingUnitFasterIssueQuery(itemID, rus.ID); itm.LoadFromRawSql(issueQuery); if (itm.RowCount > 0 && !itm.IsColumnNull("Quantity")) this.SetColumn(string.Format("{0},{1}", ru.Name, ru.ID), itm.GetColumn("Quantity")); rus.MoveNext(); } this.MoveNext(); } return this.DataTable; }