// Возвращение из базы данных информацию о авто
#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);
}
}
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);
}
}