Разработка базы знаний и поддержки принятия решений предметной области компании, производящей автомобили

comboBox3.SelectedIndex = 0;

comboBox5.Items.Clear();

comboBox5.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT id_docymentacia FROM docymentacia where status_dok='Свободная'", 5);

comboBox5.SelectedIndex = 0;

}

private void button1_Click(object sender, EventArgs e)

{

int ikol = Convert.ToInt32(comboBox1.Text);

if (ikol >= 1 && ikol < 50) selectrow = 0;

if (ikol >= 50 && ikol < 100) selectrow = 1;

if (ikol >= 100 && ikol < 500) selectrow = 2;

if (ikol >= 500 && ikol < 1000) selectrow = 3;

if (ikol >= 1000) selectrow = 4;

DataSet thisDataSet2 = new DataSet();

thisDataSet2.Locale = System.Globalization.CultureInfo.InvariantCulture;

SqlDataAdapter kofAdapter = new SqlDataAdapter("SELECT id_resursi,tehn_proizv,sirie,energia,dopolnoboryd,oboryd,prochie FROM resursi", cls.Conn);

kofAdapter.Fill(thisDataSet2, "resursi");

resyrsi = new double[thisDataSet2.Tables[0].Rows.Count, 6];

resyrsitemp = new double[thisDataSet2.Tables[0].Rows.Count, 6];

globalkr = new double[thisDataSet2.Tables[0].Rows.Count, 2];

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

{

resyrsi[i, 0] = Convert.ToDouble(thisDataSet2.Tables[0].Rows[i]["id_resursi"]);

resyrsi[i, 1] = Convert.ToDouble(thisDataSet2.Tables[0].Rows[i]["sirie"]);

resyrsi[i, 2] = Convert.ToDouble(thisDataSet2.Tables[0].Rows[i]["energia"]);

resyrsi[i, 3] = Convert.ToDouble(thisDataSet2.Tables[0].Rows[i]["oboryd"]);

resyrsi[i, 4] = Convert.ToDouble(thisDataSet2.Tables[0].Rows[i]["dopolnoboryd"]);

resyrsi[i, 5] = Convert.ToDouble(thisDataSet2.Tables[0].Rows[i]["prochie"]);

}

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

for (int j = 1; j < 6; j++) resyrsi[i, j]=ikol*resyrsi[i, j];

double[] masmax,masmin;

masmax = new double[5];

masmin = new double[5];

double max, min;

for (int j = 1; j < 6; j++)

{

max=resyrsi[0, j];

min=resyrsi[0,j];

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

if (resyrsi[i, j] >= max) { max = resyrsi[i, j]; }

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

if (resyrsi[i, j] <= min) { min = resyrsi[i, j]; }

masmax[j-1] = max;

masmin[j-1] = min;

}

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

for (int j = 0; j < 6; j++) resyrsitemp[i, j]=resyrsi[i, j];

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

for (int j = 1; j < 6; j++) resyrsitemp[i, j] = (resyrsitemp[i, j]-masmin[j-1])/(masmax[j-1]-masmin[j-1]);

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

globalkr[i, 0] = resyrsitemp[i, 0];

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

for (int j = 1; j < 6; j++)

{

globalkr[i, 1] = globalkr[i, 1] + resyrsitemp[i, j] * massivkf[selectrow, j - 1];

}

maxglob1 = globalkr[0, 1];

maxglobi1 = (int)globalkr[0, 0];

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

{

if (globalkr[i, 1] >= maxglob1)

{

maxglob1 = globalkr[i, 1];

maxglobi1 = (int)globalkr[i, 0];

}

}

if (thisDataSet2.Tables[0].Rows.Count > 1)

{

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

if (globalkr[i, 1] != maxglob1)

{

maxglob2 = globalkr[i, 1];

maxglobi2 = (int)globalkr[i, 0];

break;

}

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

{

if (globalkr[i, 1] >= maxglob2 && globalkr[i, 1] != maxglob1)

{

maxglob2 = globalkr[i, 1];

maxglobi2 = (int)globalkr[i, 0];

}

}

}

listBox1.Items.Clear();

listBox2.Items.Clear();

if (thisDataSet2.Tables[0].Rows.Count > 1)

{

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

{

int id = Convert.ToInt32(thisDataSet2.Tables[0].Rows[i]["id_resursi"]);

if (id == maxglobi1)

{

listBox1.Items.Insert(0, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["tehn_proizv"]) + " (ГК = " + Math.Round(maxglob1,2) + ")");

listBox2.Items.Insert(0, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["id_resursi"]));

listBox3.Items.Insert(0, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["tehn_proizv"]));

}

}

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

