private void clsAltoButton1_Click(object sender, EventArgs e) { if (dateTimePicker2.Value > dateTimePicker1.Value && this.textBox1.Text.Trim() != "") { dbcontext.ReportTimeSystems.Add( new BusinessSystemDBEntityModel.ReportTimeSystem { ReportName = textBox1.Text, employeeID = ClassEmployee.LoginEmployeeID, StartTime = dateTimePicker1.Value, EndTime = dateTimePicker2.Value, EventHours = dateTimePicker2.Value.Subtract(dateTimePicker1.Value).TotalHours, EventID = FindID(comboBox1.Text), Note = richTextBox1.Text, ApplyDateTime = DateTime.Now, Discontinue = true }); dbcontext.SaveChanges(); MessageBox.Show("新增成功"); var q = from RTS in dbcontext.ReportTimeSystems join emp in dbcontext.Employees on RTS.employeeID equals emp.employeeID join eve in dbcontext.Events on RTS.EventID equals eve.EventID where RTS.Discontinue == true && RTS.employeeID == ClassEmployee.LoginEmployeeID select new { 報表編號 = RTS.ReportID, //員工名稱 = emp.EmployeeName, 活動名稱 = RTS.ReportName, 開始時間 = RTS.StartTime, 結束時間 = RTS.EndTime, 所需總時數 = RTS.EventHours, 活動類型 = eve.EventName, 備註 = RTS.Note, 申請時間 = RTS.ApplyDateTime }; rts.dataGridView1.DataSource = q.ToList(); this.Close(); FormMainRTS form = new FormMainRTS(); form.Refresh(); } else { if (dateTimePicker2.Value <= dateTimePicker1.Value) { errorProvider1.SetError(dateTimePicker2, "結束時間需大於開始時間"); } else { errorProvider1.SetError(this.dateTimePicker2, String.Empty); } if (this.textBox1.Text.Trim() == "") { errorProvider1.SetError(textBox1, "請輸入活動名稱,名稱介於10個字內"); } else { errorProvider1.SetError(this.textBox1, String.Empty); } MessageBox.Show("請更正警示欄位"); } if (rts.dataGridView1.Rows.Count != 0) { for (int i = 0; i < rts.dataGridView1.Rows.Count;) { rts.dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.LightBlue; i += 2; } } }
public FormAdd(FormMainRTS ff) { InitializeComponent(); rts = ff; }