Разработка программного комплекса для автоматизации учета обслуживания и ремонта оборудования на ЭТЗ "Энергомера"

17. СанПиН 2.2.2.542 - 96. Гигиенические требования к видеодисплейным терминалам, персональным ЭВМ и организация работы. Госкомсанэпиднадзор России. - М., 1996.

18. СанПиН 2.2.2/2.4.1340-03. Гигиенические требования к персональным электронно-вычислительным машинам и организации работы. - М., 2003.

19. Хусаинов, Б. Структуры и алгоритмы обработки данных./ Б. Хусаинов. - М.: Финансы и статистика, 2004. - 464 с.

20. Экология и безопасность жизнедеятельности/ под ред. Л.А. Муравья - М.: ЮНИТИ - 2000.

ПРИЛОЖЕНИЕ А

Даталогическая модель БД

Размещено на http://www.allbest.ru/

Размещено на http://www.allbest.ru/

ПРИЛОЖЕНИЕ Б

Инфологическая модель БД

Приложение В

Диаграмма классов

Размещено на http://www.allbest.ru/

Размещено на http://www.allbest.ru/

ПРИЛОЖЕНИЕ Г

Листинг основных модулей

Модуль MainForm.cs

public partial class MainForm : Form

{

Excel.Application excelapp;

DataTable table;

string name_of_machine;

public MainForm()

{

InitializeComponent();

typeCB.SelectedIndex = 0;

}

private void BreakagetypeToolStripMenuItem_Click(object sender, EventArgs e)

{

using (BreakagetypeForm form = new BreakagetypeForm(false))

{

form.ShowDialog();

}

}

private void companyToolStripMenuItem_Click(object sender, EventArgs e)

{

using (CompanyForm form = new CompanyForm(false))

{

form.ShowDialog();

}

}

private void employeetypeToolStripMenuItem_Click(object sender, EventArgs e)

{

using (EmployeetypeForm form = new EmployeetypeForm(false))

{

form.ShowDialog();

}

}

private void itemToolStripMenuItem_Click(object sender, EventArgs e)

{

using (ItemForm form = new ItemForm(false))

{

form.ShowDialog();

}

}

private void operationToolStripMenuItem_Click(object sender, EventArgs e)

{

using (OperationForm form = new OperationForm(false))

{

form.ShowDialog();

}

}

private void addEmployeeToolStripMenuItem_Click(object sender, EventArgs e)

{

using (AddEmployeeForm form = new AddEmployeeForm())

{

if (form.ShowDialog() == DialogResult.OK)

{

MessageBox.Show("Данные успешно добавлены!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

}

}

}

private void addNodeToolStripMenuItem_Click(object sender, EventArgs e)

{

using (AddNodeForm form = new AddNodeForm())

{

if (form.ShowDialog() == DialogResult.OK)

{

MessageBox.Show("Данные успешно добавлены!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

}

}

}

private void serviceToolStripMenuItem_Click(object sender, EventArgs e)

{

using (AddServiceForm form = new AddServiceForm())

{

if (form.ShowDialog() == DialogResult.OK)

{

MessageBox.Show("Данные успешно добавлены!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

}

}

}

private void addReplacmentToolStripMenuItem_Click(object sender, EventArgs e)

{

using (AddReplacementForm form = new AddReplacementForm())

{

if (form.ShowDialog() == DialogResult.OK)

{

MessageBox.Show("Данные успешно добавлены!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

}

}

}

private void addMachineToolStripMenuItem_Click(object sender, EventArgs e)

{

using (AddMachineForm form = new AddMachineForm())

{

if (form.ShowDialog() == DialogResult.OK)

{

MessageBox.Show("Данные успешно добавлены!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

}

}

}

private void ShowBtn_Click(object sender, EventArgs e)

{

try

{

string qstr = "SELECT M.name, N.name, O.name, S.`date` FROM etz.machine as M INNER JOIN etz.node AS N ON (M.machine_id = N.machine) INNER JOIN etz.service AS S ON (S.node = N.node_id) INNER JOIN etz.operation AS O ON (S.operation = O.operation_id) WHERE S.date BETWEEN @begin_date AND @end_date";

switch (typeCB.SelectedIndex)

{

case 1:

qstr += " AND S.completed=1";

break;

case 2:

qstr += " AND S.completed=0";

break;

}

if (machineId != -1)

{

qstr += " AND M.machine_id=" + machineId.ToString();

}

using (MySqlConnection conn = new MySqlConnection(Properties.Settings.Default.etzConnectionString))

{

conn.Open();

MySqlParameter begin = new MySqlParameter("@begin_date", MySqlDbType.DateTime);

MySqlParameter end = new MySqlParameter("@end_date", MySqlDbType.DateTime);

begin.Value = beginDTP.Value;

end.Value = endDTP.Value;

using (MySqlCommand cmd = new MySqlCommand(qstr, conn))

{

cmd.Parameters.Add(begin);

cmd.Parameters.Add(end);

MySqlDataReader reader = cmd.ExecuteReader();

DataLV.Items.Clear();

table.Rows.Clear();

table.Columns.Clear();

for (int i = 0; i < reader.VisibleFieldCount; i++)

{

table.Columns.Add(i.ToString());

}

while (reader.Read())

{

string[] str = { reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), string.Format("{0}.{1}.{2}", ((DateTime)reader[3]).Day, ((DateTime)reader[3]).Month, ((DateTime)reader[3]).Year)};

DataRow r = table.NewRow();

for (int j=0;j<str.Length;j++)

{

r[j] = str[j];

}

ListViewItem item = new ListViewItem(str);

DataLV.Items.Add(item);

table.Rows.Add(r);

}

}

}

}

catch (System.Exception ex)

{

MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

}

private void replacementToolStripMenuItem_Click(object sender, EventArgs e)

{

using (ReplacementForm form = new ReplacementForm())

{

form.ShowDialog();

}

}

private void breakageToolStripMenuItem_Click(object sender, EventArgs e)

{

using (BreakageLogForm form = new BreakageLogForm())

{

form.ShowDialog();

}

}

private void exitToolStripMenuItem_Click(object sender, EventArgs e)

{

Application.Exit();

}

private void aboutToolStripMenuItem_Click(object sender, EventArgs e)

{

using (AboutForm form = new AboutForm())

{

form.ShowDialog();

}

}

private void mainExportToolStripMenuItem_Click(object sender, EventArgs e)

{

try

{

if (DataLV.Items.Count == 0)

{

MessageBox.Show("Эксрортировать нечего!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);

return;

}

if (saveFlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)

{

using (FileStream fs = new FileStream(saveFlg.FileName + ".html", FileMode.OpenOrCreate, FileAccess.Write))

{

using (StreamWriter sw = new StreamWriter(fs))

{

sw.Write(@"<br/>");

sw.Write(@"<table border=1 align=center>");

sw.Write(@"<tr><td><b>Станок</b></td><td><b>Узел</b></td><td><b>Операция</b></td><td><b>Дата</b></td></tr>");

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

{

sw.Write(@"<tr>");

sw.Write(@"<td>");

sw.Write(DataLV.Items[i].SubItems[0].Text);

sw.Write(@"</td>");

sw.Write(@"<td>");

sw.Write(DataLV.Items[i].SubItems[1].Text);

sw.Write(@"</td>");

sw.Write(@"<td>");

sw.Write(DataLV.Items[i].SubItems[2].Text);

sw.Write(@"</td>");

sw.Write(@"<td>");

sw.Write(DataLV.Items[i].SubItems[3].Text);

sw.Write(@"</td>");

}

sw.Write(@"</tr>");

sw.Write(@"</table>");

sw.Write(@"<br/>");

sw.Write(@"<center>");

sw.Write(string.Format("{0}.{1}.{2}", DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year));

sw.Write(@"</center>");

}

}

MessageBox.Show("Данные эксрортированы!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

}

catch (System.Exception ex)

{

MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

}

private void SetFilterBtn_Click(object sender, EventArgs e)

{

using (FilterForm form = new FilterForm())

{

if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK)

{

machineId = form.Machine;

if (machineId == -1)

{

name_of_machine = "Все станки";

}

else

{

name_of_machine = form.MachineCB.Items[form.MachineCB.SelectedIndex].ToString();

}

}

}

}

private int machineId = -1;

private void MainForm_Load(object sender, EventArgs e)

{

using (StartForm form = new StartForm())

{

if (form.ShowDialog() != System.Windows.Forms.DialogResult.OK)

{

Application.Exit();

}

}

excelapp = new Excel.Application();

table = new DataTable();

name_of_machine = "";

}

private void button1_Click(object sender, EventArgs e)

{

Excel.Workbook book;

Excel.Worksheet sheet;

Excel.Sheets sheets;

Excel.Range cells;

excelapp.SheetsInNewWorkbook = 1;

excelapp.Workbooks.Add(Type.Missing);

book = excelapp.Workbooks[1];

sheets = book.Worksheets;

sheet = (Excel.Worksheet)sheets.get_Item(1);

sheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape;

try

{

cells = (Excel.Range)sheet.get_Range("A1");

sheet.Shapes.AddPicture(Application.StartupPath.ToString() + "\\1.jpg", Office.MsoTriState.msoFalse, Office.MsoTriState.msoTrue, cells.Left, cells.Top, 100, 25);

cells = (Excel.Range)sheet.get_Range("C1");

sheet.Shapes.AddPicture(Application.StartupPath.ToString() + "\\1.jpg", Office.MsoTriState.msoFalse, Office.MsoTriState.msoTrue, cells.Left, cells.Top, 100, 25);

}

catch

{ }

if (machineId == -1)

{

name_of_machine = "Все станки";

}

cells = (Excel.Range)sheet.get_Range("A2:D2");

cells.Merge();

cells.Value2 = "Отчет по обслуживанию в период с " + beginDTP.Value.ToShortDateString() + " по " + endDTP.Value.ToShortDateString(); ;

cells.HorizontalAlignment = Excel.Constants.xlCenter;

cells.get_Characters().Font.Size = 12;

cells = (Excel.Range)sheet.get_Range("A3:D3");

cells.Merge();

cells.Value2 = "Станок: "+ name_of_machine;

cells.HorizontalAlignment = Excel.Constants.xlCenter;

cells.get_Characters().Font.Size = 12;

cells = (Excel.Range)sheet.get_Range("A4:D4");

cells.Merge();

cells.Value2 = "Обслуживание: " + typeCB.Text;

cells.HorizontalAlignment = Excel.Constants.xlCenter;

cells.get_Characters().Font.Size = 12;

for (int k = 0; k < DataLV.Columns.Count; k++)

{

cells = (Excel.Range)sheet.Cells[6, k+1];

cells.Value2 = DataLV.Columns[k].Text;

cells.get_Characters().Font.Bold=true;

cells.BorderAround();

}

for (int i = 7; i < table.Rows.Count + 7; i++)

{

for (int j = 1; j < table.Columns.Count + 1; j++)

{

cells = (Excel.Range)sheet.Cells[i, j];

cells.Value2 = table.Rows[i - 7][j - 1].ToString();

cells.BorderAround();

}

}

sheet.Columns.AutoFit();

excelapp.Visible = true;

}

private void MainForm_FormClosed(object sender, FormClosedEventArgs e)

{

excelapp.Quit();

}

private void helpToolStripMenuItem_Click(object sender, EventArgs e)

{

}

private void toolStripMenuItem1_Click(object sender, EventArgs e)

{

}

private void добавитьПоломкуToolStripMenuItem_Click(object sender, EventArgs e)

{

using (Form1 form = new Form1())

{

form.ShowDialog();

}

}

ПРИЛОЖЕНИЕ Д

Диаграмма вариантов использования

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