{

int id = Convert.ToInt32(thisDataSet2.Tables[0].Rows[i]["id_resursi"]);

if (id == maxglobi2)

{

listBox1.Items.Insert(1, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["tehn_proizv"]) + " (ГК = " + Math.Round(maxglob2,2) + ")");

listBox2.Items.Insert(1, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["id_resursi"]));

listBox3.Items.Insert(1, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["tehn_proizv"]));

}

}

}

else

{

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

{

int id = Convert.ToInt32(thisDataSet2.Tables[0].Rows[i]["id_resursi"]);

Console.Write(id + " " + maxglobi1);

if (id == maxglobi1)

{

listBox1.Items.Insert(0, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["tehn_proizv"]) + " (ГК = " + Math.Round(maxglob1,2)+")");

listBox2.Items.Insert(0, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["id_resursi"]));

listBox3.Items.Insert(0, Convert.ToString(thisDataSet2.Tables[0].Rows[i]["tehn_proizv"]));

}

}

}

}

private void listBox1_SelectedIndexChanged(object sender, EventArgs e)

{

listBox3.SelectedIndex = listBox1.SelectedIndex;

listBox2.SelectedIndex = listBox1.SelectedIndex;

textBox3.Text = listBox3.SelectedItem.ToString();

textBox4.Text = listBox2.SelectedItem.ToString();

}

private void button2_Click(object sender, EventArgs e)

