public string GetItemData(string FromItemNo, int ReadMax, ref DataTable dtItems, ref DataTable dtSearchItems) { ItemListPage_Service itemlistpageservice = new ItemListPage_Service(); itemlistpageservice.UseDefaultCredentials = true; List <ItemListPage_Filter> ItemFilterArray = new List <ItemListPage_Filter>(); ItemListPage_Filter ItemBlockedFilter = new ItemListPage_Filter(); ItemBlockedFilter.Field = ItemListPage_Fields.Blocked; ItemBlockedFilter.Criteria = false.ToString(); ItemFilterArray.Add(ItemBlockedFilter); ItemListPage_Filter ItemSanaFilter = new ItemListPage_Filter(); ItemSanaFilter.Field = ItemListPage_Fields.Visible_in_Webshop; ItemSanaFilter.Criteria = true.ToString(); ItemFilterArray.Add(ItemSanaFilter); ItemListPage_Filter ItemLocationFilter = new ItemListPage_Filter(); ItemLocationFilter.Field = ItemListPage_Fields.Location_Filter; ItemLocationFilter.Criteria = Globals.theLocation; ItemFilterArray.Add(ItemLocationFilter); ItemListPage_Filter ItemNoFilter = new ItemListPage_Filter(); ItemNoFilter.Field = ItemListPage_Fields.No; ItemNoFilter.Criteria = FromItemNo; ItemFilterArray.Add(ItemNoFilter); ItemListPage[] Result = itemlistpageservice.ReadMultiple(ItemFilterArray.ToArray(), "", ReadMax); if (Result.Count() > 0) { var cellValue = ""; if (dtItems.Rows.Count > 0) { cellValue = dtItems.Rows[dtItems.Rows.Count - 1][0].ToString(); } dtSearchItems.Rows.Add(new object[] { string.Format("{0} {1} {2}", "", "", "") }); foreach (var item in Result) { if (!item.No.Equals(cellValue)) { dtItems.Rows.Add(new object[] { item.No, item.Description, item.Unit_Price, item.Sales_Unit_of_Measure, item.Inventory, item.Barcode_Base_UoM }); dtSearchItems.Rows.Add(new object[] { string.Format("{0} {1} {2}", item.No, item.Description, item.Barcode_Base_UoM) }); } } return(Result.Last().No); } else { return(""); } }
public string ReturnItemDescription(string ItemNo) { var service = new ItemListPage_Service(); service.UseDefaultCredentials = true; ItemListPage Result = service.Read(ItemNo); return(Result.Description); }
public void GetItemData() { ItemListPage_Service itemlistpageservice = new ItemListPage_Service(); itemlistpageservice.UseDefaultCredentials = true; List <ItemListPage_Filter> ItemFilterArray = new List <ItemListPage_Filter>(); ItemListPage_Filter ItemBlockedFilter = new ItemListPage_Filter(); ItemBlockedFilter.Field = ItemListPage_Fields.Blocked; ItemBlockedFilter.Criteria = false.ToString(); ItemFilterArray.Add(ItemBlockedFilter); ItemListPage_Filter ItemSanaFilter = new ItemListPage_Filter(); ItemSanaFilter.Field = ItemListPage_Fields.Visible_in_Webshop; ItemSanaFilter.Criteria = true.ToString(); ItemFilterArray.Add(ItemSanaFilter); ItemListPage_Filter ItemLocationFilter = new ItemListPage_Filter(); ItemLocationFilter.Field = ItemListPage_Fields.Location_Filter; ItemLocationFilter.Criteria = Globals.theLocation; ItemFilterArray.Add(ItemLocationFilter); ItemListPage[] Result = itemlistpageservice.ReadMultiple(ItemFilterArray.ToArray(), "", 5000); if (Result.Count() > 0) { dtSearchItems.Clear(); dtSearchItems.Columns.Clear(); dtSearchItems.Columns.Add(("Varedata"), typeof(string)); dtItems.Clear(); dtItems.Columns.Clear(); dtItems.Columns.Add(("Varenr."), typeof(string)); dtItems.Columns.Add(("Beskrivelse"), typeof(string)); dtItems.Columns.Add(("Pris"), typeof(decimal)); dtItems.Columns.Add(("Enhed"), typeof(string)); dtItems.Columns.Add(("Lager"), typeof(string)); dtItems.Columns.Add(("Stregkode"), typeof(string)); dtSearchItems.Rows.Add(new object[] { string.Format("{0} {1} {2}", "", "", "") }); foreach (var item in Result) { dtItems.Rows.Add(new object[] { item.No, item.Description, item.Unit_Price, item.Sales_Unit_of_Measure, item.Inventory, item.Barcode_Base_UoM }); dtSearchItems.Rows.Add(new object[] { string.Format("{0} {1} {2}", item.No, item.Description, item.Barcode_Base_UoM) }); } } }
public void FormatData() { if ((cbSearchType.Text.IndexOf(" ") > 0) && (!string.IsNullOrEmpty(cbSearchType.Text))) { itemno = cbSearchType.Text.Substring(0, (cbSearchType.Text.IndexOf(" "))); if (!string.IsNullOrEmpty(itemno)) { var service = new ItemListPage_Service(); service.UseDefaultCredentials = true; ItemListPage result = service.Read(itemno); tbDescription.Text = string.Format("Vare nr.: {0}{1}Beskrivelse: {2}{3}Beholdning: {4} {5}{6}Vejledende pris: {7}", result.No, Environment.NewLine, result.Description, Environment.NewLine, result.Inventory, result.Sales_Unit_of_Measure, Environment.NewLine, result.Unit_Price.ToString("N2")); cbSearchType.DroppedDown = false; tbQty.Focus(); } } }