//tested #region gives data at Modify ordering datas - strippings /// <summary> /// collect the stripping pool of chosen product /// </summary> /// <param name="prodId"></param> /// <returns></returns> public List <string> getThePoolOfStrippings(int prodId) { List <string> listStripName = new List <string>(); try { modellerRead = new OrderingModellerReadIn(dbci, parentMainWin); stripList = modellerRead.getStripPoolOfOrderingChoose(prodId.ToString()); if (stripList.Count == 0) { listStripName.Add("Nincs kiszerelés"); return(listStripName); } foreach (OrderingStrippingToChoose row in stripList) { listStripName.Add(row.termekkiszerel.ToString()); } } catch (ErrorServiceGetTheStripPool e) { throw new ErrorServiceOrdering(e.Message); } catch (Exception e) { throw new ErrorServiceOrdering("Ismeretlen hiba történt (ServOrdStripCollect) " + e.Message); } return(listStripName); }
/// <summary> /// construct the DataTable of Cancelled orderings /// </summary> /// <returns>DataTable of CancelledOrderings</returns> public DataTable getCancelledOrdersDataTable() { DataTable table = new DataTable(); table.Columns.Add("Srsz.", typeof(int)); table.Columns.Add("Terméknév", typeof(string)); table.Columns.Add("Kiszerelés", typeof(string)); table.Columns.Add("Menyyiség", typeof(int)); table.Columns.Add("Beszállító", typeof(string)); table.Columns.Add("Bejegyzés", typeof(DateTime)); table.Columns.Add("Törölve", typeof(string)); for (int i = 0; i < 7; i++) { table.Columns[i].ReadOnly = true; } try { modellerRead = new OrderingModellerReadIn(dbci, parentMainWin); cancelledList = modellerRead.getListOfCancelledOrderings(); foreach (OrderingCancelled rec in cancelledList) { table.Rows.Add(rec.beszerId, rec.termekNev, rec.termekKiszer, rec.beszerzMennyis, rec.termekBeszall, rec.beszerzDatum, rec.beszerzLemond); } } catch (ErrorServiceCreateDataList e) { throw new ErrorServiceOrdering(e.Message); } catch (Exception e) { throw new ErrorServiceOrdering("Adattábla alkotásánál ismeretlen hiba történt (ServOrdCanc) " + e.Message); } return(table); }
//tested #region gives data at Modify ordering datas - products /// <summary> /// collects the pool of productions /// </summary> /// <returns>the list of product names</returns> public List <string> getThePoolOfProductions_ProdSubcontrKeys() { List <string> listProdName = new List <string>(); try { modellerRead = new OrderingModellerReadIn(dbci, parentMainWin); prodList = modellerRead.getProdPoolOfOrderingChoose(); foreach (OrderingProdToChoose row in prodList) { listProdName.Add(row.termekNev + "_" + row.beszallitoId); } } catch (ErrorServiceGetTheProdPool e) { throw new ErrorServiceOrdering(e.Message); } catch (Exception e) { throw new ErrorServiceOrdering("Isermetlen hiba történt (ServOrdProdCollect) " + e.Message); } return(listProdName); }