/// <summary> /// Формирование списка изображений /// </summary> /// <param name="__id"></param> /// <returns></returns> private List <ImageResource> GetImagesList(int __id) { List <ImageResource> imgList = new List <ImageResource>(); // Извлекаем данные из БД dsParserTableAdapters.tInventImagesTableAdapter ta = new dsParserTableAdapters.tInventImagesTableAdapter(); dsParser.tInventImagesDataTable tbl = ta.GetDataByInventItemId(__id); foreach (dsParser.tInventImagesRow row in tbl) { imgList.Add(new ImageResource(__id, row.Url, ExportFile.FilePath.FullName)); } return(imgList); }
/// <summary> /// Записывает данные товара в БД /// </summary> public void RegisterInventItem() { if (Url.Length > 0 && Parent != null) { dsParserTableAdapters.tInventItemsTableAdapter taInventItems = new dsParserTableAdapters.tInventItemsTableAdapter(); dsParser.tInventItemsDataTable tblInventItems = taInventItems.GetDataByUrl(Url); dsParser.tInventItemsRow rowInventItems; if (tblInventItems.Rows.Count > 0) { rowInventItems = (dsParser.tInventItemsRow)tblInventItems.Rows[0]; } else { rowInventItems = tblInventItems.NewtInventItemsRow(); rowInventItems.Url = Url; } // Обновление данных товара rowInventItems.ParentId = Parent.Id; rowInventItems.Name = Name; rowInventItems.ShortDescr = ShortDescr; rowInventItems.Descr = Descr; rowInventItems.OldPrice = (decimal)OldPrice; rowInventItems.Price = (decimal)Price; if (rowInventItems.RowState == System.Data.DataRowState.Detached) { tblInventItems.Rows.Add(rowInventItems); } taInventItems.Update(tblInventItems); // Сохранение данных о картинках dsParserTableAdapters.tInventImagesTableAdapter taImages = new dsParserTableAdapters.tInventImagesTableAdapter(); dsParser.tInventImagesDataTable tblImages; dsParser.tInventImagesRow rowImages; foreach (string imageUrl in Images) { tblImages = taImages.GetDataByUrl(rowInventItems.Id, imageUrl); if (tblImages.Rows.Count == 0) { rowImages = tblImages.NewtInventImagesRow(); rowImages.InventItemId = rowInventItems.Id; rowImages.Url = imageUrl; tblImages.Rows.Add(rowImages); taImages.Update(tblImages); } } // Сохранение данных о характеристиках dsParserTableAdapters.tInventOptionsTableAdapter taOptions = new dsParserTableAdapters.tInventOptionsTableAdapter(); dsParser.tInventOptionsDataTable tblOptions; dsParser.tInventOptionsRow rowOptions; foreach (InventItemOption optionItem in Options) { tblOptions = taOptions.GetDataByName(rowInventItems.Id, optionItem.Name); if (tblOptions.Rows.Count > 0) { rowOptions = (dsParser.tInventOptionsRow)tblOptions.Rows[0]; } else { rowOptions = tblOptions.NewtInventOptionsRow(); rowOptions.InventItemId = rowInventItems.Id; rowOptions.Name = optionItem.Name; } rowOptions.Value = optionItem.Value; if (rowOptions.RowState == System.Data.DataRowState.Detached) { tblOptions.Rows.Add(rowOptions); } taOptions.Update(tblOptions); } } }