コード例 #1
0
        // Возвращение из базы данных информацию о авто
        #region GetAuto
        public List <Automobile> GetAuto()
        {
            List <Automobile> automobiles = new List <Automobile>();
            SqlDataReader     reader      = null;

            using (SqlConnection connection = new SqlConnection(connectString))
            {
                SqlCommand command = new SqlCommand("SELECT * FROM CatalogAutomobile", connection);
                connection.Open();

                try
                {
                    reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        Automobile auto = new Automobile()
                        {
                            ID             = (int)reader[0],
                            nameAuto       = reader[1].ToString(),
                            catalogId      = reader[2].ToString(),
                            catalogYears   = reader[3].ToString(),
                            productInStock = reader[4].ToString(),
                            model          = reader[5].ToString(),
                            imgPath        = reader[6].ToString(),
                            ImgLink        = reader[7].ToString(),
                            autoLink       = reader[8].ToString()
                        };
                        automobiles.Add(auto);
                    }
                }
                catch (Exception e)
                {
                    if (reader != null)
                    {
                        reader.Close();
                    }
                    throw e;
                }

                connection.Close();
                return(automobiles);
            }
        }
コード例 #2
0
        public void RunForm(ViewAuto viewAuto)
        {
            //ссылка на базу данных
            connect = new ConnectDB();
            //сылка на авто
            automobile = new Automobile();
            // создание списка авто
            List <Automobile> ListAuto = new List <Automobile>();

            // заполнение списка автомобилями из базы данных
            ListAuto = connect.GetAuto();


            DinemicCreatPanelView();

            #region DinemicCreatPanelView


            // динамическо содание блоков из списка авто
            void DinemicCreatPanelView()
            {
                CreadFlowPanel();

                for (int i = 0; i < ListAuto.Count; i++)
                {
                    CreatView(CreatePanel(i), ListAuto[i], CreateButton(i));
                }
            }

            Panel CreatePanel(int indexPanel)
            {
                Panel panel = new Panel();

                panel.Name = "Panel" + (indexPanel + 1);
                return(panel);
            }

            Button CreateButton(int nameIndex)
            {
                Button buttonDynamic = new Button();

                buttonDynamic.Name = "button" + (nameIndex + 1);
                return(buttonDynamic);
            }

            // создание скролящуюсь панель
            void CreadFlowPanel()
            {
                this.flowLayoutPanel1 = new System.Windows.Forms.FlowLayoutPanel();
                this.flowLayoutPanel1.SuspendLayout();
                this.flowLayoutPanel1.AutoScroll = true;

                this.flowLayoutPanel1.Dock     = System.Windows.Forms.DockStyle.Fill;
                this.flowLayoutPanel1.Location = new System.Drawing.Point(0, 0);
                this.flowLayoutPanel1.Name     = "flowLayoutPanel1";
                this.flowLayoutPanel1.Size     = new System.Drawing.Size(701, 561);
                this.flowLayoutPanel1.TabIndex = 9;
            }

            // шаблон из блока информации авто
            void CreatView(Panel panel, Automobile auto, Button button)
            {
                ///Добовление панелей на flowPanel
                this.flowLayoutPanel1.Controls.Add(panel);

                // panel = new System.Windows.Forms.Panel();
                panel.SuspendLayout();

                this.labelModel          = new System.Windows.Forms.Label();
                this.pictureBox0         = new System.Windows.Forms.PictureBox();
                this.labelProductInStock = new System.Windows.Forms.Label();
                this.labelName           = new System.Windows.Forms.Label();
                this.labelCatalogYears   = new System.Windows.Forms.Label();
                ((System.ComponentModel.ISupportInitialize)(this.pictureBox0)).BeginInit();
                viewAuto.SuspendLayout();

                //
                // panel1
                //
                panel.Controls.Add(this.labelModel);
                panel.Controls.Add(this.pictureBox0);
                panel.Controls.Add(this.labelProductInStock);
                panel.Controls.Add(this.labelName);
                panel.Controls.Add(this.labelCatalogYears);
                panel.Controls.Add(button);
                panel.Location = new System.Drawing.Point(10, 10);
                panel.Margin   = new System.Windows.Forms.Padding(10);                             // изменяем имя панели
                panel.Padding  = new System.Windows.Forms.Padding(5);
                panel.Size     = new System.Drawing.Size(200, 200);
                panel.TabIndex = 5;
                //
                // labelModel
                //
                this.labelModel.AutoSize = true;
                this.labelModel.Location = new System.Drawing.Point(9, 182);
                this.labelModel.Name     = "labelModel";
                this.labelModel.Size     = new System.Drawing.Size(34, 13);
                this.labelModel.TabIndex = 4;
                this.labelModel.Text     = auto.model;
                //
                // pictureBox0
                //
                this.pictureBox0.Dock     = System.Windows.Forms.DockStyle.Top;
                this.pictureBox0.Location = new System.Drawing.Point(5, 5);
                this.pictureBox0.Name     = "pictureBox0";
                this.pictureBox0.Size     = new System.Drawing.Size(190, 100);
                this.pictureBox0.TabIndex = 0;
                this.pictureBox0.TabStop  = false;
                string path = Environment.CurrentDirectory + auto.imgPath;

                this.pictureBox0.Image = Image.FromFile(path);
                //
                // labelProductInStock
                //
                this.labelProductInStock.AutoSize  = true;
                this.labelProductInStock.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0)))));
                this.labelProductInStock.Location  = new System.Drawing.Point(8, 128);
                this.labelProductInStock.Name      = "labelProductInStock";
                this.labelProductInStock.Size      = new System.Drawing.Size(122, 13);
                this.labelProductInStock.TabIndex  = 3;
                this.labelProductInStock.Text      = auto.productInStock;
                //
                // labelName
                //
                this.labelName.AutoSize = true;
                this.labelName.Font     = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204)));
                this.labelName.Location = new System.Drawing.Point(8, 108);
                this.labelName.Name     = "labelName";
                this.labelName.Size     = new System.Drawing.Size(92, 20);
                this.labelName.TabIndex = 1;
                this.labelName.Text     = auto.nameAuto;
                //
                // labelCatalogYears
                //
                this.labelCatalogYears.AutoSize = true;
                this.labelCatalogYears.Font     = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(204)));
                this.labelCatalogYears.Location = new System.Drawing.Point(106, 113);
                this.labelCatalogYears.Name     = "labelCatalogYears";
                this.labelCatalogYears.Size     = new System.Drawing.Size(86, 13);
                this.labelCatalogYears.TabIndex = 2;
                this.labelCatalogYears.Text     = auto.catalogYears;

                // button1
                //
                button.Font     = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204)));
                button.Location = new System.Drawing.Point(5, 145);
                button.Size     = new System.Drawing.Size(125, 34);
                button.Name     = button.Name;
                button.TabIndex = 5;
                button.Text     = "Каталог запчастей";
                button.UseVisualStyleBackColor = true;
                button.Click += Button1_Click;

                // ViewAuto
                //
                viewAuto.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
                viewAuto.AutoScaleMode       = System.Windows.Forms.AutoScaleMode.Font;
                viewAuto.ClientSize          = new System.Drawing.Size(701, 561);
                viewAuto.Controls.Add(this.flowLayoutPanel1);
                viewAuto.Name = "ViewAuto";
                viewAuto.Text = "ViewAuto";
                this.flowLayoutPanel1.ResumeLayout(false);
                panel.ResumeLayout(false);
                panel.PerformLayout();
                ((System.ComponentModel.ISupportInitialize)(this.pictureBox0)).EndInit();
                viewAuto.ResumeLayout(false);
            }
        }