{

String id_proektnaproizv = textBox1.Text;

String nazvanie_proekta = textBox2.Text;

String kolvo = comboBox1.Text;

String id_master, id_resursi,id_docymentacia;

id_resursi=textBox4.Text;

comboBox4.SelectedIndex = comboBox2.SelectedIndex;

id_master = comboBox4.SelectedItem.ToString();

comboBox5.SelectedIndex = comboBox3.SelectedIndex;

id_docymentacia = comboBox5.SelectedItem.ToString();

SqlCommand command;

string insertQuery = @"insert into proizvodsto(id_proektnaproizv,nazvanie_proekta,id_master,id_resursi,id_docymentacia,kolvo) Values (@id_proektnaproizv,@nazvanie_proekta,@id_master,@id_resursi,@id_docymentacia,@kolvo)";

command = new SqlCommand(insertQuery, cls.Conn);

command.Parameters.Add("@id_proektnaproizv", SqlDbType.Int, 4);

command.Parameters["@id_proektnaproizv"].Value = id_proektnaproizv;

command.Parameters.Add("@nazvanie_proekta", SqlDbType.VarChar, 100);

command.Parameters["@nazvanie_proekta"].Value = nazvanie_proekta;

command.Parameters.Add("@id_master", SqlDbType.Int, 4);

command.Parameters["@id_master"].Value = id_master;

command.Parameters.Add("@id_resursi", SqlDbType.Int, 4);

command.Parameters["@id_resursi"].Value = id_resursi;

command.Parameters.Add("@id_docymentacia", SqlDbType.Int, 4);

command.Parameters["@id_docymentacia"].Value = id_docymentacia;

command.Parameters.Add("@kolvo", SqlDbType.Int, 4);

command.Parameters["@kolvo"].Value = kolvo;

int UspeshnoeIzmenenie1 = command.ExecuteNonQuery();

SqlCommand command2;

string updateQuery = @"update docymentacia set status_dok=@status_dok where id_docymentacia=@id_docymentacia";

command2 = new SqlCommand(updateQuery, cls.Conn);

command2.Parameters.Add("@status_dok", SqlDbType.VarChar, 50);

command2.Parameters["@status_dok"].Value = "Занята";

command2.Parameters.Add("@id_docymentacia", SqlDbType.Int, 4);

command2.Parameters["@id_docymentacia"].Value = id_docymentacia;

int UspeshnoeIzmenenie2 = command2.ExecuteNonQuery();

if ((UspeshnoeIzmenenie1 != 0) && (UspeshnoeIzmenenie2 != 0))

{

MessageBox.Show("Изменения внесены", "Изменение записи");

}

else

{

MessageBox.Show("Не удалось внести изменения", "Изменение записи");

}

DataSet thisDataSet = new DataSet();

thisDataSet.Locale = System.Globalization.CultureInfo.InvariantCulture;

// Add data from the Kompany table to the DataSet.

SqlDataAdapter resAdapter = new SqlDataAdapter("SELECT p.id_proektnaproizv,p.nazvanie_proekta,m.FIO,r.tehn_proizv,d.nazvanie,p.kolvo FROM proizvodsto as p, Master as m,resursi as r,docymentacia as d where p.id_master=m.id_master and p.id_resursi=r.id_resursi and p.id_docymentacia=d.id_docymentacia", cls.Conn);

resAdapter.Fill(thisDataSet, "proizvodsto");

BindingSource bindingSource = new BindingSource();

bindingSource.DataSource = thisDataSet;

bindingSource.DataMember = "proizvodsto";

bindingNavigator1.BindingSource = bindingSource;

dataGridView1.DataSource = bindingSource;

dataGridView1.Columns[0].HeaderText = "Код";

dataGridView1.Columns[1].HeaderText = "Проект";

dataGridView1.Columns[2].HeaderText = "Мастер";

dataGridView1.Columns[3].HeaderText = "Технология";

dataGridView1.Columns[4].HeaderText = "Документация";

dataGridView1.Columns[5].HeaderText = "Кол-во авто";

comboBox2.Items.Clear();

comboBox2.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

string komanda = "SELECT FIO FROM Master";

ReadDB(komanda, 2);

comboBox2.SelectedIndex = 0;

comboBox4.Items.Clear();

comboBox4.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT id_master FROM Master", 4);

comboBox4.SelectedIndex = 0;

comboBox3.Items.Clear();

comboBox3.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT nazvanie FROM docymentacia where status_dok='Свободная'", 3);

comboBox3.SelectedIndex = 0;

comboBox5.Items.Clear();

comboBox5.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT id_docymentacia FROM docymentacia where status_dok='Свободная'", 5);

comboBox5.SelectedIndex = 0;

}

private void button5_Click(object sender, EventArgs e)

{

cls.frm7.Close();

}

private void button3_Click(object sender, EventArgs e)

