Файл: Курсовая работа по предмету Разработка кода информационных систем Тема работы Разработка информационной системы для организации работы дорожных служб.docx
Добавлен: 28.03.2024
Просмотров: 101
Скачиваний: 4
ВНИМАНИЕ! Если данный файл нарушает Ваши авторские права, то обязательно сообщите нам.
Код основного окна
1 | using System; |
2 | using System.IO; |
3 | using System.Collections.Generic; |
4 | using System.Data.SqlClient; |
5 | using System.Drawing; |
6 | using System.Windows.Forms; |
7 | using System.Text; |
8 | |
9 | namespace testWork |
10 | { |
11 | public partial class Menu_men : Form |
12 | { |
13 | SqlConnection sqlConn; |
14 | bool dostoop = true; |
15 | int brigade = 0; |
16 | public Menu_men(bool dostoop, int brigade) |
17 | { |
18 | InitializeComponent(); |
19 | |
20 | this.dostoop = dostoop; |
21 | |
22 | this.brigade = brigade; |
23 | } |
24 | |
25 | |
26 | |
27 | private async void Menu_men_Load_1(object sender, EventArgs e) |
28 | { |
29 | string ConnStr = @"Data Source=62.63.74.62,1433;Initial Catalog=testWork;User ID=work;Password=0303";//строка подключения |
30 | |
31 | |
32 | sqlConn = new SqlConnection(ConnStr); |
33 | |
34 | await sqlConn.OpenAsync(); |
35 | |
36 | R_update_tasks(); |
37 | R_update_employee(); |
38 | |
39 | CheckBtnActivity1(); |
40 | CheckBtnActivity2(); |
41 | |
42 | if (!dostoop)//скрытие элементов для обычных сотрудников |
43 | { |
44 | add_task.Visible = false; |
45 | add_employee.Visible = false; |
46 | |
47 | ybrati1.Visible = false; |
48 | ybrati2.Visible = false; |
49 | |
50 | update_task.Visible = false; |
51 | update_employee.Visible = false; |
52 | } |
53 | |
54 | |
55 | } |
56 | private void Menu_men_Closing(object sender, FormClosingEventArgs e) |
57 | { |
58 | Application.Exit(); |
59 | } |
60 | |
61 | //task |
62 | |
63 | public void R_update_tasks() |
64 | { |
65 | listView1.Items.Clear();//очишаем таблицу |
66 | |
67 | |
68 | SqlDataReader sqlRead = null;//перемеена для хранение вывода запроса |
69 | |
70 | SqlCommand comend = new SqlCommand();//перемеена для хранение запроса |
71 | |
72 | |
73 | |
74 | string comond = "SELECT " + |
75 | "[tasks].[id] AS id_ta," + |
76 | " [industry], " + |
77 | "[tasks].[name] AS na_ta," + |
78 | " [brigade].[name] AS na_br " + |
79 | "FROM [tasks], [brigade]" + |
80 | " WHERE [tasks].[brigade] = [brigade].[id] "; |
81 | |
82 | if (!dostoop) |
83 | comond += "AND [tasks].[brigade] = @brigade"; |
84 | |
85 | comend = new SqlCommand(comond, sqlConn); |
86 | |
87 | if (!dostoop) |
88 | comend.Parameters.AddWithValue("@brigade", brigade); |
89 | |
90 | |
91 | if (sqlRead != null) |
92 | sqlRead.Close();//проверка на откратасть |
93 | |
94 | try |
95 | { |
96 | sqlRead = comend.ExecuteReader();//создаем запрос |
97 | |
98 | |
99 | while (sqlRead.Read()) |
100 | { |
101 | listView1.Items.Add |
102 | (new ListViewItem(new string[] |
103 | { |
104 | Convert.ToString(sqlRead["id_ta"]), |
105 | Convert.ToString(sqlRead["industry"]), |
106 | Convert.ToString(sqlRead["na_ta"]), |
107 | Convert.ToString(sqlRead["na_br"]) |
108 | |
109 | })//водим результат в таблицу |
110 | ); |
111 | |
112 | } |
113 | |
114 | if (sqlRead != null) |
115 | sqlRead.Close();//проверка на откратасть |
116 | } |
117 | catch (Exception ex)//обработка исключений |
118 | { |
119 | MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); |
120 | } |
121 | finally |
122 | { |
123 | if (sqlRead != null) |
124 | sqlRead.Close();//проверка на откратасть |
125 | |
126 | } |
127 | } |
128 | |
129 | private void listView1_SelectedIndexChanged(object sender, EventArgs e) |
130 | { |
131 | CheckBtnActivity1(); |
132 | } |
133 | |
134 | private void CheckBtnActivity1() |
135 | { |
136 | ybrati1.Enabled = listView1.SelectedItems.Count > 0; |
137 | update_task.Enabled = listView1.SelectedItems.Count > 0; |
138 | view_task.Enabled = listView1.SelectedItems.Count > 0; |
139 | |
140 | } |
141 | |
142 | private void ybrati1_Click(object sender, EventArgs e) |
143 | { |
144 | SqlCommand comend = new SqlCommand("DELETE FROM [tasks] " + |
145 | "WHERE [id] = @id", sqlConn);//перемеена для хранение запроса |
146 | |
147 | comend.Parameters.AddWithValue("@id", listView1.SelectedItems[0].SubItems[0].Text); |
148 | try |
149 | { |
150 | SqlDataReader sqlDataReader = comend.ExecuteReader();//создаем запросif (sqlDataReader != null) |
151 | sqlDataReader.Close();//проверка на откратасть |
152 | R_update_tasks(); |
153 | |
154 | } |
155 | catch (Exception ex)//обработка исключений |
156 | { |
157 | MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); |
158 | } |
159 | } |
160 | |
161 | private void add_task_Click(object sender, EventArgs e) |
162 | { |
163 | Form_add_tasks f = new Form_add_tasks(sqlConn); |
164 | |
165 | f.Show(); |
166 | |
167 | |
168 | } |
169 | |
170 | private void view_task_Click(object sender, EventArgs e) |
171 | { |
172 | Form_view_tasks f = new Form_view_tasks(sqlConn, |
173 | listView1.SelectedItems[0].SubItems[3].Text); |
174 | |
175 | f.Show(); |
176 | } |
177 | |
178 | private void update_task_Click(object sender, EventArgs e) |
179 | { |
180 | Form_update_task f = new Form_update_task(sqlConn, |
181 | listView1.SelectedItems[0].SubItems[3].Text); |
182 | |
183 | f.Show(); |
184 | } |
185 | |
186 | |
187 | //employee |
188 | |
189 | public void R_update_employee() |
190 | { |
191 | listView2.Items.Clear();//очишаем таблицу |
192 | byte[] data = new byte[1000000000]; |
193 | |
194 | |
195 | SqlDataReader sqlRead = null;//перемеена для хранение вывода запроса |
196 | |
197 | SqlCommand comend = new SqlCommand();//перемеена для хранение запроса |
198 | |
199 | string comond = "SELECT [surname], [employee].[name] AS name_em, [patronymic], [specialty], [employee].[id] AS id_em, [brigade].[name] AS name_br, [vin], [image]" + |
200 | "FROM [employee], [brigade]" + |
201 | "WHERE [employee].[brigade] = [brigade].[id]"; |
202 | |
203 | if (!dostoop) |
204 | comond += "AND [employee].[brigade] = @brigade"; |
205 | |
206 | |
207 | comend = new SqlCommand(comond, sqlConn); |
208 | |
209 | if (!dostoop) |
210 | comend.Parameters.AddWithValue("@brigade", brigade); |
211 | |
212 | if (sqlRead != null) |
213 | sqlRead.Close();//проверка на откратасть |
214 | string str = ""; |
215 | try |
216 | { |
217 | sqlRead = comend.ExecuteReader();//создаем запрос |
218 | |
219 | |
220 | int c = 0; |
221 | ImageList ImageList1 = new ImageList(); |
222 | ImageList1.ImageSize = new Size(50, 50); |
223 | |
224 | List |
225 | |
226 | while (sqlRead.Read()) |
227 | { |
228 | |
229 | ListViewItem1.Add(new ListViewItem(new string[] |
230 | { |
231 | "", |
232 | Convert.ToString(sqlRead["surname"]), |
233 | Convert.ToString(sqlRead["name_em"]), |
234 | Convert.ToString(sqlRead["patronymic"]), |
235 | Convert.ToString(sqlRead["specialty"]), |
236 | Convert.ToString(sqlRead["id_em"]), |
237 | Convert.ToString(sqlRead["name_br"]), |
238 | Convert.ToString(sqlRead["vin"]) |
239 | })); |
240 | |
241 | try |
242 | { |
243 | // ImageList1.Images.Add |
244 | // (new Bitmap( |
245 | // Image.FromFile(Convert.ToString(sqlRead["photo"])))); |
246 | |
247 | data = (byte[])sqlRead["image"]; |
248 | System.IO.MemoryStream ms = new System.IO.MemoryStream(data); |
249 | Image img = System.Drawing.Image.FromStream(ms); |
250 | ImageList1.Images.Add(new Bitmap(img, new Size(100, 100))); |
251 | c++; |
252 | } |
253 | catch (Exception ex)//обработка исключений |
254 | { |
255 | ImageList1.Images.Add |
256 | (new Bitmap(50, 50)); |
257 | |
258 | c++; |
259 | } |
260 | } |
261 | |
262 | listView2.SmallImageList = ImageList1; |
263 | |
264 | for (int i = 0; i < c; i++) |
265 | { |
266 | ListViewItem1[i].ImageIndex = i; |
267 | |
268 | listView2.Items.Add(ListViewItem1[i]); |
269 | } |
270 | if (sqlRead != null) |
271 | sqlRead.Close();//проверка на откратасть |
272 | } |
273 | catch (Exception ex)//обработка исключений |
274 | { |
275 | MessageBox.Show(ex.Message.ToString(), ex.Source.ToString() + str, MessageBoxButtons.OK, MessageBoxIcon.Error); |
276 | } |
277 | finally |
278 | { |
279 | if (sqlRead != null) |
280 | sqlRead.Close();//проверка на откратасть |
281 | |
282 | } |
283 | } |
284 | |
285 | private void listView2_SelectedIndexChanged(object sender, EventArgs e) |
286 | { |
287 | CheckBtnActivity2(); |
288 | } |
289 | |
290 | private void CheckBtnActivity2() |
291 | { |
292 | ybrati2.Enabled = listView2.SelectedItems.Count > 0; |
293 | update_employee.Enabled = listView2.SelectedItems.Count > 0; |
294 | view_employee.Enabled = listView2.SelectedItems.Count > 0; |
295 | } |
296 | |
297 | private void ybrati2_Click(object sender, EventArgs e) |
298 | { |
299 | SqlCommand comend = new SqlCommand("DELETE FROM [employee] " + |
300 | "WHERE [id] = @id", sqlConn);//перемеена для хранение запроса |
301 | |
302 | comend.Parameters.AddWithValue("@id", listView2.SelectedItems[0].SubItems[5].Text); |
303 | try |
304 | { |
305 | SqlDataReader sqlDataReader = comend.ExecuteReader();//создаем запросif (sqlDataReader != null) |
306 | sqlDataReader.Close();//проверка на откратасть |
307 | R_update_employee(); |
308 | } |
309 | catch (Exception ex)//обработка исключений |
310 | { |
311 | MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); |
312 | } |
313 | |
314 | } |
315 | |
316 | private void add_employee_Click(object sender, EventArgs e) |
317 | { |
318 | Form_add_employee f = new Form_add_employee(sqlConn); |
319 | |
320 | f.Show(); |
321 | } |
322 | |
323 | private void view_employee_Click(object sender, EventArgs e) |
324 | { |
325 | Form_view_employee f = new Form_view_employee(sqlConn, |
326 | listView2.SelectedItems[0].SubItems[5].Text); |
327 | |
328 | f.Show(); |
329 | } |
330 | |
331 | private void update_employee_Click(object sender, EventArgs e) |
332 | { |
333 | Form_update_employee f = new Form_update_employee(sqlConn, |
334 | listView2.SelectedItems[0].SubItems[5].Text); |
335 | |
336 | f.Show(); |
337 | } |
338 | |
339 | |
340 | //menuStrip |
341 | private void обновитьToolStripMenuItem_Click(object sender, EventArgs e) |
342 | { |
343 | R_update_tasks(); |
344 | R_update_employee(); |
345 | } |
346 | |
347 | private void инфVINToolStripMenuItem_Click(object sender, EventArgs e)//вывод собщения о годе |
348 | { |
349 | MessageBox.Show(VIN.rdrev.GET_year(listView2.SelectedItems[0].SubItems[7].Text, sqlConn),//текст из функции dll |
350 | "year",//заголовок |
351 | MessageBoxButtons.OK, |
352 | MessageBoxIcon.Question);//тип поля |
353 | } |
354 | |
355 | private void инфЗаводVINToolStripMenuItem_Click(object sender, EventArgs e)//вывод собщения о заводе |
356 | { |
357 | MessageBox.Show(VIN.rdrev.GET_factory(listView2.SelectedItems[0].SubItems[7].Text, sqlConn),//текст из функции dll |
358 | "factory",//заголовок |
359 | MessageBoxButtons.OK, |
360 | MessageBoxIcon.Question);//тип поля |
361 | } |
362 | } |
363 | } |
Код окна изменения данных пользователя
1 | using System; |
2 | using System.IO; |
3 | using System.Collections.Generic; |
4 | using System.ComponentModel; |
5 | using System.Data; |
6 | using System.Data.SqlClient; |
7 | using System.Drawing; |
8 | using System.Linq; |
9 | using System.Text; |
10 | using System.Threading.Tasks; |
11 | using System.Windows.Forms; |
12 | |
13 | namespace testWork |
14 | { |
15 | public partial class Form_update_employee : Form |
16 | { |
17 | SqlConnection sqlConn; |
18 | string FileName = "", |
19 | id = ""; |
20 | byte[] imageData; |
21 | |
22 | public Form_update_employee(SqlConnection sqlConn, string id) |
23 | { |
24 | InitializeComponent(); |
25 | |
26 | this.sqlConn = sqlConn; |
27 | this.id = id; |
28 | } |
29 | |
30 | private void Form_update_employee_Load(object sender, EventArgs e) |
31 | { |
32 | SqlDataReader sqlRead = null;//перемеена для хранение вывода запроса |
33 | |
34 | SqlCommand comend = new SqlCommand();//перемеена для хранение запроса |
35 | |
36 | |
37 | string comond = "SELECT *" + |
38 | "FROM [employee]" + |
39 | "WHERE [id] = @id "; |
40 | comend = new SqlCommand(comond, sqlConn); |
41 | comend.Parameters.AddWithValue("@id", Convert.ToString(id)); |
42 | |
43 | |
44 | |
45 | if (sqlRead != null) |
46 | sqlRead.Close();//проверка на откратасть |
47 | |
48 | try |
49 | { |
50 | sqlRead = comend.ExecuteReader();//создаем запрос |
51 | |
52 | |
53 | while (sqlRead.Read()) |
54 | { |
55 | surname.Text = Convert.ToString(sqlRead["surname"]); |
56 | name.Text = Convert.ToString(sqlRead["name"]); |
57 | patronymic.Text = Convert.ToString(sqlRead["patronymic"]); |
58 | specialty.Text = Convert.ToString(sqlRead["specialty"]); |
59 | login.Text = Convert.ToString(sqlRead["login"]); |
60 | password.Text = Convert.ToString(sqlRead["password"]); |
61 | dostoop.Text = Convert.ToString(sqlRead["dostoop"]); |
62 | |
63 | try |
64 | { |
65 | byte[] data = (byte[])sqlRead["image"]; |
66 | System.IO.MemoryStream ms = new System.IO.MemoryStream(data); |
67 | Image img = System.Drawing.Image.FromStream(ms); |
68 | pictureBox1.Image = new Bitmap(img, new Size(100, 100)); |
69 | } |
70 | catch |
71 | { |
72 | |
73 | } |
74 | } |
75 | } |
76 | catch (Exception ex)//обработка исключений |
77 | { |
78 | MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); |
79 | } |
80 | finally |
81 | { |
82 | if (sqlRead != null) |
83 | sqlRead.Close();//проверка на откратасть |
84 | |
85 | |
86 | } |
87 | } |
88 | |
89 | private void button_photo_Click(object sender, EventArgs e) |
90 | { |
91 | // диалог для выбора файла |
92 | OpenFileDialog ofd = new OpenFileDialog(); |
93 | // фильтр форматов файлов |
94 | ofd.Filter = "Image Files(*.BMP;*.JPG;*.GIF;*.PNG)|*.BMP;*.JPG;*.GIF;*.PNG|All files (*.*)|*.*"; |
95 | // если в диалоге была нажата кнопка ОК |
96 | if (ofd.ShowDialog() == DialogResult.OK) |
97 | { |
98 | try |
99 | { |
100 | // загружаем изображение |
101 | |
102 | using (System.IO.FileStream fs = new System.IO.FileStream(ofd.FileName, FileMode.Open)) |
103 | { |
104 | imageData = new byte[fs.Length]; |
105 | fs.Read(imageData, 0, imageData.Length); |
106 | } |
107 | System.IO.MemoryStream ms = new System.IO.MemoryStream(imageData); |
108 | Image img = System.Drawing.Image.FromStream(ms); |
109 | pictureBox1.Image = img; |
110 | FileName = ofd.FileName; |
111 | |
112 | } |
113 | catch // в случае ошибки выводим MessageBox |
114 | { |
115 | MessageBox.Show("Невозможно открыть выбранный файл", "Ошибка", |
116 | MessageBoxButtons.OK, MessageBoxIcon.Error); |
117 | } |
118 | } |
119 | } |
120 | |
121 | private void add_Click(object sender, EventArgs e) |
122 | { |
123 | SqlCommand comend = new SqlCommand("UPDATE [employee] " + |
124 | "SET name = @name, surname = @surname, patronymic = @patronymic, specialty = @specialty, login = @login, password = @password, dostoop = @dostoop, image = @image " + |
125 | "WHERE id = @id; ", sqlConn);//перемеена для хранение запроса |
126 | comend.Parameters.AddWithValue("@id", id); |
127 | comend.Parameters.AddWithValue("@name", name.Text); |
128 | comend.Parameters.AddWithValue("@surname", surname.Text); |
129 | comend.Parameters.AddWithValue("@patronymic", patronymic.Text); |
130 | comend.Parameters.AddWithValue("@specialty", specialty.Text); |
131 | comend.Parameters.AddWithValue("@login", login.Text); |
132 | comend.Parameters.AddWithValue("@password", password.Text); |
133 | comend.Parameters.AddWithValue("@dostoop", Convert.ToInt32(dostoop.Text)); |
134 | comend.Parameters.AddWithValue("@image", (byte[])imageData); |
135 | |
136 | |
137 | |
138 | try |
139 | { |
140 | SqlDataReader sqlRead = comend.ExecuteReader();//создаем запрос |
141 | sqlRead.Close(); |
142 | |
143 | } |
144 | catch (Exception ex)//обработка исключений |
145 | { |
146 | MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); |
147 | } |
148 | |
149 | |
150 | this.Hide(); |
151 | } |
152 | } |
153 | } |