private void button1_Click(object sender, EventArgs e) { if ( (textBox1.Text != "") && (textBox2.Text != "") && (textBox3.Text != "") && (textBox4.Text != "") && (textBox5.Text != "") && (textBox6.Text != "") && (comboBoxForTariffNetNum.Text != "") && (comboBoxForKindPay.Text != "") ) { AddTarrif addTarif2 = new AddTarrif(); DataTable dt2 = new DataTable(); double a1 = double.Parse(textBox1.Text); double a2 = double.Parse(textBox2.Text); double a3 = double.Parse(textBox3.Text); double a4 = double.Parse(textBox4.Text); double a5 = double.Parse(textBox5.Text); double a6 = double.Parse(textBox6.Text); string variableForTariffNetNum = comboBoxForTariffNetNum.Text; string variableForKindPay = comboBoxForKindPay.Text; ObrabotkaTarrif ot = new ObrabotkaTarrif(); //создаем обект для работы с класом который все делает dt2 = ot.NewTariff(a1, a2, a3, a4, a5, a6, variableForTariffNetNum, variableForKindPay); //в дататейбл заносим новую тарифную сетку deleteFromBD(variableForTariffNetNum, variableForKindPay); //удаляем старое с бд writteToBD(dt2); //записываем все в бд dataGridViewTariffVuvod.DataSource = dt2; DataTable tempDT = new DataTable(); tempDT = addTarif2.ReturnDataTable(@"SELECT * FROM infTariff"); dataGridViewTariff.DataSource = tempDT; labelTariff.Text = tempDT.Rows.Count.ToString(); labelTariffVuvod.Text = dt2.Rows.Count.ToString(); } else { MessageBox.Show("заполните все поля"); } }
private void button4_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog().ToString() == "OK") { string tarifFile = openFileDialog1.FileName; AddTarrif at = new AddTarrif(); DataTable tarifKind = at.ReturnDataTable(tarifFile, @"SELECT DISTINCT TariffNetNum, KindPay FROM infTariff ORDER BY TariffNetNum, KindPay"); for (int i = 0; i < tarifKind.Rows.Count; i++) { DataTable tarifNet = new DataTable(); tarifNet = at.ReturnDataTable(tarifFile, @"SELECT * FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "' ORDER BY TariffNetNum, KindPay, WorkerRate"); ObrabotkaTarrif ot = new ObrabotkaTarrif(); tarifNet = ot.NewTariff ( double.Parse(tarifNet.Rows[0]["HourCost"].ToString()), double.Parse(tarifNet.Rows[1]["HourCost"].ToString()), double.Parse(tarifNet.Rows[2]["HourCost"].ToString()), double.Parse(tarifNet.Rows[3]["HourCost"].ToString()), double.Parse(tarifNet.Rows[4]["HourCost"].ToString()), double.Parse(tarifNet.Rows[5]["HourCost"].ToString()), tarifNet.Rows[0]["TariffNetNum"].ToString(), tarifNet.Rows[0]["KindPay"].ToString() );//в дататейбл заносим новую тарифную сетку at.deleteFromDB(@"DELETE FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "'"); // at.deleteFromDB(tarifFile, @"DELETE FROM infTariff WHERE TariffNetNum = '" + tarifKind.Rows[i]["TariffNetNum"].ToString() + "' AND KindPay = '" + tarifKind.Rows[i]["KindPay"].ToString() + "'"); writteToBD(tarifNet);//записываем все в бд dataGridViewTariffVuvod.DataSource = tarifNet; } } }
private void button1_Click(object sender, EventArgs e) { if ( (textBox1.Text != "") && (textBox2.Text != "") && (textBox3.Text != "") && (textBox4.Text != "") && (textBox5.Text != "") && (textBox6.Text != "") && (comboBoxForTariffNetNum.Text != "") && (comboBoxForKindPay.Text != "") ) { AddTarrif addTarif2 = new AddTarrif(); DataTable dt2 = new DataTable(); double a1 =double.Parse(textBox1.Text); double a2 =double.Parse(textBox2.Text); double a3 =double.Parse(textBox3.Text); double a4 =double.Parse(textBox4.Text); double a5 =double.Parse(textBox5.Text); double a6 = double.Parse(textBox6.Text); string variableForTariffNetNum = comboBoxForTariffNetNum.Text; string variableForKindPay = comboBoxForKindPay.Text; ObrabotkaTarrif ot = new ObrabotkaTarrif(); //создаем обект для работы с класом который все делает dt2 = ot.NewTariff(a1, a2, a3, a4, a5, a6, variableForTariffNetNum, variableForKindPay);//в дататейбл заносим новую тарифную сетку deleteFromBD(variableForTariffNetNum, variableForKindPay); //удаляем старое с бд writteToBD(dt2);//записываем все в бд dataGridViewTariffVuvod.DataSource = dt2; DataTable tempDT = new DataTable(); tempDT = addTarif2.ReturnDataTable(@"SELECT * FROM infTariff"); dataGridViewTariff.DataSource = tempDT; labelTariff.Text = tempDT.Rows.Count.ToString(); labelTariffVuvod.Text = dt2.Rows.Count.ToString(); } else MessageBox.Show("заполните все поля"); }