{

String id_proektnaproizv = textBox1.Text;

String nazvanie_proekta = textBox2.Text;

String kolvo = comboBox1.Text;

String id_master, id_resursi, id_docymentacia;

DataSet thisDataSet2 = new DataSet();

thisDataSet2.Locale = System.Globalization.CultureInfo.InvariantCulture;

SqlDataAdapter idAdapter = new SqlDataAdapter("SELECT d.id_docymentacia,p.kolvo FROM proizvodsto as p, Master as m,resursi as r,docymentacia as d where p.id_master=m.id_master and p.id_resursi=r.id_resursi and p.id_docymentacia=d.id_docymentacia and p.id_proektnaproizv="+id_proektnaproizv, cls.Conn);

idAdapter.Fill(thisDataSet2, "proizvodsto");

String id_doc2 = Convert.ToString(thisDataSet2.Tables[0].Rows[0]["id_docymentacia"]);

id_resursi = textBox4.Text;

comboBox4.SelectedIndex = comboBox2.SelectedIndex;

id_master = comboBox4.SelectedItem.ToString();

comboBox5.SelectedIndex = comboBox3.SelectedIndex;

id_docymentacia = comboBox5.SelectedItem.ToString();

SqlCommand command;

string updateQuery = @"update proizvodsto set nazvanie_proekta=@nazvanie_proekta,id_master=@id_master,id_resursi=@id_resursi,id_docymentacia=@id_docymentacia,kolvo=@kolvo where id_proektnaproizv=@id_proektnaproizv";

command = new SqlCommand(updateQuery, cls.Conn);

command.Parameters.Add("@nazvanie_proekta", SqlDbType.VarChar, 100);

command.Parameters["@nazvanie_proekta"].Value = nazvanie_proekta;

command.Parameters.Add("@id_master", SqlDbType.Int, 4);

command.Parameters["@id_master"].Value = id_master;

command.Parameters.Add("@id_resursi", SqlDbType.Int, 4);

command.Parameters["@id_resursi"].Value = id_resursi;

command.Parameters.Add("@id_docymentacia", SqlDbType.Int, 4);

command.Parameters["@id_docymentacia"].Value = id_docymentacia;

command.Parameters.Add("@kolvo", SqlDbType.Int, 4);

command.Parameters["@kolvo"].Value = kolvo;

command.Parameters.Add("@id_proektnaproizv", SqlDbType.Int, 4);

command.Parameters["@id_proektnaproizv"].Value = id_proektnaproizv;

int UspeshnoeIzmenenie1 = command.ExecuteNonQuery();

SqlCommand command4;

string updateQuery4 = @"update docymentacia set status_dok=@status_dok where id_docymentacia=@id_docymentacia";

command4 = new SqlCommand(updateQuery4, cls.Conn);

command4.Parameters.Add("@status_dok", SqlDbType.VarChar, 50);

command4.Parameters["@status_dok"].Value = "Свободная";

command4.Parameters.Add("@id_docymentacia", SqlDbType.Int, 4);

command4.Parameters["@id_docymentacia"].Value = id_doc2;

int UspeshnoeIzmenenie4 = command4.ExecuteNonQuery();

SqlCommand command3;

string updateQuery3 = @"update docymentacia set status_dok=@status_dok where id_docymentacia=@id_docymentacia";

command3 = new SqlCommand(updateQuery3, cls.Conn);

command3.Parameters.Add("@status_dok", SqlDbType.VarChar, 50);

command3.Parameters["@status_dok"].Value = "Занята";

command3.Parameters.Add("@id_docymentacia", SqlDbType.Int, 4);

command3.Parameters["@id_docymentacia"].Value = id_docymentacia;

int UspeshnoeIzmenenie3 = command3.ExecuteNonQuery();

if ((UspeshnoeIzmenenie1 != 0) && (UspeshnoeIzmenenie3 != 0) && (UspeshnoeIzmenenie4 != 0))

{

MessageBox.Show("Изменения внесены", "Изменение записи");

}

else

{

MessageBox.Show("Не удалось внести изменения", "Изменение записи");

}

DataSet thisDataSet = new DataSet();

thisDataSet.Locale = System.Globalization.CultureInfo.InvariantCulture;

SqlDataAdapter resAdapter = new SqlDataAdapter("SELECT p.id_proektnaproizv,p.nazvanie_proekta,m.FIO,r.tehn_proizv,d.nazvanie,p.kolvo FROM proizvodsto as p, Master as m,resursi as r,docymentacia as d where p.id_master=m.id_master and p.id_resursi=r.id_resursi and p.id_docymentacia=d.id_docymentacia", cls.Conn);

resAdapter.Fill(thisDataSet, "proizvodsto");

BindingSource bindingSource = new BindingSource();

bindingSource.DataSource = thisDataSet;

bindingSource.DataMember = "proizvodsto";

bindingNavigator1.BindingSource = bindingSource;

dataGridView1.DataSource = bindingSource;

dataGridView1.Columns[0].HeaderText = "Код";

dataGridView1.Columns[1].HeaderText = "Проект";

dataGridView1.Columns[2].HeaderText = "Мастер";

dataGridView1.Columns[3].HeaderText = "Технология";

dataGridView1.Columns[4].HeaderText = "Документация";

dataGridView1.Columns[5].HeaderText = "Кол-во авто";

comboBox2.Items.Clear();

comboBox2.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

string komanda = "SELECT FIO FROM Master";

ReadDB(komanda, 2);

comboBox2.SelectedIndex = 0;

comboBox4.Items.Clear();

comboBox4.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT id_master FROM Master", 4);

comboBox4.SelectedIndex = 0;

comboBox3.Items.Clear();

comboBox3.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT nazvanie FROM docymentacia where status_dok='Свободная'", 3);

comboBox3.SelectedIndex = 0;

comboBox5.Items.Clear();

comboBox5.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT id_docymentacia FROM docymentacia where status_dok='Свободная'", 5);

comboBox5.SelectedIndex = 0;

}

