Добавил:
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз: Предмет: Файл:
Отчёт по лабораторным.docx
Скачиваний:
2
Добавлен:
18.11.2022
Размер:
1.41 Mб
Скачать

InitializeComponent();

}

private void wordToolStripMenuItem_Click(object sender, EventArgs e)

{

saveFileDialog1.Filter = "документ Word|*.doc";

saveFileDialog1.ShowDialog();

}

private void excelToolStripMenuItem_Click(object sender, EventArgs e)

{

saveFileDialog1.Filter = "книга Excel|*.xls";

saveFileDialog1.ShowDialog();

}

private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)

{

if (saveFileDialog1.Filter.IndexOf("Word") >0)

{

CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, saveFileDialog1.FileName);

}

if (saveFileDialog1.Filter.IndexOf("Excel") > 0)

{

CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, saveFileDialog1.FileName);

}

}

}

}

Форма Продажи товаров:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Проектирование_интерфейсов__8

{

public partial class Form3 : Form

{

public Form3()

{

InitializeComponent();

}

private void wordToolStripMenuItem_Click(object sender, EventArgs e)

{

saveFileDialog1.Filter = "документ Word|*.doc";

saveFileDialog1.ShowDialog();

}

private void excelToolStripMenuItem_Click(object sender, EventArgs e)

{

saveFileDialog1.Filter = "книга Excel|*.xls";

saveFileDialog1.ShowDialog();

}

private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)

{

if (saveFileDialog1.Filter.IndexOf("Word") > 0)

{

CrystalReport21.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, saveFileDialog1.FileName);

}

if (saveFileDialog1.Filter.IndexOf("Excel") > 0)

{

CrystalReport21.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, saveFileDialog1.FileName);

}

}

}

}

Форма Выбор заказов покупателя:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Проектирование_интерфейсов__8

{

public partial class Form4 : Form

{

public Form4()

{

InitializeComponent();

}

private void Form4_Load(object sender, EventArgs e)

{

dataSet41.Clear();

sqlDataAdapter1.Fill(dataSet41.client);

}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{

crystalReportViewer1.SelectionFormula = "{Команда.key_client} = '" + comboBox1.SelectedValue + "'";

crystalReportViewer1.RefreshReport();

}

private void wordToolStripMenuItem_Click(object sender, EventArgs e)

{

saveFileDialog1.Filter = "документ Word|*.doc";

saveFileDialog1.ShowDialog();

}

private void excelToolStripMenuItem_Click(object sender, EventArgs e)

{

saveFileDialog1.Filter = "книга Excel|*.xls";

saveFileDialog1.ShowDialog();

}

private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)

{

if (saveFileDialog1.Filter.IndexOf("Word") > 0)

{

CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, saveFileDialog1.FileName);

}

if (saveFileDialog1.Filter.IndexOf("Excel") > 0)

{

CrystalReport11.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Excel, saveFileDialog1.FileName);

}

}

}

}

Форма Выбор заказов по объёму:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Проектирование_интерфейсов__8

{

public partial class Form5 : Form

{

public Form5()

{