1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
| private void InitializeDataGridView()
{
// Create an unbound DataGridView by declaring a column count.
dataGridView1.ColumnCount = 11;
dataGridView1.ColumnHeadersVisible = true;
// Set the column header style.
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.White;
columnHeaderStyle.Font = new Font("Verdana", 8, FontStyle.Bold);
dataGridView1.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
// Set the column header names.
dataGridView1.Columns[0].Name = "OF";
dataGridView1.Columns[1].Name = "OFG";
dataGridView1.Columns[2].Name = "Département";
dataGridView1.Columns[3].Name = "Article";
dataGridView1.Columns[4].Name = "Désignation";
dataGridView1.Columns[5].Name = "Machine";
dataGridView1.Columns[6].Name = "Moule";
dataGridView1.Columns[7].Name = "Empreinte(s)";
dataGridView1.Columns[8].Name = "Date début";
dataGridView1.Columns[10].Name = "Engagement (h)";
DataGridViewComboBoxColumn equipe = new DataGridViewComboBoxColumn();
equipe.HeaderText = "Equipe";
equipe.Name = "Equipe";
equipe.MaxDropDownItems = 3;
equipe.Items.Add("M");
equipe.Items.Add("APM");
equipe.Items.Add("N");
dataGridView1.Columns.Add(equipe);
DataGridViewCheckBoxColumn validate = new DataGridViewCheckBoxColumn();
validate.HeaderText = "Validation";
validate.Name = "Validation";
dataGridView1.Columns.Add(validate);
// Populate the rows.
TimeSpan span1 = TimeSpan.FromHours(8);
TimeSpan span2 = TimeSpan.FromHours(16);
TimeSpan span3 = TimeSpan.FromHours(24);
SqlDataReader reader = null;
SqlDataReader reader2 = null;
_SqlConn.SqlConnection.Open();
SqlCommand cmd = new SqlCommand("select OFJ,OFG,Departement,Code_article,Designation_article,machine,moule,Nb_empreintes,Date,engagement,id_of from OrdreFab where CONVERT(date,date) = CONVERT(date, getdate())", _SqlConn.SqlConnection);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader.GetTimeSpan(9) <= span1)
{
equipe_PDC = "M";
dataGridView1.Rows.Add(new object[] { reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), Convert.ToString(reader.GetByte(7)), Convert.ToString(reader.GetDateTime(8)), equipe_PDC, Convert.ToString(reader.GetTimeSpan(9)) });
dataGridView1.Rows[0].Cells[11].Values = equipe_PDC;
}
}
} |