private void button4_Click(object sender, EventArgs e)

{

String id_proektnaproizv = textBox1.Text;

DataSet thisDataSet2 = new DataSet();

thisDataSet2.Locale = System.Globalization.CultureInfo.InvariantCulture;

SqlDataAdapter idAdapter = new SqlDataAdapter("SELECT d.id_docymentacia,p.kolvo FROM proizvodsto as p, Master as m,resursi as r,docymentacia as d where p.id_master=m.id_master and p.id_resursi=r.id_resursi and p.id_docymentacia=d.id_docymentacia and p.id_proektnaproizv=" + id_proektnaproizv, cls.Conn);

idAdapter.Fill(thisDataSet2, "proizvodsto");

String id_doc2 = Convert.ToString(thisDataSet2.Tables[0].Rows[0]["id_docymentacia"]);

SqlCommand command;

string deleteQuery = @"Delete proizvodsto where id_proektnaproizv=@id_proektnaproizv";

command = new SqlCommand(deleteQuery, cls.Conn);

command.Parameters.Add("@id_proektnaproizv", SqlDbType.Int, 4);

command.Parameters["@id_proektnaproizv"].Value = id_proektnaproizv;

int UspeshnoeIzmenenie = command.ExecuteNonQuery();

SqlCommand command4;

string updateQuery4 = @"update docymentacia set status_dok=@status_dok where id_docymentacia=@id_docymentacia";

command4 = new SqlCommand(updateQuery4, cls.Conn);

command4.Parameters.Add("@status_dok", SqlDbType.VarChar, 50);

command4.Parameters["@status_dok"].Value = "Свободная";

command4.Parameters.Add("@id_docymentacia", SqlDbType.Int, 4);

command4.Parameters["@id_docymentacia"].Value = id_doc2;

int UspeshnoeIzmenenie4 = command4.ExecuteNonQuery();

if ((UspeshnoeIzmenenie != 0) && (UspeshnoeIzmenenie4 != 0))

{

MessageBox.Show("Запись удалена", "Удаление записи");

}

else

{

MessageBox.Show("Не удалось удалить запись", "Удаление записи");

}

DataSet thisDataSet = new DataSet();

thisDataSet.Locale = System.Globalization.CultureInfo.InvariantCulture;

SqlDataAdapter resAdapter = new SqlDataAdapter("SELECT p.id_proektnaproizv,p.nazvanie_proekta,m.FIO,r.tehn_proizv,d.nazvanie,p.kolvo FROM proizvodsto as p, Master as m,resursi as r,docymentacia as d where p.id_master=m.id_master and p.id_resursi=r.id_resursi and p.id_docymentacia=d.id_docymentacia", cls.Conn);

resAdapter.Fill(thisDataSet, "proizvodsto");

BindingSource bindingSource = new BindingSource();

bindingSource.DataSource = thisDataSet;

bindingSource.DataMember = "proizvodsto";

bindingNavigator1.BindingSource = bindingSource;

dataGridView1.DataSource = bindingSource;

dataGridView1.Columns[0].HeaderText = "Код";

dataGridView1.Columns[1].HeaderText = "Проект";

dataGridView1.Columns[2].HeaderText = "Мастер";

dataGridView1.Columns[3].HeaderText = "Технология";

dataGridView1.Columns[4].HeaderText = "Документация";

dataGridView1.Columns[5].HeaderText = "Кол-во авто";

comboBox2.Items.Clear();

comboBox2.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

string komanda = "SELECT FIO FROM Master";

ReadDB(komanda, 2);

comboBox2.SelectedIndex = 0;

comboBox4.Items.Clear();

comboBox4.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT id_master FROM Master", 4);

comboBox4.SelectedIndex = 0;

comboBox3.Items.Clear();

comboBox3.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT nazvanie FROM docymentacia where status_dok='Свободная'", 3);

comboBox3.SelectedIndex = 0;

comboBox5.Items.Clear();

comboBox5.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

ReadDB("SELECT id_docymentacia FROM docymentacia where status_dok='Свободная'", 5);

comboBox5.SelectedIndex = 0;

}

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)

