Дипломная работа: Автоматизация услуг почтовой связи для Почты России

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
124
command.ExecuteNonQuery();//выполняем команду
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = command;//устанавливаем
команду
da.Fill(ds, "DZ");
dataGridView1.DataSource =
ds.Tables[0];//выводим в DataGridView
tabControl1.SelectTab("Table");
double balans = 0;//переменная для поля Сумма
foreach (DataGridViewRow row in
dataGridView1.Rows)//суммируем все отображаемые строки
{
double incom;
double.TryParse(row.Cells[7].Value.ToString().Replace(".",
","), out incom);
balans += incom;
}
NumberFormatInfo nfi = new
NumberFormatInfo();//формат числа с пробелами и двумя знаками
после запятой
nfi.NumberGroupSeparator = " ";//разделитель
textBox1.Text = balans.ToString("N", nfi);
}
private void comboBoxY_SelectedIndexChanged(object
sender, EventArgs e)
{
string ClientName =
comboBoxClientY.SelectedValue.ToString();
SqlCommand command = new SqlCommand("SELECT "
+ columnName + " FROM DZ WHERE Client=N'" + ClientName + "'",
sqlConnection);
command.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
125
DataSet ds = new DataSet();
da.SelectCommand = command;
da.Fill(ds, "DZ");
dataGridView2.DataSource = ds.Tables[0];
double balans = 0;
foreach (DataGridViewRow row in
dataGridView2.Rows)
{
double incom;
double.TryParse(row.Cells[7].Value.ToString().Replace(".",
","), out incom);
balans += incom;
}
NumberFormatInfo nfi = new NumberFormatInfo();
//new CultureInfo("en-US",
false).NumberFormat;
nfi.NumberGroupSeparator = " ";
textBox1.Text = balans.ToString("N", nfi);
}
private void
comboBoxBlokY_SelectedIndexChanged(object sender, EventArgs e)
{
string BlockName =
comboBoxBlockY.SelectedValue.ToString();
SqlCommand command = new SqlCommand("SELECT "
+ columnName + " FROM DZ WHERE ResponsibleBlock=N'" +
BlockName + "'", sqlConnection);
command.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = command;
da.Fill(ds, "DZ");
dataGridView2.DataSource = ds.Tables[0];
double balans = 0;
126
foreach (DataGridViewRow row in
dataGridView2.Rows)
{
double incom;
double.TryParse(row.Cells[7].Value.ToString().Replace(".",
","), out incom);
balans += incom;
}
NumberFormatInfo nfi = new NumberFormatInfo();
//new CultureInfo("en-US",
false).NumberFormat;
nfi.NumberGroupSeparator = " ";
textBox1.Text = balans.ToString("N", nfi);
}
private void
comboBoxDepartmentY_SelectedIndexChanged(object sender,
EventArgs e)
{
string DepartmentName =
comboBoxDepartmentY.SelectedValue.ToString();
SqlCommand command = new SqlCommand("SELECT "
+ columnName + " FROM DZ WHERE ResponsibleDepartment=N'" +
DepartmentName + "'", sqlConnection);
command.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = command;
da.Fill(ds, "DZ");
dataGridView2.DataSource = ds.Tables[0];
}
private void
comboBoxUnitY_SelectedIndexChanged(object sender, EventArgs e)
{
127
string UnitName =
comboBoxUnitY.SelectedValue.ToString();
SqlCommand command = new SqlCommand("SELECT "
+ columnName + " FROM DZ WHERE Unit=N'" + UnitName + "'",
sqlConnection);
command.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = command;
da.Fill(ds, "DZ");
dataGridView2.DataSource = ds.Tables[0];
}
private void
comboBoxMonth2Y_SelectedIndexChanged(object sender, EventArgs
e)
{
string MonthName =
comboBoxMonthY.SelectedValue.ToString();
//SqlCommand command = new SqlCommand("SELECT
" + "Unit AS Почтамт, KAY AS 'Код аналитического учета',
Client AS Клиент, Contract AS Договор," +
// "NumberOfContract AS 'Номер
договора',ContractDate AS 'Дата договора', Sum AS Сумма, INN
AS ИНН," +
// "ResponsibleBlock AS 'Ответственный
блок', ResponsibleDepartment AS 'Ответственный отдел',
right(convert(varchar, Month, 106), 8) AS Месяц" + " FROM DZ
WHERE Month=right(convert(varchar, '" + MonthName + "', 106),
8)", sqlConnection);
SqlCommand command = new SqlCommand("SELECT "
+ columnName + " FROM DZ WHERE Month=right(convert(varchar, '"
+ MonthName + "', 106), 8)", sqlConnection);
command.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
128
da.SelectCommand = command;
da.Fill(ds, "DZ");
dataGridView2.DataSource = ds.Tables[0];
double balans = 0;
foreach (DataGridViewRow row in
dataGridView2.Rows)
{
double incom;
double.TryParse(row.Cells[7].Value.ToString().Replace(".",
","), out incom);
balans += incom;
}
NumberFormatInfo nfi = new NumberFormatInfo();
//new CultureInfo("en-US",
false).NumberFormat;
nfi.NumberGroupSeparator = " ";
textBox1.Text = balans.ToString("N", nfi);
}
private void
comboBoxBlok_SelectedIndexChanged(object sender, EventArgs e)
{
string BlockName =
comboBoxBlok.SelectedValue.ToString();
SqlCommand command = new SqlCommand("SELECT "
+ columnName + " FROM DZ WHERE ResponsibleBlock=N'" +
BlockName + "'", sqlConnection);
command.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = command;
da.Fill(ds, "DZ");
dataGridView1.DataSource = ds.Tables[0];
tabControl1.SelectTab("Table");
Источник: https://baza.diplomsite.ru/previewfile/2349

Смотрите также:

Изложение содержания дела, по которому приняты судебные постановления
_-___-~1
_1-тема-СтрМетал