private void MainForm_Load(object sender, EventArgs e) { try { ds = new ShopDataSet(); ds.ReadXml("shop.xml"); ds.products.DefaultView.Sort = "name"; ds.sellers.DefaultView.Sort = "name"; ds.buyers.DefaultView.Sort = "name"; productsList = new List <Product>(); chosenProductsList = new List <Product>(); foreach (DataRow r in ds.products.Rows) { Product product = new Product(); product.Id = Convert.ToInt32(r["id"]); product.Name = r["name"].ToString(); if (File.Exists("images\\" + r["photo"])) { FileStream fs = new FileStream("images\\" + r["photo"], FileMode.Open, FileAccess.Read); product.Photo = Image.FromStream(fs); } else { product.Photo = noPhoto; } product.Type = r["type"].ToString(); product.Category = r["category"].ToString(); product.Control = r["control"].ToString(); product.Consumption = r["consumption"].ToString(); product.Cameras = Convert.ToInt32(r["cameras"]); product.CArrangement = r["carrangement"].ToString(); product.Width = Convert.ToDouble(r["width"]); product.Height = Convert.ToDouble(r["height"]); product.Depth = Convert.ToDouble(r["depth"]); product.RVolume = r["rvolume"].ToString().Length > 0 ? Convert.ToInt32(r["rvolume"]) : 0; product.FVolume = r["fvolume"].ToString().Length > 0 ? Convert.ToInt32(r["fvolume"]) : 0; product.RDefrosting = r["rdefrosting"].ToString(); product.FDefrosting = r["fdefrosting"].ToString(); product.Power = Convert.ToDouble(r["power"]); product.Noise = Convert.ToDouble(r["noise"]); product.Price = Convert.ToDouble(r["price"]); product.Count = Convert.ToInt32(r["count"]); productsList.Add(product); shopProductsList.Items.Add(product.Name); } if (shopProductsList.Items.Count > 0) { shopProductsList.SelectedIndex = 0; } else { addToList.Enabled = false; } } catch (Exception) { MessageBox.Show("Ошибка чтения данных!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); Close(); } }
public override global::System.Data.DataSet Clone() { ShopDataSet cln = ((ShopDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { ShopDataSet ds = new ShopDataSet(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public SaleForm(ShopDataSet ds) { InitializeComponent(); this.ds = ds; }
public ProductsForm(ShopDataSet ds) { InitializeComponent(); this.ds = ds; }