{

DataSet thisDataSet2 = new DataSet();

thisDataSet2.Locale = System.Globalization.CultureInfo.InvariantCulture;

SqlDataAdapter kofAdapter = new SqlDataAdapter("SELECT id_resursi,tehn_proizv,sirie,energia,dopolnoboryd,oboryd,prochie FROM resursi", cls.Conn);

kofAdapter.Fill(thisDataSet2, "resursi");

textBox1.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value + "";

textBox2.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[1].Value + "";

for (int i = 0; i < comboBox2.Items.Count; i++)

{

if (dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value + "" == comboBox2.Items[i].ToString())

{

comboBox2.SelectedIndex = i;

comboBox4.SelectedIndex = i;

}

}

textBox3.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[3].Value + "";

for (int i = 0; i < thisDataSet2.Tables[0].Rows.Count; i++)

{

String tehn = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[3].Value + "";

String tehn2 = Convert.ToString(thisDataSet2.Tables[0].Rows[i]["tehn_proizv"]);

if (tehn == tehn2)

{

textBox4.Text = Convert.ToString(thisDataSet2.Tables[0].Rows[i]["id_resursi"]);

break;

}

}

for (int i = 0; i < comboBox3.Items.Count; i++)

{

if (dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[4].Value + "" == comboBox3.Items[i].ToString())

{

comboBox3.SelectedIndex = i;

comboBox5.SelectedIndex = i;

}

}

comboBox1.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[5].Value + "";

}

private void Form7_FormClosed(object sender, FormClosedEventArgs e)

{

cls.frm2 = new Form2();

cls.frm2.Show();

}

private void button6_Click(object sender, EventArgs e)

{

DataSet thisDataSet = new DataSet();

thisDataSet.Locale = System.Globalization.CultureInfo.InvariantCulture;

SqlDataAdapter resAdapter = new SqlDataAdapter("SELECT p.id_proektnaproizv,p.nazvanie_proekta,m.FIO,r.tehn_proizv,d.nazvanie,p.kolvo FROM proizvodsto as p, Master as m,resursi as r,docymentacia as d where p.id_master=m.id_master and p.id_resursi=r.id_resursi and p.id_docymentacia=d.id_docymentacia", cls.Conn);

resAdapter.Fill(thisDataSet, "proizvodsto");

Word.Application word = new Word.Application(); //создаем COM-объект Word

word.Visible = true;

Word.Document doc = word.Documents.Add();

doc.Select();

word.Selection.TypeText(" Отчет по производству!\r\n");

for (int i = 0; i < thisDataSet.Tables[0].Rows.Count; i++)

{

word.Selection.TypeText("Код проекта: " + Convert.ToString(thisDataSet.Tables[0].Rows[i]["id_proektnaproizv"]) + "\n");

word.Selection.TypeText("Проект: " + Convert.ToString(thisDataSet.Tables[0].Rows[i]["nazvanie_proekta"]) + "\n");

word.Selection.TypeText("Мастер: " + Convert.ToString(thisDataSet.Tables[0].Rows[i]["FIO"]) + "\n");

word.Selection.TypeText("Производство по технологии: " + Convert.ToString(thisDataSet.Tables[0].Rows[i]["tehn_proizv"]) + "\n");

word.Selection.TypeText("Документация: " + Convert.ToString(thisDataSet.Tables[0].Rows[i]["nazvanie"]) + "\n");

word.Selection.TypeText("Партия автомобилей в количестве: " + Convert.ToString(thisDataSet.Tables[0].Rows[i]["kolvo"]) + ", шт.\n");

word.Selection.TypeText("\r\n");

}

word = null;

}

}

}

Размещено на Allbest.ru